PageRenderTime 41ms CodeModel.GetById 1ms app.highlight 34ms RepoModel.GetById 1ms app.codeStats 0ms

/database/layers_dev_updates/006_layer_metadata_update_29042011.sql

http://alageospatialportal.googlecode.com/
SQL | 84 lines | 57 code | 12 blank | 15 comment | 0 complexity | 08b7f5c40545848cc6d5fd23cd7a7fc5 MD5 | raw file
 1\set ON_ERROR_STOP 1
 2begin transaction;
 3
 4update layers set
 5--name =                    'ramsar'
 6description =             'RAMSAR wetland regions'
 7,source =                  'ERIN'
 8,notes =                   E'Australia\'s Ramsar Wetlands - Downloadable (Subset Only).\n\nThe Ramsar Wetlands data contained within this dataset is from QLD, NSW, WA and Commonwealth agencies only. Ramsar Wetland boundaries for all other jurisdictions are to be sourced by contacting the relevant State/Territory agency.'
 9,displayname =             'RAMSAR wetland regions'
10,environmentalvalueunits = 'class'
11,metadatapath =            'http://www.environment.gov.au/metadataexplorer/full_metadata.jsp?docId={D06B412B-A1F5-42F8-BE39-1E4C17312FBD}'
12,mddatest =                '2011-01-18'
13,citation_date =           '2010-11-26'
14,datalang =                'eng'
15,mdhrlv =                  ''
16,respparty_role =          'distributor'
17,licence_level =           2
18,licence_link =            ''
19,licence_notes =           E'Copyright Commonwealth of Australia, Department of Sustainability, Environment, Water, Population and Communities with data compiled through cooperative efforts of the States/Territories Government wetland agencies. October 2010. All rights reserved\n\nParticipating Agencies:\n - ACT Department of Territory and Municipal Services\n - NSW Department of Environment, Climate Change and Water\n - NT Department of Natural Resources, Environment, The Arts and Sport\n - Qld Department of Environment and Resource Management\n - SA Department for Environment and Natural Resources\n - Tas Department of Primary Industries, Parks, Water and Environment\n - Vic Department of Sustainability and Environment\n - WA Department of Environment and Conservation'
20,source_link =             'http://www.environment.gov.au/metadataexplorer/full_metadata.jsp?docId={D06B412B-A1F5-42F8-BE39-1E4C17312FBD}'
21
22where id =                      915;
23
24
25update layers set
26--name =                    'nrm_regions_2010'
27description =             'National Resource Management (NRM) Regions'
28,source =                  'ERIN'
29,notes =                   E'The Natural Resource Management (NRM) Regions dataset has been prepared for the purpose of reporting on the Australian Government\'s Caring for our Country investments. The dataset is designed to cover all Australian territory where Caring for our Country projects might take place and includes major islands; external territories; state and coastal waters; in addition to the 56 NRM regions. This version of the data is an update and formalisation of the \'interim 2010\' dataset (which was an interim update of the NRM Regions 2009 dataset- publicly released in Feb 09).\n\nWhilst the boundaries of NRM Regions are defined by legislation in some states and territories this dataset should not be used to represent legal boundaries in any way. It is an administrative dataset developed for the purpose of reporting and public information. It should be noted that from time to time the states and/or territories may revise their regional boundaries in accordance with local needs and therefore alterations to either the attribution or boundaries of the data may occur in the future.\n\nCaring for our Country commenced on 1 July 2008. It integrates delivery of the Australian Government\'s previous natural resource management programs, including the Natural Heritage Trust, the National Landcare Program, the Environmental Stewardship Program and the Working on Country Indigenous land and sea ranger program.'
30,displayname =             'NRM Regions'
31,displaypath =             'http://spatial-dev.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:nrm_regions_2010&format=image/png&styles='
32,environmentalvalueunits = 'class'
33,metadatapath =            'http://www.environment.gov.au/metadataexplorer/full_metadata.jsp?docId={FA68F769-550B-4605-A0D5-50B10ECD0EB9}'
34,mddatest =                '2011-01-27'
35,citation_date =           '2010-11-11'
36,datalang =                'eng'
37,mdhrlv =                  ''
38,respparty_role =          'custodian'
39,licence_level =           2
40,licence_link =            ''
41,licence_notes =           E'Access constraints: This data will be made available for download from the Department\'s website subject to Commonwealth of Australia Copyright and a licence agreement.\nLimitations of use: This is an administrative dataset developed for the purpose of reporting and public information. The dataset is not a legal boundary dataset and does not represent legal boundaries in any way.'
42,source_link =             'http://www.environment.gov.au/metadataexplorer/full_metadata.jsp?docId={FA68F769-550B-4605-A0D5-50B10ECD0EB9}'
43
44where id =                      916;
45
46update layers set
47--name =                    'australian_coral_ecoregions'
48description =             'Australian Coral Ecoregions'
49,source =                  ''
50,path =                    '/data/ala/shapefiles/coral_ecoregions'
51,notes =                   E'Australian Coral Ecoregions:\n - Arnhem Land\n - Central & North GBR\n - Keppel Islands & Capricorn Bunker Reefs, Souther GBR\n - Darwin\n - Rowley Shoals\n - Ningaloo Reef & NW Western Australia\n - SW West Australia\n - Recherche Archipelago\n - Houtman Abrolhos Islands\n - Direction Bank\n - Ashmore Reef\n - Scott Reef\n - Christmas Island\n - Cocos Keeling\n - Arafura Sea Gulf of Carpenteria\n - Shark Bay\n - Kimberley Coast\n - Elizabeth & Middleton Reefs\n - Lord Howe Island\n - Solitary Islands\n - Moreton Bay\n - Pompey & Swain Reefs, South-east GBR\n - Torres Strait & far Northern GBR\n - South-east Australia\n - Coral Sea'
52--,enabled =                 true
53,displayname =             'Australian Coral Ecoregions'
54,displaypath =             'http://spatial-dev.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:australian_coral_ecoregions&format=image/png&styles='
55,environmentalvalueunits = 'class'
56,metadatapath =            ''
57,mddatest =                '2011'
58,citation_date =           '2011-01-20'
59,datalang =                'eng'
60,mdhrlv =                  ''
61,respparty_role =          'distributor'
62,licence_level =           2
63,licence_link =            'http://creativecommons.org.au/learn-more/licences'
64,licence_notes =           E'Attribution: J. Veron Coral Reef Research\nLicence: Creative Commons Attribution-Non-Commercial 3.0 Australia'
65,source_link =             ''
66
67where id =                      917;
68
69--SELECT id, "name", description, "type", source, path, extents, minlatitude, 
70--       minlongitude, maxlatitude, maxlongitude, notes, enabled, displayname, 
71--       displaypath, scale, environmentalvaluemin, environmentalvaluemax, 
72--       environmentalvalueunits, lookuptablepath, metadatapath, classification1, 
73--       classification2, uid, mddatest, citation_date, datalang, mdhrlv, 
74--       respparty_role, licence_level, licence_link, licence_notes, source_link
75--  FROM layers
76
77--where id in (917,916,915)
78----name like 'ger_%'
79----description like '%land%' or displayname like 'Mining%'
80
81--order by classification2 asc, displayname asc, classification1 asc;
82
83commit transaction;
84