Reading San Francisco Complaint Files by Violation Item

A San Francisco housing complaint can produce several records without representing several separate complaints. That distinction matters when a renter reviews a building, an owner follows an inspection, or a buyer asks about unresolved work. Counting every search result as a new incident can exaggerate a history. Reading only a complaint summary can also hide the individual conditions an inspector recorded.

The useful question is therefore more precise than whether a building has complaints. Ask which complaint the record belongs to, which specific item it describes, and what later evidence addresses that item. This guide explains a document review method. It does not rate a property, establish present conditions, or replace an inspection of the actual home.

Start with the correct record relationship

San Francisco publishes a Department of Building Inspection dataset for Notices of Violation. Its documentation explains that the records describe violations and inspector comments from inspections. It recommends sorting by Complaint Number and Item Sequence Number and connecting the results with the Building Complaints dataset. Those instructions are important because the dataset contains items within complaints, rather than a simple list of unrelated building problems.

The accompanying data dictionary defines Complaint Number as the complaint identifier. Item Sequence Number orders items within that complaint. Preserve both fields in your notes. An address is useful for finding a possible match, but it is not an adequate substitute for these identifiers when discussing a particular record with the department or property representative.

Imagine a fictional complaint containing three listed conditions. A downloaded view might show three rows bearing the same complaint number and different sequence numbers. A second complaint might contain one row. That creates four item rows across two complaints. Reporting four complaints would misdescribe the file. Reporting two conditions would be equally misleading. State which unit you counted and why it matters to your question.

Establish the address before interpreting the history

Write the street address as it appears in the document, including any unit or location description. Also retain the block information when the record supplies it. Compare these details with the building you are researching. A record describing a common stair, another apartment, or an adjacent building may be relevant in different ways, but those differences should remain visible.

Do not silently change an address to make it match your search. If a property uses more than one street entrance, record the alternate address as an unresolved identity question. Ask the department or property representative whether the records refer to the same building. An apparent match based only on a familiar street number is not strong enough to support a confident statement about a specific apartment.

For a rental decision, separate buildingwide conditions from conditions documented in the offered unit. A common exit concern may affect the route from several apartments. A condition recorded inside one apartment does not establish that the same condition exists in every apartment. Conversely, a different unit number does not make all common area information irrelevant. Read the location description before deciding what to ask next.

Build a complaint and item worksheet

Use one worksheet line for each item you actually review. Suggested columns are complaint number, item sequence, address, location within the property, document date, recorded condition, later document, and remaining question. The final column is particularly useful because it prevents the worksheet from becoming a collection of copied allegations without an explanation of their significance.

Keep the wording of a short condition description faithful to the source, or clearly label your own paraphrase. Do not rewrite a technical observation as a broader conclusion such as unsafe building or fully repaired building. When terminology is unclear, copy the relevant field into a question for the responsible office instead of substituting an interpretation that sounds more certain.

A second worksheet can summarize each complaint as a whole. It should reference the item worksheet rather than replace it. This gives you both views: how many distinct complaints you identified and how many individual items you examined. It also makes later updates easier because a new document may address only part of an existing complaint.

Read dates as a sequence of events

A filing date, inspection date, notice date, and later status date can describe different events. Write each date beside its own label. Sorting all dates into one column called problem date can obscure whether a document records an allegation, an inspector observation, or subsequent administrative activity. If a field lacks a clear definition, retain its original label and ask what it means.

Build a short timeline for the complaint you care about. Start with the earliest relevant document you have, then add subsequent documents in order. Note gaps without filling them through assumption. A long gap between two visible entries does not prove nothing happened. It establishes that your current collection does not explain the interval.

Download or save the records you relied on where the service permits it, and note when you viewed them. A later reader should be able to distinguish the date of your research from the date of the underlying event. Avoid presenting an old notice as a current observation merely because you found it today. Equally, avoid treating an old record as irrelevant without checking whether later information resolves your concern.

Connect repair claims to the actual item

A statement that work was completed becomes more useful when it identifies the complaint and condition involved. Ask a property representative which document supports the statement and whether it concerns all listed items or only selected ones. An invoice, photograph, permit entry, inspection note, and case status can answer different questions. Their existence does not make them interchangeable.

For example, a fictional owner supplies a receipt for replacing a window. The complaint also contains separate items concerning a common corridor and a bathroom condition. The receipt may help explain the window work, but it does not address the other two items. Your notes should say which item the receipt appears to concern and which questions remain unanswered.

Do not turn this comparison into a private determination that a violation has legally been cleared. Ask the responsible department what official record establishes the present status when that status matters to your decision. A useful request is specific: identify the complaint number, list the item sequence numbers, and ask where to find the latest action addressing them.

Use the right city service for the question

San Francisco's guidance on substandard living conditions directs residents to Housing Inspection Services within the Department of Building Inspection. It also describes community partners that can help residents understand reporting and communicate about housing conditions. Those services are a better starting point for an inspection question than a general interpretation of a property advertisement.

The city's repair guidance distinguishes the Rent Board's role from a city inspector's role. That distinction matters when someone expects a record search to produce a repair order or a rent adjustment automatically. State the outcome you need when contacting an office. Asking how to interpret an inspection entry is different from seeking help about a repair problem or a separate tenancy dispute.

For a new report, describe the condition and location plainly and retain your submission details. For an existing file, lead with the complaint identifier. Avoid sending a large folder without explaining the exact issue. A concise question linked to one or two relevant entries is easier to answer than an unsupported claim that the entire building history is contradictory.

A fictional review from start to finish

Suppose a prospective renter finds a complaint with item sequences one, two, and three. The offered apartment is on the second floor. Item one describes a common area, while the other items identify locations that the renter cannot confidently connect with the offered unit. The renter records all three rows under the same complaint number and flags the location uncertainty.

The property representative replies that the matter was handled and sends a work receipt. The renter matches the receipt description to item two, marks the relationship as provisional, and requests the later departmental entry. The renter also asks whether item one concerns the common route used by the offered apartment. None of these steps requires assuming the property is satisfactory or unsatisfactory before the documents are understood.

A later record explains action on two items but leaves the third unclear to the renter. The final research note therefore says that three items were reviewed, later information was found for two, and clarification is still needed for one. That is more accurate than saying the complaint is resolved, and more useful than repeating the original notice without acknowledging subsequent information.

Keep the final conclusion proportional

End your review with a small set of supported statements: the address searched, the complaint identifiers examined, the number of item rows reviewed, the later records found, and the questions still open. If you searched only selected records, say so. Do not label the result a complete building history unless the scope and coverage genuinely support that description.

A missing search result should be described as a missing result in the service and search you used. It does not certify present housing conditions. A visible record should likewise be described within its actual date, location, and document type. This restrained approach makes your findings usable by a renter, owner, adviser, or inspector without overstating what the public file proves.

The practical deliverable is a traceable set of questions, not a score built from raw row counts. By keeping complaint identifiers, item sequences, locations, and later documents together, you can explain precisely what needs clarification and avoid confusing a detailed inspection record with a larger number of independent cases.

Sources