Latest Contributions by VinceAngelo

I'm on the slide toward 35 years as an Oracle DBA, but I've mostly been using PostgreSQL the past 10. I was always multi-platform (Oracle, Oracle/Sybase, Oracle/Sybase/Informix/DB2, Oracle/Sybase/Informix/DB2/SQL-Server, Oracle/SQL-Server/DB2/PostgreSQL, PostgreSQL/SQL-Sever/Oracle/Informix, PostgreSQL/SQL-Server/Oracle), so I'm comfortable with multi-tenanted  configurations, but I've been quite pleased with the maturity of PG 11/12/13/14/15. Dealing with schema names which aren't user or login names is probably the biggest pain point, but at least you don't need to try to run four different releases of ArcSDE in the same instance (on a single laptop with SQL-Server and Oracle and Informix also installed). - V ... View more

No, if you use double-quotes to force fields to camelCase, ArcGIS will not see the fields. Field aliases exist and are case independent in comparison. - V ... View more

Python is the world's easiest computer language to learn. Automating ArcGIS loading is as simple as: Completing the first few chapters of an intro Python book (or online class) Completing at least one free online intro ArcPy training Performing at least part of the task manually using Desktop Going into the Geoprocessing Results log and using "Copy as Python Snippet..." Pasting the snippet into a new script  with an import arcpy at the top Altering the singleton command to be in a looping construct (usually a for loop) Annotating your code with a ton of arcpy.AddMessage or print statements Test it over and over until you've got it right. That's it. Of course, there are many levels of complexity available with a programming language as powerful as Python, but you can start that next week. - V ... View more

Not to pile on, but this is not possible.  Each instance can only have one 'sde' login. The only way to have two different 'sde' logins is to have two different database instances (running on different machines or on one machine with two different database ports (the second on other than the SQL Server default of 1433). - V ... View more

Part of the issue could be using ancient software -- Pro 2.6 was released three years ago, and 10.7.1 six months before that.  The fact that a *point* feature class has topology errors is quite bizarre. Personally, I refuse to use copy/paste for data transfer -- too many ways for things to go wrong, and no way to determine what is being done. SDO_GEOMETRY has to have repair utilities because there is no way to get to the data in otherwise. ST_GEOMETRY is not supposed to accept invalid geometry, so there isn't any way to repair it once in place. The fact that it's corrupt is a bug in the Paste procedure (possibly introduced at Copy). You really ought to bring this dataset to the attention of Tech Support, though it wouldn't hurt to make sure the issue wasn't addressed by 2.7, 2.8, 2.9, 3.0, 3.1, or 10.8, 10.8.1 or 10.8.2 first. - V ... View more

Yes, it's a file geodatabase. Be sure not to change the folder name (it will no longer work if you change the '.gdb' suffix) or add any other files beneath it (once it finds '.gdb' in the path, ArcGIS is looking in the file geodatabase catalog for the remainder of the name). It is not, however, "a map."  Instead, it is mapping data. In the GIS model, a map is a characteristic of a application project file (e.g., ".mxd" for ArcMap or ".aprx" for ArcGIS Pro), where data is represented and the interactions of data sources are modeled. If the person providing the data didn't provide a project file, you need to go back to them for one (or learn to use GIS quickly), because you have nothing to pass on yet. The good news is that GIS isn't all that hard to start learning. The bad news is that animation isn't in the shallow end of the GIS skill set pool. - V ... View more

Both ArcGIS 10.3 and Oracle 11gR2 are ancient.  You haven't provided the DDL for table creation, but it seems likely that you have an unsupported datatype (which makes specifying the DDL all the more important). - V ... View more

It's more expensive to allocate an EC2 to run a PG instance than to use an equivalent RDS. S3 is much less expensive (albeit with higher latency) than EBS (SSD-backed) storage. Performance (and functionality) of a file share from an EC2/EBS volume is highly dependent on the location of the client (in the same AWS enclosure? in a different one? across a WAN?).  The mosaic dataset only really stores the metadata, not the images themselves, which are the vast majority of the storage requirement (probably 99.9+%). I don't have a ton of experience with MDS using RDS/S3, but I'm sure there's documentation and others with more experience for best practice recommendations. ... View more

Are you running an RDS in AWS or PostgreSQL in a Windows EC2 with file sharing? If it's the former, then this won't work, since an RDS doesn't have the ability to share a UNC path. If it's the latter, you probably ought to be using an RDS and an S3 bucket. - V ... View more

It seems likely (just based on 30+ years of Linux development, not with any direct knowledge)  that supporting DLLs changed (or were scheduled to change), and had to be folded into the release DLL to prevent an awkward package dependency chain.  It happens. -  V ... View more

(I moved your post to Data Management/Geodatabase Questions, where folks who deal with this will see it.) Please add the following details: What is the registered rowid column of table  pat_patrimoine? What is the cardinality of the relationship between pat_patrimoine and pat_entite_z1? What column did you register as the rowid for the view? What do the following two SQL queries return? SELECT count(*) FROM {viewname}; SELECT count(*) FROM {viewname} GROUP BY {registered_rowid_column}; - V ... View more

There's not really anything to elaborate on. The format was never published, so you should not find any documentation. It's also not something that needs to be used (except to convert to GeoTIFF). Esri tools (including Pro) will read Grid format (if it hasn't been mangled in transfer). The important thing to understand is that grid is a folder structure, so the parent directory and parallel "info" folder are critical. Moving just the files is more likely to mangle the data. - V ... View more

Case is a bit tricky -- Geodatabases are case-insensitive, but the enterprise geodatabase tables themselves require single-case (UPPER for Oracle, lower for others). ArcGIS clients will show the mixed-case alias for the tables, but Esri doesn't support the RDBMS extensions that allow actual mixed case (quotes around names, e.g., "MixedName"). I guess there is merit in using mixed case in aliases, since it will subtly allow you to detect if the table is registered. - V ... View more

Best practice is to design your feature datasets so that only feature classes that need to be edited together are in a single feature dataset. Sixteen feature classes in a single FDS is quite a few. Are these really all edited together or are you using the FDS as a folder mechanism? If it's the latter, you could remove the singleton feature class from the FDS, and just grant privileges for the edit user. - V ... View more