gis for applied economicsgis for applied economics visualization tools and vector transformation...

59
GIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 [email protected]

Upload: others

Post on 18-Jan-2021

5 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

GISFORAPPLIEDECONOMICS

VisualizationtoolsandVectorTransformation(II)

JuanCarlosMuñoz-MoraUniveristatPompeuFabra

Nov2016

[email protected]

Page 2: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

ROADMAP1. Commentsonthereplicationfromprevioussession2. AdditionalconceptsinVectorTransformation3. ConceptsinVectorTransformation(II)

BufferDistances

4. Bufferanddistancesinaction5. ReplicationDell()

Page 3: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

REPLICATIONPREVIOUSSESSION

Desktopsolution?ReplicationpyQGISReplicationStandalone

Page 4: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

DESKTOPSOLUTIONS(ANIDEA)1addnewvariableattribute2makeintersection3exportdatatoR(csv)4identifyrepeatedunion5joindatafrom

outside

Page 5: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

ADDITIONALCONCEPTSINVECTORTRANSFORMATION

Page 6: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

UNION

Page 7: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Inshapely(Standalonesolution)

InpyQGIS

a.union(b)

processing.runalg('qgis:union', input, input2, output)

Page 8: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

DIFFERENCE

Page 9: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Inshapely(Standalonesolution)

InpyQGIS

a.difference(b)

processing.runalg('qgis:difference', input, overlay, output)

Page 10: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

SYMMETRICDIFFERENCE

Page 11: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Inshapely(Standalonesolution)

InpyQGIS

a.symmetric_difference(b)

processing.runalg('qgis:symetricaldifference', input, overlay, output)

Page 12: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

SPATIALJOINOverlappingNearbyjoin

Page 13: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

DESKTOPSOLUTIONS(PLUGINS)mmqgisspatialjoin

ANYIDEA(INTUITION)HOWCANWEIMPLEMENTTHISINPYTHON/PYQGIS?

Page 14: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Inshapely(Standalonesolution)

InpyQGIS

## ---- For Polygons## Option 1 - object.contains(other)## Option 2 - at the borderobject.touches(other)## Option 3object.within(other)## --- For Linesobject.crosses(other)object.disjoint(other)

processing.runalg('qgis:joinattributesbylocation' , target, join, predicate, summary, stats, keep, output)

Page 15: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

CONCEPTSINVECTORTRANSFORMATION(II)

Page 16: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

BUFFERThisoperationcreatesapolygonaround

theobjectataspecifieddistance.

Page 17: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Neighborhood(averyrusticdefinition-why?)Identifyspilloversoftreatments

,Peereffect

Alternativewaystodefinetreatment

DISTANCES

Miguel&Kremer(2004) deMeletal.(2008)

Conley&Udry(2010)

Muehlenbachsetal.(2015)

Page 18: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Proximity(veryrude)Buildinstruments(Validity!)

Moreonlocationasainstrumentsee

Whatisthedifferentwithbuffferapproach?

Oster(2012)Nunn(2008)

Gibson&McKenzie2007

Page 20: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

U.S.commercialairports,2008greatarcsandsymbolmapshowVoronoi

Page 22: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 23: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

ThreemodelsoftheEarthtocalculatedistances:

FlatplaneSphericalEllipsoid

Page 24: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

FLATPLANE-EARTHASAFLATPLANEEuclideandistance(Pythagoreantheorem )

whatifweuseunprojectedcoordinates?units

+ =a2 b2 c2

Page 25: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

SPHERICAL-EARTHASAPERFECTSPHEREGreatcircledistance(Haversineformula-decimalsdegrees)

Page 26: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

ELLIPSOID-EARTHASANON-PERFECTSPHERE

Greatcircledistance(Vincentyformula-decimalsdegrees)

Page 27: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

But,whataboutifwewouldliketotakeintoaccountroads?

Wewilldiscussitonthelastsession!

Page 28: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

CONCEPTSINVECTORTRANSFORMATION(II)

INACTION

Page 29: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

DavidYanagizawa-Drott

QuarterlyJournalofEconomics,2014,129(4),pp.1947-199

PROPAGANDAANDCONFLICT:EVIDENCEFROMTHERWANDAN

GENOCIDE

Page 30: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Theroleofmassmediaintimesofconflictandstate-sponsoredmassviolenceagainstcivilians.

METHODRTLMtransmittersandradiopropagationsoftwareradiocoveragewithineachvillage.Casuallink receptiongeneratedbyRwanda'shighlyvaryingtopography

