A lookup dictionary 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) |
| 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 |