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

Andy Morsell amorsell at spatialgis.com
Thu Aug 31 12:28:22 EDT 2006


I'm not intending to argue, but I still don't think that is correct about
indexing.  It looks like Locator supports the same indexing.  If it didn't,
it would be extremely slow.

http://www.geometryit.com/tip/oracleSpatialLocator.php
http://www.oracle.com/technology/products/spatial/pdf/10gr2_collateral/locat
or_spatial_ds_10gR2.pdf 


Andy 

-----Original Message-----
From: Francisco Javier Rojas Duran [mailto:francisco.rojas at dasoft.com.mx] 
Sent: Thursday, August 31, 2006 9:22 AM
To: 'Andy Morsell'
Cc: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] Oracle Spatial v/s Oracle Locator with
MapGuide FDO
Importance: High

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















More information about the Mapguide-users mailing list