Latest Contributions by jaykapalczynski

Yea I picked that up and made the change in my testing yesterday....thanks So this is what I have right now...I get this error...thoughts? I assume a date format issue? Questions: I dont see how this query is looping through each Boat Ramp Name, The fc variable the query is running against might not even have the Boat Ramp in it ( in fact I know it does not have all the unique boat ramps in it).   Thats why I created the LIST called "myBoatRampList".  This contains all the unique Boat Ramp Names. I assumed I would loop through the LIST (myBoatRampList) reading each unique Boat Ramp name. On each pass through the loop verify if there has been a record created for that specific boat ramp in the last 30 days. If not then write that to a second LIST (notInspected).  This will be the list of Boat Ramps that do not have inspection in the last 30 days. Traceback (most recent call last): File "E:\ArcGISProjects\BoatRampFacilities\PythonScripts\PythonSync\PythonScripts\~6_30days ago.py", line 44, in <module> for row in cursor: RuntimeError: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]Operand type clash: datetime2 is incompatible with int] [DGIF_TEST.DBO.BRs_Boat_Ramp_Inspection_2] arcpy.env.workspace = "C:\\Users\\xxx\\AppData\\Roaming\ESRI\\Desktop10.4\\ArcCatalog\\[email protected]" fc = "xx" var_additionalcomments = 'additionalcomments' var_CreationDate = 'CreationDate' var_Creator = 'Creator' headers = ['comments','Creation Date','Creator'] QueryFields = [var_additionalcomments,var_CreationDate,var_Creator] # Get Date 30 days ago import datetime as DT today = DT.date.today() month_ago = today - DT.timedelta(days=30) print month_ago # Get list of all Boat Ramps myLayer = "BoatRampsWGS" myField = "SITENAME" myBoatRampList = [row[0] for row in arcpy.da.SearchCursor(myLayer, myField)] print myBoatRampList # Loop through List of Boat Ramps and return those that dont have inspection within 30 days notInspected = [] dateQry="""CreationDate > date{} AND CreationDate < date{}""".format(month_ago, today) myField1 = "CreationDate" #with arcpy.da.SearchCursor(myLayer, ['CreationDate', 'additionalcomments'], dateQry) as cursor: with arcpy.da.SearchCursor(fc, myField1, dateQry) as cursor:     for row in cursor:         print(row)         CreatevalDate = str('{0},{1},{2}'.format(row[0],row[1],row[2]))         notInspected.append(CreatevalDate)         ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

While writing the below I had a thought...where in that example is it taking the unique Boat Ramp Names from the Array and looping through each one to determine if that specific boat ramp has an inspection date in the last 30 days....  I then need a list of each boat ramp that does not have an inspection in the last 30 days....mind you each boat ramps has hundreds of existing inspections.  Im really confused. It looks like that query is giving me the boat ramps that were inspected in the last 30 days...not the ones that have not been inspected... I try this: myLayer = "BoatRampsWGS" myField = "SITENAME" # Loop through List of Boat Ramps and return those that dont have inspection within 30 days notInspected = [] dateQry="""CreationDate > date%s AND CreationDate < date%s"""%month_ago %today with arcpy.da.SearchCursor(myLayer, ['CreationDate', 'additionalcomments'], dateQry) as cursor:     for row in cursor:         #print(row)         print('{} is in default of {}'.format(row[0], row[1])) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ and get this error: Traceback (most recent call last): File "E:\ArcGISProjects\xxxx\PythonScripts\PythonSync\PythonScripts\xxx.py", line 76, in <module> dateQry="""CreationDate > date%s AND CreationDate < date%s"""%month_ago %today TypeError: not enough arguments for format string‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Is this saying :  Greater than the month_ago variable and less than todays date? dateQry="""InspectionDate > date%s AND InspectionDate < date%s"""%month_ago %today ... View more

Using SQL. How would I reformat it? ... View more

I know I am missing the ] at the end of this line....copy and paste issue QueryFields = [var_additionalcomments,var_CreationDate,var_Creator ... View more

I get totally different numbers for each...as you alluded to..not sure why UNION               = 1275 records SPATIAL JOIN   = 2076 records So trying to figure out whats up with all that.... The spatial join gives me the County Polygon...when I select a County I can see the records but they select with the WHOLE County boundary...I cant see their individual boundaries... Thoughts? Can I explode them out or something?  Like the UNION gives me? ... View more

ok gonna try that now. ... View more

Am I doing a Union or a Spatial Join with Intersect? ... View more

Dang that was it...thanks.... I have one more question sort of unrelated and might just post in another post... I have vehicle Laptops that have GPS...Can I tie this into the vehicles GPS...not on a phone? ... View more

I have a BasemapToggle, HomeButton and Search written in the same fashion and same location in the HTML, JS, and CSS files...Its just the LocateButton that dissapears ... View more

Yea that part I understand...just want to confirm...just gonna give this a test...and add the Fail safe another day. Thanks for your thoughts. Any examples of the code to do the testing?  Creating the log file and then testing if it exists?  I assume I do this in the python script and not in the Bat file. ... View more