What is the best way to construct a SQL query that returns the block name for each bus point as it travels?
I have two datasets in postgres; 1) a bunch of points that represent bus locations 2) city block polygons. Each bus has a unique ID and each block polygon has a field that has the block name in it. ...
I have a spatial trajectory dataset which basically contains about 10E6 (lat,lon,time)-tuples, grouped together by an identifier so they form trajectories. Currently, SQLite is used to store the raw ...