Version History of Meluselvitys 2012 Zone 12 Rautatiet L Yo Polygon
Click here for a data sample
This table contains the version history of rows from the 'avoindatameluselvitys_2012_alue_12_rautatiet_l_yo__meluselvitys_2012_alue_12_rautatiet_l_yopolygon' table, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. The table includes additional columns '_start_date' and '_end_date' which represent the extraction dates of each row. The data in this table can be utilized for various data analytics purposes such as trend analysis, historical comparisons, and identifying changes over time. The table provides insights into the noise assessment areas related to railways in Finland, including information such as identifier, data boundaries, data owner, last update date, geometry representation in both GeoJSON and Geotext formats, geometry type, centroid representation, centroid x-coordinate, centroid y-coordinate, and the actual geometry.
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 | A sequential number to identify the row version within the table. |
|---|
| id | int | The unique identifier for each row in the table. |
|---|
| db_lo | int | A lower bound value for a range of database values. |
|---|
| db_hi | int | An upper bound value for a range of database values. |
|---|
| datanomist | string | The name of the data scientist responsible for the row version. |
|---|
| paivitetty | string | The date and time when the row version was last updated. |
|---|
| geom_geojson | string | The geometry of the row version represented in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version represented in Geotext format. |
|---|
| geom_type | string | The type of geometry for the row version. |
|---|
| geom_centroid | string | The centroid of the geometry for the row version. |
|---|
| geom_center_x | double | The X-coordinate of the center point of the geometry for the row version. |
|---|
| geom_center_y | double | The Y-coordinate of the center point of the geometry for the row version. |
|---|
| geom | binary | The geometry object for the row version. |
|---|
