San Diego's StreetsSD is an interactive data visualization charting road repairs across the city, allowing residents to track progress and access detailed information about streets and road repairs. The system uses a 100-point based system to classify streets as "Good", "Fair", or "Poor" and enables prioritization of repairs over the next five years. This initiative is part of the City of San Diego's efforts to foster the development of smart cities with open data at both local and global levels, joining major cities like New York and London in incorporating deep insights from open data into their management projects. The system updates automatically to provide residents with accurate information about streets in every neighborhood, making it a valuable tool for civic engagement and transparency. CARTO has been committed to democratizing open-data knowledge and supports smart city initiatives, including the Open Cities Summit, where attendees can learn more about how location intelligence can enhance their next initiative.