Diversity Workbench: Schema for Diversity Gazetteer information model, version '2.1.0003'.
Document last revised on 28.Sep.2003 9:54
Copyright 2001-2002 G. Hagedorn. All rights reserved.
Suggestions how to correct or improve the schema are welcome! Place name, preferred name, place type and hierarchy in several languages. The PlaceNameID can be used to further analyze the geographical place in GeoNameAnalysis and GeoPlaceAnalysis. ID within the DiversityGazetteer (only for the Getty TGN this is identical with the external ID, always use the analysis table to find coordinates, source, and original ID!). A place name in one of the supported languages. The preferred place name, usually in the local language (e.g. Deutschland instead of Germany). Empty if PlaceName = Preferred_PlaceName. Number referring to a list of defined place types (foreign key, PlaceType.PlaceTypeID). A list defining the hierarchy of geographical places above the current place, necessary to distinguish synonymous place names. The highest element of the hierarchy is identified through an ID to save storage space and allow simple analysis queries (foreign key). ... for North and Central America. ID within the DiversityGazetteer (only for the Getty TGN this is identical with the external ID, always use the analysis table to find coordinates, source, and original ID!). A place name in one of the supported languages. The preferred place name, usually in the local language (e.g. Deutschland instead of Germany). Empty if PlaceName = Preferred_PlaceName. Number referring to a list of defined place types (foreign key, PlaceType.PlaceTypeID). A list defining the hierarchy of geographical places above the current place, necessary to distinguish synonymous place names. The highest element of the hierarchy is identified through an ID to save storage space and allow simple analysis queries (foreign key). ... for South America. ID within the DiversityGazetteer (only for the Getty TGN this is identical with the external ID, always use the analysis table to find coordinates, source, and original ID!). A place name in one of the supported languages. The preferred place name, usually in the local language (e.g. Deutschland instead of Germany). Empty if PlaceName = Preferred_PlaceName. Number referring to a list of defined place types (foreign key, PlaceType.PlaceTypeID). A list defining the hierarchy of geographical places above the current place, necessary to distinguish synonymous place names. The highest element of the hierarchy is identified through an ID to save storage space and allow simple analysis queries (foreign key). ... for Asia. ID within the DiversityGazetteer (only for the Getty TGN this is identical with the external ID, always use the analysis table to find coordinates, source, and original ID!). A place name in one of the supported languages. The preferred place name, usually in the local language (e.g. Deutschland instead of Germany). Empty if PlaceName = Preferred_PlaceName. Number referring to a list of defined place types (foreign key, PlaceType.PlaceTypeID). A list defining the hierarchy of geographical places above the current place, necessary to distinguish synonymous place names. The highest element of the hierarchy is identified through an ID to save storage space and allow simple analysis queries (foreign key). ... for Europe. ID within the DiversityGazetteer (only for the Getty TGN this is identical with the external ID, always use the analysis table to find coordinates, source, and original ID!). A place name in one of the supported languages. The preferred place name, usually in the local language (e.g. Deutschland instead of Germany). Empty if PlaceName = Preferred_PlaceName. Number referring to a list of defined place types (foreign key, PlaceType.PlaceTypeID). A list defining the hierarchy of geographical places above the current place, necessary to distinguish synonymous place names. The highest element of the hierarchy is identified through an ID to save storage space and allow simple analysis queries (foreign key). ... for Oceania and Antarctica. ID within the DiversityGazetteer (only for the Getty TGN this is identical with the external ID, always use the analysis table to find coordinates, source, and original ID!). A place name in one of the supported languages. The preferred place name, usually in the local language (e.g. Deutschland instead of Germany). Empty if PlaceName = Preferred_PlaceName. Number referring to a list of defined place types (foreign key, PlaceType.PlaceTypeID). A list defining the hierarchy of geographical places above the current place, necessary to distinguish synonymous place names. The highest element of the hierarchy is identified through an ID to save storage space and allow simple analysis queries (foreign key). A translation of internal DiversityGazetteer name IDs to place IDs (each place may have several names) and to name IDs in external databases (compare GeoExternalDatabase). The ID of a name in the DiversityGazetteer (foreign key + part of primary key). The ID of a place in the DiversityGazetteer (foreign key). The ID of an external geographical data collection as defined in GeoExternalDatabase (foreign key). An ID number for a place name as defined in the external database (foreign key to separate module). Geographical coordinates for places and place IDs in external databases (compare GeoExternalDatabase). ID within the DiversityGazetteer for a place (which may have several names). Latitude as decimal number (double precision floating point, S negative, N positiv). Longitude as decimal number (double precision floating point, W negative, E positive). The ID of an external geographical data collection as defined in GeoExternalDatabase (foreign key + part of primary key). An ID number for geographical place (which may have several names) as defined in the external database. PlaceID of federal state or province (where available) // Currently a TopID, use GeoTopHierarchy table to find PlaceID! May later be changed, after checking associations in GeoTopHierarchy! PlaceID of political country // Currently a TopID, see above! PlaceID of region or continent // Currently a TopID, see above! A list of place types used in the PlaceName table. Place types help to identify places correctly and distinguish between homonymous place names. Internal ID for a place type (primary key). The ID has no meaning outside the DiversityGazetteer, i.e. it is not identical with an ID in a source data collection. Description or name of a place type. The place type name is displayed in the default picklist if marked here. The highest geographical elements are normalized into this separate table. All are present in the PlaceName table, but joining with that table would provide very bad performance. An ID for a place used in the geographical hierarchy of place names (primary key). The name in the preferred (mostly local) language. The name in English. If TopID refers to a state within a federal state (e.g. for U.S. and Germany) this ID refers to the true CountryID. Field is Null if Name itself is a country! The region as TopID (North & Central, South America, Europe, Asia, Africa, Oceania, Antarctica). GeoPlaceAnalysis.PlaceID corresponding to TopID (short integer). An association with the TGN place IDs is preferred; associations prefer nations over region. Historic problems may have to be checked, please inform us about problems you encounter! Description of data collections (Getty TGN, GN250, etc.) from which DiversityGazetteer names originate or which have been linked to these names. An ID to identify an external data collection of geographical names, places, or information (primary key, the ID has no meaning outside of the DiversityGazetteer). The name of the data collection that has been integrated or can be linked to for further analysis. The version of this data collection (either official version number, or dates when the collection was integrated). The table and field name to which GeoNameAnalysis.ExternalNameID refers in the external data collection. The table and field name to which GeoPlaceAnalysis.ExternalPlaceID refers in the external data collection. Free-text description of the precision and method with which coordinates are provided by external database. Additional notes concerning this data collection. Generic collection of enumerations and descriptions of objects which are identified through a text code. Such enumeration are frequently used to translate code values to user-readable text in reports and pick lists. A text string defining a group of values (= enumeration) for a specific use (part of primary key). A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it. Short abbreviated description of the object, displayed in the user interface. Description of enumerated object, displayed in the user interface. Internal development notes about usage, definition, etc. of an enumerated object. The order in which the entries are displayed. The order may be changed at any time, but all values must be unique. Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box). (potential root element for the namespace of current database subsystem)