Line 9 wall thickness

The following spreadsheet is derivedfrom work done by Darko Matovic, a professor at Queens University.

The first column is the wall thickness in inches and the fifth column is the thickness in mm. The 2nd, 3rd and 4th columns are the km post at begining, the end and the length of each section.

In the 7th column are designations of "high consequence areas (ESA=environmentally sensitive area; HPA= high population area; OPA=other population area; & DW=drinking water). The next column has the start and end km post and the following column has the distance between them in metres. The colours indicate the start and finish of such areas

 

Wt, in KPStart KPEnd Length, km Wt, mm Location marker      
0.312 2997.532 2999.576 2.044 7.92        
0.5 2999.576 2999.632 0.056 12.70 Creek      
0.312 2999.632 3007.285 7.652 7.92        
0.312 3004.69         1/6/1979 Dent 1
0.281 3007.285 3017.279 9.994 7.14 Valve 9       
0.5 3017.279 3017.316 0.037 12.70 Creek      
0.281 3017.316 3019.821 2.506 7.14        
0.344 3019.821 3022.960 3.138 8.74        
0.5 3022.960 3023.085 0.126 12.70 Bronte Creek      
0.344 3023.085 3023.681 0.595 8.74        
0.312 3023.681 3027.611 3.930 7.92 Valve 10      
0.344 3027.611 3029.566 1.955 8.74        
0.5 3029.566 3029.775 0.209 12.70 Oakville Creek      
0.344 3029.775 3030.636 0.861 8.74        
0.312 3030.636 3032.503 1.867 7.92        
0.5 3032.503 3032.656 0.153 12.70 East Oakville Creek      
0.312 3032.656 3041.548 8.892 7.92        
0.312 3036.82     7.92   1/26/1991 Crack 2
0.344 3041.548 3041.803 0.256 8.74        
0.5 3041.803 3041.861 0.058 12.70        
0.344 3041.861 3042.561 0.700 8.74 Valve 11      
0.5 3042.561 3042.780 0.219 12.70 Credit River      
0.344 3042.780 3044.122 1.342 8.74        
0.312 3044.122 3047.806 3.684 7.92        
0.5 3047.806 3047.846 0.040 12.70 Cooksville Creek      
0.312 3047.846 3051.284 3.438 7.92        
0.5 3051.284 3051.321 0.037 12.70 Little Etobicoke Creek      
0.312 3051.321 3054.052 2.731 7.92        
0.5 3054.052 3054.139 0.087 12.70 Bourough of Etobicoke      
0.312 3054.139 3055.436 1.297 7.92 Valve 12      
0.5 3055.436 3055.546 0.109 12.70 Mississauga Pond      
0.312 3055.546 3057.335 1.790 7.92 Start Spread 3      
0.375 3057.335 3057.738 0.402 9.53        
0.312 3057.738 3058.550 0.813 7.92        
0.5 3058.550 3058.708 0.158 12.70        
0.312 3058.708 3063.802 5.094 7.92        
0.5 3063.802 3063.925 0.124 12.70 Humber River      
0.312 3063.925 3066.364 2.438 7.92        
0.5 3066.364 3066.536 0.172 12.70 East Humber River      
0.312 3066.536 3067.007 0.472 7.92        
0.5 3067.007 3067.040 0.032 12.70 Drainage      
0.312 3067.040 3068.247 1.207 7.92 Valve 13      
0.281 3068.247 3070.548 2.301 7.14        
0.5 3070.548 3070.670 0.122 12.70 Black Creek      
0.281 3070.670 3074.314 3.644 7.14        
0.5 3074.314 3074.850 0.536 12.70 West Don River      
0.281 3074.850 3078.562 3.713 7.14        
0.5 3078.562 3078.641 0.079 12.70        
0.281 3078.641 3080.156 1.514 7.14        
0.5 3080.156 3080.262 0.106 12.70 Creek      
0.281 3080.262 3081.829 1.568 7.14        
0.5 3081.829 3081.997 0.167 12.70 East Don River      
0.281 3081.997 3094.891 12.894 7.14 Valve 14      
0.5 3094.891 3094.939 0.048 12.70 Creek      
0.281 3094.939 3095.477 0.538 7.14        
0.5 3095.477 3095.636 0.159 12.70 Rouge River      
0.281 3095.636 3097.279 1.643 7.14        
0.5 3097.279 3097.313 0.034 12.70 Creek      
0.281 3097.313 3100.272 2.960 7.14 Start Spread 4 ESA 3099.98 310.74
0.5 3100.272 3100.446 0.174 12.70 Plum Hollow Nursery Pond   3100.29  
0.281 3100.446 3101.447 1.001 7.14        
0.5 3101.447 3101.486 0.039 12.70 Creek      
0.281 3101.486 3101.948 0.462 7.14        
0.5 3101.948 3101.986 0.039 12.70 Creek      
0.281 3101.986 3105.744 3.758 7.14        
0.5 3105.744 3105.953 0.209 12.70 West Duffin Creek      
0.281 3105.953 3108.030 2.076 7.14   HPA 3106.59 1875.87
0.5 3108.030 3108.102 0.072 12.70 Decker Hills Tributory   3108.46  
0.281 3108.102 3109.069 0.967 7.14   ESA 3107.14 28.61km
0.5 3109.069 3109.130 0.061 12.70 Brougham Creek      
  3109.900       Pickering-Ajax Boundary      
