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

contrib:bz10m_roads2_network [2008/01/10 13:07]
sleleiva created
contrib:bz10m_roads2_network [2019/01/16 10:03]
Line 1: Line 1:
-=== BZ10M: Bolzano Roads 2 (New) Network - Network Data Model === 
- 
-== Import == 
- 
-  imp user/pass file=/bz10m/roads2_network-1.0.dmp full=y 
- 
-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> 
  
/var/www/wiki.inf.unibz.it/data/pages/contrib/bz10m_roads2_network.txt · Last modified: 2019/01/16 10:03 (external edit)