WORLD_GAZETTEER_DIC
Dictionary table which expands the CODE field in WORLD_GAZETTEER. Data are derived from the Digital Chart of the World (DCW).
| No. |
Column name |
Data type |
Notes |
| 1 |
CODE |
Varchar(1) |
Primary key
|
| 2 |
TYPE |
Varchar(20) |
|
Sample data (rows 1 to 18 of 18)
| CODE |
TYPE |
| W |
Administrative name |
| A |
Airport |
| B |
Built up area |
| C |
Country name |
| U |
Cultural landmark |
| E |
Desert name |
| D |
Drainage feature |
| H |
Drainage point |
| I |
Island name |
| K |
Kampong |
| L |
Land place name |
| M |
Mountain name |
| S |
Ocean feature line |
| T |
Ocean feature point |
| O |
Ocean place name |
| P |
Populated place |
| ? |
United States |
| V |
Village |
