PageRenderTime 17ms CodeModel.GetById 11ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 0ms

/database/layers_prod_updates/016_beards_080811.sql

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