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 made a site to quick identify any plant and learn how to care for it https://ift.tt/Lv1Sb3JShow HN: I made a site to quick identify any plant and learn how to ca… Read More
Show HN: I created a web app to encrypt/decrypt messages using Web Crypto API https://ift.tt/Jw0EY2MShow HN: I created a web app to encrypt/decrypt messages using Web Cry… Read More
Show HN: Create mind maps to learn new things using AI https://ift.tt/5HU8Wr4Show HN: Create mind maps to learn new things using AI Enter a topic a… Read More
Show HN: Semantic Macros Text Editor https://ift.tt/2zc604yShow HN: Semantic Macros Text Editor https://ift.tt/6Rt8jTv October 21… Read More
Show HN: Floating point arithmetic types in C++ for any size and any base https://ift.tt/F4Mpot6Show HN: Floating point arithmetic types in C++ for any size and any b… Read More
Show HN: Contagious Beliefs–Simulating Political Alignment https://ift.tt/OLhF2SNShow HN: Contagious Beliefs–Simulating Political Alignment This is a s… Read More
Show HN: Open-Source Zero-Shot Image Model Server Enabling Model Feedback https://ift.tt/wXRzblPShow HN: Open-Source Zero-Shot Image Model Server Enabling Model Feedb… Read More
Show HN: HN Update – Hourly News Broadcast of Top HN Stories https://ift.tt/gUyzWZuShow HN: HN Update – Hourly News Broadcast of Top HN Stories I feel li… Read More
0 Comments: