11.521 Lab #4 - In-Class (Feb. 27, 2018)
-------------

SCREEN SHARE: via WebEx: go to http://mit.webex.com/join/jf
  
(0) Avoid working with network-stored datasets
	-- Reset scratch workspace (via Geoprocessing / Environments... )
	-- Copy shapefiles to C:\TEMP before opening them
	-- Start in C:\temp\eboston05 using eboston05_lab2start.mxd from Lab #2 
	   and then add extra shapefiles into a new Data Frame 
	   
(1) Review objectives and datasets for Lab #4
    -- Map the location of parcels requesting zoning variances
	-- (Demo) Pull tables from Postgres (or Access) into ArcGIS
	-- (Demo) Convert XY coordinates in a table to a pin map
	-- (Demo) Spatial joins of zoning variance points with polygon layers (1990 census tracts, msa5_tr90.shp)
	   << requires a saved shapefile of lonlat5 points before this operation will work!)
	-- Be aware that all layers are in Mass State Plane NAD83 meters EXCEPT boston parcels (Parcels05)
	-- parcels05 is in Mass State Plane NAD83 feet.
	-- Google Earth mashups with KML output from ArcGIS
    -- Use mass_water.shp to shade water bodies blue (or one of the MassGIS or ESRI geoservices)
	-- Use K:\data\bosparcels05.shp for all Boston parcels

(2) ArcGIS to Postgres drivers. ArcGIS v. 10.5+ has correct drivers for Postgres via Add/Database-connection
(older versions had some problems connecting to postgres from 64-bit windows machines)

(3) Preparing ZONING data for mapping 
    -- getting X,Y (latitude/longitude) values from Postgres tables, using a csv table.
    -- In ArcGIS, use Tools/Add-XY-data to convert lat/lon to points
    ---- or, right click on the table and choose 'Display X/Y data'
	
(4) Multiple ways to do today's lab - join/query tables in Postgres, MS-Access, 
    or ArcGIS (depending on size, famililarity, complexity)
	
(5) Google Earth mashup - coordinate system issues and KMZ files

Tricky 'Gotchas' with today's lab:
 
 (a)  Problems displaying XY map of zoning variances after converting lon/lat to X/Y points.  
 - If you import a table into an empty data frame and then 'add XP data' the point file may not display.  
 - If you first add a shapefile (with the desired coordinate system) into the data frame and then add the 
 XY points, the points will display properly.  
 - Likewise, if the points do not display, you can add a shapefile will known coordinate system and 
 both will display.
 - ditto for trying to create a KMZ file from the layer in ArcMap.  
 Save as a shapefile, bring back in, set symbology and then save using 'layer to kml'.


Remember:  
 - Problem Set A is due one week from Thursday (March 8)
 - Problem Set B is due Thursday, March 15 and we have finished the discussion of using lookup tables 
 to accumulate and repurpose read-only 'official' data.  So, we have covered all that you need for 
 both homeworks.  
 - Lab #4 in lab today and due next Tuesday, March 6 - using Boston Zoning Variance database (from 1980s) 

 - Extra lab, Friday, Mar 3: in room 9-554 from 12:15-2:15 There will not be any formal presentation, but 
Rounaq Jose will be prepared to illustrate queries and ArcGIS-Access-Postgres connectivity 
as well as answer questions about queries and tips and tricks with ArcGIS, Postgres and MS-Access