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

[Simon Greener]

Joel,

The EXISTING Oracle provider that ships with MapGuide Enterprise (if you
download a trial copy from the Autodesk website) requires these F_* tables.

I know this because I have been orchestrating a trial of FDO at Laser-Scan
in the UK in which the main data stores for product testing are in Oracle  
Spatial.
Also, Laser-Scan, as an Autodesk partner, has access to Autodesk products.  
We
had to use a tool that ships with Autodesk Map 3D to construct the  
appropriate
metadata tables after we discovered we too could not access native Oracle  
Spatial
data using the FDO provider that ships with the per-pay version of  
MapGuide Enterprise
unless we had created and populated these tables.

Autodesk's Geoff Zeiss pointed me at Haris's work and I have been in  
communication
with Haris about trialling his native Oracle Spatial FDO provider.

None of this should be construed as a criticism of Autodesk's Oracle  
provider.
They said it was not available for proprietary reasons and they are  
correct in this.

Until Haris's work is available the open source community only have the  
OGR provider
to access Oracle Spatial. Unless, of course, those who wrote the OGR OS  
interface
decide to re-write that aspect of OGR as a native OS FDO provider....

regards
S

On Thu, 31 Aug 2006 20:20:19 +0100, Joel Carranza <jec at gatekeeper.com>  
wrote:

>
> Simon,
>
> I wonder if you could follow up a little bit on your statement:
>
> "Oracle provider ... require(s) the F_* Autodesk catalog tables (which  
> the
> AutoDesk provider
> shipped with their per pay version...)"
>
> I was not aware of this. It would explain alot about why we can't get
> anything to work. Is this an explicit fact or simply an impression you  
> got
> after trying to get things to work? Can you point me to some  
> documentation?
>
> Thanks
> Joel
>
>
> Simon Greener wrote:
>>
>> 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
>>
>>
>>
>



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