Ah, this makes perfect sense - I figured that I needed to define the geometry type, just wasn't quite figuring out how. Nice and simple solution! Thanks so much, Mike
On Tue, Mar 28, 2017 at 1:40 AM, Bernhard Ströbl <bernhard.stro...@jena.de> wrote: > Hi, > you need to explicitly state the geometry type and SRS in you view > definition like this: > CREATE OR REPLACE VIEW test.testbuff as > SELECT gid, area_id, > st_buffer(testshape.geom, 100)::geometry(Polygon,your_srs_code) > as geom2 FROM test.testshape where testshape.area_id=100; > > could be Polygon or Multipolygon depending on the input, your_srs_code > should be the same as testshape's > > QGIS can analyze geometry columns and detect the type (and probably SRS), > however only relations with geometry fields defined in this way are listed > in geometry_columns. > > Bernhard > > > Am 27.03.2017 um 23:42 schrieb Michael Treglia: > >> Hi All, >> >> I'm running a PostGIS query to create a view, buffering a polygon - >> viewing the result in DB Manager, the associated icon, rather than being >> polygons, is a question mark, and in the info tab for the layer, I see >> the warning ' There is no entry in geometry_columns!' >> >> That said, the layer actually displays fine in QGIS, and in the list of >> fields, the appropriate column is labeled as Type 'geometry'. >> >> Thus, is this really a problem? And if so, any easy fixes? A sample >> query is below: >> >> CREATE OR REPLACE VIEW test.testbuff as >> SELECT gid, area_id, st_buffer(testshape.geom, 100) >> as geom2 FROM test.testshape where testshape.area_id=100; >> >> >> Thanks for any suggestions! >> Mike >> >> >> _______________________________________________ >> Qgis-user mailing list >> Qgis-user@lists.osgeo.org >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user >> >> > > > __________ Information from ESET Mail Security, version of virus signature > database 15160 (20170328) __________ > > The message was checked by ESET Mail Security. > http://www.eset.com > > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
