[Bug: Priority]: Export of CBBR Data does not have facility or address information

[mbh329]

What happened? What did you expect to happen?

Example of an issue with the CBBR data when exported from CPP with Tracking ID: 109202612C

1. Issue is replicable on Safari and MS Edge web browsers
2. Filter to a specific community board CBBR data and export the data, no location information is available in the columns
3. Issue persists when not filtering and downloading the data, no location information is populated

Link to CPP

Tracking Number	Community Board Number	Address	Site or Facility Name	Street Segment - On Street	Street Segment - Cross Street 1	Street Segment - Cross Street 2	Intersection - Street 1	Intersection - Street 2	Type	Is Continued Support	CB Request	CB Explanation	Agency Acronym	Priority	Agency Response	Agency Response Explanation
109202612C	BX09								C	FALSE	Create a new, or renovate or upgrade an existing public library	$725,000 ADA elevator: this 1985 branch will replace the current outdated elevator and sure it is compliant with ADA regulations.    $1,700,000 boiler: this project will replace the current boiler with an energy efficient model this will make the building more energy-efficient by reducing energy consumption and greenhouse gas in missions. A new boiler will ensure that the library is adequate heated during the colder months. HVAC. This project will replace the HVAC system of energy efficient model. This is an existing project I need supplemental funding. NY PL branches are designated NYC office of emergency management cooling centers. They provide cool and safe environment for patrons and community members. During periods of extensive heat	NYPL	12	The agency does not understand the request as written and requires more clarification.	This request includes multiple locations and projects. Clarification is needed for the locations.

What browsers are you seeing the problem on?

Safari, Edge

Which operating system are you using?

Max + Windows

[TangoYankee]

Looking into this, "109202612C" has location information in the source data for "site name". However, values of the other location fields are blank in the source data; it is expected that they would be blank in the data export. It is also common for projects to have only one location field populated.

The example of "109202612C" does demonstrate that there is an issue with the "site name" field. However, it doesn't demonstrate that it's all location fields. @mbh329, are there examples of projects where other location fields have values in the source data but are not included in the export? Ie) A project that has an "address" in the source data but not in the export?

[mbh329]

@TangoYankee I will look and get back to you!

[mbh329]

@TangoYankee I just went through the steps to export the CBBR data on my safari browser and did not have an issue with the facility and/or location data so not sure what is going on exactly. See below for example of the most recent export where the parkchester library appears as the facility site and other location information is also populated

[TangoYankee]

Interesting! I appreciate the extra investigation. I'll bring this up in sprint planning