Geographical Data

Repository containing information on using geographical data.

See wiki for walk-throughs (listed below).

---

Functions

BigQuery User Defined Functions (UDFs) for geo processes.

• Generate Coordinate Linestring
• Calculate Bearing

---

Census Data

Walks through U.S. Census Bureau Data.

• Hierarchy of Census Geographical Entities
• Geographic Identifiers
• Census Entity Relationships
• ZCTAs vs. ZIP Codes
• American Community Survey (ACS)
• Calculating Interpolated Medians
• Google Public Data: Census
• Calling Census API
• Urbanization Index
• Geocoding Addresses

---

Hurricane Data

Walks through how to create a table that will enable you to analyze customer behavior pre/post major storm activity.

• Saffir–Simpson Hurricane Wind Scale
• Output Data
• Source Data
• Process

---