Welcome! This is where I will index all of the files and videos for the Spatial Econometrics Course. FILES are linked to the left (<----See Files).
I do not charge for anything here. Also, where possible, all of the files and programs we use here will be free. If we will use a program or data that is not free, I will explicitly point this out. Otherwise, assume it is free! Click on the underlined link (like Intro Video 0:) to watch each video.
Introduction and Overview:
Intro Video 0: About the project (Beginning information about my plans for the course and what I hope to cover))
Intro Video 1: An overview of Spatial Econometrics and Spatial Econometric Models (A broad overview of the major spatial econometric models, Lag, Error, Kelejian-Prucha, Durbin, Manski, SLX)
Basic GIS Tools: with MapWindow (Open Source, very similar to ArcGIS):
GIS One: Basic GIS Tricks. (I called this "Video 2" in the video itself!) How to open maps (.SHP files) by adding and manipulating layers, edit them to remove unwanted areas, and save the new edited shapefile as a new file.
GIS Two: Data and Data Maps. Adding External Data to an existing SHP file and making Chloropleth Maps. This is very tedious, and there are easier ways... but I teach you a couple of slow and dirty ways to get it done.
GIS Two-B: Better Ways of Getting Data In. I told you that there were some better ways of getting data in, so here are two of them. Sorting, and using the "Swift-D" plugin.
GIS Three: Map Labels and Layouts. Here we label the states, and work with print layouts to make a pretty map with proper legends, titles, etc.
GIS Four: Census Geographies. Here we learn about census tracts, block groups, blocks, counties, MSAs, ZCTAs, congressional districts voting districts, school districts, lakes, metropolitan and micropolitan areas... Download link for free maps is below.
GIS Five: Importing and Mapping Points. Here we import a large number of points (population weighted block group centroids) from a CSV file, and add them to our map.
Here we take our shapefile of the world's countries and create center points, and export this data to a CSV file, and bring them into Excel.
GIS Seven: Matching Data and Mapping County Rural-Urban Continuum Codes. Here we map all US Counties with their 2013 Rural Urban Continuum Codes, creating a new variable in our map to match on.
We create a mappable shape (e.g., hexagon, circle, ellipse), and then find the intersection of two shapefiles, first keeping the intersection, and then cut off the intersection. Lastly, we find the centroids.
Download Links for Files, Programs, and Data
Download the handout, US State/Territory Map and World Map from the Files Section on the left side (or click the links on the words)
Link to Download MapWindow (free GIS program)
Link to Download LibreOffice Portable (Free Office Suite)
Link To Download US Map Used (free SHP files of the US states)
Link to Download 2010 US County Map (free SHP of US 2010 Counties)
Link to Download World Map (free World SHP file)
Link To Download 7Zip (Free compression program to open ZIP, 7z, and other compressed archives. The first .exe link should work for Windows Users)
The Mathematics of Great Circle Distance Formulas
I give some details and visualizations about longitude, latitude, and how "Great Circle Distance" formulas work. However, here I show you some EASY mathematics for understanding how to calculate a great circle distance WITHOUT actually covering any of the particular formulas people commonly use. Instead, I show you the intuition behind how they will work. In the next videos I cover several common formulas that are used in practice.
Part 2: Real Great Circle Distance Formulas (coming soon)