@avonmoos
With the help of @MikeMillerGIS I was able to come up with something along these lines.
Set up for my Storm data, the 'endpoints' of a gravity main can be a Manhole, Inlet, Outlet, Cleanout, Discharge Point, Network Structure, or Fitting all of which are in their own featureclass.
Though, have not tested it extensively, should be a good starting point as it is working as expected.
function get_fs(cls_name){
return Decode(cls_name,
"sdInlet",FeatureSetByName($datastore, "sdInlet", fields, true),
"sdOutlet",FeatureSetByName($datastore, "sdOutlet", fields, true),
"sdCleanOut",FeatureSetByName($datastore, "sdCleanOut", fields, true),
"sdManhole",FeatureSetByName($datastore, "sdManhole", fields, true),
"sdDischargePoint",FeatureSetByName($datastore, "sdDischargePoint", fields, true),
"sdFitting",FeatureSetByName($datastore, "sdFitting", fields, true),
"sdNetworkStructure",FeatureSetByName($datastore, "sdNetworkStructure", fields, true),
null)
}
function IsEmptyButBetter(data) {
if (IsEmpty(data)) return true;
for (var x in data) return false;
return true;
}
var fields = ['FacilityID']
var fclist = ['sdManhole','sdInlet','sdOutlet','sdCleanOut', 'sdFitting', 'sdDischargePoint', 'sdNetworkStructure'];
var line_shape = Geometry($feature)
var spRef = line_shape['spatialReference']
// Get the origin and end points of the line
var orig_x = line_shape['paths'][0][0].x
var orig_y = line_shape['paths'][0][0].y
var orig_point = Point({x: orig_x, y: orig_y, spatialReference: spRef})
var end_x = line_shape['paths'][-1][-1].x
var end_y = line_shape['paths'][-1][-1].y
var end_point = Point({x: end_x, y: end_y, spatialReference: spRef})
var attributes = {}
var umh = 'NA'
var dmh = 'NA'
for (var p in fclist){
var point_fs = get_fs(fclist[p]);
//find point intersecting origin
var origIntx = first(Intersects(orig_point, point_fs));
//find point intersecting end
var endIntx = first(Intersects(end_point, point_fs));
if (!IsEmptyButBetter(origIntx)) {
attributes['UpMH'] = origIntx['FacilityID']
var umh = attributes['UpMH']
}
if (!IsEmptyButBetter(endIntx)) {
attributes['DownMH'] = endIntx['FacilityID']
var dmh = attributes['DownMH']
}
//add FacilityID to attribute results
if (!IsEmptyButBetter(attributes)) {
attributes['FacilityID'] = umh + "-" + dmh
}
var result = {}
if (!IsEmptyButBetter(attributes)) {
result['result'] = {
'attributes': attributes
}
}
}
return result
This will find the FacilityID from the upstream and downstream points if exist, populate the UpMH and DownMH fields in the gravity main feature class as well as update the gravity main FacilityID to UpMH-DownMH regardless of which point FC it is in.
R_
