Latest Contributions by TimMinter

‎05-31-2023

@MarceloMarques - Got it. Thanks again. If there were a "Kudos" button for your replies, I'd be clicking them wildly 🙂.

‎05-31-2023

@MarceloMarques - Thank you. Revealing a bit more about my situation... ArcGIS Pro clients are all at 3.1.2 ArcGIS Enterprise components are at 11.1.x Python 3 scripts, ModelBuilder models, and similar incantations are all functioning more or less as expected. All of the above are working happily enough with the 10.9.1.2.9 enterprise geodatabase in SQL Server 2019 via ODBC Driver 18. I manage enterprise geodatabases in sandbox, development, test, and production environments. For an upgrade like this, I'll restore a backup of the production databases to the development instance, and then operate on those, iterating until things go green. I'll deal with my custom SQL code, SQL Server views, stored procedures, triggers, etc. as I need to. I own the costs and risks of that stuff getting busted by Esri's enterprise geodatabase changes. We dropped all support for ArcGIS 32-bit apps in February 2022, so if any linger and someone yells, we'll use it as an opportunity to get them current. So, given those conditions, it sounds like you're suggesting minimal or no trouble if I perform the recommended upgrade process from 10.9.1.2.9 to "ArcGIS Pro 3.1.x - 11.1.y.z" in my development SQL Server 2019 environment. Does that sound about right? Your answer helps me design my upgrade process. I'm looking to short-circuit as much of the process as possible, just expecting that there is a happy path I need to find. Ideally, that happy path is laid out for me in the documentation. I'm asking about all this stuff because my experience with the documentation is that there are frequently gaps between what it states and how the software works. thx, tim

‎05-30-2023

@MarceloMarques, @ChestonDobbins - The documentation is a little light on details. After tossing out, "breaking changes" concepts like the changes to the fully qualified names for enterprise geodatabase objects, it would be helpful to specify what we can expect to break, suggest mitigations, etc. So, when I upgrade my "10.9.1.2.9" enterprise geodatabases in SQL Server 2019 to "ArcGIS Pro 3.1.0 - 11.1.0.41833" enterprise geodatabases, should I expect some, all, or none of the following to break? APRX/LYRX layer connections to EGDB feature classes, tables, etc. ArcGIS Enterprise Server map services that use the EGDB feature classes, tables, etc. Python 3 scripts ModelBuilder models other stuff? thx, tim

‎05-24-2023

Yes, I've been able to find that outside of the My Esri Support workflow. I think it's a great idea to provide it within the workflow to help me go through a logical sequence of self-service before I commit to an Esri support request. Sequence being something like: Is the power on? yes Is the PC on? yes Are all ArcGIS dependencies correct? yes Did I read and follow the instructions? yes Is it a known bug? Is there a workaround? etc. You get the idea 🙂 tim

‎05-24-2023

The My Esri Support workflow should include the ability to search and present details for all bugs. The My Esri Support site presently helps you search your own organization's bugs, but not bugs reported by others. This has nearly no value for helping us solve new problems prior to requesting a support case.

‎05-02-2023

@RudolfdeMunnik I just got a chance to follow your lead and got it to work with our data. It looks to me like you've tested it thoroughly. I'm forcing WGS84 decimal degrees (WKID 4326) in my REST request like this: https://services1.arcgis.com/bKDOijB8sneN5004/arcgis/rest/services/AGRIC_GIS_DATA/FeatureServer/1/query?where=1=1&outFields=*&geometryPrecision=4&outSR=4326&f=json Then, I adjust the "Shape" custom field code like this: Text.Replace(Text.FromBinary(Json.FromValue([geometry])), "]]]" ,"]]], ""spatialReference"":{""wkid"":4326,""latestWkid"":4326}") Then, finally, I add your optional ShpTxtLen so I can see how things worked out and tweak the coordinate precision if needed. Thanks again! tim

‎04-18-2023

@RudolfdeMunnik Nice! One quick thought on dealing with the 32k character constraint is that the REST service request can specify an appropriately lower precision. So, going from 7 in your example to a lower precision that is appropriate for use in Power BI may be some good trickery. I'm thinking that Power BI doesn't know or care about topology and is happiest with cartoon geometries anyway, so it kind of doesn't matter as long as the area looks ok to the eye.

‎02-08-2023

Hi @ChelseaRozek, no, no go. One approach I haven't looked at very hard is to use ArcGIS Pro Data Interoperability extension to dump a TopoJSON. I gave it a few tries, but couldn't get the Power BI visualization thingy to recognize the file. I appeared to be following the instructions correctly, and it was beginning to smell like a bug, so I ran away. If you find a way, do post back. edit: What I didn't say was that the TopoJSON approach looks fairly stale in the PowerBI environment. There's a website that will convert for you, which is great for non-confidential data. I think I found the source code in Github and decided not to pursue going local with it. Also, one thought I had was to have a look at the SEDF to see if I could use it to squeeze out a CSV that PowerBI recognizes. I might poke at that one day soon.

‎02-03-2023

