[Integrations](https://spiral.ai/integrations) › [dots](https://spiral.ai/integrations/dots) › [Columbus contractor permit activity](https://spiral.ai/integrations/dots/columbus-contractor-permit-activity)

# How to Use Columbus contractor permit activity in dots

Returns applicant businesses ranked by permit count, with total permit valuation for a date window. Use it to compare business activity across Columbus or within a ZIP code and work category.

|  |  |
| --- | --- |
| Model | Columbus contractor permit activity |
| Available through | Alexandria |
| Category | Listings |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, with a Spiral API key |

## Prompts to try with Columbus contractor permit activity in dots

- On the first Monday of each month, use Columbus contractor permit activity to summarize plumbing applicant counts and valuations in Columbus for the previous calendar month.
- Each month, use Columbus contractor permit activity to compare roofing applicants in ZIP 43212 for the previous calendar month with the month before it.
- Every Monday at 9am: use Columbus contractor permit activity to look this up and give me the result as a table.
- Pull the latest numbers from Columbus contractor permit activity and tell me what changed since last week.
- Check Columbus contractor permit activity and summarize what you find in three bullet points.

## How to set up Columbus contractor permit activity in dots

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

### Use the Spiral skill

1. **Send dots 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 Spiral's MCP server

1. **Create an API key**: In the console, open API keys and create a key for your dot. Copy it.

2. **Send your dot this message**: Your dot reads Spiral's skill and asks for your API key.

```text
set up https://spiral.ai/SKILL.md
```

3. **Give your dot the key**: When your dot asks for the key, add it where your dot keeps secrets, never in the chat itself.

### Use the Spiral CLI

1. **Install and sign in**: Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run Columbus contractor permit activity**: One request; the result comes back by polling or a webhook.

```bash
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": "opendata-columbus-gov/building-permits/contractor_activity",
    "input": {
      "issued_since": "<issued_since>"
    }
  }'
```

Then paste one of the prompts above: dots finds Columbus contractor permit activity on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/dots

## Columbus contractor permit activity tools and prices

- [City of Columbus Building Permits (opendata.columbus.gov) · Contractor activity](https://spiral.ai/tools/alexandria/opendata-columbus-gov/building-permits/contractor_activity) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| zip |  | — | Five-digit site ZIP code, for example 43215. Pattern: ^[0-9]{5}$. |
| limit | 1 to 100 | 25 | Records per page. |
| cursor |  | — | The next_cursor of the previous page; repeat the same filters with it. Pattern: ^[0-9]{1,7}$. |
| permit_type |  | — | Case-insensitive substring over property class, permit kind, work category, general type and Census category: new structure, demolition, roof, plumbing, mechanical, fire protection, sign, commercial, multi family, single family houses detached, five or more family. |
| issued_until |  | — | Last issue date, inclusive (YYYY-MM-DD); open-ended when omitted. Pattern: ^[0-9]{4}-[0-9]{2}-[0-9]{2}$. |

## What can you do with Columbus contractor permit activity in dots?

Keep a recurring Columbus construction brief current as the city refreshes its permit data nightly. Monitor new permits, revisit selected records, and compare applicant-business activity over time.

### Choose a supplier sales territory

Compare plumbing permit activity across Columbus ZIP codes, identify active applicant businesses, and inspect individual permits before preparing a business outreach list.

### Benchmark a contractor's recorded activity

Compare a public business's permit count and valuation with other applicants in the same work category. Review its matching permits and expand selected records to explain the comparison.

### Prepare a quarterly development brief

Summarize permits issued in ZIP 43215, compare applicant-business activity across quarters, and include full records for selected commercial permits.

### Research multifamily construction activity

Find multifamily permits, compare the applicant businesses associated with that category, and examine selected records for a housing development report.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All dots guides](https://spiral.ai/integrations/dots)

## Columbus contractor permit activity in other agents

- [Amp](https://spiral.ai/integrations/amp/columbus-contractor-permit-activity)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/columbus-contractor-permit-activity)
- [Claude](https://spiral.ai/integrations/claude-desktop/columbus-contractor-permit-activity)
- [Claude Code](https://spiral.ai/integrations/claude-code/columbus-contractor-permit-activity)
- [Cline](https://spiral.ai/integrations/cline/columbus-contractor-permit-activity)
- [Codex](https://spiral.ai/integrations/codex/columbus-contractor-permit-activity)
- [Cursor](https://spiral.ai/integrations/cursor/columbus-contractor-permit-activity)
- [Devin](https://spiral.ai/integrations/devin/columbus-contractor-permit-activity)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/columbus-contractor-permit-activity)
- [Gemini](https://spiral.ai/integrations/gemini/columbus-contractor-permit-activity)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/columbus-contractor-permit-activity)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/columbus-contractor-permit-activity)
- [goose](https://spiral.ai/integrations/goose/columbus-contractor-permit-activity)
- [Grok](https://spiral.ai/integrations/grok/columbus-contractor-permit-activity)
- [Grok Build](https://spiral.ai/integrations/grok-build/columbus-contractor-permit-activity)
- [Hermes](https://spiral.ai/integrations/hermes/columbus-contractor-permit-activity)
- [Instinct](https://spiral.ai/integrations/instinct/columbus-contractor-permit-activity)
- [Manus](https://spiral.ai/integrations/manus/columbus-contractor-permit-activity)
- [Muse](https://spiral.ai/integrations/muse/columbus-contractor-permit-activity)
- [Muse Code](https://spiral.ai/integrations/muse-code/columbus-contractor-permit-activity)
- [n8n](https://spiral.ai/integrations/n8n/columbus-contractor-permit-activity)
- [Notion](https://spiral.ai/integrations/notion/columbus-contractor-permit-activity)
- [OpenClaw](https://spiral.ai/integrations/openclaw/columbus-contractor-permit-activity)
- [opencode](https://spiral.ai/integrations/opencode/columbus-contractor-permit-activity)
- [Perplexity](https://spiral.ai/integrations/perplexity/columbus-contractor-permit-activity)
- [Raycast](https://spiral.ai/integrations/raycast/columbus-contractor-permit-activity)
- [VS Code](https://spiral.ai/integrations/vscode/columbus-contractor-permit-activity)
- [Windsurf](https://spiral.ai/integrations/windsurf/columbus-contractor-permit-activity)
- [Zapier](https://spiral.ai/integrations/zapier/columbus-contractor-permit-activity)

## More dots guides

- [Columbus building permit search](https://spiral.ai/integrations/dots/columbus-building-permit-search)
- [Connecticut solar and battery installations](https://spiral.ai/integrations/dots/connecticut-solar-and-battery-installations)
- [Columbus building permit details](https://spiral.ai/integrations/dots/columbus-building-permit-details)
- [Connecticut solar and battery installer activity](https://spiral.ai/integrations/dots/connecticut-solar-and-battery-installer-activity)
- [Colorado DORA license types](https://spiral.ai/integrations/dots/colorado-dora-license-types)
- [Craigslist housing posting details](https://spiral.ai/integrations/dots/craigslist-housing-posting-details)

## Questions about Columbus contractor permit activity in dots

**Can dots use Columbus contractor permit activity?**

Yes. Add Spiral to dots as an MCP server, and dots can find and run Columbus contractor permit activity like any built-in tool.

**How much does Columbus contractor permit activity cost in dots?**

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

**Do I need an Alexandria account to use Columbus contractor permit activity in dots?**

You need no Alexandria account. dots uses one Spiral API key for every tool, and Spiral runs Columbus contractor permit activity on its own Alexandria account.

**How long does it take to set up Columbus contractor permit activity in dots?**

About two minutes: create an API key, then send your dot this message, then give your dot the key.

**Does dots wait while Columbus contractor permit activity runs?**

Columbus contractor permit activity runs in the background. dots starts the run, checks on it and gives you the json when it's ready.

**Does this cover all of Franklin County?**

The documented coverage is permits issued by Columbus Building and Zoning Services. A Franklin County location alone does not establish that its permits belong in this city-issued dataset.

**How far back do the records go?**

The city documents a period of record from 2010 to the present. Use 2010 as the documented starting point for historical comparisons.

**How fresh is the permit data?**

The city says the layer updates nightly as new permits are issued. Plan monitoring around that nightly schedule.

**Can I compare contractor activity by both volume and value?**

The provider ranks applicant businesses by permit count and permit value. Those measures describe activity recorded in Columbus permits.

**Can the permit data be reused in a commercial report?**

The provider identifies the dataset as CC0. CC0 permits copying, modification, distribution, and commercial reuse without asking permission.

