/database/layers_prod_updates/013_geohab_02082011.sql
SQL | 78 lines | 74 code | 3 blank | 1 comment | 0 complexity | d8232211a4044a4c634338aa898eea5e MD5 | raw file
1\set ON_ERROR_STOP 1 2begin; 3 4-- geohab 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 ( 42925, 43'geohab', 44'geohab', 45'Contextual', 46'', 47'/data/ala/data/shapefiles/ozcoasts', 48NULL, 49-54.778, 5072.577, 51-9.178, 52167.998, 53E'', 54true, 55'geohab', 56'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:geohab&format=image/png&styles=', 57'', 58'', 59'', 60'', 61'', 62'http://www.fixme.com', 63'Marine', 64'Borders', 65'925', 66'2011-08', 67'2011', 68'eng', 69NULL, 70NULL, 712, 72'', 73'', 74'http://www.fixme.com' 75); 76 77commit; 78