Latest Contributions by JoeStefanoni

I have a somewhat related question.  Is it possible to filter a feature layer to display a selected subset from a related table?  In my situation, there is a field called Program_Type in the related table and I only want to display those records in the main layer with a Program_Type value of DPCC.  Is this possible using a filter or some other means? ... View more

I was able to set everything up similar to how you did using the following code specific to my datasets: var substances = FeatureSetByName($map,"Environmental_NJEMS - Unknown Source Contaminants") return substances // Filter related features by using a common attribute var INCIDENT_ID = $feature["INCIDENT_ID"] var filterStatement = 'INCIDENT_ID = @SUBST_IMPACT_ID' // Related features as a variable var relatedData = Filter(substances, filterStatement) // Sort related features by oldest to newest var relatedDataSorted = OrderBy(relatedData, 'SUBST_IMPACT_ID') // Build the pop-up string by iterating through all related features var popupString = '' for (var f in relatedDataSorted){ popupString += Text(f.INCIDENT_ID) + TextFormatting.NewLine + DefaultValue(f.SUBST_DESC, 'no data') + TextFormatting.NewLine + DefaultValue(f.SUBST_QTY, 'no data') + TextFormatting.NewLine + DefaultValue(f.UNIT, 'no data') + TextFormatting.NewLine + TextFormatting.NewLine } DefaultValue(popupString, 'No measurements to show') and when I test it I get the following (which seems correct): ResultValueResult OBJECTID SUBST_IMPACT_ID SUBST_STATUS SUBST_DESC CAS_NUM SUBST_QTY UNIT SUBST_QTY_TYPE IMPACT SUBST_STATE 1 60255 Known TETRACHLOROETHANE 25322207 12 ppb Actual Land Liquid 2 243563 Known ODORS PETROLEUM 0 unknown Unknown Air Gas 3 325919 Known WATER (GROUND WATER) 0 unknown Unknown Land Liquid 4 332493 Known LEAD 7439921 46.5 ppb Actual Land Liquid 5 334419 Known TETRACHLOROETHYLENE 127184 22.6 ppb Actual Land Liquid 6 334815 Known PERCHLOROETHYLENE 127184 Unknown Land Liquid 7 339869 Known TETRACHLOROETHANE 25322207 4 ppb Actual Land Solid 8 340360 Known VOC'S Unknown Land Liquid 9 344195 Known VOC'S Unknown Land Liquid 10 351494 Known TETRACHLOROETHYLENE 127184 Unknown Land Liquid 11 352755 Known TRICHLOROETHYLENE 79016 1.8 ppb Actual Land Liquid 12 352755 Known TETRACHLOROETHYLENE 127184 2.2 ppb Actual Land Liquid 13 353476 Known TETRACHLOROETHANE 25322207 0 unknown Unknown Land Liquid 14 379271 Known UNKNOWN LIQUID Unknown Land Liquid 15 380589 Known PERCHLOROETHYLENE 127184 0 unknown Unknown Land Liquid 16 381255 Known VOC'S Unknown Land Liquid 17 382651 Known OIL OTHER Unknown Land Liquid 18 386939 Known TRICHLOROETHYLENE 79016 587 ppb Actual Land Liquid 19 386939 Known TETRACHLOROETHYLENE 127184 24500 ppb Actual Land Liquid 20 390719 Known UNKNOWN LIQUID Unknown Land Liquid 21 393537 Known OIL FUEL #2 Unknown Land Liquid 22 393561 Known CARBON TETRACHLORIDE 56235 1.1 ppb Actual Land Liquid 23 393633 Known VOC'S 0 unknown Unknown Land Liquid 24 396455 Known PETROLEUM PRODUCTS 0 unknown Unknown Land Solid 25 402883 Known PETROLEUM PRODUCTS Unknown Land Liquid 26 402893 Known TETRACHLOROETHYLENE 127184 8.55 ug/l Actual Land Liquid 27 402893 Known TRICHLOROETHYLENE 79016 0.9400000000000001 ug/l Actual Land Liquid 28 405583 Known VOC'S Unknown Land Liquid 29 409239 Known TRICHLOROETHYLENE 79016 2.4 ppb Actual Land Liquid 30 409239 Known TETRACHLOROETHYLENE 127184 51 ppb Actual Land Liquid Fetch More... What I don't know how to do is incorporate it into my customized pop-up box?  When I add the expression to my pop-up, I end up losing all the pop-up display information.  Please advise. ... View more

I would like to know if there is an ArcGIS tool to calculate the maximum distance from the centroid of a polygon to the polygon edge.  Specifically I'm working with a parcel dataset. ... View more

Awesome! Do you know how would you write an IIF expression to try and capture a numeric value between say 1 and 10? Joe Stefanoni, GIS Specialist NJDEP – Site Remediation Program (609) 633-1405 joe.stefanoni@dep.nj.gov<mailto:joe.stefanoni@dep.nj.gov> ... View more

See my last response. Maybe eliminating the concatenate command will work since you suggested that when you added the command, the pop-up stopped functioning properly. I actually have a whole different way of displaying pop-ups/hiding null vales but it’s a little more complicated as it involves setting up an Arcade expression to display when values are present and not display nulls and then further manipulation of the expression via HTML in the pop-up configuration. Joe Stefanoni, GIS Specialist NJDEP – Site Remediation Program (609) 633-1405 joe.stefanoni@dep.nj.gov<mailto:joe.stefanoni@dep.nj.gov> ... View more

Try doing it without the concatenate command – iif(($feature["Arsenic_Function"]>=$feature["Arsenic_MCL"]), [$feature["Arsenic_ug_L_"] + " ug/L"], "") Joe Stefanoni, GIS Specialist NJDEP – Site Remediation Program (609) 633-1405 joe.stefanoni@dep.nj.gov<mailto:joe.stefanoni@dep.nj.gov> ... View more

It took some time to get it wright, but this works like a charm: For the layer, select configure pop-up, then Display a custom attribute display and switch to HTML. Then enter the following HTML Code for each layer where you want to exclude Null values: **NPL is the name of the field I want to exclude Null values for You will also need to add the following Attribute Expression: IIF(isEmpty($feature.NPL), "none", "inline") Continue to do this in both sections for each field you want to exclude Null values for. Only the name of the field and expr number will change in the HTML: And only the field name will change in the attribute expression: IIF(isEmpty($feature.CHROME_SITE), "none", "inline") You’re attribute expression ox will look something like this when done (I set up 6 expressions): Good luck, Joe Joe Stefanoni, GIS Specialist NJDEP – Site Remediation Program (609) 633-1405 joe.stefanoni@dep.nj.gov<mailto:joe.stefanoni@dep.nj.gov> ... View more

This is definitely helpful in that I am now able to exclude null values for a particular field from displaying in the pop-up but I have not been able to figure out how to tweak it so that I can also include the field name in the pop-up display when the value is not null?  If I add it prior to the NPL_STATUS field (NPL STATUS:), I get the field only showing up when the value is not null (which is what I want) but I get the field name (NPL Status: ) showing up in all the pop-ups, for when the value is null and not null: <td><b>{expression/expr0}</b></td>                <td>NPL Status: {NPL_STATUS}</td>   ... View more

Thanks!  That's exactly what I wanted to be able to do. ... View more

Thanks! Joe Stefanoni, GIS Specialist NJDEP Site Remediation Program (609) 633-1405 joe.stefanoni@dep.nj.gov ... View more