/database/layers_dev_updates/027_myrtle_rust_260911.sql

http://alageospatialportal.googlecode.com/ · SQL · 78 lines · 74 code · 3 blank · 1 comment · 0 complexity · 7bf3baa57368ca017ea278b7e40ede7e MD5 · raw file 

    

  1. \set ON_ERROR_STOP 1
    2. 

  2. begin;
    3. 

  3. 

  4. -- lith_geologicalunitpolygons1m
    5. 

  5. INSERT INTO layers
    6. 

  6. (
    7. 

  7.   id,
    8. 

  8.   "name",
    9. 

  9.   description,
    10. 

  10.   "type",
    11. 

  11.   source,
    12. 

  12.   path,
    13. 

  13.   extents,
    14. 

  14.   minlatitude,
    15. 

  15.   minlongitude,
    16. 

  16.   maxlatitude,
    17. 

  17.   maxlongitude,
    18. 

  18.   notes,
    19. 

  19.   enabled,
    20. 

  20.   displayname,
    21. 

  21.   displaypath,
    22. 

  22.   scale,
    23. 

  23.   environmentalvaluemin,
    24. 

  24.   environmentalvaluemax,
    25. 

  25.   environmentalvalueunits,
    26. 

  26.   lookuptablepath,
    27. 

  27.   metadatapath,
    28. 

  28.   classification1,
    29. 

  29.   classification2,
    30. 

  30.   uid,
    31. 

  31.   mddatest,
    32. 

  32.   citation_date,
    33. 

  33.   datalang,
    34. 

  34.   mdhrlv,
    35. 

  35.   respparty_role,
    36. 

  36.   licence_level,
    37. 

  37.   licence_link,
    38. 

  38.   licence_notes,
    39. 

  39.   source_link
    40. 

  40. )
    41. 

  41. VALUES (
    42. 

  42. 934,
    43. 

  43. 'myrtle_rust', 
    44. 

  44. 'Myrtle rust reports', 
    45. 

  45. 'Contextual', 
    46. 

  46. 'GA', 
    47. 

  47. '/data/ala/data/shapefiles/myrtle_rust', 
    48. 

  48. NULL, 
    49. 

  49. -35.3, 
    50. 

  50. 148.6, 
    51. 

  51. -28.2, 
    52. 

  52. 153.6, 
    53. 

  53. E'',
    54. 

  54. true,
    55. 

  55. 'Myrtle Rust Observations', 
    56. 

  56. 'http://spatial-dev.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:myrtle_rust&format=image/png&styles=',
    57. 

  57. '', 
    58. 

  58. '', 
    59. 

  59. '', 
    60. 

  60. '', 
    61. 

  61. '', 
    62. 

  62. 'fixme: metadata_path', 
    63. 

  63. 'Vegetation',
    64. 

  64. '', 
    65. 

  65. '934', 
    66. 

  66. '2011-09-26', 
    67. 

  67. '2011-09-26', 
    68. 

  68. 'eng', 
    69. 

  69. NULL, 
    70. 

  70. NULL, 
    71. 

  71. 2,
    72. 

  72. 'fixme: license_link',
    73. 

  73. 'fixme: license_notes',
    74. 

  74. 'fixme: source_url'
    75. 

  75. );
    76. 

  76. 

  77. commit;
    78.