/*
Setup source data from here
http://www.sharpgis.net/post/2008/02/24/Creating-OGC-conformance-test-map-in-SQL-Server-2008.aspx
*/
SELECT neatline, 'Background' as name, 'map_neatlines' as layer, 'White' as Fill, 'Transparent' as Color, 0.1 as Thickness FROM map_neatlines UNION ALL
SELECT shores, name as [Display], 'ponds' as layer, 'LightBlue' as Fill, 'Blue' as Color, 0.1 as Thickness FROM ponds UNION ALL
SELECT boundary, name as [Display], 'forests' as layer, 'Green' as Fill, '#ff005500' as Color, 0.4 as Thickness FROM Forests UNION ALL
SELECT shore, name as [Display], 'lakes' as layer, 'Blue' as Fill, 'Transparent' as Color, 0.2 as Thickness FROM lakes UNION ALL
SELECT boundary, name as [Display], 'named_places' as layer, '#00ffff99' as Fill, 'Brown' as Color, 0.2 as Thickness FROM named_places UNION ALL
SELECT centerline, name as [Display], 'streams_outline' as layer, 'Blue' as Fill, 'Blue' as Color, 0.5 as Thickness FROM streams UNION ALL
SELECT centerline, name as [Display], 'streams_fill' as layer, 'LightBlue' as Fill, 'LightBlue' as Color, 0.3 as Thickness FROM streams UNION ALL
SELECT centerline, name as [Display], 'road_segments' as layer, 'LightGreen' as Fill, 'Black' as Color, num_lanes*0.2 as Thickness FROM road_segments UNION ALL
SELECT centerlines, name as [Display], 'divided_routes' as layer, 'LightGreen' as Fill, '#aaff0000' as Color, num_lanes*0.2 as Thickness FROM divided_routes UNION ALL
SELECT footprint, address as [Display], 'buildings_footprint' as layer, 'Black' as Fill, 'Transparent' as Color, 0.1 as Thickness FROM buildings UNION ALL
SELECT position.STBuffer(0.5), address as [Display], 'buildings_position' as layer, 'Red' as Fill, 'Transparent' as Color, 0.1 as Thickness FROM buildings UNION ALL
SELECT position.STBuffer(1), name as [Display], 'bridges' as layer, '#550000ff' as Fill, 'Black' as Color, 0.1 as Thickness FROM bridges