| # Refill provides a high contrast, black & white basemap useful for data visualization. | |
| # Give OpenStreetMap data a professional basemap skin using the Tangram graphics library | |
| # and Mapzen's versatile Vector Tiles. | |
| # | |
| # Refill is a modern GL take on Geraldine's work on Toner for Stamen as part of their | |
| # great CityTracking project. Please use and adapt the open source scene file in | |
| # your own projects! | |
| # | |
| # Authors: Geraldine Sarmiento, Nathaniel V. Kelso | |
| # Read more: https://github.com/tangrams/refill-style |
First, apply the mid latitude mask as mask.
Next, add envelopes for each of the C-CAP sources as masks (otherwise chunky pixels sneak in, per mojodna/marblecutter-land-cover#6):
update land_cover set mask = ST_Union(mask, (select ST_Union(ST_Envelope(geom)) from land_cover where source='C-CAP')) where source='ESACCI-LC Mid Latitudes';-- update the footprint to exclude the mask
update land_cover set geom=ST_Multi(ST_Difference(geom, mask)) where source='ESACCI-LC Mid Latitudes';
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset='utf-8' /> | |
| <title></title> | |
| <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' /> | |
| <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.45.0/mapbox-gl.js'></script> | |
| <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.45.0/mapbox-gl.css' rel='stylesheet' /> | |
| <style> | |
| body { margin:0; padding:0; } |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset='utf-8' /> | |
| <title></title> | |
| <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' /> | |
| <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.42.0/mapbox-gl.js'></script> | |
| <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.42.0/mapbox-gl.css' rel='stylesheet' /> | |
| <style> | |
| body { margin:0; padding:0; } |
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <meta charset='utf-8' /> | |
| <title></title> | |
| <meta name='viewport' content='initial-scale=1,maximum-scale=1,user-scalable=no' /> | |
| <script src='https://api.tiles.mapbox.com/mapbox-gl-js/v0.45.0/mapbox-gl.js'></script> | |
| <link href='https://api.tiles.mapbox.com/mapbox-gl-js/v0.45.0/mapbox-gl.css' rel='stylesheet' /> | |
| <style> | |
| body { margin:0; padding:0; } |
I hereby claim:
To claim this, I am signing this object:
| -- | |
| -- This will register the "planet" table within your AWS account | |
| -- | |
| CREATE EXTERNAL TABLE planet ( | |
| id BIGINT, | |
| type STRING, | |
| tags MAP<STRING,STRING>, | |
| lat DECIMAL(9,7), | |
| lon DECIMAL(10,7), | |
| nds ARRAY<STRUCT<ref: BIGINT>>, |
| with params as ( | |
| select | |
| 27.61649608612061 as minlon, | |
| 53.85379229563698 as minlat, | |
| 27.671985626220707 as maxlon, | |
| 53.886459293813054 as maxlat | |
| ), direct_nodes as ( | |
| select n.id, n.version, n.changeset, n.timestamp, n.lat, n.lon | |
| from | |
| planet n, |