/database/layers_prod_updates/003_ne_world_25052011.sql
SQL | 74 lines | 74 code | 0 blank | 0 comment | 0 complexity | 435c08b8b2d642444be705c8124fdc64 MD5 | raw file
1\set ON_ERROR_STOP 1 2begin; 3INSERT INTO layers 4( 5 id, 6 "name", 7 description, 8 "type", 9 source, 10 path, 11 extents, 12 minlatitude, 13 minlongitude, 14 maxlatitude, 15 maxlongitude, 16 notes, 17 enabled, 18 displayname, 19 displaypath, 20 scale, 21 environmentalvaluemin, 22 environmentalvaluemax, 23 environmentalvalueunits, 24 lookuptablepath, 25 metadatapath, 26 classification1, 27 classification2, 28 uid, 29 mddatest, 30 citation_date, 31 datalang, 32 mdhrlv, 33 respparty_role, 34 licence_level, 35 licence_link, 36 licence_notes, 37 source_link 38) 39VALUES ( 40922, 41'ne_world', 42'Natural Earth World Boundaries', 43'Contextual', 44'Natural Earth', 45'/data/ala/data/shapefiles/10m-admin-0-countries', 46NULL, 47-90, 48-180, 4990, 50180, 51'Country boundary data provided by natural earth', 52true, 53'Country Boundaries', 54'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:ne_world&format=image/png&styles=', 55NULL, 56'', 57'', 58'', 59'', 60'http://www.naturalearthdata.com/downloads/10m-cultural-vectors/10m-admin-0-countries/', 61'Political', 62'', 63'922', 64'2010-05', 65'2010', 66'eng', 67NULL, 68NULL, 692, 70'http://creativecommons.org/publicdomain/', 71'Made with Natural Earth. Free vector and raster map data @ naturalearthdata.com.', 72'http://www.naturalearthdata.com' 73); 74commit;