Latest Contributions by DavidPike

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

The custom print service may only be for Portal? It is ArcGIS server documentation. ... View more

I would have thought that you create the match table each time to reference your parcel id ... View more

The dataframe can absolutely be set  unfortunately the layout properties to go with it can only be set through arcobjects. ... View more

I would buffer to the envelope of your parcel then use simple trig to construct lines to split that envelope and then clip you parcel to the split envelope. ... View more

I'm straying out of my comfort zone, but I would think you specify the match table in your tool, I.e a tool parameter would be the parcel ID then your attachment path. ... View more

Oh cool. If your gdb is in your data store you should be able to write straight into it. The gp service you create should have 'allow uploads ticked' which should allow you to specify the path from your phone. This is from a portal perspective unfortunately tho. ... View more

Hi Jay, What exactly do you want to do? ... View more