Skip to content

Instantly share code, notes, and snippets.

View chrismetcalf's full-sized avatar

Chris Metcalf chrismetcalf

View GitHub Profile
@chrismetcalf
chrismetcalf / acapps_2012_snippets.md
Created December 8, 2012 06:52
#acApps 2012 Code Snippets

#acApps 2012 Code Cookbook

Big congrats to our winners!

Handy Tools & Resources

package com.socrata.school.api;
import java.io.File;
import com.socrata.api.Connection;
import com.socrata.api.HttpConnection;
import com.socrata.api.RequestException;
import com.socrata.data.View;
public class BulkUpdate {
package com.socrata.school.api;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.socrata.api.Connection;
import com.socrata.api.HttpConnection;
@chrismetcalf
chrismetcalf / lexington_example.rb
Created August 2, 2012 00:03
Sample code for the Kentucky Ruby User Group
#!/usr/bin/env ruby
# Just a simple demo on how to use SODA 2.0 to access data from a Socrata data site
require 'net/http'
require 'uri'
require 'json'
require 'cgi'
require 'pp'
# Just a helper class
@chrismetcalf
chrismetcalf / gist:3132216
Created July 17, 2012 21:26
Hawaii Developer Training Example
package gov.hawaii.data.demo;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.socrata.api.Connection;
import com.socrata.api.HttpConnection;
[ {
"content" : {
"id" : "apps-plate",
"contextId" : "foods",
"children" : [ {
"text" : "Choose a Food",
"type" : "Title"
}, {
"type" : "Text"
} ],
// Location value is special
double latitude = (rand.nextInt(180000)/1000.0) - 90.0;
double longitude = (rand.nextInt(360000)/1000.0) - 180.0;
Map<String, Double> location = new HashMap<String,Double>();
location.put("latitude", latitude);
location.put("longitude", longitude);
r.putDataField(v.getColumnByApiIdentifier("location"), location);
function! HtmlEntities()
silent %s/À/\&Agrave;/eg
silent %s/Á/\&Aacute;/eg
silent %s/Â/\&Acirc;/eg
silent %s/Ã/\&Atilde;/eg
silent %s/Ä/\&Auml;/eg
silent %s/Å/\&Aring;/eg
silent %s/Æ/\&AElig;/eg
silent %s/Ç/\&Ccedil;/eg
silent %s/È/\&Egrave;/eg
* About to connect() to nycopendata.socrata.com port 80 (#0)
* Trying 216.227.229.140... % Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0connected
* Connected to nycopendata.socrata.com (216.227.229.140) port 80 (#0)
> GET /download/fum3-ejky/application%252Fzip HTTP/1.1
> User-Agent: curl/7.21.4 (universal-apple-darwin11.0) libcurl/7.21.4 OpenSSL/0.9.8r zlib/1.2.5
> Host: nycopendata.socrata.com
> Accept: */*
>