Water Stream Conduits - Version History
Click here for a data sample
This table contains the version history of the rows extracted from the 'Helsingin kaupunkiympariston toimiala' website, which originates from Finland. It has been named 'purojen_putkitetut_osuudetvesi_purojen_putkitetut_osuudetlinehistory'. The table includes additional columns compared to its base table: '_start_date' and '_end_date'. The '_start_date' column indicates the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it denotes that the row is the most recent version. The table has various columns such as 'id', 'tunnus', 'luokkatunn', 'luokan_nim', 'nimi', 'kuvaus', 'huom', 'digipvm', 'pvm_editoi', 'pinta_ala', 'kohdetekst', 'metadata', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table can be utilized in data analytics to track the changes made to the rows over time, analyze the historical trends and patterns, and perform geospatial analysis using the geometry-related columns.
Field Descriptions
| Name |
Data type |
Description |
| _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 number that represents the order of the row version. |
|---|
| id | int | The unique identifier of the row. |
|---|
| tunnus | string | The identifier of the row. |
|---|
| luokkatunn | string | The identifier of the row's class. |
|---|
| luokan_nim | string | The name of the row's class. |
|---|
| nimi | string | The name of the row. |
|---|
| kuvaus | string | The description of the row. |
|---|
| huom | string | Additional remarks or notes about the row. |
|---|
| digipvm | string | The date of digitization of the row. |
|---|
| pvm_editoi | string | The date when the row was last edited. |
|---|
| pinta_ala | string | The surface area of the row. |
|---|
| kohdetekst | string | The text describing the object in the row. |
|---|
| metadata | string | Additional metadata associated with the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | Textual representation of the row's geometry. |
|---|
| geom_type | string | The type of geometry of the row. |
|---|
| geom_centroid | string | The centroid of the row's geometry. |
|---|
| geom_center_x | double | The X coordinate of the center point of the row's geometry. |
|---|
| geom_center_y | double | The Y coordinate of the center point of the row's geometry. |
|---|
| geom | binary | The spatial data that represents the geometry of the row. |
|---|
