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; } } }

Getting Error in my where clause using cursor in arcpy.

broy06

I'm currently using Arcmap 10.7 version. I'm guessing my error is in the where clause. Could anyone please help me to get rid from this problem?. I'm not able to print the cursor part i.e.,

Print (MEASUREDLENGTH_Risk_Score) # Not getting the value of MEASUREDLENGTH

Below is my code-:

import arcpy
arcpy.env.workspace = "D:\pipe\map.gdb"
featureClass_1 = "P_Pipes"
Table_Pipe = "Pipe_Risk"
fieldNames_1 = [ "Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" , "INSTALLATIONDATE", "Risk_Score"]
fieldNames_Pipe = ["Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTHLOWERLIMIT" ,"MEASUREDLENGTHUPPERLIMIT" , "INSTALLATIONDATELOWERLIMIT" , "INSTALLATIONDATEUPPERLIMIT" , "OVERALLRISKSCORE"]


def Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH,  INSTALLATIONDATE):

    ML_Out_fields = ["MEASUREDLENGTHLOWERLIMIT" ,"MEASUREDLENGTHUPPERLIMIT" , "OVERALLRISKSCORE"]
    ML_where_Clause = "MEASUREDLENGTHLOWERLIMIT <= " + MEASUREDLENGTH + " and MEASUREDLENGTHUPPERLIMIT >= " + MEASUREDLENGTH 
    print(ML_where_Clause)
    
    Table_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, ML_Out_fields, ML_where_Clause)
    for row in Table_Pipe_Cursor:
        lst.append(row[2])
        MEASUREDLENGTH_Risk_Score = row[2]
        print ((MEASUREDLENGTH_Risk_Score))

Pipe_Risk_Score("Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" ,  "INSTALLATIONDATE")

Trouver plus de publications taguées avec

Accepted answers

Anonymous User

It looks like you are not using the right ML where clause again.

ML_where_Clause = "MEASUREDLENGTHLOWERLIMIT <= {0} and MEASUREDLENGTHUPPERLIMIT >= {0}".format(MEASUREDLENGTH)

For your date rage, maybe drop the = because it is including 01-01-1955 and 01-01-1935 as being valid so its selecting both.

All comments

broy06

Yes sir. I tried But I wanna access only the domain value of Dates not the exact date & from this i'm getting Dates only.

Thank You!

JoshuaBixby

