Differences

This shows you the differences between two versions of the page.

--- contrib:bz10m_roads2_network [2008/01/10 13:07] – created sleleiva
+++ contrib:bz10m_roads2_network [2008/01/10 17:27] – SRID tricks sleleiva
@@ Line 28: / Line 28: @@
 How to do this for the LINK table (same for NODE, just substitute LINK$ with NODE$):
 <code oracle8>
-INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, COLUMN_NAME, DIMINFO)
+DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME='BZ_ROADS2_LINK$';
+INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
        VALUES('BZ_ROADS2_LINK$', 'GEOMETRY',
-              SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, 0.05),
+              SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', 0, 0, .001),
-                            SDO_DIM_ELEMENT('Y', -90, 90, 0.05))
+                            SDO_DIM_ELEMENT('Y', 0, 0, .001),
+)
        );
 CREATE INDEX BZ_ROADS2_LINK$_INDEX ON BZ_ROADS2_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX;
 </code>