Rautatietasoristeys - Rautatietasoristeys (Tierekisterin tietolaji 192)

Tables

Tl192, Avointl192TSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Rautatietasoristeyksen tieosoite määräytyy ko. väylien keskilinjojen leikkauspisteen mukaan. Rautatietasoristeyksiin luetaan myös ne muutamat tapaukset, joissa rautatie ja yleinen tie käyttävät samaa ajorataa sillalla. Tieosoite määräytyy tällöin yhteisen osuuden keskikohdan mukaan.

Column Descriptions

Tl192, Avointl192

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3201 and maximum value is 4164.
ely	int	Data source did not contain a description for ELY. Column ely has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 14.
tie	int	Data source did not contain a description for TIE. Column tie has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 18 and maximum value is 87681.
lakkautpvm	string	Data source did not contain a description for LAKKAUTPVM. Column is empty.
ajr	int	Data source did not contain a description for AJR. Column ajr has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2.
aosa	int	Data source did not contain a description for AOSA. Column aosa has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 951.
aet	int	Data source did not contain a description for AET. Column aet has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 11435.
alkupvm	string	Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm	string	Data source did not contain a description for LOPPUPVM. Column is empty.
rautatie	int	Data source did not contain a description for RAUTATIE. Column rautatie has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 4.
s_rautatie	string	Data source did not contain a description for S_RAUTATIE. Column s_rautatie has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is puolipuomi and maximum string is valo/??ni.
sahkorat	int	Data source did not contain a description for SAHKORAT. Column sahkorat has 479 rows, out of which 336 are empty, making the null percent 70.15. This column is filled with a constant value. Constant value is 1.
s_sahkorat	string	Data source did not contain a description for S_SAHKORAT. Column s_sahkorat has 479 rows, out of which 336 are empty, making the null percent 70.15. This column is filled with a constant value.
rhkid	string	Data source did not contain a description for RHKID. Column rhkid has 479 rows, out of which 31 are empty, making the null percent 6.47. Minimum string is IN /01 and maximum string is ÄJ /09.
id	int	Data source did not contain a description for ID. Column is empty.
muutospvm	string	Data source did not contain a description for MUUTOSPVM. Column is empty.
ualue	int	Data source did not contain a description for UALUE. Column ualue has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 127 and maximum value is 1435.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus 17-22 and maximum string is Äänekoski 14-19.
liva	string	Data source did not contain a description for LIVA. Column liva has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaan ELY and maximum string is Varsinais-Suomen ELY.
kuntakoodi	int	Data source did not contain a description for KUNTAKOODI. Column kuntakoodi has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ähtäri and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 19.
maakunta	string	Data source did not contain a description for MAAKUNTA. Column maakunta has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Pohjanmaa and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 479 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Länsi-Suomen lääni and maximum string is Oulun l??ni.
geom_geojson	string	Geometry in GeoJSON format.
orig_extractdate	string

Additional Info

Last Updated	September 2, 2023
Created	July 9, 2018