Dealer locations - Steps to create

[missyschoenbaum]

Make notes here

[RobPNth]

Tim Boyer found a listing of registered dealers. There were 3541. These were assumed to be livestock owners already in the US farm file, from amongst the following farm classes: ['cow_calf_small','feedlot_small','goats','sheep','stockers','swine_enterprise_small','swine_grower_finisher_small','swine_nursery_small','swine_other_small']. There were a total of 1807435 such farms in the file. Therefore, the proportion of these that were dealers was 0.00195913. A python script was written to randomly convert this proportion of the above farm classes to dealers.

Here is the Python code:

import sys, os, string, random

fclassl = ['cow_calf_small','feedlot_small','goats','sheep','stockers','swine_enterprise_small','swine_grower_finisher_small','swine_nursery_small','swine_other_small']

ifile = open("C:\FMD_Modelling\USA\data\us_farm_file4.txt","r") #input file ofile = open("C:\FMD_Modelling\USA\data\us_farm_file5.txt","w") #output file for line in ifile: #each record line = line.strip() id,fclass,cattle,goats,sheep,swine,coords = line.split() if fclass in fclassl: rand = random.random() if rand <= 0.00195913: fclass = "dealer" ofile.write(id+" "+fclass+" "+cattle+" "+goats+" "+sheep+" "+swine+" "+coords+"\n") else: ofile.write(line+"\n") else: ofile.write(line+"\n") ifile.close() ofile.close()

[RobPNth]

I have now uploaded the proc_ffile_dealers.py file. The actual numbers of "dealer" farm class properties in the US farm file is: 3557