28 reputation
6
bio website
location
age
visits member for 2 years, 4 months
seen Jun 18 at 13:38

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
Apr
3
revised Boundless OpenGeo Applications: ERROR 404
added 326 characters in body
Apr
3
asked Boundless OpenGeo Applications: ERROR 404
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?
Feb
26
comment Unable to view GeoTiff in GeoServer layer preview
I left the Tile Caching default values when I've loaded the geotiff.
Feb
26
comment Unable to view GeoTiff in GeoServer layer preview
Well, there is this error "Error dispatching tile request to GeoServer" and several Warnings like "Unable to find property: 'format.wms.application..." and "Unable to find property: 'format.wfs.application...."
Feb
26
asked Unable to view GeoTiff in GeoServer layer preview