@broy06, how is this question different from one you posted yesterday? (https://community.esri.com/t5/python-questions/getting-error-in-arcpy-using-cursor/m-p/1087638#M62015) . In the other post, @BlakeTerhune gave you a suggestion on handling dates, did you ever try it?

broy06

Sir @Anonymous User . I'm getting my output for the same. But in case of Measured length & Installation Date, I'm getting the multiple values. See, in the case of Measured Length, I'm getting the 5 output values where as in case of Installation Date, I'm getting 2 values. So do i have to change the signs in the where clause? or something else.

Material: 5 OPERATINGPRESSURE: 40.0 MEASUREDLENGTH: 182.36985383 INSTALLATIONDATE: 1955-01-01 00:00:00
1.5
0.4
MEASUREDLENGTHUPPERLIMIT >= 182.36985383
0.1
0.2
0.3
0.4
1.0
INSTALLATIONDATELOWERLIMIT <= timestamp '1955-01-01 00:00:00' and INSTALLATIONDATEUPPERLIMIT >= timestamp '1955-01-01 00:00:00'
2.0
1.4

Anonymous User

Should be uCur.updateRow(row), lowercase U in the update.

broy06

Yes sir @Anonymous User , It's working now. Below error is because of the "with" statement in updating cursor case?

Currently using Arcmap 10.7

C:\Users\my>D:\Arcpy\Material.py
Material: 3 OPERATINGPRESSURE: 125.0 MEASUREDLENGTH: 3737.85025923 INSTALLATIONDATE: 1958-07-08 00:00:00
0.3
1.2
MEASUREDLENGTHUPPERLIMIT >= 3737.85025923
1.0
INSTALLATIONDATELOWERLIMIT <= timestamp '1958-07-08 00:00:00' and INSTALLATIONDATEUPPERLIMIT >= timestamp '1958-07-08 00:00:00'
1.4
Traceback (most recent call last):
File "D:\Arcpy\Material.py", line 69, in <module>
uCur.UpdateRow(row)
AttributeError: 'da.UpdateCursor' object has no attribute 'UpdateRow'

Anonymous User

I don't know what database your featureclass is in and there are different ways of using dates. Look at the documentation if your database is not postgresql and this doesn't work and format it accordingly.

ID_where_Clause = "INSTALLATIONDATELOWERLIMIT <= timestamp '{0}' and INSTALLATIONDATEUPPERLIMIT >= timestamp '{0}'".format(INSTALLATIONDATE)

broy06

@Anonymous User Sir, I didn't get your point. What you wanna tell me?

Yes, I want the same thing as you mentioned above but also in the case of INSTALLATIONDATE I will get some float value like INSTALLATIONDATE: 1.2 if my code runs

Anonymous User

You are not running the code I just provided. You would see something like:

Material: 0.3 OPERATINGPRESSURE: 2 MEASUREDLENGTH: 4.5 INSTALLATIONDATE: 01/02/1935

being printed in the console if you were.

broy06

Yes sir, I agreed with your point but while running a where clause for MEASUREDLENGTH & INSTALLATIONDATE, It's giving me error

C:\Users\my>D:\Arcpy\Material.py
0.3
0.9
1.5
1.8
2.4
3.0
0.4
0.4
1.2
1.2
1.6
2.4
4.0
MEASUREDLENGTHLOWERLIMIT <= MEASUREDLENGTH and MEASUREDLENGTHUPPERLIMIT >= MEASUREDLENGTH
Traceback (most recent call last):
File "D:\Arcpy\Material.py", line 55, in <module>
Pipe_Risk_Score("Material", "OPERATINGPRESSURE", "MEASUREDLENGTH", "INSTALLATIONDATE")
File "D:\Arcpy\Material.py", line 36, in Pipe_Risk_Score
for row in sCur:
RuntimeError: An expected Field was not found or could not be retrieved properly. [Pipe_Risk]

It means upto the where clause of "MEASUREDLENGTH", the program or code runs.

Anonymous User

OK, I've solved your problem in the previous posts and it looks like you are not trying what I provided here in its entirety.

import arcpy

arcpy.env.workspace = "D:\Pipe\map.gdb"
featureClass_1 = "P_Pipes"
Table_Pipe = "Pipe_Risk"
fieldNames_1 = ["Material", "OPERATINGPRESSURE", "MEASUREDLENGTH", "INSTALLATIONDATE", "Risk_Score"]
fieldNames = ["Material", "OPERATINGPRESSURE", "MEASUREDLENGTHLOWERLIMIT", "MEASUREDLENGTHUPPERLIMIT",
              "INSTALLATIONDATELOWERLIMIT", "INSTALLATIONDATEUPPERLIMIT", "OVERALLRISKSCORE"]


def Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH, INSTALLATIONDATE):
    lst = []
    # Case: Material
    Material_where_Clause = "Material = " + Material
    with arcpy.da.SearchCursor(Table_Pipe, ["Material", "OVERALLRISKSCORE"], Material_where_Clause) as sCur:
        for row in sCur:
            lst.append(row[1])
            Material_Risk_Score = row[1]
            print Material_Risk_Score

    # Case: Operating Pressure
    OP_Out_fields = ["OPERATINGPRESSURE", "OVERALLRISKSCORE"]
    OP_where_Clause = "OPERATINGPRESSURE = " + OPERATINGPRESSURE
    with arcpy.da.SearchCursor(Table_Pipe, OP_Out_fields, OP_where_Clause) as sCur:
        for row in sCur:
            lst.append(row[1])
            OPERATINGPRESSURE_Risk_Score = row[1]
            print OPERATINGPRESSURE_Risk_Score

    # Case: ML
    ML_Out_fields = ["MEASUREDLENGTHLOWERLIMIT", "MEASUREDLENGTHUPPERLIMIT", "OVERALLRISKSCORE"]
    ML_where_Clause = "MEASUREDLENGTHLOWERLIMIT <= " + MEASUREDLENGTH + " and MEASUREDLENGTHUPPERLIMIT >= " + MEASUREDLENGTH
    print ML_where_Clause
    with arcpy.da.SearchCursor(Table_Pipe, ML_Out_fields, ML_where_Clause) as sCur:
        for row in sCur:
            lst.append(row[2])
            MEASUREDLENGTH_Risk_Score = row[2]
            print MEASUREDLENGTH_Risk_Score

    # Case: ID
    ID_Out_fields = ["INSTALLATIONDATELOWERLIMIT", "INSTALLATIONDATEUPPERLIMIT", "OVERALLRISKSCORE"]
    ID_where_Clause = "INSTALLATIONDATELOWERLIMIT <= {0} and INSTALLATIONDATEUPPERLIMIT >= {0}".format(INSTALLATIONDATE)
    with arcpy.da.SearchCursor(Table_Pipe, ID_Out_fields, ID_where_Clause) as sCur:
        for row in sCur:
            lst.append(row[2])
            ID_Risk_Score = row[2]
            print ID_Risk_Score

    return sum(lst) / len(lst)


