Qipudata
San Francisco · v0.7.1
qipu data›San Francisco›Documentation›Check a line against its page

Check a line against its page

Every row points to a printed page. Before you quote a decision, open the page and read it there. It takes a minute.

On this site

  • Open the decision's record page (from search, a place page, or record/?id=).
  • Under the summary, "From the page" shows the printed lines we read it from (records before 1951).
  • "The printed page on the Internet Archive" opens the scan at that page. Find the quoted heading; the item is the paragraph under it.

From the data

source_url is the archive.org viewer page. quote is the start of the printed text. Search the page for the first words of the quote:

SELECT decision_id, quote, source_url
FROM 'https://tiles.qipu.org/data/releases/v0.7.1/parquet/decisions.parquet'
WHERE decision_id = 'qipu:sf/decision/journalofproceed1912sanfrich:66/2'

The page image itself can be fetched through archive.org's IIIF service. The viewer counts pages from 0 (/page/n66) and IIIF from 1, so viewer page n66 is image $67:

https://iiif.archive.org/iiif/journalofproceed1912sanfrich$67/full/1200,/0/default.jpg

What to look for

  • The outcome. "Passed for printing" is a first reading, not a law. Check that the item was "finally passed".
  • The number. In rows from the older reading passes, an ordinance number can belong to the neighbouring item (see Accuracy).
  • The date. If the row has none, the meeting heading is on an earlier page; turn back until you reach "MONDAY, …".
  • The summary. It is written by a model. The print is the record.

When the page doesn't match

If the page says something else, or the item isn't there, tell us through Corrections and takedown with the decision_id and what the page shows. Corrections go into their own table and never overwrite the original reading.