POST
|
I used the code below to find out which neighborhood each Census block group is within. I now want to find out the total internet subscriptions for each neighborhood. I'm don't know the correct terminology to search for how to do this. Xander Bakker any help would be appreciated. var pnt= Centroid(Geometry($feature))
var neighborhood = FeatureSetByName($map,"Shreveport_Neighborhoods",["NAME"])
var fsIntersectHood = Intersects(neighborhood, pnt)
var fneighborhood = first(fsIntersectHood)
if (fneighborhood == null) return ""
return fneighborhood.NAME
... View more
02-20-2020
02:34 PM
|
0
|
1
|
389
|
POST
|
Xander Bakker, I got my if-else statement to work. Now am I able to use <CLR> or something else to change the color of - Round(aggAcreage,2) ? var intersectingAggDiss = Intersects(FeatureSetByName($map,"COS Aggregated Vacant Parcels - No Structure"), $feature);
var aggAcreage = 0;
for (var aggacre in intersectingAggDiss) {
aggAcreage += aggacre.Acreage;
}
if (aggAcreage == 0){
aggAcreage = '';
} else {
'The aggregate acreage is: ' + Round(aggAcreage,2);
}
... View more
12-24-2019
09:29 AM
|
0
|
1
|
1856
|
POST
|
Hi Xander, Am I understanding correctly that you can't use formatting tags in AGOL? I am having two issues: I can't get the iif statement to work and Am I able to change the color of just the acreage number? - Round(aggAcreage,2) (I know how to change the color of the entire expression) var intersectingAggDiss = Intersects(FeatureSetByName($map,"COS Aggregated Vacant Parcels - No Structure"), $feature);
var aggAcreage = 0;
for (var aggacre in intersectingAggDiss) {
aggAcreage += aggacre.Acreage;
}
iif (aggAcreage = 0, '', 'The aggregate acreage is: ' + Round(aggAcreage,2));
//return 'The aggregate acreage is: ' + Round(aggAcreage,2);
... View more
12-24-2019
08:39 AM
|
0
|
1
|
1856
|
POST
|
Xander you are a lifesaver. Thank you so much! My hunch was right a list was needed. I just started learning code a month ago. I was about to break out LP3THW and start looking at lists. But I know I wouldn't have come up with your syntax. Too bad you don't live closer I'd take you out for a few beers.
... View more
12-20-2019
08:39 AM
|
0
|
1
|
3912
|
POST
|
Xander Bakker Xander Bakker Kevin Milton Ken Buja I can write one-off conditional expressions but how do you combine multiple conditional expressions for different fields? In the example below Field 1 & 2 are from one layer and Field 3 is from the popup layer. I want to only return a value and if it is null do not return an empty space. I can write an expression for each field that is null and only return the other 2 or all 3 if all values are present but not how to combine all expressions. Field1 Field1 or Field2 or Field1 or Field3 and so on Field2 Field2 Field3 Field3 Field3 I know how to return all fields even if it's null but it leaves a space/s. This is my expression: var buildn = FeatureSetByName($map,"NLCOG Buildings",["BUILDING_N"])
var fsIntersectbuild = Intersects(buildn, $feature)
var fbuildn = first(fsIntersectbuild)
var buildu = FeatureSetByName($map,"NLCOG Buildings",["USAGE_"])
var fIntersectbuild = Intersects(buildu, $feature)
var fusage = first(fIntersectbuild)
var occp = $feature.OCCUPANCY
iif (fbuildn.BUILDING_N == null, fusage.USAGE_ + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)
//iif (fusage.USAGE_ == null, fbuildn.BUILDING_N + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)
//iif (occp == null || occp == 'SINGLEF', fusage.USAGE_ + TextFormatting.NewLine + fbuildn.BUILDING_N, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp) Each one of the iif statements works independently. I've tried using the When function but each field is different so it doesn't work or not the way that I wrote it. Any help would be appreciated.
... View more
12-20-2019
07:13 AM
|
1
|
3
|
7985
|
BLOG
|
Kelly Gerrow Xander Bakker Kevin MacLeod Robert Scheitlin, GISP I can write one-off conditional expressions but how do you combine multiple conditional expressions for different fields? I have 3 fields I want to return to a new line but only if there is a value to return. Example: Field1 or Field1 or Field2 or Field1 or Field3 and so on Field2 Field2 Field3 Field3 Field3 I know how to return all fields even if it's null but it leaves an empty space. Field1 Field3 This is my expression: var buildn = FeatureSetByName($map,"NLCOG Buildings",["BUILDING_N"])
var fsIntersectbuild = Intersects(buildn, $feature)
var fbuildn = first(fsIntersectbuild)
var buildu = FeatureSetByName($map,"NLCOG Buildings",["USAGE_"])
var fIntersectbuild = Intersects(buildu, $feature)
var fusage = first(fIntersectbuild)
var occp = $feature.OCCUPANCY
iif (fbuildn.BUILDING_N == null, fusage.USAGE_ + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)
//iif (fusage.USAGE_ == null, fbuildn.BUILDING_N + TextFormatting.NewLine + occp, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp)
//iif (occp == null || occp == 'SINGLEF', fusage.USAGE_ + TextFormatting.NewLine + fbuildn.BUILDING_N, fbuildn.BUILDING_N + TextFormatting.NewLine + fusage.USAGE_ + TextFormatting.NewLine + occp) Each one of the iif statements works independently. I've tried using the When function but each field is different so it doesn't work or not the way that I wrote it. Any help would be appreciated.
... View more
12-19-2019
03:31 PM
|
1
|
0
|
9506
|
Title | Kudos | Posted |
---|---|---|
1 | 12-20-2019 07:13 AM | |
1 | 12-19-2019 03:31 PM |
Online Status |
Offline
|
Date Last Visited |
08-12-2021
01:19 PM
|