Historical Versioning of ELY Areas 2020 (Scale 1:4,500,000)
Click here for a data sample
The 'table__history' is a history table that forms part of a dataset collection named 'tilastointialueet_ely4500k_2020'. This table contains data about ELY areas in 2020 at a scale of 1:4,500,000. This information is sourced from the 'Tilastokeskus' (Statistics Finland) website based in Finland. The table holds the version history of its base table rows, including information about when each row was extracted from the data source and when a new version of the row was extracted. If the end date for a row is null, this indicates that the row is the most recent version. Geographic coordinates, presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude, are included in this table. The data stored in this table can be utilized in various ways, such as tracking changes over time, geospatial data analytics, and understanding regional distributions and trends.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | This column represents the date when the row was extracted from the data source. It forms a unique identifier for each row in combination with the '_row_number'. |
|---|
| _end_date | date | This column signifies the date when a new version of the row was extracted from the data source. A null value in this column indicates that the row is the most recent version. |
|---|
| _row_number | long | This column contains the number of the row in the raw data extracted from the source. It is used in conjunction with '_start_date' to uniquely identify each row in the table. |
|---|
| ely | string | This column contains a string representation of the ELY center code. |
|---|
| geom_geojson | string | This column contains the geometric data of the ELY center in GeoJSON format. |
|---|
| geom_geotext | string | This column contains textual representation of the geometric data of the ELY center. |
|---|
| geom_type | string | This column represents the type of geometric data stored (e.g., 'ST_MULTIPOLYGON', 'ST_POLYGON'). |
|---|
| geom_centroid | string | This column contains the centroid of the geometric data of the ELY center. |
|---|
| geom_center_x | double | This column represents the x-coordinate of the geometric center of the ELY center. |
|---|
| geom_center_y | double | This column represents the y-coordinate of the geometric center of the ELY center. |
|---|
| gml_id | string | This column contains a string that uniquely identifies the geometric data of the ELY center. |
|---|
| id | long | This column contains a unique integer identifier for each row of data. |
|---|
| name | string | This column contains the English name of the ELY center. |
|---|
| namn | string | This column contains the name of the ELY center in another language. |
|---|
| nimi | string | This column contains the Finnish name of the ELY center. |
|---|
| vuosi | long | This column contains the year associated with the data. In the sample data provided, the year is 2020. |
|---|
