Differences

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

--- contrib:bz10m_roads_spatial [2007/09/26 16:09] – sleleiva
+++ contrib:bz10m_roads_spatial [2019/01/16 10:03] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-=== BZ10M: Bolzano 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|