Background
Looking to leverage an existing GIS system for exploring organizational data.
Architecture
The following figure represents a high-level overview of the system's desired features:
The most basic usage would be as follows:
The user visits a web site.
The system presents a map (having regions, cities, and buildings).
The user drills-down on the map to a particular building.
The system provides a basic CRUD interface.
The user can view and modify information about personnel (e.g., their assigned teams), equipment (e.g., network appliances), applications, and the building itself (e.g., contact and phone numbers).
Ideally, all the components should be open-source (or otherwise free).
Problem
This must be a small project that needs a quick (but functional) prototype, mostly to confirm whether or not such a system would be useful in the long term.
Questions
What software components would you use to quickly develop a working prototype?
What open-source solutions already exist, if any?
Ideas
Here is what I am thinking:
PostGIS - Define the regions, cities, and sites
Google Maps - Display an interactive, clickable map
geoJSON - Protocol between PostGIS and Google Maps
Seam - CRUD interface
Custom Development
For example, this would entail:
Installation and configuration
Configure SSH for remote logins
Subversion (or git)
PostgreSQL
PostGIS
Java
Tomcat
Seam
JasperReports
Enter GIS information into PostGIS
Aggregate data sources into PostgreSQL database
Develop starting page for map interface
Develop clickable Google Maps interface
Develop summary reports
Develop CRUD interface using Seam for data maintenance
Surely something like this already exists?
Thank you!