440 likes | 453 Views
Learn about the development of a web-based database for the California Historical Resources Inventory, offering comprehensive tools for managing and integrating historical resource data.
E N D
CHRID Workshop Marie Nelson, OHP Survey CoordinatorCathy Wahlstrom, City of OntarioDiane Ayala, City of OntarioMark Kruger, President CFWebtools
CHRID • California • Historical • Resources • Inventory • Database
HRI Database Development • Many local government and consultant efforts • City of Riverside APA Award (2001) • Ontario customized Riverside’s database • Platform from SQL to Oracle (2003)
CalCRDCalifornia Cultural Resources Database • Access database Oracle • Generic, comprehensive CLG capabilities • DPR, National Register, Mills Act, Sec. 106, Design Review, Local Designation, Training, Staff, Commission, Architectural Checklist • CalCRD revolutionized HRI data management • Access platform inflexible, limited navigation, not stable for growing data and future integration
Web-based • 2004 Sacramento and Ontario CLG grant • Transform CalCRD from Access database to Web-based application SQL • Stable, flexible, expandable, integratable • Easier to share data • Accessable with remote internet access
Resource-driven • Enter base information once • Populates in other forms
http://chris.cfwebtools.com • Test site • Test data Hosted by CFWebtools, Nebraska
Training Exercises • Public search, view, print application • Administrative application • Search capabilities • Add new resource • Forms • Initialize government application • Approval functions • Security functions
Front Page • Designed as public interface • Disclaimer, links to ICs, OHP, NAHC • Acknowledgements with link to NPS
Public Search Site Search by: • Property • District No access to: • Property owner info • Archeological data
1920 + or - 5 Tracks queries 112 W. B Street
Click “Primary Record” • Click “Print” • Click “Print” again
DPR 523A PDF • Close window
Click “Admin” • Login “administrator” • Password “rosebud” Thumbnail preview
Administrative Functions • Use Staff Data to enter staff names, training • UseUtilities to add local designation, contexts, surveys • UseAccount to change password • UseSecurity to manage permissions for users and groups • UseResources to add, search, approve, submit DPR forms
Search by: Property District Mills Act Section 106
Mills Act Automatic forms, formulas • Click “Search” • Property address • Enter “203”
Functions • View • Print • Edit • Add new item (Mills Act)
Automatic Formulation Resource is always identified Click here for automation
The Resource Wizard Enter new resource
Getting Started Staff Data • customize for jurisdiction
Data Approval Data Waiting Approval Approved Admin Pending Submission
Create a User • Add new • Update
Next Phase • GIS Component • GIS Planning • Map query results • Enhancements • CFWebtools • Field templates, disconnected user tool • Advisory Committee • Graphic, navigation, enhancements • Support OHP data/GIS integration
Online Help Files • Online Forum • Downloads • Support options • Register user • Register site www.chridnet.com
Support tools • Support options
Technical Support Mark Kruger, President CFWebtools Omaha, Nebraska • Developed CHRID Web application • Developed CHRID support site
What Will Change? • Web Based Means… • Enter Data Directly • Create a File for uploading • Data will automatically be “in synch” • You may need to support a web server
Can We Host it Ourselves? • Web Server – Win2k or 2003 (Linux is also possible) • Coldfusion 7 license (A Java Based App Server) • Database Server – • MS SQL (Possibly other options) • MSDE or SQL Express (limits connections and size, but works well) • File Storage to Support Your Images and Maps • Security – firewall, backups redundancy, etc. If you have a self-hosted web site or sites you may already be in a position to host it yourself at minimal cost • Expertise in SQL and Web Servers is required.
Do We Have Other Options? • Hosted Solution • Leased Solution • Deployment Only • Dedicated Server Option
Where Do I Find Help? • CHRIDNET.COM • Online Forum for user supported help • Developers Blog for tricks on non-standard deployments • Online Help files • Email support@chridnet.com or chridsupport@cfwebtools.com
Online Help Files • Online Forum • Downloads • Support options • Register user • Register site www.chridnet.com