with arcpy.da.UpdateCursor(PipeFCName, ["Material", "OPERATINGPRESSURE", "MEASUREDLENGTH", "INSTALLATIONDATE", "Risk_Score"]) as uCur:
    for row in uCur:
        Material = row[0]
        OPERATINGPRESSURE = row[1]
        MEASUREDLENGTH = row[2]
        INSTALLATIONDATE = row[3]
        print "Material: {}\t OPERATINGPRESSURE: {}\t MEASUREDLENGTH: {}\t  INSTALLATIONDATE: {}".format(Material, OPERATINGPRESSURE, MEASUREDLENGTH, INSTALLATIONDATE)
        row[4] = Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH, INSTALLATIONDATE)
        uCur.UpdateRow(row)

broy06

Sir, What i have to actually do is taking the "overall risk score" from the lookup table for each value in the feature class and then after accessing the "Overall risk score" for each value in my lookup table. I'm trying to update it in the main feature class( I have added a new field "Risk_Score" here)

So, what i wanna do is reading the value from the lookup table & update the average of Risk score in my original feature class attributes.

Example:

Material = 3

Operating Pressure = 40

Measured Length = 52.5

Installation Date = 2015-4-01

Say overall risk score for Material (3) = 0.3

Say overall risk score for Operating pressure(40) = 0.1

Say overall risk score for Measured Length(52.5) = 1.2

Say overall risk score for Installation Date(2015-4-01) = 1

#And most importantly, I wanna read the "Overall Risk Score" for each parameters not their value, I just want for Operating Pressure =120, what'll be the overall risk score from the lookup table.

Pipe_Risk_Score = (Overall Risk Score (Material) + Overall Risk Score(Operating Pressure)+ Overall Risk Score(Measured Length)+ Overall Risk Score(Installation Date) ) /4

That's why I have defined the function, so that i can pass the return average value while updating the field value.

# below is the psuedo code, what i wanna do after the search cursor.

PipeCursor = arcpy.da.UpdateCursor(GDBPath,PipeFCName)
for row in PipeCursor

Material = row[0] // Cast Iron
OperatingPressure = row[1] // 120
MeasuredLength = row[3] // 100
InstallationDate = row[4] // 1-Jan-1990

PipeRiskScore = Pipe_Risk_Score(Material,OperatingPressure,MeasuredLength,InstallationDate)

row.set_value("OverallRiskScore",PipeRiskScore)

Then I have to update it into my feature class by taking all the parameters into consideration.

Sir, do you understand now, what i'm trying to do? Now please suggest

Anonymous User

This is getting beyond the scope of the original question. If the field values you are tying to use in the queries are coming from the same table as what you are using to get the information from, I think you could simplify this script into a single cursor and drop the multiple sql queries on each field.

I am unclear if you are trying to average each features value across the fields, or average the field across all features. This is not tested but should do both and get you started- you can add/ delete what you need when you debug it against the data.

import arcpy

arcpy.env.workspace = "D:\Pipe\map.gdb"
featureClass_1 = "P_Pipes"
Table_Pipe = "Pipe_Risk"

# Lists for holding values from the cursor
material_overall = []
opPressureOverall = []
measuredlengthOverall = []
riskscoreOverall = []

