Dataset collection 'testtest' from Helsingin kaupunkiympariston toimiala in Finland
Tables
-
Helsinki Urban Environment Agency - Geospatial DataTSV
This table contains data from the website of Helsingin kaupunkiympäristön toimiala, originating from the country Finland (ISO country code 'fi'). The table 'testtest__test' is a collection of various data related to geographic locations. It includes columns such as '_extract_date' which represents the date when the data was extracted, '_row_number' indicating the row number of each entry, 'geom_geojson' providing the geographic data in GeoJSON format, 'geom_geotext' representing the geographic information in plain text format, 'geom_type' indicating the type of geometry, 'geom_centroid' providing the centroid coordinates of the geometry, 'geom_center_x' representing the X coordinate of the geometry center point, 'geom_center_y' representing the Y coordinate of the geometry center point,...
-
Version History of Test Test Rows from Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of the 'testtesttest' table sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland. The table includes various columns such as '_start_date', '_end_date', '_row_number', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it indicates that the row is the most recent version. This table can be used in data analytics to analyze the changes in the geographic information, such as the centroid and type of geometry, over time. By comparing different versions of the...
Column Descriptions
Helsinki Urban Environment Agency - Geospatial Data
Column | Type | Comment |
---|---|---|
_extract_date | date | The date when the row was extracted |
_row_number | long | The unique row number |
geom_geojson | string | The geographic data in GeoJSON format |
geom_geotext | string | The geographic data in GeoText format |
geom_type | string | The type of geometric shape |
geom_centroid | string | The centroid point of the geometric shape |
geom_center_x | double | The x-coordinate of the center point of the geometric shape |
geom_center_y | double | The y-coordinate of the center point of the geometric shape |
geom | binary | The raw geometric data |
Version History of Test Test Rows from Helsingin kaupunkiympariston toimiala (Finland)
Column | Type | Comment |
---|---|---|
_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The unique identifier of the row version. |
geom_geojson | string | The geometry of the row version in GeoJSON format. |
geom_geotext | string | The geometry of the row version in GeoText format. |
geom_type | string | The type of geometry for the row version. |
geom_centroid | string | The centroid of the geometry for the row version. |
geom_center_x | double | The x-coordinate of the center point of the geometry for the row version. |
geom_center_y | double | The y-coordinate of the center point of the geometry for the row version. |
geom | binary | The geometry of the row version. |
Additional Info
Last Updated | September 13, 2024 |
---|---|
Created | October 22, 2018 |