Latest Contributions by VinceAngelo

Cross-posted to GIS StackExchange ... View more

There are two different pages with different retirement date resolution, but they're both in Dec 2013.   ArcGIS 9.3 was introduced two months after my son was born, and he's a 9 year-old, so, yeah... - V ... View more

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