Visual Field Example 5 - ACT Cycle Crashes since 2012 Heat Map

The source data this example is based upon

• dataACT ACT Government CSV Dataset

Key aspects this example demonstrates

• Fetching a CSV dataset with a spatial latitude and longitude component
• Creation of a database view that manually assembles a WKT POINT geometry (this could also be done with the Misc:makeSimplePoint Custom Function)

  create view if not exists CRASHES_VW
  as
  select 'POINT ('||c.longitude||' '||c.latitude||')' the_geom,
         c.severity tooltip,
         c.*
  from CRASHES c;
  

• Creating a Heat Map Visualization of the dataset view

Additional Information

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

visualfield.org