TransWikia.com

Joining table to feature class AND matching fields using ArcMap

Geographic Information Systems Asked on February 25, 2021

I am digitizing points from pdfs and aerial imagery. Just points. Then I want to create lots of fields and populate them without resorting to FieldCalculator or arcpy.DA modules. There are too many fields and rows to add manually using FieldCalculator. So here are my first steps:

  1. create new feature class –> point
  2. manually add (digitize) 30-40 points

Then I need to populate all 30 rows with 10 fields worth of values. So I am separately filling out a csv with 30 rows to join to those points. For instance 30 features/points on new feature class gets 30 rows in a csv. The csv has 10 attribute fields and I fill out all the values for each of the 30 rows ON the CSV because it’s fast and easy. Next steps:
3. join the csv to the basically empty feature class
4. export the joined feature class

Then each week I digitize 40 new points in feature class and I need continue with the csv protocol and join. So I tried:
5. edit existing feature and digitize the 30 new points
6. create new csv with id_join field matching the objectid of 30 new points in feature class (31-60 for example).

My problem is, apparently there is no capability to essentially join WHILE mapping the attributes from csv to the feature class. For instance if field: num_people was created on first join and existed in feature class when second join occurs, I can’t join my batch with rows 31-60 containing the EXACT same fields and field names and populate those fields from 31-60. Brand new fields are created.

So it’s basically a join/append hybrid I am trying to achieve to allow a periodic update of growing feature class.

Does anybody have a workflow preferably using joins or other tools in ArcMap?

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP