nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get the data from HostedFeatureLayer for today's date using python from ArcGIS Online

ChallagundlaSindhuraITS

Curently, I am pulling all the data from the featurelayerid using the below script:

feature_layer_id = ' ' Inspform = gis.content.get(feature_layer_id) insp=Inspform.layers[0].query().sdf insp.to_sql('testtable',con=engine,schema=None,if_exists='replace',index=False,index_label=None,dtype=None,method=None)

The featurelayer has two fields with create date and edit date. would like to pull data where createdate or edit date is equal to sysdate.

How can i achieve this? I am new to python and Arcgis

I browsed some sample notebooks, but no luck

Find more posts tagged with

Accepted answers

JamesCrandall

It's expecting a formatted date. I do something similar to setup where clause for querying the last 24 hours on a feature layer.

from datetime import datetime, timedelta

last_24hour_date_time = datetime.now() - timedelta(hours = 24)
timestamp = last_24hour_date_time.strftime('%Y-%m-%d %H:%M:%S')
whereClause = "CreationDate>= '{}'".format(timestamp)

All comments

ChallagundlaSindhuraITS

Did a workaround other than where clause, Below script worked:

from datetime import datetime, timedelta

last_24hour_date_time = datetime.now() - timedelta(hours = 1200)
timestamp = last_24hour_date_time.strftime('%Y-%m-%d %H:%M:%S')
#print (timestamp) #2022-10-19 18:41:09
filterinsp = insp[insp['CreationDate'] >= timestamp] ### this worked to get all 24 hours data
filterinsp

Thanks for your help!!

ChallagundlaSindhuraITS

Thank You James, The CreationDate format is

2022-10-07 17:46:00.158999808

Tried below statements , but no luck. Please Advise.

inspd=Inspform.layers[0].query(where = "CreationDate>= '{}'".format(timestamp)).sdf
inspd=Inspform.layers[0].query(where = "CreationDate>= '{}'".format(last_24hour_date_time)).sdf

JamesCrandall

It's expecting a formatted date. I do something similar to setup where clause for querying the last 24 hours on a feature layer.

from datetime import datetime, timedelta

last_24hour_date_time = datetime.now() - timedelta(hours = 24)
timestamp = last_24hour_date_time.strftime('%Y-%m-%d %H:%M:%S')
whereClause = "CreationDate>= '{}'".format(timestamp)

ChallagundlaSindhuraITS

Thank You, I tried something like this, I dont want to hard code the date. It should be sysdate.

insp=Inspform.layers[0].query(where =" CreationDate > [datetime(2022, 10, 7)]").sdf ; I am trying to figure out the correct syntax

JamesCrandall

You probably just want feature_layer.query(). Take a look at the docs

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.