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

To download the data set, please sign up or log in

Click here for a data sample

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 analytics scenarios, such as tracking changes in the data over time, analyzing spatial patterns using the geometry columns, and understanding the historical development of neighborhood names in Helsinki.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe row number of the version history.
nimi_rstringThe name of the row.
ikoordintThe I coordinate of the row.
pkoordintThe P coordinate of the row.
geom_geojsonstringThe geometry of the row in GeoJSON format.
geom_geotextstringThe geometry of the row in Geotext format.
geom_typestringThe type of geometry of the row.
geom_centroidstringThe centroid of the geometry of the row.
geom_center_xdoubleThe X coordinate of the center of the geometry of the row.
geom_center_ydoubleThe Y coordinate of the center of the geometry of the row.
geombinaryThe geometry of the row.
tietopalveintThe information service of the row.

No sample for this dataset

Additional Information

Last updated April 24, 2024
Created April 24, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id19ca67bb-e88e-48e8-8b78-a6ece9c395c0
Package idf01ea7dc-03a5-45f5-b02a-4fa6da3294b1
Position1
Revision id9a7fb5df-0119-4027-a5df-1eb27db18e34
Stateactive
Tableavoindataseutukartta_nimisto_kaupunginosanimet_ruotsi__seutukartta_nimisto_kaupunginosanimet_ruotsipoint__history