current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Sign up ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.
up vote 1 down vote favorite
1

I would like to query a feature classes date range. For instance, if there is data within a 2 day range then I would like to print true or do something else. I thought arcpy.Exist would do the job, but I am missing something here. I guess my arcpy.Exist is only seeing if the variable exists, how would I check to see if the actual where clause is True for my feature layer?

query = arcpy.MakeFeatureLayer_management(fc, "QueryLayer", """Date BETWEEN '2014-02-16 16:53:25' AND  '2014-02-17 18:53:25'""")


try:
    query

finally:
    if arcpy.Exists(query):
        print "true"
    else:
        print "no data"
share|improve this question
    
Note: Cross-posted to Esri's GeoNet –  Vince Apr 6 at 16:49

2 Answers 2

up vote 2 down vote accepted

arcpy.Exists() will check for the existence of datasets, so it should always return true given the way you have it set up here, because query will exist whether there are records in it or not.

You could use arcpy.GetCount_management().

query = arcpy.MakeFeatureLayer_management(fc, "QueryLayer", """Date BETWEEN '2014-02-16 16:53:25' AND  '2014-02-17 18:53:25'""")
count = arcpy.GetCount_management(query).getOutput(0)
if count > 0:
    #do something: at this point you know that the query returned at least one record.

Based on @nmpeterson's answer in this post, you may want to try this alternative method for getting the count (if you're using 10.1+), may be faster:

count = sum((1 for row in arcpy.da.SearchCursor(query, ['OID@'])))
share|improve this answer
    
Hi Mr. Adam, what is "OID@" I am not understanding this syntax. I figured a search cursor would be quicker as I don't need a feature layer. –  Geoffrey West Apr 6 at 14:30
    
"OID@" is the standard way to get the object ID field with the .da cursors. In this case, the cursor only includes one field, "OID@" and it is a field that is guaranteed to exist in every feature class or shapefile. So this sum operation is performed on a list of 1's, as many 1's as there are rows in the cursor, i.e. records in the feature class. More info on using OID@: resources.arcgis.com/en/help/main/10.1/index.html#//… –  mr.adam Apr 6 at 14:50
up vote 1 down vote

This solution works better. 

cursor = arcpy.SearchCursor(fc,"""Date BETWEEN '2014-02-16 16:53:25' AND  '2015-02-17 16:53:25'""" )
for row in cursor:
 print(row.getValue("Date"))


if row.getValue("Date") < datetime.datetime.now():
    print "true"
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.