668430-Roa

100 Part II: Multi-state deterioration modelling Table II.1: Case studies on sewer main degradation modelling, detailing reference, city, country, network length (study/total km), number of pipes for model calibration, and dataset availability: Not Available (N.A.), Upon Request (U.P.). Reference City Country Len. (km) Pipes Avail. Micevski, Kuczera, and Coombes, 2002 Newcastle Australia 17/380 497 N.A. Baik, Jeong, and Abraham, 2006 San Diego U.S. 90/4,800 - N.A. Le Gat, 2008 Dresden Germany 287/870 21,966 N.A. Dirksen and Clemens, 2008 - Netherlands 95/- - N.A. Lubini and Fuamba, 2011 St-Hyacinthe &Verdun Canada - 459 N.A. Scheidegger, Hug, Rieckermann, et al., 2011†† - - - - N.A. Duchesne, Beardsell, Villeneuve, et al., 2013 Quebec Canada 936/5,333 15,122 N.A. Egger, Scheidegger, Reichert, et al., 2013†† - - - 2,000 N.A. Rokstad and Ugarelli, 2015 Oslo Norway 499/1,848 12,003 N.A. Caradot, Sonnenberg, Kropp, et al., 2017 Braunschweig Germany 1,027/1,300 35,826 N.A. Caradot, Riechel, Fesneau, et al., 2018 Berlin Germany 4,825/9,710 102,258 N.A. Hernández, Caradot, Sonnenberg, et al., 2021 Medellín Colombia 537/5,213↓ 17,298 N.A. Hernández, Caradot, Sonnenberg, et al., 2021 Bogotá Colombia 432/9,391↓ 8,553 N.A. Lin, Yuan, and Tovilla, 2019 - Canada - - N.A. Tran, Lokuge, Karunasena, et al., 2022 - Australia - - N.A. Khaleghian and Shan, 2023 † U.S. - - U.R. Jimenez-Roa, Heskes, Tinga, et al., 2022 Breda Netherlands 1,045/2,169 25,594 Yes † Four states from the U.S.: Texas, Indiana, California, and Pennsylvania. †† Synthetic data generated with NetCoS tool. → Not explicitly mentioned in the paper, but inferred from the information. For completeness, other available datasets exist(e)(f)(g), but no related publications were found at the time of the publication of dissertation. In the next section we provide details on the dataset, which is used in Chapters 5 and 6. II.4.3 Breda’s case study The raw dataset for the case study includes 59,183 sewer mains (approximately 2,169 kilometres) and 30,661 inspections. After cleaning, which involved removing uninspected pipes, those built before 1900, and those with missing or erroneous data, the dataset was reduced to 25,594 sewer mains (approximately 1,045 kilometres) and 29,926 inspections. Histograms for all categorical and numerical variables in the dataset are displayed in (e)https://hub.arcgis.com/maps/09bb004af3cf4c65b7ea73f81f1fe2bc/about (f)https://hub.arcgis.com/datasets/lahub::sewer-pipes/about (g)https://sitepx.freensb.cloudns.org/https/catalogue.data.govt.nz/dataset/wastewaternetwork-wastewater-points2

RkJQdWJsaXNoZXIy MjY0ODMw