<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <title>Socrata Developer Portal | Socrata</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta name="description" content="">
    <meta name="author" content="">

    <!-- Le Bootstrap-->
    <link href="//netdna.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">

    <!-- Font Awesome by Dave Gandy - http://fontawesome.io/ -->
    <link href="//netdna.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.css" rel="stylesheet"/>

    <!-- Featherlight Lightbox -->
    <link href="//cdn.rawgit.com/noelboss/featherlight/1.3.4/release/featherlight.min.css" rel="stylesheet"/>

    <!-- MathJax -->
    <script type="text/x-mathjax-config">
      MathJax.Hub.Config({
        tex2jax: {
          inlineMath: [['\\(','\\)']],
          processEscapes: true
        }
      });
    </script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.0/MathJax.js?config=TeX-AMS-MML_HTMLorMML" type="text/javascript"></script>

    <!-- Google Web Fonts -->
    <link href="//fonts.googleapis.com/css?family=Ubuntu:bold" rel="stylesheet" type="text/css"/>
    <link href="//fonts.googleapis.com/css?family=Nobile" rel="stylesheet" type="text/css"/>
    <link href="//cdnjs.cloudflare.com/ajax/libs/highlight.js/9.1.0/styles/default.min.css" rel="stylesheet"/>

    <!-- CSS customizations -->
    <link href="/common/css/common.css" rel="stylesheet"/>
    <link href="/common/css/murphy.css" rel="stylesheet"/>
    <link href="/css/local.css" rel="stylesheet"/>

    <!-- Page-level Customizations -->
    

    <!-- Site-level Customizations -->
    

    <!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
    <!--[if lt IE 9]>
      <script src="//html5shim.googlecode.com/svn/trunk/html5.js"></script>
    <![endif]-->

    <!-- Require.js is either the best thing to ever happen to me or my worst enemy -->
    <script src="/common/js/require.js"></script>
    
    <script>
      // Load common code and custom includes
      requirejs(['/common/js/common.js'], function(common) {
        var rel_require = function(script) {
          if(script.match(/^\/[^\/]/)) {
            script = ''  + script;
          }

          requirejs([script]);
        };

        // Site scripts
        
          rel_require('/js/main.js');
        
          rel_require('/js/snuffleupadata.js');
        
          rel_require('/js/peeper.js');
        
          rel_require('/js/github.js');
        
          rel_require('/common/js/lib/socrata-status.js');
        
          rel_require('/common/js/lib/ga-tracking.js');
        

        // Page scripts
        
        
          rel_require('/js/foundry-local.js');
        
      });
    </script>

    <!-- Custom non-RequireJS dependencies -->
    

    <!-- Browser Icons -->
    <link rel="apple-touch-icon-precomposed" sizes="144x144" href="/common/ico/apple-touch-icon-144-precomposed.png"/>
    <link rel="apple-touch-icon-precomposed" sizes="114x114" href="/common/ico/apple-touch-icon-114-precomposed.png"/>
    <link rel="apple-touch-icon-precomposed" sizes="72x72" href="/common/ico/apple-touch-icon-72-precomposed.png"/>
    <link rel="shortcut icon" href="/common/ico/favicon.png"/>

    <!-- Blog RSS -->
    <link type="application/atom+xml" rel="alternate" href="https://dev.socrata.com/feed.xml" title="Socrata Developer Blog">
  </head>

  <body class="dev foundry 200">
    <!-- Path: "200.html" -->


    <!-- Header Nav -->
    <div class="navbar navbar-inverse navbar-fixed-top dev" role="navigation">
      <div class="container">
        <!-- Current Site -->
        <div class="navbar-header">
          <!-- Collapse Button -->
          <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#nav-collapse">
            <span class="sr-only">Toggle navigation</span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
            <span class="icon-bar"></span>
          </button>

          <a class="navbar-brand dev" href="/"><i class="fa fa-code"></i> SODA Developers</a>
        </div>

        <div class="collapse navbar-collapse" id="nav-collapse">
          <!-- Right side nav -->
          <form class="navbar-form navbar-right visible-lg" action="/search.html" method="GET" role="search">
            <div class="form-group">
              <input name="q" class="form-control search" type="text" placeholder="Search" aria-label="Search terms">
            </div>
          </form>

          <!-- Nav elements -->
          <ul class="nav navbar-nav">
            <li class="dropdown ">
  <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-fw fa-cogs"></i>App Developers <i class="fa fa-caret-down"></i></a>
  <ul class="dropdown-menu">
    
  <li class="nav-header dropdown-header">App Developers</li>
  <li><a href='/consumers/getting-started'>Getting Started</a></li>
  <li><a href="/data/">Finding Open Data</a></li>

  <li class="nav-header dropdown-header">Examples</li>
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2016/02/02/plotly-pandas'>Data Visualization with Plotly and Pandas</a></li>
      
    
  
    
      
        <li><a href='/blog/2016/02/01/pandas-and-jupyter-notebook'>Data Analysis with Python and pandas using Jupyter Notebook</a></li>
      
    
  
    
  
    
  
    
      
        <li><a href='/blog/2015/11/28/using-r-and-shiny-to-find-outliers-with-box-plots'>Using R and Shiny to Find Outliers with Scatter and Box Plots</a></li>
      
    
  
    
  
    
      
        <li><a href='/blog/2015/11/10/analyzing-open-data-with-sas'>Analyzing Open Data with SAS</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2015/07/09/sms-apps-with-twilio'>Building SMS Applications with Twilio</a></li>
      
    
  
    
      
        <li><a href='/blog/2015/06/17/forecasting_with_rsocrata'>Forecasting with RSocrata</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2015/05/20/data-visualisation-with-r'>Making a heatmap with R</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2015/03/30/create-a-column-chart-with-highcharts'>Create a column chart with Highcharts</a></li>
      
    
  
    
  
    
      
        <li><a href='/blog/2015/02/10/within-box-query-with-leaflet'>Generating a within_box() query with Leaflet.js</a></li>
      
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2014/12/24/jquery-date-slider'>Using a jQueryUI date slider to build a SODA Query</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2014/11/04/data-visualization-with-python'>Data Analysis with Python, Pandas, and Bokeh</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2014/10/01/animated-heatmap'>Animated Heatmap with Heatmap.js</a></li>
      
    
  
    
      
        <li><a href='/blog/2014/09/26/traffic-light-with-electric-imp'>Build a physical "Traffic Light"</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2014/05/31/google-maps'>Google Maps Mashup</a></li>
      
    
  
    
      
        <li><a href='/blog/2014/05/31/google-kml'>Google Maps with KML</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2013/08/13/simple-chart-with-d3'>Simple column chart with D3</a></li>
      
    
  

  <li class="nav-header dropdown-header">SDKs &amp; Libraries</li>
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/allejo/PhpSoda" rel="external">PhpSoda</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/soda-android-sdk" rel="external">Google Android</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/CityofSantaMonica/SODA.NET" rel="external">.NET</a></li>
      
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/datasync" rel="external">DataSync SDK (Java)</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/rozap/exsoda" rel="external">Elixr</a></li>
      
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/zachgarwood/ember-socrata" rel="external">ember-socrata</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/SebastiaanKlippert/go-soda" rel="external">go-soda</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/soda-ios-sdk" rel="external">Apple iOS</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://github.com/socrata/soda-java" rel="external">Java</a></li>
      
    
  
    
      
        <li><a href="https://github.com/socrata/soda-js" rel="external">javascript</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/drewgendreau/Socrata.jl" rel="external">Julia</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://github.com/socrata/soda-php" rel="external">PHP</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/Socrata-PowerShell" rel="external">PowerShell</a></li>
      
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/socrata-py" rel="external">Python (Dataset Management API)</a></li>
      
    
  
    
      
        <li><a href="https://github.com/xmunoz/sodapy" rel="external">Python</a></li>
      
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/Chicago/RSocrata" rel="external">R</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/soda-ruby" rel="external">Ruby</a></li>
      
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/soda-scala" rel="external">Scala</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/soda-swift" rel="external">Swift</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  



  </ul>
