To download the data set, please sign up or log in
Lipas kaikki alueet
Tables
-
Lipas kaikki alueet, Lipaslipas kaikki alueet, Full historyTSV
No description available for layer lipas:lipas_kaikki_alueet (lipas_kaikki_alueet)
-
Lipas kaikki alueet, Lipaslipas kaikki alueet, LatestTSV
No description available for layer lipas:lipas_kaikki_alueet (lipas_kaikki_alueet)
Column Descriptions
Lipas kaikki alueet, Lipaslipas kaikki alueet, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72252 and maximum value is 604110. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 775 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 4510. |
| tyyppikoo0 | int | Data source did not contain a description for tyyppikoo0. Column tyyppikoo0 has 775 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 4500. |
| tyyppikoo1 | int | Data source did not contain a description for tyyppikoo1. Column tyyppikoo1 has 775 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 4000. |
| sijainti_i | int | Data source did not contain a description for sijainti_i. Column sijainti_i has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30031 and maximum value is 581731. |
| alue_id | int | Data source did not contain a description for alue_id. Column alue_id has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1342 and maximum value is 502469. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - and maximum string is Öjenintie 13. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 775 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 95420. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 775 rows, out of which 121 are empty, making the null percent 15.61. Minimum string is and maximum string is Övermalax. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus and maximum string is Äänekoski. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kansallispuisto and maximum string is Virkistysmetsä. |
| tyyppi_ni0 | string | Data source did not contain a description for tyyppi_ni0. Column tyyppi_ni0 has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Allaktivitetsområde med r... and first 25 characters of maximum string: Utflyktsområde... |
| tyyppi_ni1 | string | Data source did not contain a description for tyyppi_ni1. Column tyyppi_ni1 has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hiking area and maximum string is Tourist services area. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aaltopuisto and maximum string is Övermalax leikkiparkki. |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 775 rows, out of which 398 are empty, making the null percent 51.35. Minimum string is and maximum string is Övermalax lekpark. |
| www | string | Data source did not contain a description for www. Column www has 775 rows, out of which 135 are empty, making the null percent 17.42. Minimum string is and maximum string is www.virpiniemi.fi. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 775 rows, out of which 478 are empty, making the null percent 61.68. Minimum string is and maximum string is ymk@hel.fi. |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 775 rows, out of which 412 are empty, making the null percent 53.16. First 25 characters of minimum string: ... and first 25 characters of maximum string: Maarit Kaitola 0400 86720... |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yritys. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yksityinen / yritys. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 775 rows, out of which 260 are empty, making the null percent 33.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yhteydessä Evon opetusmet... |
| osa_alue_j | string | Data source did not contain a description for osa_alue_j. Column osa_alue_j has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: {"type":"Polygon","coordi... and first 25 characters of maximum string: {"type":"Polygon","coordi... |
| x | float | Data source did not contain a description for x. Column x has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 124182.99 and maximum value is 646850.62. |
| y | float | Data source did not contain a description for y. Column y has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6641813.00 and maximum value is 7364901.00. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((20.230474576755... and first 25 characters of maximum string: POLYGON ((29.778784007556... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20.23 and maximum value is 29.78. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.86 and maximum value is 66.39. |
| geom_type | string | Geometry type. Column geom_type has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON. |
Lipas kaikki alueet, Lipaslipas kaikki alueet, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72252 and maximum value is 604110. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 775 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 4510. |
| tyyppikoo0 | int | Data source did not contain a description for tyyppikoo0. Column tyyppikoo0 has 775 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 4500. |
| tyyppikoo1 | int | Data source did not contain a description for tyyppikoo1. Column tyyppikoo1 has 775 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 4000. |
| sijainti_i | int | Data source did not contain a description for sijainti_i. Column sijainti_i has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 30031 and maximum value is 581731. |
| alue_id | int | Data source did not contain a description for alue_id. Column alue_id has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 1342 and maximum value is 502469. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is - and maximum string is Öjenintie 13. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 775 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 95420. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 775 rows, out of which 121 are empty, making the null percent 15.61. Minimum string is and maximum string is Övermalax. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 10 and maximum value is 992. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Alavus and maximum string is Äänekoski. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Kansallispuisto and maximum string is Virkistysmetsä. |
| tyyppi_ni0 | string | Data source did not contain a description for tyyppi_ni0. Column tyyppi_ni0 has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Allaktivitetsområde med r... and first 25 characters of maximum string: Utflyktsområde... |
| tyyppi_ni1 | string | Data source did not contain a description for tyyppi_ni1. Column tyyppi_ni1 has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Hiking area and maximum string is Tourist services area. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Aaltopuisto and maximum string is Övermalax leikkiparkki. |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 775 rows, out of which 398 are empty, making the null percent 51.35. Minimum string is and maximum string is Övermalax lekpark. |
| www | string | Data source did not contain a description for www. Column www has 775 rows, out of which 135 are empty, making the null percent 17.42. Minimum string is and maximum string is www.virpiniemi.fi. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 775 rows, out of which 478 are empty, making the null percent 61.68. Minimum string is and maximum string is ymk@hel.fi. |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 775 rows, out of which 412 are empty, making the null percent 53.16. First 25 characters of minimum string: ... and first 25 characters of maximum string: Maarit Kaitola 0400 86720... |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yritys. |
| yllapitaja | string | Data source did not contain a description for yllapitaja. Column yllapitaja has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Ei tietoa and maximum string is Yksityinen / yritys. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 775 rows, out of which 260 are empty, making the null percent 33.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Yhteydessä Evon opetusmet... |
| osa_alue_j | string | Data source did not contain a description for osa_alue_j. Column osa_alue_j has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: {"type":"Polygon","coordi... and first 25 characters of maximum string: {"type":"Polygon","coordi... |
| x | float | Data source did not contain a description for x. Column x has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 124182.99 and maximum value is 646850.62. |
| y | float | Data source did not contain a description for y. Column y has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6641813.00 and maximum value is 7364901.00. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POLYGON ((20.230474576755... and first 25 characters of maximum string: POLYGON ((29.778784007556... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 20.23 and maximum value is 29.78. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.86 and maximum value is 66.39. |
| geom_type | string | Geometry type. Column geom_type has 775 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POLYGON. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | September 8, 2020 |