Latest Contributions by JayLarsen

‎02-07-2024

Hello. I have the same question. I have AGOL and BAO (web) and need to know the ESRI pop for city of Phoenix. How do I get it? Is there an enrichment of some boundary by city from census and ESRI? Or is there a canned report in BAO?

‎02-06-2024

AND THEY'RE MAGICALLY FIXED AGAIN. Yep, takes like a week to be messed up, and then ESRI magically fixes them and they work properly again. Very weird. Please fix this ESRI, when we make layers, it's because we are likely working on deadline and can't afford this type of error. Cheers!

‎01-31-2024

It has been officially end-of-lifed by ESRI in favor of the Office365 type plugins, sadly. I can't even find an old one hanging around anywhere. Last filename I had was: "ArcGISMapsForOffice_x64_2020.1.1_en" for 64-bit Excel, there was a companion for 32-bit as well. Some scammy-looking d/l sites seem to have it, but who knows what they really are?

‎01-29-2024

Yeah, I knew that trick...but I was hoping ESRI had fixed the underlying problem by now. I might as well wait as the layers do "fix themselves" some time later. I'm not gonna spend any more time on recreateing the layers when I have them funcional in the map I need for near term use. Such a weird error!

‎01-26-2024

It's doing this again. Made 2 layers from Excel upload last week, now can't open them properly outside of a map. SAME EXACT THING! Any new advice? I had hoped ESRI would have fixed this by now?

‎01-11-2024

I was looking at some ZIPs and census blocks for an area I was refreshing some work on and noticed that instead of vigorous pop growth, the 2023-2028 growth was now much slower or just a hair negative. The reason for studying this area was the growth--this area has been growing rapidly for years, and to my knowledge still is. I have read the ESRI Demographics notes saying be prepared for big swings as they base on the 2020 census now, but I am still very surprised! Has anybody else seen something like this? My area of interest is in the NW sector of the Phoenix metro. Not sure what to say to my bosses about this now? Any ideas?

‎01-04-2024

Yeah, I saw that. Even d/l a test *.osm file to hack in QGIS. I was hoping for an "automatic" way? Maybe I should just draw them? There could only be 20-30 structures in the end? I'll experiment. Thanks!

‎01-03-2024

Did you ever get an answer or figure this out?

‎01-03-2024

Is there a way to use building footprints from OSM or ESRI base maps? I want to tag my buildings in a map for the real estate dept to use. Both OSM and ESRI have pretty good building footprints, I just need to "cut" out the ones I'm interested in and put them in layer so I can do a JOIN to my ownership and use data?

‎12-07-2023

Thanks for the reply! It's a shame that IT security ruins our fun like this. I played around with the Excel Office365 plugin at home on my Mac with my personal license ID and it was very cool--worked like magic. I couldn't believe it!

‎12-06-2023

It's very common. I work in healthcare, and MSFT store is locked out. It's really a problem because we relied on the old Excel plugin for several routine workflows that are no very difficult and time-consuming. My IT didn't even really seem to understand what and how the AppSource store worked...we are all Office365, so you'd think they would be hip to MSFT's concept by now.

‎12-06-2023

Many of the feature I map are on top of one another at larger scales--sometimes even at smaller scales. Is there any trick or feature in AGOL to "squish" them from being on top of one another to side-by-side? Sort of a reverse clustering? The software "knows" that things being selected are on top of one another--it has the arrow to "page thru" all the features in the area when that occurs. So it should be possible, perhaps even easy? Anybody have the same problem?

‎11-14-2023

Your best new friend is the SQL-style JOIN command. It literally does everything you need. https://doc.arcgis.com/en/arcgis-online/analyze/join-features.htm Good to have some of the table join lingo...right/left and inner/outer mid... https://en.wikipedia.org/wiki/Join_(SQL) Cheers! Now just imagine if those lazy slacks at MSFT would put a JOIN command in Excel at last....

‎11-13-2023

The easiest way to make a ZIP choropleth map (<--cool map nerd term) is to use the Excel plugin. If you don't have that, it's going to be uploading the table and doing the table JOIN to the LivingAtlas ZIP layer. That's what the procedure in your link does. It's worth knowing that technique, no matter what. Good luck, you're on the right track!

‎10-31-2023

Yeah, it would be nice! Especially since % is so common in mapping. My recollection is you have to format the number part and the label part both with 2 separate Arcade expressions to handle both labelling in the choropleth map and the legend. Very annoying. Maybe somebody knows some magic to handle this?

Online Status	Offline
Date Last Visited	‎07-07-2025 05:52 PM

My Ideas

Latest Contributions by JayLarsen

Re: City Code

Re: Hosted Feature Layer Error: There was an error publishing the service.

Re: Where can I download the highest ArcGIS Maps for Office 2016

Re: Hosted Feature Layer Error: There was an error publishing the service.

Re: Error trying to open Hosted Feature Service

pop growth 2023 big swings?

Re: use building footprints from OSM or ESRI base maps?

Re: How to access footprint data from basemap

use building footprints from OSM or ESRI base maps?

Re: Offline installer for ArcGIS For Excel

Re: Offline installer for ArcGIS For Excel

method to automatically un-stack features?

Re: Creating a Composite Table in ArcGIS Online: Merging Data from Two Sources

Re: Creating Map with Zip Codes

Re: Allow formatting AGOL legends with percent %

USA Traffic Counts

Re: USA Traffic Counts

Re: Hosted Feature Layer Error: There was an error...

creating new hosted feature from existing is weird...

Re: City Code