Latest Contributions by VinceAngelo

Placing the double-quotes around "Height" may have forced the SELECT result set to have a column named "Height", which ArcGIS cannot "see" because it requires ANSI-conformant SQL naming.  Try eliminating the double-quotes from the SELECT statement. - V ... View more

Unfortunately, the best way to recover corrupt file geodatabases is to create a new file geodatabase, copy out what can be recovered, then pull in contents of your backups for the rest.  You can try to work with Tech Support, but if the data no longer exists on disk, there isn't really anything they can do. - V ... View more

Note: Cross-posted to GIS Stack Exchange. ... View more

Contacting Tech Support should be your first impulse to address low-level database errors. You can post here as well, but GeoNet is not a replacement for Tech Support. Storage format does not change without a a specific request to do so.  SDELOB storage would remain so until an explicit upgrade was performed.  The Adds table should always have the same geometry storage as the base table.  If this is not the case, you absolutely need to talk to Tech Support. The error may be due to corruption of the base table schema with respect to the Adds table; SQL*Plus "describe tablename" on both the base table and Adds table is recommended. Esri supports Oracle 11.2.0.3 at ArcGIS 10.3.1, but recommends upgrade to 10.2.0.4 11.2.0.4 (ArcGIS 10.4 and 10.5 only support 10.2.0.4 11.2.0.4 and higher). - V ... View more

Are you editing a versioned feature class?  Does the deletes table remove the base table rows you have edited in favor of a newer version? All edits to versioned tables should be made with version-aware means. ... View more

Cross-posted to GIS Stack Exchange ... View more

Directories and files, both. ... View more

This is more a religious issue than a technical one.  Esri supports both Linux and Windows platforms, without regard to which one is "better". There are a few technical issues which could steer you to one platform or the other (e.g., Direct Connect to MS SQL Server enterprise geodatabase is not possible from Linux, or the only version of Windows supported by your IT department is under the minimum or over the maximum required for ArcGIS), but from my experience, Server is startlingly OS agnostic. Utilizing a new OS may have a ramp-up cost (if it's new to your IT infrastructure), but once the install is complete, the Server software behaves the same from a client standpoint.  The usual hitches in porting between platforms are tied to customized extensions and the curious way case dependency is handled when migrating from case-neutral path strings of Windows to case-dependent paths in Linux. - V ... View more

Please always include error messages as text in the initial posting itself.  There are two reasons: Folks are more likely to read it (and therefore answer) vice a zipped text file. The question (and answer, hopefully) is more likely to be found in a free text search by others with the same issue. - V ... View more

Actually, I should clarify that the units are assumed to be meters (the actual units are undefined) with a tenth-millimeter (1.0e-04) coordinate precision (but what's an order of magnitude between friends?) The SgShape library became the Esri reference geometry library 20+ years ago, but wasn't immediately adopted by all products. SgShape's CoordRef default origin and scale are {0.0,0.0,1.0},  which would snap degrees to the nearest degree and invalidate anything outside Quadrant I.  The arcpy SpatialReference type manifests the SgShape library's CoordRef as a wrapper, but it sets the nominal origin and scale to {-450359962737.05,-450359962737.05,10000} (which partitions the coordinate space addressable by a long long integer with {0,0} in the center). The arcpy Geometry type retains the double precision array values, so it's only storing them in a feature class that actually truncates the coordinates to four places (as per the SpatialReference) >>> import arcpy >>> pt = arcpy.Point() >>> pt.X = 1.23456789 >>> pt.Y = 9.87654321 >>> print pt 1.23456789 9.87654321 NaN NaN >>> pg = arcpy.PointGeometry(pt) >>> sr = pg.spatialReference >>> print sr.falseOriginAndUnits -450359962737.05 -450359962737.05 10000 >>> print pg.WKT POINT (1.2345678899999999 9.8765432099999995)‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

It's best to consider spatial reference use to be as "optional" as breathing.  In reality, every shape has a default spatial reference, which assumes units of meters, and coordinate precision of millimeters. - V ... View more

Please avoid use of the word "urgent", especially in titles, since all it really does is drive away potential respondents. ... View more

You can compute the intersection of the neighboring shapes (which will generate a line or point, or a line and a point) and compare the envelope of the relationship geometry with that of the reference shape, which would let you discern intercardinal directions (N/NE/E/SE/S/SW/W/NW) or even "Within". - V ... View more