Version History of Reef Type Data from Geological Survey of Finland in Finland
Click here for a data sample
This table contains the version history of the rows extracted from the 'Geological Survey of Finland' website. The data represents information about different types of rock formations and their characteristics. The table includes various columns such as '_start_date', '_end_date', 'gml_id', 'objectid', 'tracttype', 'tractname', and several columns related to depth, estimated probabilities, mean estimates, shape area, shape length, and geometry. The '_start_date' column indicates the date when each row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version available. The table can be used for data analytics purposes, such as analyzing variations in the characteristics of rock formations over time, identifying the most common types of rock formations in different regions, estimating probabilities of certain features, and calculating mean estimates. The data can provide valuable insights into geological studies and research in Finland.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the validity period of the row version. |
|---|
| _end_date | date | The end date indicating the validity period of the row version. |
|---|
| _row_number | long | The number assigned to each row version. |
|---|
| gml_id | string | The id of the row version in GML format. |
|---|
| objectid | int | The unique identifier of the row version. |
|---|
| tracttype | string | The type of tract. |
|---|
| tractname | string | The name of the tract. |
|---|
| number_dep_10_percent_prob | int | The number of dependencies with 10 percent probability. |
|---|
| number_dep_50_percent_prob | int | The number of dependencies with 50 percent probability. |
|---|
| number_dep_90_percent_prob | int | The number of dependencies with 90 percent probability. |
|---|
| expected_number_of_dep | int | The expected number of dependencies. |
|---|
| cr_estim_10_percent_prob | int | The estimated count rate with 10 percent probability. |
|---|
| cr_estim_50_percent_prob | int | The estimated count rate with 50 percent probability. |
|---|
| cr_estim_90_percent_prob | int | The estimated count rate with 90 percent probability. |
|---|
| cr_mean_estimate | int | The mean estimate of the count rate. |
|---|
| shape_area | int | The area of the shape. |
|---|
| shape_len | int | The length of the shape. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in Geotext format. |
|---|
| geom_type | string | The type of 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 of the row version. |
|---|
