To download the data set, please sign up or log in
Helsinki tiet mml 100 k
Tables
-
Helsinki tiet mml 100k, Faris testhelsinki tiet mml 100k, Full historyTSV
helsinki_tiet_mml_100k
-
Helsinki tiet mml 100k, Faris testhelsinki tiet mml 100k, LatestTSV
helsinki_tiet_mml_100k
Column Descriptions
Helsinki tiet mml 100k, Faris testhelsinki tiet mml 100k, Latest
| Column | Type | Comment |
|---|---|---|
| kohderyhma | int | Data source did not contain a description for Kohderyhma. Column kohderyhma has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 25. |
| vertikaali | int | Data source did not contain a description for Vertikaali. Column vertikaali has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -11 and maximum value is 1. |
| kohdeluokk | int | Data source did not contain a description for Kohdeluokk. Column kohdeluokk has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12111 and maximum value is 12141. |
| tieluokka | int | Data source did not contain a description for Tieluokka. Column tieluokka has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -29999 and maximum value is 6. |
| valmiusast | int | Data source did not contain a description for Valmiusast. Column valmiusast has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| tienumero | int | Data source did not contain a description for Tienumero. Column tienumero has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 40915. |
| paallyste | int | Data source did not contain a description for Paallyste. Column paallyste has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2. |
| yksisuunta | int | Data source did not contain a description for Yksisuunta. Column yksisuunta has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2. |
| ajorataluk | int | Data source did not contain a description for Ajorataluk. Column ajorataluk has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 4. |
| id | int | Data source did not contain a description for ID. Column id has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 54. |
| tunnus | int | Data source did not contain a description for TUNNUS. Column tunnus has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 801. |
| suurpiiri | int | Data source did not contain a description for SUURPIIRI. Column suurpiiri has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 8. |
| kunta | int | Data source did not contain a description for KUNTA. Column kunta has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91. |
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ALPPIHARJU and maximum string is ÖSTERSUNDOM. |
| nimi_se | string | Data source did not contain a description for NIMI_SE. Column nimi_se has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is BERGHÄLL and maximum string is ÖSTRA BAGGBÖLE. |
| suurpiir00 | string | Data source did not contain a description for SUURPIIR00. Column suurpiir00 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ETELÄINEN and maximum string is ÖSTERSUNDOM. |
| suurpiir01 | string | Data source did not contain a description for SUURPIIR01. Column suurpiir01 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MELLERSTA and maximum string is ÖSTRA. |
| kunta_nimi | string | Data source did not contain a description for KUNTA_NIMI. Column kunta_nimi has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: HELSINKI. |
| kunta_ni00 | string | Data source did not contain a description for KUNTA_NI00. Column kunta_ni00 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: HELSINGFORS. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 7577 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 (24.8327191553... and first 25 characters of maximum string: MULTILINESTRING ((25.0773... |
| 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 7577 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. |
Helsinki tiet mml 100k, Faris testhelsinki tiet mml 100k, Full history
| Column | Type | Comment |
|---|---|---|
| kohderyhma | int | Data source did not contain a description for Kohderyhma. Column kohderyhma has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 25. |
| vertikaali | int | Data source did not contain a description for Vertikaali. Column vertikaali has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -11 and maximum value is 1. |
| kohdeluokk | int | Data source did not contain a description for Kohdeluokk. Column kohdeluokk has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 12111 and maximum value is 12141. |
| tieluokka | int | Data source did not contain a description for Tieluokka. Column tieluokka has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is -29999 and maximum value is 6. |
| valmiusast | int | Data source did not contain a description for Valmiusast. Column valmiusast has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 3. |
| tienumero | int | Data source did not contain a description for Tienumero. Column tienumero has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 40915. |
| paallyste | int | Data source did not contain a description for Paallyste. Column paallyste has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 2. |
| yksisuunta | int | Data source did not contain a description for Yksisuunta. Column yksisuunta has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 0 and maximum value is 2. |
| ajorataluk | int | Data source did not contain a description for Ajorataluk. Column ajorataluk has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 4. |
| id | int | Data source did not contain a description for ID. Column id has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21 and maximum value is 54. |
| tunnus | int | Data source did not contain a description for TUNNUS. Column tunnus has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 101 and maximum value is 801. |
| suurpiiri | int | Data source did not contain a description for SUURPIIRI. Column suurpiiri has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1 and maximum value is 8. |
| kunta | int | Data source did not contain a description for KUNTA. Column kunta has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 91. |
| nimi | string | Data source did not contain a description for NIMI. Column nimi has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ALPPIHARJU and maximum string is ÖSTERSUNDOM. |
| nimi_se | string | Data source did not contain a description for NIMI_SE. Column nimi_se has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is BERGHÄLL and maximum string is ÖSTRA BAGGBÖLE. |
| suurpiir00 | string | Data source did not contain a description for SUURPIIR00. Column suurpiir00 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ETELÄINEN and maximum string is ÖSTERSUNDOM. |
| suurpiir01 | string | Data source did not contain a description for SUURPIIR01. Column suurpiir01 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is MELLERSTA and maximum string is ÖSTRA. |
| kunta_nimi | string | Data source did not contain a description for KUNTA_NIMI. Column kunta_nimi has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: HELSINKI. |
| kunta_ni00 | string | Data source did not contain a description for KUNTA_NI00. Column kunta_ni00 has 7577 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: HELSINGFORS. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 7577 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 (24.8327191553... and first 25 characters of maximum string: MULTILINESTRING ((25.0773... |
| 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 7577 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. |
Additional Info
| Last Updated | September 9, 2020 |
|---|---|
| Created | September 9, 2020 |