City of Roseville Parks Department Enterprise Asset Management Database Development

Roseville, California

Foothill Associates provided database modeling services in support of the City of Roseville’s development of an Enterprise Asset Management (EAM) database for the City’s park resources and golf courses. We conducted multiple modeling workshops with City maintenance staff to help them clarify the information needed to meet the City’s operations and management objectives. A draft logical data model was prepared and reviewed with City staff to get further input on specific attribute definitions, values, table relationships, data validation, and metadata requirements. The final geodatabase included complete feature classes, domains, and metadata.