Helsinki Urban Environment Agency - Geospatial Data
Click here for a data sample
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, and 'geom' which represents the geometric data. This table can be utilized to perform various data analytics tasks such as spatial analysis, mapping, and data visualization, enabling insights and understanding of geographic characteristics of the data.
Field Descriptions
Name |
Data type |
Description |
_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 |