Russell Mercer's Avatar

Russell Mercer

@getspatial.bsky.social

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,011 Followers  |  334 Following  |  36 Posts  |  Joined: 23.09.2024  |  1.9951

Latest posts by getspatial.bsky.social on Bluesky


# 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 โ€” ๐Ÿ‘ 6649    ๐Ÿ” 2549    ๐Ÿ’ฌ 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 โ€” ๐Ÿ‘ 40574    ๐Ÿ” 12466    ๐Ÿ’ฌ 1114    ๐Ÿ“Œ 544
Post image

Noticing a theme here.

24.07.2025 19:37 โ€” ๐Ÿ‘ 15466    ๐Ÿ” 6170    ๐Ÿ’ฌ 1781    ๐Ÿ“Œ 895
Post image 04.07.2025 00:12 โ€” ๐Ÿ‘ 51303    ๐Ÿ” 13448    ๐Ÿ’ฌ 1545    ๐Ÿ“Œ 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 โ€” ๐Ÿ‘ 38837    ๐Ÿ” 8846    ๐Ÿ’ฌ 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 โ€” ๐Ÿ‘ 74091    ๐Ÿ” 10822    ๐Ÿ’ฌ 2148    ๐Ÿ“Œ 756
Post image 26.11.2024 18:11 โ€” ๐Ÿ‘ 54927    ๐Ÿ” 20368    ๐Ÿ’ฌ 1412    ๐Ÿ“Œ 1531
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 โ€” ๐Ÿ‘ 92630    ๐Ÿ” 25815    ๐Ÿ’ฌ 2204    ๐Ÿ“Œ 1435

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

@getspatial is following 19 prominent accounts