Street Map and Neighborhood Names in Swedish for Helsinki, Finland

The dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Place Names in Swedish for Districts on Open Metropolitan Map in FinlandTSV
This table contains data from the 'Helsinki City Environment Sector' website, originating from the country Finland (ISO country code: FI). The table 'avoindataseutukartta_nimisto_kaupunginosanimet_ruotsi__seutukartta_nimisto_kaupunginosanimet_ruotsipoint' consists of 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 can be utilized for various data analytics tasks such as analyzing and visualizing geographical information, calculating distances between points, and identifying the centroid of different geometries.
Version History of Place Names in City Districts in Swedish - Helsinki Urban Environment Department (Finland)TSV
This table contains the version history of the rows extracted from the web site of 'Helsingin kaupunkiympariston toimiala' in Finland. The base table for this version history table is from the data source 'Helsinki City Environment Sector'. The table includes columns such as '_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 represents the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row represents the most recent version. This table can be utilized in various data...

Column Descriptions

Place Names in Swedish for Districts on Open Metropolitan Map in Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The index of the row in the table
nimi_r	string	The name of the resource
ikoord	int	The x coordinate of the resource
pkoord	int	The y coordinate of the resource
geom_geojson	string	The geometry of the resource in GeoJSON format
geom_geotext	string	The geometry of the resource in Geotext format
geom_type	string	The type of the 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 full geometry of the resource
tietopalve	int	The service provided

Version History of Place Names in City Districts in Swedish - Helsinki Urban Environment Department (Finland)

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 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 geometry of the row.
geom_centroid	string	The centroid of the geometry of the row.
geom_center_x	double	The X coordinate of the center of the geometry of the row.
geom_center_y	double	The Y coordinate of the center of the geometry of the row.
geom	binary	The geometry of the row.
tietopalve	int	The information service of the row.

Additional Info

Last Updated	September 13, 2024
Created	November 21, 2018