PL0000: Map master table (8723 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
|
map_ID |
varchar(10) |
NO |
PRI |
|
|
| 366 |
map_series_ID |
varchar(8) |
YES |
|
|
|
| 202 |
map_or_sheet_name |
varchar(30) |
YES |
|
|
|
| 272 |
map_subsheet_name |
varchar(26) |
YES |
|
|
|
| 10101 |
map_published_sheet_name |
varchar(30) |
YES |
|
|
|
| 271 |
map_number |
varchar(25) |
YES |
|
|
|
| 205 |
map_scale |
decimal(10,0) |
YES |
|
|
|
| 367 |
map_type |
char(2) |
YES |
|
|
|
| 551 |
map_geodetic_datum |
varchar(20) |
YES |
|
|
|
| 552 |
map_height_datum |
varchar(20) |
YES |
|
|
|
| 553 |
map_grid |
varchar(20) |
YES |
|
|
|
| 554 |
map_geog_coords_shown_YN |
enum() |
YES |
|
|
|
| 555 |
map_vector_version_avail |
enum() |
YES |
|
|
|
| 556 |
map_raster_version_avail |
enum() |
YES |
|
|
|
| 370 |
map_source_country_code |
char(2) |
YES |
|
|
|
| 200 |
map_source_org_code |
char(3) |
YES |
|
|
|
| 396 |
map_source_type |
char(2) |
YES |
|
|
|
| 196 |
map_scope_country_code |
char(2) |
YES |
|
|
|
| 197 |
map_scope_state_code |
char(2) |
YES |
|
|
|
| 198 |
map_scope_area_code |
varchar(5) |
YES |
|
|
|
| 274 |
map_scope_N_latitude |
decimal(10,0) |
YES |
|
|
|
| 275 |
map_scope_S_latitude |
decimal(10,0) |
YES |
|
|
|
| 276 |
map_scope_E_longitude |
decimal(10,0) |
YES |
|
|
|
| 277 |
map_scope_W_longitude |
decimal(10,0) |
YES |
|
|
|
| 273 |
map_latest_update_year |
varchar(4) |
YES |
|
|
|
| 557 |
map_edition |
varchar(4) |
YES |
|
|
|
|
»------» |
PL0203: Cave map details (2400 rows of data)
| FID |
Field |
Type |
Null |
Key |
Default |
Extra |
|
map_ID |
varchar(10) |
NO |
PRI |
|
|
| 517 |
map_numberer_org_code |
char(3) |
YES |
|
|
|
| 201 |
map_sequence_number |
varchar(5) |
YES |
|
|
|
| 199 |
map_cave_serial_number |
varchar(4) |
YES |
|
|
|
| 203 |
map_survey_grade_org |
char(3) |
YES |
|
|
|
| 204 |
map_survey_grade_value |
varchar(8) |
YES |
|
|
|
| 206 |
map_views_shown |
char(3) |
YES |
|
|
|
| 607 |
map_survey_start_year |
varchar(4) |
YES |
|
|
|
| 207 |
map_survey_finish_year |
varchar(4) |
YES |
|
|
|
| 401 |
map_issue_year |
varchar(4) |
YES |
|
|
|
| 208 |
map_principal_surveyor_ID |
varchar(10) |
YES |
|
|
|
| 402 |
map_principal_drafter_ID |
varchar(10) |
YES |
|
|
|
| 211 |
map_host_area_map_ID |
varchar(10) |
YES |
|
|
|
| 212 |
map_restricted_YN |
int(11) |
YES |
|
|
|
| 213 |
map_microfilmed_YN |
int(11) |
YES |
|
|
|
| 403 |
map_digital_master_YN |
enum() |
YES |
|
|
|
| 214 |
map_sheet_size |
varchar(25) |
YES |
|
|
|
| 404 |
map_sheet_quantity |
int(11) |
YES |
|
|
|
| 580 |
map_biblio_updater_ID |
varchar(10) |
YES |
|
|
|
| 581 |
map_biblio_updater_org_ID |
varchar(9) |
YES |
|
|
|
| 217 |
map_biblio_updater_year |
varchar(4) |
YES |
|
|
|
|