POST
|
Hello, What is the proper syntax for where_clause when I have multiple conditions? This is what I got when I exported from my model builder: arcpy.Select_analysis(in_features = Pipe_Table__WGS_PIPE_, out_feature_class = WGS_PIPE, where_clause = "PIPE_DIAMETER <= 20 And SYS_ZONE <> 0 And OWNER = 'WDD' And USE_TYPE IN ('DIST', 'TRUNK', 'LSLATERAL', 'MANIFOLD') " ) The above returns me an error. However, if I just do one condition such as the following below, it works... arcpy.Select_analysis(in_features = Pipe_Table__WGS_PIPE_, out_feature_class = WGS_PIPE, where_clause = "PIPE_DIAMETER <= 20" ) Can anyone please help? Thanks!
... View more
11-05-2019
04:51 PM
|
0
|
3
|
3016
|
POST
|
I've been trying a few sample notebooks and there's always an error somewhere in the middle. For example on the "Analyzing Violent Crime" sample notebook (https://developers.arcgis.com/python/sample-notebooks/analyzing-violent-crime/) on the "try it live", there's an error on cell [14]: crime_hot_spots = find_hot_spots(violent_crimes, output_name='ViolentCrimeHotSpots', bounding_polygon_layer=analysis_boundary) ProcessFeatureOutput failed. Error: {"code" : 0, "messageCode":"GPEXT_017","message": "Service ViolentCrimeHotSpots already exists.", "params": {"name" : "ViolentCrimeHotSpots"}} {"messageCode": "AO_100007", "message": "FindHotSpots failed."} Failed to execute (FindHotSpots). Failed. What might be the cause for this? Alternatively, can someone just point me to a sample notebook that actually run from beginning to end?
... View more
08-11-2019
11:01 PM
|
0
|
2
|
758
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|