Latest Contributions by VinceAngelo

‎09-23-2016

There are, of course, few warranties in the software world, and collisions in 128-bit space are possible, but very remote. I'm just pointing out that they're less remote (by many orders of magnitude) if you are assigning values using two different algorithms (the examples you referenced use the same algorithm that ArcGIS uses, so they're not likely to conflict). If this is the only way to meet your requirement, so be it. But I do urge caution (and a UNIQUE index and robust error handling during assignment) - V

‎09-23-2016

As long as the GlobalID isn't NULL you can change it to any ID you want! This is not completely true, since it can't be NULL and it must be UNIQUE. The main benefit of the UUID type is the reliable uniqueness aspect, but that reliability is compromised by assigning values outside the algorithm. So, while you can set it to any value, doing so voids the warranty, and makes your organization responsible for allocation of IDs from that date forward. - V

‎09-21-2016

UUIDs have their place; I just try to make sure that I use them appropriately. The easiest way to configure non-UUID offline IDs is to assign a core element or element set to a device "AAA-CZZ" for device1, "DAA-FZZ" for device2. Leaving room for expansion is key, but depending on what is being collected, you may want to make the allocation root less obvious -- If you have a reliable time subsystem on the device, then the algorithm could be quite sophisticated. - V

‎09-02-2016

That entirely depends on what RDBMS you are using. Please be sure to specify the exact version of ArcGIS and the exact database product (with complete version, to patch level) with each initial post (it will generate answers faster, since there won't need to be multiple queries for additional information, or answers not applicable to your environment). Note that "shapefile" is a specific format, and when its data is loaded in a database it is no longer in that format. - V

‎09-01-2016

If the points were in a database instance you could create a trigger to automatically update both lon and lat when the geometry was updated (and vice versa -- update the geometry when either lon or lat was changed). Neither shapfiles nor file geodatabase support the concept of triggers, which means your application will need to enforce the desired behavior, but this can be defeated by not using the application. - V

‎08-26-2016

I'm not sure how versioning and state zero interact with user-schema geodatabases. I don't see how this would make your implementation any easier -- If the only versioned tables are owned by the one user, and no other user accesses them, then why would they need to be logged out to complete a compress? If you test this and it works for you, best of luck. - V

‎07-29-2016

I wrote some pretty extensive ArcPy scripts for a project that required custom data-loading into PostgreSQL 9.4 using ArcGIS 10.4. In order to improve performance I created some large dictionary caches, which blew out 32-bit process space limits ("Out of client memory" errors), so I installed the 64-bit Background Geoprocessing module, changed the Windows batch script path to include "...\Python27\ArcGISx6410.4" and "...\ArcGIS10.4\bin64" (vice "..\Python27\ArcGIS10.4" and "...\ArcGIS10.4\bin") and I was in business. When it came time to upgrade to 10.4.1, I experienced disaster -- My scripts weren't working! I couldn't even connect to PostgreSQL! Eventually, Tech Support walked me to a possible cause, and then I found the real cause: My connections failed because a PostgreSQL support library was missing from ArcGIS10.4\bin64 at 10.4.1. Unfortunately, the connections didn't fail in a useful way (say, by raising an exception), they sort of silently failed, only raising an exception when I tried to access the connectionProperties of the workspace description (props = arcpy.Describe(pathToDotSDEfile).connectionProperties) So, for the record, the solution is to install a replacement for the missing "libintl-8.dll" library. This can be done by: Installing a copy of 64-bit PostgreSQL server on all clients, and prepending the bin directory to the PATH Downloading and extracting the "binaries-only" install of PostgreSQL (or copying the bin directory out of your server, if it's a Windows install), and prependng that to the PATH Installing ArcGIS for Server 10.4.1, and prepending its Server\bin directory to the PATH Copying the "libintl-8.dll" file from an ArcGIS Server 10.4.1 install Server\bin directory into Desktop10.4\bin64 [Haven't tried, but it might work] Copy the "libintl-8.dll" file from a 10.4.0 Desktop bin64 directory (where Background Geoprocessing is installed) into the 10.4.1 bin64 folder [I've been told this *doesn't* work] I'm sure a QFE will come out on this pretty quick, but at least there's lots of workarounds.

‎07-27-2016

What happens when you copy the .gdb folder off the file server to a local disk, and access it there? This sounds like a networking issue (and best practice is to avoid network shares of file geodtabases). - V

‎07-22-2016

Databases can do any number of amazing things to prevent certain operations (at a performance cost, of course). Shapefiles are NOT database entities, and therefore don't have any of these options available. Even if you requested this enhancement through Ideas, and it was implemented, it's not likely that it would be implemented on shapefiles. - V

‎07-22-2016

You can't lock a column, only a table. ArcGIS creates the locks required for the operation by default. - V

‎07-21-2016

Have you tried to copy the feature class to an EGDB? It should just work (the only significance of the CAD object is that you can't access the data from SQL). - V

‎07-21-2016

It's been forever since I last looked at this, but I believe nothing has changed, in which case the answer is: It IS still possible to store multipatch in an enterprise geodatabase (there is no such thing as ArcSDE anymore), but this is only through use of a CAD object, since the underlying geomety type does not support multipatch. Given that it's been 4 years, you might be better off asking a new question. You should specify the version of ArcGIS involved. - V

‎07-11-2016

Dropping the spatial index has the same effect.

‎07-07-2016

This is the same answer as provided in gis.stackexchange.com two days ago. - V

‎07-06-2016

Databases aren't generally things that people leave open to allow anyone connection rights. In fact. most DBAs spend a great deal of effort to prevent that from happening (aided by the built-in firewall of the PostgreSQL server). PostGIS geometries are real geometries, just like the native geometry types of other databases. There are tons of tutorials out on the interwebs; I recommend you just dive in to get your feet wet. - V

My Ideas

Latest Contributions by VinceAngelo

Re: Using GlobalID for a Relationship

Re: Using GlobalID for a Relationship

Re: Using GlobalID for a Relationship

Re: Automatic Updates in X Y data fields

Re: Automatic Updates in X Y data fields

Re: User Schema geodatabase in Oracle 12.1.0.2

64-bit ArcPy and PostgreSQL at 10.4.1

Re: Errors when connecting to file geodatabases

Re: how to lock column in my shapefile?

Re: how to lock column in my shapefile?

Re: Is there any way to convert multipatch feature classes from a file geodatabase to an enterprise geodatabase?

Re: Multipatch Storage in ArcSDE: Are there any special requirements?

Re: SDE Taking Too Long To Load Data

Re: Publishing GP tools as GP services using Python 32- or 64-bit dependencies

Re: Help me understand which enterprise geodatabase (mainly PostgreSQL question)

Re: Error Connecting to Enterprise Geodatabase (SQ...

Re: Precision vs. XY Resolution

Re: Best practices for programmatically mirroring ...

Re: Best practices for programmatically mirroring ...

Re: Best practices for programmatically mirroring ...

Coordinate Reference Systems