with arcpy.da.SearchCursor(Table_Pipe, ["Material", "OPERATINGPRESSURE", "MEASUREDLENGTH",
                                        "INSTALLATIONDATELOWERLIMIT", "INSTALLATIONDATEUPPERLIMIT",
                                        "OVERALLRISKSCORE"]) as sCur:
    for row in sCur:
        Material_Risk_Score = row[0]
        # filter Nulls
        if Material_Risk_Score is not None:
            material_overall.append(Material_Risk_Score)

        OPERATINGPRESSURE_Risk_Score = row[1]
        if OPERATINGPRESSURE_Risk_Score is not None:
            measuredlengthOverall.append(OPERATINGPRESSURE_Risk_Score)

        MEASUREDLENGTH_Risk_Score = row[2]
        if MEASUREDLENGTH_Risk_Score is not None:
            measuredlengthOverall.append(MEASUREDLENGTH_Risk_Score)
        
        # This can probably be just a Null check instead of dates becuase this will always be true for the values shown in the table unless its Null.
        # if row[3] <= '2035-01-01' and row[4] >= '1935-01-01':
        if row[3] is not None and row[4] is not None:
            ID_Risk_Score = row[5]
            riskscoreOverall.append(ID_Risk_Score)
            # There are no values in the other fields if the dates are filled in so not sure if this is correct:
            print "Feature risk average: {}".format(
                Material_Risk_Score + OPERATINGPRESSURE_Risk_Score + MEASUREDLENGTH_Risk_Score + ID_Risk_Score / 4)

        else:
            # average the three fields for each feature leaving the installation out because there are no date values if these
            # fields have values.
            print "Feature risk average: {}".format(
                Material_Risk_Score + OPERATINGPRESSURE_Risk_Score + MEASUREDLENGTH_Risk_Score / 3)


# if you want average of the fields across all features.
print 'material_overall average = {}'.format(sum(material_overall) / len(material_overall))
print 'Operating Pressure average = {}'.format(sum(measuredlengthOverall) / len(measuredlengthOverall))
print 'Measured Length average = {}'.format(sum(measuredlengthOverall) / len(measuredlengthOverall))
print 'Risk Score average = {}'.format(sum(riskscoreOverall) / len(riskscoreOverall))

broy06

But I'm interested in a overall risk score of individual value. I want the average as a return function.

Please have a look at my complete code:

import arcpy
from datetime import datetime
arcpy.env.workspace = "D:\Pipe\map.gdb"
featureClass_1 = "P_Pipes"
Table_Pipe = "Pipe_Risk"
fieldNames_1 = [ "Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" , "INSTALLATIONDATE", "Risk_Score"]
fieldNames = ["Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTHLOWERLIMIT" ,"MEASUREDLENGTHUPPERLIMIT" , "INSTALLATIONDATELOWERLIMIT" , "INSTALLATIONDATEUPPERLIMIT" , "OVERALLRISKSCORE"]

lst=[]

def Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH, INSTALLATIONDATE):

# Case: Material

#Material_Out_fields = ["Material" , "OVERALLRISKSCORE"]

Material_where_Clause = "Material = " + Material
Table_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, ["Material" , "OVERALLRISKSCORE"],Material_where_Clause)
for row in Table_Pipe_Cursor:
# lst.append(row[1])
Material_Risk_Score = row[1]
print Material_Risk_Score

# Case: Operating Pressure

OP_Out_fields = ["OPERATINGPRESSURE" , "OVERALLRISKSCORE"]
OP_where_Clause = "OPERATINGPRESSURE = " + OPERATINGPRESSURE
Table_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, OP_Out_fields, OP_where_Clause)

for row in Table_Pipe_Cursor:
lst.append(row[1])
OPERATINGPRESSURE_Risk_Score = row[1]
print (OPERATINGPRESSURE_Risk_Score)

# Case: ML

ML_Out_fields = ["MEASUREDLENGTHLOWERLIMIT" ,"MEASUREDLENGTHUPPERLIMIT" , "OVERALLRISKSCORE"]
ML_where_Clause = "MEASUREDLENGTHLOWERLIMIT <= " + MEASUREDLENGTH + " and MEASUREDLENGTHUPPERLIMIT >= " + MEASUREDLENGTH #.format(MEASUREDLENGTH)
print ML_where_Clause
#Table_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, ML_Out_fields, ML_where_Clause)
#ML_where_Clause = "MEASUREDLENGTHLOWERLIMIT <= " + MEASUREDLENGTH + " and MEASUREDLENGTHUPPERLIMIT >= " + MEASUREDLENGTH.format(MEASUREDLENGTH, MEASUREDLENGTH)
# print(ML_where_Clause)
#ML_where_Clause = "CAST(MEASUREDLENGTHUPPERLIMIT AS INTEGER <= "MEASUREDLENGTHUPPERLIMIT" and "MEASUREDLENGTHUPPERLIMIT" >= "MEASUREDLENGTHLOWERLIMITTable_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, ML_Out_fields, ML_where_Clause)

