Engineering-Tech Wiki

imp user/pass file=/bz10m/roads_spatial-current.dmp full=y

The table will be called BZ_ROADS.

This is the TeleAtlas table we got from the municipality on July the 18, 2007. The table contains linestrings (in GEOMETRY column), which represent roads segments; In Network Data Model they become links.

If you want to use any spatial operators (such as finding all segments within distance, retrieving bounding rectangle etc.) you need to create an index for this table:

INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, COLUMN_NAME, DIMINFO)
       VALUES('BZ_ROADS', 'GEOMETRY',
              SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, 0.05),
                            SDO_DIM_ELEMENT('Y', -90, 90, 0.05))
       );
CREATE INDEX BZ_ROADS_INDEX ON BZ_ROADS(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX;

We are working on the meanings of the columns: