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

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
16
comment PostgreSQL/PostGIS: create spatial view
PostgreSQL 9.3 and PostGIS 2.1
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
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...."
Nov
28
comment arcpy - Calculate field in a joined table
Ooops, too many bangs. The correct command is: arcpy.CalculateField_management(Table_A, Table_A + ".field_A", "!" + Table_B + ".field_B!","PYTHON")
Mar
9
comment ArcMap 10 Layout View: search for elements and delete
Thanks Petr. I've already solved adding graphC.Reset() after graphC.DeleteElement(elem).