[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] rtpostgis errors
From:       aperi2007 <aperi2007 () gmail ! com>
Date:       2010-12-24 19:42:56
Message-ID: 4D14F7C0.4080405 () gmail ! com
[Download RAW message or body]

> >Uhm... maybe I should drop the box2d too from topology model.
> >It's currently used to represent mbr (Minimum Bounding Rectangle)
> >for the Face table.
> >
> >ISO says it should be an ST_Polygon and oracle says it should be
> >an SDO_GEOMETRY.

Hi,

In Oracle the geometry type is definided only when declared the spatial 
index-type.
It is different from postgis where the geometry-type is definited when 
you define the column.

So say-ing "SDO_Geometry" mean "generic geometry" and could mean "Polygon"

Infact oracle say the data-type is SDO_Geometry and the 
sdo_topo.initialize_metadata
procedure creates a spatial_index on this column. Most probably the 
procedure create a spatial-index
for polygons types.

Regards,

Andrea.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]