AVI Regions 2013 Dataset (1:4 500 000 Scale)
The table is part of a larger dataset collection and contains data related to the administrative regions in Finland for the year 2013. It includes a variety of columns with different types of data. Some key columns include the date of data extraction, the row number, and geographic information.
The table has a special column that notes the date when the data was extracted, allowing users to understand the timeline of the dataset's creation. Another column provides the specific row number of each entry, ensuring each row's uniqueness in the table.
In addition, the table presents geographic data in several formats, including GeoJSON, geotext, and coordinates. This geospatial information, provided in the WGS 84 coordinate reference system, can be utilized to perform in-depth geographic analysis or even create detailed visualizations of the data. For instance, the geographical information could be used to map out the boundaries of each administrative region in Finland.
Another set of columns provide names of the regions in various languages, which can be utilized in multilingual data analysis or to ensure the accessibility of data to users with different language preferences.
The table also contains data about the regions' identifiers which could be used in data linking and merging when working with other related datasets.
The data in this table is sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland and could be invaluable for analysts or researchers interested in studying regional trends or patterns in Finland for the year 2013.
Field Descriptions
| Name | Data type | Description |
|---|---|---|
| _extract_date | date | This column holds the date when the data on the row of the table was extracted from the source. It aids 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 assists in uniquely identifying each row when used in combination with the '_extract_date' column. |
| avi | string | This string type column holds some unique identifiers, possibly related to the geographical area. |
| geom_geojson | string | This column contains geographical data in the GeoJSON format, which represents simple geographical features. |
| geom_geotext | string | This column holds geographical data in a textual format. The data appears to represent various multi-polygon geographical shapes. |
| geom_type | string | This column specifies the type of the geographical data present in the table. For example, 'ST_MULTIPOLYGON' represents a type of complex geographical shape. |
| geom_centroid | string | This column contains the coordinates of the centroid, or geometric center, of the geographical shape represented in the row. |
| geom_center_x | double | This column holds the x-coordinate of the geometric center of the geographical shape represented in the row. |
| geom_center_y | double | This column holds the y-coordinate of the geometric center of the geographical shape represented in the row. |
| gid | long | This is an integer type column that may serve as a unique identifier for each row. |
| gml_id | string | This string type column seems to contain a unique identifier for each geographical shape represented in the table. |
| name | string | This column contains names in English, possibly of the geographical areas represented in the table. |
| namn | string | This column contains names in a non-English language, possibly Finnish or Swedish, which may correspond to the geographical areas represented in the table. |
| nimi | string | This column contains names in another non-English language, possibly Finnish, which may correspond to the geographical areas represented in the table. |
| vuosi | long | This integer type column holds what appears to be years, possibly indicating the year of data collection or a relevant event for the geographical area. |
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 | 8ee8bc49-e3ac-402f-8474-a34dd5929bc6 |
| Package id | 5f49795b-9ea4-4988-a823-159d6fefcf3b |
| Revision id | 64d153ff-0ded-4772-bc67-87e7ad81bef8 |
| State | active |
| Table | tilastointialueet_avi4500k_2013__table |