/database/layers_prod_updates/016_beards_080811.sql
SQL | 78 lines | 74 code | 3 blank | 1 comment | 0 complexity | 6171a4ffcd24d557eb2ae5b5c408b313 MD5 | raw file
- \set ON_ERROR_STOP 1
- begin;
- -- beards
- INSERT INTO layers
- (
- id,
- "name",
- description,
- "type",
- source,
- path,
- extents,
- minlatitude,
- minlongitude,
- maxlatitude,
- maxlongitude,
- notes,
- enabled,
- displayname,
- displaypath,
- scale,
- environmentalvaluemin,
- environmentalvaluemax,
- environmentalvalueunits,
- lookuptablepath,
- metadatapath,
- classification1,
- classification2,
- uid,
- mddatest,
- citation_date,
- datalang,
- mdhrlv,
- respparty_role,
- licence_level,
- licence_link,
- licence_notes,
- source_link
- )
- VALUES (
- 931,
- 'beards',
- 'beards',
- 'Contextual',
- NULL,
- '/data/ala/data/shapefiles/ozcoasts',
- NULL,
- -35.1,
- 112.9,
- -13.7,
- 129,
- NULL,
- true,
- 'beards',
- 'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:beards&format=image/png&styles=',
- NULL,
- NULL,
- NULL,
- NULL,
- NULL,
- 'http://www.fixme.com',
- 'Area Management',
- 'Biodiversity',
- '931',
- '2011-08',
- '2011',
- 'eng',
- NULL,
- NULL,
- 2,
- NULL,
- NULL,
- 'http://www.fixme.com'
- );
- commit;