Database Schema

Configuration Tables

Edit these configuration tables to modify the GPV viewer behavior. These tables can be edited directly using a database utility such as SQL Server Management Studio or you can use the GPV Configurator, a Microsoft Access forms-based application.

See Database Schema History for a list of database changes since version 3.1.

Core

• New at 5.0 GPVSetting - individual settings for this instance of the GPV (formerly in the Web.config).
• Changed at 5.0 GPVApplication - lists all of the applications provided by this instance of the GPV.
• GPVApplicationMapTab - links map tabs to applications.
• Changed at 5.0 GPVMapTab - associates ArcGIS Server map services with map tabs.
• GPVMapTabLayer - links layers to map tabs.
• Changed at 5.0 GPVLayer - specifies the characteristics of map service layers in the GPV.
• New at 5.0 GPVMapTabTileGroup - links tile groups to map tabs.
• New at 5.0 GPVTileGroup - defines a set of tiled image layers that can be turned on and off as a group.
• New at 5.0 GPVTileLayer - specifies the characteristics of tiled image layers.

Layer Capabilities

• GPVConnection - provides connections to databases outside of the GPV configuration database.
• GPVDataTab - defines the data tabs associated with layers.
• GPVLayerFunction - defines the various database functions a layer can perform.
• GPVLayerProximity - links named search distances to layers.
• GPVProximity - defines named search distances.
• GPVQuery - defines the queries associated with layers.
• GPVSearch - defines search forms associated with layers.
• GPVSearchInputField - specifies individual search input fields for each search form.

Markup

• GPVApplicationMarkupCategory - links markup categories to applications.
• GPVMarkupCategory - lists all of the categories of map markup.
• Changed at 5.1 GPVMarkupGroup - stores markup groups created by users. *
• GPVMarkup - stores map markups created by users. *
• GPVMarkupSequence - stores the next ID for individual markups and groups. *

Printable Map

• GPVApplicationPrintTemplate - links printable maps to applications.
• GPVPrintTemplate - defines the page characteristics of printable maps.
• GPVPrintTemplateContent - defines the elements (text, boxes, maps) on printable maps.

Zones and Levels

• GPVZoneLevel - specifies common properties for a set of zones and levels.
• GPVLevel - lists the levels available in an application.
• GPVZone - lists the zones available in an application.
• GPVZoneLevelCombo - lists the valid combinations of zones and levels.

Miscellaneous

• GPVExternalMap - defines external web-based map viewers that can be launched from the GPV.
• GPVMailingLabel - contains mailing label layouts. *
• GPVSavedState - stores GPV application state for the email function. *
• GPVUsageTracking - logs each initiation of a GPV application. *
• GPVUser - assigns users to roles; also provides user accounts for Database Authentication.

* Does not contain configurable data.

Schema Diagram

All of the tables in the GPV are interrelated as shown in this diagram.