Included Vancouver Open Data crime-adjacent civic datasets
Source:R/datasets_vancouver.R
vancouver_crime_adjacent.RdPhase 3DDD1. Five small fixtures harvested live from
opendata.vancouver.ca for offline reproducibility – chosen to
surface neighbourhood-level civic context useful in carceral /
policing analysis even though VPD itself publishes crime data
separately (see morie_datasets_vpd_crime()).
Phase 3EEE3. Included 27-row snapshot of City-run community centres. Useful as an "anchor institutions" overlay for analyses of neighbourhood-level crime + social-service access.
Phase 3EEE3. Included 91-row snapshot of community + farmers markets across Vancouver. Useful for food-access / quality-of-life overlays.
Phase 3EEE3. Included 100-row sample of designated disability parking locations across Vancouver (out of 159 total).
Phase 3EEE3. Included 100-row sample of Vancouver's public art registry (out of 747 total) – artist, install year, neighbourhood, primary material. Useful as a CPTED-style "place-making" overlay variable.
Usage
morie_datasets_vancouver_graffiti(offline = TRUE, max_features = NULL)
morie_datasets_vancouver_noise_control_areas(
offline = TRUE,
max_features = NULL
)
morie_datasets_vancouver_homeless_shelters(offline = TRUE, max_features = NULL)
morie_datasets_vancouver_property_use_inspection_districts(
offline = TRUE,
max_features = NULL
)
morie_datasets_vancouver_fire_halls(offline = TRUE, max_features = NULL)
morie_datasets_vancouver_community_centres(offline = TRUE, max_features = NULL)
morie_datasets_vancouver_community_food_markets(
offline = TRUE,
max_features = NULL
)
morie_datasets_vancouver_disability_parking(
offline = TRUE,
max_features = NULL
)
morie_datasets_vancouver_public_art(offline = TRUE, max_features = NULL)Value
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
A data.frame of the requested dataset (a 0-row typed frame when the data is unavailable offline).
Details
| Loader | Dataset slug | Rows |
morie_datasets_vancouver_graffiti() | graffiti | 100 (of 7683) |
morie_datasets_vancouver_noise_control_areas() | noise-control-areas | 3 |
morie_datasets_vancouver_homeless_shelters() | homeless-shelter-locations | 17 |
morie_datasets_vancouver_property_use_inspection_districts() | property-use-inspection-districts | 23 |
morie_datasets_vancouver_fire_halls() | fire-halls | 20 |
All loaders accept the same offline = TRUE (default) /
max_features interface as the other morie dataset wrappers.
Examples
df <- morie_datasets_vancouver_graffiti()
head(df)
#> count geo_local_area lon lat
#> 1 1 Kitsilano -123.1693 49.26434
#> 2 1 Downtown -123.1225 49.27870
#> 3 2 Hastings-Sunrise -123.0438 49.27014
#> 4 2 Kitsilano -123.1706 49.26437
#> 5 1 Mount Pleasant -123.1043 49.26621
#> 6 10 Renfrew-Collingwood -123.0396 49.25900
df <- morie_datasets_vancouver_noise_control_areas()
head(df)
#> name
#> 1 Schedule F (Prohibited Use of Leaf Blowers)
#> 2 Schedule C (Refuse Collection hours in Downtown area)
#> 3 Intermediate Zone
#> url
#> 1 http://vancouver.ca/commsvcs/LICANDINSP/compliance/noise/general.htm
#> 2 http://vancouver.ca/commsvcs/LICANDINSP/compliance/noise/wastehauler/index.htm
#> 3 <NA>
df <- morie_datasets_vancouver_homeless_shelters()
head(df)
#> facility category phone meals pets
#> 1 Union Gospel Mission Men 604-253-3323 yes no
#> 2 Belkin House Adults (all genders) 604-681-3405 no no
#> 3 Tenth Avenue Church Adults (all genders) 604-876-2181 yes no
#> 4 Catholic Charities Men's Hostel Men 604-443-3292 no no
#> 5 The Haven Men 604-646-6800 no no
#> 6 Anchor of Hope Adults (all genders) 604-646-6899 yes no
#> carts geo_local_area
#> 1 no Strathcona
#> 2 no Downtown
#> 3 no Mount Pleasant
#> 4 no Downtown
#> 5 no Downtown
#> 6 no Downtown
df <- morie_datasets_vancouver_property_use_inspection_districts()
head(df)
#> name
#> 1 PUID-8
#> 2 PUID-25
#> 3 PUID-5
#> 4 PUID-2
#> 5 PUID-9
#> 6 PUID-22
df <- morie_datasets_vancouver_fire_halls()
head(df)
#> name address geo_local_area
#> 1 No 5 3090 Rosemont Drive Killarney
#> 2 No 14 2804 Venables St Hastings-Sunrise
#> 3 No 15 3003 E 22nd Av Renfrew-Collingwood
#> 4 No 17 7070 Knight St Victoria-Fraserview
#> 5 No 20 5402 Victoria Drive Kensington-Cedar Cottage
#> 6 No 21 5425 Carnarvon St Dunbar-Southlands
df <- morie_datasets_vancouver_community_centres()
head(df)
#> name address
#> 1 Hastings 3096 E Hastings St
#> 2 Thunderbird 2311 Cassiar St
#> 3 Killarney 6260 Killarney St
#> 4 Hillcrest 4575 Clancy Loranger Way
#> 5 Sunset 6810 Main St
#> 6 Trout Lake 3360 Victoria Drive
#> urllink
#> 1 http://vancouver.ca/parks/cc/hastings/index.htm
#> 2 http://vancouver.ca/parks/cc/thunderbird/index.htm
#> 3 http://vancouver.ca/parks/cc/killarney/index.htm
#> 4 http://vancouver.ca/parks-recreation-culture/hillcrest-centre.aspx
#> 5 http://vancouver.ca/parks/cc/sunset/index.htm
#> 6 http://vancouver.ca/parks/cc/troutlake/index.htm
#> geo_local_area lon lat
#> 1 Hastings-Sunrise -123.0393 49.2809
#> 2 Hastings-Sunrise -123.0321 49.2636
#> 3 Killarney -123.0444 49.2274
#> 4 Riley Park -123.1079 49.2438
#> 5 Sunset -123.1006 49.2229
#> 6 Kensington-Cedar Cottage -123.0655 49.2553
df <- morie_datasets_vancouver_community_food_markets()
head(df)
#> year markettype marketname_location_host
#> 1 2016 Community Food Market Collingwood Neighbourhood House
#> 2 2016 Farmers Market Il Centro - Italian Market
#> 3 2016 Farmers Market Hastings Park
#> 4 2016 Community Food Market Alternates between 4 locations
#> 5 2015 Farmers Market River District Farmers Market
#> 6 2015 Community Food Market Good Foods Market
#> marketoperator streetnumber streetdirection
#> 1 Greater Vancouver Food Bank (Curbside Fresh) NA <NA>
#> 2 Italian Cultural Centre NA <NA>
#> 3 Vancouver Farmers Markets NA <NA>
#> 4 Cedar Cottage NA <NA>
#> 5 River District 8683 <NA>
#> 6 Fresh Roots 3075 <NA>
#> streetname streettype mergedaddress
#> 1 <NA> <NA> <NA>
#> 2 <NA> <NA> 3075 Slocan St
#> 3 Renfrew St Renfrew St
#> 4 <NA> <NA> <NA>
#> 5 Kerr St 8683 Kerr St
#> 6 Slocan St 3075 Slocan St, Vancouver, BC
#> marketdirection website
#> 1 <NA> <NA>
#> 2 <NA> <NA>
#> 3 Hastings Skatepark http://eatlocal.org
#> 4 <NA> http://cedarcottagefoodnetwork.wordpress.com/
#> 5 Kerr Street, near the pier http://www.riverdistrict.ca
#> 6 just south of Grandview hwy http://freshroots.ca/food/good-food-markets/
#> day open close
#> 1 Thursday 3pm 6pm
#> 2 June 17, July 15, Aug 19, Nov 25 3pm 7pm
#> 3 Sunday 10am 2pm
#> 4 Saturday 10am (or 10:30am) 12pm (or 12:30pm)
#> 5 Saturday 10am 3pm
#> 6 Wednesday 5pm 630pm
#> months numberofvendors
#> 1 May 5-Oct. 27 <NA>
#> 2 June - Nov <NA>
#> 3 Nov - Apr 33
#> 4 <NA> <NA>
#> 5 May - Oct 77
#> 6 May - Nov <NA>
df <- morie_datasets_vancouver_disability_parking()
head(df)
#> description location notes spaces
#> 1 Metered Accessible Parking Space North Side 1000 Alberni St NA 1
#> 2 Accessible Parking Space East Side 5800 Balsam St NA 1
#> 3 Metered Accessible Parking Space South Side 1700 Grant St NA 1
#> 4 Metered Accessible Parking Space North Side 1600 Kitchener St NA 1
#> 5 Metered Accessible Parking Space South Side 1700 Parker St NA 1
#> 6 Accessible Parking Space West Side 5300 Yew St NA 1
#> url geo_local_area lon lat
#> 1 NA West End -123.1219 49.28420
#> 2 NA Kerrisdale -123.1614 49.23362
#> 3 NA Grandview-Woodland -123.0692 49.27125
#> 4 NA Grandview-Woodland -123.0699 49.27218
#> 5 NA Grandview-Woodland -123.0693 49.27573
#> 6 NA Arbutus Ridge -123.1585 49.23781
df <- morie_datasets_vancouver_public_art()
head(df)
#> registryid title_of_work
#> 1 1 Captain George Vancouver
#> 2 2 The Swimmer
#> 3 4 Two Steel and Copper Fountains
#> 4 19 Lovers II
#> 5 23 Untitled (Low Relief)
#> 6 24 Angel of Victory
#> artistprojectstatement
#> 1 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) to create a life-size sculpture of the man who mapped the harbour in 1792 and after whom the city is named. \nMarega began by setting up 500 pounds of clay on a turntable in his Hornby Street Studio. From the clay model, he made a plaster cast which was then used to cast the finished work in "Roman bronze". It was cast at Ornamental Bronze, a foundry in Vancouver. The work was installed on August 20, 1936.The bronze figure standing atop the granite plinth is said to bear little physical resemblance to Captain George. The sculpture was copied from a maquette, which had been fashioned after a painting that was in turn, a copy from an original painting.\nAn interesting conversation is recorded between Major Matthews, the City Archivist, and Townley. \nMatthews: "Mr. Townley, the "Sun" newspaper wants to know how much the Vancouver statue cost and who paid for it."\nTownley: "What do they want to bring that up for? Leave sleeping dogs lie. I've been afraid that matter would come up, but it has not...why bring it up now? It was all in the contract; everything was above board; there's nothing to hide; but if it gets out what it cost, then some fool will start writing to the newspapers, or something, and complain of the waste of money; say it ought to have been given towards the support of some fool scheme of his own, the "home for incurable dogs", or some other idiotic thing".\nMatthews: "Alright; drop it, I don't want to know; the "Sun" is publishing a story on the statue, and I suppose they want to put the cost in."\nTownley: "Well, Charles Marega made it, and baby bonds paid for it...I don't know exactly what it cost; it would be hard to find out; part of it was in the stone work cost. Marega for $5000, and then there was the base; so much per square foot for the base, perhaps $500 for that..."\nThe statue was cleaned in 2001, 65 years after its installation and in time for the city's 115th birthday. The bill for cost of cleaning was $5800, almost the same amount as the original statue cost. This sculpture is on the City of Vancouver's Heritage Inventory list and, as a proud homage to a great explorer, has stood the test of time.
#> 2 Commissioned by Duncan McNab and Associates, architects, and the engineering firm working on the Aquatic Centre.
#> 3 <NA>
#> 4 <NA>
#> 5 <NA>
#> 6 The artist won the CPR commission from a nation-wide competition.
#> type status sitename
#> 1 Figurative In place Vancouver City Hall
#> 2 Sculpture In place Vancouver Aquatic Centre
#> 3 Fountain or water feature No longer in place Beach Towers Apartments
#> 4 Figurative In place Vancouver City Hall
#> 5 Relief In place White House Apartments
#> 6 Memorial or monument In place Waterfront Station
#> siteaddress primarymaterial
#> 1 453 West 12th Avenue bronze
#> 2 1050 Beach Avenue Silicon bronze
#> 3 1600 Beach Avenue Steel & copper, mosaic tile
#> 4 453 West 12th Avenue at Cambie <NA>
#> 5 2033 Comox Street Plaster
#> 6 601 West Cordova Street bronze
#> url
#> 1 https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=1
#> 2 https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=2
#> 3 https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=4
#> 4 https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=19
#> 5 https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=23
#> 6 https://covapp.vancouver.ca/PublicArtRegistry/ArtworkDetail.aspx?ArtworkId=24
#> photourl ownership neighbourhood
#> 1 NA City of Vancouver Mount Pleasant
#> 2 NA City of Vancouver West End
#> 3 NA private West End
#> 4 NA City of Vancouver Mount Pleasant
#> 5 NA Privately owned West End
#> 6 NA Cadillac Fairview Downtown
#> locationonsite
#> 1 North entrance, exterior, in front of stairs
#> 2 North side of front entrance
#> 3 On west and east sides of the east tower
#> 4 Northwest lawn
#> 5 On building exterior, one on either side of entrance and one at the North end.
#> 6 East of front entrance
#> geo_local_area
#> 1 Mount Pleasant
#> 2 West End
#> 3 West End
#> 4 Mount Pleasant
#> 5 West End
#> 6 Downtown
#> descriptionofwork
#> 1 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.
#> 2 An abstract form representing the motion of swimming, this bronze sculpture is mounted on two poles in front of the Aquatic Centre.
#> 3 Two copper ship-like abstract forms grace a pool of green water at this apartment dwelling.
#> 4 <NA>
#> 5 <NA>
#> 6 A heritage monument, this bronze figurative sculpture depicts an angel carrying a dead soldier and commemorates those who lost their lives in World War I. This is one of three identical statues commissioned by the Canadian Pacific Railway in 1921 to honour their workers who answered the call of "king and country" and made the ultimate sacrifice. The others are in Winnipeg and Montreal. The angel originally held a full wreath in her upraised hand. After WW II, the dates of that war were also added to the plaque.
#> photocredits yearofinstallation lon lat
#> 1 Barbara Cole 1936 -123.1139 49.26118
#> 2 Barbara Cole 1977 -123.1350 49.27701
#> 3 <NA> 1965 -123.1422 49.28408
#> 4 <NA> 1977 -123.1145 49.26144
#> 5 <NA> 1960 -123.1431 49.29101
#> 6 Maxime Cyr-Morton 1921 -123.1114 49.28525