PostGIS applications
I would like to learn how to build applications using postGIS. I'm wondering if there are any good open source examples I can take a look at? I am especially interested in those that not only use postgres to store map data, but also make extensive use of special postGIS functions in application code (SQL-MM aggregates and functions, i.e. ST_ *). Thank!
source to share
PostGIS is a great tool for storing and running all kinds of queries in your geodata. However, you need a different tool to display the maps. There are many.
If you are interested in web mapping: here is the question, I asked about web mapping . I ended up storing the mapping data in a PostGIS database and then serving it up with GeoServer and OpenLayers. Another solid web mapping route is GeoDjango .
Edit: More on my previous experience. I had a dataset of vector data (polygons) stored in shapefiles (.shp). I needed to display them on google maps and select them on the web platform. First, I imported the shapefiles into my PostGIS database.
After setting up GeoServer, I linked my PostGIS database to GeoServer and created a WFS layer. There are different types (like WMS), but I used WFS because it is good for selecting which polygons to display.
Then I had to display the layer that I added to the GeoServer. For this, I used the OpenLayers JavaScript library. They have many examples on their website. This one uses GeoServer to serve the map data. Just browse the source to see how Openlayers gets the map and displays it.
If you want to create offline maps: Quantum GIS is a good free tool. ArcGIS is also very popular, but not free.
If I were you I would take a look at https://gis.stackexchange.com/ . You will find a lot of things there and it's a very helpful community.
source to share