Latest Contributions by QiuhuaMa

I think I figured out the problem. Input Field Shape_area is 0 in my new data. thanks, qiuhua ... View more

Xander, is there a problem with the code?  I want to calculate number of fires and average size of fires within 5km of a houses in the past 7 years. I saw that number of fire is 1 but max, min and average size of fire is 0. if there is only one fire, these sizes should be the size of that fire, right? ... View more

Xander, I am a little confused about dist2fire and fireoid. They refer to the nearest fire burned in the past 7 years or the nearest one burned within 5 kms in the last 7 years? thanks, qiuhua ... View more

Yes, you are right! Most houses in my data are located in the city and far away from the fires. With 25km, 70% of the houses should have more than one fire! Qiuhua ... View more

Xander, Thanks so much! however I cannot see which line restrict distance, # of fires and average size of fires within 5kms of a house in the past 7 years! Qiuhua ... View more

Hi, another way to examine the effect of fire on house price is to check number and size of fire within a certain distance in the last 7 years. I would like to count number of fires within 5km of a house in the past 7 years, then calculate their average size! Can this be done using python? THANKS SO MUCH, chelsea 2015年4月10日 下午5:25于 "Xander Bakker" <geonet@esri.com>写道： GeoNet <http://jiveon.jivesoftware.com/wf/click?upn=Dg1s4x8le7Lmxv8KWGaqo8h7SGfRSMkw-2FpvHGF9-2FW3rK-2Bvs1kL9-2FnG6jjf2NZhrLDz0M-2BrY-2By9IaziQEKVk3Hg-3D-3D_cklnSfGWc0xtrUWz22hpfRmL-2BltIn2gVqEZxa2WpZ5WxnKfgSyyLU2hOb5I9HulWredg8bzBclHT-2Bssd3ileiOvLFQa-2FmBCtTaSqDGUHKu4XnPDXbl4Ut-2FMsay6tDfBzbVyLltMUwOlSIVVR-2BV5NMQcQfabq6bnsJ3h2e1w1qxNeHuvAFqXMl-2Fgn3Jq-2FWu3P1S-2FUEe4CHuJjCedZY-2BH76WvpBn6acAcWT4wYCAVAPnSBQ3MG2e01gVAgY-2FP54joxFx3SrBDvBPCJclBcl-2B3JuMZQtE3dW34Cm4Y7KaLDVIyvFkRba7LQTlzH6ZiELIuu> add time constraint to near tool reply from Xander Bakker <http://jiveon.jivesoftware.com/wf/click?upn=Dg1s4x8le7Lmxv8KWGaqo7A4BXwO9PY1WvQ5cXCtK4-2FJIS3CK9JWidf-2FyI744iulp2nFUojYk8SjUF04OfNOXam6B1F7Qh0-2B9QYrDAA5RTM-3D_cklnSfGWc0xtrUWz22hpfRmL-2BltIn2gVqEZxa2WpZ5WxnKfgSyyLU2hOb5I9HulWredg8bzBclHT-2Bssd3ileiOvLFQa-2FmBCtTaSqDGUHKu4XnPDXbl4Ut-2FMsay6tDfBzYMfGzF0tzxGItU0XBAVRvIFK1Crre-2BQMAzijTGJvPtjjVYP9Y2zQdaiYRPZQVTXdLWrglYoGLlp7tj9o4J8kB32EMk-2BdykdvaaHciSVPu0coHhC9yF25LKcHvkBr1y2gAnZn7Nufsz3QlcJ-2Fmb-2BV9l9nGGoVsfujd2BJdCilzosqp8OjRNjyb4CuZDTW9M7-2F> in Python - View the full discussion <http://jiveon.jivesoftware.com/wf/click?upn=Dg1s4x8le7Lmxv8KWGaqo0VQjeJBYpG9HGC8QZBT-2FEx1rLkR8-2Fx-2FWdOrqbWRfYSj-2Bj-2F8IDaEgj29-2BmPV8A-2By0H03mtjLHTpxxgI2CO1cdwQ-3D_cklnSfGWc0xtrUWz22hpfRmL-2BltIn2gVqEZxa2WpZ5WxnKfgSyyLU2hOb5I9HulWredg8bzBclHT-2Bssd3ileiOvLFQa-2FmBCtTaSqDGUHKu4XnPDXbl4Ut-2FMsay6tDfBzmKBKWVY715nrdJfp-2FROf-2BiJjyGh0EpaBnitt8dOcfj8-2FIpvsZkweBZlgU8P46bbtoaUsygjnX-2Bj83goL3QHpLVW5CqZCUL-2Fv0eXXfNhrRuQ5TpEhowkCZPUIt9zUhX6lNio2ms1y3ULw3lXOtWDOOXPhz7pltNlXOR9jdHaCaabEZ8BTMt899G3wLZUdw7oA> ... View more