MAINFINDINGBroadcastsledtomoreviolenceduringthegenocide.

participation(10%oftotal-51,000persons)spillovereffectsinmilitiaviolence

↑↑

Page 31: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

Inadditiontoviolencebythemilitary,attacksandmassacresconductedbylocalmilitiasgroupsandordinary

civilianscontributedtoadeathtollof0.5–1.0milliondeaths(DesForges,1999;Straus,2004;Verwimp,2006).

Page 32: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 33: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 34: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 35: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 36: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 37: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

TimothyG.ConleyandChristopherR.Udry

AmericanEconomicReview2010,100:1,35–69

LEARNINGABOUTANEWTECHNOLOGY:PINEAPPLEINGHANA

Page 38: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

TheroleofsociallearninginthediffusionofanewagriculturaltechnologyinGhana. Dofarmerslearnfrom

theirpeers?

MAINFINDINGSFarmersadjusttheirinputstoalignwiththoseoftheir

informationneighborswhoweresurprisinglysuccessfulinpreviousperiods.

DATAGeo-locatedpanelhouseholdsurveys(every6weekin1996-

98)in3villagesofsouthernGhana

Page 39: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

NEIGHBORHOODMETRICResponseto"Haveyouevergoneto__foradviceabout

yourfarm?"

Page 40: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

EMPIRICALSPECIFICATION

Page 41: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

INDEXOFGOODNEWSINPUTLEVELS

Standarderrors:calculatedbyConley(1999)

Page 42: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu
Page 43: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

SPATIALREGRESSIONDISCONTINUITY

DESIGN(fewwords)

Page 44: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

WHATISDIFFERENT?Usingboundariesascutoff

lines(set)Indicator-Score-coordinatestwo-dimensions

Further

Keele&Titiunik2014

Page 46: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

NathanNunn

TheQuarterlyJournalofEconomics(2008)123(1):139-176.

(GISstrategyreplication)

THELONG-TERMEFFECTSOFAFRICA'SSLAVETRADES

Page 47: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

THEPAPERCanpartofAfrica'scurrentunderdevelopmentbeexplained

byitsslavetrades?

DATASlavesexportedfromeachcountry

fromeachportofAfricaEthnicityofasampleof100,00+slavesEthnichomelandinAfrica

Page 48: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

REDUCEDFORM

GDPpercapitaincountry in2000

#ofslavesexported1400-1900fromcountry

Landsurfaceareaofcountry

Controls

= α + β ln( ) + +yiexporti

areaiX ′

i εi

yi i

exportsi

i

areai i

X ′i

Page 49: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

DISTANCEASINSTRUMENT

Page 50: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

EXCLUSIONRESTRICTION-LOCATIONOFSLAVEPORTS

climatesuitabilityofplantationcrops/locationofminesnotaffectedbythedistancetoAfricaDistancetoslavemarkets Distancetoothereconomicopportunities

Page 51: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

FIRSTSTAGE

where,

Distancetonearestslavetradecenters

ln( ) = δ + Ω + +exportsi

areaiD′

i X ′i μi

=D′i

Page 52: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

RESULTS(FIRSTSTAGE)

Page 53: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

RESULTS(SECONDSTAGE)

Page 54: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

REPLICATIONPLANDistancetotheSlaveTradeCenterFromeachcountrytilltheAtlanticborder

Page 55: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

REPLICATEITSINSTRUMENTDistancetonearestslavetradecentersPLANARE

Page 56: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

TIPSFORPYQGISInpyQGIS

processing.runalg('qgis:union', input, input2, output)

Page 57: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

TIPSFORPYQGISGettingthecentroids

Featurebyfeature

processing.runalg('qgis:polygoncentroids', input_layer, output_layer)

for f in layer.getFeatures(): pt = f.geometry().centroid().asPoint()

Page 58: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

DistanceMatrixprocessing.runalg('qgis:distancematrix', input_layer, input_field, target_layer, target_field, matrix_type, nearest_points, distance_matrix)

Page 59: GIS FOR APPLIED ECONOMICSGIS FOR APPLIED ECONOMICS Visualization tools and Vector Transformation (II) Juan Carlos Muñoz-Mora Univeristat Pompeu Fabra Nov 2016 juancarlos.munoz@upf.edu

FORNEXTSESSIONInstallthefollowinglibraries

rasteriorasterstats