wesley.king

Exporting data from a shapefile into 2 related tables

Discussion created by wesley.king on Jul 16, 2013
Latest reply on Jul 16, 2013 by stacyrendall
Hi Everyone,
I'm trying to find a solution to a new issue we now have since converting our tables to SDSFIE 3.0 Gold standards.  Basically, the issue is that all feature classes that we once had are now split up into 2 related tables (base table with geometry and ancillary table with attributes).  In this case the relationship is 1:1.

We get data deliveries in spreadsheets and/or shapefiles and now need to output the geometries to the base table and the attributes to the ancillary table.  Entering one-by-one would be ridiculously time consuming and not an option (create base table record, create corresponding ancillary table record, enter attributes).  I cannot find a good way to do this and was hoping someone in the scripting community may have already done this.

Does anyone know of a script that can accomplish this, or have any recommendations or advice.  Advanced warning...I do not have extensive knowledge or understanding in this area, but have a co-worker who would help.

Thank you,
Wes

Outcomes