each spatial GFT survey question should have a single flag

[damonmcc]

problem

Currently, we create a flag column for each dataset and some survey questions.

But GIS needs a single flag column and a single set of source geometry tables (e.g points, lots, buffers) for each spatial survey question.

The GFT tool will only show questions and their flag. Values which contributed to a flag will only been shown in the export table.

The exceptions to this 1-to-1 relationship are

• Project BBL: user enters this information, this isn't a flag we compute
• Project zoning: 3 questions about lots within a project, 1 column for a lot's zoning category

approach

We're using the GFT Data Review excel file to document two things:

• all survey questions
• the mappings of survey question to dataset(s)

These tables (especially the mappings table) can inform any changes DE has to make to the GFT build.

We've had the Data Source review excel file, but that table was used to track source data and doesn't represent the one-to-many relationship of survey question to source datasets

[damonmcc]

GIS diagram showing flow from GFT table made by DE to the app and to the two app outputs: Report PDF and Output CSV

[damonmcc]

will start using the list of survey questions to ensure we're generating a single flag for each one. this is not blocked by confirmation of the source data for each flag