</li>

<li class="dropdown ">
  <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-fw fa-cloud-upload"></i>Data Publishers <i class="fa fa-caret-down"></i></a>
  <ul class="dropdown-menu">
    
  <li class="nav-header dropdown-header">Data Publishers</li>
  <li><a href="/publishers/">Publisher Guide</a></li>

  <li class="nav-header dropdown-header">APIs for Publishing Data</li>
  <li><a href='/publishers/soda-producer/soda-producer-basics'>SODA Producer API</a></li>
  <li><a href='/publishers/dsmapi'>Dataset Management API</a></li>
  <li><a href="/publishers/import/">Import API</a></li>

  <li class="nav-header dropdown-header">Tools &amp; Connectors</li>
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://socrata.github.io/connectors/" rel="external">Connectors &amp; ETL Templates</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/connectors/pentaho-kettle'>Pentaho Kettle</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/connectors/rsocrata'>RSocrata</a></li>
      
    
  
    
  
    
  
    
      
        <li><a href='/connectors/safe-fme'>Safe FME</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://socrata.github.io/datasync/" rel="external">Socrata Datasync</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  

  <li class="nav-header dropdown-header">SDKs &amp; Libraries</li>
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/allejo/PhpSoda" rel="external">PhpSoda</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/CityofSantaMonica/SODA.NET" rel="external">.NET</a></li>
      
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/datasync" rel="external">DataSync SDK (Java)</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/zachgarwood/ember-socrata" rel="external">ember-socrata</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/SebastiaanKlippert/go-soda" rel="external">go-soda</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://github.com/socrata/soda-java" rel="external">Java</a></li>
      
    
  
    
      
        <li><a href="https://github.com/socrata/soda-js" rel="external">javascript</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://github.com/socrata/soda-php" rel="external">PHP</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/Socrata-PowerShell" rel="external">PowerShell</a></li>
      
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/socrata-py" rel="external">Python (Dataset Management API)</a></li>
      
    
  
    
      
        <li><a href="https://github.com/xmunoz/sodapy" rel="external">Python</a></li>
      
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/Chicago/RSocrata" rel="external">R</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="https://github.com/socrata/soda-ruby" rel="external">Ruby</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  

  <li class="nav-header dropdown-header">Examples</li>
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2017/01/03/visualizing-data-using-google-calendar-chart'>Visualizing data using the Google Calendar Chart</a></li>
      
    
  
    
      
        <li><a href='/blog/2017/01/03/scrubbing-data-with-python'>Scrubbing data with Python</a></li>
      
    
  
    
      
        <li><a href='/blog/2017/01/03/gauge-visualizations-using-the-google-charts-library'>Gauge Visualizations using the Google Charts library</a></li>
      
    
  
    
  
    
      
        <li><a href='/blog/2016/10/28/pulling-data-from-hadoop'>Pulling data from Hadoop and Publishing to Socrata</a></li>
      
    
  
    
      
        <li><a href='/blog/2016/08/30/pentaho-kettle-data-integration'>Using Pentaho to Read data from Salesforce and Publish to Socrata</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2016/03/17/ssis-socrata-datasync'>Using a SSIS to write to a Socrata Dataset</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2015/05/29/pentaho-kettle-etl-kit'>Pentaho Kettle ETL Toolkit</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2015/02/09/wufoo-to-socrata'>Using a Wufoo form to write to a Socrata Dataset</a></li>
      
    
  
    
  
    
      
        <li><a href='/blog/2015/01/11/soda-sensor-push'>Pushing Sensor Data to Socrata</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href='/blog/2014/10/09/fme-socrata-writer'>Using the FME Socrata Writer</a></li>
      
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      
        <li><a href="http://socrata.github.io/soda-ruby/examples/upsert.html" rel="external">Upsert via soda-ruby</a></li>
      
    
  
    
  
    
  



  </ul>
