02_getFeatureBySQL.html 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
  1. <!--********************************************************************
  2. * Copyright© 2000 - 2021 SuperMap Software Co.Ltd. All rights reserved.
  3. *********************************************************************-->
  4. <!DOCTYPE html>
  5. <html>
  6. <head>
  7. <meta charset="UTF-8">
  8. <title data-i18n="resources.title_getFeatureBySQL"></title>
  9. <script type="text/javascript" src="../js/include-web.js"></script>
  10. <script type="text/javascript" src="../../dist/ol/include-ol.js"></script>
  11. </head>
  12. <body style=" margin: 0;overflow: hidden;background: #fff;width: 100%;height:100%; position: absolute;top: 0;">
  13. <div id="map" style="width: 100%;height:100%"></div>
  14. <script type="text/javascript">
  15. var map, resultLayer,
  16. baseUrl = (window.isLocal ? window.server : "https://iserver.supermap.io")+"/iserver/services/map-world/rest/maps/World",
  17. url = (window.isLocal ? window.server : "https://iserver.supermap.io")+"/iserver/services/data-world/rest/data";
  18. map = new ol.Map({
  19. target: 'map',
  20. controls: ol.control.defaults({attributionOptions: {collapsed: false}})
  21. .extend([new ol.supermap.control.Logo()]),
  22. view: new ol.View({
  23. center: [100, 0],
  24. zoom: 3,
  25. projection: 'EPSG:4326',
  26. multiWorld: true
  27. })
  28. });
  29. var layer = new ol.layer.Tile({
  30. source: new ol.source.TileSuperMapRest({
  31. url: baseUrl,
  32. wrapX: true
  33. }),
  34. projection: 'EPSG:4326'
  35. })
  36. map.addLayer(layer);
  37. query();
  38. function query() {
  39. var sqlParam = new SuperMap.GetFeaturesBySQLParameters({
  40. queryParameter: {
  41. name: "Countries@World",
  42. attributeFilter: "SMID = 247"
  43. },
  44. datasetNames: ["World:Countries"]
  45. });
  46. new ol.supermap.FeatureService(url).getFeaturesBySQL(sqlParam, function (serviceResult) {
  47. var vectorSource = new ol.source.Vector({
  48. features: (new ol.format.GeoJSON()).readFeatures(serviceResult.result.features),
  49. wrapX: false
  50. });
  51. resultLayer = new ol.layer.Vector({
  52. source: vectorSource
  53. });
  54. map.addLayer(resultLayer);
  55. });
  56. }
  57. </script>
  58. </body>
  59. </html>