[postgis-users] Anti-meridian and polar polygon question

[Richard_D_Levine at raytheon.com]

It is a separately licensed and installed capability, though it is
automatically installed when you do an Enterprise install.  I've used it
fairly extensively and it is fast, robust, and accurate, though the syntax
and semantics are arcane.  It is not very OpenGIS compliant, so don't
expect to port to anything else easily.  I hid the spatial implementation
details inside PL*SQL packages behind innocuous sounding procedures, like
Make_Circle(point, radius, SRID), to enhance portability.

PostgreSQL doesn't support packages, so you would have to put all of your
procedures into a separate schema to mimic the naming.  My package was
named Geometries, so when I do this in PostgreSQL I will create a schema
named Geometries to contain work-alike functions.  I think I should be able
to maintain most queries that run against either platform by doing this,
but I haven't done it yet, so that is speculation.

Rick


|---------+--------------------------------------------->
|         |           "Ken Tanaka" <Ken.Tanaka at noaa.gov>|
|         |           Sent by:                          |
|         |           postgis-users-bounces at postgis.refr|
|         |           actions.net                       |
|         |                                             |
|         |                                             |
|         |           10/22/2004 10:54 AM               |
|         |           Please respond to PostGIS Users   |
|         |           Discussion                        |
|         |                                             |
|---------+--------------------------------------------->
  >----------------------------------------------------------------------------------------------|
  |                                                                                              |
  |       To:       PostGIS Users Discussion <postgis-users at postgis.refractions.net>             |
  |       cc:                                                                                    |
  |       Subject:  Re: [postgis-users] Anti-meridian and polar polygon question                 |
  >----------------------------------------------------------------------------------------------|




Thanks for mentioning this, I hadn't realized that Oracle had this
capability. Although we use Oracle quite a bit, it's always had ArcSDE
layered on top of it, which certainly doesn't handle ellipsoid based
models in its current version. So we've been chopping things on the
antimeridian to keep the ArcSDE layer happy.

-Ken

Richard_D_Levine at raytheon.com wrote:

>In a feeble attempt to amuse his dog (who is easily amused), Ken Tenaka
wrote:
>
>"does anyone know of other spatially enabled databases that can also do
>this, either free or commercial?"
>
>This comes from an Oracle forum where somebody else asked exactly the same
>question:
>
>

> From: Oracle, Gary Smith 02-Mar-04

> 21:00

> Subject: Re : Oracle Spatial and

> geodec behavior

>

> Oracle Spatial's geodetic model allows

> customers to specify geodetic

> geometries that span the 180 meridian,

> and also geometries that encompass a

> pole (for example a polygon geometry

> that follows the 70 degree latitude

> line could represent a polygon that

> looks like a hat that covers a pole).

>

>
>

...

_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users