1. Home
  2. Datasets
  3. Tunneli ...
To download the data set, please sign up or log in

Tunneli (Taitorakennerekisteri)

Tunneli (Taitorakennerekisteri)

Tables

Column Descriptions

Trex tunneli, Avointrex tunneli, Latest

Column Type Comment
id int Data source did not contain a description for ID. Column id has 186 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 186.
oid string Data source did not contain a description for OID. Column oid has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.2.246.578.1.17.104500 and maximum string is 1.2.246.578.1.17.903013.
tila string Data source did not contain a description for TILA. Column tila has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kaytossa and maximum string is poistettu.
nykyinen_o string Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: nimi:Ei tiedossa (selvite... and first 25 characters of maximum string: nimi:Väylävirasto,yTunnus...
katuosoitt string Data source did not contain a description for KATUOSOITT. Column katuosoitt has 186 rows, out of which 185 are empty, making the null percent 99.46. The single string value is: nimi:Ratapihantie,kunta:t...
keskipiste int Data source did not contain a description for KESKIPISTE. Column keskipiste has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 226498 and maximum value is 637697.
keskipist0 int Data source did not contain a description for KESKIPIST0. Column keskipist0 has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6663234 and maximum value is 7376453.
keskipist1 string Data source did not contain a description for KESKIPIST1. Column keskipist1 has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: lat:60.0632695591311,lon:... and first 25 characters of maximum string: lat:66.5020453556391,lon:...
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is H-1 and maximum string is U-987654.
rataosoitt string Data source did not contain a description for RATAOSOITT. Column rataosoitt has 186 rows, out of which 115 are empty, making the null percent 61.83. First 25 characters of minimum string: ... and first 25 characters of maximum string: ratanumero:KV 888,ratakil...
sijaintiku string Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 186 rows, out of which 1 are empty, making the null percent 0.54. Minimum string is and maximum string is tunnus:935,nimi:Virolahti.
tieosoitte string Data source did not contain a description for TIEOSOITTE. Column tieosoitte has 186 rows, out of which 124 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: tienumero:9,tieosa:204,et...
nimi string Data source did not contain a description for NIMI. Column nimi has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aviapoliksen ajotunneli and maximum string is Åminnen tunneli.
nykyinenku string Data source did not contain a description for NYKYINENKU. Column nykyinenku has 186 rows, out of which 8 are empty, making the null percent 4.30. Minimum string is and maximum string is nimi:Yksityinen.
paivitetty timestamp Data source did not contain a description for PAIVITETTY. Column paivitetty has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2019-03-01 00:00:00 and maximum value is 2020-08-31 00:00:00.
rakenneluo string Data source did not contain a description for RAKENNELUO. Column rakenneluo has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:T,nimi:Tunneli.
sijaintisu string Data source did not contain a description for SIJAINTISU. Column sijaintisu has 186 rows, out of which 137 are empty, making the null percent 73.66. Minimum string is and maximum string is tunnus:W,nimi:W.
kayttotark string Data source did not contain a description for KAYTTOTARK. Column kayttotark has 186 rows, out of which 93 are empty, making the null percent 50.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: tunnus:91,nimi:Rautatietu...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 186 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 (22.02368796556292 ... and first 25 characters of maximum string: POINT (29.59955952163581 ...
geom_center_x float Longitude of center. Column geom_center_x has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.02 and maximum value is 29.60.
geom_center_y float Latitude of center. Column geom_center_y has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.06 and maximum value is 66.50.
geom_type string Geometry type. Column geom_type has 186 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.

Trex tunneli, Avointrex tunneli, Full history

Column Type Comment
id int Data source did not contain a description for ID. Column id has 186 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 186.
oid string Data source did not contain a description for OID. Column oid has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 1.2.246.578.1.17.104500 and maximum string is 1.2.246.578.1.17.903013.
tila string Data source did not contain a description for TILA. Column tila has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is kaytossa and maximum string is poistettu.
nykyinen_o string Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: nimi:Ei tiedossa (selvite... and first 25 characters of maximum string: nimi:Väylävirasto,yTunnus...
katuosoitt string Data source did not contain a description for KATUOSOITT. Column katuosoitt has 186 rows, out of which 185 are empty, making the null percent 99.46. The single string value is: nimi:Ratapihantie,kunta:t...
keskipiste int Data source did not contain a description for KESKIPISTE. Column keskipiste has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 226498 and maximum value is 637697.
keskipist0 int Data source did not contain a description for KESKIPIST0. Column keskipist0 has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6663234 and maximum value is 7376453.
keskipist1 string Data source did not contain a description for KESKIPIST1. Column keskipist1 has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: lat:60.0632695591311,lon:... and first 25 characters of maximum string: lat:66.5020453556391,lon:...
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is H-1 and maximum string is U-987654.
rataosoitt string Data source did not contain a description for RATAOSOITT. Column rataosoitt has 186 rows, out of which 115 are empty, making the null percent 61.83. First 25 characters of minimum string: ... and first 25 characters of maximum string: ratanumero:KV 888,ratakil...
sijaintiku string Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 186 rows, out of which 1 are empty, making the null percent 0.54. Minimum string is and maximum string is tunnus:935,nimi:Virolahti.
tieosoitte string Data source did not contain a description for TIEOSOITTE. Column tieosoitte has 186 rows, out of which 124 are empty, making the null percent 66.67. First 25 characters of minimum string: ... and first 25 characters of maximum string: tienumero:9,tieosa:204,et...
nimi string Data source did not contain a description for NIMI. Column nimi has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aviapoliksen ajotunneli and maximum string is Åminnen tunneli.
nykyinenku string Data source did not contain a description for NYKYINENKU. Column nykyinenku has 186 rows, out of which 8 are empty, making the null percent 4.30. Minimum string is and maximum string is nimi:Yksityinen.
paivitetty timestamp Data source did not contain a description for PAIVITETTY. Column paivitetty has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2019-03-01 00:00:00 and maximum value is 2020-08-31 00:00:00.
rakenneluo string Data source did not contain a description for RAKENNELUO. Column rakenneluo has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:T,nimi:Tunneli.
sijaintisu string Data source did not contain a description for SIJAINTISU. Column sijaintisu has 186 rows, out of which 137 are empty, making the null percent 73.66. Minimum string is and maximum string is tunnus:W,nimi:W.
kayttotark string Data source did not contain a description for KAYTTOTARK. Column kayttotark has 186 rows, out of which 93 are empty, making the null percent 50.00. First 25 characters of minimum string: ... and first 25 characters of maximum string: tunnus:91,nimi:Rautatietu...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 186 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 (22.02368796556292 ... and first 25 characters of maximum string: POINT (29.59955952163581 ...
geom_center_x float Longitude of center. Column geom_center_x has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22.02 and maximum value is 29.60.
geom_center_y float Latitude of center. Column geom_center_y has 186 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.06 and maximum value is 66.50.
geom_type string Geometry type. Column geom_type has 186 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.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated September 11, 2020
Created September 11, 2020