Russell Mercer's Avatar

Russell Mercer

@getspatial

Cartographer, data nerd. San Diego by way of Seattle. FOSS4G. Love my family, dancing, and travel. Need to do more of the last 2! Getspatial.com

1,012
Followers
334
Following
36
Posts
23.09.2024
Joined
Posts Following

Latest posts by Russell Mercer @getspatial

# of paragraphs for news orgs to mention there's no discernable need to deploy troops to Portland, Oregon

The Guardian: 1st paragraph
BBC: 4th paragraph
AP: 5th paragraph
Time: 6th paragraph
Politico: 8th paragraph
NPR: 9th paragraph
CNN: 10th paragraph
NBC: 12th paragraph
Fox News: never mentions

27.09.2025 19:24 ๐Ÿ‘ 6645 ๐Ÿ” 2547 ๐Ÿ’ฌ 156 ๐Ÿ“Œ 159

The fact that Matthew Dowd lost his job for pointing out Charlie Kirkโ€™s hate speech, while Brian Kilmeade openly suggests we should euthanize the homeless and there is zero outrage, shows exactly what is terribly wrong with todayโ€™s political mainstream media.

13.09.2025 20:35 ๐Ÿ‘ 40548 ๐Ÿ” 12458 ๐Ÿ’ฌ 1113 ๐Ÿ“Œ 544
Post image

Noticing a theme here.

24.07.2025 19:37 ๐Ÿ‘ 15462 ๐Ÿ” 6168 ๐Ÿ’ฌ 1780 ๐Ÿ“Œ 894
Post image
04.07.2025 00:12 ๐Ÿ‘ 51280 ๐Ÿ” 13445 ๐Ÿ’ฌ 1544 ๐Ÿ“Œ 590

Clearly your cat has a better grasp of what your priorities should be than you do.

20.06.2025 05:21 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Aye, for at 0%, every hour is 5 oโ€™clock everywhere.

18.06.2025 03:08 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

People with random knowledge, and a willingness to share it, are what we need more of in the world. We all know things. Sharing them lifts everyone up and gives that little spark of joy at learning some odd tidbit you wouldnโ€™t have found out except by that chance interaction.

18.06.2025 03:05 ๐Ÿ‘ 29 ๐Ÿ” 2 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

These are fantastic! Deep sea muppets need a series. Feel like there should be a pirates of the Caribbean crossover with the dead sailors from the black pearl.

18.06.2025 03:01 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

So I have to ask, what about ArcPro would make this better? Do you want the contours smoother because they look better, or because you think they are more accurate?
Are contours easier to symbolize in Pro than QGIS?
Sorry, asking seriously to see what the functional differences are.

17.06.2025 01:12 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

W.E.B. Du Bois on Robert E. Lee:

โ€œEither he knew what slavery meant when he helped maim and murder thousands in its defense, or he did not. If he did not he was a fool. If he did, Robert Lee was a traitor and a rebelโ€“not indeed to his country, but to humanity and humanityโ€™s God.โ€

11.06.2025 12:42 ๐Ÿ‘ 38812 ๐Ÿ” 8842 ๐Ÿ’ฌ 299 ๐Ÿ“Œ 270

Hi all. Iโ€™m trying to connect to a MS SQL Server DB from Postgres using a FDW, and am having trouble getting the connection string right. Has anyone done this successfully on a windows server? Any assistance or pointers would be much appreciated.
#gischat #postgresql

11.04.2025 20:14 ๐Ÿ‘ 3 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
FlatGeobuf A performant binary encoding for geographic data based on flatbuffers

Turns out what I found was the flatgeobuf format. Looks like it has a translator in the OGC package, so I will have to give that a shot for converting small datasets to for use on the web.
Too much new stuff to keep up with! ๐Ÿ˜Š

flatgeobuf.org

19.03.2025 15:19 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Web geo people. I need help tracking down something. A few months back, I ran across info about a library or script that could be used to serve layers from a geo package out to the web without setting up a full product like geo server or map server. I canโ€™t find it now. Any ideas? #gischat

06.03.2025 05:35 ๐Ÿ‘ 2 ๐Ÿ” 1 ๐Ÿ’ฌ 2 ๐Ÿ“Œ 0

I use a Firefox with an ad blocker and a No Script plugin. DuckDuckGo may have one. NoScript does as it says and blocks scripting running on the page. It is broken down by originating site so you allow the parts to make the site work and block the ones that serve ads, etc. Extra work, but worth it.

