Visual Field Example 3 - SF Schools in Seismic Hazard Zones

The source data this example is based upon

• Data SF Schools CSV Dataset
• Data SF San Francisco Seismic Hazard Zones CSV Dataset
• Note DataSF has changed the format of the Schools dataset since this example was first made.

Key aspects this example demonstrates

• Fetching 2 CSV datasets each with a spatial (WKT) component (schools point layer and seismic zones polygon layer)
• Creation of a database table that creates a relational cross join (Cartesian Product) of these datasets
• Applying a Custom Function (Turf booleanPointInPolygon) spatial test against the joined datasets (table)
• Creation of a database view that references the output of the custom function and filters the original schools dataset
• Creation of a Map Visualization of the resultant filtered view

Additional Information

• View this example stand alone
• View the metadata used in this example

visualfield.org