Latest Contributions by VinceAngelo

Shapefile is dreadful for this purpose, since it doesn't support the feature dataset container that supports networks.  File geodatabase is really your only option. - V ... View more

Legal questions like this are best asked of your lawyer, or by your lawyer to Esri's laywers. Asking strangers on the Internet is worth less than you pay for it (and does not absolve liability), but it seems that your use does not meet the "for free" criteria, and therefore such use would violate the Esri TOS. - V ... View more

You know how it works. Only Development makes promises about future development, and Support reports the supported environments. Even if I knew the plan (and I don't), it's not my place to say more than, "It ain't there yet." My problem was with a PG 11.8 to PG 11.9 transfer, where a geodatabase upgrade wasn't available, but the OID support was corrupted by the export -- pg_dump actually corrupted the geodatabase before the PG 12 support geodatabase changes could engage. - V ... View more

According to the 10.8.1 doc (https://desktop.arcgis.com/en/system-requirements/latest/database-requirements-postgresql.htm), support only goes to PG 12.2+ (PG 12.4+ for Pro 2.7), so it can't be before ArcGIS 10.9. If you haven't made it all the way to PG 12.x yet, I urge you to pay close attention to the note about "WITH OIDS=True" in older databases.  That's an ugly transition, there.  Cost me about 25 hours during a four-day migration, since pgAdmin4 pg_dump corrupts the "WITH OIDS=True" in PG 11 -> PG 11 migration, too. - V ... View more

If the data all registers well, then the difference is due to string comparison on projection names, not actual coordref differences.  This is one of the few cases where clobbering the .prj is acceptable (save the old one, though, just in case). - V ... View more

You generally want a hosted feature class or Enterprise geodatabase table for dynamic tables, since multi-user access with ACID (Atomicity, Consistency, Isolation, Durability) is an intrinsic feature of RDBMS. - V ... View more

If every row has a NULL value in that column, you certainly don't want to assert a NOT NULL on the column until the table has been updated so that only valid (non-NULL) values are present. - V ... View more

You can only enforce NOT NULL on a column if the table doesn't have NULL values in that column. You'll need to fix this first. - V ... View more

The "{tablename}" and "{columnname}" and "{datatype}" need to be replaced with actual values, e.g., ALTER TABLE [EDIT_TEST] ALTER COLUMN [TEST] nvarchar({actualwidth}) NOT NULL (Yes, you need to replace "{actualwidth}" with the defined width of the column). - V ... View more

If the table is not versioned, you can use SQL to alter the column: ALTER TABLE [{tablename}] ALTER COLUMN [{columnname}] {datatype} NOT NULL You should then open the table in the Catalog view as the table owner, to make sure the properties are correct, and populate the update to the sde.sde_column_registry table. - V ... View more

Friends don't let friends use Excel for data transfer (especially large data transfer).  CSV is much less likely to be mangled. - V ... View more

Daily reboots aren't really part of best practice.  Some of my clients have monthly "hardware" restarts, and if you want to be hard-core then weekly restarts could be scheduled, but the server recycle is supposed to obviate the need for *any* reboots. - V ... View more

Just because midnight is the default service restart time doesn't mean it needs to *stay* the service restart time. I ran a script to assign restart times in round-robin fashion with an interval 15 minutes between of hours of  0015-0445. - V ... View more

I'm getting HTTPS errors on your file links. If you put the parameters in the question as text, then no one would need to download an image for the definition of "crazy." Yes, spatial reference tolerances can have an impact on the compression algorithm used to store geometry, but only when using Esri's ST_GEOMETRY storage (you haven't specified the RDBMS or geometry storage type, either). Yes, correcting the feature dataset spatial reference generally requires a complete reload of all the feature classes, and replacing a feature class spatial reference generally requires recreating and reloading the feature class. - V ... View more