</li> 

<li class="dropdown ">
  <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-fw fa-book"></i>API Docs <i class="fa fa-caret-down"></i></a>
  <ul class="dropdown-menu">
    
  <li class="nav-header dropdown-header">Overview</li>
  <li><a href='/docs/endpoints'>API Endpoints</a></li>
  <li><a href='/docs/row-identifiers'>Row Identifiers</a></li>
  <li><a href='/docs/verbs'>RESTful Verbs</a></li>
  <li><a href='/docs/app-tokens'>Application Tokens</a></li>
  <li><a href='/docs/authentication'>Authentication</a></li>
  <li><a href='/docs/response-codes'>Response Codes &amp; Headers</a></li>
  <li><a href='/docs/system-fields'>System Fields</a></li>
  <li><a href='/docs/cors-and-jsonp'>CORS &amp; JSONP</a></li>
  

  <li class="nav-header dropdown-header">Filtering &amp; Querying</li>
  <li><a href='/docs/filtering'>Simple Filters</a></li>
  <li><a href="/docs/queries/">SoQL Queries</a></li>
  <li><a href='/docs/paging'>Paging Through Data</a></li>
  <li><a href="/docs/functions/">SoQL Function and Keyword Listing</a></li>
  <li><a href="/docs/transforms/">Data Transform Functions</a></li>

  <li class="nav-header dropdown-header"><a href="/docs/formats/">Data Formats</a></li>
  <li class="dropdown-hide"><a href='/docs/formats/json'>JSON</a></li>
  <li class="dropdown-hide"><a href='/docs/formats/geojson'>GeoJSON</a></li>
  <li class="dropdown-hide"><a href='/docs/formats/csv'>CSV</a></li>
  <li class="dropdown-hide"><a href='/docs/formats/rdf-xml'>RDF-XML</a></li>

  <li class="nav-header dropdown-header"><a href="/docs/datatypes/">Datatypes</a></li>
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/checkbox'>Checkbox</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/fixed_timestamp'>Fixed Timestamp</a></li>
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/floating_timestamp'>Floating Timestamp</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/line'>Line</a></li>
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/location'>Location</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/multiline'>MultiLine</a></li>
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/multipoint'>MultiPoint</a></li>
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/multipolygon'>MultiPolygon</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/number'>Number</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/point'>Point</a></li>
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/polygon'>Polygon</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/text'>Text</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
      <li class="dropdown-hide"><a href='/docs/datatypes/url'>URL</a></li>
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
    
  
  

  <li class="nav-header dropdown-header"><a href="/docs/other/">Other APIs</a></li>



  </ul>
