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

Laituri (Taitorakennerekisteri)

Laituri (Taitorakennerekisteri)

Tables

Column Descriptions

Trex laituri, Avointrex laituri, Full history

Column Type Comment
id int Data source did not contain a description for ID. Column id has 398 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 398.
oid string Data source did not contain a description for OID. Column oid has 398 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.18.104000 and maximum string is 1.2.246.578.1.18.903002.
tila string Data source did not contain a description for TILA. Column tila has 398 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 purettu.
nykyinen_o string Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is nimi:Helsingin kaupunki and maximum string is nimi:Yksityinen.
katuosoitt string Data source did not contain a description for KATUOSOITT. Column is empty.
keskipiste int Data source did not contain a description for KESKIPISTE. Column keskipiste has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 177744 and maximum value is 664486.
keskipist0 int Data source did not contain a description for KESKIPIST0. Column keskipist0 has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6641058 and maximum value is 7384891.
keskipist1 string Data source did not contain a description for KESKIPIST1. Column keskipist1 has 398 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:59.786410301571,lon:2... and first 25 characters of maximum string: lat:66.5802968715809,lon:...
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is H-2748 and maximum string is V-6003.
rataosoitt string Data source did not contain a description for RATAOSOITT. Column is empty.
sijaintiku string Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 398 rows, out of which 3 are empty, making the null percent 0.75. Minimum string is and maximum string is tunnus:915,nimi:Varkaus.
tieosoitte string Data source did not contain a description for TIEOSOITTE. Column tieosoitte has 398 rows, out of which 203 are empty, making the null percent 51.01. First 25 characters of minimum string: ... and first 25 characters of maximum string: tienumero:9452,tieosa:1,e...
nimi string Data source did not contain a description for NIMI. Column nimi has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aaslan lauttapaikka and maximum string is Österskärin laituri.
nykyinenku string Data source did not contain a description for NYKYINENKU. Column nykyinenku has 398 rows, out of which 40 are empty, making the null percent 10.05. Minimum string is and maximum string is nimi:Yksityinen.
vesivaylao string Data source did not contain a description for VESIVAYLAO. Column vesivaylao has 398 rows, out of which 389 are empty, making the null percent 97.74. First 25 characters of minimum string: ... and first 25 characters of maximum string: nimi:SALMI OULUJÄRVESSÄ,s...
paivitetty timestamp Data source did not contain a description for PAIVITETTY. Column paivitetty has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2019-02-04 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 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:LR,nimi:Laituri.
sijaintisu string Data source did not contain a description for SIJAINTISU. Column sijaintisu has 398 rows, out of which 335 are empty, making the null percent 84.17. Minimum string is and maximum string is tunnus:W,nimi:W.
rakennetyy string Data source did not contain a description for RAKENNETYY. Column rakennetyy has 398 rows, out of which 359 are empty, making the null percent 90.20. First 25 characters of minimum string: ... and first 25 characters of maximum string: nimi:Teräsbetoninen , ter...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 398 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.15711366719817 ... and first 25 characters of maximum string: POINT (30.238302446282677...
geom_center_x float Longitude of center. Column geom_center_x has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.16 and maximum value is 30.24.
geom_center_y float Latitude of center. Column geom_center_y has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.79 and maximum value is 66.58.
geom_type string Geometry type. Column geom_type has 398 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.

Trex laituri, Avointrex laituri, Latest

Column Type Comment
id int Data source did not contain a description for ID. Column id has 398 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 398.
oid string Data source did not contain a description for OID. Column oid has 398 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.18.104000 and maximum string is 1.2.246.578.1.18.903002.
tila string Data source did not contain a description for TILA. Column tila has 398 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 purettu.
nykyinen_o string Data source did not contain a description for NYKYINEN_O. Column nykyinen_o has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is nimi:Helsingin kaupunki and maximum string is nimi:Yksityinen.
katuosoitt string Data source did not contain a description for KATUOSOITT. Column is empty.
keskipiste int Data source did not contain a description for KESKIPISTE. Column keskipiste has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 177744 and maximum value is 664486.
keskipist0 int Data source did not contain a description for KESKIPIST0. Column keskipist0 has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6641058 and maximum value is 7384891.
keskipist1 string Data source did not contain a description for KESKIPIST1. Column keskipist1 has 398 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:59.786410301571,lon:2... and first 25 characters of maximum string: lat:66.5802968715809,lon:...
tunnus string Data source did not contain a description for TUNNUS. Column tunnus has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is H-2748 and maximum string is V-6003.
rataosoitt string Data source did not contain a description for RATAOSOITT. Column is empty.
sijaintiku string Data source did not contain a description for SIJAINTIKU. Column sijaintiku has 398 rows, out of which 3 are empty, making the null percent 0.75. Minimum string is and maximum string is tunnus:915,nimi:Varkaus.
tieosoitte string Data source did not contain a description for TIEOSOITTE. Column tieosoitte has 398 rows, out of which 203 are empty, making the null percent 51.01. First 25 characters of minimum string: ... and first 25 characters of maximum string: tienumero:9452,tieosa:1,e...
nimi string Data source did not contain a description for NIMI. Column nimi has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aaslan lauttapaikka and maximum string is Österskärin laituri.
nykyinenku string Data source did not contain a description for NYKYINENKU. Column nykyinenku has 398 rows, out of which 40 are empty, making the null percent 10.05. Minimum string is and maximum string is nimi:Yksityinen.
vesivaylao string Data source did not contain a description for VESIVAYLAO. Column vesivaylao has 398 rows, out of which 389 are empty, making the null percent 97.74. First 25 characters of minimum string: ... and first 25 characters of maximum string: nimi:SALMI OULUJÄRVESSÄ,s...
paivitetty timestamp Data source did not contain a description for PAIVITETTY. Column paivitetty has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2019-02-04 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 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: tunnus:LR,nimi:Laituri.
sijaintisu string Data source did not contain a description for SIJAINTISU. Column sijaintisu has 398 rows, out of which 335 are empty, making the null percent 84.17. Minimum string is and maximum string is tunnus:W,nimi:W.
rakennetyy string Data source did not contain a description for RAKENNETYY. Column rakennetyy has 398 rows, out of which 359 are empty, making the null percent 90.20. First 25 characters of minimum string: ... and first 25 characters of maximum string: nimi:Teräsbetoninen , ter...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 398 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.15711366719817 ... and first 25 characters of maximum string: POINT (30.238302446282677...
geom_center_x float Longitude of center. Column geom_center_x has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.16 and maximum value is 30.24.
geom_center_y float Latitude of center. Column geom_center_y has 398 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.79 and maximum value is 66.58.
geom_type string Geometry type. Column geom_type has 398 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 May 12, 2022
Created September 11, 2020