The latest articles on DEV Community by caio zanetti (@caio_zanetti). https://dev.to/caio_zanetti https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3815184%2Fab80cc27-ad08-443e-90de-c05cd69d0c6e.jpg https://dev.to/caio_zanetti en caio zanetti Mon, 09 Mar 2026 17:42:55 +0000 https://dev.to/caio_zanetti/automating-earthworks-analysis-with-python-and-kml-data-18nc https://dev.to/caio_zanetti/automating-earthworks-analysis-with-python-and-kml-data-18nc <p>In many engineering projects, evaluating terrain and estimating earthworks is still a very manual process.</p> <p>Engineers often draw road alignments in Google Earth, export KML files and then manually calculate slopes, terrain profiles and cut/fill volumes.</p> <p>I wanted to see if this workflow could be automated.</p> <p>So I built a small tool using Python and geospatial data.</p> <h1> The Idea </h1> <p>The concept is simple.</p> <ol> <li>Draw a road or path in Google Earth </li> <li>Export the path as a KML file </li> <li>Upload the file to the application </li> <li>Automatically generate terrain profiles and estimate earthworks volumes</li> </ol> <p>The goal is to quickly evaluate the feasibility of access roads or alignments without going through a complex GIS workflow.</p> <p><a href="https://kml-earthworks.streamlit.app/" rel="noopener noreferrer">app</a><br> <a href="https://github.com/CAIOZANETTI/kml-earthworks" rel="noopener noreferrer">Repository</a><br> <a href="https://www.linkedin.com/posts/eng-caio-zanetti_automatizando-an%C3%A1lise-de-terraplenagem-com-activity-7436727491962200064-aa0r?utm_source=social_share_send&amp;utm_medium=member_desktop_web&amp;rcm=ACoAAAen_5gB_unzDkmA2xIPhqSqVRXDG0xLxAg" rel="noopener noreferrer">linkedin</a></p> automation python showdev sideprojects