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

AlexandriaListingsAvailable now

WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations

data-wprdc-org/code-enforcement/search_violations

Search property, job and marketplace listings with WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations from Alexandria through one Spiral API key. Use to check a Pittsburgh property's code-enforcement history (address or parcel_id from search_permits), to read one case file (case_number returns all its rows) or to watch new investigations (investigated_since the last day you checked). It runs in the background and returns structured JSON. Pay as you go, with no subscription.

Pricing

$0.00873 per call.

Limits

Runs
In the background
Returns
json
Longest queue wait
1 hour
Run deadline
5 minutes
Longest run, end to end
225 minutes
Largest inline input
1 MB
Largest input file
2 GB
Largest output
5 GB

Input

FieldKindDefaultDescription
sortone of
investigated_desc, 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.

limitnumber
1 to 100
25

Rows per page.

cursortext—

next_cursor from the previous page; repeat the same filters with it. Pattern: ^[0-9]+$.

statustext—

Case-insensitive word match: every word must start a word of the column (prefix), in any order of the case status: under investigation, in violation, in court, closed.

addresstext—

Case-insensitive word match: every word must start a word of the column (prefix), in any order. Street line only (1815 Lowrie St, 56 South 12th Street); text after a comma is ignored and Street, Avenue, Road, Drive, North, South and similar become the city's abbreviations (ST, AVE, RD, DR, N, S).

outcometext—

Case-insensitive word match: every word must start a word of the column (prefix), in any order of the investigation outcome: violation found, no violation found, violation resolved, taking case to court.

case_typetext—

Case-insensitive word match: every word must start a word of the column (prefix), in any order of the case file type: building without a permit, vacant building, fire safety, weeds, construction site, illegal dumping.

parcel_idtext—

Allegheny County parcel id (block and lot), exact: 16 characters as the datasets store it (0048J00305000000) or the county's dashed form (0048-J-00305-0000-00). The same id joins permits, violations and condemned properties. Pattern: ^[0-9A-Za-z -]+$.

case_numbertext—

Case file number, exact (CF-PLI-2025-063616); returns every row of the case. Case-insensitive. Pattern: ^[A-Za-z0-9][A-Za-z0-9-]{2,29}$.

neighborhoodtext—

Case-insensitive word match: every word must start a word of the column (prefix), in any order of the city neighborhood.

investigated_sincetext—

Only investigation rows on or after this day, YYYY-MM-DD. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$.

investigated_untiltext—

Only investigation rows on or before this day, YYYY-MM-DD. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$.

Same request in code

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"
    }
  }'

Frequently asked questions

How much does WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations cost?

$0.00873 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

How do I use WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations through an API?

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "data-wprdc-org/code-enforcement/search_violations"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

Do I need an account with Alexandria to use WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations?

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

Can my AI agent use WPRDC (data.wprdc.org): Pittsburgh permits, code violations, condemnations and contractor licences · Search violations?

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.