[OpenSpending] New Satellite site budget Rotterdam

Marco Voormolen marco.voormolen at gmail.com
Fri Mar 28 17:34:37 UTC 2014

Hey Ton,

Thanks for you response. The choice for future years has to do with the
fact that the city of Rotterdam re-structured the categorization of their
budget in 2012 and 2013. So the structure is completely different than
before from 2013 onwards. And they even made a change in 2014 again. It is
a wish to also have the data of previous years displayed in the future

As for the IV3, I wasn't familiar with that term. Looked into the datasets
at openspending.nl, very interesting. Converting to openspending should be
doable I guess (Too bad VBA doesn't work too well in Excel with Wine
(Ubuntu), but I'd have to look into that. (Do you have any idea what the
'hoofdfuncties' in the left column column are and what all the numbers

The stuff you're working on sounds very cool! Let's keep each other updated!



2014-03-27 9:06 GMT+01:00 Ton Zijlstra <ton.zijlstra at gmail.com>:

> Hi Marco,
> I had seen this. Good stuff, especially how it was introduced as a parting
> gift from a city council member, which gave put it in the center of
> attention.
> Is it a deliberate choice to only provide budgets for future years? How
> about comparing budgets and spending from previous ones. Has Rotterdam made
> IV3 spending reporting public (the stuff they normally send to the
> statistics office)? Comparing actual spending to planned and previous
> spending, or even to comparable local governments elsewhere, such as is
> being done at openspending.nl, I think might be more insightful than mere
> budgets. Any plans along those lines?
> Have you ever played around with IV3 spending reports from the city? I
> have collected the IV3 data from a whole bunch of local governments. Next
> to giving the data to openspending.nl I have tried my hand at converting
> the IV3 spreadsheets into CSV for use at OpenSpending.org but it is a slow
> process. Maybe you have any experience you can share?
> (btw, I am bringing spending and budget data for all 25 local governments
> in the Province Overijssel, 2009-now.
> http://www.zylstra.org/blog/2014/03/an-exercise-in-freedom-of-information-local-spending-data/Which I aim to add to
> openspending.org. Also just started an open data project for the Province
> North-Holland, with 10 local govs. It is likely that as part of that the
> spending data from many of the 53 local govs in that Province will become
> available sometime this year)
> best,
> Ton
> ---------------------------------------------------------------------------
> Interdependent Thoughts
> Ton Zijlstra
> ton at tonzijlstra.eu
> +31-6-34489360
> http://zylstra.org/blog
> ---------------------------------------------------------------------------
> On Thu, Mar 27, 2014 at 8:53 AM, Marco Voormolen <
> marco.voormolen at gmail.com> wrote:
>> Dear all,
>> Anders asked me to share with you the news that we produced an
>> Openspending Satellite site for the budget of Rotterdam. It (at this point
>> in time) contains the 2014 budget. As well as the slightly customized
>> treemap, it has a customized multi-year barchart and a table that shows the
>> changes over te years.
>> Loading times are a bit unfortunately, because I'm still making more
>> Openspending API calls than would be strictly necessary.
>> Check it out here: http://begroting.middeninrotterdam.nl/begroting.html
>> I'd love to hear any tips/ideas/improvement! Hope you like the site!
>> _______________________________________________
>> openspending mailing list
>> openspending at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/openspending
>> Unsubscribe: https://lists.okfn.org/mailman/options/openspending
> _______________________________________________
> openspending mailing list
> openspending at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/openspending
> Unsubscribe: https://lists.okfn.org/mailman/options/openspending
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending/attachments/20140328/236d2ab3/attachment-0002.html>

More information about the openspending mailing list