Link incidents to corresponding TMC

CityofToronto / bdit_incidents

Analyzing impacts of traffic incidents on road congestion

2 stars 0 forks source link

Closed dolejarz closed 7 years ago

radumas commented 7 years ago

[x] ensure checking for incident & TMC direction (note peculiarities of TMC directions...)
[x] Use PostGIS's K-Nearest Neighbour search like this?

radumas commented 7 years ago

Rough PostgreSQL outline

CREATE OR REPLACE FUNCTION match_tmc(point GEOMETRY, OUT tmc char(9), OUT tmc_distance float)

And then usage like (may not work)


FROM incidents``` 

Or [like this](http://gis.stackexchange.com/a/144230/36886)