This post Accessing PostGIS raster data using Query Layer in ArcGIS Desktop? was created in Jul-12. Since then, I have not found any other related-post published.
Using QGIS with DBManager ON, my postGIS raster tables can be displayed nicely so far. That's cool and it proved that my raster tables are OK and not corrupted. However, I need to use ArcMap 10.1 and read those rasters, without having to create views or multy-polygons in the database as the above post suggested.
I have tried two ways:
- Setting a Database connection in ArcCatalog directly to the Postgress/PostGIS database. I can display vector features, but only see the attribute table of the raster, so not displaying the raster as a whole. I guess this has not been implemented so far by ESRI, has it?.
- By using the Interoperability extension and its postGIS file type, I can see my geometries within my database, anything new, so I am able to add those raster tables into my ArcCatalog tree. Interesting, at least this time, the icon of the element instead of being a table icon seems to be a point feature icon, so something different is going on. But when I try to display these point geometries (a kind of cells?), it says "Error reading Interoperability Data. The operation failed because the database table does not have a numeric number".
If I were able to add this numeric number into my raster table at the database - still I don't know how to do it- would I be able to finally visualize the raster?, or would I see just only the table again?. Would version 10.2 of ArcGIS improve this a little?. Is there any other way round to solve this within ArcGIS?
In the other hand, am I having these issues because I have not done something at the database level which I was supposed to do with my raster files? Someone has succeeded at adding postgis rasters into ArcGIS?