To download the data set, please sign up or log in
Hankekartta ratahankkeet
Tables
-
Hankekartta ratahankkeet, Avoinhankekartta ratahankkeet, Full historyTSV
No description available for layer avoin:hankekartta_ratahankkeet (hankekartta_ratahankkeet)
-
Hankekartta ratahankkeet, Avoinhankekartta ratahankkeet, LatestTSV
No description available for layer avoin:hankekartta_ratahankkeet (hankekartta_ratahankkeet)
Column Descriptions
Hankekartta ratahankkeet, Avoinhankekartta ratahankkeet, Full history
| Column | Type | Comment |
|---|---|---|
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 16 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 raakapuuterminaali... and first 25 characters of maximum string: Turku-Uusikaupunki rataos... |
| aloitusvuo | int | Data source did not contain a description for ALOITUSVUO. Column aloitusvuo has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014 and maximum value is 2020. |
| lopetusvuo | int | Data source did not contain a description for LOPETUSVUO. Column lopetusvuo has 16 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 2024. |
| linkki | string | Data source did not contain a description for LINKKI. Column linkki has 16 rows, out of which 3 are empty, making the null percent 18.75. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://vayla.fi/luumaki-... |
| kustannusa | int | Data source did not contain a description for KUSTANNUSA. Column kustannusa has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8 and maximum value is 193. |
| kuvaus | string | Data source did not contain a description for KUVAUS. Column kuvaus has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hanke sisältää rataosuude... and first 25 characters of maximum string: Sähköistyshanke sisältää ... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 16 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.2472719331... 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 16 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 ratahankkeet, Avoinhankekartta ratahankkeet, Latest
| Column | Type | Comment |
|---|---|---|
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 16 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 raakapuuterminaali... and first 25 characters of maximum string: Turku-Uusikaupunki rataos... |
| aloitusvuo | int | Data source did not contain a description for ALOITUSVUO. Column aloitusvuo has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2014 and maximum value is 2020. |
| lopetusvuo | int | Data source did not contain a description for LOPETUSVUO. Column lopetusvuo has 16 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 2024. |
| linkki | string | Data source did not contain a description for LINKKI. Column linkki has 16 rows, out of which 3 are empty, making the null percent 18.75. First 25 characters of minimum string: ... and first 25 characters of maximum string: https://vayla.fi/luumaki-... |
| kustannusa | int | Data source did not contain a description for KUSTANNUSA. Column kustannusa has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8 and maximum value is 193. |
| kuvaus | string | Data source did not contain a description for KUVAUS. Column kuvaus has 16 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Hanke sisältää rataosuude... and first 25 characters of maximum string: Sähköistyshanke sisältää ... |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 16 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.2472719331... 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 16 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 |