[mapserver-users] Oracle Locator support

[Michael Shishcu]

Hi Bill,
Here (
http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator-vs-enterprise-licensing-the-sdogeom-package)
You can find differences between Spatial and locator.
That was posted in 2007 - anyway, in general, that is true. There also had
been changes in 11g (R1 or R2 - do not remember exactly) that added a
number of features into locator from spatial.
Less words, you can easily use locator for wms/wfs services etc, with
restriction to several analytic  packages/functions.

One more thing to mention. Every feature that is available in spatial is
also accessible in locator (afair true for Oracle Enterprise and Standard
editions, not sure with XE). The only difference is licensing.
So you can develop your application, write down all the functions you used
and decide does that list fit into locator or not. If not - you go into
spatial or change your code.

regards, michael
On Tue, Feb 28, 2012 at 8:01 AM, bteluk at gmail.com <bteluk at gmail.com> wrote:

> Hi,
> I'm trying to find out if Oracle Locator can be used as an effective
> Spatial
> Database for MapServer.  I haven't been able to find a list of what is and
> isn't supported for this combination.  We've been using PostgreSQL/PostGIS
> as our spatial database and are wondering whether a shift to Oracle Locator
> is viable, or whether we'd need to go to Oracle Spatial.  The kinds of
> things we're doing are:
> - building OpenLayers applications with a high level of user functionality
> eg. multiple layers, point and polygon queries, user drawn/edited features
> (for writing to the database)
> - providing WMS services (eg. street maps)
> - providing WFS services (with filtering)
> - custom services eg. nearest feature to a point, queries on buffered
> features, etc.
> Thanks, Bill Teluk
>
> --
> View this message in context:
> http://osgeo-org.1560.n6.nabble.com/Oracle-Locator-support-tp4519962p4519962.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120228/c1af059b/attachment.htm>