So i downloaded the ESRI NA all roads data and have selected and am working with only a few counties in my area which I wanted to create a network dataset on. The attributes it contains are great and will be perfect for my usage, but at first glance and investigation I can see some streets (in-particular main highways and interstates) that have sections missing. Some areas where it is just multiple links and the road picks up again. I have my county data with all streets that seems to have it right, but the ESRI data within is much much better. This is going to be saved onto a university database for class purposes, so I would like to make sure the connections are made. What would work best to keep the ESRI data but have the connections made: simple spatial join? Append?