Finnish District Names in Swedish

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

History of Region Map Names in Swedish in FinlandTSV
This table contains the version history of rows extracted from the web site of Helsingin kaupunkiympäristön toimiala in Finland. It is related to the seutukarttanimet_ruotsi__nimet_ruotsi base table. The table includes information about the start and end dates of each row version, a row number, 'nimi_r' data, 'ikoord' coordinates, 'pkoord' coordinates, 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains geometrical data. This table can be utilized in data analytics to analyze changes over time, track updates, compare different versions of rows, and perform spatial analysis on the geographical data.
Place Names in Finland with Swedish NamesTSV
The table contains data from the web site of 'Helsinki City Environment' in Finland. It provides information on 'seutukarttanimet_ruotsi__nimet_ruotsi'. The data can be utilized in data analytics for various purposes such as geographical analysis, mapping, and spatial data visualization.

Column	Type	Comment
_extract_date	date	The date when the row was extracted or created.
_row_number	long	The row number or identifier.
nimi_r	string	The name of the object in region R.
ikoord	int	The i-coordinate of the object location.
pkoord	int	The p-coordinate of the object location.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in Geotext format.
geom_type	string	The type of geometry for the object.
geom_centroid	string	The centroid of the object.
geom_center_x	double	The X-coordinate of the center of the object.
geom_center_y	double	The Y-coordinate of the center of the object.
geom	binary	The full geometry of the object.

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The unique identifier for each row version.
nimi_r	string	The name of the row.
ikoord	int	The x-coordinate of the row.
pkoord	int	The y-coordinate of the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The text representation of the geometry of the row.
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 point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The geometry of the row.

Last Updated	September 13, 2024
Created	October 22, 2018