Jump to content

 
Photo

Join Attributes without Corresponding IDs

- - - - -

  • Please log in to reply
3 replies to this topic

#1
aft19

aft19

    Newbie

  • New Member
  • Pip
  • 1 posts
  • United States

Hello,

I believe my question is fairly simple, however I cannot figure out how to get it done. I have four layers:

- DOD (Department of Defense) Lands
- Area covered by USGS LiDAR
- Area covered by NCALM LiDAR
- Area covered by NOAA LiDAR

My goal is simply to append to the DOD attribute table whether it falls within USGS, NCALM, or NOAA range, or multiple. Also, within the attribute table for USGS, NCALM, and NOAA, it indicates the name of the .las file by which LiDAR is downloaded, I would like to add that field as well. I do not have any corresponding ID fields by which to join.

So, for example, let's say I have a military base in North Carolina; the entire state of NC is covered by USGS data, so I simply want all DOD polygons within NC to have "USGS" in the new field, "Agency." Also, let's say the file name is "PJCT_NAME NC_Phase2_2003", I would like a field that indicates that as well.

If you have any suggestions I would be greatly appreciative.

Thanks

#2
dsl

dsl

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 225 posts
  • Gender:Male
  • Location:Denver
  • United States

If you are using ArcGIS, you might look into using a spatial join. You might also just do an intersect which should carry over any of the attributes from one layer to another...but it will probably get messy.

Hope that helps,
David

#3
katzmoye

katzmoye

    Contributor

  • Validated Member
  • PipPip
  • 14 posts
  • Gender:Female
  • Location:Portland, OR
  • United States

Are you using ArcGIS? Why not select by location and then calc the field? As for recording the file name why not create a Source field and calc that as well?

#4
jrat

jrat

    Master Contributor

  • Validated Member
  • PipPipPipPip
  • 143 posts
  • Gender:Male
  • Location:Hagerstown, MD
  • United States

I also would suggest a spatial join




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

-->