Map Sheet Division 5x5 km in Helsinki, Finland
Tables
-
Open Data Map Sheet Distribution in 5x5 km - Map Sheet Distribution in 5x5 km PolygonTSV
This table contains information on map sheet divisions in a 5x5 km grid. The data is sourced from the website of Helsingin kaupunkiympäristön toimiala, which is a municipal organization in Finland. The table includes various attributes such as the extraction date, row number, ID, code, sheet size, coordinates, indices, sub-indices, municipal area, surface area, creation date, data modification date, owner, historical information, data creator, geometries in GeoJSON and GeoText formats, geometry type, centroid coordinates, and the full geometry. This data can be utilized for various data analytics purposes, such as analyzing municipal areas by surface area, identifying map sheets based on their size and location, tracking historical changes, and performing spatial analysis using the...
-
Version History of AvoinData Karttalehtijako 5x5 km - Karttalehtijako 5x5 km PolygonTSV
This table contains the version history of the 'avoindatakarttalehtijako_5x5_km__karttalehtijako_5x5_kmpolygon' table. It has two additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version of the row. The data in this table has been sourced from the website of 'Helsinki City Environment Sector' in the country Finland (ISO country code: FI). The table includes various columns like 'id', 'tunnus', 'lehtikoko', 'lehtikoko0', 'koordinaat', 'koordinaa0', 'km_indeksi', 'km_indeks0', 'km_alainde',...
Column Descriptions
Open Data Map Sheet Distribution in 5x5 km - Map Sheet Distribution in 5x5 km Polygon
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | Date when the data was extracted. |
| _row_number | long | Number representing the row in the table. |
| id | int | Unique identifier for each record. |
| tunnus | string | Specific code or symbol associated with the record. |
| lehtikoko | int | Size of the leaf or page. |
| lehtikoko0 | int | Alternate size of the leaf or page. |
| koordinaat | int | Coordinate value. |
| koordinaa0 | int | Alternate coordinate value. |
| km_indeksi | int | Index value for kilometers. |
| km_indeks0 | int | Alternate index value for kilometers. |
| km_alainde | string | Sub-index value for kilometers. |
| kunnan_alu | string | Area associated with a municipality or city. |
| pintaala | string | Total area of the record. |
| luonti_pvm | string | Date of creation of the record. |
| data_muokk | string | Information about the data modification. |
| muokkaus_p | string | Date of data modification. |
| omistaja | string | Owner of the record. |
| historia_p | string | Historical information related to the record. |
| data_luoja | string | Creator of the data. |
| geom_geojson | string | Geographical data in GeoJSON format. |
| geom_geotext | string | Geographical data in geotext format. |
| geom_type | string | Type of geographical data. |
| geom_centroid | string | Centroid of the geographical data. |
| geom_center_x | double | X-coordinate of the center of the geographical data. |
| geom_center_y | double | Y-coordinate of the center of the geographical data. |
| geom | binary | Geographical data. |
Version History of AvoinData Karttalehtijako 5x5 km - Karttalehtijako 5x5 km Polygon
| Column | Type | Comment |
|---|---|---|
| _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 number of the row version in the version history. |
| id | int | The unique identifier of the row. |
| tunnus | string | The identifier of the row for reference purposes. |
| lehtikoko | int | The size of the leaf. |
| lehtikoko0 | int | An additional size identifier of the leaf. |
| koordinaat | int | The coordinates of the location. |
| koordinaa0 | int | An additional set of coordinates for the location. |
| km_indeksi | int | The kilometer index. |
| km_indeks0 | int | An additional kilometer index. |
| km_alainde | string | The sub kilometer index. |
| kunnan_alu | string | The municipality area. |
| pintaala | string | The surface area of the row. |
| luonti_pvm | string | The date of creation. |
| data_muokk | string | The date of data modification. |
| muokkaus_p | string | The type of modification. |
| omistaja | string | The owner of the row. |
| historia_p | string | The historical preservation status of the row. |
| data_luoja | string | The creator of the data. |
| geom_geojson | string | The geographic JSON representation of the geometry. |
| geom_geotext | string | The text representation of the geometry. |
| 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 of the geometry. |
| geom_center_y | double | The y-coordinate of the center of the geometry. |
| geom | binary | The geometric representation of the row. |
Additional Info
| Last Updated | September 13, 2024 |
|---|---|
| Created | April 23, 2024 |