Water runoff areas - Streams and Ponds
Click here for a data sample
This table contains data on open water areas, brooks, and flowing water areas. It includes information such as the date of extraction, row number, unique identifier, class code, class name, name, description, remarks, digital date, editing date, surface area, target text, metadata, geojson format geometry, geotext format geometry, geometry type, centroid of geometry, center x-coordinate of geometry, center y-coordinate of geometry, and geometry itself. The data in this table can be utilized for various data analytics purposes such as studying the distribution and characteristics of open water areas, brooks, and flowing water areas in Helsingin kaupunkiympariston toimiala, which is a data source available on the website of Helsinki City Environment Sector. This data source originates from Finland (ISO country code: fi)
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date on which the row was extracted. |
|---|
| _row_number | long | A unique identifier for each row in the table. |
|---|
| id | int | The unique identifier for each record in the table. |
|---|
| tunnus | string | A code or identifier for each record. |
|---|
| luokkatunn | string | A code or identifier for the class. |
|---|
| luokan_nim | string | The name of the class. |
|---|
| nimi | string | The name of the record or object. |
|---|
| kuvaus | string | A description or summary of the record or object. |
|---|
| huom | string | Additional notes or comments about the record or object. |
|---|
| digipvm | string | The date on which the record was created or digitized. |
|---|
| pvm_editoi | string | The date on which the record was last edited or modified. |
|---|
| pinta_ala | float | The surface area of the object in square units. |
|---|
| kohdetekst | string | Additional text or details about the object. |
|---|
| metadata | string | Metadata or additional information about the record or object. |
|---|
| geom_geojson | string | The geometry of the object in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the object in Well-known Text (WKT) format. |
|---|
| geom_type | string | The type of geometry of the object. |
|---|
| geom_centroid | string | The centroid of the geometry of the object. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry of the object. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry of the object. |
|---|
| geom | binary | The geometry of the object. |
|---|
