contrib:bz10m_roads_network
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
contrib:bz10m_roads_network [2007/09/26 17:32] – sleleiva | contrib:bz10m_roads_network [2019/01/16 10:03] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | === BZ10M: Bolzano Roads Network - Network Data Model === | + | === This page has been moved to: === |
+ | https:// | ||
- | == Import | + | === Please update your records. === |
- | imp user/pass file=/ | ||
- | |||
- | Create network (needs to be done once): | ||
- | <code oracle8> | ||
- | INSERT INTO USER_SDO_NETWORK_METADATA( | ||
- | network, network_category, | ||
- | node_table_name, | ||
- | link_table_name, | ||
- | VALUES( | ||
- | ' | ||
- | ' | ||
- | ' | ||
- | </ | ||
- | |||
- | Current version: 1.0 (9/26/2007) | ||
- | |||
- | The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$ | ||
- | |||
- | The links are taken directly from the [[contrib: | ||
- | |||
- | == Columns == | ||
- | BZ_ROADS_LINK$: | ||
- | |LINK_ID | ||
- | |START_NODE_ID|ID of the starting node of the link in the BZ_ROADS_NODE$| | ||
- | |END_NODE_ID | ||
- | |COST | ||
- | |LINK_NAME | ||
- | |LENGTH | ||
- | |MINUTES | ||
- | |KPH |Speed limit. Copied from the [[contrib: | ||
- | |GEOMETRY | ||
- | |||
- | BZ_ROADS_NODE$: | ||
- | |NODE_ID | ||
- | |GEOMETRY | ||
- | |||
- | |||
- | == Creating index == | ||
- | 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. | ||
- | 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, | ||
- | | ||
- | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(' | ||
- | SDO_DIM_ELEMENT(' | ||
- | ); | ||
- | CREATE INDEX BZ_ROADS_LINK$_INDEX ON BZ_ROADS_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; | ||
- | </ | ||
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_roads_network.1190820761.txt.gz · Last modified: 2019/01/16 10:03 (external edit)