Data collection and asset management for public infrastructure