PageRenderTime 10ms CodeModel.GetById 1ms app.highlight 5ms RepoModel.GetById 2ms app.codeStats 0ms

/database/layers_dev_updates/027_myrtle_rust_260911.sql

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