User Tools

Site Tools


contrib:bz10m_roads2_network

Differences

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

Link to this comparison view

Next revision
Previous revision
contrib:bz10m_roads2_network [2008/01/10 13:07] – created sleleivacontrib:bz10m_roads2_network [2019/01/16 10:03] (current) – external edit 127.0.0.1
Line 1: Line 1:
-=== BZ10MBolzano Roads 2 (New) Network - Network Data Model ===+=== This page has been moved to: === 
 +https://www.inf.unibz.it/dis/wiki/doku.php?id=projects:bz10m:roads2_network
  
-== Import =+=== Please update your records. ===
- +
-  imp user/pass file=/bz10m/roads2_network-1.0.dmp full=+
- +
-Create network (needs to be done once): +
-<code oracle8> +
-INSERT INTO USER_SDO_NETWORK_METADATA( +
-                network, network_category, geometry_type, +
-                node_table_name, node_geom_column, +
-                link_table_name, link_geom_column, link_direction) +
-        VALUES( +
-                'BZ_ROADS2_NET', 'SPATIAL', 'SDO_GEOMETRY', +
-                'BZ_ROADS2_NODE$', 'GEOMETRY', +
-                'BZ_ROADS2_LINK$', 'GEOMETRY', 'UNDIRECTED'); +
-</code> +
- +
-Current version: 1.0 (1/10/2008) +
- +
-The imported network data model will contain two tables: BZ_ROADS_LINK$ and BZ_ROADS_NODE$ +
- +
-The links are taken directly from the [[contrib:bz10m_roads_spatial|Spatial table]] road segments (linestrings). The nodes are created by generating a node for each segment start and end points. +
- +
- +
-== 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, COLUMN_NAME, DIMINFO) +
-       VALUES('BZ_ROADS2_LINK$', 'GEOMETRY', +
-              SDO_DIM_ARRAY(SDO_DIM_ELEMENT('X', -180, 180, 0.05), +
-                            SDO_DIM_ELEMENT('Y', -90, 90, 0.05)) +
-       ); +
-CREATE INDEX BZ_ROADS2_LINK$_INDEX ON BZ_ROADS2_LINK$(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; +
-</code>+
  
/data/www/wiki.inf.unibz.it/data/attic/contrib/bz10m_roads2_network.1199966879.txt.gz · Last modified: 2019/01/16 10:03 (external edit)