"""for row in Table_Pipe_Cursor:
lst.append(row[2])
MEASUREDLENGTH_Risk_Score = row[2]
print MEASUREDLENGTH_Risk_Score"""

# Case: ID

INSTALLATIONDATE = datetime.strptime("1935-01-01 " ,"%Y-%m-%d") #"01/01/2035 00:00:00")
ID_Out_fields = ["INSTALLATIONDATELOWERLIMIT" , "INSTALLATIONDATEUPPERLIMIT" , "OVERALLRISKSCORE"]
ID_where_Clause = "INSTALLATIONDATELOWERLIMIT <= datetime(1935-01-01 ) and INSTALLATIONDATEUPPERLIMIT >= datetime(2035-01-01 )"
#ID_where_Clause = "(INSTALLATIONDATELOWERLIMIT <= {} and INSTALLATIONDATEUPPERLIMIT >= {})".format(INSTALLATIONDATE)
Table_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, ID_Out_fields, ID_where_Clause)
for row in Table_Pipe_Cursor:
#lst.append(row[2])
ID_Risk_Score = row[2]
print (ID_Risk_Score)

#Final_Risk_Score = (Material_Risk_Score + OP_Risk_Score + ML_Risk_Score + ID_Risk_Score)/4

#Pipe_Risk_Score(Material , OPERATINGPRESSURE , MEASUREDLENGTH , INSTALLATIONDATE) # Showing me Name error using this line without quotes
Pipe_Risk_Score("Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" , "INSTALLATIONDATE")

broy06

Sir, Actually i want the average of all these function at last in a return. Please have a look at my full code. I'm interested in accessing the "overallrisk" score of the value of all these parameters like Material, OPERATINGPRESSURE and so on.

import arcpy
arcpy.env.workspace = "D:\pipe\map.gdb"
featureClass_1 = "P_Pipes"
Table_Pipe = "Pipe_Risk"
fieldNames_1 = [ "Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" , "INSTALLATIONDATE", "Risk_Score"]
fieldNames_Pipe = ["Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTHLOWERLIMIT" ,"MEASUREDLENGTHUPPERLIMIT" , "INSTALLATIONDATELOWERLIMIT" , "INSTALLATIONDATEUPPERLIMIT" , "OVERALLRISKSCORE"]


def Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH,  INSTALLATIONDATE):

# Case: Material

# Case: Operating Pressure

for row in Table_Pipe_Cursor:
lst.append(row[1])
OPERATINGPRESSURE_Risk_Score = row[1]
print (OPERATINGPRESSURE_Risk_Score)

# Case: ML

"""for row in Table_Pipe_Cursor:
lst.append(row[2])
MEASUREDLENGTH_Risk_Score = row[2]
print MEASUREDLENGTH_Risk_Score"""

# Case: ID

#INSTALLATIONDATE = datetime.strptime("01/01/1935 00:00:00" , "01/01/2035 00:00:00")
#ID_Out_fields = ["INSTALLATIONDATELOWERLIMIT" , "INSTALLATIONDATEUPPERLIMIT" , "OVERALLRISKSCORE"]
#ID_where_Clause = "INSTALLATIONDATELOWERLIMIT <= datetime(01/01/1935 00:00:00) and INSTALLATIONDATEUPPERLIMIT >= datetime(01/01/2035 00:00:00)"
#ID_where_Clause = "(INSTALLATIONDATELOWERLIMIT <= {} and INSTALLATIONDATEUPPERLIMIT >= {})".format(INSTALLATIONDATE)
#Table_Pipe_Cursor = arcpy.da.SearchCursor(Table_Pipe, ID_Out_fields, ID_where_Clause)
#for row in Table_Pipe_Cursor:
#lst.append(row[2])
#ID_Risk_Score = row[2]
#print (ID_Risk_Score)"""

#Final_Risk_Score = (Material_Risk_Score + OP_Risk_Score + ML_Risk_Score + ID_Risk_Score)/4

Anonymous User

