Regional Administrative Agency Areas (Scale 1:1,000,000) - Data Table
The table under consideration belongs to a dataset collection named 'Tilastointialueet_avi1000k'. It comprises of a diverse set of columns that carry a rich variety of data, including specific geographic information, identifiers and names, among other elements. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland.
One of the key components of the table is the geographic information contained in several columns, all beginning with the prefix 'geom_'. These contain various forms of geographic details such as geographic coordinates, which are presented using the WGS 84 coordinate reference system. The axis order for these coordinates follows the structure: longitude first, followed by latitude. This geographical data is particularly valuable for geospatial data analytics, allowing for comprehensive location-based studies and investigations.
The table also contains special columns '_extract_date' and '_row_number'. These serve as unique identifiers for each row, with the former containing the date of extraction of data from the source, and the latter carrying the row number of the extracted data. This combination of extract date and row number ensures that each row can be accurately and uniquely identified.
The table's contents are described as 'AVI-areas (1:1 000 000)', indicating that the data contains information about different AVI areas. This is further reinforced by the columns 'avi', 'id', 'name', 'namn', 'nimi', and 'vuosi', which carry identifiers, names in different languages, and years respectively.
This table can serve as a valuable foundation for various data analytics applications. For instance, the geographic data can be utilized to conduct regional analyses or to study spatial patterns. The identifiers and names can be used to cross-reference with other datasets for more comprehensive insights. Moreover, the year column could be used for temporal or longitudinal studies as well. Furthermore, the extract date and row number can be used to track the evolution of the data over time.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column contains the date when the data on the row was extracted from the source. It plays a crucial role in uniquely identifying each row in combination 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 column '_extract_date'. It uniquely identifies each row when used in conjunction with the '_extract_date' column. |
| avi | string | This column contains string values which might be identifiers or codes for a certain feature or entity in the dataset. |
| geom_geojson | string | This column contains geographic data in the GeoJSON format, which is a format for encoding a variety of geographic data structures. |
| geom_geotext | string | This column contains geographic data in textual format, probably representing various geographic features. |
| geom_type | string | This column specifies the type of geographic data stored in the 'geom_geotext' and 'geom_geojson' columns. It appears to contain a single, constant value 'ST_MULTIPOLYGON'. |
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the feature represented in the 'geom_geotext' and 'geom_geojson' columns. |
| geom_center_x | double | This column contains the X coordinate of the geometric center of the feature represented in the 'geom_geotext' and 'geom_geojson' columns. |
| geom_center_y | double | This column contains the Y coordinate of the geometric center of the feature represented in the 'geom_geotext' and 'geom_geojson' columns. |
| gml_id | string | This column contains unique identifiers for each row, likely sourced from the original data source. |
| id | long | This column contains integer values, possibly representing unique identifiers for the entities or features referenced in the dataset. |
| name | string | This column contains string values, likely representing the names of the entities or features in English language. |
| namn | string | This column contains string values, likely representing the names of the entities or features in another language, possibly Swedish. |
| nimi | string | This column contains string values, likely representing the names of the entities or features in Finnish language. |
| vuosi | long | This column contains integer values, possibly indicating the year associated with the data on each row. |
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 | b1f65809-4b40-4496-b79e-39fadabf763d |
| Package id | 8af66a40-a2c1-4804-bb37-07d00853c90e |
| Revision id | 8ec3c614-e5d7-4f18-bb7a-abc1d1964112 |
| State | active |
| Table | tilastointialueet_avi1000k__table |