PageRenderTime 34ms CodeModel.GetById 11ms RepoModel.GetById 0ms app.codeStats 0ms

/database/layers_prod_updates/016_beards_080811.sql

http://alageospatialportal.googlecode.com/
SQL | 78 lines | 74 code | 3 blank | 1 comment | 0 complexity | 6171a4ffcd24d557eb2ae5b5c408b313 MD5 | raw file
  1. \set ON_ERROR_STOP 1
  2. begin;
  3. -- beards
  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. 931,
  42. 'beards',
  43. 'beards',
  44. 'Contextual',
  45. NULL,
  46. '/data/ala/data/shapefiles/ozcoasts',
  47. NULL,
  48. -35.1,
  49. 112.9,
  50. -13.7,
  51. 129,
  52. NULL,
  53. true,
  54. 'beards',
  55. 'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:beards&format=image/png&styles=',
  56. NULL,
  57. NULL,
  58. NULL,
  59. NULL,
  60. NULL,
  61. 'http://www.fixme.com',
  62. 'Area Management',
  63. 'Biodiversity',
  64. '931',
  65. '2011-08',
  66. '2011',
  67. 'eng',
  68. NULL,
  69. NULL,
  70. 2,
  71. NULL,
  72. NULL,
  73. 'http://www.fixme.com'
  74. );
  75. commit;