To download the data set, please sign up or log in
Hankekartta tiehankkeet
Tables
-
Hankekartta tiehankkeet, Avoinhankekartta tiehankkeet, Full historyTSV
No description available for layer avoin:hankekartta_tiehankkeet (hankekartta_tiehankkeet)
-
Hankekartta tiehankkeet, Avoinhankekartta tiehankkeet, LatestTSV
No description available for layer avoin:hankekartta_tiehankkeet (hankekartta_tiehankkeet)
Column Descriptions
Hankekartta tiehankkeet, Avoinhankekartta tiehankkeet, Full history
| Column | Type | Comment |
|---|---|---|
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hailuodon kiinteä yhteys,... and first 25 characters of maximum string: Vt 5 Mikkeli - Juva... |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 21 rows, out of which 18 are empty, making the null percent 85.71. Minimum string is and maximum string is Kaarina/Lieto. |
| aloitusvuo | int | Data source did not contain a description for ALOITUSVUO. Column aloitusvuo has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2016 and maximum value is 2020. |
| lopetusvuo | int | Data source did not contain a description for LOPETUSVUO. Column lopetusvuo has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020 and maximum value is 2023. |
| linkki | string | Data source did not contain a description for LINKKI. Column linkki has 21 rows, out of which 3 are empty, making the null percent 14.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://vayla.fi/vt-5-mik... |
| kustannusa | float | Data source did not contain a description for KUSTANNUSA. Column kustannusa has 21 rows, out of which 1 are empty, making the null percent 4.76. Minimum value is 0.81 and maximum value is 275.00. |
| kuvaus | string | Data source did not contain a description for KUVAUS. Column kuvaus has 21 rows, out of which 3 are empty, making the null percent 14.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: Väylävirasto toteuttaa ha... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 21 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.3474693686... and first 25 characters of maximum string: MULTILINESTRING ((27.3039... |
| 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 21 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 tiehankkeet, Avoinhankekartta tiehankkeet, Latest
| Column | Type | Comment |
|---|---|---|
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hailuodon kiinteä yhteys,... and first 25 characters of maximum string: Vt 5 Mikkeli - Juva... |
| kunta | string | Data source did not contain a description for KUNTA. Column kunta has 21 rows, out of which 18 are empty, making the null percent 85.71. Minimum string is and maximum string is Kaarina/Lieto. |
| aloitusvuo | int | Data source did not contain a description for ALOITUSVUO. Column aloitusvuo has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2016 and maximum value is 2020. |
| lopetusvuo | int | Data source did not contain a description for LOPETUSVUO. Column lopetusvuo has 21 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2020 and maximum value is 2023. |
| linkki | string | Data source did not contain a description for LINKKI. Column linkki has 21 rows, out of which 3 are empty, making the null percent 14.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://vayla.fi/vt-5-mik... |
| kustannusa | float | Data source did not contain a description for KUSTANNUSA. Column kustannusa has 21 rows, out of which 1 are empty, making the null percent 4.76. Minimum value is 0.81 and maximum value is 275.00. |
| kuvaus | string | Data source did not contain a description for KUVAUS. Column kuvaus has 21 rows, out of which 3 are empty, making the null percent 14.29. First 25 characters of minimum string: ... and first 25 characters of maximum string: Väylävirasto toteuttaa ha... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 21 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.3474693686... and first 25 characters of maximum string: MULTILINESTRING ((27.3039... |
| 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 21 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 |