Statistical Areas Dataset for Pornainen, Finland
Tables
-
Polygon Statistical Areas in Pornainen, FinlandTSV
This table contains statistical data for the municipality areas in Pornainen. It provides information such as the extract date, row number, total area, municipality name, area size, status, name in Finnish and ISO name, group, geographic polygann as geojson, geographic polygann as geotext, geographic polygann type, centroid of the geographic polygann, center x-coordinate of the geographic polygann, center y-coordinate of the geographic polygann, and the full geographic polygann. The data in this table can be utilized for various data analytics tasks such as analyzing the distribution of municipal areas, calculating the size of different areas, comparing the status of different areas, visualizing geographic boundaries, and conducting spatial analysis. The table is sourced from the...
-
Version History of Area Statistics in Pornainen, FinlandTSV
This table contains the version history of rows from the table 'seutukarttapornainen_tilastoalueet__pornainen_tilastoalueetpolygon'. The rows in this table represent the different versions of the base table rows, with each version having a corresponding '_start_date' and '_end_date' indicating the extraction dates. The base table provides various information such as 'kokotun', 'kunta', 'suur', 'tila', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. This version history table can be utilized in data analytics by tracking changes and analyzing trends over time. For example, it can be used to identify when and how certain attributes of the base table rows have changed, monitor update frequencies, and...
Column Descriptions
Polygon Statistical Areas in Pornainen, Finland
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the row was extracted |
_row_number | long | The row number in the table |
kokotun | int | The size of the object |
kunta | int | The municipality of the object |
suur | string | The area of the object |
tila | int | The status of the object |
nimi | string | The name of the object |
nimi_iso | string | The ISO name of the object |
mtryhm | int | The object's main group |
geom_geojson | string | The geometry in GeoJSON format |
geom_geotext | string | The geometry in geotext format |
geom_type | string | The type of geometry |
geom_centroid | string | The centroid of the geometry |
geom_center_x | double | The X-coordinate of the center of the geometry |
geom_center_y | double | The Y-coordinate of the center of the geometry |
geom | binary | The geometry |
Version History of Area Statistics in Pornainen, Finland
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period for the row version. |
_end_date | date | The end date of the validity period for the row version. |
_row_number | long | The assigned number of the row version. |
kokotun | int | Description not available. |
kunta | int | Description not available. |
suur | string | Description not available. |
tila | int | Description not available. |
nimi | string | Description not available. |
nimi_iso | string | Description not available. |
mtryhm | int | Description not available. |
geom_geojson | string | Description not available. |
geom_geotext | string | Description not available. |
geom_type | string | Description not available. |
geom_centroid | string | Description not available. |
geom_center_x | double | Description not available. |
geom_center_y | double | Description not available. |
geom | binary | Description not available. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 22, 2018 |