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

Estonia Postal Code Profile

Estonia Postal Code Profile

Tables

  • Fi sdh, postalcode profile estonia profile, all observedTSV

    Estonia postal code areas with geometry information including the full history of all dataset versions. The column valuedate specifies the dataset version. The postal code areas, their names and geometries are algorithmically generated and therefore approximations of the real postal code areas in Estonia. The data sources include Geoportal, OpenAddresses and OpenStreetMap.

  • Fi sdh, postalcode profile estonia profile, latest observedTSV

    The latest version of Estonia postal code areas with geometry information. The postal code areas, their names and geometries are algorithmically generated and therefore approximations of the real postal code areas in Estonia. The data sources include Estonia Geoportal, OpenAddresses and OpenStreetMap.

Column Descriptions

Fi sdh, postalcode profile estonia profile, latest observed

Column Type Comment
country string Country as 2-digit ISO 3166-1 alpha-2 code. Column country has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: EE.
postalcode string Postal code. Column postalcode has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 10001 and maximum string is 96149.
name string Postal code area name. Column name has 5455 rows, out of which 13 are empty, making the null percent 0.24. Minimum string is and maximum string is Öötla.
geom_geotext string Postal code area geometry in Well-Known Text (WKT) format. Geometry may be a polygon, multipolygon or point. Geometry is a point for administrative areas and when area is not known. Column geom_geotext has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((21.871432... and first 25 characters of maximum string: POLYGON ((28.196475489146...
valuedate_start date Validity date range of the data, start date. For algorithmically created datasets the validity date is the creation date of the dataset.
valuedate_end date Validity date range of the data, end date. For algorithmically created datasets the validity date is the creation date of the dataset.
valuedate date Validity date of the data. For algorithmically created datasets the validity date is the creation date of the dataset.
geom_geojson string Geometry as GeoJSON.
geom_center_x float Longitude of center. Column geom_center_x has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.87 and maximum value is 28.20.
geom_center_y float Latitude of center. Column geom_center_y has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 57.54 and maximum value is 59.69.
geom_type string Geometry type. Column geom_type has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.

Fi sdh, postalcode profile estonia profile, all observed

Column Type Comment
country string Country as 2-digit ISO 3166-1 alpha-2 code. Column country has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. The single string value is: EE.
postalcode string Postal code. Column postalcode has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is 10001 and maximum string is 96149.
name string Postal code area name. Column name has 5455 rows, out of which 13 are empty, making the null percent 0.24. Minimum string is and maximum string is Öötla.
geom_geotext string Postal code area geometry in Well-Known Text (WKT) format. Geometry may be a polygon, multipolygon or point. Geometry is a point for administrative areas and when area is not known. Column geom_geotext has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. First 25 characters of minimum string: MULTIPOLYGON (((21.871432... and first 25 characters of maximum string: POLYGON ((28.196475489146...
valuedate_start date Validity date range of the data, start date. For algorithmically created datasets the validity date is the creation date of the dataset.
valuedate_end date Validity date range of the data, end date. For algorithmically created datasets the validity date is the creation date of the dataset.
valuedate date Validity date of the data. For algorithmically created datasets the validity date is the creation date of the dataset.
geom_geojson string Geometry as GeoJSON.
geom_center_x float Longitude of center. Column geom_center_x has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 21.87 and maximum value is 28.20.
geom_center_y float Latitude of center. Column geom_center_y has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum value is 57.54 and maximum value is 59.69.
geom_type string Geometry type. Column geom_type has 5455 rows, out of which 0 are empty, making the null percent 0.00. The column is fully populated. Minimum string is ST_MULTIPOLYGON and maximum string is ST_POLYGON.
orig_extractdate string The date when the data was originally fetched from the source.

Additional Info

Last Updated April 2, 2021
Created April 2, 2021