openapi: 3.0.1 info: title: Farmland Sales and Listings description: 'Ag-Analytics® Farmland Sales API provides users with easy and fast access to filter and find land for sale, complete with the sales and geographic data components to get a detailed description of that land’s value. ' version: '1.0' servers: - url: https://ag-analytics.azure-api.net/farmland-sales paths: /: get: summary: Farmland Sales - GET description: "\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\nAg-Analytics® Farmland Sales API provides users with easy and fast access to filter and find land for sale, complete with the sales and geographic data components to get a detailed description of that land’s value. The data of this service is originally provided by Farmland Finder. Each response item has a full description of the entire sale/listing information. Multiple parcel/land records can belong to one single listing. In the ‘parcels’ parameter in listing, each parcel record gives the detailed description of a certain land/parcel itself.\n\n\n\n

\nPlease note, the API request format has been edited from POST to GET. Changes will be reflected in the Documentation and Jupyter Notebook.

\n

\n\n\n\n
\n
\nFarmland Sales Example Response

\n
\n\n\n\n
\n
\n

Documentation

\n
\n\n\n\n

Notebook

\n
\n\n\n\n

Github Repo

\n
\n
\n\n
Click the Jupyter Notebook Static Sample to view a static rendition of this APIs Jupyter Notebook.
Click the Jupyter Notebook Github Repo to access the Jupyter Notebook .ipynb files and
instructions needed in order to run this APIs Jupyter Notebook.
\n
\n
\n\n\n\n\n\n
\n\n\n\n\n
\n

Header Parameters

\n
\n\t

content-type: \"application/json”

\n
\n\t

Ocp-Apim-Subscription-Key: Subscription keys are given upon purchase

\n
\n\n\n\n
\n

Request Parameters

\n
\n
\n \n\t\n \t \n \t \n \t \n \t \n\t \n\t \n\t\n\n \n \n \n \n \n \n \n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
ParameterData TypeRequired?OptionsDescription
StateTextYesIllinois, Indiana, Iowa, Kansas, Michigan, Minnesota, Missouri, Nebraska, North Dakota, Ohio, South Dakota, WisconsinState of interest. Title cased. Ex. \"Michigan\" or \"Ohio\"
CountyTextNoCounties in the above statesCounty of interest. Title cased. Ex. \"Osceola\" or \"Polk\" Note: This parameter will be valid only if the State parameter is provided
Bounding_boxTextYesGeoJSONArea of interest in GeoJSON format. Note: Please provide at least one parameter selected from 'State', 'County', and 'Bounding_box'
StatusTextConditional'Sold', 'For Sale', 'Expired Listing'Sale condition of the property
StartDateIntegerConditional'yyyy-mm-dd'Searching starting date of the property Sale Date. In format 'yyyy-mm-dd' Note: Required only if Status is 'Sold'
EndDateIntegerYes'yyyy-mm-dd'Searching starting date of the property Sale Date. In format 'yyyy-mm-dd' Note: Required only if Status is 'Sold'
\n
\n
\n\n\n\n\n
\n

Response Parameters

\n
\n
\n \n\n\n\n\n\n\n\n \n \n \n \n \n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
ParameterTypeDescription
statusStringStatus of the API call. (\"SUCCESS\", \"FAILURE\", \"WARNING\")
msgText---
Listing ParameterTypeDescription
Listing_idStringThe unique ID for each listing(sales).
Entry_UpdatedDateThe date of the listing(sales) information has been updated
Avg_CSR2IntegerThe average The Iowa Corn Suitability Rating(Soil Productivity Index)
CRPStringIf the property joined the Conservation Reserve Program.(‘Yes’ or 'No')
CRP_AcresFloatThe CRP acres
Total_AcresFloatThe total acres of the entire sale
Tillable_AcresFloatThe tillable acres of the sale
Percent_TillableFloatThe percent tillable area
Sale_PriceFloatThe total sale price of the sale record
Price_AcreFloatThe price per acre of the sale record
StatusStringOne of the following values: \"For Sale\", \"Listing Expired\", \"Sold\"
Sale_ConditionStringOne of the following values: \"Auction\", \"Listing\"
Listing_AgentStringThe listing agent name
Broker_URLStringThe URL link to the broker listing webpage as a string
BuyerStringThe buyer name as a string
Sale_DateStringThe sale date string in YYYY-MM-DD format. (When the parcel is still listing, the attribute will be Null)
Taxes_totalFloatTaxes for the sale as a float
Assessed_LandStringIf the land/parcel has been assessed
Parcel ParameterTypeDescription
Parcel_IDStringThe unique sale ID for each parcel as a string
ParcelStringIndex of the parcel in one listing(transaction)
ShapeStringThe boundary of the parcel/property in Well Known Text type
GeoJSONStringThe boundary of the parcel/property in GeoJSON type
AcresFloatArea of the parcel
StateStringThe state where the parcel/property locates in
CountyStringThe county where the parcel/property locates in
lat_centerFloatThe latitudinal center of the parcel/property as a float value
lng_centerFloatThe longitudinal center of the parcel/property as a float value
rangeStringThe range as a string (ex: 26W - always include E or W)
sectStringThe section as string (ex: 17)
twnshpStringThe township as a string (ex: 78N - always include N or S)
county_nameStringThe county name as a string (Title cased - for ex: Osceola, Polk, etc.)
state_nameStringThe state name as a string (Title cased - for ex: Michigan)
STATEFPStringThe FIPS to state level as a string
FIPSStringThe FIPS to county level as a string
\n
\n
\n
\n
" operationId: farmland-sales parameters: - name: State in: query description: 'State of interest, title cased. Ex. "Michigan"' schema: enum: - '' type: '' default: '' - name: County in: query description: 'County of interest, title cased. Ex. "Osceola"' schema: enum: - '' type: '' default: '' - name: Status in: query description: Sale condition of the property. schema: enum: - '' type: '' default: '' - name: Content-Type in: header description: Request content type schema: enum: - '' type: '' default: '' responses: '200': description: '' components: securitySchemes: apiKeyHeader: type: apiKey name: Ocp-Apim-Subscription-Key in: header apiKeyQuery: type: apiKey name: subscription-key in: query security: - apiKeyHeader: [ ] - apiKeyQuery: [ ]