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