Latest Contributions by StéphaneHenriod

Yes, I now realize this isn't exactly good practices! Learning (and suffering) by doing 🙂 Recreating a DB is also not an option... I will thus contact ESRI support and see whether they can help at this point. Thanks a lot! ... View more

Thanks Marco, this is actually what I meant by "purging": deleting the records that are no longer synchronised with the actual state od the DB. So, if I inderstand correctly, there is no other way than recreating all the schemas and table? This is quite annoying cause I even have the opposite case now: a table that exists in Oracle (even has a shape column) but that is no longer displayed in ArcGIS... The problem probably arose while I had to delete and re-create this table a few times (sometimes within Oracle, sometimes within ArcGIS). If I rename this table, it appears in ArcGIS. But as soon as I give it its real name back, it disappears... My assumption is that there must be a record in the ArcSDE schema saying that this table is invalid or something... Any idea? ... View more

Thanks everybody for the answers Isn't there any other option than recreating the tables in Oracle and then deleting them in Desktop? There are quite a lot of them, including in schemas that no longer exist and this would require quite some manual work. There is no complex relationship though. I would have hoped that there is some kind of metadata table that can simply be purged? ... View more

Thanks everybody for the answers Isn't there any other option than recreating the tables in Oracle and then deleting them in Desktop? There are quite a lot of them, including in schemas that no longer exist and this would require quite some manual work. I would have hoped that there is some kind of metadata table that can simply be purged? ... View more

Hi restore is unfortunately not an option. Some tables have been deleted 2 years ago and we obviously can't restore to a point that far in the past... I will have a look at your link and contact ESRI if this proves insufficient. Cheers Stéphane ... View more

Sorry for digging up this old post, but I currently ave the exact same question. Is there an easy way to implement simple constraints in a File Geodatabase (foreign key constraints, for example)? I couldn't find any documentation on that... Thanks a lot in advance! Stéphane ... View more

Dear all, just a lttle up to this thread. Anyone has an idea why I am experiencing these troubles? Any idea what can cause bugs between PostGIS and ArcGIS? maybe the type of columns, the name of the geometry column, the platform or version of the tools...? Thanks a lot in advance and wish you all a very nice week-end, Stéphane ... View more

PS: I have tried to create a new very simple PostGIS table (1 column INT, 1 column GEOM, 1 primary key). And still the exact same issue when using data interop, but works fine when using the query layer. ... View more

Dear Bruce, I made a few tries, as per your recommendations. I checked the table in pgAdmin and, apparently, everything is fine (no empty geometry, type and srid referenced in the geometry_columns table: srid 4326 type POINT). I attach a sql dump of my table to this message. Still the same problem: I can see my layer in ArcMap and in ArcCatalog, but only the attribute table. If I "zoom to selected feature" or "flash", nothing happens. Interestingly enough, the "Add query layer" gives the exact opposite result: I can load my point layer, the points are displayed in ArcMap but, when I try to open the attribute table, I get the message "Could not load data from the data source. If you can correct the problem, press the refresh button to reload data. Possible problems can include bad network connection, invalid field, etc. The operation is not supported by this implementation" The database is installed on my local computer, so no network issue involved. Is there any field type in my table that is not recognized by ArcGIS? Final word: I have tried the exact same procedure with other tables in my database, and always get the same behaviour. Final word (2): I can use those layers with no problem in Qgis Thanks a lot in advance for your help! Stephane PS: Just got an awful doubt: does Data Interop work with PostGIS geometry type? or only with the PostgreSQL geometry types? ... View more

Dear Bruce, thank you for your answer! Unfortunately I can't, as I can't even open the layer in ArcMap. I try to add layer, choose "Interooperability connections", open "myconection.fdl" but this one is empty. Only in ArcCatalog, I can open "myconnection.fdl" and see the layer inside. The layer seems to be a geographic layer ("point" icon, column "SHAPE" in the attribute table), but can't be displayed in the Geography preview. Do you have an idea where it can come from? Thanks again! best, Stéphane ... View more