Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Ok, so I 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 this isn't entirely clear, let me know! THANKS!

IF NOT: This 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? THANKS AGAIN!

share|improve this question

1 Answer 1

Take a look at Query Layers.

  • Load your parcel boundary layer into ArcMap
  • Pull the information you require from your back-end Sharepoint into a stand-alone table in ArcMap (including the ID field that joins it to the Parcel)
  • Make a join between from the parcel layer to the query layer.
  • I believe that this link should now be dynamic and will pull the data directly from the db behind Sharepoint.

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?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.