Geospatial Dataset Collection: Place Names in Swedish from 'Helsinki Urban Environment' Website, Finland

This dataset collection contains one or more tables sourced from the website of Helsingin kaupunkiympäristön toimiala, which is a government agency responsible for urban environment in Finland. The tables in this collection belong to the avoindataseutukartta_nimisto_paikannimet_ruotsi dataset collection.

Tables

Place Names in Helsinki Metropolitan Area in Swedish on Open Metropolitan Area MapTSV
This table contains data from the dataset 'avoindataseutukartta_nimisto_paikannimet_ruotsi__seutukartta_nimisto_paikannimet_ruotsipoint' sourced from the website of 'City Environment Sector of Helsinki'. The dataset originates from Finland (ISO country code: FI). 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'. This data can be utilized for various data analytics purposes such as geographic analysis, mapping, spatial clustering, and geospatial data visualization.
Version History of Place Names in Swedish in the Helsinki Metropolitan AreaTSV
The table contains the version history of the rows extracted from the data source 'Helsinki City Environment Sector' in the country Finland (ISO country code: 'fi'). It represents the historical records of a base table named 'avoindataseutukartta_nimisto_paikannimet_ruotsi__seutukartta_nimisto_paikannimet_ruotsipoint'. The table includes the following columns: '_start_date', '_end_date', '_row_number', 'nimi_r', 'ikoord', 'pkoord', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', 'tietopalve'. The '_start_date' column indicates the date when a row was extracted, while the '_end_date' column represents the date when a new version of the row was extracted. If a row has a null value in the '_end_date' column, it denotes that it is the...

Column Descriptions

Place Names in Helsinki Metropolitan Area in Swedish on Open Metropolitan Area Map

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier of each row in the table.
nimi_r	string	The name of the object.
ikoord	int	The x-coordinate of the object's position.
pkoord	int	The y-coordinate of the object's position.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext format.
geom_type	string	The type of the geometry (e.g., point, line, polygon).
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.
tietopalve	int	The service providing information about the object.

Version History of Place Names in Swedish in the Helsinki Metropolitan Area

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 entry.
nimi_r	string	The name of the row.
ikoord	int	The i-coordinate of the row.
pkoord	int	The p-coordinate of the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in Geotext format.
geom_type	string	The type of the geometry stored in the row.
geom_centroid	string	The centroid of the geometry stored in the row.
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 stored in the row.
tietopalve	int	The data service associated with the row.

Additional Info

Last Updated	April 23, 2024
Created	May 6, 2018