Yeah, the problem is some houses don't have a valid sale date! After deleting these data, it works. thanks, Chelsea ... View more

I just corrected this error: IOError: "C:\Forum\DistFireHouse\shp\housesaledata.shp" does not exist but still got the message: Runtime error Traceback (most recent call last): File "", line 74, in chkDate File "C:\Python27\ArcGIS10.1\lib\site-packages\dateutil\relativedelta.py", line 247, in __radd__ raise TypeError, "unsupported type for add operation" TypeError: unsupported type for add operation ... View more

I tried this code with another house sale data. This data has different fields from the one I posted, but still has house id and sale date. I got the following message: Runtime error Traceback (most recent call last): File "", line 36, in addField File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\__init__.py", line 1075, in ListFields return gp.listFields(dataset, wild_card, field_type) File "c:\program files (x86)\arcgis\desktop10.1\arcpy\arcpy\geoprocessing\_base.py", line 344, in listFields self._gp.ListFields(*gp_fixargs(args, True))) IOError: "C:\Forum\DistFireHouse\shp\housesaledata.shp" does not exist any idea what happened? Chelsea ... View more

thanks for the reminder about overwriting problem. Actually I get confused starting at # loop through houses! Is this loop still consistent with what you posted earlier? For each house, find all fires in the past 7 years based on house sale date. Then calculate distance of each fire to the house and store the shorted one! Chelsea ... View more

thanks so much, Xander! I am a Econ student and don't have any programming skills. I tried read your script but can only understand a few. I will run your code and compare it to results that I got earlier to see whether they are consistent. Except for fire history in the past 7 years, I also would like to do fire history in the past 10, 15 and 20 years. It seems to me that I only need to change the code in the following 2 lines: def chkDate(date_sale, year_fire, month_fire, day_fire): date_fire = datetime(year=year_fire, month=month_fire, day=day_fire) date_2monthsbefore_sale = date_sale + relativedelta(months=-2) year_sale = date_sale.year test = (year_fire >= year_sale - 7) and (date_fire < date_2monthsbefore_sale) if test: print "date_sale: print "date_fire: ".format(date_sale) ".format(date_fire) print "date_2monthsbefore_sale: print "year_sale: ".format(date_2monthsbefore_sale) ".format(year_sale) print " < < ".format(year_sale-7, date_fire, date_2monthsbefore_sale) return test if __name__ == '__main__': main() Am I right? Are there any other changes that I need to make? thanks, Chelsea ... View more

the end time of fire need to be 2 month earlier than house sale time since most sale process took longer than 2 month. ... View more

Xander, you are right! Each house has a different sale date. I didn't define the maximum search distance. What you said is exactly what I want to do! I tried to do this manually but it took so much time! I attached part of my house sale data and fire history data. Parcelid is parcel id for each house. Ma_date_dt is sale date of each house. For each fire, I have fire_day, fire_month and fire_year! If a house is sold on 07/15/2013, I would like to find the nearest fire to this house that burned between 2006 and 05/2013. if a house is sold on 05/02/2011, I would like to find the nearest fire to the house that burned between 2004 to 03/2011. I would like to restrict the beginning time to year but the end time to month/year. thanks so much, Chelsea ... View more