Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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:

  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).

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:

  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
add comment

1 Answer 1

up vote 4 down vote accepted

One of our clients uses the OpenGeo suite. There is a community edition if you don't need support.

share|improve this answer
    
Looks like a good suite for strictly GIS. I could not find any extensions documented on the OpenGeo site for CRUD on non-GIS data, which is a major point to the proposed architecture. Thank you! –  Dave Jarvis Apr 26 '12 at 7:18
    
Could you define the nature of the non-GIS data for us? –  dwurf Apr 26 '12 at 7:36
    
The nature of the non-GIS data is in the question: "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)." –  Dave Jarvis Apr 26 '12 at 19:34
    
Ah, so it is. I don't know of any boxed apps that will help you with this part, I think your SEAM/JasperReports plan is as good as any. GeoServer/GeoExt will run just fine in Tomcat so no obstacles there. –  dwurf Apr 26 '12 at 23:10
add comment

Your Answer

 
discard

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.