/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 

    

  1. \set ON_ERROR_STOP 1
    2. 

  2. begin;
    3. 

  3. 

  4. -- geohab
    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. 925,
    43. 

  43. 'geohab', 
    44. 

  44. 'geohab', 
    45. 

  45. 'Contextual', 
    46. 

  46. '', 
    47. 

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

  48. NULL, 
    49. 

  49. -54.778, 
    50. 

  50. 72.577, 
    51. 

  51. -9.178, 
    52. 

  52. 167.998, 
    53. 

  53. E'', 
    54. 

  54. true,
    55. 

  55. 'geohab', 
    56. 

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

  57. '', 
    58. 

  58. '', 
    59. 

  59. '', 
    60. 

  60. '', 
    61. 

  61. '', 
    62. 

  62. 'http://www.fixme.com', 
    63. 

  63. 'Marine',
    64. 

  64. 'Borders', 
    65. 

  65. '925', 
    66. 

  66. '2011-08', 
    67. 

  67. '2011', 
    68. 

  68. 'eng', 
    69. 

  69. NULL, 
    70. 

  70. NULL,
    71. 

  71. 2,
    72. 

  72. '',
    73. 

  73. '',
    74. 

  74. 'http://www.fixme.com'
    75. 

  75. );
    76. 

  76. 

  77. commit;
    78.