Waterway Pipe Shares in Open Waterways
Click here for a data sample
This table contains data sourced from the website of Helsingin kaupunkiympariston toimiala in Finland (ISO country code: 'fi'). It contains information about the various attributes of the ltj_avoinvesi_purojen_putkitetut_osuudet__vesi_purojen_putkitetut_osuudetline table. The table may be utilized for data analytics purposes, such as analyzing the distribution of 'pinta_ala' (surface area) across different 'luokkatunn' (class identifiers) or studying the relationship between 'geom_geojson' (geographical JSON object) and 'metadata' (additional information). It can also be used to explore the 'kuvaus' (description) and 'nimi' (name) associated with each entry. The 'huom' (note) field could be used to identify any specific notes or comments about each entry. The 'digipvm' (digital date) and 'pvm_editoi' (date edited) columns may be used to track the timeline or revision history of the data. The 'kohdetekst' (target text) attribute provides textual information about each entry, while the 'geom_type' (geometry type) and 'geom_centroid' (centroid) columns offer insights into the spatial aspects of the data. Finally, the 'geom' column contains the geometric data associated with each entry in a non-text format.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted |
|---|
| _row_number | long | The row number of the data entry |
|---|
| id | int | The unique identifier of the entry |
|---|
| tunnus | string | The tunnus of the entry |
|---|
| luokkatunn | string | The luokkatunn of the entry |
|---|
| luokan_nim | string | The name of the luokka |
|---|
| nimi | string | The name of the entry |
|---|
| kuvaus | string | The description of the entry |
|---|
| huom | string | Additional notes about the entry |
|---|
| digipvm | string | The digital date of the entry |
|---|
| pvm_editoi | string | The date when the entry was edited |
|---|
| pinta_ala | string | The surface area of the entry |
|---|
| kohdetekst | string | The target text of the entry |
|---|
| metadata | string | The metadata associated with the entry |
|---|
| geom_geojson | string | The geometric data in GeoJSON format |
|---|
| geom_geotext | string | The geometric data in Geotext format |
|---|
| geom_type | string | The type of geometric data |
|---|
| geom_centroid | string | The centroid of the geometric data |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometric data |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometric data |
|---|
| geom | binary | The geometric data |
|---|
