Loading...

QGIS - Dynamic Queries With PostGIS

18,721 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Apr 10, 2013

A short demonstration of why it is such a good idea to use PostGIS as your QGIS datastore. I show how views can be used to create dynamic layers that are updated as the layers around them are changed.

Here are the various SQL statements pictured above:

create view vw_poi_buffer as select gid, st_buffer(the_geom, 0.0008) as geom, name from poi;
create view vw_poi_roads as select distinct r.gid, r.the_geom, r.name from jalan r, vw_poi_buffer b where st_intersects(r.the_geom, b.geom);

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...