master

Branches (81)

Tags (32)

Manage

Manage

master

v11.3.x

v12.1.0

v12.0.1

dependabot/npm_and_yarn/src/common/fast-xml-parser-5.7.0

snyk-fix-54d9e7714a681c45b3ad4dacb6c8592a

dependabot/npm_and_yarn/turf/turf-7.3.3

snyk-fix-abdb4bdebc8b86ad9f7bfae6309e58ad

snyk-fix-4712f7a861c430e813f85333e4bfed82

snyk-upgrade-e88282fa32778b721e99887d92f3a0a7

snyk-upgrade-9a49cfee0586b226f385660495928af1

snyk-upgrade-976578446f1da59fc1ae66384683a906

snyk-upgrade-9b8759143442723b128989c089b4f3c3

dependabot/npm_and_yarn/mapbox-gl-3.18.1

dependabot/npm_and_yarn/elastic/elasticsearch-9.2.1

dependabot/npm_and_yarn/nightwatch-3.15.0

dependabot/npm_and_yarn/chromedriver-145.0.0

snyk-fix-34e860bf6537d6ef593f3733a0a21b4c

v12.0.0

v11.1.1

12.1.0-r

12.0.1-r

12.0.0-r

11.3.0

11.1.2

11.2.1

11.2.0

11.1.1

11.1.0

11.1.0-beta

11.0.1

11.0.0

11.0.0-beta

10.2.1

10.2.0

10.1.3

10.1.2

10.1.1

10.1.0

10.1.0-beta

iClient-JavaScript
/
examples
/
leaflet
/
01_mapQueryBySQL.html

<!--********************************************************************
* Copyright© 2000 - 2026 SuperMap Software Co.Ltd. All rights reserved.
*********************************************************************-->
<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title data-i18n="resources.title_mapQueryBySQL"></title>
    <style>
      #toolbar {
        position: absolute;
        top: 50px;
        right: 10px;
        width: 240px;
        text-align: center;
        z-index: 1000;
        border-radius: 4px;
      }
    </style>
</head>
<body style=" margin: 0;overflow: hidden;background: #fff;width: 100%;height:100%;position: absolute;top: 0;">
<div id="toolbar" class="panel panel-primary">
  <div class='panel-heading'>
      <h5 class='panel-title text-center' data-i18n="resources.title_queryBySQL"></h5></div>
  <div class='panel-body content'>
      <div class='panel'>
        <div class='input-group'>
          <span class='input-group-addon'>SQL</span>
          <input min="0" class="form-control" id="sql" placeholder="SMID < 10" />
        </div>
      </div>
      <input type="button" class="btn btn-default" data-i18n="[value]resources.text_query" onclick="query()"/>&nbsp;
      <input type="button" class="btn btn-default" data-i18n="[value]resources.text_input_value_clear" onclick="clearFeatures()"/>
  </div>
</div>
<div id="map" style="margin:0 auto;width: 100%;height: 100%"></div>
<script type="text/javascript" include="bootstrap" src="../js/include-web.js"></script>
<script type="text/javascript" src="../../dist/leaflet/include-leaflet.js"></script>
<script type="text/javascript">
    var host = window.isLocal ? window.server : "https://iserver.supermap.io";
    var map, resultLayer,
        url = host + "/iserver/services/map-world/rest/maps/World";
    map = L.map('map', {
        preferCanvas: true,
        crs: L.CRS.EPSG4326,
        center: {lon: -120, lat: 0},
        maxZoom: 18,
        zoom: 2
    });
    new L.supermap.TiledMapLayer(url).addTo(map);

    function query() {
        clearFeatures();
        var sql = document.getElementById("sql").value || "SMID < 10";
        var param = new L.supermap.QueryBySQLParameters({
            queryParams: {
                name: "Capitals@World.1",
                attributeFilter: sql
            }
        });
        new L.supermap
            .QueryService(url)
            .queryBySQL(param).then((serviceResult) => {
              var result = serviceResult.result;
              resultLayer = L.geoJSON(result.recordsets[0].features).addTo(map);
            });
    }

    function clearFeatures() {
      resultLayer && map.removeLayer(resultLayer);
    }
</script>
</body>
</html>