Regions Administrative Division 2021 - Detailed Geospatial Data (Scale 1:4 500 000)
Click here for a data sample
The table in discussion is part of a broader dataset collection. This table is specifically dedicated to AVI areas of 2021 at a scale of 1:4,500,000. It is derived from the 'Tilastokeskus' website, located in Finland. The table is rich with a variety of columns that carry specific and unique data. Two notable columns, 'extract_date' and '_row_number', present the date of data extraction and the row number in the extracted data, respectively. These two columns together create a unique identifier for each row. The table also carries geographical data in various forms across multiple 'geom' prefixed columns. This data can be beneficial in geospatial analytics, with coordinates presented using the WGS 84 coordinate reference system, where axis order is longitude first, followed by latitude. The table includes information about different AVI areas, such as their names in different languages and their unique identifiers. In data analytics, this table can be handy for geographical analyses, regional planning, and trend analysis based on the extraction date. It can also be utilized to understand patterns and correlations among AVI areas over time.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column records the date when the specific row of data was extracted from the data source. |
|---|
| _row_number | long | This column contains the sequential row number of the data extracted from the source on the given extract date. The combination of '_extract_date' and '_row_number' uniquely identifies each row. |
|---|
| avi | string | This column represents an identifier. |
|---|
| geom_geojson | string | This column contains the geographical data in GeoJSON format, which describes the shapes of the geographical areas. |
|---|
| geom_geotext | string | This column contains the geographical data in geotext format, providing another way to represent the shapes of geographical areas. |
|---|
| geom_type | string | This column indicates the type of the geographical data, for instance, whether the data represents a multipolygon or a single polygon. |
|---|
| geom_centroid | string | This column contains the centroid of the geographical area represented by the row of data. The centroid is the center point of the shape. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the center of the geographical area. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the center of the geographical area. |
|---|
| gml_id | string | This column contains a unique identifier for each row in the GML (Geography Markup Language) format. |
|---|
| id | long | This column contains a unique integer identifier for each row. |
|---|
| name | string | This column contains the English name of the geographical area. |
|---|
| namn | string | This column contains the Swedish name of the geographical area. |
|---|
| nimi | string | This column contains the Finnish name of the geographical area. |
|---|
| vuosi | long | This column contains the year associated with the data, given as an integer. |
|---|
