Mapviewer - Metadata

> MAPViewer

1 - About

The Metadata for Mapviewer are design with the tool map builder


3 - View

User and MDSYS View MDSYS Table Definition
user_sdo_styles sdo_styles_table this view stores individual map symbols and other types of styles such as: LINE patterns, COLOR definitions, and thematic mapping styles
user_sdo_themes sdo_themes_table this view stores the definitions of individual map layers or themes. A theme is always based on a data table or view, and specifies what rendering and labeling styles to be used.
user_sdo_maps sdo_maps_table this view stores the definitions of base maps. Each base map contains a list of themes. It specifies the display order and on/off status of each theme at various map scales.

4 - Export

CONNECT <username/password>
    CREATE TABLE styles AS SELECT * FROM user_sdo_styles;
    CREATE TABLE themes AS SELECT * FROM user_sdo_themes;
    CREATE TABLE maps AS SELECT * FROM user_sdo_maps;
    CREATE TABLE cached_maps AS SELECT * FROM user_sdo_cached_maps;
    EXP <username/password> file=mapviewer_meta.dmp TABLES=(styles,themes,maps,cached_maps)

5 - Documentation / Reference

  • Public User Synonym Come from the file mvdemo.sql from the demo zip file and from this excellent guide (Integration with OBIEE) )
mapviewer/metadata.txt · Last modified: 2017/09/13 21:21 by gerardnico