/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. begin;
  3. -- geohab
  4. INSERT INTO layers
  5. (
  6. id,
  7. "name",
  8. description,
  9. "type",
  10. source,
  11. path,
  12. extents,
  13. minlatitude,
  14. minlongitude,
  15. maxlatitude,
  16. maxlongitude,
  17. notes,
  18. enabled,
  19. displayname,
  20. displaypath,
  21. scale,
  22. environmentalvaluemin,
  23. environmentalvaluemax,
  24. environmentalvalueunits,
  25. lookuptablepath,
  26. metadatapath,
  27. classification1,
  28. classification2,
  29. uid,
  30. mddatest,
  31. citation_date,
  32. datalang,
  33. mdhrlv,
  34. respparty_role,
  35. licence_level,
  36. licence_link,
  37. licence_notes,
  38. source_link
  39. )
  40. VALUES (
  41. 925,
  42. 'geohab',
  43. 'geohab',
  44. 'Contextual',
  45. '',
  46. '/data/ala/data/shapefiles/ozcoasts',
  47. NULL,
  48. -54.778,
  49. 72.577,
  50. -9.178,
  51. 167.998,
  52. E'',
  53. true,
  54. 'geohab',
  55. 'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:geohab&format=image/png&styles=',
  56. '',
  57. '',
  58. '',
  59. '',
  60. '',
  61. 'http://www.fixme.com',
  62. 'Marine',
  63. 'Borders',
  64. '925',
  65. '2011-08',
  66. '2011',
  67. 'eng',
  68. NULL,
  69. NULL,
  70. 2,
  71. '',
  72. '',
  73. 'http://www.fixme.com'
  74. );
  75. commit;