Use a search cursor to iterate over the table.

Material = 'Something'
with arcpy.da.SearchCursor(yourtable, ["OPERATINGPRESSURE" , "MEASUREDLENGTH" , "INSTALLATIONDATE"]) as sCur:
    for row in sCur:
         OPERATINGPRESSURE = row[0]
         MEASUREDLENGTH = row[1]
         INSTALLATIONDATE = row[2]
         Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH, INSTALLATIONDATE)
         # or 
         # Pipe_Risk_Score(Material, row[0], row[1], row[2])

broy06

Hi sir, As you have defined or initialize value for a variable like

OPERATINGPRESSURE = 36

MEASUREDLENGTH = 12

INSTALLATIONDATE = datetime.strptime('08/03/2021 12:43:34')

Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH,  INSTALLATIONDATE)

So, how should I define my values for the variable in a function call, since each variable has so many different values from the table? How to fetch the data for each variable from a lookup table. Please have a look at the table given below-: Thank you!

Screenshot (99).png

Screenshot (102).png

Where changes should be made in Geoprocessing - Add Rasters to Mosaic Dataset.png

Classification Improvement - Nonexistent in Pro.PNG

broy06

Sir, Actually while calling a function without "Material" (quotes) , it's showing me "Name error", Name: Material is not defined and so on. okay I'm updating my full code in the question along with the lookup table & feature class attribute pic. Thank you, Please have a look then. Error: Pipe_Risk_Score("Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" , INSTALLATIONDATE)
NameError: name 'INSTALLATIONDATE' is not defined

Anonymous User

You are passing strings into your functions:

Pipe_Risk_Score("Material" , "OPERATINGPRESSURE" , "MEASUREDLENGTH" ,  "INSTALLATIONDATE")

OPERATINGPRESSURE is assigned "OPERATINGPRESSURE"

MEASUREDLENGTH is assigned "MEASUREDLENGTH"

INSTALLATIONDATE is assigned "INSTALLATIONDATE"

If you want the float / date that is assigned to MEASUREDLENGTH (or any of the other values), you need to remove the quotes in the function call so it passes the variables and not "OPERATINGPRESSURE" , "MEASUREDLENGTH" , "INSTALLATIONDATE" strings. For example:

OPERATINGPRESSURE = 36

MEASUREDLENGTH = 12

INSTALLATIONDATE = datetime.strptime('08/03/2021 12:43:34')

Pipe_Risk_Score(Material, OPERATINGPRESSURE, MEASUREDLENGTH,  INSTALLATIONDATE)

OPERATINGPRESSURE is assigned 36

MEASUREDLENGTH is assigned 12

INSTALLATIONDATE is assigned datetime 08/03/2021 12:43:34

We cant tell how you are assigning the variables from the lookup table from the code snippet you provided above so if you are having issues, it would be helpful to post the full code and any error messages that you are getting.

broy06

Hello, Earlier i tried using the same method which you suggested me but getting no output only able to see the print statement of where clause, not getting the value of "MEASUREDLENGTH" which has a double data type values, which i want. Please suggest me, what i'm lacking of?

GKmieliauskas

Hi,

Change

 + and "MEASUREDLENGTHUPPERLIMIT >= "

 + " and MEASUREDLENGTHUPPERLIMIT >= "

broy06

Yes. See, basically there is 1 feature class & 1 lookup table (Created in a same gdb). The actual value of "MEASUREDLENGTH" is in feature class attributes. but i have assigned some score for the same in the form of range in look up table and now i am calling it from the lookup table.

You are passing "MEASUREDLENGTH" as a string variable to MEASUREDLENGTH in the function call, but are trying to use it as integer in the whereclause. Where is the actual value of MEASUREDLENGTH for the sql coming from?

broy06

Sir, this statement gives me a blank screen with no output.

Anonymous User

It looks like you are trying to use string formatting for the variable but forgot the .format().

ML_where_Clause = "MEASUREDLENGTHLOWERLIMIT <= {0} and MEASUREDLENGTHUPPERLIMIT >= {0}".format(MEASUREDLENGTH)

danretired

Select Layer By Attribute (Data Management)—ArcGIS Pro | Documentation

from there, this is an example of a where clause for a string

"[NAME] = 'California'"

What do you get if you do an sql query on the data manually? Check it out and copy the syntax

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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