To download the data set, please sign up or log in

Osoite

Osoite

Tables

Column Descriptions

Osoite, Mkososoite

Column Type Comment
gml_id string Data source did not contain a description for gml_id. Column gml_id has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is osoite.398198139 and maximum string is osoite.410866001.
yksilointitieto int Data source did not contain a description for yksilointitieto. Column yksilointitieto has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 398198139 and maximum value is 515440392.
alkuhetki timestamp Data source did not contain a description for alkuHetki. Column alkuhetki has 100 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 2016-09-16 07:18:43 and maximum value is 2018-11-21 07:33:02.
teksti_lang string Data source did not contain a description for teksti_lang. Column teksti_lang has 100 rows, out of which 44 are empty, making the null percent 44.00. The single string value is: .
teksti string Data source did not contain a description for teksti. Column teksti has 100 rows, out of which 44 are empty, making the null percent 44.00. Minimum string is and maximum string is Jyväkuja.
osoitenumero int Data source did not contain a description for osoitenumero. Column osoitenumero has 100 rows, out of which 57 are empty, making the null percent 57.00. Minimum value is 1 and maximum value is 1054.
postinumero int Data source did not contain a description for postinumero. Column postinumero has 100 rows, out of which 41 are empty, making the null percent 41.00. Minimum value is 80100 and maximum value is 82220.
postitoimipaikannimi string Data source did not contain a description for postitoimipaikannimi. Column postitoimipaikannimi has 100 rows, out of which 41 are empty, making the null percent 41.00. Minimum string is and maximum string is REIJOLA.
kunta int Data source did not contain a description for kunta. Column kunta has 100 rows, out of which 97 are empty, making the null percent 97.00. Constant value is 167.
geom_geojson string Geometry in GeoJSON format.
geom_geotext string Geometry as GeoText. Column geom_geotext has 100 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 (29.6835524 62.6299... and first 25 characters of maximum string: POINT (29.8404775 62.5258...
geom_center_x double Longitude of the centroid of the geometry. Column is empty.
geom_center_y double Latitude of the centroid of the geometry. Column is empty.
geom_type string Geometry type. Column geom_type has 100 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 April 12, 2019
Created November 25, 2018