Specified query has no data, consult FAOSTAT

[luxusdata]

Hello,

I have an issue when trying to download data from FAOSTAT. A query has no data. Could you please confirm? Could it be fixed?

wheatYield = getFAOtoSYB(name = "wheatYield", domainCode = "QC",
itemCode = 15, elementCode = 5419)$entity

Thank you in advance.

[filippogheri]

Hi,
thanks for your message. The problem comes from the fact that FAOSTAT system has been completely reviewed and for this reason the query structure as constructed by the current R FAOSTAT package is no longer valid. I need to implement important changes to the package. I will try to do this as soon as possible.

Really sorry for any inconvenient this might have caused.

Cheers,

Filippo

[paulrougieux]

In the mean time you can load FAOSTAT bulk data into R. For example I downloaded forestry data from the Forestry Production and Trade page.

 forestry <- read.csv(unz("data-raw/Forestry_E_All_Data_(Normalized).zip",
                     "Forestry_E_All_Data_(Normalized).csv"), stringsAsFactors = FALSE)

I have compared it to data I had stored last year with the FAOSTAT package. Sawnwood production values are the same except for a few changes for China (maybe due to the multiple China issue) and also some other countries for 2014 and 2015, probably due to update concerning those recent data points.

[thiagoveloso]

@filippogheri congratulations for your excellent work on the FAOSTAT package. I was just wondering if the recent errors could be fixed already?

I look forward to using this package again!

Cheers,
Thiago.

[ghost]

any progress on updating the FAOSTAT package? it still doesnt seem to work.

[fbiga]

Here is a gist with a couple of functions which load faostat bulk data into R data frames:
https://gist.github.com/fbiga/0f94080bc9e645184a4368639b81d35a