Input data set for the TX case study in

Dalal, J. and Uster, H., “Combining Worst Case and Average Case Considerations in an Integrated Emergency Response Network Design Problem,” Transportation Science, Vol. 52, No. 1, pp. 171–188, 2018. 

All model parameters are given in the following Excel files.

·         1-Source-data.xlsx

 

Source ID (i)

x

y

population

Zone

 

Col 1: source node (i) ID

Col 2: longitude (x) of source node i

Col 3: latitude (y) of source node i

Col 4: which zone source node “i” belongs to: Coast/A/B/C.

 

·         2-Shelter-data.xlsx

Shelter ID (j)

x

y

population

Capacity

Fixed Cost

 

Col 1: shelter node (j) ID

Col 2: longitude (x) of shelter node j

Col 3: latitude (y) of shelter node j

 

·         3-DC-data.xlsx

ID (k)

x

y

Capacity

Fixed Cost

 

Col 1: DC node (k) ID

Col 2: longitude (x) of DC node k

Col 3: latitude (y) of DC node k

Col 4: capacity of DC k

Col 5: fixed cost of opening DC at k

 

·         4-Other parameters.xlsx

[Per head demand, φ]

 

  [Unit TC for relief, β]

 

 

[Unit TC for people, α] [Unit TC for people, α]

 

 

 

 

 


a)      Per head demand for relief item

b)      Unit transportation cost for relief item ($/unit-mile)

c)      Unit transportation cost of evacuees ($/person-mile) 

 

 

We present the sources of GIS data in Table 1-2 below.

Table 1: Data used in case study with sources

 

Data

Source

Census 2010 population data for each evacuation origin (block-group level) and each candidate shelter (county level)

www. socialexplorer.com

Census 2010 TIGER/Line GIS shapefiles having “block-group” and “county” as geographic units to construct the evacuation, shelter and DC zones as given in Table 4.

www.census.gov

 

We use the following counties given in Table 2, to construct the evacuation, shelter, and DC zones respectively. 

Table 2: Counties considered in three zones in our GIS case study

 

Evacuation Zone

Shelter Zone

DC Zone

Selected block groups of the following 5 counties, closely resembling the evacuation map by Texas DPS: Brazoria, Chambers, Galveston, Harris, Matagorda.

Anderson, Angelina, Bastrop,

Bell, Bexar*, Blanco, Bosque,

Brazos*, Burleson, Burnet,

Caldwell, Cherokee, Comal,

Coryell, Dallas*, Ellis,

Falls, Freestone, Gillespie,

Gregg, Guadalupe, Hamilton,

Harrison, Hays, Henderson, Hill,

Houston, Johnson, Kaufman,

Kendall, Lampasas, Lee, Leon,

Limestone, Llano, Madison,

Mason, McLennan*, Milam,

Mills, Nacogdoches*, Navarro,

Panola, Robertson, Rusk, San

Saba, Shelby, Smith*, Tarrant*,

Travis*, Trinity, Upshur,

Vanzandt, Walker*, Williamson,

Wood. (56 counties)

Archer, Baylor, Bowie, Brewster,

Callahan, Clay, Coke, Cooke,

Crane, Crockett, Edwards, Fannin, Fisher, Glasscock, Grayson,

Haskell, Howard, Irion, Jones,

Kinney, Knox, Lamar, Martin, Maverick, Midland, Mitchell,

Montague, Nolan, Pecos, Reagan, Real, Red river, Schleicher, Scurry, Shackelford, Sterling, Stonewall, Sutton, Taylor, Terrell, Throckmorton, Tomgreen, Upton, Uvalde, Val verde,

Wichita, Young, Zavala. (48

counties)

Source of evacuation: Centroid of Block Group.

Candidate Shelter:

 Centroid of County.

Candidate DC:

Centroid of County.

 

*Counties considered as shelters in the “State Evacuation and Sheltering Plan” (Texas, 2006)