roboticistmark/GovHack — pull request #2 by logworthy (2013-06-02 07:13:19+00:00)
Title: Create mesh block heat calculation

PostGIS SQL script to calculate number of trains, trams, buses near a mesh block.

/****
Dependencies:
mesh_blocks_vic - mesh block tables imported from abs
"sii:dps_932_rail_stations_vmt" - rail stations imported from ptv
"sii:dps_918_tram_stops_vicmap" - tram stops imported from ptv
"sii:dps_895_bus_stops_vicmap" - bus stops imported from ptv

Outputs:
mb_heat - mesh block data + tram, train, bus counts
*/