contrib:bz10m_roads2_network
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
contrib:bz10m_roads2_network [2008/01/10 17:27] – SRID tricks sleleiva | contrib:bz10m_roads2_network [2019/01/16 10:03] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | === BZ10M: Bolzano Roads 2 (New) 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 (1/ | + | |
- | + | ||
- | The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$ | + | |
- | + | ||
- | The links are taken directly from the [[contrib: | + | |
- | + | ||
- | + | ||
- | == 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> | + | |
- | DELETE FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME=' | + | |
- | INSERT INTO USER_SDO_GEOM_METADATA(TABLE_NAME, | + | |
- | | + | |
- | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(' | + | |
- | SDO_DIM_ELEMENT(' | + | |
- | 82344) | + | |
- | ); | + | |
- | CREATE INDEX BZ_ROADS2_LINK$_INDEX ON BZ_ROADS2_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; | + | |
- | </ | + | |
/data/www/wiki.inf.unibz.it/data/pages/contrib/bz10m_roads2_network.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1