HOW TO USE
    FREE TOOL ← All Tools

    SQL WHERE Clause Builder for ArcGIS Online Queries

    Build ArcGIS SQL WHERE clauses visually using real field names and domain values from your service — no SQL knowledge needed. Sign in to load your saved services instantly and apply filters directly in Export or Schedules.

    Tutorial Get full access →
    Connected to ArcGIS Online
    1
    ArcGIS Online — Content tab: Go to arcgis.com → Content, click your Feature Layer item → scroll the right panel down → copy the URL ending in /FeatureServer/0
    2
    ArcGIS Online — Map Viewer: Open your web map → click a layer in the layers panel → ⋯ More options → View item details → Item page → URL in bottom-right.
    3
    Organizational AGOL: Works with personal arcgis.com accounts and organizational portals (yourorg.maps.arcgis.com). URL format: https://services.arcgis.com/{orgId}/arcgis/rest/services/{name}/FeatureServer/0
    4
    Not sure which layer? Use the free REST Explorer → — paste your org URL and browse all your Feature Services visually.
    1
    CONNECT
    2
    CONFIRM
    My Saved Services
    Demo:
    Conditions
    Join:
    WHERE clause
    Add conditions above to build your SQL filter…
    DO MORE WITH A FREE ACCOUNT
    Save your services, export AGOL layers to Excel / CSV, and automate recurring exports — no ESRI Pro license, no credit card.
    Create free account →