Part 2: Get the fusion table ready for ArcMap

  1. Now, get the fusion table ready for ArcMap.  First, query/filter out bad data.  Click on Options -> Filter, and add 3 filters:
    1. "Where Longitude > 0"
    2. "Where Latitude > 0"
    3. "Where date >= 1/1/2009" (just get 2009 data to give ArcMap some breathing room)
  2. Export as csv for use in ArcMap (File -> Download)

Part 3:  ArcMap

  1. Import the csv file
  2. Map the data by XY coordinates (make sure to set the coordinate system to WGS1984)
  3. Export (save) the data as a new shapefile (GIS data layer)
  4. Play with symbology (categorical mapping by the "cat" field)
  5. Add time dimension to your layer: Properties, Time tab, enable, and select Date (not the DateTime) field (ESRI)
  6. Explore the time slider (ESRI)
  7. Play your data over time (ESRI)
  8. Apply Spatial statistics (directional distribution) to your temporal data
  9. Toolbox -> Spatial Statistics -> Measuring Geographic Distributions -> Directional Distribution
  10. For the Case Field, make sure to select Date (not DateTime)
  11. Enable time to the new layer created, and play the temporal animation again
https://vimeo.com/36055250

This hands on workshop demonstrates how to use Google Fusion Tables and ArcGIS to create stunning…