The organization I am working for has a sharepoint database that multiple people update every time they do an inspection of natural resources on a parcel in the county.
This database has the following fields:
*Parcel Number
*Date
*Notes
*Inspector
*Action
I have created a feature class with a centroid with these attributes placed in each parcel that has been inspected.
Is there a way to dynamically link the sharepoint database to the geodatabase so that when they go in and change/add anything to the notes section it actively changes (and adds new points to newly listed parcels) the attributes in the featureclass?
If not, his layer only needs to be updated monthly. I am able to export it to a excel or csv file. Is there a quick way to create the centroids layer from this table?
Best Answer
Take a look at Query Layers.
Any attributes within the fields that you have pulled in from Sharepoint that get changed at the SP end, these should flow through to your MXD.
A less dynamic approach would be suck the data you want out of Sharepoint, into an XLS, and load the XLS into your MXD and then join your parcel layer to that.
You have not given any background into the bigger picture on what you are trying to achieve. You may want to take a look at ArcGIS for Sharepoint.
I might be missing something, but I do not see the need to calculate centroids everytime. Do the parcel boundaries change from month to month?