OpenCities Map CONNECT Edition Help

To Create a Feature of Type Polygon

  1. Create the table with one geometry column and one ID.
    CREATE TABLE POLYGON
    (ID NUMBER PRIMARY KEY, 
    Geometry MDSYS.SDO_GEOMETRY);

  2. Insert the table metadata into the Oracle Spatial metadata.
    INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID) 
    VALUES ('POLYGON', 'Geometry', 
    MSYS.SDO_DIM_ARRAY
    (MDYS.SDO_DIM_ELEMENT('X', 714099.913898663, 715312.343907550, 0.000000050),  
    MDSYSS.DO_DIM_ELEMENT('Y', 4908438.586694972, 4910715.465519385, 0.000000050)), 
    82247;
    ​

  3. Create the spatial index of type multipolygon to use model multi-geometry objects.
    CREATE INDEX POLYGON_IDX ON POLYGON(Geometry) 
    INDEXTYPE IS MDSYS.SPATIAL_INDEX_V2 PARAMETERS ('layer_gtype=multipolygon');