User Tools

Site Tools


contrib:bz10m_roads_spatial

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
contrib:bz10m_roads_spatial [2007/09/26 16:09] sleleivacontrib:bz10m_roads_spatial [2008/01/28 11:39] – deleted -- obsolete information sleleiva
Line 1: Line 1:
-=== BZ10MBolzano Roads Network Spatial Table ===+=== This page has been moved to: === 
 +https://www.inf.unibz.it/dis/wiki/doku.php?id=projects:bz10m:data:roads_spatial
  
-== Import ==+=== Please update your records. ===
  
-  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 [[contrib:bz10m_roads_network|Network Data Model]] they become links. 
- 
-== 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: 
-<code oracle8> 
-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; 
-</code> 
- 
-== Columns of the table == 
-We are working on the meanings of the columns: 
-|ID|long integer, the ID for each road segment| 
-|FEATTYP|?| 
-|FT|?| 
-|F_JNCTID|?| 
-|F_JNCTTYP|?| 
-|T_JNCTID|?| 
-|T_JNCTTYP|?| 
-|PJ|?| 
-|METERS|Length of a segment in meters, rounded up to the hundredth part. See LENGTH| 
-|FRC|?| 
-|NETCLASS|?| 
-|NETBCLASS|?| 
-|NET2CLASS|?| 
-|NAME|Name of the street/highway number| 
-|NAMELC|?| 
-|SOL|?| 
-|NAMETYP|?| 
-|CHARGE|?| 
-|ROUTENUM|Highway number| 
-|RTETYP|?| 
-|RTEDIR|?| 
-|RTEDIRVD|?| 
-|PROCSTAT|?| 
-|FOW|?| 
-|SLIPRD|?| 
-|BACKRD|?| 
-|TOLLRD|?| 
-|RDCOND|?| 
-|STUBBLE|?| 
-|PRIVATERD|?| 
-|CONSTATUS|?| 
-|ONEWAY|Road type. Looks utterly incomplete.\\ FT-one way street\\ N-only for bus or cycle (transit limited e.g. Downtown)| 
-|F_BP|?| 
-|T_BP|?| 
-|F_ELEV|?| 
-|T_ELEV|?| 
-|KPH|Speed limit| 
-|MINUTES|Calculated column: amount of time in minutes which takes to drive the road segment, when driving at the speed limit| 
-|POSACCUR|?| 
-|CARRIAGE|?| 
-|LANES|Number of lanes. Utterly incomplete (98.7% are zeroes)| 
-|LENGTH|The length of the road in meters, precise up to a thousandth part| 
/data/www/wiki.inf.unibz.it/data/pages/contrib/bz10m_roads_spatial.txt · Last modified: 2019/01/16 10:03 by 127.0.0.1