/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
- \set ON_ERROR_STOP 1
- begin;
- -- aspa_asma_aat
- 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 (
- 933,
- 'aspas_asmas_aat',
- 'aspas_asmas_aat',
- 'Contextual',
- NULL,
- '/data/ala/data/shapefiles/aspas_asmas_aat_jun11',
- NULL,
- -35.1,
- 112.9,
- -13.7,
- 129,
- NULL,
- true,
- 'AAT Protected and Managed Areas',
- '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=',
- NULL,
- NULL,
- NULL,
- NULL,
- NULL,
- 'http://www.fixme.com',
- 'Area Management',
- 'Biodiversity',
- '933',
- '2011-08',
- '2011',
- 'eng',
- NULL,
- NULL,
- 2,
- NULL,
- NULL,
- 'http://www.fixme.com'
- );
- commit;