Collection of Geospatial Data for Coastal Areas in Sweden sourced from Helsingin kaupunkiympariston toimiala, Finland

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Geographical Names of Coastal Areas in SwedenTSV
This table contains data sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from Finland. It represents the avoindataseutukartta_nimisto_merialue_ruotsi__seutukartta_nimisto_merialue_ruotsipoint dataset. The table includes various columns such as _extract_date, _row_number, nimi_r, ikoord, pkoord, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, geom, and tietopalve. These columns contain information that can be utilized in various data analytics tasks such as spatial analysis, centroid calculation, and geotext processing.
Historical Version of the Swedish-language Coastal Area Nomenclature Dataset on the Open Data District Map - Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of the rows in the 'avoindataseutukartta_nimisto_merialue_ruotsi__seutukartta_nimisto_merialue_ruotsipoint' base table. The rows in this table represent different versions of the data extracted from the data source provided by 'Helsinki City Environment Department' in the country Finland (ISO country code: fi). The '_start_date' column indicates the date when the row was extracted, while the '_end_date' column shows the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row represents the most recent version of the data. The table contains additional columns such as '_row_number', 'nimi_r', 'ikoord', 'pkoord', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid',...

Column Descriptions

Geographical Names of Coastal Areas in Sweden

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
nimi_r	string	The name of the entity.
ikoord	int	The X-coordinate of the entity.
pkoord	int	The Y-coordinate of the entity.
geom_geojson	string	The geometry of the entity in GeoJSON format.
geom_geotext	string	The geometry of the entity in Geotext format.
geom_type	string	The type of geometry.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The X-coordinate of the center of the geometry.
geom_center_y	double	The Y-coordinate of the center of the geometry.
geom	binary	The geometry of the entity.
tietopalve	int	The service information.

Historical Version of the Swedish-language Coastal Area Nomenclature Dataset on the Open Data District Map - Helsingin kaupunkiympariston toimiala (Finland)

Column	Type	Comment
_start_date	date	The starting date of the validity period of the row version.
_end_date	date	The ending date of the validity period of the row version.
_row_number	long	The number assigned to the row version.
nimi_r	string	The name of the row version.
ikoord	int	The x-coordinate value of the row version.
pkoord	int	The y-coordinate value of the row version.
geom_geojson	string	The geometry in GeoJSON format of the row version.
geom_geotext	string	The geometry in Geotext format of the row version.
geom_type	string	The type of geometry for the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The x-coordinate value of the center of the geometry of the row version.
geom_center_y	double	The y-coordinate value of the center of the geometry of the row version.
geom	binary	The geometry of the row version.
tietopalve	int	The data service of the row version.

Additional Info

Last Updated	April 23, 2024
Created	May 6, 2018