Top Queries

The following are the most common queries on our API

1. City Information

Returns 30 cities with information on if that information is active (most current year), boundary name, city name, MSA name, city Parcl ID, MSA Parcl ID, and year.

query CityInfo {
  CITY(limit: 30) {
    ACTIVE
    BOUNDARY_NAME
    CITY_NAME
    MSA_NAME
    MSA_PARCL_ID
    PARCL_ID
    YEAR
  }
}

2. MSA Parcl ID

Retrieve all MSA Parcl IDs for MSAs available in API.

query MSAParclID {
  MSA {
    MSA_NAME
    PARCL_ID
  }
}

3. City PPSF

Returns city information on Huntington Beach and PPSF of the area ordered by date in descending order.


query HuntingtonBeachPrices {
  CITY(where: {CITY_NAME: {_eq: "Huntington Beach"}}) {
    ACTIVE
    BOUNDARY_NAME
    CITY_NAME
    MSA_NAME
    MSA_PARCL_ID
    PARCL_ID
    YEAR
    parcl_price_feed(order_by: {DATE: desc}) {
      DATE
      PARCL_ID
      PARCL_PRICE_FEED
    }
  }
}

4. Chicago Deep Dive

Gets an average PPSF for the Chicago MSA, returns most populous cities within the MSA (ordered by population) and returns PPSF of each city in last 3 days. For each city, the total population of the last 5 years is also shown. Finally, every neighborhood in the city is returned, along with the number of amenities in each neighborhood (bars/cafes/restaurants).

query ChicagoDeepDive {
  MSA(where: {MSA_NAME: {_eq: "Chicago-Naperville-Elgin, IL-IN-WI"}}) {
    MSA_NAME
    parcl_price_feed_aggregate(limit: 14, order_by: {DATE: desc}) {
      aggregate {
        avg {
          PARCL_PRICE_FEED
        }
      }
    }
    cities(limit: 10, order_by: {census_aggregate: {avg: {POP_TOTAL: desc}}}) {
      CITY_NAME
      parcl_price_feed(limit: 3, order_by: {DATE: desc}) {
        PARCL_PRICE_FEED
        DATE
      }
      census(limit: 5, order_by: {YEAR: desc}) {
        YEAR
        POP_TOTAL
      }
      neighborhoods {
        NEIGHBORHOOD
        amenities {
          AMENITY_CATEGORY_TYPE
          NUM_AMENITIES
        }
      }
    }
  }
}