Skip to content

Feature: repository search

Britta edited this page Mar 23, 2024 · 51 revisions

We need to show the following materials in our blended search results:

  • Regulations
  • Public policy documents that we link to:
    • Federal Register rules
    • Supplemental content: subregulatory guidance, technical assistance, etc.
  • Uploaded policy document files (internal to CMCS)

Each kind of material has slightly different fields, so the purpose of this page is to explicitly document how we want search to work.

Background info about technology

In our Postgres database we have:

  • The full text of regulation sections in scope, imported via eCFR API
  • Metadata about each document:
    • Imported via Federal Register API for post-1994 rules (and hand-corrected as needed)
    • Entered by hand for everything else
  • The full text of most documents, extracted via our Text Extractor Lambda function, which uses:
    • Google Magika to detect file types
    • AWS Textract to process PDFs, including text detection for scanned documents
    • A variety of open source libraries to process Outlook, Word, Excel, PowerPoint, RTF, TXT, HTML, image, and ZIP files

We have a special process for extracting the full text of post-1994 Federal Register rules, because their website does not allow scraping their web pages. We fetch their text-only URL via their API and extract from that URL instead of the normal web page.

We use Postgres full-text search via Django's support for Postgres full-text search.

Context about metadata

For team members, see "Structure and content of resources" (requires login).

Our metadata fields for FR docs, supplemental content, and uploaded files are shown here as they look on a subject page:

Screenshot 2023-12-18 at 5 05 43 PM

Search result display

Factors for what you can see:

  • Supplemental content and FR docs can be marked "approved" or not approved in the admin panel. Items that aren't approved are only visible in the admin panel (which is only available to logged-in users), never shown in search results or elsewhere on the site.
  • If you're not logged in, you cannot see internal documents (uploaded files) in search results or elsewhere on the site.

In search results, we always show the following document metadata if available:

  • Document category
  • Date
  • Subjects
  • Related citations

If the desired keyword(s) exist only in the document metadata (FR doc name or description, supplemental content name or description, uploaded file name or summary, etc.), show that document metadata. This means:

  • FR doc: name (grey metadata) and description (blue link)
  • Supplemental content: name (grey metadata) and description (blue link)
  • Uploaded files: name (blue link) and summary (black text)

If the desired keyword(s) also exist in the extracted document text, show the name and description (grey metadata and blue link) AND:

  • For all types of documents, show the relevant headline (excerpt) from the full-text content, in black text. (For uploaded files, this headline replaces the summary.)

Search result ranking

Team members can look at this doc for context about decisions we made for weights (login required).

Rank filtering

This environment variable tells our search system where to "cut off" the results: should it show lots of results, including less relevant results at the end, or should it only show fewer results that are most relevant? Lower numbers (like 0.01) mean show lots of results, and higher numbers (like 0.1) mean show fewer results.

Rank filter should be 0.05 in all environments, for both basic (not quoted) and phrase (quoted) search queries. The rank filter value for each environment is in our parameter store: BASIC_SEARCH_FILTER and QUOTED_SEARCH_FILTER.

Weights

Weights for documents:

  • (FR doc) name: A
  • (Supplemental content) name: A
  • (Uploaded file) name: A
  • (FR doc) description: A
  • (Supplemental content) description: A
  • (Uploaded file) summary: B
  • (Uploaded file) filename: C
  • Date: C
  • Subjects (full names, short names, and abbreviations): D
  • Content: D

We could add citations to the weighting list if we want to.

Weights for regulation text sections:

  • Section number: A
  • Section title: A
  • Part title: A
  • Content: B

We may be able to add the subpart title to the weighting list if we want to.

Overview

Data

Features

Decisions

User research

Usability studies

Design

Development

Clone this wiki locally