AnsweredAssumed Answered

How to join a spatail data with a non-spatial data set?

Question asked by taejnkwon on Feb 4, 2015
Latest reply on Feb 6, 2015 by rfairhur24

Hello,

 

I have a shape file that contains a total of 479 polylines and each line is associated with SiteID as shown below.

patrol_routes.PNG

I have another data that contains more than 88000 rows of data, each row contains various measurements along with "SiteID" (first column in the figure below). And of course there are many rows having identical SiteID.

data.PNG

What I'd like to do is to join this data with 479 polylines by matching the SIteID so that each data entry can be shown on the map as a line containing many rows of information many the same SiteID. I used join function but it didn't work.

Any suggestion is greatly appreciated!!

Thanks!

Outcomes