PageRenderTime 30ms CodeModel.GetById 15ms app.highlight 10ms RepoModel.GetById 1ms app.codeStats 0ms

/database/layers_prod_updates/021_aspa_asma_aat_290811.sql

http://alageospatialportal.googlecode.com/
SQL | 78 lines | 74 code | 3 blank | 1 comment | 0 complexity | f8ebf377ceeee23a4d4c671af84fc010 MD5 | raw file
 1\set ON_ERROR_STOP 1
 2begin;
 3
 4-- aspa_asma_aat
 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 (
42933,
43'aspas_asmas_aat', 
44'aspas_asmas_aat', 
45'Contextual', 
46NULL, 
47'/data/ala/data/shapefiles/aspas_asmas_aat_jun11', 
48NULL, 
49-35.1, 
50112.9, 
51-13.7, 
52129, 
53NULL, 
54true,
55'AAT Protected and Managed Areas', 
56'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:aspas_asmas_aat&format=image/png&styles=', 
57NULL, 
58NULL, 
59NULL, 
60NULL, 
61NULL, 
62'http://www.fixme.com', 
63'Area Management',
64'Biodiversity', 
65'933', 
66'2011-08', 
67'2011', 
68'eng', 
69NULL, 
70NULL,
712,
72NULL,
73NULL,
74'http://www.fixme.com'
75);
76
77commit;
78