Latest Contributions by DavidPike

Are the field names and field data type the same across the merged datasets?  Otherwise obviously there would be null values from one dataset which doesn't match the same field name or type and a new field has to be added to the merged output.  There's not quite enough info to go on from your current screenshots. ... View more

Might also be worth testing against the base table rather than evw to confirm this as the likely cause of the inefficiency (appreciate record count would differ however). ... View more

What happens if you set this as the else   else {return $feature["date_diag"]}   what are you data types for periodicite? string or numbers? ... View more

I'd just highlight an error in your post - Esri is clockwise outer rings and anti-clockwise inner rings/holes. ... View more

Impressive stuff there.  Yes on looking back, 'else if' makes no difference since a return statement is used each time.  'When' is certainly more readable also. ... View more

Do you have a current Enterprise GIS setup?  ... View more

How big is the dataset?  One thing to check is that you have a spatial index, it is much faster if so.  Maybe the 'disjoint' test is faster. When was the last time the database was compressed (I'm guessing versioned as you have _evw)?  Is it going to state 1 or 0?  Otherwise the versioned view query is quite expensive to work through - checking on the delta tables and the base table differences. ... View more

The simplest way to looks at it is that row selection treats the feature class as a table with no geometry and can't be used as an input for a geoprocessing tool which requires a geometry operation (e.g. buffer, select by location).   Feature selection includes the geometry, and can be used in subsequent geoprocessing tools in the same way as the original feature class. row selection - outputs the row of the attribute table feature selection - outputs as if a selection from the feature class, including the geometry/shape. ... View more

Looks like your code logic doesn't really work.  If inspectionResult is always either pass or fail, then only the first 2 if statements would ever be evaluated since a return breaks any subsequent evaluations (also consider using 'else if' to make the code more efficient.   you need some more detailed logic such as      //8 possible permutations (2^3) (ermmmm I think - a while since my statistics classses!) var Stage1= $feature.inspectionresult var Stage2= $feature.installationresults var Stage3= $feature.ns_serviceentrance if (Stage1=="Pass" && Stage2=="Fail" && Stage3=="Fail") return "Stage 1 Pass Stage 2-3 Fail" else if (Stage1=="Pass" && Stage2=="Pass" && Stage3=="Fail") return "Stage 1-2 Pass Stage 3 Fail" else if (Stage1=="Pass" && Stage2=="Fail" && Stage3=="Pass") return "Stage 1-3 Pass Stage 2 Fail" else if (Stage1=="Pass" && Stage2=="Pass" && Stage3=="Pass") return "Stage 1-2-3 Pass" else if (Stage1=="Fail" && Stage2=="Pass" && Stage3=="Pass") return "Stage 1 Fail Stage 2-3 pass" else if (Stage1=="Fail" && Stage2=="Fail" && Stage3=="Pass") return "Stage 1-2 Fail Stage 3 pass" else if (Stage1=="Fail" && Stage2=="Pass" && Stage3=="Fail") return "Stage 1-3 Fail Stage 2 pass" else if (Stage1=="Fail" && Stage2=="Fail" && Stage3=="Fail") return "Stage 1-2-3 Fail"   ... View more

It's an ArcMap tool also.  What version do you have?  I think it goes all the way back. ... View more

if ($feature["note_diag"] != "" && $feature.periodicite == "1") { return Dateadd($feature["date_diag"],1,'years') } else if($feature["note_diag"] != "" && $feature.periodicite == "2") { return Dateadd($feature["date_diag"],2,'years') } else if($feature["note_diag"] != "" && $feature.periodicite == "3") { return Dateadd($feature["date_diag"],3,'years') } else if($feature["note_diag"] != "" && $feature.periodicite == "4") { return Dateadd($feature["date_diag"],4,'years') } //else {return something} ... View more