[mapguide-users] Oracle Spatial v/s Oracle Locator with MapGuide FDO
Paul Ramsey
pramsey at refractions.net
Wed Aug 30 22:48:16 EDT 2006
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
>
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20060830/8bc8536a/attachment.html
More information about the Mapguide-users
mailing list