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

Hankekartta tiesuunnitelmat v

Hankekartta tiesuunnitelmat v

Tables

Column Descriptions

Hankekartta tiesuunnitelmat v, Avoinhankekartta tiesuunnitelmat v, Full history

Column Type Comment
nimi string Data source did not contain a description for NIMI. Column nimi has 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: E18 Raision keskusta... and first 25 characters of maximum string: Yt 6450 kevyen liikenteen...
tilaaja string Data source did not contain a description for TILAAJA. Column tilaaja has 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Etelä-Pohjanmaan ELY-kesk... and first 25 characters of maximum string: Varsinais-Suomen ELY-kesk...
tila string Data source did not contain a description for TILA. Column tila has 1033 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 Vanhentunut.
vaihe string Data source did not contain a description for VAIHE. Column vaihe has 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Parantamissuunnitelma and maximum string is Yleissuunnitelma.
maku_indek string Data source did not contain a description for MAKU_INDEK. Column maku_indek has 1033 rows, out of which 414 are empty, making the null percent 40.08. First 25 characters of minimum string: ... and first 25 characters of maximum string: Maku-indeksi 105,30 (2015...
kustannusa float Data source did not contain a description for KUSTANNUSA. Column kustannusa has 1033 rows, out of which 334 are empty, making the null percent 32.33. Minimum value is 0.02 and maximum value is 3593000.00.
kohdesivu string Data source did not contain a description for KOHDESIVU. Column kohdesivu has 1033 rows, out of which 996 are empty, making the null percent 96.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.ely-keskus.fi...
hankeprose string Data source did not contain a description for HANKEPROSE. Column hankeprose has 1033 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 is empty.
hankekortt string Data source did not contain a description for HANKEKORTT. Column hankekortt has 1033 rows, out of which 893 are empty, making the null percent 86.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.vayla.fi/docu...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1033 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 (20.9323234222... and first 25 characters of maximum string: LINESTRING (30.6304798046...
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 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.
orig_extractdate string The date when the data was originally fetched from the source.

Hankekartta tiesuunnitelmat v, Avoinhankekartta tiesuunnitelmat v, Latest

Column Type Comment
nimi string Data source did not contain a description for NIMI. Column nimi has 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: E18 Raision keskusta... and first 25 characters of maximum string: Yt 6450 kevyen liikenteen...
tilaaja string Data source did not contain a description for TILAAJA. Column tilaaja has 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Etelä-Pohjanmaan ELY-kesk... and first 25 characters of maximum string: Varsinais-Suomen ELY-kesk...
tila string Data source did not contain a description for TILA. Column tila has 1033 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 Vanhentunut.
vaihe string Data source did not contain a description for VAIHE. Column vaihe has 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Parantamissuunnitelma and maximum string is Yleissuunnitelma.
maku_indek string Data source did not contain a description for MAKU_INDEK. Column maku_indek has 1033 rows, out of which 414 are empty, making the null percent 40.08. First 25 characters of minimum string: ... and first 25 characters of maximum string: Maku-indeksi 105,30 (2015...
kustannusa float Data source did not contain a description for KUSTANNUSA. Column kustannusa has 1033 rows, out of which 334 are empty, making the null percent 32.33. Minimum value is 0.02 and maximum value is 3593000.00.
kohdesivu string Data source did not contain a description for KOHDESIVU. Column kohdesivu has 1033 rows, out of which 996 are empty, making the null percent 96.42. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.ely-keskus.fi...
hankeprose string Data source did not contain a description for HANKEPROSE. Column hankeprose has 1033 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 is empty.
hankekortt string Data source did not contain a description for HANKEKORTT. Column hankekortt has 1033 rows, out of which 893 are empty, making the null percent 86.45. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://www.vayla.fi/docu...
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 1033 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 (20.9323234222... and first 25 characters of maximum string: LINESTRING (30.6304798046...
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 1033 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING.

Additional Info

Last Updated September 10, 2020
Created September 10, 2020