Version History of Place Names in City Districts in Swedish - Helsinki Urban Environment Department (Finland)
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_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. |