Map District Names in Finland
Tables
-
History of Neighborhood Names in Finland from Helsingin kaupunkiympariston toimialaTSV
This table contains the version history of the 'seutukarttanimet_kaupunginosat_suomi__nimet_kaupunginosat_suomi' table sourced from the web site of 'Helsingin kaupunkiympariston toimiala' in Finland. It includes historical records of various attributes such as names, coordinates, geometries, and other related data. Each row in the table represents a specific version of the base table, identified by the '_start_date' and '_end_date' columns. The '_end_date' column indicates the date when a new version of the row was extracted. If its value is null, it implies that the corresponding row is the most recent version. The data in this table can be utilized for various data analytics purposes, such as analyzing the changes in neighborhood names and boundaries over time, identifying trends in...
-
Neighborhoods in Finland - Names of Neighborhoods in FinlandTSV
This table contains data from the 'Helsingin kaupunkiympariston toimiala' website in Finland. It includes various information such as the extraction date, row number, neighborhood name, coordinates, geographic data in JSON and text format, geometry type, centroid, center coordinates, and the geometry itself. This table can be utilized for data analytics by analyzing the neighborhood names to identify patterns or trends, using the coordinates to plot the data on maps, or examining the geometry to perform spatial analyses.
Column Descriptions
Neighborhoods in Finland - Names of Neighborhoods in Finland
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the data was extracted. |
_row_number | long | The row number of the record. |
nimi_s | string | The name of the record. |
ikoord | int | The x-coordinate of the record. |
pkoord | int | The y-coordinate of the record. |
geom_geojson | string | The geometry of the record in GeoJSON format. |
geom_geotext | string | The geometry of the record 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 complete geometry of the record. |
History of Neighborhood Names in Finland from Helsingin kaupunkiympariston toimiala
Column | Type | Comment |
---|---|---|
_start_date | date | The date when the version of the row started being valid. |
_end_date | date | The date when the version of the row stopped being valid. |
_row_number | long | A unique identifier for each row version. |
nimi_s | string | The name of the row version. |
ikoord | int | The i-coordinate of the row version. |
pkoord | int | The p-coordinate of the row version. |
geom_geojson | string | The geometry of the row version in GeoJSON format. |
geom_geotext | string | The geometry of the row version in GeoText format. |
geom_type | string | The type of the geometry in the row version. |
geom_centroid | string | The centroid of the geometry in the row version. |
geom_center_x | double | The x-coordinate of the center of the geometry in the row version. |
geom_center_y | double | The y-coordinate of the center of the geometry in the row version. |
geom | binary | The geometry of the row version. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 22, 2018 |