Suomi Urban Area Map with Neighborhood Names

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

Tables

District Names in FinlandTSV
This table contains data from the 'Helsinki City Environment Department' website. It represents the geographical names of neighborhoods (kaupunginosanimet) in Finland. The data includes information on the extraction date, row numbers, neighborhood names in Finnish, coordinate information, geometrical representations, and other related attributes. The table can be utilized in data analytics to analyze and understand the distribution and characteristics of neighborhoods in Finland, perform spatial analysis, calculate centroids, and extract geographical information. The country of origin for this data is Finland (ISO country code: 'fi').
Version History of Urban District Names and Coordinates in FinlandTSV
This table contains the version history of the 'avoindataseutukartta_nimisto_kaupunginosanimet_suomi__seutukartta_nimisto_kaupunginosanimet_suomipoint' table. The table is sourced from the website of 'Helsinki City Environment Sector' in Finland. It provides historical information about various attributes of city district names, including the start and end dates of each version. The '_start_date' column indicates the extraction date of the row, while the '_end_date' column specifies the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the corresponding row represents the latest version. The table can be utilized for data analytics purposes, such as tracking the changes in city district names over time, analyzing the frequency of updates,...

Column Descriptions

District Names in Finland

Column	Type	Comment
_extract_date	date	The date when the row was extracted
_row_number	long	The number assigned to each row
nimi_s	string	The name of the entity represented by the row
ikoord	int	The X-coordinate of the entity location
pkoord	int	The Y-coordinate of the entity location
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 of the entity
geom_centroid	string	The centroid of the entity geometry
geom_center_x	double	The X-coordinate of the centroid
geom_center_y	double	The Y-coordinate of the centroid
geom	binary	The full geometry of the entity
tietopalve	int	The information service provided by the entity

Version History of Urban District Names and Coordinates in 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 in the table.
nimi_s	string	The name of the row in the base table.
ikoord	int	The coordinate i value.
pkoord	int	The coordinate p value.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry 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 geometry.
tietopalve	int	The data service that provided the information.

Additional Info

Last Updated	September 13, 2024
Created	November 21, 2018