_start_date | date | The start date of the validity period of the row version. |
_end_date | date | The end date of the validity period of the row version. |
_row_number | long | The row number of the version history. |
gml_id | string | The GML ID of the row version. |
objectid | int | The object ID of the row version. |
mine_id | int | The ID of the mine associated with the row version. |
mine_name | string | The name of the mine associated with the row version. |
mine_status | string | The status of the mine associated with the row version. |
mining_start_year | int | The start year of mining for the mine associated with the row version. |
mining_end_year | int | The end year of mining for the mine associated with the row version. |
years_mined | int | The total number of years the mine has been in operation. |
main_commodity_mined | string | The main commodity mined at the mine. |
size_by_main_commodity | string | The size of the mine based on the main commodity mined. |
production | string | The production value of the mine. |
total_ore_mined | string | The total amount of ore mined at the mine. |
total_ore_processed | string | The total amount of ore processed at the mine. |
total_waste_mined | string | The total amount of waste material mined at the mine. |
main_commodities_deposit | string | The main commodities found in the deposit. |
deposit_name | string | The name of the deposit. |
deposit_id | int | The ID of the deposit. |
easting_euref | int | The easting coordinate in the EUREF coordinate reference system. |
northing_euref | int | The northing coordinate in the EUREF coordinate reference system. |
easting_ykj | int | The easting coordinate in the YKJ coordinate reference system. |
northing_ykj | int | The northing coordinate in the YKJ coordinate reference system. |
date_updated | timestamp | The date when the row version was last updated. |
current_holder | string | The current holder of the mine. |
other_commodities_deposit | string | Other commodities found in the deposit. |
resources_total | string | The total amount of resources in the mine. |
reserves_total | string | The total amount of reserves in the mine. |
calc_method | string | The method used to calculate the resources and reserves. |
calc_year | int | The year in which the resources and reserves were calculated. |
mine_alternative_names | string | Alternative names for the mine. |
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 of the row version. |
geom_centroid | string | The centroid of the row version geometry. |
geom_center_x | double | The x-coordinate of the center of the row version geometry. |
geom_center_y | double | The y-coordinate of the center of the row version geometry. |
geom | binary | The full geometry of the row version. |