We have a dataset with a personal GDB (mdb) with several feature classes and an mxd tied to those features to create layers based on definition queries…
Currently to QAQC our data we use MsAccess queries to cross check data both within a feature class table and across feature classes that have common ID’s…
This is building space data, so things we check are a field that marks the space vacant [sp_vacant ] and another field within the same feature class that marks the space classification (hallway, stair, office, etc [sp_type])… Since we do not want to mark public areas as vacant the query checks any vacant values against the space type to get a list of possible errors…
Another type of MSAccess query we run would be to check personnel recorded for that building [sp_person] in one feature class against a matching field [sp_type] from the other feature class where both features contain matching room ID’s [sp_ID]…
To do the previous we build queries in Access, export those tables in Excel and use them as a checklist to edit possible mistakes. I then have to go back in Access once edits are made to re run the queries to check for completeness.
Rather than all that I would like to create, run and view the same type of queries in ArcMap rather than using MsAccess.
Or perhaps getting an editable layer with attributes that I can change directly and those changes will propagate to the original feature class data.
So a table or preferably layer that responds to a sql like query.
