PageRenderTime 17ms CodeModel.GetById 13ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/database/layers_prod_updates/003_ne_world_25052011.sql

http://alageospatialportal.googlecode.com/
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;