spatiAlert Toolkit

Free tools for finding hotspots of under-vaccination in school-level data. Two browser tools handle the hardest part, cleaning and preparing the data, and a Shiny app finds the hotspots.

Work through them in order, or use whichever one you need.

1PrepareHTML · runs in browser

RecordMatcher

Matches records between two files that don't necessarily share a clean ID, for example matching school vaccination data to one or more school address or school enrollment files using school name. It proposes a match for every record, lets you review as many or as few as you choose, and merges the data.

  • Fuzzy matching on one or more columns
  • Every export row keeps its score and how it was decided
  • Built-in clean-up step before export
2PrepareHTML · runs in browser

PlaceFinder

Turns addresses into latitude and longitude. Build the address from your columns, look it up, fix the ones that fail, and export coordinates with the source of each one recorded.

  • Uses the US Census geocoder
  • Flags addresses that need fixing
  • Each row records where its coordinates came from
3AnalyzeR Shiny · download to run

spatiAlert

Calculates Getis-Ord Gi* hotspots using point or area-aggregated data.

  • Census tract and county data for all 50 states are pre-loaded, or upload your own shapefiles (such as school districts)
  • Explore first: map schools, counts of undervaccinated students, and vaccination rates
  • Export the exploration maps and a final report with tables and explanations
  • Runs locally in R on your computer

See the Getting Started Guide for more information.

Working with sensitive data? Download the tool and run it on your own computer rather than opening it here. The two HTML tools are built to work inside your browser without uploading your files, but running a downloaded copy offline gives you full control of where your data goes.

See the tools in action

Tutorials and sample data

Want to try the tools before using your own data?

Video tutorials Coming soon

Short walkthroughs for each tool.

  • RecordMatcher: video coming soon
  • PlaceFinder: video coming soon
  • spatiAlert: video coming soon

Sample data Coming soon

Practice files so you can follow along start to finish.

  • RecordMatcher: sample files coming soon
  • PlaceFinder: sample file coming soon
  • spatiAlert: sample dataset coming soon

Questions or problems?

Something not working, or not sure how to use a tool? Contact: Emily Serman (eserman@clemson.edu)

Email Emily

Before you open this online

Please don't use sensitive or identifiable data here. This copy is served from a public website. If your data is sensitive, download the tool and run it locally on your own computer instead.