Timeline for Accessing PostGIS raster data using Query Layer in ArcGIS Desktop?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 9, 2012 at 23:38 | comment | added | dustymugs | Run "SELECT postgis_full_version()" and in the output there will be the GEOS version info. | |
| Aug 2, 2012 at 21:27 | comment | added | GISTECH | I have installed postgis 2.0.1. Still the problem persists. How to check if geos 3.3.5 is installed or not? Thanks. | |
| Jul 27, 2012 at 22:53 | comment | added | dustymugs | How big (width x height) is your original raster? It should be noted that when you tile your raster into PostGIS, you should keep the tile size anywhere between between 30 - 100 pixels for width and height. What the exact values for width and height should be based what is cleanly divisible (without remainder) from your raster's width and height. You're getting a ring intersection? ST_DumpAsPolygons automatically rectifies invalid polygons unless your version of GEOS is less than 3.3.0. It is strongly encouraged to have the latest GEOS, 3.3.5 I think. | |
| Jul 27, 2012 at 17:40 | comment | added | GISTECH | Hi, I ran your code and I was able to successfully create a view. However, it took time. I ran a explain analyze query to see the data. It is taking a long time and displaying a list of "Ring self-intersection at or near point xxxx.xx xxxx.xx" I want to let you know that when I loaded a raster file I used 300x300 tiling. Does this has anything to do this? what does "Ring self-intersection at or near point xxxx.xx xxxx.xx" mean? How to fix it? Any help. Thanks. | |
| Jul 26, 2012 at 16:13 | comment | added | GISTECH | thank you dustmugs. I was successfully able to create a view. However, when I tried to add a view to the arcmap and validate the data, it freezes the window. What could be an issue | |
| Jul 25, 2012 at 21:28 | history | answered | dustymugs | CC BY-SA 3.0 |