CA0000: Cave master table (6955 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
| 227 |
cave_id |
varchar(10) |
NO |
PRI |
|
|
| 1 |
karst_feature_type |
enum() |
YES |
|
|
|
| 9 |
quantity_of_entrances |
smallint(3) |
YES |
|
|
|
| 10 |
entrance_type |
enum() |
YES |
|
|
|
| 2 |
submersion |
enum() |
YES |
|
|
|
| 20 |
penetrability |
enum() |
YES |
|
|
|
| 3 |
flow_presence |
enum() |
YES |
|
|
|
| 4 |
flow_direction |
enum() |
YES |
|
|
|
| 5 |
internal_flow |
enum() |
YES |
|
|
|
| 6 |
internal_water |
enum() |
YES |
|
|
|
| 56 |
length |
decimal(10,1) |
YES |
|
|
|
| 57 |
length_method |
enum() |
YES |
|
|
|
| 58 |
length_accuracy |
decimal(10,2) |
YES |
|
|
|
| 511 |
vertical_extent |
decimal(7,2) |
YES |
|
|
|
| 59 |
extent_below_entrance |
decimal(8,2) |
YES |
|
|
|
| 60 |
extent_above_entrance |
decimal(8,2) |
YES |
|
|
|
| 61 |
vertical_method |
enum() |
YES |
|
|
|
| 62 |
vertical_accuracy |
decimal(7,2) |
YES |
|
|
|
| 63 |
length_of_largest_chamber |
decimal(8,2) |
YES |
|
|
|
| 64 |
width_of_largest_chamber |
decimal(8,2) |
YES |
|
|
|
| 65 |
height_of_largest_chamber |
decimal(8,2) |
YES |
|
|
|
| 67 |
extent_length |
decimal(8,1) |
YES |
|
|
|
| 68 |
extent_width |
decimal(8,1) |
YES |
|
|
|
| 297 |
length_category |
enum() |
YES |
|
|
|
| 527 |
depth_category |
enum() |
YES |
|
|
|
| 21 |
latitude_coarse |
decimal(8,4) |
YES |
|
|
|
| 22 |
longitude_coarse |
decimal(9,4) |
YES |
|
|
|
| 23 |
map_sheet_name_coarse |
varchar(30) |
YES |
|
|
|
| 26 |
grid_reference_coarse |
varchar(4) |
YES |
|
|
|
| 25 |
grref_qualifier_coarse |
varchar(4) |
YES |
|
|
|
| 27 |
nearest_locality |
varchar(30) |
YES |
|
|
|
| 28 |
altitude_coarse |
decimal(7,1) |
YES |
|
|
|
| 29 |
degree_explored |
enum() |
YES |
|
|
|
| 42 |
owner_type |
enum() |
YES |
|
|
|
| 44 |
management_classifier |
varchar(8) |
YES |
|
|
|
| 45 |
management_category |
enum() |
YES |
|
|
|
| 47 |
controller |
varchar(8) |
YES |
|
|
|
| 54 |
percent_mapped |
smallint(4) |
YES |
|
|
|
| 78 |
entrance_marking |
enum() |
YES |
|
|
|
| 13 |
minimum_temperature |
decimal(5,1) |
YES |
|
|
|
| 14 |
maximum_temperature |
decimal(5,1) |
YES |
|
|
|
| 15 |
minimum_humidity |
decimal(6,1) |
YES |
|
|
|
| 16 |
maximum_humidity |
decimal(6,1) |
YES |
|
|
|
| 17 |
moisture_level |
enum() |
YES |
|
|
|
| 228 |
owner_person_id |
varchar(10) |
YES |
|
|
|
| 417 |
owner_organisation_id |
varchar(9) |
YES |
|
|
|
| 418 |
owner_name |
varchar(60) |
YES |
|
|
|
| 229 |
local_government_area |
varchar(30) |
YES |
|
|
|
| 230 |
update_status |
char(2) |
YES |
|
|
|
| 220 |
country_in_cave_number |
char(2) |
YES |
|
|
|
| 18 |
state_in_cave_number |
enum() |
YES |
|
|
|
| 19 |
area_in_cave_number |
char(3) |
YES |
|
|
|
| 77 |
serial_in_cave_number |
varchar(11) |
YES |
|
|
|
| 303 |
area_lookup |
varchar(7) |
YES |
|
|
|
|
»------» |
CA0245: Cave exact position (5752 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
| 227 |
cave_id |
varchar(10) |
NO |
PRI |
|
|
|
value_sequence |
smallint(5) |
NO |
PRI |
|
|
| 245 |
position_latitude |
decimal(11,7) |
YES |
|
|
|
| 246 |
position_longitude |
decimal(12,7) |
YES |
|
|
|
| 514 |
position_geog_precision |
decimal(8,5) |
YES |
|
|
|
| 515 |
position_geog_accuracy |
decimal(8,5) |
YES |
|
|
|
| 247 |
position_grid_zone |
char(3) |
YES |
|
|
|
| 248 |
position_sheet_number |
varchar(4) |
YES |
|
|
|
| 249 |
position_easting |
decimal(10,3) |
YES |
|
|
|
| 250 |
position_northing |
decimal(12,3) |
YES |
|
|
|
| 251 |
position_grid_ref_units |
char(1) |
YES |
|
|
|
| 252 |
position_gref_precision |
decimal(10,3) |
YES |
|
|
|
| 300 |
position_gref_accuracy |
decimal(10,3) |
YES |
|
|
|
| 625 |
position_geodetic_datum |
varchar(30) |
YES |
|
|
|
| 626 |
position_map_grid |
varchar(30) |
YES |
|
|
|
| 628 |
position_method |
char(2) |
YES |
|
|
|
| 631 |
position_date |
date |
YES |
|
|
|
| 442 |
altitude |
decimal(10,3) |
YES |
|
|
|
| 443 |
altitude_units |
char(1) |
YES |
|
|
|
| 444 |
altitude_precision |
decimal(8,3) |
YES |
|
|
|
| 445 |
altitude_accuracy |
decimal(8,3) |
YES |
|
|
|
| 627 |
altitude_height_datum |
varchar(30) |
YES |
|
|
|
| 441 |
fifthsmallest_land_unit |
varchar(30) |
YES |
|
|
|
| 253 |
fourthsmallest_land_unit |
varchar(30) |
YES |
|
|
|
| 254 |
thirdsmallest_land_unit |
varchar(30) |
YES |
|
|
|
| 255 |
secondsmallest_land_unit |
varchar(30) |
YES |
|
|
|
| 256 |
smallest_land_unit |
varchar(10) |
YES |
|
|
|
| 365 |
special_land_parcel |
varchar(30) |
YES |
|
|
|
|