Varmistetut reitit

Tables

Tl158, Avointl158, LatestTSV
Aineisto kattaa Liikenneviraston ylläpitämän maantieverkon. Tällä tietolajilla ilmoitetaan varareittisuunnitelmien mukaisesti varmistetuille tieosuuksille varareittinumerot, jotka toimiva tieosuuden kiertotienä (yksi tai useampi varareitti). Reitin numero on muotoa XXXXXYYNNN, missä XXXXX on ko. tien numero, EE sen ELY:n numero, joka ko. varareitin suunnitelmasta vastaa ja NNN ELY-kohtainen varareitin numero.

Column Descriptions

Tl158, Avointl158, Latest

Column	Type	Comment
objectid	int	Data source did not contain a description for OBJECTID. Column objectid has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60350 and maximum value is 65661.
ely	int	Data source did not contain a description for ELY. Column ely has 5312 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 5312 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 29415.
lakkautpvm	date	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 5312 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 5312 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 503.
aet	int	Data source did not contain a description for AET. Column aet has 5312 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 17408.
losa	int	Data source did not contain a description for LOSA. Column losa has 5312 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 503.
let	int	Data source did not contain a description for LET. Column let has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 3 and maximum value is 26205.
alkupvm	date	Data source did not contain a description for ALKUPVM. Column is empty.
loppupvm	date	Data source did not contain a description for LOPPUPVM. Column is empty.
varare1	int	Data source did not contain a description for VARARE1. Column varare1 has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101001 and maximum value is 8912034.
http_vara1	string	Data source did not contain a description for HTTP_VARA1. Column http_vara1 has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: http://aineistot.vayla.fi... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare2	int	Data source did not contain a description for VARARE2. Column varare2 has 5312 rows, out of which 1173 are empty, making the null percent 22.08. Minimum value is 101005 and maximum value is 8912035.
http_vara2	string	Data source did not contain a description for HTTP_VARA2. Column http_vara2 has 5312 rows, out of which 1173 are empty, making the null percent 22.08. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare3	int	Data source did not contain a description for VARARE3. Column varare3 has 5312 rows, out of which 2551 are empty, making the null percent 48.02. Minimum value is 101006 and maximum value is 8912013.
http_vara3	string	Data source did not contain a description for HTTP_VARA3. Column http_vara3 has 5312 rows, out of which 2551 are empty, making the null percent 48.02. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare4	int	Data source did not contain a description for VARARE4. Column varare4 has 5312 rows, out of which 3715 are empty, making the null percent 69.94. Minimum value is 102013 and maximum value is 8912009.
http_vara4	string	Data source did not contain a description for HTTP_VARA4. Column http_vara4 has 5312 rows, out of which 3715 are empty, making the null percent 69.94. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare5	int	Data source did not contain a description for VARARE5. Column varare5 has 5312 rows, out of which 4476 are empty, making the null percent 84.26. Minimum value is 202012 and maximum value is 8912023.
http_vara5	string	Data source did not contain a description for HTTP_VARA5. Column http_vara5 has 5312 rows, out of which 4476 are empty, making the null percent 84.26. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare6	int	Data source did not contain a description for VARARE6. Column varare6 has 5312 rows, out of which 4926 are empty, making the null percent 92.73. Minimum value is 310238 and maximum value is 8912030.
http_vara6	string	Data source did not contain a description for HTTP_VARA6. Column http_vara6 has 5312 rows, out of which 4926 are empty, making the null percent 92.73. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare7	int	Data source did not contain a description for VARARE7. Column varare7 has 5312 rows, out of which 5161 are empty, making the null percent 97.16. Minimum value is 310253 and maximum value is 8912032.
http_vara7	string	Data source did not contain a description for HTTP_VARA7. Column http_vara7 has 5312 rows, out of which 5161 are empty, making the null percent 97.16. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare8	int	Data source did not contain a description for VARARE8. Column varare8 has 5312 rows, out of which 5269 are empty, making the null percent 99.19. Minimum value is 414129 and maximum value is 8912032.
http_vara8	string	Data source did not contain a description for HTTP_VARA8. Column http_vara8 has 5312 rows, out of which 5269 are empty, making the null percent 99.19. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
varare9	int	Data source did not contain a description for VARARE9. Column varare9 has 5312 rows, out of which 5299 are empty, making the null percent 99.76. Minimum value is 414130 and maximum value is 8812040.
http_vara9	string	Data source did not contain a description for HTTP_VARA9. Column http_vara9 has 5312 rows, out of which 5299 are empty, making the null percent 99.76. First 25 characters of minimum string: ... and first 25 characters of maximum string: http://aineistot.vayla.fi...
id	int	Data source did not contain a description for ID. Column is empty.
muutospvm	date	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 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 129 and maximum value is 1435.
s_ualue	string	Data source did not contain a description for S_UALUE. Column s_ualue has 5312 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 19-24.
liva	string	Data source did not contain a description for LIVA. Column liva has 5312 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 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992.
kunta	string	Data source did not contain a description for KUNTA. Column kunta has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski.
maakuntako	int	Data source did not contain a description for MAAKUNTAKO. Column maakuntako has 5312 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 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Karjala and maximum string is Varsinais-Suomi.
laani	string	Data source did not contain a description for LAANI. Column laani has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Etelä-Suomen lääni and maximum string is Oulun l??ni.
varalisa	string	Data source did not contain a description for VARALISA. Column varalisa has 5312 rows, out of which 5303 are empty, making the null percent 99.83. Minimum string is and maximum string is 34b.
varalk1	int	Data source did not contain a description for VARALK1. Column varalk1 has 5312 rows, out of which 5 are empty, making the null percent 0.09. Minimum value is 1 and maximum value is 2.
varalk2	int	Data source did not contain a description for VARALK2. Column varalk2 has 5312 rows, out of which 1180 are empty, making the null percent 22.21. Minimum value is 1 and maximum value is 2.
varalk3	int	Data source did not contain a description for VARALK3. Column varalk3 has 5312 rows, out of which 2553 are empty, making the null percent 48.06. Minimum value is 1 and maximum value is 2.
varalk4	int	Data source did not contain a description for VARALK4. Column varalk4 has 5312 rows, out of which 3719 are empty, making the null percent 70.01. Minimum value is 1 and maximum value is 2.
varalk5	int	Data source did not contain a description for VARALK5. Column varalk5 has 5312 rows, out of which 4477 are empty, making the null percent 84.28. Minimum value is 1 and maximum value is 2.
varalk6	int	Data source did not contain a description for VARALK6. Column varalk6 has 5312 rows, out of which 4924 are empty, making the null percent 92.70. Minimum value is 1 and maximum value is 2.
varalk7	int	Data source did not contain a description for VARALK7. Column varalk7 has 5312 rows, out of which 5161 are empty, making the null percent 97.16. Minimum value is 1 and maximum value is 2.
varalk8	int	Data source did not contain a description for VARALK8. Column varalk8 has 5312 rows, out of which 5269 are empty, making the null percent 99.19. Minimum value is 1 and maximum value is 2.
varalk9	int	Data source did not contain a description for VARALK9. Column varalk9 has 5312 rows, out of which 5299 are empty, making the null percent 99.76. Minimum value is 1 and maximum value is 2.
s_varalk1	string	Data source did not contain a description for S_VARALK1. Column s_varalk1 has 5312 rows, out of which 5 are empty, making the null percent 0.09. Minimum string is and maximum string is varalk2.
s_varalk2	string	Data source did not contain a description for S_VARALK2. Column s_varalk2 has 5312 rows, out of which 1180 are empty, making the null percent 22.21. Minimum string is and maximum string is varalk2.
s_varalk3	string	Data source did not contain a description for S_VARALK3. Column s_varalk3 has 5312 rows, out of which 2553 are empty, making the null percent 48.06. Minimum string is and maximum string is varalk2.
s_varalk4	string	Data source did not contain a description for S_VARALK4. Column s_varalk4 has 5312 rows, out of which 3719 are empty, making the null percent 70.01. Minimum string is and maximum string is varalk2.
s_varalk5	string	Data source did not contain a description for S_VARALK5. Column s_varalk5 has 5312 rows, out of which 4477 are empty, making the null percent 84.28. Minimum string is and maximum string is varalk2.
s_varalk6	string	Data source did not contain a description for S_VARALK6. Column s_varalk6 has 5312 rows, out of which 4924 are empty, making the null percent 92.70. Minimum string is and maximum string is varalk2.
s_varalk7	string	Data source did not contain a description for S_VARALK7. Column s_varalk7 has 5312 rows, out of which 5161 are empty, making the null percent 97.16. Minimum string is and maximum string is varalk2.
s_varalk8	string	Data source did not contain a description for S_VARALK8. Column s_varalk8 has 5312 rows, out of which 5269 are empty, making the null percent 99.19. Minimum string is and maximum string is varalk2.
s_varalk9	string	Data source did not contain a description for S_VARALK9. Column s_varalk9 has 5312 rows, out of which 5299 are empty, making the null percent 99.76. Minimum string is and maximum string is varalk2.
geom_geojson	string	Geometry in GeoJSON format.
geom_geotext	string	Geometry as GeoText. Column geom_geotext has 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: LINESTRING (21.4046029180... and first 25 characters of maximum string: MULTILINESTRING ((30.3207...
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 5312 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_LINESTRING and maximum string is ST_MULTILINESTRING.

Additional Info

Last Updated	September 11, 2020
Created	July 9, 2018