Mapviewer - SH Customer Density Semi-Static Map

You must have the sh schema and the spatial demo files installed.

As sys :

GRANT SELECT ANY TABLE TO MVDEMO;

As mvdemo :

CREATE TABLE t_sh_customer_density AS (
SELECT STATE_ABRV, 
(
SELECT count(DISTINCT T245.CUST_ID)
FROM 
     SH.COUNTRIES T175,
     SH.CUSTOMERS T186,
     SH.SALES T245
WHERE  
  T175.COUNTRY_ID = T186.COUNTRY_ID 
  AND T175.COUNTRY_NAME = 'United States of America' 
  AND T186.CUST_ID = T245.CUST_ID
  AND state_abrv = T186.CUST_STATE_PROVINCE
) CountCustomers, 
geom  
FROM
mvdemo.states
)

INSERT INTO USER_SDO_GEOM_METADATA VALUES (
    'sh_customer_density', 
    'GEOM', 
        MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X', -180, 180, .00000005), 
                            MDSYS.SDO_DIM_ELEMENT('Y', -90, 90, .00000005)),
        8307);
 
CREATE INDEX t_sh_customer_density_SDX ON t_sh_customer_density(GEOM)
indextype IS mdsys.spatial_index;

With Oracle Maps, labels are manifest as tool-tips on mouse-over the feature on the map.

cx : -96.554346 cy : 38.987208 height : 42.081234

Location :

• In Map Builder / node Tile Layers
• In MapViewer : Admin (Type the oc4j admin credentials) / Management / Manage Map Tile Layers / Create

Zoom Level Definition :

To know more about how to define the zoom level : Point Center and Zoom Level Definition

The tutorial is provided with the installation of MapViewer on this url :

• http://mapviewerhost:9704/mapviewer/fsmc/tutorial/samples/showMap.html

<script language=javascript>
  function showMap()
  {	
    var baseURL  = "http://"+document.location.host+"/mapviewer";
    var mapCenterLon =  -96.554346;
    var mapCenterLat =  38.987208;
    var mapZoom      =  0;
    var mpoint = MVSdoGeometry.createPoint(mapCenterLon,mapCenterLat,8307);
    var mapview = new MVMapView(document.getElementById("map"), baseURL);
    mapview.addMapTileLayer(new MVMapTileLayer("mvdemo.SH_CUST_DENSITY_MAP")); 
    mapview.setCenter(mpoint); 
    mapview.setZoomLevel(mapZoom);    
    mapview.display();  			
  }
</script>

See this article on how to retrieve debug information : Mapviewer debugging - log

You have forgotten to create the spatial index.

 
Message:Exception while querying theme: THEME_SH_CUST_DENSITY
Description: Nested exception is:
java.sql.SQLException: ORA-13226: interface not supported without a spatial index
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 8
ORA-06512: at "MDSYS.SDO_3GL", line 1173