[OpenSpending] Uploading California City Expenditures to Open Spending

Wed Jul 24 20:41:00 UTC 2013

Hi Marc,

That's really cool. I've downloaded your CSV and, as it's quite small, I
would upload them all to a single dataset. It's almost always better to
keep all related data in a single dataset, with multiple years and cities,
than to break them by city or whatever.

I saw that you create /pscs_sf_2012. I would suggest you to simply create
/pscs, or /california, whatever makes more sense to you, and throw
everything in there. It makes it easier to work. If you want to see just
one city/year, you can filter using OpenSpending.

Cheers!

Vítor Baptista

Developer  |  http://vitorbaptista.com |
LinkedIn<http://www.linkedin.com/in/vitorbaptista>|
@vitorbaptista <http://twitter.com/vitorbaptista>

The Open Knowledge Foundation <http://okfn.org>

*Empowering through Open Knowledge*

http://okfn.org/  |  @okfn <http://twitter.com/okfn>  |  OKF on
Facebook<https://www.facebook.com/OKFNetwork> |
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter/>

2013/7/24 Marc Joffe <marc at publicsectorcredit.org>

> My group has pulled actual expenditure data for 260 California cities from
> their audited financial statements.  We present this and other data at
> http://www.publicsectorcredit.org/ca. I just uploaded the expenditure
> data for one city to OpenSpending you can see it at
> http://openspending.org/pscs_sf_2012/views/san-francisco-expenditures-2012
> .****
>
> ** **
>
> I have also dumped the spending data for all 260 cities to a CSV file at
> http://www.publicsectorcredit.org/openspending/California_City_Expenditures.csv.
> This file could be broken up into 260 separate city files and uploaded one
> by one – a time consuming process. If anyone has thoughts about how to
> automate the upload of all this data to OpenSpending I would love to hear
> them. ****
>
> ** **
>
> Marc Joffe****
>
> Public Sector Credit Solutions****
>
> http://www.publicsectorcredit.org****
>
> ** **
>
> _______________________________________________
> openspending mailing list
> openspending at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending
> Unsubscribe: http://lists.okfn.org/mailman/options/openspending
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending/attachments/20130724/c3174456/attachment.html>