Version History of Geological Survey Samples from Geologian tutkimuskeskus (Finland)
Click here for a data sample
This table contains the version history of the 'rajapinnat_gtk_kalliopera_wfsoku_kansannayteet__oku_kansannayteet' table sourced from the website of 'Geological Survey of Finland' in the country 'Finland'. It includes the extracted rows with additional columns such as '_start_date' and '_end_date'. Each row represents a specific version of the base table row, with '_start_date' indicating when the row was extracted, and '_end_date' showing the extraction date of the newer version. The table can be utilized for data analytics purposes, such as monitoring changes in the sampled points over time, analyzing spatial distribution, assessing sample types, and evaluating the organizations responsible for the samples.
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 unique row number identifier. |
|---|
| gml_id | string | The GML identifier of the row. |
|---|
| objectid | int | The identifier of the object. |
|---|
| northing | int | The northing coordinate value. |
|---|
| easting | int | The easting coordinate value. |
|---|
| northing_original | int | The original northing coordinate value. |
|---|
| easting_original | int | The original easting coordinate value. |
|---|
| sample_no | int | The sample number. |
|---|
| map_index | int | The index value of the map. |
|---|
| district | string | The district associated with the row. |
|---|
| sample_type | string | The type of the sample. |
|---|
| sample_type_c10 | string | The type of the sample with a code 10 designation. |
|---|
| organization | string | The organization associated with the row. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in geotext format. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry. |
|---|
