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
{ | |
"version": "2", | |
"header": { | |
"title": "NYC 311 Data", | |
"description": "The last 3 million NYC 311 complaints", | |
"navigation": [ | |
{ | |
"label": "Download", | |
"url": "" | |
} |
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
-- PostgreSQL | |
-- combine data for all years into one table | |
-- to find distinct addresses & BBL numbers | |
create table dhcr_all ( | |
zip integer, | |
bldgno1 text, | |
street_name1 text, | |
street_suffix1 text, | |
bldgno2 text, | |
street_name2 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
Select ST_AsText( | |
ST_Transform( | |
ST_SetSRID( | |
ST_MakePoint(xcoord,ycoord), | |
2263) | |
, 4326) | |
) from nyc_pluto limit 10; | |
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
############################## | |
# _ | |
# | |_ _ __ ___ _ ___ __ | |
# | __| '_ ` _ \| | | \ \/ / | |
# | |_| | | | | | |_| |> < | |
# \__|_| |_| |_|\__,_/_/\_\ | |
# | |
############################# | |
############################################################################ |
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 os import path | |
import re | |
import requests | |
url_template = "http://thenounproject.com/download/zipped/svg_%d.zip" | |
base_dir = path.dirname(path.abspath(__file__)) | |
svg_dir = path.join(base_dir, 'svg') | |
pattern = re.compile(r'<svg.*/svg>', re.DOTALL) | |
for x in xrange(1, 300): |