Skip to content(if available)orjump to list(if available)

Show HN: A Simple Server to Match Long/Lat to a TimeZone

Show HN: A Simple Server to Match Long/Lat to a TimeZone

15 comments

·May 20, 2025

I figured this might be useful to folks.

It's a simple PHP server that requires a single-table database (It's fairly "agnostic," but all my uses are in MySQL).

I won't publish any of the servers that I've set up for my apps, because someone is bound to write an application that drives my bandwidth into the stratosphere.

I could definitely take it further, but this gives me all I need for my purposes.

Here's an app I wrote, that uses it: https://apps.apple.com/us/app/we-are-never-alone/id650482602...

kevmo314

Since the geojson for the timezone data is a static file you can avoid using a database entirely and ship it to your app.

If you'd like to avoid shipping a giant geojson, with the generosity of CDN providers you can actually hit the npm-hosting servers with HTTP Range requests and do this completely on demand from the client: https://github.com/kevmo314/browser-geo-tz

edoceo

How should we get right bits by range? Wouldn't we get chunks of JSON that aren't delimited nicely?

kevmo314

Good question, the geojson data is actually broken down into two parts, a true JSON file and a quad tree: https://github.com/evansiroky/node-geo-tz/tree/master/data

So I guess it's a bit of a lie that it's only geojson :)

The way it works is you load the index file which contains the large regions (in other words, the first level or two of the quad tree) and if the time zone can't be resolved, it relies on querying the data file which is actually a multi-record protobuf file so you can load the specific range of data you're looking for. The algorithm is here: https://github.com/evansiroky/node-geo-tz/blob/master/src/fi...

Here's the step that resolves individual tree nodes: https://github.com/kevmo314/browser-geo-tz/blob/main/src/fin...

edoceo

Ack. Like so many managers I asked the question before code review. I see the curTz and getting offset bytes for a proper blob decode. Very legal and very cool.

SahAssar

I'm guessing this does not try to handle things like terra nullius (Bir Tawil, Marie Byrd Land, etc.) or where there might not be a "correct" answer over which timezone is in a place (like https://www.972mag.com/the-worlds-only-ethnic-time-zone/)?

ChrisMarshallNY

It just uses the map that was generated by the TimeZone Boundary Builder[0]. It does fine for my purposes.

I just figured it might be useful. One reason that I wrote it, was because I couldn't find a decent SaaS that didn't charge eye-watering prices, for a fairly slow response. I wrote it in an afternoon or two. Not really an ambitious project.

I don't usually do "Show HN." Not interested in competing with anyone. If you like it, use it. If you don't like it, don't use it. If there are clear bugs, I'm always open to feedback.

[0] https://github.com/evansiroky/timezone-boundary-builder

lowercased

FWIW, I'd found https://www.geocod.io/ to be a good service a couple years back. They sponsored some conferences I went to, and I needed some geocoding->timezone info. IIRC, at the time, it was $5/month which covered everything we needed. Dunno if that's eye-watering or not.

Seems to have changed pricing a bit since. The 'pay as you go' model now has 2500 API calls/day for free, and $1/2000 API calls after that. My needs never grew in to needing much more than what we hit for that $5/month, so I can't vouch for their service at a large scale, but I enjoyed using it.

No affiliation just a happy former customer.

ChrisMarshallNY

Well the model that I would use, would be about 20,000 or so lookups, every 4 hours.

Might add up.

akhenakh

Look at this library embedding the TZ data, implemented in multiple languages, even providing an HTTP server https://github.com/ringsaturn/tzf

OsrsNeedsf2P

I recently had this issue with an Android app I made, it was surprisingly difficult to resolve. I ended up going with some OpenStreetMap mirror endpoint for my solution

ChrisMarshallNY

Well, I looked at all kinds of “clever” approaches, and kept coming back to needing to use a map.

I found a project that is under active development, that generates a very precise shapefile, and figured out how to use it.

I load a database, as opposed to doing shapefile parsing on the fly, for performance reasons.

The magic juice is the domain rect. It’s a superfast triage, that gets us into the ballpark, and then I use a fast winding number test, to get precise.

I think that I could probably do a whole lot to optimize it, but PHP/SQL is not my forte, so I kept it simple. It works great for the manner in which I use it.

The unit tests have a lot of points, close together, on either side of a TZ boundary. The edges are where the Devil lives.

cyberax

Super nice! I wanted to do an Arduino-based GPS clock that always shows the correct local time, but got bogged down getting the exact timezone boundaries.

Thanks for bringing up https://github.com/evansiroky/timezone-boundary-builder !

ChrisMarshallNY

It's a great project. If you are involved, you have my thanks (also, the thanks of a lot of people that have no idea it exists).