Latest Contributions by VinceAngelo

I'm not aware of any changes to type support in the last six releases of ArcGIS.  I haven't tried to see if ArcGIS Pro handles bigint types. Using either integer or double is problematic in terms of primary keys.  Neither can capture the full range of bigint values.  If there are no values which exceed 2^31-1, then you should certainly use an integer type.  If the values exceed two billion, I'd recommend considering either hi/lo integers as a compound key, or using UUID (128-bit) with the 64-bit integer mapped to the lower half of the range.  After that would be ASCII text, and then double, since float equivalence is fundamentally unreliable. - V ... View more

It's unclear how you archived the file geodatabase (a brief search on "VisaVersa" does not locate backup software), but one of the tenets of making backups is to validate their efficacy.  If you haven't made a snapshot, cloned it, archived it, deleted it, and successfully restored (based on a byte-wise comparison of the clone and post-restore), you don't really have a backup.  If ArcGIS tools can't read the restored file, you may not have very many options.  Contacting Tech Support could confirm that the file is corrupt, and they may be able to tell whether this is a partial or complete loss situation. - V ... View more

The only possible option is if Microsoft supports an "asBinary" request on the geometry, and the result is parsed as a BLOB.  But that's the long way around the lake when WKT and WKB should be valid options. - V ... View more

I have no idea where the stream that starts with 'E6' comes from, but it isn't WKB or native shapefile. If you want to insert via Well-Known Text, you shouldn't capture Well-Known Binary from the cursor. They are related, but they are not equivalent.  There are significant pieces of your code missing, which makes it difficult to help you. - V ... View more

You should use 'shape@' as the field name to get the geometry object, 'shape@wkt' to the the Well-Known Text string, and 'shape@wkb' to get Well-Known Binary. It is confusing to reference "shapefile" and "SQL Server" in the same paragraph without specifying how you converted between them, since you cannot have a shapefile in a database. - V ... View more

I'm confused by your description of having two servers, one "SDE SERVER" and the other "SQL SERVER".  The ArcSDE server software no longer exists -- all that functionality now lived exclusively in the Desktop and Server "Direct Connect" capabilities.  The last version of ArcGIS to support an application server was 10.2 (which is scheduled for retirement in ten weeks), but since you are using 10.5, what is running on the SDE SERVER? Virtualizing database servers can have negative performance outcomes. I urge caution. - V ... View more

We pass 150m points through the 3m polygon-polygon intersection result (takes an hour or so in PostgreSQL, but only because we have to match to features nearby if not exactly within one).  I use straight SQL; none of that GUI stuff for me.  But first I defragment both tables spatially, and my polygons are regularly partitioned to max 25 sq km, so the identity operation flies. - V ... View more

Having gone through the extra steps of upgrading SQL Server and ArcGIS (twice), then drag-n-drop should be sufficient. - V ... View more

Again, there are security flaws in PG 9.4.5. Best practice it to start with the most recent build of the PG major release (9.4.21 for PG 9.4). The documentation doesn't show any geodatabase upgrade path from 9.3 to 10.4.1. You description is at odds with what is possible. - V ... View more

ArcGIS 9.2 is so ancient that it uses a different geodatabase model. Exporting though simple features (XML, file geodatabase, personal geodatabase, or if desperate, shapefiles [though ASCII is probably less lossy than shapefile]) and starting fresh in a new database is your only viable methodology. As to the PostgreSQL release, you ought to be starting with 9.4.21, which is also compatible with ArcGIS 10.4/10.4.1 (but has fewer known security bugs).  And there isn't any reason to start using ArcGIS 10.4 when 10.4.1 is the long-term supported release. Starting with 10.5.1 or 10.6.1 would allow access to PG 9.5 and 9.6, respectively, and pull you back from the precipice of PG 9.4 end-of-life (Dec 2019) - V ... View more

Since this is a new question in a different environment, it really ought to be asked as a new question. ... View more

Going back and editing the initial post is required in GIS SE, but it's confusing here, where there is no way to distinguish comments  from answers.  Far better to post edited code as a reply to the original post, so that your current code is provided as a snapshot in time. - V ... View more

You haven't defined the Python variables Q1/A1/W1/Q2/A2/W2/Q3/A3/W3/Q4/A4/W4/Q5/A5/W5 (by adding them to parameter list?) and don't use Python syntax to reference the W? variables in the code block. The expression should look like computeFn(!var1!,...!varN!) ‍‍‍‍ And the code block like def computeFn(var1,...varN): return var1 * ...‍‍ - V ... View more

Yes, ArcMap 10.4.1 (32-bit ArcPy), in fact (and don't call me Shirley ) - V ... View more

An Enterprise geodatabase can only be configured without Esri SDE.ST_Geometry support when using RDS (Amazon PostgreSQL Database-as-a-Service).  If you just want PG-based support Query Layers (without any geodatabase functionality) then you don't need to create the sde login/schema or run Enable Enterprise Geodatabase. - V ... View more