Fun With Radios: Using PostGIS and PostgreSQL in Amateur Radio
Thursday, June 25 at 15:40–16:30
-
Grant Fritchey is a Data Platform MVP and AWS Community Builder with over 30 years’ experience in IT, including time spent in support and development. Grant works with multiple data platforms including PostgreSQL and SQL Server, as well as multiple cloud platforms. He has also developed in Python, C#, and Java. Grant writes books for Apress and Simple-Talk, including the new book 'Introduction to PostgreSQL for the Data Professional.' Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product advocate in January 2011.
Getting your amateur radio license opens up all sorts of fun. One interesting example is Active Packet Reporting System (APRS), basically sending your location information out over the airwaves. The data is gathered up and available on a web site, APRS.fi. However, you only get limited reporting from the data there. In order to have more fun with that data, I've built a Lambda Function on AWS to pull data into an Aurora PostgreSQL database that has the postGIS extension. With all that in place, I can then use my APRS data in much more interesting ways to display all sorts of exciting reports thanks to the functionality offered through postGIS. This session will be focused on showing you how all the processes are brought together in order to demonstrate just how much you can do with PostgreSQL and postGIS. Putting PostgreSQL to work doesn't have to be hard, especially on fun projects.
