`dc_query`

Pack: data-dc · Endpoint: https://gateway.pipeworx.io/data-dc/mcp

Query any Washington, DC ArcGIS layer by service path + layer id. Full ArcGIS query: where, out_fields, order_by, limit. Use dc_layers to find a service/layer, or dc_recent for the common ones. Epoch dates are converted to ISO.

Parameters

Name	Type	Required	Description
`service`	string	yes	ArcGIS service path, e.g. “FEEDS/MPD/MapServer” (or a short name: crime\|service_requests\|permits).
`layer`	number	yes	Layer id within the service (from dc_layers), e.g. 39.
`where`	string	no	ArcGIS SQL where (default “1=1”).
`out_fields`	string	no	Comma-separated fields, or ”*” (default).
`order_by`	string	no	Sort clause, e.g. “REPORT_DAT DESC”.
`limit`	number	no	Max rows (default 100, max 2000).

Example call

Arguments

{
  "service": "crime",
  "layer": 0,
  "where": "OFFENSE='THEFT/OTHER'",
  "limit": 50
}

curl

curl -X POST https://gateway.pipeworx.io/data-dc/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"dc_query","arguments":{"service":"crime","layer":0,"where":"OFFENSE='\''THEFT/OTHER'\''","limit":50}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('dc_query', {
  "service": "crime",
  "layer": 0,
  "where": "OFFENSE='THEFT/OTHER'",
  "limit": 50
});

More examples

{
  "service": "service_requests",
  "layer": 39,
  "out_fields": "WARD,REPORT_DAT,STATUS",
  "order_by": "REPORT_DAT DESC",
  "limit": 100
}

Connect

Add this to your MCP client config, or use one-click install buttons:

{
  "mcpServers": {
    "data-dc": {
      "url": "https://gateway.pipeworx.io/data-dc/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

dc_query