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/…)

  1. ct_influenza_qgis
  2. vc_influenza_qgis
  3. 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

  1. 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.
  2. 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.

  3. 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.

Supporting Documents

Influenza Vaccination (last edited 2012-05-10 14:33:49 by AnyaOkhmatovskaia)