| ArcGIS REST Services Directory | Login | Get Token | 
| Home > services > Sewer > SewerPipes_LastInspected (MapServer) | Help | API Reference | 
| JSON | SOAP | 
Arcade expression to symbolize based on last inspected date:
// pipes inspected in the last year
if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') <=1)
{
return "Inspected in Last Year"
}
// pipes inspected 2 years ago
else if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') >=2 &&
DateDiff(Now(), Date($feature["Last_Insp"]), 'years') <3)
{
return "Inspected 2 Years Ago"
}
// pipes inspected in the last 3-5 years
else if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') >=3 &&
DateDiff(Now(), Date($feature["Last_Insp"]), 'years') <=5)
{
return "Inspected 3-5 Years Ago"
}
// pipes inspected more than 5 years ago
else if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') >5)
{
return "Inspected More Than 5 Years Ago"
}
Arcade expression to symbolize based on last inspected date:
// pipes inspected in the last year
if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') <=1)
{
return "Inspected in Last Year"
}
// pipes inspected 2 years ago
else if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') >=2 &&
DateDiff(Now(), Date($feature["Last_Insp"]), 'years') <3)
{
return "Inspected 2 Years Ago"
}
// pipes inspected in the last 3-5 years
else if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') >=3 &&
DateDiff(Now(), Date($feature["Last_Insp"]), 'years') <=5)
{
return "Inspected 3-5 Years Ago"
}
// pipes inspected more than 5 years ago
else if(DateDiff(Now(), Date($feature["Last_Insp"]), 'years') >5)
{
return "Inspected More Than 5 Years Ago"
}