Version History of Meluselvitys 2012 Alue 09 Maantietölädän Polygon from Helsingin kaupunkiympäristön toimiala in Finland
Click here for a data sample
This table, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland, contains the version history of the avoindatameluselvitys_2012_alue_09_maantiet_l_den__meluselvitys_2012_alue_09_maantiet_l_denpolygon table. It includes the '_start_date' and '_end_date' columns, which indicate when a particular row of the base table was extracted from the data source. The table consists of various columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', as well as the 'geom' column. These columns provide valuable data that can be utilized in data analytics to gain insights and perform various analyses.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | Date indicating the start of validity period for the row version |
|---|
| _end_date | date | Date indicating the end of validity period for the row version |
|---|
| _row_number | long | Sequential number assigned to each row version in the table |
|---|
| id | int | Unique identifier for the row |
|---|
| db_lo | int | Lower bound of a range for the row in the database |
|---|
| db_hi | int | Upper bound of a range for the row in the database |
|---|
| datanomist | string | Name of the data analyst who created or last updated the row version |
|---|
| paivitetty | string | Timestamp indicating when the row version was last updated |
|---|
| geom_geojson | string | Geometry of the row version in GeoJSON format |
|---|
| geom_geotext | string | Geometry of the row version in geotext format |
|---|
| geom_type | string | Type of geometry for the row version |
|---|
| geom_centroid | string | Centroid of the geometry for the row version |
|---|
| geom_center_x | double | X coordinate of the center of the geometry for the row version |
|---|
| geom_center_y | double | Y coordinate of the center of the geometry for the row version |
|---|
| geom | binary | Geometry object for the row version |
|---|
