Cross-Departmental Collaboration: Turning Siloed Data into Shared Insight

One pivotal moment in my career as a GIS analyst came during a proposed redesign of a major arterial roadway. Initially scoped as a routine resurfacing project, the initiative took a significant turn after we aggregated data from multiple departments, including transportation, public health, and emergency services. A shared dataset revealed a pattern of pedestrian injuries concentrated around intersections near schools and senior housing facilities. This insight prompted a reevaluation of the project’s goals, shifting from mere pavement replacement to a comprehensive redesign that included traffic calming measures, upgraded crosswalks, and bicycle lanes.
The key to this shift was not just the availability of data, but the willingness of departments to share and interpret it together. Transportation planners brought in collision reports, while public health staff contributed data on injury severity and hospitalization rates. Emergency services provided response time analytics, which were layered spatially in our GIS platform. This collaborative approach, enabled by interoperable data systems and shared dashboards, resulted in a safer and more inclusive design. The project ultimately received additional funding through a state pedestrian safety grant, which likely would not have been pursued without this integrated planning approach.
Data Integration Challenges and the Importance of Context
Integrating data from multiple sources often reveals inconsistencies that require both technical skill and contextual understanding to resolve. For example, parcel data from the planning department may use different geocoding conventions than utility infrastructure maps maintained by the public works department. Without standardization, overlaying these datasets can result in misalignments that skew analysis. In one project involving stormwater infrastructure upgrades, we discovered that address mismatches between permitting records and asset management databases were causing planners to overlook properties at risk of flooding.
Addressing these discrepancies required not only data cleaning but also active engagement with the domain experts who manage each dataset. A regular working group with representatives from planning, utilities, and IT allowed us to define shared data standards and implement consistent update protocols. These conversations also uncovered valuable institutional knowledge not captured in digital formats, such as historical infrastructure modifications or undocumented easements. By embedding this qualitative context into our spatial analysis, we improved both the reliability of our models and the trust stakeholders had in our recommendations.
Engaging Non-Technical Partners Through Visualization
One of the most effective ways to bridge the gap between technical analysis and policy decision-making is through intuitive, interactive visualizations. In a recent downtown revitalization project, we developed a web-based map tool that allowed community members and city council members to explore proposed streetscape changes alongside demographic, economic, and mobility data. Unlike static reports, these visualizations allowed users to toggle between scenarios, adjust assumptions, and immediately see projected impacts on traffic flow and pedestrian access.
This approach proved especially valuable during public engagement sessions. Residents could visualize how changes to bus stop locations would affect walkability, while business owners examined how loading zone adjustments might impact deliveries. Visual storytelling not only improved transparency, but also invited input that altered final design choices. For instance, an initially planned removal of a left-turn lane was reversed after visual simulations showed a significant increase in travel time for emergency vehicles. Empowering non-technical stakeholders with accessible data visualization tools enhances both the legitimacy and quality of infrastructure decisions.
Openness and Mentorship as Catalysts for Better Planning
Throughout my work, I’ve found that openness to feedback and a culture of mentorship significantly enhance the utility of data in planning decisions. Early in my career, a senior planner encouraged me to present not just the outputs of our spatial models, but also the assumptions behind them. This practice, now standard in our department, has improved the quality of dialogue between analysts and decision-makers. When stakeholders understand the model inputs, they’re more likely to contribute insights that refine both the data and the outcomes.
Mentorship also plays a critical role in building the cross-functional fluency needed for data-driven infrastructure planning. Over time, I’ve mentored public works staff on how to use GIS for asset tracking, while they’ve helped me understand the operational constraints of managing underground utilities. These reciprocal relationships not only build trust but also foster a shared language around infrastructure challenges. As a result, data is no longer viewed as an external product but as a collaborative tool developed and refined through ongoing partnership.
Commitment to Technical Growth and Equity
Staying current with emerging tools and methodologies is essential to providing actionable insights in infrastructure planning. Recently, we incorporated machine learning techniques to analyze maintenance patterns across city-owned bridges, identifying clusters of deferred repairs that correlated with historically underinvested neighborhoods. This type of analysis, while technically complex, provided a clear, data-backed rationale for rebalancing capital improvements funding and addressing long-standing service disparities.
Equitable planning requires more than just identifying where gaps exist. It involves continuously improving our methods to uncover blind spots in conventional analysis. For example, integrating crowd-sourced data from mobility apps and community surveys has revealed micro-level barriers to accessibility that traditional datasets often miss. By committing to both technical growth and ethical accountability, we can ensure that our infrastructure investments not only enhance efficiency but also serve the broader goal of social equity in municipal governance.
Bibliography
National Association of City Transportation Officials. Designing Streets for Safe and Sustainable Urban Mobility. New York: NACTO, 2020.
Federal Highway Administration. Data Integration for Infrastructure Asset Management. Washington, DC: U.S. Department of Transportation, 2018.
U.S. Department of Housing and Urban Development. Case Studies in Data-Driven Community Planning. Washington, DC: HUD User, 2021.
Center for Government Excellence at Johns Hopkins University. Data Visualization for Public Decision-Making. Baltimore: GovEx, 2019.
American Planning Association. Equity in Infrastructure Investment. Chicago: APA, 2022.






Join the discussion
Members can read and add comments on every article.