Examples of Query by Fields

Optimal ways to look up and query our nationwide parcel data

There are many ways to find parcel records of interest. With so much flexibility available, this article is all about describing different ways to do things, and then giving real-world examples of common types of parcel requests.

The Query endpoint is a bit of a 'Swiss Army knife' of Regrid endpoints. Much of the functionality of our other endpoints can be performed by this endpoint as well. It is primarily geared toward filtering by many fields scoped by a location/region/geometry component.

There is a slight learning curve to this endpoint as more information is embedded in the query parameter keys as well as values. But once that structure is clear, the versatility and expressiveness of the Query by Fields endpoint may make it your go-to endpoint.

Query by Fields

We highlight detailed use here, but sometimes it's best to learn by seeing a specific example request.

1. First note the query you'd like to make. What fields from the Regrid Schema will be used to filter parcel records?
2. Using the Query by Fields endpoint, take each field and craft it with the fields parameter then a field name and operator with the square bracket formatting (fields[geoid][eq]). The value after the field name is the SQL-like operator as defined in the Query by Fields endpoint.
3. Note adding multiple fields to a single query will AND them together which returns more specific results.
4. If the dataset is too large or a known region is needed, be sure to use some sort of geographic bounding field. This can be achieved with any of the following parameters: geoid, state2 & county, path (country/state/county), or a geojson geometry of the area of interest. Results can always be paged through using the offset_id and limit parameters if result sets are expected to be larger than 1000.

---

FIPS code and Owner Name

/api/v2/parcels/query?fields[geoid][eq]=48113&fields[owner][ilike]=7 ELEVEN INC

Find all parcels owned by 7-Eleven in Dallas County, Texas. Limit your result with the limit parameter. Dallas County has additional fields from the county that we provide users, set return_custom to true to view all fields.

Query parameters

• fields[geoid][eq]: Using the county FIPS code
• fields[owner][ilike]: Using the owner name for the search. This is case sensitive, so use ilike vs eq.

---

Zip Code, Land Use Code and State

/api/v2/parcels/query??fields[szip][eq]=46202&fields[lbcs_activity][between]=[2000,2999]&fields[state2][eq]=IN

Find businesses in Downtown Indianapolis within a specific zip code. These are parcels marked as Shopping, business, or trade activities. Limit your result with the limit parameter.

Query parameters

• fields[szip][eq]: Using the parcel situs zip code to search.
• fields[lbcs_activity][between]: You can look up all of our land base use codes here.
• fields[state2][eq]: Using the parcel situs state to search.
• path: Represents the path for the '/country/state/county'. This restricts the search to this area.

---

Land Use Code and FIPS Code

/api/v2/parcels/query?fields[lbcs_activity][eq]=4340&fields[geoid][eq]=48113 Find all the telecommunication parcels in Dallas County, Texas. Want to double check the count, use return_count parameter to get the total

Query parameters

• fields[lbcs_activity][eq]: You can look up all of our land base use codes here.
• fields[geoid][eq]: Using the county FIPS code

---

Standardized Zoning Type and FIPS Code

/api/v2/parcels/query?fields[zoning_type][eq]=Special&fields[geoid][eq]=53033 Find all the telecommunication parcels in Dallas County, Texas. Want to double check the count, use return_count parameter to get the total

Query parameters

• fields[zoning_type][eq]: Review all of our standardized zoning types across the USA.
• fields[geoid][eq]: Using the county FIPS code

---

Polygon Area, Land Use Code and Land Value

/api/v2/parcels/query?fields[lbcs_activity][eq]=1100&fields[landval][gte]=100000

Locate all the residential properties in a polygon area where the land value is greater or equal to $100,000.

• geojson: Geographic data structure for Polygon. Can use Point and Multipoint in combination with radius in a separate request. For example: {"type":"Polygon","coordinates":[[ [ -96.77737790638413, 32.8277929786983], [-96.77476147447638, 32.82780540015257], [-96.77614360093615, 32.82905995805102]]]}
• fields[lbcs_activity][eq]: You can look up all of our land base use codes here.
• fields[landval][gte]: Using parcel land value field.