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

/database/layers_prod_updates/013_geohab_02082011.sql

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