Regional Administration Areas (1:4 500 000) Data Table
The table, part of the 'tilastointialueet_avi4500k' dataset, contains information about AVI areas on a scale of 1:4,500,000, originating from the 'Tilastokeskus' (Statistics Finland) website. The data includes various geographical and administrative details, making it a valuable resource for geospatial data analytics.
The columns in the table provide a range of valuable information. The uniqueness of each row in the table is ensured by an extract date and a row number, offering a clear chronology of data extraction.
The data includes geographic information represented in various formats like geojson, geotext, and centroid point. It also contains the type of geometry used and the X and Y coordinates of the geometric center. All geographic coordinates are presented using the WGS 84 coordinate reference system, with longitude first, followed by latitude.
Moreover, the table also contains an identification number (id), a name in English, and corresponding names in Finnish (nimi) and Swedish (namn). This multilingual labeling enhances the accessibility and usability of the data across different regions.
The data in this table could be of great use in various data analytics scenarios. For example, it could be used in regional planning and development, where understanding geographical boundaries and regional names are crucial. It could also be beneficial for environmental studies, where geographic coordinates and geometric data are essential. Furthermore, the time-stamped data extraction could offer insights into changes over time, which could be valuable for historical analyses or predictive modeling.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row of the table was extracted from the data source. It forms part of a unique identifier for the row when combined with the '_row_number' column. |
| _row_number | long | This column contains the row number in the data extracted from the source on the extract date specified by the '_extract_date' column. It forms part of a unique identifier for the row when combined with the '_extract_date' column. |
| avi | string | This string column represents a unique identifier for a specific region. |
| geom_geojson | string | This column contains geographic data in GeoJSON format. It could represent the shape and boundaries of a specific area. |
| geom_geotext | string | This column provides geographic data in a text-based format. It might represent the shape and boundaries of a specific area, similar to the 'geom_geojson' column. |
| geom_type | string | This column specifies the type of geographical data contained in the 'geom_geojson' and 'geom_geotext' columns. It could be a polygon, multipolygon, etc. |
| geom_centroid | string | This column provides the geographic center point of the shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_x | double | This column provides the x-coordinate of the geographic center point of the shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
| geom_center_y | double | This column provides the y-coordinate of the geographic center point of the shape defined in the 'geom_geojson' and 'geom_geotext' columns. |
| gml_id | string | This string column contains a unique identifier for each row. |
| id | long | This integer column represents a unique identifier for each row. |
| name | string | This string column contains the English name of a specific region. |
| namn | string | This string column contains the Finnish name of a specific region. |
| nimi | string | This string column contains the Swedish name of a specific region. |
| vuosi | long | This integer column represents the year of the data. |
No sample for this dataset
Additional Information
| Last updated | November 8, 2024 |
|---|---|
| Created | November 8, 2024 |
| License | No License Provided |
| Geographic coverage | |
| Geographic granularity | |
| Temporal coverage from | |
| Temporal coverage to | |
| Temporal coverage to | |
| Country | fi |
| Database | fi_tilastokeskus |
| Extract date | 2024-11-11 |
| Id | 0f8c3670-47d5-40f2-8c3d-1b102ba6e674 |
| Package id | afd64340-d315-4d05-9f8f-80dd9f1d464f |
| Revision id | 7c01be08-60d0-4eac-84d5-8b931f841166 |
| State | active |
| Table | tilastointialueet_avi4500k__table |