Show HN: OpenTimes – Free travel times between U.S. Census geographies Hi HN! Today I'm launching OpenTimes, a free database of roughly 150 billion pre-computed, point-to-point travel times between United States Census geographies. In addition to letting you visualize travel isochrones on the homepage, OpenTimes also lets you download massive amounts of travel time data for free and with no limits. The primary goal here is to enable research and fill a gap I noticed in the open-source spatial ecosystem. Researchers (social scientists, economists, etc.) use large travel time matrices to quantify things like access to healthcare, but they often end up paying Google or Esri for the necessary data. By pre-calculating times between commonly-used research geographies (i.e. Census) and then making those times easily accessible via SQL, I hope to make large-scale accessibility research cheaper and simpler. Some technical bits that may be of interest to HN folks: - The entire OpenTimes backend is just static Parquet files on R2. There's no RDBMS or running service. The whole thing costs about $10/month to host and is free to serve. - All travel times were calculated by pre-building the inputs (OSM, OSRM networks) and then distributing the compute over hundreds of GitHub Actions jobs. - The query/SQL layer uses a setup I haven't seen before: a single DuckDB database file with views that point to static Parquet files via HTTP. Finally, the driving times are optimistic since they don't (yet) account for traffic. This is something I hope to work on in the near future. Enjoy! https://opentimes.org March 18, 2025 at 02:10AM
Show HN: OpenTimes – Free travel times between U.S. Census geographies https://ift.tt/Evt4OZz
Related Articles
Show HN: I built a solcial-media-inspired fitness App https://ift.tt/ZFq9Jg2Show HN: I built a solcial-media-inspired fitness App Hi Hacker News! … Read More
Show HN: Plain Vanilla – a tutorial website for vanilla web development https://ift.tt/8I6OCgQShow HN: Plain Vanilla – a tutorial website for vanilla web developmen… Read More
Show HN: AI-Powered Stock Market Analyst with Global Coverage https://ift.tt/dZxvKQsShow HN: AI-Powered Stock Market Analyst with Global Coverage We’re th… Read More
Show HN: Open-source nextjs14 and Supabase and stripe and docs/blog template https://ift.tt/40X9PRKShow HN: Open-source nextjs14 and Supabase and stripe and docs/blog te… Read More
Show HN: Run Mutahunter.ai LLM powered software testing on your code in browser https://ift.tt/qVY2PeMShow HN: Run Mutahunter.ai LLM powered software testing on your code i… Read More
Show HN: Remix Gear and Next.js Gear – The cleanest way to start a project https://ift.tt/pqhw3aDShow HN: Remix Gear and Next.js Gear – The cleanest way to start a pro… Read More
Show HN: Rust Under the Hood – Explore Rust Through Assembly https://ift.tt/DMxHun7Show HN: Rust Under the Hood – Explore Rust Through Assembly I'm excit… Read More
Show HN: A singing synthesizer for the browser with algorithmic 3-part harmony https://ift.tt/sU8jbXQShow HN: A singing synthesizer for the browser with algorithmic 3-part… Read More
0 Comments: