Statistical Areas 2015 - Overview (Scale 1:4,500,000)
Click here for a data sample
The table in question hails from the dataset collection 'tilastointialueet_avi4500k_2015' and contains a wealth of information relating to the AVI-areas for the year 2015 at a scale of 1:4,500,000. This data has been sourced from 'Tilastokeskus' (Statistics Finland) website, located in Finland. The table contains a multitude of columns, each providing unique insights into the dataset. Two of these columns, 'extract_date' and '_row_number', are particularly noteworthy. The former provides the date when the data was extracted from the source, while the latter signifies the row number in the data extracted on that specific date. Together, they uniquely identify each row in the table. In addition to this, the table contains columns starting with 'geom' that hold geographic information, useful in geospatial data analytics. This geographic data is presented using the WGS 84 coordinate reference system, with the longitude given first, followed by the latitude. With this information, one could conduct a variety of data analytics tasks. For instance, it would be possible to analyze trends over time by looking at the '_extract_date'. The geographic data could be used to perform spatial analysis or mapping. Additionally, the 'avi' column could be used to categorize or group the data for further analysis. Overall, the table provides a comprehensive view of the AVI-areas for 2015, allowing for in-depth exploration and analysis.
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 source. It is a part of the unique identifier for 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 forms a unique identifier for each row in combination with the '_extract_date' column. |
|---|
| avi | string | This column contains a string representative of an administrative division. |
|---|
| geom_geojson | string | This column contains geometric data in GeoJSON format, typically representing geographical features. |
|---|
| geom_geotext | string | This column contains geometric data in text format, specifically in the form of multiple polygons. |
|---|
| geom_type | string | This column specifies the type of geometry represented in the 'geom_geojson' column. The column only contains the value 'ST_MULTIPOLYGON', indicating that the data is composed of multiple polygons. |
|---|
| geom_centroid | string | This column contains the central point of the geographical feature represented by the geometry data. |
|---|
| geom_center_x | double | This column contains the x-coordinate of the central point of the geographical feature represented by the geometry data. |
|---|
| geom_center_y | double | This column contains the y-coordinate of the central point of the geographical feature represented by the geometry data. |
|---|
| gid | long | This column contains an integer value, likely serving as an identifier. |
|---|
| gml_id | string | This column contains a string value, likely serving as another form of identifier. |
|---|
| name | string | This column contains the English names of the geographical areas represented in the data. |
|---|
| namn | string | This column contains the names of the geographical areas in a different language, likely Swedish or Finnish. |
|---|
| nimi | string | This column contains the names of the geographical areas in another language, likely Finnish. |
|---|
| shape_star | double | This column contains a real number, possibly representing an area or other geometric measurement associated with the geographical feature. |
|---|
| shape_stle | double | This column contains a real number, possibly representing a perimeter or other geometric measurement associated with the geographical feature. |
|---|
| vuosi | double | This column contains a real number, likely representing a year, as suggested by the sample value 2015.0. |
|---|
