This file contains 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
| results | BASE TABLE | | |
| resultview3 | VIEW | | |
| resultview_sub1 | BASE TABLE | | |
| resultview_sub2 | BASE TABLE | | |
| resultview_sub3 | BASE TABLE | | |
| resultview_sub3a | BASE TABLE | | |
RESULTSVIEW3 is confirmed to be a view | |
mysql> select * from trackertouse; |
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
This file contains 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
brew install ffmpeg --with-libvorbis, --with-libvpx, --with-theora, --with-opus, --with-x265, --with-fdk-aac --with-ffplay, --with-freetype, --with-libass, --with-libquvi | |
ffmpeg -f gif -i YOURGIF.gif -vcodec libx264 -pix_fmt yuv420p YOURMP4.mp4 | |
ffmpeg -i YOURMP4.mp4 -c:v libvpx -b:v 1M -c:a libvorbis YOURWEBM.webm | |
#bonus cool js library | |
#http://gka.github.io/canvid/ |
This file contains 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
task :jsonify_timeline => :environment do | |
require 'csv' | |
require 'json' | |
require 'open-uri' | |
def scrub(text) | |
if text.include? '--' | |
text = text.gsub(/--/, '—') | |
end | |
return text |
This file contains 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
from BeautifulSoup import BeautifulSoup | |
from datetime import datetime | |
import itertools | |
import requests | |
import os | |
directory = "medill-scraper/data/scrapes/%s/" % (datetime.now().strftime("%m-%d-%Y")) | |
if not os.path.exists(directory): | |
os.makedirs(directory) |
This file contains 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
/* | |
requires: phantomjs, async | |
usage: phantomjs index.js | |
*/ | |
var async = require('async'); | |
var sites = [ | |
['zaller', 'https://www.baycitizen.org/blogs/sandbox/digital-maps-low-cost-fighting-wildfires/'], | |
['binladen-pg-2', 'https://www.baycitizen.org/news/osama-bin-laden/san-francisco-vs-usa-rift-emerges-bin/?page=1'], |
This file contains 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
var legend = function(r, notes, fmt, label, points){ | |
notes.append("svg:circle") | |
.attr("cy", 40 + r(points[2])) | |
.attr("cx", 0) | |
.attr("r", r(points[2])) | |
.style("stroke", "#444455") | |
.style("stroke-width", "1") | |
.style("fill", "none"); | |
notes.append("svg:circle") | |
.attr("cy", 40 + r(points[1])) |
This file contains 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
var margin = {top: 20, left: 50, right: 50, bottom: 50}, | |
w = 700 - margin.left - margin.right, | |
h = 500 - margin.top - margin.bottom; | |
var ygetter = function(d){return d.value;}; | |
var f = d3.format(",.0f"); | |
var barPadding = 10; | |
var colWidth = (w / data.length) - barPadding; | |
var colSpace = w / data.length; |
This file contains 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
/************************************************************************** | |
* OSM2GEO - OSM to GeoJSON converter | |
* OSM to GeoJSON converter takes in a .osm XML file as input and produces | |
* corresponding GeoJSON object. | |
* | |
* AUTHOR: P.Arunmozhi <[email protected]> | |
* DATE : 26 / Nov / 2011 | |
* LICENSE : WTFPL - Do What The Fuck You Want To Public License | |
* LICENSE URL: http://sam.zoy.org/wtfpl/ | |
* |
This file contains 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
var slugify = function(input){ | |
return input | |
.toLowerCase() | |
.replace(/ /g,'-') | |
.replace(/[^\w-]+/g,''); | |
}; |