To download the data set, please sign up or log in

Hankekartta s rataosuudet

Hankekartta s rataosuudet

Tables

Column Descriptions

Hankekartta s rataosuudet, Avoinhankekartta s rataosuudet, Full history

Column Type Comment
nimi string Data source did not contain a description for NIMI. Column nimi has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaan raakapuuterminaali and maximum string is Turun ratapihat.
tilaaja string Data source did not contain a description for TILAAJA. Column tilaaja has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Väylävirasto.
tila string Data source did not contain a description for TILA. Column tila has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hyväksytty and maximum string is Lainvoimainen.
vaihe string Data source did not contain a description for VAIHE. Column vaihe has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ratasuunnitelma and maximum string is Yleissuunnitelma.
maku_indek string Data source did not contain a description for MAKU_INDEK. Column maku_indek has 22 rows, out of which 6 are empty, making the null percent 27.27. Minimum string is and maximum string is MAKU 130, 2010=100.
kustannusa float Data source did not contain a description for KUSTANNUSA. Column kustannusa has 22 rows, out of which 6 are empty, making the null percent 27.27. Minimum value is 5.80 and maximum value is 1500.00.
kohdesivu string Data source did not contain a description for KOHDESIVU. Column kohdesivu has 22 rows, out of which 8 are empty, making the null percent 36.36. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.vayla.fi/tamp...
hankeprose string Data source did not contain a description for HANKEPROSE. Column hankeprose has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: https://vayla.fi/hankkeid...
kuvaus string Data source did not contain a description for KUVAUS. Column kuvaus has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Akaan raakapuuterminaalin... and first 25 characters of maximum string: Turun ratapihan uudelleen...
hankekortt string Data source did not contain a description for HANKEKORTT. Column hankekortt has 22 rows, out of which 12 are empty, making the null percent 54.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://vayla.fi/document...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 22 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 (22.2633239605... and first 25 characters of maximum string: MULTILINESTRING ((24.9333...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 22 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.
orig_extractdate string The date when the data was originally fetched from the source.

Hankekartta s rataosuudet, Avoinhankekartta s rataosuudet, Latest

Column Type Comment
nimi string Data source did not contain a description for NIMI. Column nimi has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaan raakapuuterminaali and maximum string is Turun ratapihat.
tilaaja string Data source did not contain a description for TILAAJA. Column tilaaja has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Väylävirasto.
tila string Data source did not contain a description for TILA. Column tila has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hyväksytty and maximum string is Lainvoimainen.
vaihe string Data source did not contain a description for VAIHE. Column vaihe has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ratasuunnitelma and maximum string is Yleissuunnitelma.
maku_indek string Data source did not contain a description for MAKU_INDEK. Column maku_indek has 22 rows, out of which 6 are empty, making the null percent 27.27. Minimum string is and maximum string is MAKU 130, 2010=100.
kustannusa float Data source did not contain a description for KUSTANNUSA. Column kustannusa has 22 rows, out of which 6 are empty, making the null percent 27.27. Minimum value is 5.80 and maximum value is 1500.00.
kohdesivu string Data source did not contain a description for KOHDESIVU. Column kohdesivu has 22 rows, out of which 8 are empty, making the null percent 36.36. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.vayla.fi/tamp...
hankeprose string Data source did not contain a description for HANKEPROSE. Column hankeprose has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: https://vayla.fi/hankkeid...
kuvaus string Data source did not contain a description for KUVAUS. Column kuvaus has 22 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Akaan raakapuuterminaalin... and first 25 characters of maximum string: Turun ratapihan uudelleen...
hankekortt string Data source did not contain a description for HANKEKORTT. Column hankekortt has 22 rows, out of which 12 are empty, making the null percent 54.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://vayla.fi/document...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 22 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 (22.2633239605... and first 25 characters of maximum string: MULTILINESTRING ((24.9333...
geom_center_x float Longitude of center. Column is empty.
geom_center_y float Latitude of center. Column is empty.
geom_type string Geometry type. Column geom_type has 22 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 10, 2020
Created September 10, 2020