ELY Areas 2018 (Scale 1:1,000,000) Table
Click here for a data sample
The table belongs to the dataset collection titled 'tilastointialueet_ely1000k_2018'. It contains data related to ELY-areas in 2018 at a scale of 1:1 000 000, which is sourced from the 'Tilastokeskus' website in Finland. The table consists of various columns that store a range of data types, including geographic information and date-time data. Two columns, 'extract_date' and '_row_number', play a crucial role in uniquely identifying each row of data. The '_extract_date' column represents the date when the data row was extracted from the source, whereas '_row_number' provides the row number in the data extracted from the source on the specified extract date. Columns beginning with 'geom' are storing geospatial data, which can be leveraged for geospatial data analytics. The geographic coordinates are presented using the WGS 84 coordinate reference system, with axis order longitude first, followed by latitude. Other columns store information such as the area name in various languages, unique identifiers for the areas, and the year of data collection, among others. This rich dataset table could be used in various data analytics scenarios. For instance, one could analyze the spatial distribution of these areas, perform temporal analysis on the data extraction process, or conduct multilingual studies based on the different names given to the areas. Additionally, as the data is sourced from Finland, it could be useful in studies focused on this specific region.
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'. The combination of the columns '_extract_date' and '_row_number' uniquely identifies each row. |
|---|
| ely | string | This is a string type column that likely contains codes or identifiers related to the data. |
|---|
| geom_geojson | string | This column contains geometric data in the GeoJSON format. This data typically represents shapes or locations on a map. |
|---|
| geom_geotext | string | This column contains geometric data in a text format. Similar to the 'geom_geojson' column, it represents shapes or locations on a map. |
|---|
| geom_type | string | This column indicates the type of geometry stored in the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_centroid | string | This column contains the geometric center or centroid of the shape or location represented by the 'geom_geojson' and 'geom_geotext' columns. |
|---|
| geom_center_x | double | This column contains the X coordinate of the geometric centroid. |
|---|
| geom_center_y | double | This column contains the Y coordinate of the geometric centroid. |
|---|
| gml_id | string | This is a string type column that likely contains a unique identifier for each row in the table. |
|---|
| id | long | This is an integer type column that likely contains a unique identifier for each row in the table. |
|---|
| name | string | This is a string type column that likely contains names associated with the data in each row. |
|---|
| namn | string | This is a string type column that likely contains additional names or identifiers associated with the data in each row. |
|---|
| nimi | string | This is a string type column that likely contains additional names or identifiers associated with the data in each row. |
|---|
| vuosi | long | This is an integer type column that likely contains year information associated with the data in each row. |
|---|
