/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
- \set ON_ERROR_STOP 1
- begin;
- -- geohab
- 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 (
- 925,
- 'geohab',
- 'geohab',
- 'Contextual',
- '',
- '/data/ala/data/shapefiles/ozcoasts',
- NULL,
- -54.778,
- 72.577,
- -9.178,
- 167.998,
- E'',
- true,
- 'geohab',
- 'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:geohab&format=image/png&styles=',
- '',
- '',
- '',
- '',
- '',
- 'http://www.fixme.com',
- 'Marine',
- 'Borders',
- '925',
- '2011-08',
- '2011',
- 'eng',
- NULL,
- NULL,
- 2,
- '',
- '',
- 'http://www.fixme.com'
- );
- commit;