Re: Querying distances between two coordinates
From: BicycleRepairman <engel.kevin_at_gmail.com>
Date: Wed, 15 Jun 2011 05:34:33 -0700 (PDT)
Message-ID: <ef7f413c-b2c9-45ac-a063-8713d0c19526_at_a35g2000vbl.googlegroups.com>
On Jun 15, 3:34 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <e0eb3577-194b-4cf9-8b42-
> 51e8e3f4e..._at_f2g2000yqh.googlegroups.com>, hurleyjo..._at_yahoo.com says...
>
>
>
>
>
>
>
>
>
>
>
> > Jeremy:
>
> > ... I was trying to answer (radius-
> > search) one of my team came up with a solution storing the lat/long
> > in a
> > table column of type "mdsys.sdo_geometry" - I believe this does not
> > require any Oracle options - available in SE.
>
> > Then insert data into the column using a call such as:
>
> > mdsys.sdo_geometry
> > (2001, -- This is the SDO_GTYPE attribute and it is set
> > to
> > -- 2001 when storing a two-dimensional single
> > point
> > -- such as a customer's location.
> > 8307, -- This is the spatial reference system ID
> > -- (SRID), 8307 corresponds to "Longitude /
> > --Latitude (WGS 84)
> > mdsys.sdo_point_type (-0.771618, 51.579601, null),
> > null,
> > null)
>
> > ... Then query using the function "sdo_within_distance"
>
> > JBH notes:
> > ***********
>
> > Sounds to me as if you are using Oracle spatial features and will need
> > to be licensed appropriately.
>
> > Oracle makes it easy to have features/options appear in database
> > instances that you may not have appropriately licensed. Up to the DBA
> > and IT management to carefully know how to install and select ( and
> > deselect ) options that you are not licensed for.
>
> > The Oracle spatial stuff comes in the mdsys schema ... check with
> > Oracle and do your homework but I think if you start using this stuff
> > you better be prepared to pay for it.
>
> Thanks for your comments John.
>
> http://download.oracle.com/docs/html/B10826_01/sdo_locator.htm
>
> This states:
>
> "Oracle Locator (also referred to as Locator) is a feature of Oracle
> Database 10g Standard Edition. Locator provides core features and
> services available in Oracle Spatial. It provides significant
> capabilities typically required to support Internet and wireless
> service-based applications and partner-based GIS solutions. Locator is
> not designed to be a solution for geographic information system (GIS)
> applications requiring complex spatial data management. If you need
> capabilities such as linear referencing, spatial functions, or
> coordinate system transformations, use Oracle Spatial instead of
> Locator."
>
> So it looks as though there is a subset of spatial features which do NOT
> require additional licensing.
>
> --
> jeremy
Date: Wed, 15 Jun 2011 05:34:33 -0700 (PDT)
Message-ID: <ef7f413c-b2c9-45ac-a063-8713d0c19526_at_a35g2000vbl.googlegroups.com>
On Jun 15, 3:34 am, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <e0eb3577-194b-4cf9-8b42-
> 51e8e3f4e..._at_f2g2000yqh.googlegroups.com>, hurleyjo..._at_yahoo.com says...
>
>
>
>
>
>
>
>
>
>
>
> > Jeremy:
>
> > ... I was trying to answer (radius-
> > search) one of my team came up with a solution storing the lat/long
> > in a
> > table column of type "mdsys.sdo_geometry" - I believe this does not
> > require any Oracle options - available in SE.
>
> > Then insert data into the column using a call such as:
>
> > mdsys.sdo_geometry
> > (2001, -- This is the SDO_GTYPE attribute and it is set
> > to
> > -- 2001 when storing a two-dimensional single
> > point
> > -- such as a customer's location.
> > 8307, -- This is the spatial reference system ID
> > -- (SRID), 8307 corresponds to "Longitude /
> > --Latitude (WGS 84)
> > mdsys.sdo_point_type (-0.771618, 51.579601, null),
> > null,
> > null)
>
> > ... Then query using the function "sdo_within_distance"
>
> > JBH notes:
> > ***********
>
> > Sounds to me as if you are using Oracle spatial features and will need
> > to be licensed appropriately.
>
> > Oracle makes it easy to have features/options appear in database
> > instances that you may not have appropriately licensed. Up to the DBA
> > and IT management to carefully know how to install and select ( and
> > deselect ) options that you are not licensed for.
>
> > The Oracle spatial stuff comes in the mdsys schema ... check with
> > Oracle and do your homework but I think if you start using this stuff
> > you better be prepared to pay for it.
>
> Thanks for your comments John.
>
> http://download.oracle.com/docs/html/B10826_01/sdo_locator.htm
>
> This states:
>
> "Oracle Locator (also referred to as Locator) is a feature of Oracle
> Database 10g Standard Edition. Locator provides core features and
> services available in Oracle Spatial. It provides significant
> capabilities typically required to support Internet and wireless
> service-based applications and partner-based GIS solutions. Locator is
> not designed to be a solution for geographic information system (GIS)
> applications requiring complex spatial data management. If you need
> capabilities such as linear referencing, spatial functions, or
> coordinate system transformations, use Oracle Spatial instead of
> Locator."
>
> So it looks as though there is a subset of spatial features which do NOT
> require additional licensing.
>
> --
> jeremy
That's correct; the locator subset of Spatial was something they added
in 10gR2, if I recall correctly.
For some reason, they didn't shout from the highest mountaintops that
you didn't have to buy Spatial (or EE for that matter) for a lot of
common use cases.
Received on Wed Jun 15 2011 - 07:34:33 CDT