Chapter 5: SQL for Geodata
Business intelligence and data analysis commonly include the calculation of distances and related parameters such as time or costs. In addition to these basic calculations, you might need to calculate the shortest, fastest, or even cheapest distance. Logistics companies calculate delivery routes where a driver does not have to change lanes while driving, always can exit the vehicle on the sidewalk, and deliver as much general cargo as possible with as little fuel as possible. More sophisticated analyses using GIS systems are easily able to take into account numerous other parameters such as the time of day and the usual traffic volume, maximum permitted speeds, slopes and differences in altitude, as well as weather ...
Get Advanced SQL with SAS now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.