So, I'm working on a project using Postgresql and Postgis. We have a client using ArcGIS (10.0) and ArcFM. We are trying to export some data from postgres to ESRI, but we have our hands tied quite a bit as we don't have esri experience or access to esri!
The client is a utility and using the connectivity features of esri. They have a pretty extensive network mapped already and we are looking to add assets to it. For example, a service line to an existing water main - and have it connected appropriately.
We have looked at a few ways so far, I thought the most promising was to use gdal / ogr to export from postgres to a file geodatabase. Then the 'Geometric Network Incremental Loader' could be used to import and connect the data. It may still work but it seems that the likely SRID projection needed isn't supported by the ogr / FileGDB format.
Doing more research, I found that arcgis has capabilities to read postgis - it seems at both the server and desktop level. Is it possible then for ArcGIS to load postgis data and import / copy either all or selected data from the postgis 'layer' in to the existing geometric network? Copying all the attributes, geometries and connecting appropriately? I saw reference to the 'Copy Features' command - will this do all of that?