Urban area names in Finland's maritime areas

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

Names of Marine Areas in SwedenTSV
This table contains data related to the sea areas in Sweden, sourced from the website of Helsingin kaupunkiympariston toimiala. It provides information on sea area names, coordinates, geometries, and other attributes. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution of sea areas, calculating the centroid and center coordinates of the geometries, and visualizing the sea areas on a map.
Version History of Marine Area Names in Sweden for District Map Names in Sweden Sourced from the Website of 'City Environment Sector of Helsinki' (Country: Finland)TSV
This table contains the version history of the rows from the base table 'seutukarttanimet_merialueet_ruotsi__nimet_merialueet_ruotsi'. It has additional columns '_start_date' and '_end_date' that represent the extraction dates for each row. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland. The data source is from the country with the ISO country code 'FI'. This table can be utilized in data analytics to track the changes in the names of marine areas over time, analyze the spatial distribution of marine areas using geographic coordinates, and calculate the centroids and center points of the geometry of the marine areas.

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
nimi_r	string	The name of the object (in Russian).
ikoord	int	The X-coordinate of the object.
pkoord	int	The Y-coordinate of the object.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in WKT (Well-Known Text) format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The X-coordinate of the center point of the geometry.
geom_center_y	double	The Y-coordinate of the center point of the geometry.
geom	binary	The geometry of the object.

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version history.
nimi_r	string	The name of the base table row.
ikoord	int	The X-coordinate of the spatial geometry.
pkoord	int	The Y-coordinate of the spatial geometry.
geom_geojson	string	The spatial geometry in GeoJSON format.
geom_geotext	string	The spatial geometry in Geotext format.
geom_type	string	The type of the spatial geometry.
geom_centroid	string	The centroid of the spatial geometry.
geom_center_x	double	The X-coordinate of the center point of the spatial geometry.
geom_center_y	double	The Y-coordinate of the center point of the spatial geometry.
geom	binary	The spatial geometry.

Last Updated	September 13, 2024
Created	October 21, 2018