Metadata Services for ArcIMS 10
Gazetteer Metadata Service database schema

Gazetteer Metadata Service database schema

A Gazetteer Metadata Service uses the same set of objects in the relational database to store and manage gazetteer places as a Metadata Service uses to manage metadata documents: one feature class, or ArcSDE layer, and four tables are created in the database. A Gazetteer Metadata Service�s objects are named the same way, using the table name prefix specified in the service�s ArcXML configuration file. For example, your configuration file will have an entry like this:

Given a table prefix of �gazetteer�, the following objects will be created in the database:

All of these tables have the same columns for a Gazetteer Metadata Service as for a regular Metadata Service, but different values are stored in some of the columns. Only the tables and columns that are used differently than for regular Metadata Services are listed below.

Business table: <prefix>

The business table associated with the Gazetteer Metadata Service�s feature class contains one record for each gazetteer place. An additional record represents the Metadata Service itself; this is the service�s root document. Each record has an XML document, a feature representing the extent in decimal degrees of the place, and additional properties and information about the place.

DatasetName (SE_STRING)�The description of the place; �Home� for the root document. Used in to uniquely identify the gazetteer place in the response.

Onlink (SE_STRING)�Not used.

Server (SE_STRING)�The gazetteer place's numeric rank; a value from 1 to 26.

Service (SE_STRING)�The place name.

ServiceType (SE_STRING)�The gazetteer place's alphanumeric rank; a value from A to Z. Used to order search results when the SEARCH_METADATA element's sort or sort2 attributes are set to "contenttype".

NumChildren (SE_INT32)�Not used.

NumSiblings (SE_INT32)�Not used.

Relevance (SE_INT32)�Not used.

Private (SE_INT32)�Not used.

Folder (SE_INT32)�Not used.

RefCount (SE_INT32)�Not used.

Xml (SE_XML)�An XML column. This column contains integers. A foreign key reference used to join the business table to the XML document table, which contains the gazetteer places. A gazetteer place XML documents consists of one root element, gazetteer-entry, that has the same value as the Service column; a text index is created on the value of the gazetteer-entry element. Value set based on the value of the PUT_GAZETTEER_ENTRY element.

Thumbnail (SE_BLOB)�Not used.

Deleted table: <prefix>D

Not used.

Deleted relationships table: <prefix>DR

Not used.

Relationships table: <prefix>R

Not used. Relationships are not recorded between gazetteer places or between gazetteer places and the Gazetteer Metadata Service's root document; therefore, if you try to browse the contents of a Gazetteer Metadata Service in ArcCatalog you won't see any gazetteer places.



Search code: @gazetteer_metadata_service_database_schema