search

CSTARS / farm-budgets-data

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

Develop a land costs / acre for the entire region. #14

Closed qjhart closed 9 years ago

qjhart commented 9 years ago

Nathan sez there is a cost for land-rent but it's only available by county and irrigated vs, non-irrigated. Nathan used non-irrigated land rent.

qjhart commented 9 years ago

Nathan thinks that this is done annually.

ncparker commented 9 years ago

I've added land rent for irrigated cropland as a data dump from NASS for counties in CA/ID/OR/WA.

qjhart commented 9 years ago

@ncparker, Before I close this issue, I'm going to suggest some minor modifications to your input format, (basically less columns) ,but it looks good, thanks.

blyeo commented 9 years ago

Hi--How do I see the data that has been uploaded?

On Thu, Feb 26, 2015 at 2:14 PM, Quinn Hart notifications@github.com wrote:

@ncparker https://github.com/ncparker, Before I close this issue, I'm going to suggest some minor modifications to your input format, (basically less columns) ,but it looks good, thanks.

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

qjhart commented 9 years ago

It's hard to know this in advance, but Nathan could have automatically upated this issue by referencing #14 in comment when he committed, otherwise, here, I can reference the commit, 91ade2c6033fd84b59987d0bcf77b99ae92e99d8, and you can follow that to see the file(s) he added and modified. You can either download the files individually or better yet, clone the repo on your site.

ncparker commented 9 years ago

Ok I'm slow at learning.. I've reduced the columns and added a 5 digit FIPS code. The file can be found here: farm-budgets-data/data/costs/ucd/NASS land rent 2008-2014.csv

I'll reference the issue next time. I've got the idea now.

blyeo commented 9 years ago

Hi-shall we set up a master excel sheet where we can enter all these data to the corresponding region and crops- SWAP format? Pls also delegate someone to enter the data in the correct format once we agree on the data we want to use for each of the cost categories.

On Feb 27, 2015, at 10:00, ncparker notifications@github.com wrote:

Ok I'm slow at learning.. I've reduced the columns and added a 5 digit FIPS code. The file can be found here: farm-budgets-data/data/costs/ucd/NASS land rent 2008-2014.csv

I'll reference the issue next time. I've got the idea now.

\ Reply to this email directly or view it on GitHub.

qjhart commented 9 years ago

@ncparker I've been draconian in removing columns from this file, I hope that's okay with you.