Skip to content

Instantly share code, notes, and snippets.

View aidanwaugh's full-sized avatar

Aidan Waugh aidanwaugh

  • Canada
View GitHub Profile
@aidanwaugh
aidanwaugh / PublicArt_VanTor_COMBO.csv
Last active April 14, 2019 02:45
We can't make this file beautiful and searchable because it's too large.
City,TitleOfWork,YearOfInstallation,Status,DescriptionOfwork,ArtistProjectStatement,SiteName,SiteAddress,Neighbourhood,ProximityLevel,Latitude,Longitude,LocationOnsite,Type,PrimaryMaterial,Ownership,URL,PhotoURL,PhotoCredits,Artists,RegistryID
Vancouver,Queen Victoria Memorial Drinking Fountain,1905,In place,,,,Stanley Park,Stanley Park,3,49.297138,-123.134314,Facing entrance to Vancouver Rowing Club,Fountain,"Granite, bronze",City of Vancouver,https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=82,https://covapp.vancouver.ca/PublicArtRegistry/ImageDisplay.aspx?AreaId=82&ImageId=63,,16,82
Vancouver,Chehalis Cross,1906,In place,A heritage monument to the eight who died on the steam driven tug boat Chehalis in 1906.,,Brockton Point,Stanley Park,Stanley Park,3,49.299862,-123.118001,Left of road past lighthouse,Memorial,,City of Vancouver,https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=96,https://covapp.vancouver.ca/PublicArtRegistry/ImageDisplay.aspx?AreaId=96&I
@aidanwaugh
aidanwaugh / TorontoPublicArt.csv
Created April 12, 2019 14:50
City TitleOfWork YearOfInstallation Status DescriptionOfwork ArtistProjectStatement SiteName SiteAddress Neighbourhood Latitude Longitude LocationOnsite Type PrimaryMaterial Ownership URL PhotoURL PhotoCredits Artists RegistryID
Toronto Planters 1992 Trinity- Spadina 313744.473 4833807.374 Ceramic CERAMIC MORIYAMA, JONI PLANTERS
Toronto Spacing... Aerial Highways 1977 Eglinton-Lawrence 309291.197 4841522.661 Ceramic CERAMIC TILE BREEZE, CLAUDE SPACING... AERIAL HIGHWAYS
Toronto Passing 2002 Willowdale 314742.335 4847531.573 Ceramic CERAMIC TILE BELANGER, SYLVIE PASSING
Toronto From Here Right Now 2002 Willowdale 313818.304 4847246.679 Ceramic CERAMIC TILE, TERRAZZO ESPINAL, PANYA CLARK FROM HERE RIGHT NOW
Toronto Bayview Underpass 1961 Don Valley West 314280.898 4842871.865 Concrete CONCRETE SINGLETON, G.A. BAYVIEW UNDERPASS
Toronto Pylon 1960 Toronto-Danforth 318495.767 4838896.812 Concrete CONCRETE, BRONZE GLADSTONE, GERALD PY
@aidanwaugh
aidanwaugh / VancouverPublicArt.csv
Created April 12, 2019 14:46
We can't make this file beautiful and searchable because it's too large.
City,TitleOfWork,YearOfInstallation,Status,DescriptionOfwork,ArtistProjectStatement,SiteName,SiteAddress,Neighbourhood,Latitude,Longitude,LocationOnsite,Type,PrimaryMaterial,Ownership,URL,PhotoURL,PhotoCredits,Artists,RegistryID
Vancouver,Captain George Vancouver,1936,In place,"A full figure bronze statue of Captain George Vancouver stands on the north side of City Hall, pointing towards Vancouver harbour and holding a partially open scroll in his left hand. The figure commemorates the events of 1792, when Captain George, a representative of King George III of England, sailed into Burrard Inlet and charted the area.","A new city hall and a statue of Captain George Vancouver were commissioned to commemorate Vancouver's Golden Jubilee in 1936. The architect of the new City Hall at Strathcona Park on West 12th Avenue, Fred Townley, proposed the sculpture, commissioned by the Vancouver Canadian Club, be placed on the plaza on the north side of the building. Noted BC sculptor, Charles Marega, was commissioned (for
@aidanwaugh
aidanwaugh / gist:f222625852351a7cb9ec453ccab8605f
Last active March 22, 2019 02:26
Neighbourhood,PopTotal,0 to 14 years,0 to 4 years,5 to 9 years,10 to 14 years,Age 15 to 64,15 to 19 years,20 to 24 years,25 to 29 years,30 to 34 years,35 to 39 years,40 to 44 years,45 to 49 years,50 to 54 years,55 to 59 years,60 to 64 years,65 years and over,65 to 69 years,70 to 74 years,75 to 79 years,80 to 84 years,85 years and over,85 to 89 years,90 to 94 years,95 to 99 years,100 years and over,ArtCount,0 to 14 years,15 to 29 years,30 to 44 years,45 to 59 years,60 to 74 years,75 to 90 years,90 years and over,Total - Distribution (%) of the population by broad age groups - 100% data,0 to 14 years,15 to 64 years,65 years and over,85 years and over
Arbutus-Ridge ,15295,2015,455,685,880,9805,1230,1165,805,570,560,965,1350,1310,920,935,3480,915,635,590,525,810,430,270,90,20,2,2015,13005,2095,3580,2485,1545,380,100,13.2,64.1,22.7,5.3
Downtown ,62030,4000,2080,1105,810,51275,1180,4050,8810,9750,6620,4755,4610,4160,3970,3365,6760,2640,1710,1095,700,615,390,170,45,10,202,4000,65315,21125,12740,7715,2185,225,100,6.5
@aidanwaugh
aidanwaugh / public_artEDITED.csv
Created March 1, 2019 02:09
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
RegistryID,TitleOfWork,YearOfInstallation,Status,DescriptionOfwork,ArtistProjectStatement,SiteName,SiteAddress,Neighbourhood,Latitude,Longitude,LocationOnsite,Type,PrimaryMaterial,Ownership,URL,PhotoURL,PhotoCredits,Artists
444,Everything Is Going To Be Alright,2009,In place,Neon text affixed to the restored masonry parapet of the southern fa�ade of the six storey portion of the building. The art piece is set back from the three storey Pender fa�ade but visible from farther vistas.,,The Wing Sang Building,51 East Pender Street,DowntownEastside,49.280538,-123.103112,Southern fa�ade of the six storey portion of the building,Site Work,"15 mm diameter, single tube white neon",Bob Rennie,https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=444,https://covapp.vancouver.ca/PublicArtRegistry/ImageDisplay.aspx?AreaId=444&ImageId=356,http://www.renniecollection.org,325
650,Tidal Pool,2016,Removed,"The film Tidal Pool by Curtis Grahauer represents New Brighton Park in Vancouver as a point of artic
@aidanwaugh
aidanwaugh / weather.csv
Last active March 1, 2019 01:41
YearOfInstallation precipitation Latitude Longitude wind Type Neighbourhood
01/01/2012 0 12.8 5 4.7 drizzle Vancouver
02/01/2012 10.9 10.6 2.8 4.5 rain Vancouver
03/01/2012 0.8 11.7 7.2 2.3 rain Vancouver
04/01/2012 20.3 12.2 5.6 4.7 rain Vancouver
05/01/2012 1.3 8.9 2.8 6.1 rain Vancouver
06/01/2012 2.5 4.4 2.2 2.2 rain Vancouver
07/01/2012 0 7.2 2.8 2.3 rain Vancouver
08/01/2012 0 10 2.8 2 sun Vancouver
09/01/2012 4.3 9.4 5 3.4 rain Vancouver
@aidanwaugh
aidanwaugh / public_art.csv
Created February 16, 2019 17:43
vancouver_public_art
We can't make this file beautiful and searchable because it's too large.
RegistryID,TitleOfWork,YearOfInstallation,Status,DescriptionOfwork,ArtistProjectStatement,SiteName,SiteAddress,Neighbourhood,Latitude,Longitude,LocationOnsite,Type,PrimaryMaterial,Ownership,URL,PhotoURL,PhotoCredits,Artists
1,Captain George Vancouver,1936,In place,"A full figure bronze statue of Captain George Vancouver stands on the north side of City Hall, pointing towards Vancouver harbour and holding a partially open scroll in his left hand. The figure commemorates the events of 1792, when Captain George, a representative of King George III of England, sailed into Burrard Inlet and charted the area.","A new city hall and a statue of Captain George Vancouver were commissioned to commemorate Vancouver's Golden Jubilee in 1936. The architect of the new City Hall at Strathcona Park on West 12th Avenue, Fred Townley, proposed the sculpture, commissioned by the Vancouver Canadian Club, be placed on the plaza on the north side of the building. Noted BC sculptor, Charles Marega, was commissioned (for about $5500)
@aidanwaugh
aidanwaugh / pctstats.csv
Created February 1, 2019 17:32
PCT
Year,Completed,Attempted,Deaths
1983,11,0,3
1984,16,27,
1985,11,18,
1986,4,7,
1987,27,45,
1988,31,52,
1989,27,45,
1990,26,43,
1991,32,53,
@aidanwaugh
aidanwaugh / cameras gist.csv
Created January 28, 2019 18:44
camera
Model Manufacturer Release date Max resolution Low resolution Effective pixels Zoom wide (W) Zoom tele (T) Normal focus range Macro focus range Storage included Weight (inc. batteries) Dimensions Price
Agfa ePhoto CL50 Agfa 1999 1280 640 1 34 102 0 0 8 0 0 179
Agfa ePhoto CL18 Agfa 2000 640 0 0 45 45 0 0 2 0 0 179
Epson PhotoPC 850 Zoom Epson 1999 1600 640 1 35 105 0 0 0 0 0 229
Agfa ePhoto CL30 Agfa 1999 1152 640 0 35 35 0 0 4 0 0 269
Contax N Digital Contax 2000 3040 0 6 0 0 0 0 0 0 152 549
Sony Mavica FD-100 Sony 2002 1280 1024 1 37 111 0 0 1 0 0 1399
Sony Mavica FD-85 Sony 2000 1280 1280 1 37 111 1 1 1 0 0 1399
Sony Mavica FD-90 Sony 2000 1280 1280 1 34 270 4 4 1 0 0 1399
Pentax Optio Z10 Pentax 2007 3264 2592 8 38 266 40 8 0 0 94 249
@aidanwaugh
aidanwaugh / sleepdata.csv
Created January 28, 2019 05:01
We can make this file beautiful and searchable if this error is corrected: No commas found in this CSV file in line 0.
Start;End;Sleep quality;Time in bed;Wake up;Sleep Notes;Heart rate;Activity (steps)
2017-06-13 22:31:26;2017-06-14 04:23:10;52%;5:51;;;0;1058
2017-06-14 20:39:37;2017-06-15 05:39:54;82%;9:00;;;0;1362
2017-06-15 21:22:38;2017-06-16 04:18:41;77%;6:56;;;0;681
2017-06-18 21:28:06;2017-06-19 04:20:39;57%;6:52;;;0;4540