(评论)
(comments)

原始链接: https://news.ycombinator.com/item?id=43392521

OpenTimes是一个新的免费数据库,提供美国人口普查地理区域间的预计算出行时间。由dfsnow创建,它包含约1500亿个点到点的出行时间数据,填补了开源空间数据研究的空白。 该项目旨在通过提供替代Google和Esri等付费服务的方案,降低大规模可及性研究的成本和难度,例如用于量化医疗保健的可及性。 技术上,OpenTimes使用存储在R2上的静态Parquet文件,每月仅需10美元的费用。出行时间通过OSM、OSRM网络和分布式GitHub Actions作业计算得出。一个单一的DuckDB数据库文件,包含指向Parquet文件的视图,提供了SQL查询层。 目前,驾车时间较为乐观,因为它没有考虑交通状况。创建者希望将来改进这一点。用户正在请求更高的缩放级别以获取街道细节和搜索功能。


原文
Hacker News new | past | comments | ask | show | jobs | submit login
Show HN: OpenTimes – Free travel times between U.S. Census geographies (opentimes.org)
8 points by dfsnow 18 minutes ago | hide | past | favorite | 2 comments
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!











Looks cool. Please allow high max zoom levels, it’s hard to see individual street details on mobile.


PLEASE let me search






Join us for AI Startup School this June 16-17 in San Francisco!


Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact



Search:
联系我们 contact @ memedata.com