topic Re: adding data to related tables PrecinctPollingPlace in State & Local Government Questions

adding data to related tables PrecinctPollingPlace

PeterHoffman — Tue, 20 Aug 2013 16:46:39 GMT

I have followed the steps for using my own data and have loaded feature class PollingPlaces but I do not know how to load into the table PrecinctPollingPlace.

Re: adding data to related tables PrecinctPollingPlace

JackBeers_III — Thu, 22 Aug 2013 11:54:24 GMT

In the PollingPlace FC, I calculate the POLLINGID field as the VotingPrecinct FC's NAME field for which the Polling Place point resides. This is a 1-M relate so you can have more than one record with the same POLLINGID. You'll want to make sure the POLLINGID in the PollingPlace FC matches exactly with the VotingPrecinct FC's NAME field or the next step will not work. After you have calculated the PollingPlace FC you can load the records into the PrecinctPollingPlace table via ArcCatalog. Then in ArcMap, you can join this table with the VotingPrecinct FC via the matching join fields. Now you can calculate the PRECINCTID in the PrecinctPollingPlace table.

Clear as mud? Good Luck!

Re: adding data to related tables PrecinctPollingPlace

PeterHoffman — Fri, 23 Aug 2013 12:33:37 GMT

I was able to finally load data using arccatalog, still not working correctly.
I have a call into ESRI tech support, have not heard back yet.
Not sure why you had to use the calculate method.