[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Omaha.pm] Mon Jun 29 7pm - PRI Hack Night!



http://www.meetup.com/Open-Nebraska-Meetup/events/223501025/

Jack Dunn could use some developer help refreshing an Omaha City Council database with recent Tax Increment Financing (TIF) data. 

Let's get together and get this done! :D See you there!

- Jay Hannah 
402-598-7782

http://www.meetup.com/Open-Nebraska-Meetup/events/223501025/





> On Jun 19, 2015, at 1:44 AM, Jack Dunn <office@prineb.org> wrote:
> 
> All,
> 
> The objective of this project is to update two PRI reports on Tax Increment Financing (TIF).  These two reports, which can be found on the Policy Research & Innovation website (www.prineb.org), cover TIF projects for the City of Omaha for the years 2008 through 2011.  I would like to update these reports with data from 2012 through 2014.
> 
> The source data are located in the Archived City Council Journals, which are the minutes of past City Council meetings.  The Journals are PDFs.  I have no interest in the City Council Agendas for this project.
> 
> The Journals for 2014 are found at: 
>     http://www.cityofomaha.org/cityclerk/city-council/journals-a-videos
> Prior Journals are found at:
>     http://www.cityofomaha.org/cityclerk/archived-city-council-documents
> 
> The variables of interest are found in two spreadsheet from a 2011 PRI report:
>     http://www.progressiveresearchinstitute.org/Papers/2011/TIF/revenue_lost.pdf
>     http://www.progressiveresearchinstitute.org/Papers/2011/TIF/ctl_project_name-project_date.pdf
> 
> Both spreadsheets are cited in that 2011 TIF report titled:  What is Tax Increment Financing (and Why Should Anyone Care)? 
>     http://www.prineb.org/Papers/2011/TIF/tif_white_paper2.pdf
> 
> A second, follow up report was published in 2012:
>     http://www.prineb.org/Papers/2012/TIFReportUpdateFinal.pdf
> 
> It would be a great help just to go through the Journals from 2012 through 2014 and capture the TIF ordinance description and attached files.  If there is a way to capture the variables of interest mentioned above for each proposed TIF ordinance, even better!
> 
> There's more that I would like to propose;  for instance, tracking the real estate, banking and construction connections including campaign contributions for City Council members, but let's take one project at a time.
> 
> I'm sure I have left questions unanswered, so please let me know what they are and I'll do my best to respond.
> 
>     Thank you,
> 
>     Jack Dunn
>     Co-Executive Director
>     Policy Research & Innovation
> 
> 
> On 06/18/2015 10:51 PM, Matt Steele wrote:
>> The agendas website is back up and running. Looks like the ElasticSearch service had crashed; it's back up now.
>> 
>> There's not much to the page. A perl script scrapes the site Nate linked, and we convert the PDFs to text (using pdf2text) and place them in a search engine (ElasticSearch) with a web frontend. Still kicking around after 3 years.
>> 
>> On Jun 18, 2015 9:45 PM, "Nate Benes" <natebenes@gmail.com> wrote:
>> Jay, Jack,
>> 
>> http://www.cityofomaha.org/cityclerk/city-council/agendas is the canonical source for these agendas.
>> 
>> During the first Hack Omaha, a team put together a service that automatically downloaded these from the city's website and added them to a simple, searchable web interface.  There's a demo live at http://agendas.dataomaha.com/                 although it seems broken right now.
>> 
>> I bcc'd the original author of that project to see if he knows the current status.
>> 
>> Jack, how would you like to see the agendas presented?  What would a user hope to learn from agendas and how can we best get them that information?
>> 
>> Thanks,
>> Nate
>> 
>> On Thu, Jun 18, 2015 at 4:27 PM Jay Hannah <jay@jays.net> wrote:
>> On Jun 16, 2015, at 2:32 PM, Jack Dunn <office@prineb.org> wrote:
>> > https://github.com/modi1231/ParseCityCouncilToDB
>> 
>> Hi Jack,
>> 
>> So it looks like what you've got there is a pretty simple text parser which then shoves the text into a database. Looks like it's written in C# 4.0.
>> 
>> I suspect that the Omaha City Council documents are PDFs, so the actual data flow is:
>> 
>> download .pdf from somewhere
>>   -> convert .pdf to text
>>   -> parse the text, put it in a database
>>   -> ??? website?
>> 
>> Do you know where the original data source is?
>> 
>> Is it just these agendas?
>> 
>>   http://www.cityofomaha.org/cityclerk/city-council/agendas
>> 
>> The other data that you mentioned -- do you have that data somewhere? Is it all .pdf files?
>> 
>> Thanks,
>> 
>> j
>> 
>> 
>> 
>> --
>> You received this message because you are subscribed to the Google Groups "Open Nebraska" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to open-ne+unsubscribe@googlegroups.com.
>> To post to this group, send email to open-ne@googlegroups.com.
>> Visit this group at http://groups.google.com/group/open-ne.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/open-ne/93B88CBF-3A2E-4A82-B333-9BA08C178606%40jays.net.
>> For more options, visit https://groups.google.com/d/optout.
>> -- 
>> You received this message because you are subscribed to the Google Groups "Open Nebraska" group.
>> To unsubscribe from this group and stop receiving emails from it, send an email to open-ne+unsubscribe@googlegroups.com.
>> To post to this group, send email to open-ne@googlegroups.com.
>> Visit this group at http://groups.google.com/group/open-ne.
>> To view this discussion on the web visit https://groups.google.com/d/msgid/open-ne/CAMjp6Gef%3D9zAoL%3DarqSgiOnMcLhBdNb9Kkak9ypP9ArQuQTC7Q%40mail.gmail.com.
>> For more options, visit https://groups.google.com/d/optout.
>