Home

Sunnyvale, TX

Aren Cambre's picture
Tue, 09/01/2009 - 20:43 — Aren Cambre
Data details
Most recent open records log update: 
2011-01-27
Total TPIA costs: 
$0
TPIA request log: 

Also see the jurisdictions summary page for more per-jurisdiction details.

Date Body Files
Thu, 01/27/2011

Routed thank you letter to Dave through faculty research advisor.
Fri, 06/25/2010

All requested data emailed by Liz Hopkins.
Thu, 06/24/2010

Dave sent another file for review. I wrote back that it's missing a few fields. Dave then sent another file, but it, too was missing a few fields. Gave him a list of additional fields to satisfy request.
Wed, 06/23/2010

Dave sent a new test file for validation. I responded saying the format will probably work. I also suggested that, based on experience with other cities, they may want to export a year or two at a time so as not to overwhelm their system.
Tue, 06/22/2010

Sent Dave instructions on how to pull better data.
Tue, 05/04/2010

Scott wants me to talk with Sunnyvale's Director of Finance and Administration, Dave Cranford.

I replied with my phone number.

Dave later emailed a PDF of what Incode can provide. I wrote back saying that an Incode sales rep said it should be possible to choose Excel instead of PDF for any report. Dave replied that he had worked with an Incode support person for 30 minutes the prior day and that:

Two export files are created when you click the export file prompt. One file, a summary, can be exported into an excel format (see 1st file above). I assume the detail is in the other report which is an XML format and neither I nor the support person could get it open.

Dave also emailed a sample Excel file that he was able to produce from Incode.
Fri, 04/30/2010

Scott Campbell replied saying that they are working with Incode vendor to figure out how to comply with my request.

I replied letting him know that I am contacting Incode (actually Tyler Technologies) about some other cities, too.
Thu, 04/29/2010

Asked Scott Campbell how the request was proceeding.
Fri, 02/26/2010

Town Manager Scott Campbell wrote back thinking he was going to hear from me. He will talk to their IT consultant and call me next week.
Wed, 02/24/2010

Asked Kathryn Dewey what can be done to advance this request.
Wed, 09/16/2009

Discussed the request more over the phone. Assured them that I do not need a response before the statutorily-prescribed 10 day open records limit. They are receptive to exploring a direct export from their underlying database system.
Wed, 09/02/2009

Kathryn Dewey, Town Secretary, acknowledged request.
Tue, 09/01/2009

TIPA request emailed to Kathryn Dewey, Town Secretary (townsecretary@townofsunnyvale.org).
Request status for standard citations: 
Finished
Request status for red light camera citations: 
Has no red light cameras