https://community.esri.com/t5/arcgis-pro-questions/merge-separate-information-datasets/m-p/1194110#M57529 <P>Hello Arc users,</P><P>I'm new to ArcGIS Pro, currently researching pedestrian vehicle incidents. The excel file that I have been using is of the incidents and provides information of the location (county, municipality, roadway, and lat &amp; log points). What it does not provide is the road classifications, which I have to download separately, and my question is how can I merge the two datasets so that each incident can be associated to a road classification? I'm not sure whether this process should be done in Excel or ArcGIS but perhaps it would be better off in Excel since I intend to create statistical infographics with the information.</P><P>My research is on Georgia and I'm having trouble finding a dataset that provides all road classifications, I've only found files that include city owned public streets or state-owned highways separately.</P> Wed, 20 Jul 2022 19:05:58 GMT ItsAnt 2022-07-20T19:05:58Z https://community.esri.com/t5/arcgis-pro-questions/merge-separate-information-datasets/m-p/1194110#M57529 <P>Hello Arc users,</P><P>I'm new to ArcGIS Pro, currently researching pedestrian vehicle incidents. The excel file that I have been using is of the incidents and provides information of the location (county, municipality, roadway, and lat &amp; log points). What it does not provide is the road classifications, which I have to download separately, and my question is how can I merge the two datasets so that each incident can be associated to a road classification? I'm not sure whether this process should be done in Excel or ArcGIS but perhaps it would be better off in Excel since I intend to create statistical infographics with the information.</P><P>My research is on Georgia and I'm having trouble finding a dataset that provides all road classifications, I've only found files that include city owned public streets or state-owned highways separately.</P> Wed, 20 Jul 2022 19:05:58 GMT https://community.esri.com/t5/arcgis-pro-questions/merge-separate-information-datasets/m-p/1194110#M57529 ItsAnt 2022-07-20T19:05:58Z