/database/layers_prod_updates/003_ne_world_25052011.sql

http://alageospatialportal.googlecode.com/ · SQL · 74 lines · 74 code · 0 blank · 0 comment · 0 complexity · 435c08b8b2d642444be705c8124fdc64 MD5 · raw file

  1. \set ON_ERROR_STOP 1
  2. begin;
  3. INSERT INTO layers
  4. (
  5. id,
  6. "name",
  7. description,
  8. "type",
  9. source,
  10. path,
  11. extents,
  12. minlatitude,
  13. minlongitude,
  14. maxlatitude,
  15. maxlongitude,
  16. notes,
  17. enabled,
  18. displayname,
  19. displaypath,
  20. scale,
  21. environmentalvaluemin,
  22. environmentalvaluemax,
  23. environmentalvalueunits,
  24. lookuptablepath,
  25. metadatapath,
  26. classification1,
  27. classification2,
  28. uid,
  29. mddatest,
  30. citation_date,
  31. datalang,
  32. mdhrlv,
  33. respparty_role,
  34. licence_level,
  35. licence_link,
  36. licence_notes,
  37. source_link
  38. )
  39. VALUES (
  40. 922,
  41. 'ne_world',
  42. 'Natural Earth World Boundaries',
  43. 'Contextual',
  44. 'Natural Earth',
  45. '/data/ala/data/shapefiles/10m-admin-0-countries',
  46. NULL,
  47. -90,
  48. -180,
  49. 90,
  50. 180,
  51. 'Country boundary data provided by natural earth',
  52. true,
  53. 'Country Boundaries',
  54. 'http://spatial.ala.org.au/geoserver/gwc/service/wms?service=WMS&version=1.1.0&request=GetMap&layers=ALA:ne_world&format=image/png&styles=',
  55. NULL,
  56. '',
  57. '',
  58. '',
  59. '',
  60. 'http://www.naturalearthdata.com/downloads/10m-cultural-vectors/10m-admin-0-countries/',
  61. 'Political',
  62. '',
  63. '922',
  64. '2010-05',
  65. '2010',
  66. 'eng',
  67. NULL,
  68. NULL,
  69. 2,
  70. 'http://creativecommons.org/publicdomain/',
  71. 'Made with Natural Earth. Free vector and raster map data @ naturalearthdata.com.',
  72. 'http://www.naturalearthdata.com'
  73. );
  74. commit;