https://community.esri.com/t5/gis-life-discussions/streetlight-pole-condition-assessment/m-p/1617371#M1556 <P>Not sure which community to post in as I'm open to any solution!</P><P>I have a portfolio of streetlight poles which need to be assessed/inspected regularly. These inspections allocate the pole a condition rating (1-5). This has been completed previously via Survey123 and is also possible to do via Field Maps through the Streetlight Management Solution.</P><P>HOWEVER I want to be able to:</P><P>- View data from previous inspections (this again seems doable via related records)</P><P>- Colour code the feature layer in a map based on the latest condition rating</P><P>It doesn't seem possible to do both! I have tried some arcade expressions posted on forums to bring data from related records/repeats into the core feature layer data to no avail.</P> Thu, 22 May 2025 01:59:17 GMT ElishaStephens-Graham 2025-05-22T01:59:17Z https://community.esri.com/t5/gis-life-discussions/streetlight-pole-condition-assessment/m-p/1617371#M1556 <P>Not sure which community to post in as I'm open to any solution!</P><P>I have a portfolio of streetlight poles which need to be assessed/inspected regularly. These inspections allocate the pole a condition rating (1-5). This has been completed previously via Survey123 and is also possible to do via Field Maps through the Streetlight Management Solution.</P><P>HOWEVER I want to be able to:</P><P>- View data from previous inspections (this again seems doable via related records)</P><P>- Colour code the feature layer in a map based on the latest condition rating</P><P>It doesn't seem possible to do both! I have tried some arcade expressions posted on forums to bring data from related records/repeats into the core feature layer data to no avail.</P> Thu, 22 May 2025 01:59:17 GMT https://community.esri.com/t5/gis-life-discussions/streetlight-pole-condition-assessment/m-p/1617371#M1556 ElishaStephens-Graham 2025-05-22T01:59:17Z