How to Use Pittsburgh code violations in Codex
Retrieve Pittsburgh enforcement records with investigation findings, cited code sections, and case status. Use this to reconstruct a case history; use Pittsburgh condemned properties for condemnation records and latest inspection results.
Prompts to try with Pittsburgh code violations in Codex
Copy an example into Codex, or ask in your own words.
Use Pittsburgh code violations to retrieve Hazelwood enforcement records and build a view that groups the returned records by case.
Use Pittsburgh code violations to retrieve South Side Flats records and add a case-summary export to this project's reporting tool.
Use Pittsburgh code violations to look this up and give me the result as a table. Save the result in ./assets.
Pull the latest numbers from Pittsburgh code violations and tell me what changed since last week.
Check Pittsburgh code violations and summarize what you find in three bullet points.
How to set up Pittsburgh code violations in Codex
Pick the way that suits you. Each takes about two minutes.
Use Spiral's MCP server
- Add the hosted server
codex mcp add spiral --url https://api.spiral.ai/mcp
- Sign in
Codex opens the browser: sign in to Spiral and click Authorize. No API key. codex mcp list then shows Spiral.
codex mcp login spiral
Use the Spiral skill
- Send Codex this message
Your agent reads Spiral's skill and sets itself up.
set up https://spiral.ai/SKILL.md
- Sign in or paste a key
Approve Spiral in the browser, or give the agent a key from the console.
Use the Spiral CLI
- Install and sign in
Installs the Spiral CLI, signs you in and adds its skill to your coding agents.
npx -y spiral-cli@latest init
Call the Spiral API
- Create an API key
In the console, under API keys.
- Run Pittsburgh code violations
One request; the result comes back by polling or a webhook.
curl https://api.spiral.ai/v1/runs \ -H "Authorization: Bearer $SPIRAL_API_KEY" \ -H "Content-Type: application/json" \ -H "Idempotency-Key: $(uuidgen)" \ -d '{ "provider": "alexandria", "model": "data-wprdc-org/code-enforcement/search_violations", "input": { "sort": "investigated_desc" } }'
Then paste one of the prompts above: Codex finds Pittsburgh code violations on Spiral, shows the price and runs it.
Pittsburgh code violations providers and prices
Spiral runs Pittsburgh code violations through Alexandria. Open a card for today's price, with every fee included.
Settings you can ask for
Ask Codex for any of these in your prompt.
| Setting | Allowed values | Default | Description |
|---|---|---|---|
| Sort | investigated_desc or investigated_asc | investigated_desc | investigated_desc: newest investigation first; investigated_asc: oldest first (a case's history in order). Rows without an investigation date come last. |
| Limit | 1 to 100 | 25 | Rows per page. |
Every API field of WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations is on its tool page: open its card above.
What can you do with Pittsburgh code violations in Codex?
Build a Pittsburgh property-condition view with returned locations and inspection or enforcement findings. Keep parcel totals separate from record totals so repeated records do not inflate the display.
Neighborhood property-condition brief
Prepare a Homewood briefing that separates condemnation records from enforcement cases and reports distinct parcels.
Commercial site review
Check a proposed Pittsburgh business location for condemnation records and recorded enforcement activity before requesting a fuller property review.
Community planning map
Map returned property locations for a Beltzhoover planning meeting, keeping condemnation results and enforcement cases clearly labeled.
Public-data change digest
Compare successive neighborhood searches and summarize newly appearing records and changes to previously returned records.
Redevelopment research shortlist
Attach condemnation and enforcement findings to a Pittsburgh redevelopment shortlist so researchers can identify parcels needing further review.
Neighborhood reporting research
Build a source-backed reporting brief on property conditions in Hazelwood, separating inspection results from enforcement findings.
More on Pittsburgh code violations and Codex
Overview
Pittsburgh code violations in other agents
Questions about Pittsburgh code violations in Codex
Can Codex use Pittsburgh code violations?
Yes. Add Spiral to Codex as an MCP server, and Codex can find and run Pittsburgh code violations like any built-in tool.
How much does Pittsburgh code violations cost in Codex?
$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Codex plan is separate.
Do I need an Alexandria account to use Pittsburgh code violations in Codex?
No. Spiral runs Pittsburgh code violations on its own Alexandria account. You sign in to Spiral once and never paste a key.
How long does it take to set up Pittsburgh code violations in Codex?
About two minutes: add the hosted server, then sign in.
Does Codex wait while Pittsburgh code violations runs?
Pittsburgh code violations runs in the background. Codex starts the run, checks on it and gives you the json when it's ready.
Does this cover all of Allegheny County?
These are City of Pittsburgh condemnation and enforcement records. An Allegheny County parcel identifier in a record does not make the dataset countywide.
How often does WPRDC publish updates?
Both datasets list daily data changes and daily publishing. That is a publishing schedule, not a promise that every property receives a new inspection each day.
Can I count rows to count properties?
No. WPRDC flags duplicate parcel records in the condemnation data; enforcement records also describe case activity rather than a simple property inventory.
Does a latest inspection result provide the whole property history?
The condemnation data describes the latest inspection, including its pass or fail result. The violations data serves a different purpose: investigating recorded enforcement cases.
How far back does Pittsburgh's violations data go?
The current violations resource covers June 2020 onward. WPRDC publishes October 2015 through May 2020 separately as historical PLI data, so that older period should not be assumed to appear in a current search.
Start using Pittsburgh code violations in Codex
One Spiral account for every tool your agent needs. No subscription; you pay per run.
Paste this into Codex:
set up https://spiral.ai/SKILL.md


