Section 1Feature run
06_build_rfi_features.py read data/processed/rfi_clean.csv and wrote data/processed/rfi_features.csv. The clean table was not changed. All 107 identifiers remain RFI-001 through RFI-107.
The new fields are derived. Where a question already names a discipline, that label is kept. Otherwise the opening of the question is matched to keywords. Drawing and specification flags come from the notes. A later model can replace these rules.
| Field | How it is set |
|---|---|
| discipline | Stated discipline in the question, otherwise keyword rules |
| issue_type | Keyword rules on the question |
| drawing_update_required | Yes, No, or Unknown from the notes |
| spec_update_required | Yes, No, or Unknown from the notes |
| document_update_required | Yes when either update flag is Yes; No when both are No; otherwise Unknown |
| question_word_count | Words in the question |
| response_word_count | Words in the response |
Section 2Discipline
Electrical is the largest group, with 40 of 107 RFIs. Twenty-four fall into Other, mostly contracting and solicitation questions that do not name an engineering discipline.
| Discipline | RFIs |
|---|---|
| Electrical | 40 |
| Other | 24 |
| General | 15 |
| Civil | 9 |
| Structural | 5 |
| Mechanical | 4 |
| Architectural | 3 |
| Quality / Inspection | 3 |
| Controls / SCADA | 2 |
| Cybersecurity | 2 |
Section 3Issue type
62 RFIs cite a specification section and are labelled Specification Clarification. Drawing Conflict is rare in this first pass: only two questions use conflict language the rules recognise.
| Issue type | RFIs |
|---|---|
| Specification Clarification | 62 |
| Compliance Requirement | 11 |
| Missing Information | 11 |
| Design Clarification | 6 |
| Inspection / Quality | 6 |
| Material Requirement | 4 |
| Interface Coordination | 3 |
| Drawing Conflict | 2 |
| Constructability | 1 |
| Scope Gap | 1 |
Section 4Document updates
51 notes say no specification or drawing update is required. Those rows are No on all three flags. A note that a specification or drawing was updated is Yes. A blank note, or a note that only says an attachment was sent, stays Unknown.
| Flag | Yes | No | Unknown |
|---|---|---|---|
| Drawing update required | 18 | 51 | 38 |
| Spec update required | 17 | 51 | 39 |
| Document update required | 19 | 51 | 37 |
Document update is Yes for 19 RFIs: 16 notes update both the specification and the drawing, two update a drawing only, and one updates a specification only.
Section 5Word counts
Questions run from 9 to 335 words, with a median of 69. Responses run from 0 to 109 words, with a median of 16. Eight responses have no words, the same eight open RFIs.
Section 6First 10 feature rows
Question text is shortened here. The full text and the remaining rows are in rfi_features.csv.
| RFI | Discipline | Issue type | Document | Question words | Response words | Question |
|---|---|---|---|---|---|---|
| RFI-001 | Electrical | Material Requirement | Unknown | 49 | 68 | The specifications identify approved electric meter models for AMRS integration. Would the Government accept the… |
| RFI-002 | Electrical | Drawing Conflict | Yes | 108 | 21 | Battery Energy Storage System Capacity Discrepancy The solicitation appears to contain conflicting BESS sizing… |
| RFI-003 | Other | Compliance Requirement | Unknown | 52 | 69 | Applicable Davis-Bacon Wage Determination The solicitation references a wage determination associated with Burlington… |
| RFI-004 | Other | Design Clarification | Unknown | 37 | 5 | Site Walk Date Clarification The solicitation references a site visit as occurring on "Friday, 03 September 2026."… |
| RFI-005 | Controls / SCADA | Interface Coordination | No | 53 | 43 | Existing SCADA Integration Requirements The specifications reference integration between the new microgrid control… |
| RFI-006 | Cybersecurity | Compliance Requirement | No | 80 | 78 | Cybersecurity / RMF Requirements The specifications include multiple references to cybersecurity support and RMF… |
| RFI-007 | Other | Compliance Requirement | Unknown | 63 | 105 | CPARS and Past Performance Questionnaires (PPQs) The Supplementary Instructions to Bidders references Contractor… |
| RFI-008 | Architectural | Specification Clarification | Yes | 252 | 9 | Spec: 09 06 00 – Schedules for Finishes, 09 90 00 – Paints and Coatings Question: Paragraph 1.6.3 of Section 09 90 00… |
| RFI-009 | Quality / Inspection | Inspection / Quality | Unknown | 63 | 13 | Spec: 01 45 35 Special Inspections Question: Subpart 1.2 of Section 01 45 35 of the specifications states that the… |
| RFI-010 | Structural | Specification Clarification | No | 109 | 16 | 1. Discipline: Structural Sheet: S-501 Detail: K15 Spec: Question: On Sheet S-501 Detail K15 calls out a typical… |