Site Contents

• Register

• About FOSS4G
• Important Dates
• Sponsors
• Contacts

• Program Overview
• Plenaries
• Presentations
• Labs
• Workshops
• Exhibition
• Events

• Travel Information
• Accommodations
• Special Activities

• About Victoria
• Dining & Shopping
• Nanaimo & Vancouver Island
• The Gulf Islands

Home > Presentations

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 http://www.macnoise.com/opreports/