</li> 
<li class="">
  <a href="/libraries/"><i class="fa fa-fw fa-github-alt"></i>Libraries &amp; SDKs</a>
</li> 

          </ul>
        </div><!--/.nav-collapse -->
      </div>
    </div>

    <div id="acquisition-notice" class="alert forge-banner">
      <div class="forge-banner__container">
        <div class="forge-banner__container-wrapper">
          <div class="forge-banner__container-wrapper-icon">
            <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24" part="svg"><path d="M0 0h24v24H0V0z" fill="none" part="path"></path><path d="M11 7h2v2h-2V7zm0 4h2v6h-2v-6zm1-9C6.48 2 2 6.48 2 12s4.48 10 10 10 10-4.48 10-10S17.52 2 12 2zm0 18c-4.41 0-8-3.59-8-8s3.59-8 8-8 8 3.59 8 8-3.59 8-8 8z" part="path"></path></svg>
          </div>
          <div class="forge-banner__container-wrapper-subsection" part="subsection-wrapper">
            <div class="forge-banner__container-wrapper-subsection-text forge-typography--body1" part="subsection-text">
              Socrata was acquired by Tyler Technologies in 2018 and is now the Data and Insights division of Tyler. The platform is still powered by the same software formerly known as Socrata but you will see references to Data &amp; Insights going forward.
            </div>
            <div class="forge-banner__container-wrapper-subsection-action" part="action-subsection">
              <a href="https://www.tylertech.com/solutions/transformative-technology/data-insights">
                <button type="button" class="forge-button forge-button--outlined mdc-ripple-upgraded">Learn more...<span class="forge-button__ripple"></span></button>
              </a>
            </div>
          </div>
        </div>
      </div>
    </div>

    <div id="socrata-status" class="alert" style="display: none;">
      <div class="container">
        <i class="fa fa-warning"></i>
        <strong><span class="message"></span></strong>:
        For more information see <a href="http://status.socrata.com">status.socrata.com</a>.
      </div>
    </div>

    <div class="container-fluid content">
      

      <div id="branding"></div>
<h1 id="title"></h1>
<div id="splash" style="display: none"></div>
<div id="foundry-docs"></div>


      <footer class="muted">
        <hr />
        <a rel="license" href="http://creativecommons.org/licenses/by-nc-sa/3.0/deed.en_US">
          <img alt="Creative Commons License" src="https://licensebuttons.net/l/by-nc-sa/3.0/80x15.png" />
        </a>

        Licensed by <a xmlns:cc="http://creativecommons.org/ns#" href="https://www.tylertech.com/solutions/transformative-technology/data-insights" property="cc:attributionName" rel="cc:attributionURL">Tyler Technologies</a>
        under <a rel="license" href="http://creativecommons.org/licenses/by-nc-sa/3.0/deed.en_US">CC BY-NC-SA 3.0</a>. Learn how <a href='/contributing'>you can contribute!</a>
      </footer>
    </div> <!-- /container -->

    
      <!-- Dump in our site config -->
      <script type="text/javascript">
          var flags = {"show_migration":true, "peeper":{"img":"/img/peeper.png", "link":"/support.html", "delay":4000}}
      </script>
    
  </body>
</html>