0.281 3109.130 3111.327 2.197 7.14 Valve 15      
0.5 3111.327 3111.451 0.124 12.70 East Duffin Creek      
0.281 3111.451 3114.589 3.138 7.14        
0.5 3114.589 3114.626 0.037 12.70 Creek      
0.281 3114.626 3115.151 0.525 7.14        
0.5 3115.151 3115.186 0.035 12.70 Creek      
0.281 3115.186 3115.780 0.594 7.14        
0.5 3115.780 3115.817 0.037 12.70 Creek      
0.281 3115.817 3117.130 1.313 7.14        
  3116.500       Ajax-Whitby Boundary      
0.5 3117.130 3117.169 0.039 12.70 Creek      
0.281 3117.169 3117.782 0.613 7.14        
0.5 3117.782 3117.821 0.039 12.70 Creek      
0.281 3117.821 3118.394 0.573 7.14        
0.5 3118.394 3118.518 0.124 12.70 Creek      
0.281 3118.518 3118.828 0.311 7.14        
0.25 3118.828 3118.925 0.097 6.35        
0.5 3118.925 3118.962 0.037 12.70 Creek      
0.25 3118.962 3120.552 1.590 6.35        
0.281 3120.552 3120.576 0.024 7.14   HPA 3120.95 1911.08
0.25 3120.576 3120.602 0.026 6.35     3122.86  
0.281 3120.602 3120.650 0.048 7.14        
0.25 3120.650 3121.400 0.750 6.35        
0.281 3121.400 3121.424 0.024 7.14        
0.25 3121.424 3121.870 0.446 6.35        
0.5 3121.870 3121.908 0.039 12.70 Lynde Creek      
0.25 3121.908 3122.256 0.348 6.35        
0.281 3122.256 3122.280 0.024 7.14 new valve      
0.25 3122.280 3123.978 1.698 6.35        
0.281 3123.978 3124.002 0.024 7.14        
0.25 3124.002 3124.693 0.690 6.35        
  3124.200       Whitby-Oshawa Boundary      
0.5 3124.693 3124.817 0.124 12.70 Oshawa Creek      
0.281 3124.817 3124.854 0.037 7.14        
0.25 3124.854 3127.149 2.295 6.35        
0.281 3127.149 3127.173 0.024 7.14        
0.25 3127.173 3128.211 1.038 6.35   HPA 3126.75 1340.96
0.5 3128.211 3128.333 0.122 12.70 East Oshawa Creek   3128.09  
0.25 3128.333 3129.299 0.966 6.35        
0.281 3129.299 3129.323 0.024 7.14        
0.25 3129.323 3130.850 1.527 6.35        
0.281 3130.850 3130.874 0.024 7.14        
0.25 3130.874 3131.938 1.064 6.35        
  3131.800       Oshawa Clarington Boundary    
