HN user

wcedmisten

883 karma

Full stack software engineer. Specialization is for insects.

We all learn better together!

https://wcedmisten.fyi

wcedmisten@gmail.com

Posts24
Comments121
View on HN
surprisedatespot.com 1y ago

A Global Comparison of Restaurants in OpenStreetMap and Overture Places

wcedmisten
4pts0
surprisedatespot.com 1y ago

Show HN: Surprise Date Spot – Spin the wheel to find a new restaurant near you

wcedmisten
2pts0
old.reddit.com 1y ago

Family poisoned after using AI-generated mushroom identification book

wcedmisten
248pts108
wcedmisten.fyi 1y ago

Open source tools to query OpenStreetMap

wcedmisten
115pts9
wcedmisten.fyi 1y ago

Open source tools to query OpenStreetMap

wcedmisten
9pts3
jalammar.github.io 2y ago

The Illustrated Word2Vec (2019)

wcedmisten
180pts19
wcedmisten.fyi 2y ago

Show HN: Hospital Territory Map of Virginia

wcedmisten
4pts3
wcedmisten.fyi 2y ago

Adding Keyboard Shortcuts to a 24 Year Old Government Website with Userscripts

wcedmisten
4pts0
waterwaymap.org 2y ago

Waterway Map

wcedmisten
434pts151
github.com 2y ago

OpenStreetMap Americana: A quintessentially American map style

wcedmisten
4pts0
koipond.fish 3y ago

Koi Pond

wcedmisten
43pts3
wcedmisten.fyi 3y ago

Mapping hospital accessibility with OpenStreetMap

wcedmisten
151pts33
news.ycombinator.com 3y ago

Ask HN: Best pretrained OCR model for dashcam footage?

wcedmisten
2pts0
wcedmisten.fyi 3y ago

Making a Stateful Webapp on a $7.68 per Month Budget

wcedmisten
2pts0
blog.tugzrida.xyz 3y ago

Introducing: The IPv6 Canvas [Now Closed]

wcedmisten
2pts0
pluralistic.net 3y ago

The urinary tract infection business-model

wcedmisten
7pts0
ianthehenry.com 3y ago

Drinking with Datalog

wcedmisten
3pts0
wcedmisten.fyi 3y ago

Self Hosting a Google Maps Alternative with OpenStreetMap

wcedmisten
1pts0
wcedmisten.fyi 3y ago

Measuring Walkability with OpenStreetMap and Isochrone Maps

wcedmisten
3pts0
www.openbible.info 3y ago

The location of every identifiable place mentioned in the Bible

wcedmisten
5pts0
wcedmisten.fyi 3y ago

Show HN: Fill in the plaques for these paintings made by Stable Diffusion

wcedmisten
1pts0
wcedmisten.fyi 3y ago

Show HN: Multiverse Art Curator – small browser game made with stable diffusion

wcedmisten
1pts0
wcedmisten.fyi 4y ago

Evaluating Mechanical Keyboard Delivery Estimates with Python Web Scraping

wcedmisten
2pts0
wcedmisten.fyi 4y ago

Find Missing Speed Limits in OpenStreetMap from Dashcam Footage

wcedmisten
4pts0

I don't get how people can listen to and share AI generated "music" and not feel legitimately embarrassed to their core. Like the AI Charlie Kirk song, but unironically. I'm truly baffled how anyone can enjoy it.

If I was very talented and had the time, I could have written the lyrics and recorded the song myself (which undoubtedly would be even more awesome), but I can’t do this.

I promise you that any art you produced would be better than slop. There is not a single crayon scribble or off-tune melody that would be worse than the generic garbage that comes out of an AI model

Software engineering is a mostly solved problem at this point

I guess that's why Claude Code has 0 open issues on Github. Since software engineering is solved, their autonomous agents can easily fix their own software much better and faster than human devs. They can just add "make no mistakes" to their prompt and the model can solve any problem!

Oh wait, they have 5,000+ open issues on Github[1]. I'm yet to be convinced that this is a solved problem

[1] https://github.com/anthropics/claude-code/issues

Having spent 3 years of my career working with Clojure, I think it actually gives you even more rope to shoot yourself with than Python/JS.

