forked from CartoDB/CartoDB-basemaps
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathlayers.yml
98 lines (77 loc) · 3.26 KB
/
layers.yml
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
global_variables:
sql: |
SELECT null::geometry AS the_geom_webmercator LIMIT 0
false_background:
sql: |
SELECT the_geom_webmercator
FROM false_background_zoomed('!scale_denominator!', !bbox!) AS _
land_positive:
sql: |
SELECT
cartodb_id,
the_geom_webmercator
FROM land_positive_zoomed('!scale_denominator!', !bbox!) AS _
urban_areas:
sql: |
SELECT
cartodb_id,
scalerank,
the_geom_webmercator
FROM urban_areas_zoomed('!scale_denominator!',!bbox!) AS _
green_areas:
sql: |
SELECT the_geom_webmercator, area FROM green_areas_zoomed('!scale_denominator!',!bbox!) AS _
admin0boundaries:
sql: |
SELECT the_geom_webmercator, unit FROM admin0boundaries_zoomed('!scale_denominator!', !bbox!) AS _
admin1boundaries:
sql: |
SELECT scalerank, the_geom_webmercator FROM admin1boundaries_zoomed('!scale_denominator!', !bbox!) AS _
water:
sql: |
(SELECT id::bigint, the_geom_webmercator, name, type, is_lake, ne_scalerank, area FROM water_zoomed('!scale_denominator!', !bbox!) AS _)
UNION ALL
(SELECT cartodb_id::bigint, the_geom_webmercator, '' AS name, 'ocean' AS type, 1 AS is_lake, 0 AS ne_scalerank, 999999999 AS area FROM land_negative_zoomed('!scale_denominator!', !bbox!) AS _)
aeroways:
sql: |
SELECT type, the_geom_webmercator FROM aeroways_zoomed('!scale_denominator!', !bbox!) AS _
ne10mroads:
sql: |
SELECT cartodb_id, the_geom_webmercator, type, scalerank FROM ne_10m_roads_zoomed('!scale_denominator!', !bbox!) AS _
# osm_id is used to call out a few special buildings
buildings:
sql: |
SELECT osm_id, the_geom_webmercator, area FROM buildings_zoomed('!scale_denominator!',!bbox!) AS _
osmtunnels:
sql: |
select highway, railway, kind, the_geom_webmercator, is_link from tunnels('!scale_denominator!',!bbox!) as _
osmroads:
sql: |
select highway, railway, kind, the_geom_webmercator, is_link from high_road('!scale_denominator!',!bbox!) as _
osmbridges:
sql: |
select highway, railway, kind, the_geom_webmercator, is_link from bridges('!scale_denominator!',!bbox!) as _
country_city_labels:
sql: |
SELECT cartodb_id, name, the_geom_webmercator, scalerank, place, pop_est, country_city, is_capital FROM country_city_labels_zoomed('!scale_denominator!',!bbox!) AS _
park_labels:
sql: |
SELECT name, area, the_geom_webmercator FROM green_areas_zoomed('!scale_denominator!',!bbox!) AS _
water_labels:
sql: |
SELECT id, the_geom_webmercator, name, area, is_lake FROM water_zoomed('!scale_denominator!',!bbox!) AS _
osm_roads_labels:
sql: |
SELECT name, highway, railway, kind, the_geom_webmercator FROM high_road_labels('!scale_denominator!',!bbox!) as _
marine_labels:
sql: |
SELECT cartodb_id, name, namealt, featurecla, the_geom_webmercator, scalerank FROM ne_marine_zoomed('!scale_denominator!',!bbox!) AS _
admin1boundary_labels:
sql: |
SELECT cartodb_id, name, scalerank, the_geom_webmercator, geomtype from admin1boundaries_zoomed('!scale_denominator!',!bbox!) as _
admin1_labels:
sql: |
SELECT cartodb_id, name, scalerank, the_geom_webmercator FROM admin1_polygons_zoomed('!scale_denominator!',!bbox!) AS _
continent_labels:
sql: |
SELECT cartodb_id, name, the_geom_webmercator FROM continents_zoomed('!scale_denominator!',!bbox!) AS _