A tool by Firecrawl · uses 9 tools · Government

Council district constituent issue brief

Use when a Seattle city council legislative aide prepares for a constituent meeting or neighbourhood walk. Maps an address to its council district and member, pulls the member's recent statements, counts open 311 and code-violation records nearby from city open data, and adds local demographics, giving the aide a sourced one-pager.

Open in ChatGPT Open in Claude

Save a copy for your team

Tools it calls

Each tool's price and track record across every agent today. Empty means the call worked and found nothing.

ToolPriceMedianSuccessEmpty

OpenStreetMapGeocodePrice5 creditsMedian531 msSuccess98.9%Empty27%
City of SeattleFind districtPrice5 creditsMedian–Success–Empty–
City of SeattleCouncilmemberPrice5 creditsMedian–Success–Empty–
City of SeattleCouncil newsPrice5 creditsMedian–Success–Empty–
Socrata open-data portalsSearch datasetsPrice5 creditsMedian160 msSuccess97.4%Empty7.9%
Socrata open-data portalsDescribe datasetPrice5 creditsMedian–Success–Empty–
Socrata open-data portalsQuery datasetPrice5 creditsMedian717 msSuccess90.3%Empty12.3%
US Census BureauDataPrice5 creditsMedian617 msSuccess97.7%Empty3.8%
US Census BureauGeographiesPrice5 creditsMedian152 msSuccess100%Empty0%

Instructions

What your agent follows when it runs this tool. Paste them into any assistant connected to Firecrawl.

# Council district constituent issue brief

For one address or neighbourhood in Seattle and an upcoming meeting. The aide needs to know whose district it is, what the member has said and what residents keep reporting.

## 1. Whose district

1. Geocode the address with @[OpenStreetMap · Geocode](alexandria:openstreetmap-org/places/geocode). Carry **lat** and **lon**.
2. Map it with @[City of Seattle · Find district](alexandria:seattle-gov/seattle-city-government/find_district): district number and councilmember.
3. Read the member's record with @[City of Seattle · Councilmember](alexandria:seattle-gov/seattle-city-government/councilmember) and recent statements with @[City of Seattle · Council news](alexandria:seattle-gov/seattle-city-government/council_news) (search the neighbourhood or topic).

## 2. What residents report

4. Find Seattle's 311 or code-compliance dataset with @[Socrata · Search datasets](alexandria:socrata-com/open-data/search_datasets) (domain data.seattle.gov, query "customer service requests" or "code complaints").
5. Read its columns with @[Socrata · Describe dataset](alexandria:socrata-com/open-data/describe_dataset), then count recent records near the point by category with @[Socrata · Query dataset](alexandria:socrata-com/open-data/query_dataset) (where on date and location, group by type).

## 3. Who lives there

6. Pull tract-level population, renter share and median income with @[US Census Bureau · Data](alexandria:census-gov/census/data) (acs/acs5) after resolving the tract with @[US Census Bureau · Geographies](alexandria:census-gov/census/geographies).

## Write the brief

- **Header:** district, member, meeting purpose.
- **Top five issues** by 90-day request count, with open versus closed.
- **What the member has said** on those issues, dated.
- **Neighbourhood profile:** population, renter share, income, with ACS vintage.
- **Sources:** dataset ids, query filters, news URLs, ACS tables. Say what could not be found or which datasets were stale.

All Firecrawl tools