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