Tree Management Database SOW.pdf

Pacific District (775) Project No.: 775-M&R-FY24-029

Tree Management Database Subscription 12/21/2023

I. PART I - THE SCHEDULE

BACKGROUND

The Department of Veterans Affairs, National Cemetery Administration – Pacific District contracted with Davey Resource Group (DRG) to provide tree inventories and assessments at the Fourteen (14) National Cemeteries listed below. The data from these inventories and assessments was made available to the Government through an online tree management database subscription service known as Davey TreeKeeper (DTK). The database was also delivered to the Government in the form of a Microsoft Excel file which contained a minimum of 24 separate datasets about each tree that was inventoried. (See

Attachment ‘A’ for a full list of datasets.)

PERFORMANCE WORK STATEMENT

Provide all labor, materials, equipment, tools, intellectual property and supplies to provide online tree management software subscription to include locations for thirty (30)

Cemeteries in the National Cemetery Administration. Import existing databases for the following fourteen (14) cemeteries from Government-provided .xls files:

1. Golden Gate National Cemetery, San Bruno, California

2. Los Angeles National Cemetery, Los Angeles, California

3. Fort Rosecrans National Cemetery, San Diego, California

4. Riverside National Cemetery, Riverside, California

5. Sacramento Valley National Cemetery, Dixon, California

6. San Francisco National Cemetery, San Francisco, California

7. San Joaquin Valley National Cemetery, Santa Nella, California

8. Eagle Point National Cemetery, Eagle Point, Oregon

9. Willamette National Cemetery, Portland, Oregon

10. Tahoma National Cemetery, Tahoma, Washington

11. National Memorial Cemetery of Arizona, Phoenix, Arizona

12. Prescott National Cemetery, Prescott, Arizona

13. Santa Fe National Cemetery, Santa Fe, New Mexico

14. National Memorial Cemetery of the Pacific, Honolulu, Hawaii

TREE INVENTORY MANAGEMENT DATABASE, MAP FILES and TRAINING:

The Management Database shall have the capability to: prioritize track and schedule maintenance; prepare and justify budgets, track and respond to inquiries; allow the user to add new tree site information; allow the user to log and track work on specific trees;

allow the user to query specific trees by cemetery section and headstone name or number;

allow the user to query trees by genus and species; allow the user to generate and print reports based on tree frequency, work frequency, site information; and will allow users to display cemetery tree inventories on GIS base maps on the same screen as the management database system, and, be fully compatible with and able to directly import inventory data already gathered at fourteen (14) Pacific District cemeteries.

In addition to the 14 cemeteries that have previously established databases, the

Management Database shall also be setup to include the remaining sixteen (16)

Cemeteries in the Pacific District that do not currently have tree inventories and assessments. All 30 cemeteries must be visible on the landing page for Pacific District cemeteries. Where available survey files defining the property limits of the cemeteries will be provided to the vendor awarded the contract. Where no surveys are available the base maps shall conform closely to commercially available aerial views from Google

Maps or similar map imagery. These databases shall be established with GIS base maps for each cemetery capable of being accessed within the online management database to which existing tree locations and all other data point information can be manually added by the Government and Government contractors. These additional sixteen cemeteries are:

1. Alameda Point National Cemetery, Alameda, California

2. Albuquerque National Cemetery, Albuquerque, New Mexico

3. Bakersfield National Cemetery, Arvin, California

4. Benicia Arsenal Post Cemetery, Benicia, California

5. Elko National Cemetery, Elko, Nevada

6. Fort Bayard National Cemetery, Fort Bayard, New Mexico

7. Fort Lawton Post Cemetery, Seattle, Washington

8. Fort Richardson National Cemetery, Fort Richardson, Alaska

9. Fort Stevens National Cemetery, Hammond, Oregon

10. Fort Worden Post Cemetery, Port Townsend, Washington

11. Mare Island Naval Cemetery, Mare Island, California

12. Miramar National Cemetery, San Diego, California

13. Roseburg National Cemetery, Roseburg, Oregon

14. Sitka National Cemetery, Sitka, Alaska

15. Snake River Canyon National Cemetery, Buhl, Idaho

16. Vancouver Barracks National Cemetery, Vancouver, Washington

In addition, the Management Database shall have the following features:

1. Due to National Cemetery Administration (NCA) security restrictions, the database cannot be physically installed on NCA computers. Therefore, all inventory data shall be maintained offsite on the Contractor’s server and be fully accessible and capable of data manipulation by NCA users only through the internet.

2. The database must be accessible through the internet from the individual cemeteries, the Pacific District office, and Government contractors. The database must be accessible by more than 1 user at a time.

3. For budget and reporting purposes, the Pacific District tree inventory database administrator (Pacific District Agronomist) must be able to log in and query all individual cemetery databases simultaneously.

4. The Government’s Administrator must be able to assign read, write permissions for all users.

5. The database system must be GIS Capable or Non-GIS capable depending on the needs of the individual cemetery. The GIS maps must be viewable through the internet due to NCA computer security restrictions.

6. The database must be able to be exported as data files and shapefiles.

7. The database must be warranted, fully supported, backed up and protected by the

Contractor.

8. The program must be capable of generating user-friendly work orders.

9. The annual subscription cost must include a minimum of one (1) online remote live training session on request by the Government for all users, and unlimited access to online tutorials.