Latest Contributions by TimMinter

@MollyGreenHogeweg - Nice!  Maybe the AI Assitants could have a chat on the backside with the Esri Support AI Chatbot when putting together "happy path", "workaround", or "doesn't work right now" guidance for us. @JonathanMcD - ask big! ... View more

@MariaGiarrusso - Good tip, thanks!  Fixed my similar problem using ArcGIS Pro 3.5.6 with ArcGIS Enterprise 11.5.0.  Of course, I then had to go do the pop-up configuration work again, but such is life in Esri-land. ... View more

Yeah, I was getting 1.471 million/second (that's right) doing COPY from CSV to PostgreSQL unlogged table, which straight up spoiled me.  I'm glad I didn't have to get all chunky on the input data, and I'm glad that the local power company, Dell, Microsoft, SAFE, and Esri loaded the 680m records to the EGDB table in the 12 hours that I was not paying any attention at all. Cheers Marco, tim ... View more

Yep, fixed!  Thanks @SimiBasu.  ... View more

Looks like the CMS configuration got jiggled so there's no way to select an off-menu avatar.  That's my UX, anyway.   ... View more

Thanks Marco, lots of potentially useful info there.  I'm thankful that I'm only dealing with 1.3b records on this one.  The PC I'm using for this work is just a June 2023 vintage Dell Precision workstation meeting or exceeding ArcGIS Pro recommended and/or optimal specs, so nothing noteworthy. ... View more

Well, I'm with you, Vince.  However, my employer needs it done, and I still enjoy being employed, so the part of me that I sell for 2080 hours a year would certainly try this.  The rest of me wouldn't.  ‌‌🙂 I loaded 1.3 billion records from CSV files to PostgreSQL last week in about 24 minutes, so that's pretty cool. In further poking about the web, I ran across a bunch of grumbling about how Python will just hang during larger data loads.  I'm assuming that ArcGIS Pro Append GP tool uses Python code, and I have a suspicion (that I won't pursue) that it's just another example of that behavior. If Append could swing it, it would get my records into a geodatabase table schema with fields ordered, named, and aliased per requirements without a bunch of re-messing about. So, one of my principles is to configure before I code.  I hope I don't have to code up your hints, but I'm glad you shared them.  Some of my workmates noted that Data Interoperability (FME) extension has loaded larger recordsets for them, so I'm headed that direction now, hoping and expecting that SAFE didn't code up their tools with Python. I'll report back here with what worked, probably. The table is not a feature class. It is raw material for defined and ad-hoc data products that can support spatio-temporal analysis, etc. by being related to a polygon feature class. So, big table becomes smaller table that meets someone's specialized requirements. We all know that I'm going to try Query Layer and/or Query Table on that big table whether it's wise or not. Cheers, tim ... View more

Hi @MartinF - anecdotally, I just upgraded the EGDB schema in a SQL Server 2019 db from 10.9.1.*** to 11.3 on Monday in a development environment after a good db backup.  ArcGIS Server map/feature/editing services that depend on the EGDB objects worked just fine without any changes.  ArcGIS Pro Layer files have the db name prefix part of the EGDB schema hardcoded, but ArcGIS Pro sorted it out without any changes to the layer files.  ModelBuilder models ran fine without changes.  I found some Python code that was doing some string manipulation on the fully expressed object name (e.g. <db>.<schema>.<object> that I expect to fail when I test it soon.  Code that depends on the db objects outside of the ArcGIS sphere continues to work because the db name element in the fully expressed object name is really just a value in one or more of the EGDB sde management tables, so it's not returned when you're working with the objects in SSMS.  All pretty much good to go without any major fixes. Cheers and good luck, tim ... View more

Thanks @KoryKramer ! ... View more

"Coming in with the golden light In the morning" -KB ... View more

@Michele_Hosking, @KoryKramer - sounds like a requirement that didn't ship with this capability the first go-round.  Maybe soon?  Maybe some day? ... View more