Diversity Gazetteer
The following objects are not included:
- Logging tables
- Enumeration tables
- System objects
- Objects marked as obsolete
- Previous versions of objects
Tables, …
Table ExternalDatabase
External datasource of the data
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ExternalDatabaseID | int | ID of the source, PK | NO | - |
| ExternalDatabaseName | nvarchar (60) | Name of the external datasource | NO | - |
| ExternalDatabaseVersion | nvarchar (255) | Version of the external datasource | NO | - |
| ExternalAttribute_NameID | nvarchar (255) | Attribute of the extarnal source for mapping the data in table GeoName | YES | - |
| ExternalAttribute_PlaceID | nvarchar (255) | Attribute of the extarnal source for mapping the data in table GeoPlace | YES | - |
| ExternalCoordinatePrecision | nvarchar (255) | Description of the coordinate precision in the external source | YES | - |
| InternalNotes | nvarchar (MAX) | Notes concerning the import of the data | YES | - |
Table GeoCache
Cached values for the hierarchy of places
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| PlaceID | int | Primary key as defined in table GeoPlace | NO | - |
| Country | nvarchar (100) | The cached country derived from GeoName via the Hierarchy defined in GeoPlace via the SuperiorPlaceID | YES | - |
| HierarchyPlaceToCountry | nvarchar (2000) | The cached hierarchy from the place to the country derived from GeoName via the Hierarchy defined in GeoPlace via the SuperiorPlaceID | YES | - |
| HierarchyCountryToPlace | nvarchar (2000) | The cached hierarchy from the country to the place derived from GeoName via the Hierarchy defined in GeoPlace via the SuperiorPlaceID | YES | - |
| SuperiorPlaceID | int | Temporary used value for the superior place ID - empty after successful update of the cache values | YES | - |