The city of Corpus Christi is owed $5 million in unpaid codes fines -- and Texas Watchdog has mapped the violations and posted an online spreadsheet of the totals.

You may have seen our post from yesterday about the fines. The Corpus Christi Caller-Times reported on them and, using the Texas Public Information Act, obtained and posted a 148-page listing of the fines owed.

The list from the city doesn't add up the totals owed on each parcel or by each owner. So we took the list, crunched the numbers, and put the totals in a spreadsheet that we've embedded below. The listing -- about 2,200 entries -- is in order, from the largest amount owed to the smallest.

We've also taken the list and mapped it on an interactive Google Map below. Click on the red balloons to see the address, the name of the person or entity fined, and the amount owed (including interest). The map below may only show the downtown area, but you can use your mouse to pan around and see the balloons all over the city.

A couple of notes:
+ As you move around the map, it may take a second for all the red balloons to pop in -- that's because there are so many balloons on the map.
+ The list and the map are grouped by address by owner -- so, if multiple owners were fined for the same parcel, each owner has their own entry and their own balloon on the map. (For instance, four owners were fined for 217 Luna St., and each has a separate listing and a separate total owed.)
+ There were about 25 or so addresses that aren't on the map at all -- for most of them, the city didn't provide any address information. For a few of them, the city provided a street name but a house number of zero, so we couldn't map them, either. And a few others just couldn't be found by the geocoder we used.
+ Want to see more? The map is a lot cooler if you look at it in Google's free Google Earth program. Once you're running Google Earth, download and open the .KMZ file we've posted at this link.
+ Do you have other Texas-related government information or data that you think would be helpful on an interactive map, or that could just use some cleaning up? Texas Watchdog wants to know. Drop me a line at jennifer@texaswatchdog.org.
+ Special thanks to the people behind the BatchGeocode.com and EarthPoint.us Web sites, whose free services we used to create the map.






View Larger Map



Keep up with all the latest news from Texas Watchdog -- and join our new network on Ning at http://texaswatchdog.ning.com/! If you haven't already, Fan our page on Facebook, join our group on MySpace, follow us on Twitter, fan us or friend us on Digg and send us links to stories you think we ought to see, join our network on de.licio.us to see what we're bookmarking, and put our RSS feed in your newsreader to get our updates delivered right to your desktop. We're also on NewsVine, tumblr, FriendFeed and YouTube.
[ad#ad1forposts]