Spiral gives your agent every tool with one account. Browse the tools →

Codex · Listings

How to Use Pittsburgh condemned properties in Codex

Find Pittsburgh condemned-property records with locations and latest inspection results. Use this for a condemnation inventory or inspection check; use Pittsburgh code violations to investigate recorded cases.

Prompts to try with Pittsburgh condemned properties in Codex

Copy an example into Codex, or ask in your own words.

Use Pittsburgh condemned properties to fetch Homewood records and add a table of addresses and latest inspection results to this project's neighborhood report.

Pittsburgh condemned propertiesCodex
Try asking
  • Use Pittsburgh condemned properties for Beltzhoover and create a map from the returned property locations in this project.

  • Use Pittsburgh condemned properties for ZIP code 15212 and update this project's summary to show distinct parcel totals alongside record totals.

  • Use Pittsburgh condemned properties to look this up and give me the result as a table. Save the result in ./assets.

  • Pull the latest numbers from Pittsburgh condemned properties and tell me what changed since last week.

How to set up Pittsburgh condemned properties in Codex

Pick the way that suits you. Each takes about two minutes.

Use Spiral's MCP server

  1. Add the hosted server
    codex mcp add spiral --url https://api.spiral.ai/mcp
  2. 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

  1. Send Codex this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use the Spiral CLI

  1. 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

  1. Create an API key

    In the console, under API keys.

  2. Run Pittsburgh condemned properties

    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_condemned_properties",
        "input": {
          "zip": "<zip>"
        }
      }'

Then paste one of the prompts above: Codex finds Pittsburgh condemned properties on Spiral, shows the price and runs it.

Pittsburgh condemned properties providers and prices

Spiral runs Pittsburgh condemned properties through Alexandria. Open a card for today's price, with every fee included.

AlexandriaListings

Settings you can ask for

Ask Codex for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Sortcondemned_desc or condemned_asccondemned_desc

condemned_desc: newest first; condemned_asc: oldest first.

Limit1 to 10025

Rows per page.

Inspection resultpass or fail

pass or fail: the latest inspection result.

Every API field of WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search condemned properties is on its tool page: open its card above.

What can you do with Pittsburgh condemned properties 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.

Questions about Pittsburgh condemned properties in Codex

Can Codex use Pittsburgh condemned properties?

Yes. Add Spiral to Codex as an MCP server, and Codex can find and run Pittsburgh condemned properties like any built-in tool.

How much does Pittsburgh condemned properties 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 condemned properties in Codex?

No. Spiral runs Pittsburgh condemned properties 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 condemned properties in Codex?

About two minutes: add the hosted server, then sign in.

Does Codex wait while Pittsburgh condemned properties runs?

Pittsburgh condemned properties 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.

Get started

Start using Pittsburgh condemned properties in Codex

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Codex:

Set up Codex

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options