GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — iClient-JavaScript/examples/leaflet/01_mapQueryBySQL.html at master · SuperMap/iClient-JavaScript

Expand file tree

/

01_mapQueryBySQL.html

Copy path
More file actions
More file actions

Latest commit

 

History

History
History
74 lines (72 loc) · 2.65 KB
/

01_mapQueryBySQL.html

Copy path

File metadata and controls

74 lines (72 loc) · 2.65 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
<!--********************************************************************
* 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: "[email protected]",
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>
You are visitor 01402503 — GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.