Latest Contributions by VinceAngelo

Adding an imaginary rowid to a view is a terrible idea, and won't work (for the reasons explained above) Query Layers will use a string field as a registered column, but your column isn't unique across rows in the view, and therefore not applicable. You have two choices: Use the ArcGIS paradigm (relates and/or joins) or use the database paradigm (materialized view). - V PS: I certainly hope criminality isn't a factor, only out-of-control auto-correct. ... View more

No one can answer this without information on the cardinality of the relationships between TX_COUNTY_PARKS and TX_COUNTY_PARK_FEATURES and TX_COUNTY_PARKS with TX_COUNTY_PARK_TRAILS.  If either is one-to-many, you cannot use TX_COUNTY_PARKS.OBJECTID as a rowid. - V ... View more

That had to do with an ArcSDE Application Server (which don't exist any more, so the point is moot). Database location has been flexible since the introduction of Direct Connect 10.0/10.1. - V ... View more

That's a low-level database error, not anything Esri could have control over. A database server reboot or over-enthusiastic router configuration could generate this error, but there really is no way for us to know the cause. - V ... View more

There are an infinite number of coordinate systems that could be added, but only in the context of a finite number of known projections. Only Esri can add to the projection list (at least, if you wanted to deproject from it or project to it), but you could create a new CS string based on a known projection with alternate distance units or a custom prime meridian. Each new release of ArcGIS has a Projection Engine update, so the easiest way to increase the probability of your coordsys being supported is to make sure you're using a recent build of ArcGIS - V ... View more

Always be careful to understand what an ArcPy function returns. ListFields returns a list of Field objects, which while they include name, also includes type, isNullable, length and a number of other properties. You'd need to use a list comprehension to map the array of Fields to an array of names. - V ... View more

It can be a pain, because the Pro documentation is often found first in searches, but it's important to use the documentation for the software you are actually using. I generally go to desktop.arcgis.com, then Search, and specify the ArcMap flavor (vice "any"). Pro is sufficiently different that you shouldn't ever rely on its Python docs while using 32-bit Desktop or 64-bit Background Geoprocessing (it's even a different Python). - V ... View more

No, you never need to install any ArcGIS 10.2.x product for ArcGIS 10.5.x access to anything. Keep in mind that Desktop is 32-bit while Server is 64-bit, so you must have 64-bit Oracle libraries installed for successful Server connection. - V ... View more

PostgreSQL 9.6 is not supported by geodatabases yet, so it can't have an Enterprise geodatabase, so ALL of the geodatabase tables are missing. - V ... View more

So a line on the border of a polygon is not with the polygon, but if I add a single point to the line that is inside the polygon the line suddenly is within the polygon If you look at the Clementini* rules, this makes perfect sense. A geometry is composed of boundary and interior. The boundary of a line is the start and end points; the boundary of a polygon is its perimeter ring(s) (points don't have interior). So the "within" relationship tests for an intersection of the (line) figure with the (polygon) interior, and "line on boundary" does not intersect the polygon interior (empty set), so it's not "within". Then there's "Completely Within" and "Contains", and "Contained", but I have a scrum, so I'm not going there... - V *Eliseo Clementini, Paolino Di Felice, and Peter van Oosterom, A Small Set of Formal Topological Relationships Suitable for End-User Interaction, Proceedings of the Third International Symposium on Advances in Spatial Databases, p.277-295, June 23-25, 1993 ... View more

You're not helping yourself by providing a zip file. The script should by small enough to fit in the question page, so your participation will be hurt by a requirement to download, unzip, and open. - V ... View more

Python is a bytecode lanuage, much like Java (just more just-in-timey), and Java has gotten blazingly fast. - V ... View more

Please state which fields you cannot delete. Some RDBMSes do not support DROPping any columns, so explicitly stating the RDBMS in use and the exact version, with the exact versions of Desktop and Server is highly recommended. Screenshots to explain the error in context are not unwarranted. Best practice is to establish an "owner" login/schema which actually owns spatial data, and one or more  "access" logins through which the data manipulated (with access managed through roles). The account used to publish data to web clients should have the absolute minimum access possible. I haven't ever used archiving, but I expect it would complicate the ability to drop columns. - V ... View more

The SDE user login is not the highest level of access.  In fact, it shouldn't have any special privileges at all, and, as a rule, should not ever be used.  The table owner is the highest level of authority for any specific table and the RDBMS administrative user, which technically trumps owner, shouldn't be used at all (huge denial of service risk). - V ... View more