Automating reports using PHP, PostgreSQL / PostGIS, FPDF, JPGraph and MapServer

Presentation | Presented

  • David Bitner, Metropolitan Airports Commission

This presentation will discuss how 48 pages of monthly reports detailing aviation noise around MSP International Airport have been automated using PHP, PostgreSQL/PostGIS, FPDF, and MapServer.

The following will be discussed:

* Techniques for using MapServer and PHP MapScript to generate print resolution graphics
* Use of JPGraph along with MapServer to represent three dimensional data from PostGIS
* Optimization of report generation time

Reports generated using this approach can be found at