To download the data set, please sign up or log in
Lipas 4402 latu
Tables
-
Lipas 4402 latu, Lipaslipas 4402 latu, Full historyTSV
No description available for layer lipas:lipas_4402_latu (lipas_4402_latu)
-
Lipas 4402 latu, Lipaslipas 4402 latu, LatestTSV
No description available for layer lipas:lipas_4402_latu (lipas_4402_latu)
Column Descriptions
Lipas 4402 latu, Lipaslipas 4402 latu, Latest
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91936 and maximum value is 604006. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 3km ja 5km kilpalatu... and first 25 characters of maximum string: Öjskogin puiston valaistu... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 17366 rows, out of which 16579 are empty, making the null percent 95.47. First 25 characters of minimum string: ... and first 25 characters of maximum string: Åggelby konditionsbana sk... |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 17366 rows, out of which 16843 are empty, making the null percent 96.99. Minimum string is and maximum string is Ylipään valaistulatu. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 17366 rows, out of which 11261 are empty, making the null percent 64.85. Minimum string is and maximum string is yhteispalvelu@kurikka.fi. |
| www | string | Data source did not contain a description for www. Column www has 17366 rows, out of which 3290 are empty, making the null percent 18.95. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.ylivieska.fi/latukart... |
| puhelinnum | int | Data source did not contain a description for puhelinnum. Column puhelinnum has 17366 rows, out of which 16166 are empty, making the null percent 93.09. Minimum value is 983911 and maximum value is 624132000. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 17366 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 T. |
| vapaa_kayt | string | Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 17366 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 T. |
| rakennusvu | int | Data source did not contain a description for rakennusvu. Column rakennusvu has 17366 rows, out of which 9516 are empty, making the null percent 54.80. Minimum value is 0 and maximum value is 2020. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 17366 rows, out of which 17068 are empty, making the null percent 98.28. Minimum value is 1979 and maximum value is 2019. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 17366 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 17366 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 17366 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 Överpurmontie 600. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 240 and maximum value is 99950. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 17366 rows, out of which 1827 are empty, making the null percent 10.52. Minimum string is and maximum string is Överpurmo. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 17366 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. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 17366 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. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 17366 rows, out of which 14085 are empty, making the null percent 81.11. Minimum string is and maximum string is Ylästö. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4402. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Latu. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| reitti_id | int | Data source did not contain a description for reitti_id. Column reitti_id has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 29778 and maximum value is 512568. |
| reitin_lev | int | Data source did not contain a description for reitin_lev. Column reitin_lev has 17366 rows, out of which 16172 are empty, making the null percent 93.12. Minimum value is 1 and maximum value is 9. |
| ampumapaik | int | Data source did not contain a description for ampumapaik. Column ampumapaik has 17366 rows, out of which 13314 are empty, making the null percent 76.67. Minimum value is 0 and maximum value is 30. |
| taukopaika | int | Data source did not contain a description for taukopaika. Column taukopaika has 17366 rows, out of which 11308 are empty, making the null percent 65.12. Minimum value is 0 and maximum value is 15. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 17366 rows, out of which 8548 are empty, making the null percent 49.22. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ämmänssari-Ukkohalla n.54... |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 17366 rows, out of which 16767 are empty, making the null percent 96.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Varastolumilatu (tykkilum... |
| latu_perin | boolean | Data source did not contain a description for latu_perin. |
| valaistua | int | Data source did not contain a description for valaistua. Column valaistua has 17366 rows, out of which 6034 are empty, making the null percent 34.75. Minimum value is 0 and maximum value is 700. |
| reitin_pit | float | Data source did not contain a description for reitin_pit. Column reitin_pit has 17366 rows, out of which 1975 are empty, making the null percent 11.37. Minimum value is 0.00 and maximum value is 105.00. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 17366 rows, out of which 12736 are empty, making the null percent 73.34. Minimum string is and maximum string is Vesi. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| kuntoilute | boolean | Data source did not contain a description for kuntoilute. |
| latu_vapaa | boolean | Data source did not contain a description for latu_vapaa. |
| saa_julkai | boolean | Data source did not contain a description for saa_julkai. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 17366 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 (19.5830696193... and first 25 characters of maximum string: LINESTRING (31.1005989907... |
| 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 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING. |
Lipas 4402 latu, Lipaslipas 4402 latu, Full history
| Column | Type | Comment |
|---|---|---|
| id | int | Data source did not contain a description for id. Column id has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 91936 and maximum value is 604006. |
| nimi_fi | string | Data source did not contain a description for nimi_fi. Column nimi_fi has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: 3km ja 5km kilpalatu... and first 25 characters of maximum string: Öjskogin puiston valaistu... |
| nimi_se | string | Data source did not contain a description for nimi_se. Column nimi_se has 17366 rows, out of which 16579 are empty, making the null percent 95.47. First 25 characters of minimum string: ... and first 25 characters of maximum string: Åggelby konditionsbana sk... |
| nimi_en | string | Data source did not contain a description for nimi_en. Column nimi_en has 17366 rows, out of which 16843 are empty, making the null percent 96.99. Minimum string is and maximum string is Ylipään valaistulatu. |
| sahkoposti | string | Data source did not contain a description for sahkoposti. Column sahkoposti has 17366 rows, out of which 11261 are empty, making the null percent 64.85. Minimum string is and maximum string is yhteispalvelu@kurikka.fi. |
| www | string | Data source did not contain a description for www. Column www has 17366 rows, out of which 3290 are empty, making the null percent 18.95. First 25 characters of minimum string: ... and first 25 characters of maximum string: www.ylivieska.fi/latukart... |
| puhelinnum | int | Data source did not contain a description for puhelinnum. Column puhelinnum has 17366 rows, out of which 16166 are empty, making the null percent 93.09. Minimum value is 983911 and maximum value is 624132000. |
| koulun_lii | string | Data source did not contain a description for koulun_lii. Column koulun_lii has 17366 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 T. |
| vapaa_kayt | string | Data source did not contain a description for vapaa_kayt. Column vapaa_kayt has 17366 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 T. |
| rakennusvu | int | Data source did not contain a description for rakennusvu. Column rakennusvu has 17366 rows, out of which 9516 are empty, making the null percent 54.80. Minimum value is 0 and maximum value is 2020. |
| peruskorja | int | Data source did not contain a description for peruskorja. Column peruskorja has 17366 rows, out of which 17068 are empty, making the null percent 98.28. Minimum value is 1979 and maximum value is 2019. |
| omistaja | string | Data source did not contain a description for omistaja. Column omistaja has 17366 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 17366 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 17366 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 Överpurmontie 600. |
| postinumer | int | Data source did not contain a description for postinumer. Column postinumer has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 240 and maximum value is 99950. |
| postitoimi | string | Data source did not contain a description for postitoimi. Column postitoimi has 17366 rows, out of which 1827 are empty, making the null percent 10.52. Minimum string is and maximum string is Överpurmo. |
| kunta_nimi | string | Data source did not contain a description for kunta_nimi. Column kunta_nimi has 17366 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. |
| kuntanumer | int | Data source did not contain a description for kuntanumer. Column kuntanumer has 17366 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. |
| kuntaosa | string | Data source did not contain a description for kuntaosa. Column kuntaosa has 17366 rows, out of which 14085 are empty, making the null percent 81.11. Minimum string is and maximum string is Ylästö. |
| tyyppikood | int | Data source did not contain a description for tyyppikood. Column tyyppikood has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Constant value is 4402. |
| tyyppi_nim | string | Data source did not contain a description for tyyppi_nim. Column tyyppi_nim has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: Latu. |
| muokattu_v | date | Data source did not contain a description for muokattu_v. Column is empty. |
| reitti_id | int | Data source did not contain a description for reitti_id. Column reitti_id has 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 29778 and maximum value is 512568. |
| reitin_lev | int | Data source did not contain a description for reitin_lev. Column reitin_lev has 17366 rows, out of which 16172 are empty, making the null percent 93.12. Minimum value is 1 and maximum value is 9. |
| ampumapaik | int | Data source did not contain a description for ampumapaik. Column ampumapaik has 17366 rows, out of which 13314 are empty, making the null percent 76.67. Minimum value is 0 and maximum value is 30. |
| taukopaika | int | Data source did not contain a description for taukopaika. Column taukopaika has 17366 rows, out of which 11308 are empty, making the null percent 65.12. Minimum value is 0 and maximum value is 15. |
| lisatieto | string | Data source did not contain a description for lisatieto. Column lisatieto has 17366 rows, out of which 8548 are empty, making the null percent 49.22. First 25 characters of minimum string: ... and first 25 characters of maximum string: Ämmänssari-Ukkohalla n.54... |
| pintamater | string | Data source did not contain a description for pintamater. Column pintamater has 17366 rows, out of which 16767 are empty, making the null percent 96.55. First 25 characters of minimum string: ... and first 25 characters of maximum string: Varastolumilatu (tykkilum... |
| latu_perin | boolean | Data source did not contain a description for latu_perin. |
| valaistua | int | Data source did not contain a description for valaistua. Column valaistua has 17366 rows, out of which 6034 are empty, making the null percent 34.75. Minimum value is 0 and maximum value is 700. |
| reitin_pit | float | Data source did not contain a description for reitin_pit. Column reitin_pit has 17366 rows, out of which 1975 are empty, making the null percent 11.37. Minimum value is 0.00 and maximum value is 105.00. |
| pintamate0 | string | Data source did not contain a description for pintamate0. Column pintamate0 has 17366 rows, out of which 12736 are empty, making the null percent 73.34. Minimum string is and maximum string is Vesi. |
| yleiso_wc | boolean | Data source did not contain a description for yleiso_wc. |
| kuntoilute | boolean | Data source did not contain a description for kuntoilute. |
| latu_vapaa | boolean | Data source did not contain a description for latu_vapaa. |
| saa_julkai | boolean | Data source did not contain a description for saa_julkai. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 17366 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 (19.5830696193... and first 25 characters of maximum string: LINESTRING (31.1005989907... |
| 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 17366 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: ST_LINESTRING. |
| orig_extractdate | string | The date when the data was originally fetched from the source. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | June 16, 2018 |