QGIS – How to Display Related Records Using PostGIS

postgispostgresqlqgis

Coming from an esri background I have always used relationship classes in a gdb to display records related to a feature. Eg. Relate 1 survey point to many documents, photos etc.

Does any one know how to do something similar in QGIS?

Ando

P.S I'm using PostGreSQL 8.4.1 and PostGIS 1.4 and my clients are QGIS.

Best Answer

-There is a plugin named "eVis Event Browser" it will display images or any document based on external applications.

-You can create relational layers (generated from SQL queries) with the plugin "RT SQL Layer".

eVis

Related Solutions

[GIS] Free map service for private web applications

I'm not sure why you are excluding services like Google Maps, especially since your expected traffic not that high (Google starts charging after 25,000 map views (your map views will be much lower than 10,000): https://developers.google.com/maps/faq#usage_pricing). What you basically need is two things:

Someone to provide you with the Web slippy map. This can be Google Maps, Bing, MapQuest, Cloudmade etc. Or you could run your own tile server and use OpenStreetMap data.
Rendering your own vector data on the client side (using javascript) on top of the Web map. There are several open source libraries that can do that (OpenLayers, Leaflet, Polymaps...).

Some pointers to investigate further:

[GIS] Postgresql table won’t display in QGIS 2.2

I noticed the same behavior. Upon further investigation, it was only tables with 4d dimensions (In my case MultiPolygonZM) that wouldn't display in QGIS 2.2. I didn't test 3dm or 3dz as I don't have any data handy. You can check the coord_dimension column of your geometry_columns view.

If the Z/M coordinates are not important, you can ditch them like this:

ALTER TABLE schema.table ALTER COLUMN geom TYPE geometry(MULTIPOLYGON,4326) USING ST_Force2d(geom);

Or create a view of the table with 2d coordinates for display purposes using ST_Force2d.

If you have many tables to fix, I wrote a quick python loop to take care of the problem: https://gist.github.com/guitar1999/9442467

Best Answer

Related Solutions

[GIS] Free map service for private web applications

[GIS] Postgresql table won’t display in QGIS 2.2

Related Question