Version History of Animal Observations (Miscellaneous) from Helsinki City Environment Agency, Finland
Click here for a data sample
This table represents the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website in the country 'Finland'. It contains historical data from the 'ltj_avoinmuu_elainhavaintoja__muu_elainhavaintojapoint' base table. Each row in this table corresponds to a specific version of a row in the base table and includes additional columns '_start_date' and '_end_date' which represent the extraction dates of the row versions. The data in this table can be used for various data analytics purposes such as analyzing the changes and updates to the 'muu_elainhavaintojapoint' data over time, tracking the evolution of different attributes and properties associated with the observations of other animal species, conducting trend analysis, and performing temporal analysis on the spatial data provided in the 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' columns.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | The sequence number of the row version. |
|---|
| id | int | The identifier of the row. |
|---|
| tunnus | int | The identifier for the row. |
|---|
| luokkatunn | string | The identifier for the class. |
|---|
| luokan_nim | string | The name of the class. |
|---|
| nimi | string | The name of the row. |
|---|
| kuvaus | string | The description of the row. |
|---|
| huom | string | Additional notes for the row. |
|---|
| digipvm | string | The digital date of the row. |
|---|
| pvm_editoi | string | The date of the row edit. |
|---|
| suojaustas | int | The security level of the row. |
|---|
| pinta_ala | int | The surface area of the row. |
|---|
| kohdetekst | string | The target text of the row. |
|---|
| lajinimi | string | The name of the species. |
|---|
| havainnon | string | The observation of the row. |
|---|
| havaintosa | string | The secondary observation of the row. |
|---|
| metadata | string | Any additional metadata for the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in geotext format. |
|---|
| geom_type | string | The type of geometry for the row. |
|---|
| geom_centroid | string | The centroid of the row's geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center of the row's geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the row's geometry. |
|---|
| geom | binary | The geometry of the row. |
|---|
