Large Areas Geospatial Data (Scale 1:1 000 000)
Click here for a data sample
The table belongs to a dataset that contains information on 'Major Areas' at a 1:1,000,000 scale. This dataset is sourced from the 'Tilastokeskus' (Statistics Finland) website from Finland. The table encapsulates various types of data including geographical, temporal, and textual data. It has several columns that store distinct pieces of information. For instance, there are columns that provide the date when the data was extracted and the row number in the extracted data, which uniquely identify each row. There are also columns that contain geographical data, such as geographical coordinates, presented using the WGS 84 coordinate reference system, where longitude is presented first, followed by latitude. This information can be used for geospatial data analytics. Furthermore, the table provides names of the major areas in different languages. The data in this table could be used for a variety of data analytics purposes. For example, it could be used to analyse the geographical distribution of different areas, or to track changes in these areas over time. Additionally, the multi-language support could be useful for international studies or for applications that require localization.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | This column captures the date when the data on the row of the table was extracted. This helps track the timeliness of each data entry. |
|---|
| _row_number | long | This column represents the row number in the data extracted. It, along with the '_extract_date', uniquely identifies each row. |
|---|
| geom_geojson | string | This column holds geographical data in the GeoJSON format, a type of open standard format designed for representing simple geographical features. |
|---|
| geom_geotext | string | This column contains geometric data in text format, providing another modality for representing geographical features. |
|---|
| geom_type | string | This column specifies the type of the geometric data. In this case, it's 'ST_MULTIPOLYGON', indicating that the data represents a figure with multiple polygonal faces. |
|---|
| geom_centroid | string | This column holds the centroid coordinates of the geographical feature. It can be used to determine the central point of the feature. |
|---|
| geom_center_x | double | This column represents the X-coordinate of the center of the geographical feature. |
|---|
| geom_center_y | double | This column represents the Y-coordinate of the center of the geographical feature. |
|---|
| gml_id | string | This column contains a unique identifier for each geographical feature. |
|---|
| name | string | This column holds the English name of the geographical feature or area. |
|---|
| namn | string | This column contains the name of the geographical feature or area in Swedish. |
|---|
| nimi | string | This column provides the name of the geographical feature or area in Finnish. |
|---|
| suuralue | string | This column contains a numerical identifier for each geographical feature or area. |
|---|
| vuosi | long | This column indicates the year associated with the data entry. |
|---|
