Latest Contributions by VinceAngelo

Best practice is to create the FD using the desired spatial reference, then create new FCs within the dataset.  Second best is to use a feature class to create a feature dataset, but you will not be permitted to add an existing FC which does not exactly match the SpatialReference, because that's pretty much all a feature dataset does. The issue with using 9.3 is that it is so old, no one here is likely to have it available, so you're pretty much on your own for making it work. - V ... View more

The sun set on 9.3 closer to three and a half years ago (01 June December 2013).  Oracle 10g isn't supported by modern software, either. Feature datasets are the way to implement geodatabase functionality like topology.  The 'misbehaving' is frequently a matter of "behaving as designed" under sub-optimal conditions. - V ... View more

The PostgreSQL servers I work with at client sites are "frequently" restarted -- Every 4-6 weeks or so.   We're given several days' advance notice of the planned reboot during the regular after-hours outage window.   Stopping your server before the clients can often cause "undefined behavior" on the client side, especially if the client is configured to attempt to reconnect.   Attempting to start a server before the previous sessions exit could easily cause an error like you reported (in fact, this is the expected behavior, since the alternate is partial or complete corruption of the database instances). Failure of the PostgreSQL monitor to access the ST_geometry.so on the server is an exceedingly bizarre situation.  I've never seen or heard of that occurring. The only possible explanation which would make sense is if the server's files are accessed through an exceedingly slow NFS mount. In short, steps 1-4 & 7 are expected functionality, step 5 should not ever happen, and step 6 should not ever be necessary. ... View more

It's always critical to specify, in  the question: The exact release of the database to which you are connecting, and The exact release of ArcGIS which is being used to connect. The error message implies that your database is incompatible with your Desktop. - V ... View more

The error was explicit -- the VARCHAR constant exceeded 4000 bytes.  You can use a CLOB type for this purpose, but getting the string into that CLOB is the trick. -V ... View more

Not at this time, but there should be plenty of discussion on the topic if you look for it.  The are many variables to consider, especially frequency of update. - V ... View more

This question is identical to a question posted (and closed) on GIS StackExchange ... View more

There are a number of definitions of "efficient" in this context.  Cross-database join performance, to paraphrase John Nance Garner, isn't worth, err..., much.  The fastest response query would involve replicating an ideal subset of the join data locally (possibly even in denormalized form), then querying that from your app. - V ... View more

Please add a graphic describing your goal.  If it looks like this GIS StackExchange post, then there's already  an answer. ... View more

Posting the same question, without demonstrating that you learned more about what is necessary to make that question answerable, might actually reduce the pool of folks willing to help (which may not have been as large as you imagine). Part of the issue is that you seem to be pursuing a solution without articulating the problem it is supposed to solve (the formal name for this the "XY Problem" -- it is described here and here).  I suggest you provide more information on what you are trying to accomplish and why, then cross-check to make sure relationship classes are the right solution. - V ... View more

Cross-posted in GIS StackExchange.  You've left out quite a lot of information that was added in GIS SE comments which are critical to understanding this question (those comments should have been made as edits to the question there, as well). ... View more

Cross-posted to GIS StackExchange as Converting dwg to shapefile using arcpy and ArcGIS js ... View more

If the PG databases are in the same server, you might be able to INSERT INTO ... SELECT across databases within SQL. It's not at all difficult to write ArcPy code with a da.SearchCursor fetching rows from one database and da.InsertCursor writing into another.  I moved several dozen tables spanning 60 million rows using this last summer without any ArcGIS-related errors (using both 32-bit Python and 64-bit Python). - V ... View more

I often write scripts which are designed to run for hours or days, so I usually add a test at the top of major processing loops that check for some condition which would cause graceful termination.  Often it is the existence of a "stop.now" file,  but sometimes it is a "pause.now" which puts the script in a loop waiting for either a "stop.now" to terminate or an absence of "pause.now" to continue.  This would have to be added into your script before execution. Python script tools (.pyt) can interact with the progress bar in the tool window, but need to be inside an asynchronous arcpy.SetProgressor()/ResetProgressor() session, at which point a try block around arcpy.SetProgressorPosition() will catch a Cancel button press and allow you to handle it gracefully. - V ... View more