E.g. macros exist in Clojure but not Python/JS, and I've definitely been plenty stumped by seeing them in the codebase. They tend to be used in very "clever" patterns.

On the other hand, I'm a bit surprised Claude can tackle a complex Clojure codebase. It's been a while since I attempted using an LLM for Clojure, but at the time it failed completely (I think because there is relatively little training data compared to other mainstream languages). I'll have to check that out myself

Overture is an awesome resource because it has more coverage than OSM, but at the cost of accuracy. When I was considering using it for restaurants in surprisedatespot.com, I found that it has a lot more automated content with bad geocoding (imprecise locations) compared to OSM.

E.g. restaurants can come from an old Facebook page and the geocoding might not be accurate compared to a survey.

So where OSM might have a restaurant that closed 8 years ago, overture has every restaurant that's been at that location for the past 8 years.

osmnx looks like a cool library, I haven't seen that one before!

As for self hosting overpass, I have considered it, but the installation steps seemed a bit tedious to me compared to a lot of tools which are dockerized.

I'm a big fan! I use it for most of my OSM projects. It's pretty easy to download an OSM extract and process it into base tiles.

Protomaps also provides a free set of base tiles that you can download and rehost yourself if you don't want to process the data locally.

Hi everyone, author here!

I love making projects with OSM, but it can be challenging to figure out how to analyze the data. So I wrote the article I wish existed to help make it a little easier!

Those are the most popular sources, and I've used both!

The first one is the official OpenStreetMap data, which contains the "planet file" - i.e. all the data for the entire world. But because OSM has so much stuff in it, the planet file is a whopping 76 GB, which can take a long time to process for most tasks. I also recommend using the torrent file for faster download speeds.

As a result of the planet's size, the German company Geofabrik provides unofficial "extracts" of the data, which are filtered down to a specific region. E.g. all the data in a particular continent, country, or U.S. state. If you click on the "Sub Region" link it will show countries, and if you click on those it will show states.

The reason I call it high performance is that it avoids the hours/days of processing (for the planet file)[1] that would be required for pulling the data out of PBF and indexing it. And you'd also need RAM at least the size of the planet to even get that level of speed.

You could certainly amortize this cost for repeated queries, but for one-off queries I haven't seen anything faster.

[1] https://wiki.openstreetmap.org/wiki/Osm2pgsql/benchmarks

I recently discovered DuckDB's Read_OSM() function [1], which lets you query OSM PBF files directly.

For example, it's simple to count the cafes in North America in under 30s:

  SELECT COUNT(*) FROM st_readOSM('/home/wcedmisten/Downloads/north-america-latest.osm.pbf') WHERE tags['amenity'] = ['cafe'];
  ┌──────────────┐
  │ count_star() │
  │    int64     │
  ├──────────────┤
  │        57150 │
  └──────────────┘
  Run Time (s): real 24.643 user 379.067204 sys 3.696217

Unfortunately, I discovered there are still some bugs [2] that need to be ironed out, but it seems very promising for doing high performance queries with minimal effort.

[1] https://duckdb.org/docs/extensions/spatial.html#st_readosm--...

[2] https://github.com/duckdb/duckdb_spatial/issues/349

I'm not sure. It's because the streets are made of multiple segments ("ways" in OSM terms), which are being counted separately. I think the query would need to join connected segments to get a true number of streets.

If anyone wants to make a similar map in their own city or with a different street name, you can use Overpass Turbo to query OpenStreetMap data for this. Just comparing the maps visually, they seem to match. [1]

  [out:json][timeout:25];
  {{geocodeArea:London}}->.searchArea;
  nwr["name"="High Street"](area.searchArea);
  out geom;
[1]: https://overpass-turbo.eu/s/1ME6

I recently started a tech meetup [1] in my small city (Charlottesville, VA), and was surprised at the amount of interest!

One tip for finding a space, try your public library! Mine has plenty of meeting rooms that can be booked for free.

I initially was buying pizzas for the meetup, but they didn't really get eaten, so now I don't bring anything but an HDMI cord.

[1] https://cvillecreativecoders.com/