I have a list of bridges with various attributes that will be changing as a project progresses. Each bridge includes the lat/long coordinates. It would be really helpful to be able to display these on a map. It would be extra helpful if in the map view the bridges could be color-coded if certain columns are checked and if the view could be filtered using filters in the sheet or reports.

I know I can export this data and bring it into Google Maps or Google Earth, but having the map and the data linked would be best since things change every few days and keeping an external map updated is not feasible.