Good morning Mark,

 

I have attached a copy of GRU's electric intensity map that you have requested.  Please note it is an electric not energy intensity map.  Please refer to my responses below.  This e-mail serves to meet your public records request via e-mail to me on May 6, 2005.

 

Sincerely,

 

Jill

 

-----Original Message-----
From: Mark van Soestbergen [mailto:mark@icbe.com]
Sent: Friday, May 06, 2005 1:16 PM
To: Jill Womble
Subject: energy intensity map..

 

Mrs. Womble,

 

I recently met with Mr. Kegelman who showed me a fascinating map that illustrated energy intensity in the Gainesville grid.  I was hoping you could provide me a copy as well, and perhaps tell me some more about it. Actually, a bunch of questions arose....

 

Does the map exist in .pdf format? Yes, see the attachment

In case it is, is there a URL you could point me to?

What time period are these averages drawn from?  It is my understanding from technical staff that the data was drawn from calendar year 2003. When was this map created? First quarter of 2005.

The map indicates normalization per 1000 ft2, is it in 100 ft2 increments, or 500 ft2 or to the ft2?

Is there a database or list that ranks users in order? For example, customer x ranks 1265th in the pack, customer y 432nd? No, the map is not customer based

Without counting the colored dots, does a list exist, or is the database queriable to answer how many ft2 is red, how many ft2 is blue etc? Is there a way to create a pie chart that shows energy intensity across the color ranges? Color ranges are based on quintiles, equal number per color

 

Is this map an ad-hoc product, or did it come as part of a report or survey? Ad-hoc

Was the map created using the County Property tax data as a reference, or another list which tracks 'conditioned space' information? County Property Appraisers

 

Is this the first map of its genre, or is this done periodically, and is there also a map that shows changes over time?  This is the first map and no, there is not a map that shows changes over time.

Is there a map that shows solar resources in the Gainesville area, and a derivative product that shows which homes/buildings are fit for solar equipment? None that our professional staff is aware of.

Can this map, or is there a map that distinguishes residential homes from rental apartments? No

 

I know this a bunch of questions all at once, but I really appreciate your help in this matter.

 

Mark van Soestbergen

6651 NW 23rd Ave

Gainesville, FL, 32606-8400

 

Mark,

 

I have a hard copy of the electric intensity map earlier provided to Mr. Kegelman waiting for you at the front desk at GRU.  Please review my responses below.

 

This e-mail serves to meet your public records request via e-mail to me on May 11, 2005.

 

Sincerely,

 

Jill

 

-----Original Message-----
From: Mark van Soestbergen [mailto:mark@icbe.com]
Sent: Wednesday, May 11, 2005 11:14 PM
To: Womble, Jill A
Subject: Re: energy intensity map..

 

Jill,

 

thanks for the quick response. This really helps!

 

Some things are not clear to me. The quintile thing, does it mean there are an equal number of green service points as there are red service points? How could that be? Do the service points neatly divide into five equal portions? Yes

 

The map legend states AvgOfMonthlyAvgKWH; what does that mean, it seems there is one too many average. Is it the average of Jan, Feb.... totaled and then divided by 12?  Technical staff does not understand the question based on the map provided

 

In the letter to Mr. kegelman, you mention the electric intensity is per 1000 of square feet. Is that so? In other words, is the intensity categorized 0 to 1000 ft2, 1000 to 2000 ft2 , and so on? Are the brackets in 1000 ft2 segments? No it is a continuous function.

 

Could this map generating software be used in a similar fashion to show water and gas consumption? No, not with currently available data.

 

And last, as I am collecting various maps of infrastucture etc., of Gainesville, if it is not too much trouble, could I have a hard copy a-la Mr. Kegelman?

 

Thank you, thank you!

 

- Mark

 

Good morning Mark,

 

Public Records Law does not require that an agency create new records in order to accommodate a request for information.  It is my understanding that from technical staff that there is not a record for what you are requesting.

 

Sincerely,

 

Jill

 

-----Original Message-----
From: Mark van Soestbergen [mailto:mark@icbe.com]
Sent: Friday, May 13, 2005 1:03 PM
To: Womble, Jill A
Subject: Re: energy intensity map..

 

Jill,

 

Thanks a bunch, I will be picking up the map soon. I guess I'm beginning to understand better how the map was created, except you could you tell me one more time what AvgOfMonthlyAvgKWH means? Can you give it to me in the form of an example? At times I'm conceptually challenged, but always do much better when I can look at an example.

 

Hope that is no too much trouble for technical staff... please let them know I understand this eats their (and your) time, and that I really appreciate it.

 

- Mark

 

Good morning Mark,

Your public records request of May 25th was forwarded to me for processing by Jill Womble. The Legal Services Department, which is where I work, is responsible for handling all public records requests made of GRU, so please send any future requests to my attention.  I will be glad to provide assistance.

 

  • The dots do not reflect customer accounts, but rather on one map the dots represent service points which are associated with one or multiple residential customer accounts, on the other map the dots represent parcel centroids which are associated with one or multiple service points which in turn are associated with one or multiple residential accounts.

    Due to the fact that the maps were not intended to be authoritative representations but merely indicative of generalized patterns, the data used to generate the maps was the result of dynamic database aggregation query techniques which did not retain identifying information regarding either the customer account or parcels that contributed to the data synthesis.  Therefore the data used for the map does not support an answer to a question regarding a specific account or parcel.

 

  • The variable name "AvgOfMonthlyAvgKWH" on the one map reflects that where multiple accounts are associated with the service point the value is the average of the several customer accounts' average monthly KWH.  If there is only one account associated with the service point, as in a typical single family home, the value is the average monthly KWH of that customer.

 

  • On the other map the square footage value used in computing value for the normalized average monthly KWH per 1000 sq ft value was from the column named "HTSQFT" in an extract from a Property Appraiser's database.

 

This email serves to meet your public records request of May 25, 2005.

 

 

Rita Strother

Sr. Executive Assistant

Utilities Legal Services

Office: 352/393-1015

Fax:    352/334-2277

email: strotherrk@gru.com

 

 

 

Mr. Van Soestbergen:

Attached is the other map.  

To answer your question, a parcel centroid is the center of a parcel.

Making a map with a legend that describes in lay terms how the map is built, would require creating a new record.

 

This email serves to meet your public records request of June 13, 2005.

 

Rita Strother

Sr. Executive Assistant

Utilities Legal Services

Office: 352/393-1015

Fax:    352/334-2277

email: strotherrk@gru.com