Documentation for "/api/v1/wimn/site-activities":

Documentation score: Route: 100% Fields: 100%

Description:

MPCA site and activity overview. A site is a location, such as a manufacturing plant or cleanup site, where the MPCA carries out an activity. Activities refer to activities carried out by an organization and the MPCA at a given site. Activities include, but are not limited to, air emission permits, the cleanup of leaks and spills, the disposal of solid waste, and the handling of hazardous waste.

Search parameters:

One or more of the following search parameters need to be specified in order to retrieve data:
Parameter nameRequiredDescription
siteId The query id for the site that the activity is associated with.
siteName The name of the site that the activity is associated with.
ownerName The name of the owner of the site that the activity is associated with.
activitySubtypeName The subtype of activity. (Ref:/api/doc/v1/wimn/activity-subtypes)
cityName The name of the municipality where the site is located.
stateCode The two-character state code where the site is located.
zipCode The zip code of the site.
countyName The name of the county. (Ref:/api/doc/v1/wimn/counties)
legislativeDistrict The legislative district that the site is in.
huc8 The 8-digit hydrological unit code for the watershed that the site is in. (Ref:/api/doc/v1/wimn/watersheds)
activeSite Flag indicating whether the site is active or not ("Y", "N").
countyCode The FIPS code for the county that the site is located in. (Ref:/api/doc/v1/wimn/counties)
activityTypeCode Database code for this activity type (Ref:/api/doc/v1/wimn/activity-types)
alternateId Other names and IDs by which this activity has been known.
nameSearchString The name of the site name, activity name, organization name, or other identifier to search by.
neighborhood Search for sites using the city, county, township, or zip code that a site is found in.
searchString The name of the site name, activity name, organization name, or other identifier to search by.
institutionalControl Indicates whether or not there are institutional controls at the site ("Y", "N").

Additional parameters:

The following, optional, parameters may be specified:
Parameter nameDescription
format The desired return format. Valid formats are: {json, jsonp, text, csv, xls, ods, and tab}. The default is json.
callback The JSONP callback function name (Note that format needs to be "jsonp").
fields The comma-separated-list of the field names to return from the query. The default is to return all available fields.
nullValue Value to substitute in place of null values. The default is to return null values as "null" (per JSON.org).
limit The number of records to limit the result set to. Behaves like the SQL standard LIMIT clause.
offset Used with Limit-- the record number to start retrieving from. Behaves like the SQL standard OFFSET clause.

Result Set Definitions:

Field nameDescription
siteId The query id for the site that the activity is associated with.
siteName The name of the site that the activity is associated with.
ownerName The name of the owner of the site that the activity is associated with.
programName The name of the MPCA program associated with the activity.
activityTypeName The type of activity.
activitySubtypeName The subtype of activity.
industrialClassification Industrial classification (NAICS or SIC) for the site.
activityId The commonly used ID for the activity.
activityName The name of the activity.
active Indicates if the the activity is active or not.
addressLine1 The first line of the street address.
addressLine2 The second line of the street address.
cityName The name of the municipality where the site is located.
stateCode The two-character state code where the site is located.
zipCode The zip code of the site.
countyName The name of the county.
legislativeDistrict The legislative district that the site is in.
huc8 The 8-digit hydrological unit code for the watershed that the site is in.
watershedName The name of the major watershed that the site is located in.
lat The latitude of the site in decimal degrees.
long The longitude of the site in decimal degrees.
coordinateMethod The method used to determine the locational (lat/long) coordinates.
institutionalControl Indicates whether or not there are institutional controls at the site ("Y", "N").

Example Queries: