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
|
<html>
<head>
<script src="https://unpkg.com/deck.gl@^8.5.0/dist.min.js"></script>
<script src="https://unpkg.com/@deck.gl/carto@^8.5.0/dist.min.js"></script>
<script src="https://libs.cartocdn.com/mapbox-gl/v1.13.0/mapbox-gl.js"></script>
<link href="https://libs.cartocdn.com/mapbox-gl/v1.13.0/mapbox-gl.css" rel="stylesheet" />
</head>
<body style="margin: 0; padding: 0">
<div id="map" style="width: 100vw; height: 100vh"></div>
</body>
<script type="text/javascript">
deck.carto.setDefaultCredentials({
username: "public",
apiKey: "8l-WraD-0s4A5FJj9W7uIg",
});
const POLYGON_COLORS = [
[128, 0, 32],
[190, 1, 31],
[255, 77, 32],
[255, 142, 54],
[255, 179, 66],
[254, 239, 157],
[253, 255, 208],
];
// Create Deck.GL map
const deckgl = new deck.DeckGL({
container: 'map',
mapStyle: deck.carto.BASEMAP.DARK_MATTER,
initialViewState: {
latitude: 40.7368521,
longitude: -73.9936065,
zoom: 11,
pitch: 60
},
controller: true,
layers: [
new deck.carto.CartoLayer({
id: 'mrli',
type: deck.carto.MAP_TYPES.QUERY,
data: `SELECT geoid, the_geom_webmercator, avg(txn_amt) as index
FROM public.mrli_ny_jan WHERE industry ='ret'
group by geoid, the_geom_webmercator`,
getFillColor: deck.carto.colorBins({
attr: 'index',
domain: [0, 50, 150, 300, 600, 1000],
colors: POLYGON_COLORS
}),
getLineColor: [0, 0, 0, 0],
lineWidthMinPixels: 0,
filled: true,
extruded: true,
wireframe: true,
getElevation: (f) => {
return f.properties.index ? f.properties.index : 0
}
}),
]
});
</script>
</html>
|
