Chris Metcalf chrismetcalf
chrismetcalf
/ gist:1352704
Created
November 9, 2011 19:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| * 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: */* | |
| > |
chrismetcalf
/ gist:1352701
Created
November 9, 2011 19:45
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <html><body>You are being <a href="http://nycopendata.socrata.com/api/file_data/RmDbuOaF2Ix4qRBCywjyAQoeRy55Hz8L2kQHZy8R3Mc?filename=DCP_POPS.zip.uoaf2ix4qrbcywjyaqoery55hz8l2kqhzy8r3mc">redirected</a>.</body></html> |
chrismetcalf
/ control.json
Created
November 9, 2011 00:58
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "skip" : 0, | |
| "idColumnIndex" : 0, | |
| "appendOnly" : true, | |
| "publishOnComplete" : false, | |
| "fixedWidthFields" : { | |
| "System" : "4", | |
| "Doc Ref ID" : "20", | |
| "Doc Version" : "20", | |
| "Check Amount" : "22", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package com.socrata.demo; | |
| import java.io.IOException; | |
| import java.io.StringReader; | |
| import com.socrata.api.Connection; | |
| import com.socrata.api.HttpConnection; | |
| import com.socrata.api.RequestException; | |
| import com.socrata.data.View; | |
| import com.socrata.data.View.Row; |
chrismetcalf
/ gist:1341894
Created
November 5, 2011 19:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package com.saxon.demo; | |
| 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 Creator { |
chrismetcalf
/ gist:1341887
Created
November 5, 2011 19:04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Name,Age,Allowance | |
| Chris,30,$75.00 | |
| Sam,12,$15.00 | |
| Sue,8,$10.00 |
chrismetcalf
/ gist:1341870
Created
November 5, 2011 18:46
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Connect to the API | |
| String domain = "saxon.socrata.com"; | |
| String username = "<youremail>"; | |
| String password = "<yourpass>"; | |
| String appToken = "<yourapptoken>"; | |
| Connection connection = new HttpConnection(domain, username, password, appToken); | |
| // Connect to the view | |
| View view = View.find("ry7h-n6bk", connection); |
chrismetcalf
/ csv-to-tsv
Created
October 9, 2011 19:24
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/sh | |
| # Gist doesn't like the tab character for some reason, so replace it with an actual tab (ctrl-v, tab) | |
| sed 's/<tab>//' | sed 's/ //g' | sed 's/^"//' | sed 's/","/ /g' | sed 's/"$//' | sed 's/"//g' |
chrismetcalf
/ RecordCount.java
Created
October 6, 2011 13:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package com.socrata.geotoolbox; | |
| import au.com.bytecode.opencsv.CSVReader; | |
| import joptsimple.OptionParser; | |
| import joptsimple.OptionSet; | |
| import java.io.FileReader; | |
| import java.io.InputStreamReader; | |
| public class RecordCount { | |
| public static void main(String[] args) throws Exception { |
chrismetcalf
/ gist:1144714
Created
August 14, 2011 08:43
Compile a batch of JPEGs into a time-lapse movie
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ffmpeg -i "%05d.JPG" -vcodec libx264 -crf 20 -threads 0 video.mp4 |