Tasoristeykset

Tables

Tasoristeykset, Avointasoristeykset, LatestTSV
Sisältää valtion rataverkolla käytössä olevat tasoristeykset. Kohteet on luokiteltu vartioituihin (varustettu varoituslaitteella) ja vartioimattomiin tasoristeyksiin. Aineisto ei sisällä yksityisraiteiden tai suljettujen alueiden tasoristeyksiä. Liikennevirasto ei vastaa luovutettavien tietojen oikeellisuudesta eikä vastaa aineiston käytöstä tietojen käyttäjälle tai kolmannelle osapuolelle mahdollisesti aiheutuvista välittömistä tai välillisistä vahingoista.

Column Descriptions

Tasoristeykset, Avointasoristeykset, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 608069 and maximum value is 612304.
tunnus	string	Data source did not contain a description for TUNNUS. Column tunnus has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is AHO /01 and maximum string is ÄS /05.
nimi	string	Data source did not contain a description for NIMI. Column nimi has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aakeenkatu and maximum string is Österskogas.
raidelkm	int	Data source did not contain a description for RAIDELKM. Column raidelkm has 3027 rows, out of which 4 are empty, making the null percent 0.13. Minimum value is 1 and maximum value is 11.
paar_lkm	int	Data source did not contain a description for PAAR_LKM. Column paar_lkm has 3027 rows, out of which 44 are empty, making the null percent 1.45. Minimum value is 0 and maximum value is 8.
tila	string	Data source did not contain a description for TILA. Column tila has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: kausittainen... and first 25 characters of maximum string: käytössä. ei tasoristeyso...
huomautus	string	Data source did not contain a description for HUOMAUTUS. Column is empty.
tienimi	string	Data source did not contain a description for TIENIMI. Column tienimi has 3027 rows, out of which 72 are empty, making the null percent 2.38. Minimum string is and maximum string is Östermarksvägen.
tienumero	string	Data source did not contain a description for TIENUMERO. Column tienumero has 3027 rows, out of which 90 are empty, making the null percent 2.97. Minimum string is and maximum string is 9643.
tielaji	string	Data source did not contain a description for TIELAJI. Column tielaji has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Erikoiskuljetustie and maximum string is Yksityistie.
kansirak	string	Data source did not contain a description for KANSIRAK. Column kansirak has 3027 rows, out of which 139 are empty, making the null percent 4.59. Minimum string is and maximum string is Yhtenäinen betonilaatta.
kansilisat	string	Data source did not contain a description for KANSILISAT. Column is empty.
kansipit	int	Data source did not contain a description for KANSIPIT. Column kansipit has 3027 rows, out of which 246 are empty, making the null percent 8.13. Minimum value is 0 and maximum value is 400.
kansiaspvm	date	Data source did not contain a description for KANSIASPVM. Column is empty.
tie_huom	string	Data source did not contain a description for TIE_HUOM. Column tie_huom has 3027 rows, out of which 1986 are empty, making the null percent 65.61. Minimum string is and maximum string is Ylätalontie.
varlaty	string	Data source did not contain a description for VARLATY. Column varlaty has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei ole and maximum string is Varoitusvalolaitos.
varlani	string	Data source did not contain a description for VARLANI. Column varlani has 3027 rows, out of which 2387 are empty, making the null percent 78.86. Minimum string is and maximum string is Ähtäri, Myllymäki.
varlakpvm	date	Data source did not contain a description for VARLAKPVM. Column is empty.
varlappvm	date	Data source did not contain a description for VARLAPPVM. Column is empty.
varlahuom	string	Data source did not contain a description for VARLAHUOM. Column is empty.
ko_nro	int	Data source did not contain a description for KO_NRO. Column ko_nro has 3027 rows, out of which 2344 are empty, making the null percent 77.44. Minimum value is 32 and maximum value is 25836.
ko_ver	string	Data source did not contain a description for KO_VER. Column ko_ver has 3027 rows, out of which 2657 are empty, making the null percent 87.78. Minimum string is and maximum string is H.
alkupvm	date	Data source did not contain a description for ALKUPVM. Column is empty.
muutospvm	date	Data source did not contain a description for MUUTOSPVM. Column is empty.
alkukm_m	string	Data source did not contain a description for ALKUKM_M. Column alkukm_m has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0567 and maximum string is 1068+0386.
loppukm_m	string	Data source did not contain a description for LOPPUKM_M. Column loppukm_m has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0567 and maximum string is 1068+0386.
pistekm_m	string	Data source did not contain a description for PISTEKM_M. Column pistekm_m has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 0000+0567 and maximum string is 1068+0386.
sijraitunn	int	Data source did not contain a description for SIJRAITUNN. Column sijraitunn has 3027 rows, out of which 801 are empty, making the null percent 26.46. Minimum value is 2 and maximum value is 751.
ratanro	int	Data source did not contain a description for RATANRO. Column ratanro has 3027 rows, out of which 11 are empty, making the null percent 0.36. Minimum value is 1 and maximum value is 751.
paal_alku	int	Data source did not contain a description for PAAL_ALKU. Column paal_alku has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 567 and maximum value is 10680386.
paal_loppu	int	Data source did not contain a description for PAAL_LOPPU. Column paal_loppu has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 567 and maximum value is 10680386.
paal_piste	int	Data source did not contain a description for PAAL_PISTE. Column paal_piste has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 567 and maximum value is 10680386.
kp_alue	int	Data source did not contain a description for KP_ALUE. Column kp_alue has 3027 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 12.
irrotus_pv	timestamp	Data source did not contain a description for IRROTUS_PV. Column irrotus_pv has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020-05-11 13:37:08 and maximum value is 2020-05-11 13:37:28.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (21.222042327922534... and first 25 characters of maximum string: POINT (30.950943490957133...
geom_center_x	double	Longitude of the centroid of the geometry. Column is empty.
geom_center_y	double	Latitude of the centroid of the geometry. Column is empty.
geom_type	string	Geometry type. Column geom_type has 3027 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT.

Additional Info

Last Updated	September 11, 2020
Created	July 9, 2018