@AW_Grove What about adding them to an AGO organization or to an AGE portal? Without knowing anything yet about how the upcoming connector for ArcGIS Enterprise works, my first solution idea (which might be discarded quickly) is: Add "make CSV for Power BI" to the tail end of our data update ETL procedures (ugh. so much ETL. Why can't an ArcGIS map service just cough it up?) Update the CSVs in portal and tickle the item dates as needed to communicate freshness accurately. Gah. Second solution idea... Koop idk, tim

‎01-17-2023

Thanks for the detailed instructions @SeanKMcGinnis. Can I expect this to work with Power BI Desktop and our on-premises ArcGIS Enterprise deployment with no access from outside our organization's domain? All the documentation I've seen calls out "ArcGIS Online," so I'm expecting that I cannot use it with our ArcGIS Enterprise deployment.

‎01-11-2023

@AnneTetley @RudolfdeMunnik - good info, thanks! I've tried making EsriJSON format files with FME's Data Interoperability extension for ArcGIS Pro and bounced off without success. Doesn't mean it doesn't work, just that I've not yet made it work or proven that it doesn't. I won't engage Esri support for this unless a boss shows up with a big stick and proclaims that it's ok if I don't proceed on other assignments for a while. Also, about all I know right now of Power Automate is that there is a space between "Power" and "Automate", which I suppose is the third step after my usual starting point of complete ignorance. My customers and I deal with confidential health and other information. I've inquired internally to discover if Power Automate is authorized for use with our data (i.e. does not transport or process our data outside of our domain and transports and processes our data within our domain in an approved and secure manner), and I'll proceed with trying the suggested approaches after that light goes green.

‎12-16-2022

As-Is In ArcGIS Pro 2.9.5 (AGP), I can click a map containing numerous layers in the contents pane, then click Share > Web Layer > Publish Web Layer the "Share As Web Layer" dialog appears, and I can configure and publish I elect to "Copy all data * Feature" in order to create a "Feature Layer (hosted)" item type in ArcGIS Enterprise 10.9.1 (AGE) or ArcGIS Online (AGO), whatever AGP dutifully publishes the hosted feature layer to AGE. the AGE item page lists and links all of the layers in the item, one for each layer in the AGP map in order to share each layer as a separate item for AGE users to discover and use, I have to go to each layer item and click "Create View Layer" and go through that workflow to make separate item entries. ...and guess what - in AGE the title did not inherit the title of the layer, the item info/metadata is not present, Data tab just pulses Loading..., Visualization tab says "No legend" and zooms to the full extent of the web mercator basemap Idea for To-Be In ArcGIS Pro (AGP), I can click a map containing numerous layers in the contents pane, then click Share > Web Layer > Publish Web Layer the "Share As Web Layer" dialog appears, and I can configure and publish I elect to "Copy all data * Feature" in order to create a "Feature Layer (hosted)" item type in ArcGIS Enterprise (AGE) or ArcGIS Online (AGO), whatever New: I elect to "Create View Layers" for a) all; b) some; or c) none of the map layers AGP dutifully publishes the hosted feature layer and view layers to AGE. the AGE item page lists and links all of the layers in the item, one for each layer in the AGP map New: There is a "Feature Layer (hosted, view)" item for each map layer for which I elected to publish and create a view. New ...and each view layer inherits all of the item details, metadata, data & visualization styling from its source layer. Also, it works properly. I can then adjust the view layers as necessary, release them to my customers, and move to the next assignment. Bonus points The same pattern and capabilities hold for when I drag and drop a FGDB.zip onto the AGE "add stuff" thingy. And it works properly. Cheers, tim truncated tags ArcGIS, Pro, Enterprise, Online, copy, all, data, item, information, description, drag, drop

‎11-03-2022

I kind of failed to mention that the more recent SQL Server instance is on new hardware, didn't I? So, yes, I would expect things to be even easier if you're upgrading in-place on your current hardware. No AD Alias (CNAME) changes needed. Check the SQL Server help for your version or with your DBA regarding when and how to backup when upgrading. My experience has been good and easy with backup/restore, so nothing really to report. tim

‎11-03-2022

That's a good question. I'm not sure. If I recall, I think I registered the view with the geodatabase, which took forever, got it to work a little less slowly, handed it off to a workmate, and quietly slunk away. I'll keep an eye on Teams to see if my workmate starts grumbling on Tuesday morning, which is when supervised automation occurs for that particular data collection. All was quiet and successful this past Tuesday morn... hmm. Um. Well, we're at AGP 2.9.5, holding off on 3.x until some dust settles. Thanks for the report. We'll have a look after 3.1 releases. Also, this pattern with Esri's software has become known as "feature flicker" around our shop. A feature works properly at one release, then is borked at the subsequent release. Fairly annoying. tim

‎10-28-2022

Hi Frances, One of my teammates opened support case #03181219, which resulted in #BUG-000153360. From a quick scan, it looks like the bug fix recommendation and your info above about the accompanying DLL converged. I've had to move along to other assignments and have uninstalled Insights. Hopefully, my idea will come to fruition the next time I download and install it. Thank you, cheers, and have a proper weekend, tim

My Ideas

Latest Contributions by TimMinter

Re: Revise documentation for Upgrade Geodatabase GP tool when upgrading a SQL Server-based enterprise geodatabases to a version 11 geodatabase.

Re: Revise documentation for Upgrade Geodatabase GP tool when upgrading a SQL Server-based enterprise geodatabases to a version 11 geodatabase.

Re: Revise documentation for Upgrade Geodatabase GP tool when upgrading a SQL Server-based enterprise geodatabases to a version 11 geodatabase.

Re: My Esri Support should include bug search capability

My Esri Support should include bug search capability

Re: Shape in Geojson

Re: Shape in Geojson

Re: Shape in Geojson

Re: Using ArcGIS Connectors for Power Automate to get Custom Geometry in Power BI

Re: Using ArcGIS Connectors for Power Automate to get Custom Geometry in Power BI

Re: Shape in Geojson

Create View Layer

Re: Update ArcGIS Server Services after SQL Server Instance Change

Re: ArcGIS Pro 2.6, very slow to load SQL Server 2017 Views

Re: Databases > Create New Connection > We could connect to the database.

Re: Will ArcGIS Pro load a table with 860 million ...

Re: Some user avatars showing as broken link

Re: Will ArcGIS Pro load a table with 860 million ...

Re: Will ArcGIS Enterprise Portal use a file geoda...

Will ArcGIS Enterprise Portal use a file geodataba...