Distribution of 2x2 km Open Data Maps in Helsinki City Environment Sector (hri) dataset in Finland
Tables
-
Map Sheet Division (2x2 km) of Open Data Map SheetsTSV
This table contains data from 'Helsinki City Environment Sector' obtained from the website. The data represents the distribution of 2x2 km map sheets. It includes various attributes such as extraction date, row number, unique identifier, sheet code, sheet size, coordinates, index values, municipality area, surface area, creation date, data modification status, modification date, owner information, historical data presence, data creator, geographic data in GeoJSON format, geotext, geometric type, centroid coordinates, centroid x-coordinate, centroid y-coordinate, and the complete geometric information. The table provides valuable information for data analytics purposes such as analyzing trends in map sheet distribution, identifying variations in sheet sizes, examining changes in geometry...
-
Version History of Map Sheet Division in 2x2 KM Grid - PolygonTSV
This table contains the version history of the rows extracted from the dataset 'Helsingin kaupunkiympariston toimiala' from the country Finland (ISO country code 'fi'). The table '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If '_end_date' is null, it indicates that the row is the most recent version. The table 'avoindatakarttalehtijako_2x2_kmkarttalehtijako_2x2_kmpolygonhistory' is derived from the base table 'avoindatakarttalehtijako_2x2_km__karttalehtijako_2x2_kmpolygon'. The table includes various columns such as 'id', 'tunnus', 'lehtikoko', 'lehtikoko0', 'koordinaat', 'koordinaa0', 'km_indeksi', 'km_indeks0', 'km_alainde', 'kunnan_alu',...
Column Descriptions
Map Sheet Division (2x2 km) of Open Data Map Sheets
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the data entry. |
| id | int | The unique identifier for each entry. |
| tunnus | string | The identifier for the entry. |
| lehtikoko | int | The size of the leaf. |
| lehtikoko0 | int | The size of the leaf as an alternative representation. |
| koordinaat | int | The coordinate of the entry. |
| koordinaa0 | int | The coordinate of the entry as an alternative representation. |
| km_indeksi | int | The kilometer index of the entry. |
| km_indeks0 | int | The kilometer index of the entry as an alternative representation. |
| km_alainde | string | The sub-index of the kilometer entry. |
| kunnan_alu | string | The municipality area of the entry. |
| pintaala | string | The surface area of the entry. |
| luonti_pvm | string | The creation date of the entry. |
| data_muokk | string | The data modification information. |
| muokkaus_p | string | The modification date of the entry. |
| omistaja | string | The owner of the entry. |
| historia_p | string | The historical information of the entry. |
| data_luoja | string | The creator of the data entry. |
| geom_geojson | string | The geometry data of the entry in GeoJSON format. |
| geom_geotext | string | The geometry data of the entry in Geotext format. |
| geom_type | string | The type of geometry of the entry. |
| geom_centroid | string | The centroid position 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 geometry data of the entry. |
Version History of Map Sheet Division in 2x2 KM Grid - Polygon
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the validity period for this version of the row. |
| _end_date | date | The end date of the validity period for this version of the row. |
| _row_number | long | The row number of the version in the table. |
| id | int | The unique identifier for the row. |
| tunnus | string | A value representing the tunnus of the row. |
| lehtikoko | int | The lehtikoko value for the row. |
| lehtikoko0 | int | An additional lehtikoko value for the row. |
| koordinaat | int | The koordinaat value for the row. |
| koordinaa0 | int | An additional koordinaat value for the row. |
| km_indeksi | int | The km_indeksi value for the row. |
| km_indeks0 | int | An additional km_indeksi value for the row. |
| km_alainde | string | The km_alainde value for the row. |
| kunnan_alu | string | The kunnan_alu value for the row. |
| pintaala | string | The pintaala value for the row. |
| luonti_pvm | string | The creation date of the row. |
| data_muokk | string | The date of the last data modification for the row. |
| muokkaus_p | string | The muokkaus_p value for the row. |
| omistaja | string | The owner of the row. |
| historia_p | string | The historia_p value for the row. |
| data_luoja | string | The creator of the row data. |
| geom_geojson | string | The geojson representation of the geometry of the row. |
| geom_geotext | string | The geotext representation of the geometry of the row. |
| geom_type | string | The type of geometry for the row. |
| geom_centroid | string | The centroid of the geometry for the row. |
| geom_center_x | double | The x-coordinate of the center of the geometry for the row. |
| geom_center_y | double | The y-coordinate of the center of the geometry for the row. |
| geom | binary | The geometry of the row. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | April 23, 2024 |