0.281 3131.938 3131.975 0.037 7.14        
0.25 3131.975 3132.533 0.558 6.35        
0.281 3132.533 3132.558 0.024 7.14        
0.25 3132.558 3135.206 2.649 6.35        
0.281 3135.206 3135.231 0.024 7.14        
0.25 3135.231 3135.638 0.407 6.35        
0.281 3135.638 3135.662 0.024 7.14        
0.25 3135.662 3135.963 0.301 6.35     3135.75  
0.281 3135.963 3135.987 0.024 7.14   ESA 3135.80 155.41
0.25 3135.987 3136.084 0.097 6.35     3135.95  
0.5 3136.084 3136.122 0.039 12.70 Farewell Creek      
0.25 3136.122 3137.307 1.184 6.35 Valve 16      
0.5 3137.307 3137.345 0.039 12.70 Black Creek      
0.25 3137.345 3137.761 0.415 6.35   ESA 3138.14 237.71
0.281 3137.761 3137.783 0.023 7.14     3138.38  
0.25 3137.783 3139.462 1.679 6.35   OPA 3139.21 287.67
0.281 3139.462 3139.484 0.023 7.14     3139.5  
0.25 3139.484 3139.792 0.307 6.35   OPA 3139.52 76.24
0.281 3139.792 3140.260 0.468 7.14     3139.59  
0.5 3140.260 3140.298 0.039 12.70 Bowmanville Creek OPA 3140.22 225.11
0.281 3140.298 3140.759 0.460 7.14     3140.45  
0.5 3140.759 3140.797 0.039 12.70 Creek ESA 3139.45  
0.281 3140.797 3141.311 0.513 7.14     3149.52  
0.25 3141.311 3145.012 3.701 6.35        
0.5 3145.012 3145.051 0.039 12.70 Soper Creek      
0.25 3145.051 3145.695 0.644 6.35        
0.281 3145.695 3145.719 0.024 7.14        
0.25 3145.719 3146.573 0.855 6.35        
0.281 3146.573 3146.599 0.026 7.14        
0.25 3146.599 3147.088 0.489 6.35        
0.5 3147.088 3147.127 0.039 12.70 Soper Creek      
0.25 3147.127 3149.422 2.295 6.35   DW 3147.44 411.09
0.5 3149.422 3149.460 0.039 12.70 Wilmot Creek   3147.85  
0.25 3149.460 3149.712 0.251 6.35   DW 3148.21 3.37km
0.281 3149.712 3149.736 0.024 7.14     3151.58  
0.25 3149.736 3149.792 0.056 6.35        
0.5 3149.792 3149.831 0.039 12.70 Orono Creek      
0.25 3149.831 3151.289 1.458 6.35 new valve      
0.5 3151.289 3151.326 0.037 12.70 Hunter Creek      
0.25 3151.326 3151.450 0.124 6.35        
0.281 3151.450 3151.474 0.024 7.14        
0.25 3151.474 3152.753 1.279 6.35   DW 3152.54  
0.281 3152.753 3152.777 0.024 7.14     3156.14  
0.25 3152.777 3153.156 0.378 6.35        
0.281 3153.156 3153.180 0.024 7.14        
0.25 3153.180 3153.703 0.523 6.35        
0.5 3153.703 3153.740 0.037 12.70 Stalker Creek      
0.25 3153.740 3154.137 0.398 6.35        
0.281 3154.137 3154.161 0.024 7.14        
0.25 3154.161 3155.988 1.827 6.35        
0.5 3155.988 3156.025 0.037 12.70        
0.25 3156.025 3157.114 1.090 6.35        
0.5 3157.114 3157.152 0.037 12.70 Graham Creek      
0.25 3157.152 3157.517 0.365 6.35        
0.281 3157.517 3157.541 0.024 7.14        
0.25 3157.541 3158.386 0.845 6.35        
0.281 3158.386 3158.410 0.024 7.14        
0.25 3158.410 3158.579 0.169 6.35        
0.5 3158.579 3158.616 0.037 12.70 Graham Creek 2      
0.25 3158.616 3160.076 1.460 6.35        
0.281 3160.076 3160.100 0.024 7.14        
0.25 3160.100 3160.655 0.555 6.35        
0.5 3160.655 3160.690 0.035 12.70 Graham Creek 3      
0.25 3160.690 3160.961 0.270 6.35        
0.281 3160.961 3160.985 0.024 7.14        
0.25 3160.985 3161.717 0.732 6.35   ESA 3161.11 430.51
0.281 3161.717 3161.741 0.024 7.14     3161.54  
0.25 3161.741 3163.745 2.004 6.35        
  approx 3163     eastern boundary of Durham      
0.281 3163.745 3163.769 0.024 7.14        
0.25 3163.769 3165.403 1.633 6.35        
0.281 3165.403 3165.427 0.024 7.14        
0.25 3165.427 3166.915 1.489 6.35        
0.281 3166.915 3166.940 0.024 7.14        
0.25 3166.940 3167.929 0.990 6.35 Valve No. 17      
0.281 3167.929 3167.953 0.024 7.14        
0.25 3167.953 3168.557 0.604 6.35        
0.5 3168.557 3168.594 0.037 12.70 Creek      
0.25 3168.594 3168.792 0.198 6.35