Table Collection from Helsingin kaupunkiympäristön toimiala in Finland
Tables
-
Historical Version of Neighborhood Data from Helsingin kaupunkiympariston toimiala in FinlandTSV
This table contains the version history of rows from the 'helkaupunginosakaupunginosa' base table. It is named 'helkaupunginosakaupunginosa__history' and sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The table includes columns '_start_date' and '_end_date' which represent the extraction dates of the row versions. The table could be utilized in data analytics to analyze the changes in various attributes over time, such as 'data_luoja', 'tarkkuus', 'mittausera', 'pinta', 'historia_p', 'omistaja', 'muokkaus_p', 'data_muokk', 'id', 'aluejako', 'kunta', 'tunnus', 'nimi', 'nimi_se', 'alkuperako', 'luonti_pvm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains geospatial information...
-
Neighborhoods in the City of HelsinkiTSV
This table contains data related to urban districts in the city of Helsinki. The data includes information such as the date of extraction, row number, creator of the data, accuracy, measurement unit, surface area, historical context, owner, modification date, data modification information, ID, division of areas, municipality, code, name, name in Swedish, original source, creation date, geometry in GeoJSON format, geometry in GeoText format, geometry type, centroid of the geometry, center x coordinate of the geometry, center y coordinate of the geometry, and the geometry itself. The data in this table can be utilized in various data analytics scenarios such as analyzing population distribution across urban districts, calculating the average surface area of districts, studying historical...
Column Descriptions
Neighborhoods in the City of Helsinki
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The sequential number of the row. |
| data_luoja | string | The creator of the data. |
| tarkkuus | int | The precision of the measurements. |
| mittausera | int | The measurement area. |
| pinta | int | The surface area. |
| historia_p | timestamp | The historical period of the data. |
| omistaja | string | The owner of the data. |
| muokkaus_p | timestamp | The modification period of the data. |
| data_muokk | string | The modifier of the data. |
| id | int | The unique identifier of the data. |
| aluejako | string | The division of the area. |
| kunta | int | The municipality. |
| tunnus | int | The identifier of the data. |
| nimi | string | The name of the data. |
| nimi_se | string | The translated name of the data. |
| alkuperako | int | The original source of the data. |
| luonti_pvm | timestamp | The creation date of the data. |
| geom_geojson | string | The geometric representation of the data in GeoJSON format. |
| geom_geotext | string | The geometric representation of the data in Geotext format. |
| geom_type | string | The type of the geometric data. |
| geom_centroid | string | The centroid coordinates of the geometric data. |
| geom_center_x | double | The x-coordinate of the center of the geometric data. |
| geom_center_y | double | The y-coordinate of the center of the geometric data. |
| geom | binary | The geometric data. |
Historical Version of Neighborhood Data from Helsingin kaupunkiympariston toimiala in Finland
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period for this row version. |
| _end_date | date | The end date of the validity period for this row version. |
| _row_number | long | The row number of the version history entry. |
| data_luoja | string | The creator of the data. |
| tarkkuus | int | The accuracy of the data. |
| mittausera | int | The measurement unit of the data. |
| pinta | int | The surface of the data. |
| historia_p | timestamp | A flag indicating if this row version is a historical entry. |
| omistaja | string | The owner of the data. |
| muokkaus_p | timestamp | A flag indicating if this row version has been modified. |
| data_muokk | string | The date of the last modification of the data. |
| id | int | The unique identifier of the row version. |
| aluejako | string | The administrative division of the data. |
| kunta | int | The municipality of the data. |
| tunnus | int | The identifier of the data. |
| nimi | string | The name of the data. |
| nimi_se | string | The name of the data in Swedish. |
| alkuperako | int | The original source of the data. |
| luonti_pvm | timestamp | The creation date of the data. |
| geom_geojson | string | The serialized geometry in GeoJSON format. |
| geom_geotext | string | The serialized geometry in WKT format. |
| geom_type | string | The type of 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 data. |
Additional Info
| Last Updated | April 23, 2024 |
|---|---|
| Created | October 21, 2018 |