Latest Contributions by DavidPike

I think the mxd needs to be in the datastore as you're setting the workspace then using list layers I guess? ... View more

Is the mxd in the data store and the data referenced in the mxd through a full network path? ... View more

Is this 1 mxd? Is it registered to the data store? ... View more

Maybe reclassify the 0 to NoData ... View more

What's the source of your rasters? ... View more

Other than setting the display to nearest neighbour I dont know. Would be good to find out if and when you solve it. Good luck! ... View more

And unique values set in the symbology? ... View more

Could be a DRA issue? Are they all set to the same symbology? ... View more

Hi Kathy. Date fields are python datetime objects which can be handy. Field 1 - Field 2     produces a TimeDelta object. TimeDelta.total_seconds()  will produce the number of seconds of the timedelta object. I believe the timedelta will take into account leap years so the result may be off several days from what you may expect. Total_seconds = (TimeField1 - TimeField2).total_seconds() SecInYear = (60*60*24*365.25) Years = Total_seconds/SecInYear This is very basic and prone to error. Hopefully someone can give a better answer ... View more

Ah ok just add underscores as per your parameters ... View more

# Import arcpy module import arcpy arcpy.env.workspace = r"C:\waterfowl\waterfowl\waterfowl.gdb" arcpy.env.overwriteOutput = True # Script arguments Sitename = arcpy.GetParameterAsText(0) if len(Sitename) == 0 : Sitename = "Abgrabung Malsch/Durmersheim" # provide a default value if unspecified Category = arcpy.GetParameterAsText(1) if len(Category) == 0 : Category = "Taucher" # provide a default value if unspecified Specie = arcpy.GetParameterAsText(2) if len(Specie) == 0 : Specie = "Haubentaucher" # provide a default value if unspecified Start_Month = arcpy.GetParameterAsText(3) if len(Start_Month) == 0 : Start_Month = "1" # provide a default value if unspecified End_Month = arcpy.GetParameterAsText(4) if len(End_Month) == 0 : End_Month = "3" # provide a default value if unspecified Start_Year = arcpy.GetParameterAsText(5) if len(Start_Year) == 0 : Start_Year = "1966" # provide a default value if unspecified End_Year = arcpy.GetParameterAsText(6) if len(End_Year) == 0 : End_Year = "2007" # provide a default value if unspecified QueryTable = arcpy.GetParameterAsText(7) if len(QueryTable) == 0 : QueryTable = "QueryTable" # provide a default value if unspecified QueryTable_Statistics = arcpy.GetParameterAsText(8) if len(QueryTable_Statistics) == 0 : QueryTable_Statistics = r"C:\\waterfowl\\Scratch\\scratch.gdb\\QueryTable_Statistics1" # provide a default value if unspecified # Local variables: locationbirdinfo = "locationbirdinfo" #False = "true" #False__2_ = "true" # Process: Make Query Table arcpy.MakeQueryTable_management ("locationbirdinfo", QueryTable, "USE_KEY_FIELDS", "", "", "locationbirdinfo.locationinfo_wvz_zaehlgebiete_oag_karlsruhe_Sitename = " + Sitename + " and locationbirdinfo.birdinformation_KAT_Bezeichnung = " + "'" + Category + "'" + " and locationbirdinfo.birdinformation_ART_Bezeichnung = " + "'" + Specie + "'" + " and locationbirdinfo.birdinformation_Month_ >= " + Start Month + " and locationbirdinfo.birdinformation_Month_ <= " + End Month + " and locationbirdinfo.birdinformation_DAT_Datum >= " + Start Year + " and locationbirdinfo.birdinformation_DAT_Datum <= " + End Year) # Process: Summary Statistics arcpy.Statistics_analysis(QueryTable, QueryTable_Statistics, [[ "locationinfo_wvz_zaehlgebiete_oag_karlsruhe_Sitename", "MAX"],["birdinformation_KAT_Bezeichnung", "MAX"], ["birdinformation_ART_Bezeichnung", "MAX"], ["birdinformation_Month_", "MIN"], ["birdinformation_Month_" , "MAX"], ["birdinformation_DAT_Datum", "MIN"], ["birdinformation_DAT_Datum", "MAX"], ["birdinformation_DAT_Anzahl", "SUM"]], "")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I would consider something along the lines of creating a point at the centroid of the donuts then creating a line due north with length of the maximum buffer distance, or using the donuts geometry to decide. Create points at intersections of that line and the donut's edges then create a line between those points and grab the line length. Actually even better would be to clip that line to the buffer then take the shape length. ... View more

Jeremy, thanks very much for your time. I love the idea of comparing the geometries as opposed to a spatial join. With that in mind I can copy your script into my loop easily. Great idea. ... View more