vet_clinics_db

A database for exploring equitable access to veterinary (vet) care in Madison, WI, explores the limitations for people when accessing vet care using census tract level data: demographics, socio-economic variables, including public transit information. The database could showcase potential low-accessibility areas within census tracts.

Data Engineering Information:

Table name	File type	Geometry type	Projection	Data source	Description
vet_walk_polygons	Shapefile	Polygons	UTM Zone 16N	Network Analysis by Sid	Stores 0.5, 1-mile walk polygons from veterinary clinics (Network Analysis)
madison_demographics	CSV	NA	NA	Wisconsin Food Project	Stores Demographic and socio-economic information
madison_census_tracts	Shapefile	Polygon	UTM Zone 16N	GeoData@Wisconsin	Stores latest census tracts information 2022 (Tiger line)
madison_metro	Shapefile	Point	UTM Zone 16N	City of Madison	Stores stops information of Madison Metro Bus routes
madison_vet	Shapefile	Point	UTM Zone 16N	Compiled by Kaitlyn Breaux	Stores information on veterinary clinics (dogs, cats, open days)
madison_urban_bounds	Shapefile	Polygon	UTM Zone 16N	GeoData@Wisconsin	Stores urban bounds of the city of Madison, WI
dane_roads	Shapefile	line	UTM Zone 16N	GeoData@Wisconsin	Stores road network (Elevation model) of Dane county

Attribute information of datasets:

madison_demographics stores socio-demographic indicators which are retrieved from the American Community Survey (ACS) 2016-20, describe economic conditions with better dimensions like the Gini Index of income inequality, median income and help analyze veterinary deserts situation in Madison, WI. The data is sourced from Applied Population Laboratory (APL)

• noveh1620_est: Households without vehicle, % (2016-20)
• gini1620_est: Gini Index of Income Inequality (2016-20)
• medincacs1620_est: Median household income (2016-20)
• walkoth1620_est: Workers walking or other non-vehicle, % (2016-20)
• pubtrans1620_est: Workers using public transportation, % (2016-20)
• noncitizens1620_est: Noncitizens, % (2016-20)
• hispanic1620_est: Hispanic or Latino, % (2016-20)
• raceoth1620_est: Other or multiple race, % (2016-20)
• raceamind1620_est: American Indian, % (2016-20)
• raceasian1620_est: Asian, % (2016-20)
• raceaa1620_est: African American, % (2016-20)
• racewhite1620_est: White, % (2016-20)

madison_metro stores information on metro transit stop names and routes connected from a bus stop. The information is sourced from City of Madison. The dataset helps understand public transit availability in census tracts to assess vet care accessibility.

• stop_code: Bus stop code for each stop provided by Madison metro bus service.
• stop_name: Name of the bus stop
• primary_st: Primary street where the bus stop is located
• Route: Other connected route codes from a bus stop
• geometry: Point geometry of bus stop

madison_census_tracts is useful in appending with madison_demographics to gain insights for spatial queries in understanding vet clinics' availability and the number of bus stops.

• tractce: Census tract code
• geoid: Census tract identifier which is combination of state(55), county(025) and tractce values
• namelsad: Translated legal/statistical area description
• shape_leng: Shape length
• shape_area: Shape area
• geometry: Polygon geometry of each census tract

madison_vet provides information on veterinary clinic addresses with a range of service availability (weekends/weekdays) for various species of pet animals. Additional information on payment plans and full services are also added to complement the veterinary clinics' data. The data is compiled by Kaitlyn Breaux.

• name: Name of veterinary clinic/hospital
• hnum: House number
• street: Street address of the clinic
• city: Location of city (Within Dane county)
• open_wk: Open on weekdays (Yes/No)
• open_wkds: Open on weekends (Yes/No)
• cats: Cats are treated (Yes/No)
• dogs: Dogs are treated (Yes/No)
• others: Other animals are treated (Yes/No/NA)
• pplan: Payment plan availability (Yes/No/NA)
• full_srvc: Full service availability (Yes/No)
• low_cost: Low cost clinic (Yes/No)
• geometry: Point location of veterinary clinic

madison_urban_bounds stores the geometry information on the limits of Madison, WI. The dataset is downloaded from city of Madison

• name: Name of shapefile
• geometry: Polygon geometry of Madison, WI urban bounds

vet_walk_polygons provides walk polygons of 0.5, 1 mile from veterinary clinics (using madison_vet datasest) and dane_roads shapefile which describes Dane county road network sourced from GeoData@Wisconsin website (2022). The dataset is computed by Chinna Subbaraya Siddharth (Sid) Ramavajjala by performing network analysis using ArcGIS Pro. The dataset helps in the understanding of vet deserts in Madison, WI.

• name: Veterinary clinic from which walk polygons are computed
• org_mile: Origin mile value of the walk polygon
• dst_mile: Destination mile value of the walk polygon
• shape_leng: Shape length of polygon
• shape_area: Shape area of polygon
• geometry: Walk polygon geometry of 0.5 and 1 mile