Water Sources - Helsinki City Environment Department, Finland
Click here for a data sample
This table contains data about open water sources in Helsinki, Finland. The data is sourced from the website of Helsingin kaupunkiympariston toimiala. The table includes information such as the extract date, row number, ID, class code, class name, name, description, notes, digitalization date, editing date, area, target text, metadata, GeoJSON geometry, GeoText geometry, geometry type, centroid geometry, centroid x-coordinate, centroid y-coordinate, and raw geometry data. Examples of how the data in this table could be utilized in data analytics include analyzing the distribution of open water sources across Helsinki, calculating the average area of different classes of water sources, or finding the nearest water source to a given location.
Field Descriptions
Name |
Data type |
Description |
_extract_date | date | The date the data was extracted |
_row_number | long | The row number of the data |
id | int | The identifier of the table row |
tunnus | int | The tunnus value |
luokkatunn | string | The luokkatunn value |
luokan_nim | string | The name of the luokan |
nimi | string | The name |
kuvaus | string | The description |
huom | string | The additional note |
digipvm | string | The digipvm value |
pvm_editoi | string | The pvm_editoi value |
pinta_ala | float | The pinta_ala value |
kohdetekst | string | The kohdetekst value |
metadata | string | The metadata information |
geom_geojson | string | The geometry in GeoJSON format |
geom_geotext | string | The geotext for the geometry |
geom_type | string | The type of the 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 |