contrib:bz10m_roads_spatial
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
contrib:bz10m_roads_spatial [2007/09/26 16:09] – HOWTO Create Index 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:// | ||
- | Import: | + | === Please update your records. === |
- | imp user/pass file=/ | ||
- | 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: | ||
- | |||
- | == 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, | ||
- | | ||
- | SDO_DIM_ARRAY(SDO_DIM_ELEMENT(' | ||
- | SDO_DIM_ELEMENT(' | ||
- | ); | ||
- | CREATE INDEX BZ_ROADS_INDEX ON BZ_ROADS(GEOMETRY) INDEXTYPE IS MDSYS.SPATIAL_INDEX; | ||
- | </ | ||
- | |||
- | == 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/ | ||
- | |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