Hankekartta tiesuunnitelmat v
Tables
-
Hankekartta tiesuunnitelmat v, Avoinhankekartta tiesuunnitelmat v, Full historyTSV
Toteutukseen tähtäävät hankesuunnittelukohteet, tieosuudet.
-
Hankekartta tiesuunnitelmat v, Avoinhankekartta tiesuunnitelmat v, LatestTSV
Toteutukseen tähtäävät hankesuunnittelukohteet, tieosuudet.
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 |