• Entities and Attributes
  

  Strength (Category – 1, 2, 3, 4, 5) is an aggregate categorical attribute that summarizes all windspeeds and maybe other stuff

• The Join: Relational and Spatial
  

  The “Join” is a concept from the world of Relational Databases, SQL and set theory, but the term is used generally to talk about combining data from one or more entities based on the relationship between those entities. In the land of Relational Databases a Join is the intersection between two sets (tables/entities).

• SQL - Structured Query Language
  

  Widely used even outside the world of strictly “relational” databases. Created to operate on Relational Databases to retrieve and manipulate data.
  
  SQL is often used for data analytic purposes  - to aggregate values, sort, group, etc.

SELECT watch_warning.extent, watch_warning.type
FROM hurricane, advisory, watch_warning
WHERE hurricane.name = “Ian”
AND hurricane.h_id = advisory.h_id
AND advisory.ad_id = watch_warning.ad_id

SELECT watch_warning.type, COUNT(*)
FROM hurricane, advisory, watch_warning
WHERE hurricane.name = “Ian”
AND hurricane.h_id = advisory.h_id
AND advisory.ad_id = watch_warning.ad_id
GROUP BY watch_warning.type

Analogous to a relational Join, but uses spatial attributes to accomplish the Join. GIS facilitates this kind of Join.

SELECT watch_warning.type, COUNT(*)
FROM hurricane, advisory, watch_warning
WHERE hurricane.name = “Ian”
AND hurricane.h_id = advisory.h_id
AND advisory.ad_id = watch_warning.ad_id
AND st_within(city.postion, watch_warning.extent)
GROUP BY watch_warning.type

• Story Maps
  • ESRI Storymaps - New York Taxicab Terrain
  • Knightlabs - Game of Thrones
• Mashups
  • MapBox - LA Times California Fires
  • Leaflet - Cordillera Huayhuash
• Web Applications
  • ESRI - Hometown Maps
  • Leaflet - MAP

• Mapbox Gallery
• Open Street Map Gallery

• Create an ESRI Storymap
• Create a Leaflet Map