Seth Fitzsimmons mojodna

Mid Latitude masking

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';

Keybase proof

I hereby claim:

I am mojodna on github.
I am mojodna (https://keybase.io/mojodna) on keybase.
I have a public key ASCgwZt094z3yaJ1BaDoKDDj5KIHQGTyrCt4UIIBNzhsfgo

To claim this, I am signing this object:

	# 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

	<!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; }

	--
	-- 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,