/database/layers_dev_updates/027_myrtle_rust_260911.sql
SQL | 78 lines | 74 code | 3 blank | 1 comment | 0 complexity | 7bf3baa57368ca017ea278b7e40ede7e MD5 | raw file
1\set ON_ERROR_STOP 1 2begin; 3 4-- lith_geologicalunitpolygons1m 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 ( 42934, 43'myrtle_rust', 44'Myrtle rust reports', 45'Contextual', 46'GA', 47'/data/ala/data/shapefiles/myrtle_rust', 48NULL, 49-35.3, 50148.6, 51-28.2, 52153.6, 53E'', 54true, 55'Myrtle Rust Observations', 56'http://spatial-dev.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:myrtle_rust&format=image/png&styles=', 57'', 58'', 59'', 60'', 61'', 62'fixme: metadata_path', 63'Vegetation', 64'', 65'934', 66'2011-09-26', 67'2011-09-26', 68'eng', 69NULL, 70NULL, 712, 72'fixme: license_link', 73'fixme: license_notes', 74'fixme: source_url' 75); 76 77commit; 78