To download the data set, please sign up or log in
Lipas kaikki pisteet
Tables
-
Lipas kaikki pisteet, Lipaslipas kaikki pisteet, Full historyTSV
No description available for layer lipas:lipas_kaikki_pisteet (lipas_kaikki_pisteet)
-
Lipas kaikki pisteet, Lipaslipas kaikki pisteet, LatestTSV
No description available for layer lipas:lipas_kaikki_pisteet (lipas_kaikki_pisteet)
Column Descriptions
Lipas kaikki pisteet, Lipaslipas kaikki pisteet, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72269 and maximum value is 604097. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 201 and maximum value is 7000. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alamäkiluistelurata... and first 25 characters of maximum string: Yleisurheilun harjoitusal... |
| tyyppi_ni0 | string | Data source did not contain a description for tyyppi_ni0. Column tyyppi_ni0 has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Allaktivitetshall/multiar... and first 25 characters of maximum string: Övningsishall... |
| tyyppi_ni1 | string | Data source did not contain a description for tyyppi_ni1. Column tyyppi_ni1 has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Archery range and maximum string is Volleyball court. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: "Bantis" beachvolleykentt... and first 25 characters of maximum string: Övermark tennisplan... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 32514 rows, out of which 24639 are empty, making the null percent 75.78. Minimum string is and maximum string is Övitsböles volleybollplan. |
| sijainti_i | int | Data source did not contain a description for sijainti_i. Column sijainti_i has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8695 and maximum value is 581718. |
| www | string | Data source did not contain a description for www. Column www has 32514 rows, out of which 8528 are empty, making the null percent 26.23. Minimum string is and maximum string is wwww.kuopio.fi. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 32514 rows, out of which 19265 are empty, making the null percent 59.25. Minimum string is and maximum string is zodiak@zodiak.fi. |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 32514 rows, out of which 14784 are empty, making the null percent 45.47. Minimum string is and maximum string is virve.kiri@kymp.net. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 32514 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 32514 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. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: -... and first 25 characters of maximum string: Övitsbölevägen (Ylästönti... |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 32514 rows, out of which 2 are empty, making the null percent 0.01. Minimum value is 100 and maximum value is 99990. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 32514 rows, out of which 2044 are empty, making the null percent 6.29. Minimum string is and maximum string is Överpurmo. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 32514 rows, out of which 21004 are empty, making the null percent 64.60. First 25 characters of minimum string: ... and first 25 characters of maximum string: Öjan saaristopolun ja Håk... |
| piste_json | string | Data source did not contain a description for piste_json. Column piste_json has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: {"coordinates":[107645.69... and first 25 characters of maximum string: {"type":"Point","coordina... |
| x | float | Data source did not contain a description for x. Column x has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 87479.08 and maximum value is 729733.94. |
| y | float | Data source did not contain a description for y. Column y has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6638331.50 and maximum value is 7776091.50. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.54438689568231 ... and first 25 characters of maximum string: POINT (31.518516168300483... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.54 and maximum value is 31.52. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.82 and maximum value is 70.09. |
| geom_type | string | Geometry type. Column geom_type has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
Lipas kaikki pisteet, Lipaslipas kaikki pisteet, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 72269 and maximum value is 604097. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 201 and maximum value is 7000. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Alamäkiluistelurata... and first 25 characters of maximum string: Yleisurheilun harjoitusal... |
| tyyppi_ni0 | string | Data source did not contain a description for tyyppi_ni0. Column tyyppi_ni0 has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: Allaktivitetshall/multiar... and first 25 characters of maximum string: Övningsishall... |
| tyyppi_ni1 | string | Data source did not contain a description for tyyppi_ni1. Column tyyppi_ni1 has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Archery range and maximum string is Volleyball court. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: "Bantis" beachvolleykentt... and first 25 characters of maximum string: Övermark tennisplan... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 32514 rows, out of which 24639 are empty, making the null percent 75.78. Minimum string is and maximum string is Övitsböles volleybollplan. |
| sijainti_i | int | Data source did not contain a description for sijainti_i. Column sijainti_i has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 8695 and maximum value is 581718. |
| www | string | Data source did not contain a description for www. Column www has 32514 rows, out of which 8528 are empty, making the null percent 26.23. Minimum string is and maximum string is wwww.kuopio.fi. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 32514 rows, out of which 19265 are empty, making the null percent 59.25. Minimum string is and maximum string is zodiak@zodiak.fi. |
| puhelinnum | string | Data source did not contain a description for puhelinnum. Column puhelinnum has 32514 rows, out of which 14784 are empty, making the null percent 45.47. Minimum string is and maximum string is virve.kiri@kymp.net. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 32514 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 32514 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. |
| katuosoite | string | Data source did not contain a description for katuosoite. Column katuosoite has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: -... and first 25 characters of maximum string: Övitsbölevägen (Ylästönti... |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 32514 rows, out of which 2 are empty, making the null percent 0.01. Minimum value is 100 and maximum value is 99990. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 32514 rows, out of which 2044 are empty, making the null percent 6.29. Minimum string is and maximum string is Överpurmo. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 5 and maximum value is 992. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is Akaa and maximum string is Äänekoski. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 32514 rows, out of which 21004 are empty, making the null percent 64.60. First 25 characters of minimum string: ... and first 25 characters of maximum string: Öjan saaristopolun ja Håk... |
| piste_json | string | Data source did not contain a description for piste_json. Column piste_json has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: {"coordinates":[107645.69... and first 25 characters of maximum string: {"type":"Point","coordina... |
| x | float | Data source did not contain a description for x. Column x has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 87479.08 and maximum value is 729733.94. |
| y | float | Data source did not contain a description for y. Column y has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 6638331.50 and maximum value is 7776091.50. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: POINT (19.54438689568231 ... and first 25 characters of maximum string: POINT (31.518516168300483... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 19.54 and maximum value is 31.52. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 59.82 and maximum value is 70.09. |
| geom_type | string | Geometry type. Column geom_type has 32514 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_POINT. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 10, 2020 |
|---|---|
| Created | June 16, 2018 |