Table Collection from Helsingin kaupunkiympariston toimiala in Finland

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. It contains comprehensive information about place names in Finland.

Tables

Place Names in Finland - Regional MapTSV
The table contains data from the 'Helsinki City Planning Department' in Finland, providing information on named locations in the Helsinki metropolitan area. It includes various columns storing details such as extraction date, row number, place name, coordinates, geographic data, centroid, and other related information. This table can be used for data analytics purposes, such as analyzing the distribution of place names in the Helsinki metropolitan area, identifying the most common or unique place names, studying the spatial patterns of named locations, or conducting geospatial analyses using the provided coordinates and geographic data.
Version History of Geographical Names in Finland (from Helsingin kaupunkiympariston toimiala)TSV
This table contains the version history of rows from the 'avoindataseutukartta_nimisto_paikannimet_suomi__seutukartta_nimisto_paikannimet_suomipoint' base table. It has additional columns '_start_date' and '_end_date' that indicate the extraction dates of the rows. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code 'fi'). The table stores various attributes related to place names, such as 'nimi_s' (name), 'ikoord' (internal coordinate), 'pkoord' (public coordinate), 'geom_geojson' (geometry in GeoJSON format), 'geom_geotext' (geometry in Geotext format), 'geom_type' (geometry type), 'geom_centroid' (centroid of the geometry), 'geom_center_x' (x-coordinate of the geometry center), 'geom_center_y'...

Column Descriptions

Place Names in Finland - Regional Map

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	A unique identifier for each row in the table.
nimi_s	string	The name of a place, expressed as a string.
ikoord	int	The x-coordinate of the place's location on a map.
pkoord	int	The y-coordinate of the place's location on a map.
geom_geojson	string	The geometry of the place in GeoJSON format.
geom_geotext	string	The geometry of the place in Geotext format.
geom_type	string	The type of geometry used for the place's location.
geom_centroid	string	The centroid of the place's geometry.
geom_center_x	double	The x-coordinate of the center of the place's geometry.
geom_center_y	double	The y-coordinate of the center of the place's geometry.
geom	binary	The full geometry information of the place.
tietopalve	int	The service used to obtain the data.

Version History of Geographical Names in Finland (from Helsingin kaupunkiympariston toimiala)

Column	Type	Comment
_start_date	date	Column indicating the start date of the validity period for the row version.
_end_date	date	Column indicating the end date of the validity period for the row version.
_row_number	long	Column representing the number of the row version.
nimi_s	string	Column containing the name of the row version.
ikoord	int	Column representing the i-coordinate of the row version.
pkoord	int	Column representing the p-coordinate of the row version.
geom_geojson	string	Column containing the geometry data in the GeoJSON format for the row version.
geom_geotext	string	Column containing the geometry data in the geotext format for the row version.
geom_type	string	Column indicating the type of geometry for the row version.
geom_centroid	string	Column representing the centroid of the geometry for the row version.
geom_center_x	double	Column indicating the X-coordinate of the center point of the geometry for the row version.
geom_center_y	double	Column indicating the Y-coordinate of the center point of the geometry for the row version.
geom	binary	Column containing the raw geometry data for the row version.
tietopalve	int	Column indicating the type of service provided for the row version.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018