search

CSTARS / farm-budgets-data

Data to populate the Postgres for the farm-budgets-app
2 stars 0 forks source link

Develop a Map of the prices for the individual crops by region #13

Open qjhart opened 9 years ago

qjhart commented 9 years ago

Judy sez that this all comes from the NASS input data. Quinn will verify? Boon-Ling sez don't review these at all.

qjhart commented 9 years ago

@blyeo The additional input that is required by SWAP is the price of the commodities. This issue note seems to say you think this is complete. Do you think commodity price should be included in this database?

blyeo commented 9 years ago

We have all the commodity prices from the BCAM input Excel files. When you say be included in the database, do you mean be included as an item here: https://github.com/CSTARS/farm-budgets-data/tree/master/data ?

On Fri, Apr 3, 2015 at 3:03 PM, Quinn Hart notifications@github.com wrote:

@blyeo https://github.com/blyeo The additional input that is required by SWAP is the price of the commodities. This issue note seems to say you think this is complete. Do you think commodity price should be included in this database?

— Reply to this email directly or view it on GitHub https://github.com/CSTARS/farm-budgets-data/issues/13#issuecomment-89433865 .

qjhart commented 9 years ago

@blyeo I think we should use the same Table as we use for the price of the materials; so that means A CSV files in the form of:

item,location,year,price

Are the prices by county? State? or CMZ?

blyeo commented 9 years ago

The incumbent crop prices are by crop and by CMZ. Would you mind showing me where this Table you'd mentioned below is sitting at and how I can add data to it? We have all of this information already in an Excel format-in the thisistheonemaster worksheet.

On Apr 9, 2015, at 10:30 AM, Quinn Hart notifications@github.com wrote:

@blyeo I think we should use the same Table as we use for the price of the materials; so that means A CSV files in the form of:

item,location,year,price Are the prices by county? State? or CMZ?

— Reply to this email directly or view it on GitHub.