Tagged Questions

1
vote
1answer
44 views

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. ...
3
votes
1answer
134 views

Using PostGIS for a large trajectory dataset

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 ...