Sample 'Select by Location' using point geometry and query layer

select_by_location.py

import arcpy

point = arcpy.Point(592326.779, 6241287.454)

ref = arcpy.SpatialReference(26708) #SRID

ptGeometry = arcpy.PointGeometry(point, ref)

conn = r'Database Connections\[email protected]'
layer = "polygon"
query = "select * from data_view_spatial2"
u_id = "leaseid (Text, Nullable)"

arcpy.MakeQueryLayer_management(conn, layer, query, u_id, "POLYGON")

arcpy.SelectLayerByLocation_management(layer, "CONTAINS",ptGeometry, "#", "NEW_SELECTION")

result = int(arcpy.GetCount_management("polygon").getOutput(0))

print result
print "done"