Expired mineral exploration and mining claim areas
Click here for a data sample
This table contains data from the 'Geological Survey of Finland' sourced from the website of the organization. The data represents information about exploration permits and mining areas related to the extraction of minerals. The table includes various attributes such as the extraction date, row number, GML ID, object ID, permit number, permit name, permit holder, application date, granted date, expiration date, type of mineral being explored, map sheet, municipality, report and data hyperlinks, report status, shape area, shape length, geometric data in GeoJSON and Geotext formats, geometric type, centroid coordinates, and full geometric representation. The table provides valuable information for conducting data analytics related to the exploration and mining activities in the region. It can be utilized to analyze the distribution of permits across different municipalities, track the progress of permit applications over time, determine the types of minerals being explored, examine the spatial characteristics of mining areas, calculate the size of the exploration areas, and extract valuable insights for decision-making processes in the mineral extraction sector. The data is specific to the country with the ISO country code 'fi', which refers to Finland.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted |
|---|
| _row_number | long | The unique identifier for each row |
|---|
| gml_id | string | The GML ID of the object |
|---|
| objectid | int | The unique identifier of the object |
|---|
| permit_number | string | The number associated with the permit |
|---|
| permit_name | string | The name of the permit |
|---|
| permit_holder | string | The name of the permit holder |
|---|
| application_date | timestamp | The date when the application was made for the permit |
|---|
| granted_date | timestamp | The date when the permit was granted |
|---|
| expiration_date | timestamp | The date when the permit expires |
|---|
| exploration_mineral | string | The type of mineral for exploration |
|---|
| exploration_mineral_en | string | The type of mineral for exploration in English |
|---|
| exploration_mineral_fi | string | The type of mineral for exploration in Finnish |
|---|
| map_sheet_20 | int | The map sheet containing the area |
|---|
| municipality | string | The municipality where the permit is located |
|---|
| report_hyperlink | string | The hyperlink to the report |
|---|
| data_hyperlink | string | The hyperlink to the data |
|---|
| report_status | string | The status of the report |
|---|
| shape_area | int | The area of the shape |
|---|
| shape_len | int | The length of the shape |
|---|
| geom_geojson | string | The geometry of the object in GeoJSON format |
|---|
| geom_geotext | string | The geometry of the object 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 object |
|---|
