The most consistent data was the first week so the dates of October 1st through October 7th  were selected. This had a total number of records of 1092. The number of unique detectors were 114. This data seems the most reliable to use and merge with the base map. Before we could merge the datasets the base map was first reduced to only the areas interested in. The base map has two columns indicating if either side is in a specific borough. Our target area for the data is Manhattan and thus other borough streets were removed. Also, only streets where motor vehicles could operate were selected. This reduced the number of road segments to about  23,000. Combining these two datasets we have 1309 rows that include 7 days of traffic count data and their locations. Traffic counts recorded within Manhattan are shown in Figure 3.