To download the data set, please sign up or log in
Maankäyttö:Osoite:Osoite
Tables
-
Osoite, Mkososoite, Full historyTSV
No description available for layer mkos:Osoite (Maankäyttö:Osoite:Osoite)
-
Osoite, Mkososoite, LatestTSV
No description available for layer mkos:Osoite (Maankäyttö:Osoite:Osoite)
Column Descriptions
Osoite, Mkososoite, Full history
| Column | Type | Comment |
|---|---|---|
| gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is osoite.100016480 and maximum string is osoite.99900295. |
| yksilointitieto | int | Data source did not contain a description for yksilointitieto. Column yksilointitieto has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22595229 and maximum value is 486993135. |
| alkuhetki | timestamp | Data source did not contain a description for alkuHetki. Column alkuhetki has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001-05-12 15:08:47 and maximum value is 2020-09-10 09:10:09. |
| kunta | int | Data source did not contain a description for kunta. Column kunta has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum value is 49 and maximum value is 235. |
| teksti | string | Data source did not contain a description for teksti. Column teksti has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum string is and maximum string is Örkkirinne. |
| osoitenumero | int | Data source did not contain a description for osoitenumero. Column osoitenumero has 36346 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 566. |
| osoitenumero2 | int | Data source did not contain a description for osoitenumero2. Column osoitenumero2 has 36346 rows, out of which 5348 are empty, making the null percent 14.71. Minimum value is 1 and maximum value is 566. |
| postinumero | int | Data source did not contain a description for postinumero. Column postinumero has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum value is 370 and maximum value is 2980. |
| postitoimipaikannimi | string | Data source did not contain a description for postitoimipaikannimi. Column postitoimipaikannimi has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum string is and maximum string is VANTAA. |
| tila | string | Data source did not contain a description for tila. Column tila has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: voimassa. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 36346 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 (24.5038748 60.3216... and first 25 characters of maximum string: POINT (24.849768 60.22406... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.50 and maximum value is 24.85. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.08 and maximum value is 60.36. |
| geom_type | string | Geometry type. Column geom_type has 36346 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. |
Osoite, Mkososoite, Latest
| Column | Type | Comment |
|---|---|---|
| gml_id | string | Data source did not contain a description for gml_id. Column gml_id has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is osoite.100016480 and maximum string is osoite.99900295. |
| yksilointitieto | int | Data source did not contain a description for yksilointitieto. Column yksilointitieto has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 22595229 and maximum value is 486993135. |
| alkuhetki | timestamp | Data source did not contain a description for alkuHetki. Column alkuhetki has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2001-05-12 15:08:47 and maximum value is 2020-09-10 09:10:09. |
| kunta | int | Data source did not contain a description for kunta. Column kunta has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum value is 49 and maximum value is 235. |
| teksti | string | Data source did not contain a description for teksti. Column teksti has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum string is and maximum string is Örkkirinne. |
| osoitenumero | int | Data source did not contain a description for osoitenumero. Column osoitenumero has 36346 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 566. |
| osoitenumero2 | int | Data source did not contain a description for osoitenumero2. Column osoitenumero2 has 36346 rows, out of which 5348 are empty, making the null percent 14.71. Minimum value is 1 and maximum value is 566. |
| postinumero | int | Data source did not contain a description for postinumero. Column postinumero has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum value is 370 and maximum value is 2980. |
| postitoimipaikannimi | string | Data source did not contain a description for postitoimipaikannimi. Column postitoimipaikannimi has 36346 rows, out of which 4 are empty, making the null percent 0.01. Minimum string is and maximum string is VANTAA. |
| tila | string | Data source did not contain a description for tila. Column tila has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: voimassa. |
| geom_geojson | string | Geometry in GeoJSON format. |
| geom_geotext | string | Geometry as GeoText. Column geom_geotext has 36346 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 (24.5038748 60.3216... and first 25 characters of maximum string: POINT (24.849768 60.22406... |
| geom_center_x | float | Longitude of center. Column geom_center_x has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 24.50 and maximum value is 24.85. |
| geom_center_y | float | Latitude of center. Column geom_center_y has 36346 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 60.08 and maximum value is 60.36. |
| geom_type | string | Geometry type. Column geom_type has 36346 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. |
Additional Info
| Last Updated | September 11, 2020 |
|---|---|
| Created | September 8, 2020 |