SQL
Import census TIGER/LINE into MS SQL Server 2005
The first step to improving routing methods is to mimic current routing methods. To do this, i took the free US Census TIGER/LINE data from the Census website and imported it into a SQL Server 2005 database. The Census Bureau provides map data to the public free of charge. the files are text files and are difficult to use in their current state. We'll import them into a database and work with them a bit.
- Read more
- 2047 reads
TrafficMan
Updates
4/1/2008 - Calculate Route, Priority Queues
3/31/2008 - Importing TIGER data, find intersections, find road segments, distance stored procedure, speeds, distance/speed data
TrafficMan is a project to incorporate real and real-time traffic data into the algorithms used to calculate routes and travel times. Often I wonder if taking the highway or a back-road is the fastest route; now I will in corporate real traffic and travel times into the equations
- Read more
- 1388 reads
