Reputation
Top tag
Next privilege 50 Rep.
Comment everywhere
Badges
1 8
Impact
~5k people reached

  • 0 posts edited
  • 0 helpful flags
  • 3 votes cast
Mar
23
comment How to control layer visibility in the Map Composer Overview map?
Yes! Done.Thanks a lot
Mar
21
asked How to control layer visibility in the Map Composer Overview map?
Mar
18
awarded  Notable Question
Oct
5
awarded  Popular Question
Feb
22
awarded  Popular Question
Jun
17
awarded  Commentator
Jun
17
comment PostgreSQL/PostGIS: create spatial view
Furthermore, it is strange, because I cannot load the view_waypAZ on QGIS Desktop but I'm able to load it as PostGIS layer on my GeoServer site...
Jun
17
comment PostgreSQL/PostGIS: create spatial view
No way: same error. This is the complete statement: 'CREATE OR REPLACE VIEW geodata.view_waypAZ AS SELECT polR.codeR, count(pntAZ.geom) as tot_pntAZ, ST_SetSRID(ST_Multi(ST_centroid(polR.geom)),4326) as geom FROM geodata.boundaryR as polR LEFT JOIN geodata.waypointsAzim as pntAZ ON st_contains(polR.geom,pntAZ.geom) GROUP BY polR.codeR, polR.geom; GRANT SELECT ON TABLE geodata.view_waypAZ TO geouser;'
Jun
17
comment PostgreSQL/PostGIS: create spatial view
Thank you @mtn.biker, now it works! But when I try to put together the CREATE VIEW with SELECT statement (point 1 in my first post) the resulting view is correct but I can't add it to QGIS because of an error: "the layer view_waypAZ cannot be added because is not valid". Why?
Jun
17
awarded  Scholar
Jun
17
awarded  Supporter
Jun
17
accepted PostgreSQL/PostGIS: create spatial view
Jun
16
comment PostgreSQL/PostGIS: create spatial view
PostgreSQL 9.3 and PostGIS 2.1
Jun
16
asked PostgreSQL/PostGIS: create spatial view
Apr
10
awarded  Tumbleweed
Feb
27
revised Unable to view GeoTiff in GeoServer layer preview
added 38 characters in body
Feb
27
comment Unable to view GeoTiff in GeoServer layer preview
Thanks @iant. I've just added some more details to my initial question.
Feb
27
awarded  Editor
Feb
27
revised Unable to view GeoTiff in GeoServer layer preview
added log file output and more details
Feb
27
comment Unable to view GeoTiff in GeoServer layer preview
Please, any help about this issue?