1 / 19

Mt. Hope Cemetery Stone Inventory

This project documents and captures the condition of the historic African American Mt. Hope Cemetery in South Raleigh to preserve its history. Data collection and delivery will be completed in 6 weeks using Collector for ArcGIS and Microsoft Access.

thomast
Download Presentation

Mt. Hope Cemetery Stone Inventory

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Mt. Hope CemeteryStone Inventory Eric Wilson, Tom McKay and Bethany Williams

  2. Where and Why • Mt. Hope Cemetery • Historic African American Cemetery • Where is Mt Hope? • South Raleigh • Fayetteville and Prospect Ave • Why collect the data now? • Many headstones are concrete or wood and are degrading • Recent tornado created a need to capture the “as is” state of the stones

  3. Who • Client • Raleigh City Cemeteries Preservation Inc. • City Cemetery • Mt. Hope Cemetery • O’Rorke Cemetery • Timeframe • 6 Weeks for data collection and delivery • Staff • 1 Intern • 1 Analyst • 1 Project Manager

  4. What we used • Software • Collector for ArcGIS • Field work • AGOL • Repository • ArcGIS Desktop • Data cleanup • Microsoft Access • Merging data after collection • Final Delivery • Reporting

  5. Hardware Used • GPS – Trimble Geo 7x • Tablet – Samsung Tab Pro T320

  6. In the end… • What was captured? • Location • Accuracy (60cm, sub-meter) • Capture method • Photos • Quality • Attributes • Inscription • Scouted ahead and designed GDB to reflect most efficient data entry • Post processed additions • Photo rotation • Spatial join on historical zones • Historical registry number • New grid number

  7. In the end… • How did we check it? • For each photo… • Name and Inscription verification • Rotation verified • Location verified • What is the final product? • ArcGIS Online Map • Web App Builder • Microsoft Access Database • Searchable form and report • File Geodatabase • Photos as files (jpg, png etc.) not included

  8. Opportunities for the data • Encourage Conservation • Historic Preservation • Search • Genealogy http://naldzgraphics.net/freebies/search-box-psd-download/ http://www.pixbam.com/genealogy

  9. Comparison between City Cemetery and Mt. Hope Cemetery

  10. Comparison between City Cemetery and Mt. Hope Cemetery

  11. Comparison between City Cemetery and Mt. Hope Cemetery Spanish Flu Polio Peak Civil War

  12. Comparison between City Cemetery and Mt. Hope Cemetery

  13. Comparison - Columbia, SC • Most affluent buried in Trinity Episcopal Cemetery

  14. Challenges • Project Planning • Device Selection • Collection Method • Site • Data Collection • Powerless Power Packs • Review Pilot Data Process • Scheduling • Battery • Weather

  15. Create Services (Desktop) Planned Workflow

  16. Challenges cont. • Data Assembly • Sync • Stopped working  • Upload not Download failures • Collector still was able to collect not return data to AGOL • We suspect Attachments were the problems (File Size) • Download each day directly from the machine • Merging • Develop custom process outside of normal ESRI Kool-Aid process • Used MS Access • Avoid GlobalID Locks maintained in File GDB • Additional QA/QC • Non-spatial checks • Duplicate entry • Duplicate photos • Final Construction • Microsoft Access saved the day again

  17. Actual Workflow Create Services (Desktop)

  18. Delivery and Deployment Demo • ArcGIS Online Web Map • Online Access to Photos and Location • Searchable • Microsoft Access Database • Custom Report • Photos embedded in report

  19. Collector for the future • Subsurface Utility Engineering • Survey • Geospatial • Stay away from attachments if possible

More Related