I have a data set (more than 50,000+) of points (addresses) and Polyline (street) shapefiles of the area of interest. The street shapefile contains Annual Daily Traffic (ADT) data of each street for a long time period (1990 - 2010) for example: 1990, 1995, 2000, 2005 and so on.
I need to select streets within 30m buffer based on address locations with highest Annual Daily Traffic (ADT). Considering the complex scenario of streets (depicted by two examples below), the closest road to the address location can be a minor road or a major road but it must contain highest ADT value. If condition is met withing 30 m with highest ADT, then I need to shift my point feature to that street location otherwise the buffer is increased to 50m. This whole process needs to be iterated for all address locations (point features)enter image description here
I am looking for some advice so that I may come to know about a suitable tool i.e., Python, PostgreSQL and PostGIS etc. because ArcGIS model builder took a lot of time for this task. Any advice for using PostGIS spatial queries for this task or integrating Python with PostGIS would be more suitable?