Parking Data Format

Here is 2009 Parking Data:

http://sites.google.com/site/uhcarbonfootprintfiles/files/uhgreenreport.xlsx?attredirects=0


Below is email from Fidel Ramirez describing data:
---
Barry,
Here's the raw data I spoke about. The query brings in all the license
plate records for a customer and then display the make, model and year
of the vehicle if available.

The data is structured so that all records for a single customer are
grouped and separated with two spaces from the next customer. My
recommendation (and it involves manual work) is to narrow it down to one
record per customer based on which entry has the most usable
information.

For example:

For customer 2051 we could go with the Mercedes since it gives us the
most information.
2051 1002953 77062-3640
2051 1002953 77062-3640
2051 1002953 77062-3640
2051 1002953 77062-3640 Ford
2051 1002953 77062-3640 Mercendes-Benz 300
2051 1002953 77062-3640
2051 1002953 77062-3640

For customer 2069, we simply remove the other entries.
2069 1002865 77061-2145
2069 1002865 77061-2145
2069 1002865 77061-2145 Kia Sorento 2007
2069 1002865 77061-2145

For customer 204346, we have the Zip code but no vehicle information so
we will need to figure out some other metric to use.
204346 1016335 77346-3269
204346 1016335 77346-3269
204346 1016335 77346-3269
204346 1016335 77346-3269

I hope this is helpful. We can discuss more at length what information
we have available in the parking system at the next meeting.
Thanks,

Fidel G Ramirez
Assistant Director
Parking & Transportation
University of Houston
fgr@uh.edu 713-743-5844