[mapguide-users] Oracle Spatial v/s Oracle Locator with MapGuide FDO

[Simon Greener]

Others have answered this as well but all versions of Oracle support the  
RTree indexing.
The common spatial functions (ie SDO_ANYINTERACT etc in a SELECT WHERE  
clause) require
the indexing whereas the Operators (ie SDO_GEOM.SDO_INTERSECTION,  
SDO_GEOM.SDO_UNION etc)
are only shipped with EE.

I, like many others on this list, use EE and have also worked with XE and  
XE (and therefore SE)
definitely supports:

Create Index my_index on My_Table(Geom_Column) indextype is  
mdsys.spatial_index parameters('sdo_indx_dims=2');

Because if it didn't

SELECT m.id
   FROM my_index m
  WHERE  
SDO_ANYINTERACT(m.geom_column,Sdo_GEometry(2003,NULL,NULL,SDO_ELEM_INFO_ARRAY(1,1003,3),Sdo_Ordinate_Array(0,0,100,100))  
= 'TRUE';

would return:

ORA-13226: interface not supported without a spatial index

regards
S
On Thu, 31 Aug 2006 17:21:49 +0100, Francisco Javier Rojas Duran  
<francisco.rojas at dasoft.com.mx> wrote:

> Andy:
>
> The information that I gave you was taken from Oracle Spatial 10g
> Fundamentals training course, the common feature for both Locator and
> Spatial is the use of Spatial Functions (not Operators).
>
> The Spatial Indexing is not supported for Locator.
>
> Regards
>
> CSE. Francisco Javier Rojas Durán
> IT Manager - Oracle Specialist
> Division de Tecnologias de Información
> Grupo DaSoft S.A. de C.V.
>
> -----Mensaje original-----
> De: Andy Morsell [mailto:amorsell at spatialgis.com]
> Enviado el: Jueves, 31 de Agosto de 2006 11:10 a.m.
> Para: 'Francisco Javier Rojas Duran'
> Asunto: RE: [mapguide-users] Oracle Spatial v/s Oracle Locator with  
> MapGuide
> FDO
>
> I think that both Locator and Spatial support the same R-Tree indexing so
> the speed of Locator should be comparable to Spatial.
>
>
> Andy
>
> -----Original Message-----
> From: Francisco Javier Rojas Duran [mailto:francisco.rojas at dasoft.com.mx]
> Sent: Thursday, August 31, 2006 8:43 AM
> To: users at mapguide.osgeo.org
> Cc: 'Andy Morsell'
> Subject: Re: [mapguide-users] Oracle Spatial v/s Oracle Locator with
> MapGuide FDO
>
> Hi:
>
> The Main difference between Locator which comes with Oracle XE, SE, and  
> EE
> for free and Spatial (available only as Oracle Enterprise Option) is the  
> use
> of Oracle Spatial Indexes and also related to that the capability of  
> using
> Spatial Operators, of course the Spatial Operators and Spatial Index  
> makes
> Oracle Spatial faster than Locator.
>
> Finally the type of geometry that Spatial can store is more complex and  
> it
> is a bigger set than Locator one.
>
> Regards
>
> CSE. Francisco Javier Rojas Durán
> IT Manager - Oracle Specialist
> Division de Tecnologias de Información
> Grupo DaSoft S.A. de C.V.
>
> -----Mensaje original-----
> De: Andy Morsell [mailto:amorsell at spatialgis.com] Enviado el: Jueves, 31  
> de
> Agosto de 2006 09:59 a.m.
> Para: users at mapguide.osgeo.org
> Asunto: RE: SPAM-LOW: Re: [mapguide-users] Oracle Spatial v/s Oracle  
> Locator
> with MapGuide FDO
>
> That is great news about SL-King writing a native Oracle provider.  I  
> can't
> wait to see it.  I have found that trying to use the Autodesk Oracle FDO
> provider with non-Autodesk created Oracle Spatial data can be an  
> exercise in
> frustration.
>
>
> Andy
>
> -----Original Message-----
> From: Simon Greener [mailto:sgreener at netspace.net.au]
> Sent: Wednesday, August 30, 2006 11:58 PM
> To: users at mapguide.osgeo.org
> Subject: SPAM-LOW: Re: [mapguide-users] Oracle Spatial v/s Oracle Locator
> with MapGuide FDO
>
> Paul is right, PostGIS is neither crippled or slow and his news that a
> native FDO provider is just around the corner is great news for everyone.
>
> On the Oracle front, Locator is all you need for use with MapGuide. Haris
> Kurtagic an AutoDesk Partner in Bosnia is writing a native Oracle  
> provider
> that does not require the F_* Autodesk catalog tables (which the AutoDesk
> provider shipped with their per pay version requires and which can only  
> be
> created via AutoDesk client side tools - part of the reason, I suspect,  
> why
> they are not shipped with the open source
> version) as I write. I have seen Haris's work on integrating Autodesk  
> Map 3D
> and Oracle's Topology (an Enterprise Edition feature) was excellent so I
> suspect his native FDO provider will be good. He is not sure about how to
> market it.
> I have suggested that he make it open source and he is thinking about it:
> I think that
> there is more money in providing solutions to customers than writing
> drivers!
>
> If you need more "in database" functionality with Oracle Locator then as
> long as you are not using XE you can drop Java functions based on JTS  
> into
> the database and call them  from PL/SQL. But that is quite a bit of
> engineering when it is all there in PostreSQL/PostGIS.
>
> regards
> S
> On Thu, 31 Aug 2006 03:48:16 +0100, Paul Ramsey <pramsey at refractions.net>
> wrote:
>
>> If you wait a few months, you'll be able to use MapGuide OS with
>> PostGIS, which unlike Locator is neither hobbled nor slow.  The City
>> of Nanaimo has contracted us to build a PostGIS FDO provider. The work
>> is ongoing as I type. We anticipate delivery in the early fall.
>>
>> Paul
>>
>> On 30-Aug-06, at 7:33 PM, Srikanth Nadhamuni wrote:
>>
>>> Folks,
>>>
>>>
>>>
>>> We are trying to decide which database to use to store our spatial as
>>> well as attribute data in conjunction with MapGuide server. We found
>>> that Oracle 10g comes bundled with 'Oracle Locator' which seems to be
>>> a stripped down version of 'Oracle Spatial' which is a priced add-on
>>> to Oracle 10g. A comparison between Oracle Locator and Oracle Spatial
>>> follows from a blog posting.
>>>
>>>
>>>
>>> Can we simply use Oracle 10g with Locator (the bundled product) to
>>> store both spatial and attribute information and connect through
>>> MapGuide's Oracle FDO ? or do we need to buy Oracle Spatial to do the
>>> same.
>>>
>>>
>>>
>>> Thanks in advance,
>>>
>>>
>>>
>>> -Srikanth Nadhamuni
>>>
>>>
>>>
>>> Comparison of the Oracle Spatial and Locator Features
>>>
>>> Bloged in General, Oracle, MapViewer / GIS by Topper Thursday May 11,
>>> 2006
>>>
>>> This is a quick analysis I wrote up for a customer, but I figured
>>> other people would get a benefit out of it as well.
>>>
>>> The Oracle database engine has an extremely robust feature set that
>>> allows for the analyis of GIS data within the database. Within the
>>> Oracle suite there are two products to perform spatial analysis in
>>> the database. One is called Oracle Locator, while the other is called
>>> Oracle Spatial. Oracle Locator allows for basic GIS analysis. While
>>> Oracle Spatial will allow for more advanced analysis, including
>>> creating new spatial data and transforming data that already exists.
>>> Currently, Oracle Locator is a free component of every database that
>>> Oracle sells; this includes OracleXE, Oracle Standard Edition and
>>> Oracle Enterprise Edition. Below you will find a list of all the
>>> features you can perform with each product and some examples of what
>>> can be done with that feature.
>>>
>>> Oracle Locator
>>>
>>> Functionality
>>>
>>> Feature Name
>>>
>>> Example Use
>>>
>>> Support for All Spatial Geometry
>>>
>>> Points, Point Clusters, Lines, Line Strings, Compound Line Strings,
>>> Polygons, Polygons with Holes, Compound Polygons, Arc Strings,
>>> Circles, Rectangles
>>>
>>> All the counties in the United States Locations of all corporate
>>> sites Locations of all customers All of the roads in the United
>>> States
>>>
>>> Spatial Indexing
>>>
>>>
>>>
>>> R-Tree indexing to speed up query performance - selecting only the
>>> data needed, not an entire layer
>>>
>>> Spatial Operators
>>>
>>> SDO_FILTER
>>>
>>> SDO_RELATE
>>>
>>> SDO_NN
>>>
>>> SDO_NN_DISTANCE
>>>
>>> SDO_WITHIN_DISTANCE
>>>
>>> SDO_GEOM.SDO_DISTANCE
>>>
>>> The closest 100 customers to a site
>>> All customers that live in a particular building All of the stores in
>>> the shopping mall All of the Elvis impersonators inNashville
>>>
>>> Two Tiered Queries
>>>
>>>
>>>
>>> Filter the data, first on the geometry elements that satisfy the
>>> condition, and then based on the relational facts (i.e. first find
>>> all customers within 5 miles, then find the ones that have spent more
>>> than $5,000 this year)
>>>
>>> Open Standards
>>>
>>>
>>>
>>> Certified with the Open Geospatial Consortium and OpenGIS standards
>>> Move away from PostGIS to Oracle Produce a standardized mapping
>>> service for customers
>>>
>>> Long Transaction / Workspace Management
>>>
>>>
>>>
>>> Create new "What If?" scenarios
>>> What if this location moves 5 miles west?
>>> What if this location is sold? Where will customers go?
>>> What if I combine the Northeast and mid-Atlantic regions?
>>> Load new datasets without affecting production queries and switch
>>> over seamlessly
>>>
>>>
>>>
>>>
>>> Oracle Spatial
>>>
>>>
>>>
>>> Functionality
>>>
>>> Feature Name
>>>
>>> Example Use
>>>
>>> Length and area based calculations
>>>
>>> Length / Area
>>>
>>> What is the average size of site locations?
>>> How long is a segment of road?
>>> How much area is covered by each sales representative?
>>>
>>> Generation of new geometries
>>>
>>> Buffer, Centroid, Convex Hull
>>>
>>> Geometry Intersection, GeometryUnion
>>>
>>> Creating regions from current properties Creating 5 mile boundaries
>>> around each site to ensure market share
>>>
>>> Spatial Analytic Functions
>>>
>>>
>>>
>>> Determining what percentage of customers are within 5 miles of
>>> locations Determine the most effective place to put a new site, based
>>> on current customer data
>>>
>>> Identify which communities are growing and where to acquire new land
>>> for opportunities
>>>
>>> Find the highest income areas to launch for new executive line of
>>> products How far is the competition from the current customer base?
>>>
>>> Coordinate system transformations
>>>
>>> SDO_CS.TRANFORM
>>>
>>> SDO_CS.TRANSFORM_LAYER
>>>
>>> Translate data from localized projections to a national projection
>>> Convert Universal Transverse Mercator data into longitude and
>>> latitude points
>>>
>>> Raster image support
>>>
>>>
>>>
>>> Include aerial images with the application to assist in problem
>>> analysis Why do people drive 20 miles to this store when there is one
>>> 10 miles away? Because there is a mountain in the way View how land
>>> has changed over a period of time and determine where people are
>>> moving
>>>
>>> Network datamodels
>>>
>>>
>>>
>>> Can I make a left hand turn at this intersection?
>>> Where are the gas lines on this property?
>>>
>>> Geocoding
>>>
>>>
>>>
>>> Standardize addresses based on postal information Correct addresses
>>> with common misspellings or alternative street names I have a GPS
>>> location, who owns the property there?
>>>
>>> Routing
>>>
>>>
>>>
>>> How do I get to the nearest gas station from my current position?
>>> How long will it take me to get there?
>>> The street is under construction, what other alternatives do I have?
>>> Should I take the bus, a cab or the metro from the airport? How long
>>> is it going to take me and what does it cost?
>>>
>>> Like this article? Digg it!
>>>
>>> Share and Enjoy:These icons link to social bookmarking sites where
>>> readers can share and discover new web pages.
>>>
>>> <image001.gif>
>>> <image002.gif>
>>> <image003.gif>
>>> <image004.jpg>
>>> <image005.gif>
>>> <image006.jpg>
>>> <image007.gif>
>>> <image008.jpg>
>>> <image009.jpg>
>>> <image010.jpg>
>>> <image011.gif>
>>> <image012.gif>
>>> <image013.jpg>
>>> Trackback .
>>>
>>> Related Posts:
>>>
>>> .  Google Maps and GTOs
>>>
>>> .  Back to Civilization
>>>
>>> .  ODTUG Day 1
>>>
>>> .  Oracle Spatial and GEOCODER.us "Free" Geocoding Service
>>>
>>> .  Adding a new disk to a VMWare Virtual Machine in Linux
>>>
>>> 3 Responses to "Comparison of the Oracle Spatial and Locator Features"
>>>
>>> Justin Lokitz Says:
>>> June 6th, 2006 at 9:37 am
>>> Nice work Matt! A couple more to add to the Spatial list: Linear
>>> Referencing (LRS) and Topology Data Model.
>>>
>>> Linear Referencing is a model where "measurement" information
>>> associated with a linear geometry is stored with the geometries
>>> themselves. This allows many attributes or events to be associated
>>> with a specified segment on a linear geometry. Attributes or events
>>> are stored in tables separately from the geometry, and the geometry
>>> does not have to be duplicated in the attribute tables. Linear
>>> referencing is often used by departments of transportation, to model
>>> roads or railroads and their attributes; utilities, to model oil or
>>> gas pipes and their attributes; and telecommunications providers. A
>>> good example of this might be, "return all of the road segments that
>>> have poor pavement" or "a vehicle has gone off the highway at some
>>> longitude/latitude; what's the mile post there so ambulances can
>>> reach it easily?" etc.
>>>
>>> Topology Data Modeling is used when there is a high degree of feature
>>> editing and a strong requirement for data integrity across maps and
>>> map layers. An example of where this is used a lot is in land
>>> management where one has to account for land parcels, water features,
>>> road features, utilities and other features. Because in the end all
>>> of these features are somehow related and may even border one
>>> another, problems topology modeling solves are things like "what
>>> happens to a land parcel or sidewalk when a road is widened?" etc.
>>>
>>> Justin Lokitz Says:
>>> June 6th, 2006 at 9:40 am
>>> Also.one more thing Matt: in Oracle10gR2, Locator supports implicit
>>> and explicit coordinate system transformation (just like Spatial).
>>>
>>> Topper Says:
>>> June 6th, 2006 at 9:41 am
>>> Thanks Justin, I also need to add the Oracle Mapviewer and Oracle
>>> Maps content to the list too. Maybe another post soon.
>>>
>>> Leave a Reply
>>>
>>>
>>>  Name (required)
>>>
>>>  Mail (will not be published) (required)
>>>
>>>  Website
>>>
>>>
>>>
>>>
>>>
>>> <image014.jpg>
>>> Matt Topper
>>> Email: matt at matttopper.com
>>> Phone: 586.855.4595
>>> Currently Working For:These Guys
>>>
>>> August 2006
>>>
>>> S
>>>
>>> M
>>>
>>> T
>>>
>>> W
>>>
>>> T
>>>
>>> F
>>>
>>> S
>>>
>>> < Jul
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> 1
>>>
>>> 2
>>>
>>> 3
>>>
>>> 4
>>>
>>> 5
>>>
>>> 6
>>>
>>> 7
>>>
>>> 8
>>>
>>> 9
>>>
>>> 10
>>>
>>> 11
>>>
>>> 12
>>>
>>> 13
>>>
>>> 14
>>>
>>> 15
>>>
>>> 16
>>>
>>> 17
>>>
>>> 18
>>>
>>> 19
>>>
>>> 20
>>>
>>> 21
>>>
>>> 22
>>>
>>> 23
>>>
>>> 24
>>>
>>> 25
>>>
>>> 26
>>>
>>> 27
>>>
>>> 28
>>>
>>> 29
>>>
>>> 30
>>>
>>> 31
>>>
>>>
>>>
>>> Categories
>>>
>>> General
>>> Discoverer
>>> Jet Skiing
>>> Oracle
>>> MapViewer / GIS
>>> Portal
>>> Music
>>> Technology
>>> VMWare
>>> Links
>>>
>>>
>>> Search
>>>
>>>
>>>
>>>
>>> .         Archives:
>>>
>>> July 2006
>>> June 2006
>>> May 2006
>>> April 2006
>>> November 2005
>>> October 2005
>>> September 2005
>>> August 2005
>>> June 2005
>>> January 2005
>>> December 2004
>>> .         Pages
>>>
>>> About Me
>>> Examples
>>> Links
>>> Resume
>>> Meta:
>>>
>>> Login
>>> RSS
>>> Comments RSS
>>> Valid XHTML
>>> WP
>>> 37 queries. 1.129 seconds.
>>> Powered by Wordpress
>>> theme by evil.bert
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> <image015.gif>
>>>
>>> Technology for Social Change
>>>
>>> Srikanth Nadhamuni
>>> Managing Trustee
>>> www.egovernments.org
>>>
>>> eGovernments Foundation
>>> 303 Ashok Terrace, 2nd Floor, 100 ft Road, Indiranagar Bangalore 560
>>> 038
>>>
>>>
>>>
>>>
>>>
>>>
>>
>
>
>
> --
> SpatialDB Advice, Solutions Architect, Manifold Enthusiast, Oracle  
> Spatial
> Specialist.
> Allens Rivulet, Tasmania, Australia.
> Voice: +61 3 62396397
> Longitude: 147.2048
> Latitude: -43.0141
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>



-- 
SpatialDB Advice, Solutions Architect, Manifold Enthusiast, Oracle Spatial  
Specialist.
Allens Rivulet, Tasmania, Australia.
Voice: +61 3 62396397
Longitude: 147.2048
Latitude: -43.0141