What's flying tonight in Lincolnshire?

[charlieglnp]

https://labs.glnp.org.uk/flyingtonight/

This is a relatively simple SQLPage based app I've developed which shows you what moths you can expect to see flying in Lincolnshire tonight (or any night). Looks a bit bland at the moment as we're still sourcing photos for them all!

Clicking on a moth takes you to a chart which shows the relative abundance over the course of a year. Its all based off a simple table of moth and month recorded with all calculations done live. I could have achieved the same result by recalculating for every date, and precalculating for the charts (the queries would be more efficient) but it was partly an experiment in using SQLPage for these types of calculations as well as making it trivial to update the data in the future by just inserting additional rows into the single table.

[lovasoa]

Super cool, thanks for sharing !