/database/layers_prod_updates/016_beards_080811.sql
SQL | 78 lines | 74 code | 3 blank | 1 comment | 0 complexity | 6171a4ffcd24d557eb2ae5b5c408b313 MD5 | raw file
1\set ON_ERROR_STOP 1 2begin; 3 4-- beards 5INSERT INTO layers 6( 7 id, 8 "name", 9 description, 10 "type", 11 source, 12 path, 13 extents, 14 minlatitude, 15 minlongitude, 16 maxlatitude, 17 maxlongitude, 18 notes, 19 enabled, 20 displayname, 21 displaypath, 22 scale, 23 environmentalvaluemin, 24 environmentalvaluemax, 25 environmentalvalueunits, 26 lookuptablepath, 27 metadatapath, 28 classification1, 29 classification2, 30 uid, 31 mddatest, 32 citation_date, 33 datalang, 34 mdhrlv, 35 respparty_role, 36 licence_level, 37 licence_link, 38 licence_notes, 39 source_link 40) 41VALUES ( 42931, 43'beards', 44'beards', 45'Contextual', 46NULL, 47'/data/ala/data/shapefiles/ozcoasts', 48NULL, 49-35.1, 50112.9, 51-13.7, 52129, 53NULL, 54true, 55'beards', 56'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:beards&format=image/png&styles=', 57NULL, 58NULL, 59NULL, 60NULL, 61NULL, 62'http://www.fixme.com', 63'Area Management', 64'Biodiversity', 65'931', 66'2011-08', 67'2011', 68'eng', 69NULL, 70NULL, 712, 72NULL, 73NULL, 74'http://www.fixme.com' 75); 76 77commit; 78