LOCALITY
Referencing tables: analysis | attachment | attachment_link | collection | conop_distribution | dataset | dataset_geolocation | doi_geolocation | drillcore | image | locality_description | locality_image | locality_reference | locality_stratigraphy | locality_synonym | rock_locality | sample | sample_series | selection | site | specimen | specimen_union | stratigraphy_stratotype | taxon_occurrence | taxon_search | taxon_type_specimen |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| locality | varchar | ||
| locality_en | varchar | ||
| number | varchar | ||
| code | varchar | ||
| type | int | list_locality_type | |
| parent | int | locality | |
| coord_x | int | ||
| coord_y | int | ||
| coord_system | varchar | ||
| epsg | int | ||
| coordx | int | ||
| coordy | int | ||
| latitude | double | ||
| longitude | double | ||
| elevation | double | ||
| coord_det_precision | int | list_coordinate_precision | |
| coord_det_method | int | list_coordinate_method | |
| coord_det_agent | int | agent | |
| extent | int | list_locality_extent | |
| country | int | list_country | |
| maakond | int | list_maakond | |
| vald | int | list_vald | |
| asustusyksus | int | list_asustusyksus | |
| area | int | area | |
| remarks_location | text | ||
| depth | double | ||
| depth_basement | double | ||
| depth_bedrock | double | ||
| stratigraphy_base | int | stratigraphy | |
| stratigraphy_top | int | stratigraphy | |
| stratigraphy_base_free | varchar | ||
| stratigraphy_top_free | varchar | ||
| stratigraphy_start | varchar | ||
| stratigraphy_end | varchar | ||
| stratigraphy_id_start | int | ||
| stratigraphy_id_end | int | ||
| stratigraphy_free_start | varchar | ||
| stratigraphy_free_end | varchar | ||
| eelis | varchar | ||
| maaamet_pa_id | int | ||
| egt_id | int | ||
| mindat_id | int | ||
| is_private | tinyint | ||
| remarks | text | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| attachments | int | attachment |
