Evaluating and optimizing access of vulnerable populations to influenza prevention and control strategies

Documentation for the dataset

Dataset is composed of 3 tables, located on the SARS server in the geo database under the luc schema (SARS/geo/luc/…)

ct_influenza_qgis
vc_influenza_qgis
vc_data_transittime

Census-based Variables

Variable	Description
ctuid	Joining column
ct_geo	PostGIS enabling column; no projection (NAD83)
ct_geo_mtm8	PostGIS enabling column; projected using MTM 8
area_m2	Surface area of census tract
singlemom	Prevalence of single-mother families
singleparent	Prevalence of single-parent families
childperfam	Average no. of young children per family
over65	Prevalence of older people
over65alone	Prevalence of older people living alone
mennojob1	Prevalence of unemployed males — 1
mennojob2	Prevalence of unemployed males — 2
unemployment	Unemployment rate
licofamily	Prevalence of low income families
incomefamily	Median family income
relocated1y	Prevalence of relocated households in last year
relocated5y	Prevalence of relocated households in last 5 years
immigrant	Prevalence of immigrants
newimmigrant	Prevalence of recent immigrants
rented1	Prevalence of rented dwellings — 1
rented2	Prevalence of rented dwellings — 2
postsecedu	Prevalence of postsecondary education
universityedu	Prevalence of university education
offlangno	Prevalence of non-official mother-tongue
offlangyes	Prevalence of knowledge of official language
resdens	Residential density
sdhouse	Prevalence of single-detached houses
ct_centmat	Material deprivation index
ct_centsoc	Social deprivation index
alexisnihon	Distance from CT centroid to Place Alexis-Nihon
allancroft	Distance from CT centroid to Allancroft School
angrignon	Distance from CT centroid to Carrefour Angrignon
cavendish	Distance from CT centroid to Cavendish Mall
centredesloisirs	Distance from CT centroid to Centre des loisirs de St-Laurent
clsc_hm	Distance from CT centroid to CLSC Hochelaga-Maisonneuve
clsc_pmr	Distance from CT centroid to CLSC Plateau-Mont-Royal
college_msl	Distance from CT centroid to Mont Saint-Louis College
college_rm	Distance from CT centroid to Reine-Marie College
edouardrivest	Distance from CT centroid to Edouard Rivest Centre
frederickbanting	Distance from CT centroid to Frederick-Banting School
hospitallachine	Distance from CT centroid to Lachine Hospital
hospitalrdp	Distance from CT centroid to Riviere-des-Prairies Hospital
laval	Distance from CT centroid to former Canadian Tire
palaisdescongres	Distance from CT centroid to Palais des Congres
patroleprevost	Distance from CT centroid to Patro le Prevost Community Centre
physergo	Distance from CT centroid to Southwest Physergo Medical Centre
springgarden	Distance from CT centroid to Spring Garden Elementary
stadium	Distance from CT centroid to Olympic Stadium
theatreduquartier	Distance from CT centroid to Theatre du quartier

Vaccination Centre-based Variables

Variable	Description
name_safe	Name of vaccination centre
address	Address of vaccination centre
city	City of vaccination centre
postal_code	Postal code of vaccination centre
ctuid_vc	ID of census tract of vaccination centre
dauid	ID of dissemination area of vaccination centre
vc_geo	PostGIS enabling column; no projection (NAD83)
vc_geo_mtm8	PostGIS enabling column; projected using MTM 8
datestart1	Date clinic started operating for houropen1 and hourclose1
datestop1	Date clinic stopped operating for houropen1 and hourclose1
houropen1	Time clinic opened in first period
hourclose1	Time clinic closed in first period
datestart2	Date clinic started operating for houropen2 and hourclose2
datestop2	Date clinic stopped operating for houropen2 and hourclose2
houropen2	Time clinic opened in second period
hourclose2	Time clinic closed in second period
spvm09	ID of police precinct of vaccination centre
violentcrime	Number of violent crimes in host precinct
vcper10k	Violent crimes per 10 +000 pop of host precinct
ct_centmat	Material deprivation index of host census tract
ct_centsoc	Social deprivation index of host census tract
resdens	Residential density of host census tract
distance	Distance of search radius for calculation of bus and metro service levels
metro	Number of metro stations within [distance] meters of vaccination centre
bus	Number of bus stops within [distance] meters of vaccination centre

Public Transit Trip Variables

Variable	Description
ctuid	Joining column for census tract
id	Unique identifier
xyo	Coordinates of CT centroid (trip origin)
localo	ID of census tract (trip origin)
xyd	Coordinates of vaccination centre (trip destination)
locald	Name of vaccination centre (trip destination)
ttot	Total time of trip (assumes no initial wait time)
tmar	Total walk time of trip
tatt	Total wait time at transfer points
tveh	[Not used]
hredep	Time of departure (departure closest to 7:30am)
hrearr	Time of arrival
distmar	Total walking distance of trip
lignes	Transit line(s) used during trip (see attachment for details)
nbtrans	Number of transfers
nbmode	Number of modes used (bus, metro, train)
type_jour	Day of week (weekday OR Sunday)

Details on the above measures can be found in Inventory_of_variables.xls, which contains information on variable type, unit and calculation for each of the tables.

Additional Notes

Driving time for private vehicle trips between centroids and vaccination centres was estimated using Google’s Directions API, which was implemented by Anya here: travel time map.
- Should redo estimates using re-centred centroids, so that data align with public transit trip-time estimates.
Centroids of census tracts were generated using the ArcGIS function Convert to Point with the Inside parameter checked. ? centroids were shifted manually to move them closer to the street network (crude centre of gravity) in order to avoid problems with trip time estimations.
Georeferenced tables (PostGIS) for the location of census tract centroids and boundaries were provided by Aman.

Appendix

Notes on Deprivation index

centmat et centsoc : les centiles des composantes matérielle et sociale de l’indice national.