![National Day of Civic Hacking](../../img/ndoch.png) ## Introduction to the SODA APIs ![SODA](../../img/can.png)

# Who the heck are you? ![APIs](../../img/socrata-white.png)

We build software to make data useful to more people.

[data.edmonton.ca](http://data.edmonton.ca) [finances.worldbank.org](http://finances.worldbank.org) [data.cityofchicago.org](http://data.cityofchicago.org) [data.seattle.gov](http://data.seattle.gov) [data.oregon.gov](http://data.oregon.gov) [data.wa.gov](http://data.wa.gov) [www.metrochicagodata.org](http://www.metrochicagodata.org) [data.cityofboston.gov](http://data.cityofboston.gov) [info.samhsa.gov](http://info.samhsa.gov) [explore.data.gov](http://explore.data.gov) [data.cms.gov](http://data.cms.gov) [data.ok.gov](http://data.ok.gov) [data.nola.gov](http://data.nola.gov) [data.illinois.gov](http://data.illinois.gov) [data.colorado.gov](http://data.colorado.gov) [data.austintexas.gov](http://data.austintexas.gov) [data.undp.org](http://data.undp.org) [www.opendatanyc.com](http://www.opendatanyc.com) [data.mo.gov](http://data.mo.gov) [data.nfpa.org](http://data.nfpa.org) [data.raleighnc.gov](http://data.raleighnc.gov) [dati.lombardia.it](http://dati.lombardia.it) [data.montgomerycountymd.gov](http://data.montgomerycountymd.gov) [data.cityofnewyork.us](http://data.cityofnewyork.us) [data.acgov.org](http://data.acgov.org) [data.baltimorecity.gov](http://data.baltimorecity.gov) [data.energystar.gov](http://data.energystar.gov) [data.somervillema.gov](http://data.somervillema.gov) [data.maryland.gov](http://data.maryland.gov) [data.taxpayer.net](http://data.taxpayer.net) [bronx.lehman.cuny.edu](http://bronx.lehman.cuny.edu) [data.hawaii.gov](http://data.hawaii.gov) [data.sfgov.org](http://data.sfgov.org) [data.cityofmadison.com](http://data.cityofmadison.com) [healthmeasures.aspe.hhs.gov](http://healthmeasures.aspe.hhs.gov) [data.weatherfordtx.gov](http://data.weatherfordtx.gov) [www.data.act.gov.au](http://www.data.act.gov.au) [data.wellingtonfl.gov](http://data.wellingtonfl.gov) [data.honolulu.gov](http://data.honolulu.gov) [data.kcmo.org](http://data.kcmo.org) [data2020.abtassociates.com](http://data2020.abtassociates.com) [data.ny.gov](http://data.ny.gov) [health.data.ny.gov](http://health.data.ny.gov) [www.halifaxopendata.ca](http://www.halifaxopendata.ca) [portal.louisvilleky.gov](http://portal.louisvilleky.gov) [data.medicare.gov](http://data.medicare.gov) [data.southbendin.gov](http://data.southbendin.gov)

# The Socrata Open Data APIs ![SODA](../../img/can.png)

## Every dataset, on every Socrata data site


GET https://data.seattle.gov/resource/fire-911.json?$where=datetime > '2012-08-22 15:45'
[
  {
    "address": "1402 E Pike St",
    "longitude": "-122.314118",
    "latitude": "47.614121",
    "incident_number": "F120079189",
    "datetime": 1345675560,
    "type": "Motor Vehicle Accident",
    "report_location": {
      "longitude": "-122.314118",
      "latitude": "47.614121"
    }
  }
]

## Finding Data * [hackforchange.org/datasets](http://hackforchange.org/datasets) * [communities.socrata.com](https://communities.socrata.com) * [http://www.data.gov/developers/page/developer-data](http://www.data.gov/developers/page/developer-data)

## API Endpoints Format: https://$domain/resource/$identifier.ext

## API Endpoints Example: [Electric Consumption by Zip Code](https://data.city.gov/Environmental-Sustainability/Electric-Consumption-by-ZIP-Code-2010/abcd-1234) https://data.city.gov/envir.../elec.../abcd-1234 ... becomes ...


              https://data.city.gov/resource/abcd-1234.json

## Simple Filters


              /resource/abcd-1234.json?source=ConEd


  [ {
    "zipcode" : "10001",
    "source" : "ConEd",
    "location" : {
      "longitude" : "-73.99688630375988",
      "latitude" : "40.75025902143676",
    },
    "building_type" : "Commercial",
    "kwh" : "23328498"
  }, ... ]

## SoQL Queries


              /resource/abcd-1234.json?

                $where=kwh > 80000

For more details see dev.socrata.com

## Aggregating Data


              /resource/abcd-1234.json?

                $select=source, sum(kwh)

                &$group=source


  [ {
    "source" : "ConEd",
    "sum_kwh" : "49469570957"
  }, {
    "source" : "Long Island Power Authority",
    "sum_kwh" : "445333629"
  }, ... ]

## Limiting Output


              /resource/abcd-1234.json?

                $limit=5

## Paging Through Data


              /resource/abcd-1234.json?

              $limit=50

                &$offset=100

## Application Tokens 1. Register at [http://dev.socrata.com/register](http://dev.socrata.com/register) 2. Include as: - X-App-Token: $token HTTP Header or ... - The $$app_token=$token parameter 3. Profit!!! (from more API requests)

# Help! ![Questions](../../img/Question.tif.png)

## Developer Portal ![Developer Portal](../../img/Info.tif.png) [http://dev.socrata.com](http://dev.socrata.com)

## Open Source Code * Libraries in: * Ruby * Java * Scala * ObjectiveC / iOS * Our entire backend stack * ... and more!

### [http://github.com/socrata](http://github.com/socrata)

## Live Help! * IRC: [chat.freenode.net #ndoch](https://webchat.freenode.net/) * Twitter: [@socrata](http://twitter.com/socrata) or [@chrismetcalf](http://twitter.com/chrismetcalf) * Support Portal [support.socrata.com](http://support.socrata.com) * Track down one of us!

## One more thing...

We're hiring!

www.socrata.com/jobs

# Thanks! ![Moustaches!](../../img/moustaches.jpg)