_extract_date | date | This column stores the date that the data was extracted. |
_row_number | long | This column contains the row number of the data entry. |
gml_id | string | This column represents the GML identifier for the entry. |
objectid | int | This column stores the unique object identifier for each entry. |
id | int | This column stores the unique identifier for each entry. |
name | string | This column stores the name of the entry. |
alternative_names | string | This column stores the alternative names or aliases for the entry. |
easting_euref | int | This column stores the easting coordinate in the EUREF coordinate system. |
northing_euref | int | This column stores the northing coordinate in the EUREF coordinate system. |
easting_ykj | int | This column stores the easting coordinate in the YKJ coordinate system. |
northing_ykj | int | This column stores the northing coordinate in the YKJ coordinate system. |
commodity | string | This column stores the type of commodity associated with the entry. |
size_by_commodity | string | This column stores the size of the entry based on the commodity. |
all_main_commodities | string | This column stores the main commodities associated with the entry. |
ocurrence_type | string | This column stores the type of occurrence for the entry. |
mine_status | string | This column stores the status of the mine associated with the entry. |
discovery_year | int | This column stores the year of discovery for the entry. |
commodity_measure_total | string | This column stores the total measure of the commodity for the entry. |
resources_total | string | This column stores the total resources for the entry. |
calc_method | string | This column stores the calculation method used for the entry. |
calc_year | int | This column stores the year of calculation for the entry. |
province | string | This column stores the province or region associated with the entry. |
deposit_type | string | This column stores the type of deposit for the entry. |
host_rocks | string | This column stores the host rocks for the entry. |
deposit_shape | string | This column stores the shape of the deposit for the entry. |
length_m | int | This column stores the length of the deposit in meters. |
width_m | int | This column stores the width of the deposit in meters. |
thickness_m | int | This column stores the thickness of the deposit in meters. |
depth_m | int | This column stores the depth of the deposit in meters. |
date_updated | timestamp | This column stores the date when the entry was last updated. |
unfc_classification | string | This column stores the UNFC (United Nations Framework Classification) classification for the entry. |
other_commodities | string | This column stores other commodities associated with the entry. |
dip_azim | int | This column stores the dip azimuth for the entry. |
dip | int | This column stores the dip value for the entry. |
plunge_azim | int | This column stores the plunge azimuth for the entry. |
plunge_dip | int | This column stores the plunge dip value for the entry. |
wall_rocks | string | This column stores the wall rocks for the entry. |
current_holder | string | This column stores the current holder of the entry. |
district | string | This column stores the district or area associated with the entry. |
geom_geojson | string | This column stores the geometry of the entry in GeoJSON format. |
geom_geotext | string | This column stores the geometry of the entry in text format. |
geom_type | string | This column stores the type of geometry for the entry. |
geom_centroid | string | This column stores the centroid of the geometry for the entry. |
geom_center_x | double | This column stores the x-coordinate of the center of the geometry for the entry. |
geom_center_y | double | This column stores the y-coordinate of the center of the geometry for the entry. |
geom | binary | This column stores the geometry of the entry. |