Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top


Looking to leverage an existing GIS system for exploring organizational data.


The following figure represents a high-level overview of the system's desired features:

The most basic usage would be as follows:

  1. The user visits a web site.
  2. The system presents a map (having regions, cities, and buildings).
  3. The user drills-down on the map to a particular building.
  4. The system provides a basic CRUD interface.
  5. 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).


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.


  • What software components would you use to quickly develop a working prototype?
  • What open-source solutions already exist, if any?


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:

  1. Installation and configuration
    1. Configure SSH for remote logins
    2. Subversion (or git)
    3. PostgreSQL
    4. PostGIS
    5. Java
    6. Tomcat
    7. Seam
    8. JasperReports
  2. Enter GIS information into PostGIS
  3. Aggregate data sources into PostgreSQL database
  4. Develop starting page for map interface
  5. Develop clickable Google Maps interface
  6. Develop summary reports
  7. Develop CRUD interface using Seam for data maintenance

Surely something like this already exists?

Thank you!

share|improve this question
did you check ? – mhoran_psprep Apr 25 '12 at 22:42
No; SO people suggested PSE; GSE is a good idea. – Dave Jarvis Apr 25 '12 at 22:52

Interesting, Im developing a similar system for oil & gas, with Google Maps API v3. We chose to use CouchDB for the part of your diagram that includes GIS data, central repository, and other data sources. The idea behind this is one container to hold disparate sources of data with different types of structure, and also actual data files that represent GIS layers, logs, tickets, etc.

Also the capability of being able to host actual applications directly from the DB server is helpful for processing/uploading data.

Ultimately for our system which was faced with the prospect of bringing together old + messy + unorganized data, This NoSQL + Schema-less setup has made working with different types of data a pleasure.

share|improve this answer
up vote 0 down vote accepted

We went with the following:

  1. PostgreSQL + PostGIS
  2. Java 7 + Embedded Jetty + google-gson
  3. jQuery + OpenLayers + Select2
  4. OpenStreetMap + Mod Tile

We removed the reporting and data maintenance requirements.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.