Coordinate-based Sandstone Data from Geological Survey of Finland
Click here for a data sample
This table contains data from the 'Geological Survey of Finland' website. It consists of various fields such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'arkistonumero_arkistotunnus', 'tunnus_tarra', 'originaali_havaintonro_naytenr', 'hietyyppi', 'vuosiluku', 'havaintonumero', 'karttalehti_100k_kkj', 'karttalehti_20k_kkj', 'karttalehti_50k_utm', 'pohjoiskoordinaatti_epsg3067', 'itakoordinaatti_epsg3067', 'pohjoiskoordinaatti_kkj', 'itakoordinaatti_kkj', 'hieen_sailytyspaikka', 'alkuperainen_omistaja', 'kivilaji', 'kivilaji_alkuperainen', 'hiesyvyys_metri', 'paikka', 'kairareikatunnus', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides valuable data for data analytics purposes such as geological research, rock type analysis, depth analysis, geographical mapping, and location analysis. The table is sourced from the Geological Survey of Finland website, which originates from the country with the ISO country code 'FI' (Finland).
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted |
|---|
| _row_number | long | The row number of the record |
|---|
| gml_id | string | The ID in GML format |
|---|
| objectid | int | The unique object ID |
|---|
| arkistonumero_arkistotunnus | string | The archive number |
|---|
| tunnus_tarra | string | The label number |
|---|
| originaali_havaintonro_naytenr | float | The original observation number |
|---|
| hietyyppi | string | The type of sand |
|---|
| vuosiluku | int | The year |
|---|
| havaintonumero | float | The observation number |
|---|
| karttalehti_100k_kkj | int | The map sheet index in KKJ 100k |
|---|
| karttalehti_20k_kkj | int | The map sheet index in KKJ 20k |
|---|
| karttalehti_50k_utm | string | The map sheet index in UTM 50k |
|---|
| pohjoiskoordinaatti_epsg3067 | int | The northern coordinate in EPSG 3067 |
|---|
| itakoordinaatti_epsg3067 | int | The eastern coordinate in EPSG 3067 |
|---|
| pohjoiskoordinaatti_kkj | int | The northern coordinate in KKJ |
|---|
| itakoordinaatti_kkj | int | The eastern coordinate in KKJ |
|---|
| hieen_sailytyspaikka | string | The place of sand storage |
|---|
| alkuperainen_omistaja | string | The original owner |
|---|
| kivilaji | string | The rock type |
|---|
| kivilaji_alkuperainen | string | The original rock type |
|---|
| hiesyvyys_metri | float | The depth of sand in meters |
|---|
| paikka | string | The location |
|---|
| kairareikatunnus | int | The drillhole identifier |
|---|
| geom_geojson | string | The geometry in GeoJSON format |
|---|
| geom_geotext | string | The geometry 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 geometry center |
|---|
| geom_center_y | double | The Y-coordinate of the geometry center |
|---|
| geom | binary | The geometry |
|---|
