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.

Are there asset management systems that use PostGIS for asset storage?

share|improve this question
1  
we can build one together –  dassouki Dec 15 '10 at 19:57

2 Answers 2

I think it's one of those situations where no individual is going to build a PostGIS Asset Management System without an actual project. Reason being, there are a lot of specs required that differ from jurisdiction to jurisdiction, data access, scope, and objectives; however, I've always been interested in building one. If we can find specs for an existing PMS system, we can perhaps setup a small project and build it.

share|improve this answer
1  
I think you might be right on that. A core PGAMS should be able to handle much of a potential system's specs with configuration (lots of configuration for even the big&popular systems). –  Jay Cummins Dec 20 '10 at 11:45

I found several links that might be useful for you.

NYSAWWA

And DBlack's question on gis.stackexchange

Which is not as relevant as it could be. But without more info from azteca it looks to me as though they simply use the data via sde. If your data is in postgis/sde (pg_geometry) then at least the gis data side of cityworks should be supported (contact azteca for verification).

I don't see anything on their website about the supported rdbms's (for the asset_db side) but they do state "A key element of Cityworks' design is its flexibility ". I am relatively certain they do support the major rdbms player, mssql, oracle, sybase, informix.

With the google search "cityworks database postgres" I found an interesting link for an individual that would be a good contact for you. You might take a look. I did not feel I should post here.

share|improve this answer
    
I think my setup for my question (and my original comment) maybe misleading. It's more of an academic question. I've removed the junk and left the question! –  Jay Cummins Dec 15 '10 at 18:09

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.