Skip to content

Instantly share code, notes, and snippets.

@mojodna
Created October 26, 2018 21:41
Show Gist options
  • Save mojodna/8411d83df5d9767d9686f859315e41cc to your computer and use it in GitHub Desktop.
Save mojodna/8411d83df5d9767d9686f859315e41cc to your computer and use it in GitHub Desktop.
ESACCI-LC Mid Latitude mask
-- update the footprint to exclude the mask
update land_cover set geom=ST_Multi(ST_Difference(geom, mask)) where source='ESACCI-LC Mid Latitudes';
Display the source blob
Display the rendered blob
Raw
{"type":"MultiPolygon","coordinates":[[[[-180,-67.543299213666],[-145.696041214751,-63.0170824295011],[-112.897776572668,-57.8240238611714],[-89.3923535791757,-59.1906182212581],[-64.2470173535792,-60.2838937093276],[-47.3012472885032,-54.2708785249458],[-36.0951735357918,-50.1710954446855],[-5.21014099783079,-51.5376898047723],[34.9677331887202,-56.1841106290673],[57.3798806941432,-54.2708785249458],[68.3126355748373,-45.5246746203905],[94.5512472885032,-46.8912689804772],[134.182483731019,-54.5441973969631],[165.614154013015,-60.0105748373102],[180,-61.7467976288429],[180,-62.3076923076923],[180,-64.2857142857143],[180,-66.2637362637363],[180,-68.2417582417582],[180,-70.2197802197802],[180,-72.1978021978022],[180,-74.1758241758242],[180,-76.1538461538462],[180,-78.1318681318681],[180,-80.1098901098901],[180,-82.0879120879121],[180,-84.0659340659341],[180,-86.0439560439561],[180,-88.021978021978],[180,-90],[178.011049723757,-90],[176.022099447514,-90],[174.033149171271,-90],[172.044198895028,-90],[170.055248618785,-90],[168.066298342541,-90],[166.077348066298,-90],[164.088397790055,-90],[162.099447513812,-90],[160.110497237569,-90],[158.121546961326,-90],[156.132596685083,-90],[154.14364640884,-90],[152.154696132597,-90],[150.165745856354,-90],[148.176795580111,-90],[146.187845303867,-90],[144.198895027624,-90],[142.209944751381,-90],[140.220994475138,-90],[138.232044198895,-90],[136.243093922652,-90],[134.254143646409,-90],[132.265193370166,-90],[130.276243093923,-90],[128.28729281768,-90],[126.298342541436,-90],[124.309392265193,-90],[122.32044198895,-90],[120.331491712707,-90],[118.342541436464,-90],[116.353591160221,-90],[114.364640883978,-90],[112.375690607735,-90],[110.386740331492,-90],[108.397790055249,-90],[106.408839779006,-90],[104.419889502762,-90],[102.430939226519,-90],[100.441988950276,-90],[98.4530386740332,-90],[96.4640883977901,-90],[94.475138121547,-90],[92.4861878453039,-90],[90.4972375690608,-90],[88.5082872928177,-90],[86.5193370165746,-90],[84.5303867403315,-90],[82.5414364640884,-90],[80.5524861878453,-90],[78.5635359116022,-90],[76.5745856353591,-90],[74.585635359116,-90],[72.5966850828729,-90],[70.6077348066298,-90],[68.6187845303867,-90],[66.6298342541436,-90],[64.6408839779006,-90],[62.6519337016575,-90],[60.6629834254144,-90],[58.6740331491713,-90],[56.6850828729282,-90],[54.6961325966851,-90],[52.707182320442,-90],[50.7182320441989,-90],[48.7292817679558,-90],[46.7403314917127,-90],[44.7513812154696,-90],[42.7624309392265,-90],[40.7734806629834,-90],[38.7845303867403,-90],[36.7955801104972,-90],[34.8066298342542,-90],[32.817679558011,-90],[30.8287292817679,-90],[28.8397790055249,-90],[26.8508287292818,-90],[24.8618784530387,-90],[22.8729281767956,-90],[20.8839779005525,-90],[18.8950276243094,-90],[16.9060773480663,-90],[14.9171270718232,-90],[12.9281767955801,-90],[10.939226519337,-90],[8.95027624309392,-90],[6.96132596685084,-90],[4.97237569060775,-90],[2.98342541436463,-90],[0.994475138121544,-90],[-0.994475138121544,-90],[-2.98342541436463,-90],[-4.97237569060775,-90],[-6.96132596685084,-90],[-8.95027624309392,-90],[-10.939226519337,-90],[-12.9281767955801,-90],[-14.9171270718232,-90],[-16.9060773480663,-90],[-18.8950276243094,-90],[-20.8839779005525,-90],[-22.8729281767956,-90],[-24.8618784530387,-90],[-26.8508287292818,-90],[-28.8397790055249,-90],[-30.8287292817679,-90],[-32.817679558011,-90],[-34.8066298342542,-90],[-36.7955801104972,-90],[-38.7845303867403,-90],[-40.7734806629834,-90],[-42.7624309392265,-90],[-44.7513812154696,-90],[-46.7403314917127,-90],[-48.7292817679558,-90],[-50.7182320441989,-90],[-52.707182320442,-90],[-54.6961325966851,-90],[-56.6850828729282,-90],[-58.6740331491713,-90],[-60.6629834254144,-90],[-62.6519337016575,-90],[-64.6408839779006,-90],[-66.6298342541436,-90],[-68.6187845303867,-90],[-70.6077348066298,-90],[-72.5966850828729,-90],[-74.585635359116,-90],[-76.5745856353591,-90],[-78.5635359116022,-90],[-80.5524861878453,-90],[-82.5414364640884,-90],[-84.5303867403315,-90],[-86.5193370165746,-90],[-88.5082872928177,-90],[-90.4972375690608,-90],[-92.4861878453038,-90],[-94.4751381215469,-90],[-96.4640883977901,-90],[-98.4530386740332,-90],[-100.441988950276,-90],[-102.430939226519,-90],[-104.419889502762,-90],[-106.408839779006,-90],[-108.397790055249,-90],[-110.386740331492,-90],[-112.375690607735,-90],[-114.364640883978,-90],[-116.353591160221,-90],[-118.342541436464,-90],[-120.331491712707,-90],[-122.32044198895,-90],[-124.309392265193,-90],[-126.298342541436,-90],[-128.28729281768,-90],[-130.276243093923,-90],[-132.265193370166,-90],[-134.254143646409,-90],[-136.243093922652,-90],[-138.232044198895,-90],[-140.220994475138,-90],[-142.209944751381,-90],[-144.198895027624,-90],[-146.187845303867,-90],[-148.17679558011,-90],[-150.165745856354,-90],[-152.154696132597,-90],[-154.14364640884,-90],[-156.132596685083,-90],[-158.121546961326,-90],[-160.110497237569,-90],[-162.099447513812,-90],[-164.088397790055,-90],[-166.077348066298,-90],[-168.066298342541,-90],[-170.055248618785,-90],[-172.044198895028,-90],[-174.033149171271,-90],[-176.022099447514,-90],[-178.011049723757,-90],[-180,-90],[-180,-88.021978021978],[-180,-86.043956043956],[-180,-84.0659340659341],[-180,-82.0879120879121],[-180,-80.1098901098901],[-180,-78.1318681318681],[-180,-76.1538461538462],[-180,-74.1758241758242],[-180,-72.1978021978022],[-180,-70.2197802197802],[-180,-68.2417582417582],[-180,-67.543299213666]]],[[[180,45.4956862551764],[165.392082429501,47.0450108459869],[153.406722245239,48.502390197181],[154.901880084849,57.7540797119215],[140.771603007645,67.186857259529],[115.022479356043,68.9591895659376],[96.5370256720743,71.0629543250298],[69.1257258987264,71.1840009798396],[56.5600926612933,69.9498256940573],[42.2042017719395,69.7781822832942],[31.2402213288475,68.2200913695413],[24.4672909064708,70.0222033903046],[11.1470438738678,70.5683591849916],[2.36161563285389,67.7230864827644],[-6.95011525994386,65.3961176582604],[-19.0981561822126,55.2445770065075],[-39.9802318823587,52.9032202767701],[-54.6151567251492,54.4002111844938],[-60.6307412996322,53.3596081934995],[-65.813522307557,52.6681210825084],[-76.7684381778742,48.684924078091],[-87.9745119305857,49.5048806941431],[-99.7272234273319,55.5178958785249],[-111.561513059792,59.119538452911],[-129.083462816547,59.8860345450767],[-140.103485250666,57.3140807148669],[-165.050433839479,45.9517353579175],[-180,44.290672451193],[-180,44.5054945054945],[-180,46.4835164835165],[-180,48.4615384615385],[-180,50.4395604395604],[-180,52.4175824175824],[-180,54.3956043956044],[-180,56.3736263736264],[-180,58.3516483516484],[-180,60.3296703296703],[-180,62.3076923076923],[-180,64.2857142857143],[-180,66.2637362637363],[-180,68.2417582417582],[-180,70.2197802197802],[-180,72.1978021978022],[-180,74.1758241758242],[-180,76.1538461538462],[-180,78.1318681318681],[-180,79.4142749874853],[-180,80.1098901098901],[-180,82.0879120879121],[-180,84.0659340659341],[-180,86.0439560439561],[-180,88.021978021978],[-180,90],[-178.011049723757,90],[-176.022099447514,90],[-174.033149171271,90],[-172.044198895028,90],[-170.055248618785,90],[-168.066298342541,90],[-166.077348066298,90],[-164.088397790055,90],[-162.099447513812,90],[-160.110497237569,90],[-158.121546961326,90],[-156.132596685083,90],[-154.14364640884,90],[-152.154696132597,90],[-150.165745856354,90],[-148.176795580111,90],[-146.187845303867,90],[-144.198895027624,90],[-142.209944751381,90],[-140.220994475138,90],[-138.232044198895,90],[-136.243093922652,90],[-134.254143646409,90],[-132.265193370166,90],[-130.276243093923,90],[-128.28729281768,90],[-126.298342541436,90],[-124.309392265193,90],[-122.32044198895,90],[-120.331491712707,90],[-118.342541436464,90],[-116.353591160221,90],[-114.364640883978,90],[-112.375690607735,90],[-110.386740331492,90],[-108.397790055249,90],[-106.408839779006,90],[-104.419889502762,90],[-102.430939226519,90],[-100.441988950276,90],[-98.4530386740332,90],[-96.4640883977901,90],[-94.475138121547,90],[-92.4861878453039,90],[-90.4972375690608,90],[-88.5082872928177,90],[-86.5193370165746,90],[-84.5303867403315,90],[-82.5414364640884,90],[-80.5524861878453,90],[-78.5635359116022,90],[-76.5745856353591,90],[-74.585635359116,90],[-72.5966850828729,90],[-70.6077348066298,90],[-68.6187845303867,90],[-66.6298342541436,90],[-64.6408839779006,90],[-62.6519337016575,90],[-60.6629834254144,90],[-58.6740331491713,90],[-56.6850828729282,90],[-54.6961325966851,90],[-52.707182320442,90],[-50.7182320441989,90],[-48.7292817679558,90],[-46.7403314917127,90],[-44.7513812154696,90],[-42.7624309392265,90],[-40.7734806629834,90],[-38.7845303867403,90],[-36.7955801104972,90],[-34.8066298342542,90],[-32.817679558011,90],[-30.8287292817679,90],[-28.8397790055249,90],[-26.8508287292818,90],[-24.8618784530387,90],[-22.8729281767956,90],[-20.8839779005525,90],[-18.8950276243094,90],[-16.9060773480663,90],[-14.9171270718232,90],[-12.9281767955801,90],[-10.939226519337,90],[-8.95027624309392,90],[-6.96132596685084,90],[-4.97237569060775,90],[-2.98342541436463,90],[-0.994475138121544,90],[0.994475138121544,90],[2.98342541436463,90],[4.97237569060775,90],[6.96132596685084,90],[8.95027624309392,90],[10.939226519337,90],[12.9281767955801,90],[14.9171270718232,90],[16.9060773480663,90],[18.8950276243094,90],[20.8839779005525,90],[22.8729281767956,90],[24.8618784530387,90],[26.8508287292818,90],[28.8397790055249,90],[30.8287292817679,90],[32.817679558011,90],[34.8066298342542,90],[36.7955801104972,90],[38.7845303867403,90],[40.7734806629834,90],[42.7624309392265,90],[44.7513812154696,90],[46.7403314917127,90],[48.7292817679558,90],[50.7182320441989,90],[52.707182320442,90],[54.6961325966851,90],[56.6850828729282,90],[58.6740331491713,90],[60.6629834254144,90],[62.6519337016575,90],[64.6408839779006,90],[66.6298342541436,90],[68.6187845303867,90],[70.6077348066298,90],[72.5966850828729,90],[74.585635359116,90],[76.5745856353591,90],[78.5635359116022,90],[80.5524861878453,90],[82.5414364640884,90],[84.5303867403315,90],[86.5193370165746,90],[88.5082872928177,90],[90.4972375690608,90],[92.4861878453038,90],[94.4751381215469,90],[96.4640883977901,90],[98.4530386740332,90],[100.441988950276,90],[102.430939226519,90],[104.419889502762,90],[106.408839779006,90],[108.397790055249,90],[110.386740331492,90],[112.375690607735,90],[114.364640883978,90],[116.353591160221,90],[118.342541436464,90],[120.331491712707,90],[122.32044198895,90],[124.309392265193,90],[126.298342541436,90],[128.28729281768,90],[130.276243093923,90],[132.265193370166,90],[134.254143646409,90],[136.243093922652,90],[138.232044198895,90],[140.220994475138,90],[142.209944751381,90],[144.198895027624,90],[146.187845303867,90],[148.17679558011,90],[150.165745856354,90],[152.154696132597,90],[154.14364640884,90],[156.132596685083,90],[158.121546961326,90],[160.110497237569,90],[162.099447513812,90],[164.088397790055,90],[166.077348066298,90],[168.066298342541,90],[170.055248618785,90],[172.044198895028,90],[174.033149171271,90],[176.022099447514,90],[178.011049723757,90],[180,90],[180,88.021978021978],[180,86.043956043956],[180,84.0659340659341],[180,82.2188008405639],[180,82.0879120879121],[180,80.1098901098901],[180,78.1318681318681],[180,76.1538461538462],[180,74.1758241758242],[180,72.1978021978022],[180,70.2197802197802],[180,68.2417582417582],[180,66.2637362637363],[180,64.2857142857143],[180,62.3076923076923],[180,60.3296703296703],[180,58.3516483516484],[180,56.3736263736264],[180,54.3956043956044],[180,52.4175824175824],[180,50.4395604395604],[180,48.4615384615385],[180,46.4835164835165],[180,45.4956862551764]]],[[[145.205995,20.009551],[145.205995,20.029671],[145.205995,20.036579],[145.22516,20.036579],[145.239815,20.036579],[145.239815,20.016579],[145.239815,20.009551],[145.208628,20.009551],[145.205995,20.009551]]],[[[-168.153904,-14.550887],[-168.153904,-14.533211],[-168.14219,-14.533211],[-168.14219,-14.550887],[-168.153904,-14.550887]]],[[[-170.848824,-14.376172],[-170.848824,-14.22763],[-170.543476,-14.22763],[-170.543476,-14.376172],[-170.848824,-14.376172]]],[[[-169.689464,-14.195264],[-169.689464,-14.153473],[-169.604353,-14.153473],[-169.604353,-14.195264],[-169.689464,-14.195264]]],[[[-169.521039,-14.276821],[-169.521039,-14.20781],[-169.415909,-14.20781],[-169.415909,-14.276821],[-169.521039,-14.276821]]],[[[-171.092933,-11.066629],[-171.092933,-11.046558],[-171.063246,-11.046558],[-171.063246,-11.066629],[-171.092933,-11.066629]]],[[[144.615665,13.230814],[144.615665,13.656004],[144.961879,13.656004],[144.961879,13.230814],[144.615665,13.230814]]],[[[145.120791,14.109937],[145.120791,14.201041],[145.291617,14.201041],[145.291617,14.109937],[145.120791,14.109937]]],[[[145.536282,14.8395],[145.536282,14.867426],[145.579994,14.867426],[145.579994,14.8395],[145.536282,14.8395]]],[[[145.581675,14.921818],[145.581675,15.10165],[145.674359,15.10165],[145.674359,14.921818],[145.581675,14.921818]]],[[[145.688041,15.091068],[145.688041,15.290653],[145.831969,15.290653],[145.831969,15.091068],[145.688041,15.091068]]],[[[146.050453,16.004367],[146.050453,16.028688],[146.065741,16.028688],[146.065741,16.004367],[146.050453,16.004367]]],[[[145.631233,16.329986],[145.631233,16.372026],[145.725157,16.372026],[145.725157,16.329986],[145.631233,16.329986]]],[[[145.765272,16.690093],[145.765272,16.718874],[145.79115,16.718874],[145.79115,16.690093],[145.765272,16.690093]]],[[[145.830678,17.294844],[145.830678,17.323645],[145.854177,17.323645],[145.854177,17.294844],[145.830678,17.294844]]],[[[145.812498,17.577958],[145.812498,17.624131],[145.854182,17.624131],[145.854182,17.577958],[145.812498,17.577958]]],[[[-64.90548,17.673337],[-64.90548,17.790165],[-64.56268,17.790165],[-64.56268,17.673337],[-64.90548,17.673337]]],[[[145.706904,18.04359],[145.706904,18.170613],[145.811582,18.170613],[145.811582,18.04359],[145.706904,18.04359]]],[[[145.634386,18.723767],[145.634386,18.814906],[145.701641,18.814906],[145.701641,18.723767],[145.634386,18.723767]]],[[[-156.063761,18.908933],[-156.063761,20.270526],[-154.80467,20.270526],[-154.80467,18.908933],[-156.063761,18.908933]]],[[[145.385955,19.67435],[145.385955,19.708096],[145.417844,19.708096],[145.417844,19.67435],[145.385955,19.67435]]],[[[144.884851,20.535211],[144.884851,20.554643],[144.903952,20.554643],[144.903952,20.535211],[144.884851,20.535211]]],[[[-157.06774,20.726954],[-157.06774,20.933797],[-156.797618,20.933797],[-156.797618,20.726954],[-157.06774,20.726954]]],[[[-157.315497,21.038878],[-157.315497,21.228546],[-156.704062,21.228546],[-156.704062,21.038878],[-157.315497,21.038878]]],[[[-158.282495,21.252518],[-158.282495,21.712731],[-157.646929,21.712731],[-157.646929,21.252518],[-158.282495,21.252518]]],[[[-160.248065,21.776231],[-160.248065,22.029902],[-160.046137,22.029902],[-160.046137,21.776231],[-160.248065,21.776231]]],[[[-159.788179,21.865888],[-159.788179,22.236572],[-159.290738,22.236572],[-159.290738,21.865888],[-159.788179,21.865888]]],[[[-156.705598,20.497051],[-156.705598,20.608475],[-156.69906,20.608475],[-156.69906,21.032542],[-155.97402,21.032542],[-155.97402,20.574082],[-156.525409,20.574082],[-156.525409,20.497051],[-156.705598,20.497051]]],[[[-66.327399,17.911284],[-66.327399,17.921252],[-67.27663,17.921252],[-67.27663,18.521262],[-65.237688,18.521262],[-65.237688,17.921252],[-66.129542,17.921252],[-66.129542,17.911284],[-66.327399,17.911284]]],[[[-64.790964,18.374536],[-64.645757,18.374536],[-64.645757,18.295632],[-64.790964,18.295632],[-64.790964,18.273147],[-65.086138,18.273147],[-65.086138,18.416124],[-64.790964,18.416124],[-64.790964,18.374536]]]]}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment