-- execute the following SQL statements in sqlplus or SqlDeveloper as the mvdemo2 (or nedata) user
-- to add the required theme, map, and tile layers for the Dy Tile Layer examples
-- set define off is needed so the the ampersand in > is not treated as a substitution variable
set define off;
insert into user_sdo_themes values ('UTFGRID_THEME_DEMO_CITIES', 'for utfgrid testing', 'CITIES_US', 'LOCATION',
'
(pop90 between 200000 AND 1000000 ) (pop90 between 0 and 200000) ') ;
insert into user_sdo_themes values ('UTFGRID_THEME_DEMO_COUNTIES', 'for utfgrid testing', 'COUNTIES', 'GEOM',
'
') ;
insert into user_sdo_themes values ('UTFGRID_THEME_DEMO_STATES', 'for utfgrid testing', 'STATES', 'GEOM',
'
') ;
insert into user_sdo_themes values ('UTFGRID_THEME_DEMO_HIGHWAYS', 'for utfgrid testing', 'INTERSTATES', 'GEOM',
'
') ;
insert into user_sdo_themes values ('THEME_US_DYN_HIGHWAYS', 'dynamic theme for utfgrid testing', 'INTERSTATES', 'GEOM',
'
ROUTEN=:1 ') ;
insert into user_sdo_themes values ('THEME_US_DYN_COUNTIES', 'dynamic theme for utfgrid testing', 'COUNTIES', 'GEOM',
'
COUNTY=:1 TOTPOP>:2 ') ;
insert into user_sdo_themes values ('THEME_US_DYN_STATES', 'dynamic theme for utfgrid testing', 'STATES', 'GEOM',
'
state_abrv=:1 ') ;
insert into user_sdo_maps values ('COUNTY_UTFGRID_BASEMAP', null,
'
') ;
insert into user_sdo_maps values ('UTFGRID_BASEMAP', null,
'
') ;
insert into user_sdo_cached_maps values('UTFGRID_TL', null, null, 'YES', 'YES',
'
', 'UTFGRID_BASEMAP', null);
insert into user_sdo_cached_maps values('COUNTY_UTFGRID_TL', null, null, 'YES', 'YES',
'
', 'COUNTY_UTFGRID_BASEMAP', null);
update user_sdo_themes set styling_rules =
'
'
where name = 'THEME_DEMO_COUNTY_POPDENSITY';