Regional Administrative Agency Areas 2020 (1:4 500 000)
Click here for a data sample
The table in focus, an integral part of a specific dataset collection, contains data pertaining to the AVI regions for the year 2020 at a scale of 1:4 500 000. These regions are represented by identifiable codes. This table offers valuable insights into geographic information, making it a useful tool for geospatial data analytics. Each row of data contains an extraction date, offering a snapshot of the data as it existed at that specific point in time. The row number, in combination with the extraction date, provides a unique identifier for each row. The geographic coordinates are presented in the WGS 84 coordinate reference system, with longitude listed before latitude. The table houses a variety of other data columns, which include the specific AVI region code, the geographic details in different formats, the type of geometric data, centroid of the geometric shape, the X and Y coordinates of the geometric center, the unique GML ID, the name of the region in different languages, and the year of data. This variety of data can be leveraged in a multitude of ways. For example, it could be used to analyze geographic trends over time, or to create detailed visual representations of data based on geographic locations. The table is sourced from the website of 'Tilastokeskus' (Statistics Finland) in Finland.
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. |
|---|
| _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'. |
|---|
| avi | string | This column contains numerical identifiers, possibly representing different administrative divisions. |
|---|
| geom_geojson | string | This column contains geographical data in the form of GeoJSON, which is a format for encoding a variety of geographic data structures. |
|---|
| geom_geotext | string | This column contains geographical data in text format, presumably describing the shapes of geographical features. |
|---|
| geom_type | string | This column specifies the type of the geographical data stored, such as Polygon or MultiPolygon. |
|---|
| geom_centroid | string | This column contains the geographical coordinates of the centroid, or geometric center, of the data in the row. |
|---|
| geom_center_x | double | This column contains the X-coordinate of the geometric center of the data in the row, typically representing longitude. |
|---|
| geom_center_y | double | This column contains the Y-coordinate of the geometric center of the data in the row, typically representing latitude. |
|---|
| gml_id | string | This column contains unique identifiers for the data rows, presumably used in the Geographic Markup Language (GML) format. |
|---|
| id | long | This column contains numerical identifiers for the data rows. |
|---|
| name | string | This column contains the names of administrative divisions in English. |
|---|
| namn | string | This column contains the names of administrative divisions in Swedish. |
|---|
| nimi | string | This column contains the names of administrative divisions in Finnish. |
|---|
| vuosi | long | This column contains the year associated with the data in the row. |
|---|
