Welcome to data.dconc.gov!
We will be adding more data feeds depending on the feedback we receive from the community.
Below is a list of current data feeds:
Query string documentation
Paging and return limit:
count=<Number of records returned> Defaults to 1000
page=<page in the data set to return>
Return Format
format=csv (returns csv format)
format=json (returns json format)
format=geojson (returns geojson format)
Callback
Both the geojson and json formast support "jsonp" style callbacks.
callback=<Call back name> (places CallbackName( ... ) around the returned data)
Return Specific Columns
columns=[Any column],[Any column],[Any column]...
columns=all (Show all columns)
Query Columns:
[Any column]__gt = <any value> (greater than)
[Any column]__gte=<any value> (greater than or equal to)
[Any column]__lt=<any value> (less than )
[Any column]__lte=<any value> (less than or equal to)
[Any column]__range=<any value start>,<any value high> (between 2 given values)
[Any column]__startswith=<Any column> (String column starts with)
[Any column]__endswith=<Any column> (String column end with)
[Any column]__contains=<Any column> (String column contains the parameter)
Or queries:
|[Any column]=<any value>
place a pipe befor any quey to make it an OR:
http://data.dconc.gov/ResturantData.aspx?table=establishments&format=csv&|Premise_Name__startswith=Mc&|Premise_Name__startswith=taco&status=active
All AND/OR statements are are grouped together. in SQL terms that mean it will select like :
Select ... where (status = 'active') AND ( Premise_Name = '%MC' OR Premise_Name = '%taco' )
Not queries:
![Any column]=<any value>
place an excaimation to make it not (can be combined with Or):
http://data.dconc.gov/ResturantData.aspx?table=establishments&format=geojson&lat__range=36.009413,36.010615&!Premise_Name__istartswith=McDonald
Sort Return
sort=[Any column]
sort=+[Any column] (Sort Ascending)
sort=-[Any column] (Sort Descending)
Examples
Sort by premise name, all resturants between the latitude points: 36.009413,36.010615 return in csv format
ResturantData.aspx?format=csv&lat__range=36.009413,36.010615&sort=+Premise_Name
Show only the columns:Premise_name,premise_address1,lat,lon where the premis name starts with MC or taco and the status is active
ResturantData.aspx?format=csv&columns=status,Premise_name,premise_address1,lat,lon&|Premise_Name__startswith=Mc&|Premise_Name__startswith=taco&status=active
Tester
You can test out simple queries of the resturant data using the GeoJson tester at:
data.dconc.gov/geojsontester.html
Please be sure to include: "format=geojson" in the url you paste there.
For an example implementation viewer for live resturant data see:
data.dconc.gov/ResturantDataTest.html