Skip to content

Instantly share code, notes, and snippets.

We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 19 columns, instead of 7 in line 4.
Community Area Name,Community Area Number,Property Type,Property Name,Address,Zip Code,Phone Number,Management Company,Units,X Coordinate,Y Coordinate,Latitude,Longitude,Location,Historical Wards 2003-2015,Wards,Community Areas,Zip Codes,Census Tracts
Edgewater,77,Multifamily,Winthrop Apts.,6214 N. Winthrop Ave.,60660,773-477-7070,Hunter Properties,108,1167688.7086010627,1941496.3681431552,41.9950154576,-87.6585160357,"(41.9950154576, -87.6585160357)",40,16,76,4451,45
North Lawndale,29,Multifamily,Resurrection Homes,1910 S. Albany Ave.,60623,312-248-8355,The Resurrection Project,2,1155952.7147554972,1890430.854230329,41.8551333961,-87.7030673957,"(41.8551333961, -87.7030673957)",36,14,30,21569,132
Lakeview,6,Senior,Renaissance St. Luke Greenview Place,1501 W. Melrose St.,60657,773-525-1501,"RRG Development, Inc.",155,1165704.8480373912,1921625.293870648,41.9405311557,-87.6663826053,"(41.9405311557, -87.6663826053)",38,25,57,4449,678
West Pullman,53,Senior,All Saints Senior Residence,11701 S. State St.,60628,3
police_beat colissions
3 1
20 2
21 1
24 1
26 1
55 1
71 1
111 357
112 126
@milafrerichs
milafrerichs / abs-licenses-casnd.csv
Created March 21, 2019 15:07
Solar Permits San Diego
We can't make this file beautiful and searchable because it's too large.
"last_date","OGC_FID","GEOMETRY","licenses_id","scrape_date","licenseno","status","licensetype","issuedate","exprdate","owner","premisesaddress","segments_id","lon","lat","x","y","city","neighborhood","community","council","tract","business","mailaddress","gcquality","gctype"
"2013-07-09T",1,"","","2013-07-09T",413,"ACTIVE",51,"1951-07-20T","2014-03-31T","MISSION BAY YACHT CLUB INC","1215 EL CARMEL PL, SAN DIEGO, CA 92109",-1,-117.248361242,32.7778467173,6254804.29475,1864266.24383,"NONE","NONE","NONE","NONE","0076.00","","",0,"cns/address"
"2013-07-09T",2,"","","2013-07-09T",1414,"ACTIVE",41,"1978-06-05T","2014-04-30T","FICANO, CONNIE M","9349 MIRA MESA BLVD, SAN DIEGO, CA 92126",-1,-117.123422617,32.9167545657,6293628.59978,1914460.91829,"SndSAN","NONE","NONE","NONE","0083.59","Capriccio Italian Restaurant","",0,"cns/address"
"2013-07-09T",3,"","","2013-07-09T",1419,"ACTIVE",21,"1964-08-18T","2013-09-30T","A O K ENTERPRISES INC","3744 OCEAN VIEW BLVD, SAN DIEGO, CA 92113",-1,-117.113723001,32.7015239712,
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
language: node_js
node_js:
- "10"
# Turns on newer container-based infrastructure
# This generates a sudo warning with mongodb below, see here: https://github.com/travis-ci/travis-ci/issues/3044
sudo: false
env:
global:
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
{
"$schema": "https://vega.github.io/schema/vega-lite/v3.json",
"description": "A simple bar chart with embedded data.",
"width": 600,
"data": {
"values": [{ "name": "Thursday, 6am", "time": 185.000000, "avg": 20.09 },
{ "name": "Sunday, 5am", "time": 87.000000, "avg": 20.09 },
{ "name": "Saturday, 5am", "time": 70.250000, "avg": 20.09 },
{ "name": "Friday, 5am", "time": 46.750000, "avg": 20.09 },
{ "name": "Wednesday,9pm", "time": 41.000000, "avg": 20.09 }]
o weekday mean count
0 Sunday 2.1279472558802586 1403
1 Monday 1.6992589641434273 1255
2 Tuesday 1.678251582278482 1264
3 Wednesday 1.6827566807313659 1422
4 Thursday 1.6591638795986645 1495
5 Friday 2.107544776119401 1340
6 Saturday 2.2442722451384802 1697
road_segment time Sum of bike
20036 10:00 25.0
20036 11:00 29.0
20036 12:00 55.0
20036 13:00 51.0
20036 14:00 49.0
20036 15:00 61.0
20036 16:00 94.0
20036 17:00 111.0
20036 18:00 96.0