Latest Contributions by JohannesLindner

Is it possible to automate an arcade expression like you would a python script? Depends. You can't execute an Arcade expression in certain intervals like you could with a Python script. But you can write Attribute Rules that automatically calculate your field.   If not, is there an easy way to run it, wrapped in a python script, from within the Model Builder? You can use your Arcade expression in the Calculate Field tool.   Arcade is being used to make the end result pretty If all you want to do with Arcade is to prettify things, you could also do that in the Popup. ... View more

Hmmm, interesting. 4 vertices and distance(v1, v3) ~ distance(v2, v4): rectangle, else irregular quadrangle. (Almost) circles: for each vertex, get the distance from the centroid. get min and max distance. if max - min ~ 0: it's a circle, else it's something else. or: calculate the isoperimetric quotient of the polygon (https://en.wikipedia.org/wiki/Isoperimetric_inequality, https://en.wikipedia.org/wiki/Polsby%E2%80%93Popper_test😞 Q = 4*pi*area/(perimeter^2) For Q == 1 it's a circle; the lower Q gets, the less circle-ish the shape is.   rectangle-ish shapes with more than 4 vertices: get bearing of each line segment. if bearing[i] ~ bearing[i+1], it's the same side. if you get 4 sides this way, you know its a quadrangle. get the angles between the sides. if they're ~90°, it's a rectangle. ... View more

Your example doesn't state what the dictionary keys would be. As it looks right now, you could just do this: // Calculation Rule on Field 2 // Triggers: Update, Insert // return early if Field1 is empty if(IsEmpty($featue.Field1)) { return $feature.Field2 // or return null } // create the dictionary var value_dict = { "R-1": "Single-Family District", "ABC": "Other stuff", } // return the right value for Field2 return value_dict[$feature.Field1] // you could also do it with a list: value_list = [ ["R-1", "Single-Family District"], ["ABC", "Other stuff"], ] for(var i in value_list) { if(value_list[i][0] == $feature.Field1) { return value_list[i][1] } } // return a default value if Field1 is not in the list return null ... View more

# here you specify D:\outputData as workspace (a folder) arcpy.env.workspace = "D:\\outputData" # this only works with Enterprise geodatabase connections. if you don't have any of those, you don't need this arcpy.ClearWorkspaceCache_management() # does the raster have a file extension? inputData = "D:\\quad_dem10" # here you specify D:\outputData as a raster. but it is a folder... outputData ="D:\\outputData" # things to check: # is D:\outputData a folder? # if yes, change your Clip output to D:\outputData\outputRasterName # if no, delete the arcpy.env line (you can probably do that anyway) # open the tool (Data Management Tools -> Raster -> Raster Processing -> Clip), put in the parameters from your script and try running it manually ... View more

You have several problems in your code: "subjectitems" is a dataset with the filtered results of tbl_subjectitems. the individual subjectitems are named "si" (see line 23 in your code). you define tableresults inside the loop (line 25). for each found subjectitem, you overwrite the results of the previous ones. you append tableresults to itself (line 26), that's why you get two identical lines. tableresults is created for each mantenimiento, but you only append it to historia (results of all mentnemientos) at the very end (line 37), so you will only see the tableresults of the last processed mantenimiento. Try this: // Write a script to return a value to show in the pop-up. // For example, get the average of 4 fields: // Average($feature.SalesQ1, $feature.SalesQ2, $feature.SalesQ3, $feature.SalesQ4) var tbl = FeatureSetByName($datastore,"ActivityClass"); var tbl_subjectitem = FeatureSetByName($datastore, "SubjectItem"); var tbl_contact = FeatureSetByName($datastore, "Contact"); var codigo = $feature["PI_ID"]; //var sql = "PI_ID= '" + codigo + "'"; // Arcade has a shortcut for constructing SQL queries that will take care of the type-relevant stuff (like apostrophes): var sql = "PI_ID = @codigo"; Console(sql); var mantenimientos = Filter(tbl, sql); var cnt = Count(mantenimientos); var historia = ""; if (cnt > 0) { historia = cnt + " Record(s):" + TextFormatting.NewLine; for (var mantenimiento in mantenimientos) { // from your original post var txt_ActivityNum = Text("Activity Number: " + mantenimiento.ACTIVITY_NUM); var txt_fecha = txt_ActivityNum + "- Doc Status Date: " + Text(mantenimiento.DOC_STATUS_DATE, '(Y/MM/DD) - '); var txt_docdes = txt_fecha + "Status: " + mantenimiento.DOC_STATUS_DESC; historia += TextFormatting.NewLine + txt_docdes; // filter tbl_subjectitems var doc_id = mantenimiento.INT_DOC_ID var subjectitems = Filter(tbl_subjectitem, "INT_DOC_ID = @doc_id") // define tableresults outside of the loop avoid overwriting it for each subjectitem var tableresults = "" for(var si in subjectitems) { // subjectitems is the filtered dataset. the individual features are called "si". var txt_SubjectItemDesc = "Subject Item: " + si.subject_item_description; // append to tableresults tableresults += TextFormatting.NewLine + txt_SubjectItemDesc; } // do the same for tbl_contacts var contacts = Filter(tbl_contact, "INT_DOC_ID = @doc_id") for(var c in contacts) { // ... } // append tableresults (output of the filtered subjectitems & contacts for one mantenemiento) to historia (output of all mantenemientos) historia += TextFormatting.NewLine + tableresults } } else { historia = "No Records"; } return historia;   ... View more

You just have to order your code differently: var Status = $feature.RefStatus // exit early if RefStatus is null if(IsEmpty(Status)) { return '' } var cover_status = [ 'Ants present under artificial cover object', 'Artificial cover object not found', 'Artificial cover object not checked' ] var water_status = [ 'Current', 'Empty', 'Inaccessible', 'Polluted' 'Filled' ] if(Includes(cover_status, Status)) { return 'Artificial cover object status: ' + Status } if(Includes(water_status, Status)) { return 'Waterbody status: ' + Status } return '' // for older Arcade versions (< Arcade 1.12): var status_type = '' if (Status=='Ants present under artificial cover object' || Status=='Artificial cover object not found' || Status=='Artificial cover object not checked') { return 'Artificial cover object status: ' + Status } if (Status=='Current' || Status=='Empty' || Status=='Inaccessible' || Status=='Polluted' || Status=='Filled') { return 'Waterbody status: ' + Status } return '' ... View more