28.01.2025 09:13 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Son is off school today. He told me he wants to play a game. My recent history of watching YouTube horror movie clips is haunting me as now all I hear in my mind is a tape of the guy from the โ€œSawโ€ movie franchise starting up and him saying that. ๐Ÿคฃ๐Ÿคฃ

06.01.2025 19:35 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Post image

Did you know BlueSky only has 20 employees?

We would like to say a huge THANK YOU to those 20 warriors (who are working 24/7 to keep up with the incredible growth) for giving us a space to share.

We escaped hell to be here.

Thank you, @bsky.app & Jay Graber CEO (not a billionaire)

26.11.2024 17:58 ๐Ÿ‘ 74066 ๐Ÿ” 10820 ๐Ÿ’ฌ 2146 ๐Ÿ“Œ 755
Post image
26.11.2024 18:11 ๐Ÿ‘ 54897 ๐Ÿ” 20355 ๐Ÿ’ฌ 1412 ๐Ÿ“Œ 1528
Preview
Salish Sea Atlas - Table of Contents The Salish Sea Atlas is a free, open access, digital atlas of the Salish Sea Bioregion. Each chapter explores a different theme with text, images, interactive maps, and data download links. Learn more...

The Salish Sea contains all of Puget Sound, as well as the Strait of Georgia and Strait of Juan de Fuca. If you want to learn more about the Salish Sea's geography, check out my overview here arcg.is/1D8rDX0

26.11.2024 16:34 ๐Ÿ‘ 1 ๐Ÿ” 1 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

Thank you for this information! The Salish Sea Atlas you created is a fantastic resource!
I remember hearing the name Salish Sea occasionally , but am more disconnected from Pacific Northwest topics than I used to be, and never followed up. I appreciate this cultural and ecological definition.

26.11.2024 18:24 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

This really begs the question of why our brain appears to mostly use our long-term archived memories, to torture us?
Anyway, congrats on your PHD versary! I saw my wife complete her masters and the level of effort. A phd is an order of magnitude more. A great accomplishment, even ten years on!

26.11.2024 16:40 ๐Ÿ‘ 2 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0

Humble apologies for being off topic, but I read your first couple lines and thought you were obliquely referring to your dog fishing for catfish. ๐Ÿฆฎ๐ŸŸ
Reading further, that would be the surprise of a dogs life if they grabbed on that big a fish!!

26.11.2024 03:54 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 0 ๐Ÿ“Œ 0
Post image

Winter is coming and the #30daymapchallenge Day 25's prompt is "Heat", so obviously I made a map of the 1991-2020 average winter minimum temperatures across the Salish Sea Bioregion ๐Ÿ™‚

#geography #cartography #GIS #SalishSea #climate

26.11.2024 02:48 ๐Ÿ‘ 25 ๐Ÿ” 3 ๐Ÿ’ฌ 3 ๐Ÿ“Œ 0

Pretty amazing how far the temperature moderating influence of the water stretches inland.
Is the Salish Sea considered to contain all of Puget Sound, or is it just part of the bioregion?

26.11.2024 03:32 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

He quite clearly has this all figured out. ๐Ÿ˜

25.11.2024 22:00 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0
Post image

This needs to be said, loud, and often.

25.11.2024 17:20 ๐Ÿ‘ 92588 ๐Ÿ” 25802 ๐Ÿ’ฌ 2204 ๐Ÿ“Œ 1434

Also I realize from looking up rayrender that you may be talking about rendering light in a scene somehow and I may be talking completely out my ass. If thatโ€™s the case, I humbly apologize!!

23.11.2024 05:09 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

By path tracing, are you looking for paths between certain points, or a path from each point to every other point? Are the paths a street network or some such?
Just spitballing here, but it seems like depending on your constraints, there could be some geospatial solutions that may work.

23.11.2024 05:02 ๐Ÿ‘ 1 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0
Post image Post image Post image Post image

My redesign of the downtown Seattle Metro Service map--as seen on the screen and in the wild.

โ€ฉ#seattle #transit #maps #transitMaps #wayfinding

21.11.2024 23:01 ๐Ÿ‘ 54 ๐Ÿ” 9 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0

But is the number of people doing it statistically significant?

21.11.2024 16:44 ๐Ÿ‘ 0 ๐Ÿ” 0 ๐Ÿ’ฌ 1 ๐Ÿ“Œ 0