Geographic Information System–Based Framework for Estimating and Visualizing Unit Prices of Highway Work Items
Publication: Journal of Construction Engineering and Management
Volume 145, Issue 8
Abstract
Historical bid items from previous projects are an important source of data for project cost estimation. State highway agencies have widely used this data source for budget planning of highway projects. Current practices on using the data are, however, not efficient and fail to provide a reliable estimate. The estimate is simply based on the mean value, which is then manually adjusted by professionals using their knowledge and experience. A highway project is unique, and its price is highly dependent on various factors including location and the type of construction activities. A geospatial analytic method for project cost estimates would be highly useful for automated assessment of these influencing factors. The state of the art has applied interpolation methods to location cost-adjustment factors to adjust the total costs of two similar projects in two different cities. However, existing methods are mostly beneficial to conceptual cost estimation without considering variances between two projects in the same city and various effects of location on different work activities. This study contributes to the body of knowledge by proposing a geographic information system–based framework that leverages historical bid data for unit-price estimation and visualization with consideration of the effects of project-specific location on different bid items. Apart from applying established spatial interpolation methods to unit-price estimation, various strategies such as the use of quantity in interpolation models are proposed to improve the accuracy of the estimates. Temporal changes in unit prices and relationships between quantities and unit prices are also explored.
Get full access to this article
View all available purchase options and get full access to this article.
Data Availability Statement
Data analyzed during the study were provided by a third party. Requests for data should be directed to the provider indicated in the “Acknowledgements.” Information about the Journal’s data-sharing policy can be found here: http://ascelibrary.org/doi/10.1061/(ASCE)CO.1943-7862.0001263.
Acknowledgments
The authors would like to acknowledge that the Iowa Department of Transportation provided historical bid data for this research.
References
Ahiaga-Dagbui, D. D., and S. D. Smith. 2014. “Rethinking construction cost overruns: Cognition, learning and estimation.” J. Financial Manage. Property Constr. 19 (1): 38–54. https://doi.org/10.1108/JFMPC-06-2013-0027.
Al-Tabtabai, H., A. P. Alex, and M. Tantash. 1999. “Preliminary cost estimation of highway construction using neural networks.” Cost Eng. 41 (3): 19.
Anderson, S., I. Damnjanovic, A. Nejat, and S. Ramesh. 2009. “Synthesis on construction unit cost development: Technical report.” Accessed March 5, 2018. http://d2dtl5nnlpfr0r/.cloudfront.net/tti.tamu.edu/documents/0-6023-1.pdf.
Atkinson, R. 1999. “Project management: Cost, time and quality, two best guesses and a phenomenon, its time to accept other success criteria.” Int. J. Project Manage. 17 (6): 337–342. https://doi.org/10.1016/S0263-7863(98)00069-6.
Bansal, V. K. 2015. “Potential application areas of GIS in preconstruction planning.” J. Prof. Issues Eng. Educ. Pract. 142 (1): 06015002. https://doi.org/10.1061/(ASCE)EI.1943-5541.0000257.
Bansal, V. K., and M. Pal. 2007. “Potential of geographic information systems in building cost estimation and visualization.” Autom. Constr. 16 (3): 311–322. https://doi.org/10.1016/j.autcon.2006.07.002.
Bekele, A., R. Downer, M. Wolcott, W. Hudnall, and S. Moore. 2003. “Comparative evaluation of spatial prediction methods in a field experiment for mapping soil potassium.” Soil Sci. 168 (1): 15–28. https://doi.org/10.1097/00010694-200301000-00003.
Burrough, P. A., R. A. McDonnell, and C. D. Lloyd. 2015. Principles of geographical information systems. Oxford, UK: Oxford University Press.
Cai, H., W. Rasdorf, and C. Tilley. 2007. “Approach to determine extent and depth of highway flooding.” J. Infrastruct. Syst. 13 (2): 157–167. https://doi.org/10.1061/(ASCE)1076-0342(2007)13:2(157).
Cai, H., W. Rasdorf, C. Tilley, L. C. Smith, and F. Robson. 2006. “Geographic information systems/national elevation data route mileage verification.” J. Surv. Eng. 132 (1): 40–49. https://doi.org/10.1061/(ASCE)0733-9453(2006)132:1(40).
California DOT (Department of Transportation). 2014. Preparation guidelines for project development cost estimates. Sacramento, CA: California DOT.
Carr, R. I. 1989. “Cost-estimating principles.” J. Constr. Eng. Manage. 115 (4): 545–551. https://doi.org/10.1061/(ASCE)0733-9364(1989)115:4(545).
Chan, A. P., and A. P. Chan. 2004. “Key performance indicators for measuring construction success.” Benchmark. Int. J. 11 (2): 203–221. https://doi.org/10.1108/14635770410532624.
Cheng, M.-Y., and S.-C. Yang. 2001. “GIS-based cost estimates integrating with material layout planning.” J. Constr. Eng. Manage. 127 (4): 291–299. https://doi.org/10.1061/(ASCE)0733-9364(2001)127:4(291).
Childs, C. 2004. “Interpolating surfaces in ArcGIS spatial analyst.” ArcUser, July–September 2004.
De Smith, M. J., M. F. Goodchild, and P. Longley. 2007. Geospatial analysis: A comprehensive guide to principles, techniques and software tools. Leicester, UK: Troubador.
Dixon, W. 1953. “Processing data for outliers.” Biometrics 9 (1): 74–89. https://doi.org/10.2307/3001634.
Fotheringham, A. S., and M. E. O’Kelly. 1989. Spatial interaction models: Formulations and applications. Dordrecht, Netherlands: Kluwer.
Ghasemi, A., and S. Zahediasl. 2012. “Normality tests for statistical analysis: A guide for non-statisticians.” Int. J. Endocrinol. Metab. 10 (2): 486–489. https://doi.org/10.5812/ijem.3505.
Gransberg, D. D., and C. Riemer. 2009. “Impact of inaccurate engineer’s estimated quantities on unit price contracts.” J. Constr. Eng. Manage. 135 (11): 1138–1145. https://doi.org/10.1061/(ASCE)CO.1943-7862.0000084.
Grubbs, F. E. 1969. “Procedures for detecting outlying observations in samples.” Technometrics 11 (1): 1–21. https://doi.org/10.1080/00401706.1969.10490657.
Hauke, J., and T. Kossowski. 2011. “Comparison of values of Pearson’s and Spearman’s correlation coefficients on the same sets of data.” Quaestiones Geographicae 30 (2): 87–93. https://doi.org/10.2478/v10117-011-0021-1.
Hegazy, T., and A. Ayed. 1998. “Neural network model for parametric cost estimation of highway projects.” J. Constr. Eng. Manage. 124 (3): 210–218. https://doi.org/10.1061/(ASCE)0733-9364(1998)124:3(210).
Hoaglin, D. C. 2003. “John W. Tukey and data analysis.” Stat. Sci. 18 (3): 311–318. https://doi.org/10.1214/ss/1076102418.
Hodge, V., and J. Austin. 2004. “A survey of outlier detection methodologies.” Artif. Intell. Rev. 22 (2): 85–126. https://doi.org/10.1023/B:AIRE.0000045502.10941.a9.
Hu, W., X. Shu, X. Jia, and B. Huang. 2018. “Geostatistical analysis of intelligent compaction measurements for asphalt pavement compaction.” Autom. Constr. 89 (May): 162–169. https://doi.org/10.1016/j.autcon.2018.01.012.
Hyari, K. H. 2016. “Owner’s countermeasures to skewed bidding in construction projects: Review of current practices and proposal for new countermeasures.” J. Manage. Eng. 33 (3): 04016053. https://doi.org/10.1061/(ASCE)ME.1943-5479.0000502.
Iowa DOT (Department of Transportation). 2015. Design manual. Mason City, IA: Iowa DOT.
Isaaks, E., and R. Srivastava. 1989. An introduction to applied geostatistics. New York: Oxford University Press.
Jeljeli, M. N., J. S. Russell, H. W. G. Meyer, and A. P. Vonderohe. 1993. “Potential applications of geographic information systems to construction industry.” J. Constr. Eng. Manage. 119 (1): 72–86. https://doi.org/10.1061/(ASCE)0733-9364(1993)119:1(72).
Jeong, D. I., A. St-Hilaire, Y. Gratton, C. Bélanger, and C. Saad. 2017. “A guideline to select an estimation model of daily global solar radiation between geostatistical interpolation and stochastic simulation approaches.” Renewable Energy 103 (Apr): 70–80.https://doi.org/10.1016/j.renene.2016.11.022.
Johnston, K., J. M. Ver Hoef, K. Krivoruchko, and N. Lucas. 2001. Using ArcGIS geostatistical analyst. Redlands, CA: Esri.
Juang, K.-W., and D.-Y. Lee. 1998. “A comparison of three kriging methods using auxiliary variables in heavy-metal contaminated soils.” J. Environ. Qual. 27 (2): 355–363. https://doi.org/10.2134/jeq1998.00472425002700020016x.
Krige, D. G. 1951. “A statistical approach to some basic mine valuation problems on the Witwatersrand.” J. South Afr. Inst. Min. Metall. 52 (6): 119–139.
Kuntz, M., and M. Helbich. 2014. “Geostatistical mapping of real estate prices: An empirical comparison of kriging and cokriging.” Int. J. Geograph. Inf. Sci. 28 (9): 1904–1921. https://doi.org/10.1080/13658816.2014.906041.
Laurikkala, J., M. Juhola, E. Kentala, N. Lavrac, S. Miksch, and B. Kavsek. 2000. “Informal identification of outliers in medical data.” In Proc., 5th Int. Workshop on Intelligent Data Analysis in Medicine and Pharmacology, 20–24. Berlin: European Association for Artificial Intelligence.
Li, J., and A. D. Heap. 2011. “A review of comparative studies of spatial interpolation methods in environmental sciences: Performance and impact factors.” Ecol. Inf. 6 (3–4): 228–241. https://doi.org/10.1016/j.ecoinf.2010.12.003.
Li, J., and A. D. Heap. 2014. “Spatial interpolation methods applied in the environmental sciences: A review.” Environ. Modell. Software 53 (Mar): 173–189. https://doi.org/10.1016/j.envsoft.2013.12.008.
Li, J., A. D. Heap, A. Potter, Z. Huang, and J. J. Daniell. 2011. “Can we improve the spatial predictions of seabed sediments? A case study of spatial interpolation of mud content across the southwest Australian margin.” Cont. Shelf Res. 31 (13): 1365–1376. https://doi.org/10.1016/j.csr.2011.05.015.
Lloyd, C. 2005. “Assessing the effect of integrating elevation data into the estimation of monthly precipitation in Great Britain.” J. Hydrol. 308 (1–4): 128–150. https://doi.org/10.1016/j.jhydrol.2004.10.026.
Longley, P., M. Goodchild, D. Maguire, and D. Rhind. 2001. Geographic information systems and science. London: Wiley.
Lu, G. Y., and D. W. Wong. 2008. “An adaptive inverse-distance weighting spatial interpolation technique.” Comput. Geosci. 34 (9): 1044–1055. https://doi.org/10.1016/j.cageo.2007.07.010.
Migliaccio, G. C., M. Guindani, M. D’Incognito, and L. Zhang. 2013. “Empirical assessment of spatial prediction methods for location cost-adjustment factors.” J. Constr. Eng. Manage. 139 (7): 858–869. https://doi.org/10.1061/(ASCE)CO.1943-7862.0000654.
Migliaccio, G. C., P. Zandbergen, and A. A. Martinez. 2015. “Empirical comparison of methods for estimating location cost adjustments factors.” J. Manage. Eng. 31 (2): 04014037. https://doi.org/10.1061/(ASCE)ME.1943-5479.0000240.
Miller, I., and M. Miller. 2015. John E. Freund’s mathematical statistics with applications. London: Pearson.
Montero, J., and B. Larraz. 2011. “Interpolation methods for geographical data: Housing and commercial establishment markets.” J. Real Estate Res. 33 (2): 233–244.
Montero, J. M., G. Fernández-Avilés, and J. Mateu. 2015. Spatial and spatio-temporal geostatistical modeling and kriging. Hoboken, NJ: Wiley.
Montero-Lorenzo, J.-M., and B. Larraz-Iribas. 2012. “Space-time approach to commercial property prices valuation.” Appl. Econ. 44 (28): 3705–3715. https://doi.org/10.1080/00036846.2011.581212.
Montgomery, D. C., and G. C. Runger. 2010. Applied statistics and probability for engineers. Hoboken, NJ: Wiley.
Moyeed, R. A., and A. Papritz. 2002. “An empirical comparison of kriging methods for nonlinear spatial point prediction.” Math. Geol. 34 (4): 365–386. https://doi.org/10.1023/A:1015085810154.
Oloufa, A. A., A. A. Eltahan, and C. S. Papacostas. 1994. “Integrated GIS for construction site investigation.” J. Constr. Eng. Manage. 120 (1): 211–222. https://doi.org/10.1061/(ASCE)0733-9364(1994)120:1(211).
Ramsey, F., and D. Schafer. 2012. The statistical sleuth: A course in methods of data analysis. Boston: Cengage Learning.
Rasdorf, W., H. Cai, C. Tilley, S. Brun, and F. Robson. 2004. “Accuracy assessment of interstate highway length using digital elevation model.” J. Surv. Eng. 130 (3): 142–150. https://doi.org/10.1061/(ASCE)0733-9453(2004)130:3(142).
Schexnayder, C. J., S. L. Weber, and C. Fiori. 2003. Project cost estimating: A synthesis of highway practice. Washington, DC: Transportation Research Board.
Shamo, B., E. Asa, and J. Membah. 2015. “Linear spatial interpolation and analysis of annual average daily traffic data.” J. Comput. Civ. Eng. 29 (1): 04014022. https://doi.org/10.1061/(ASCE)CP.1943-5487.0000281.
Shrestha, P. P., N. Pradhananga, and N. Mani. 2014. “Correlating the quantity and bid cost of unit price items for public road projects.” KSCE J. Civ. Eng. 18 (6): 1590–1598. https://doi.org/10.1007/s12205-014-0445-y.
Talmaki, S., V. R. Kamat, and H. Cai. 2013. “Geometric modeling of geospatial data for visualization-assisted excavation.” Adv. Eng. Inf. 27 (2): 283–298. https://doi.org/10.1016/j.aei.2013.01.004.
Tobler, W. R. 1970. “A computer movie simulating urban growth in the Detroit region.” Supplement, Econ. Geogr. 46 (S1): 234–240. https://doi.org/10.2307/143141.
Tziachris, P., E. Metaxa, F. Papadopoulos, and M. Papadopoulou. 2017. “Spatial modelling and prediction assessment of soil iron using kriging interpolation with pH as auxiliary information.” ISPRS Int. J. Geo-Inf. 6 (9): 283. https://doi.org/10.3390/ijgi6090283.
Washington DOT (Department of Transportation). 2015. Cost estimating manual for projects. Olympia, WA: Washington DOT.
Weber, D., and E. Englund. 1992. “Evaluation and comparison of spatial interpolators.” Math. Geol. 24 (4): 381–391. https://doi.org/10.1007/BF00891270.
Webster, R., and M. A. Oliver. 2001. Geostatistics for environmental scientists (statistics in practice). Chichester, UK: Wiley.
Wilmot, C. G., and B. Mei. 2005. “Neural network modeling of highway construction costs.” J. Constr. Eng. Manage. 131 (7): 765–771. https://doi.org/10.1061/(ASCE)0733-9364(2005)131:7(765).
Zhang, S. 2010. “Validation of geographically based surface interpolation methods for adjusting construction cost estimates by project location.” Master’s thesis, Dept. of Civil Engineering, Univ. of New Mexico.
Zhang, S., S. M. Bogus, C. D. Lippitt, and G. C. Migliaccio. 2017. “Estimating location-adjustment factors for conceptual cost estimating based on nighttime light satellite imagery.” J. Constr. Eng. Manage. 143 (1): 04016087. https://doi.org/10.1061/(ASCE)CO.1943-7862.0001216.
Zhang, S., G. C. Migliaccio, P. A. Zandbergen, and M. Guindani. 2014. “Empirical assessment of geographically based surface interpolation methods for adjusting construction cost estimates by project location.” J. Constr. Eng. Manage. 140 (6): 04014015. https://doi.org/10.1061/(ASCE)CO.1943-7862.0000850.
Information & Authors
Information
Published In
Journal of Construction Engineering and Management
Volume 145 • Issue 8 • August 2019
Copyright
©2019 American Society of Civil Engineers.
History
Received: Jun 18, 2018
Accepted: Jan 3, 2019
Published online: May 31, 2019
Published in print: Aug 1, 2019
Discussion open until: Oct 31, 2019
Authors
Metrics & Citations
Metrics
Citations
Download citation
If you have the appropriate software installed, you can download article citation data to the citation manager of your choice. Simply select your manager software from the list below and click Download.