topic ArcGIS Dashboard Using Arcade to union two datasets (featureLayers) in ArcGIS Online Questions

ArcGIS Dashboard Using Arcade to union two datasets (featureLayers)

LarsChristianØstgaard — Tue, 13 Sep 2022 14:00:22 GMT

I want to display a table in ArcGIS Dashboard that contains data from two different featureLayers (datasets).

- I cannot use the Merge-functionality in ArcGIS Pro because the first featureLayers using geopoint, while the second featureLayer using polylines.

- Therefore I am trying to make an Arcade DataExpression to create a dictionary consising of data from the two different featureLayers.

- The two featureLayers both include the same fields ['objectid','CreationDate','Creator','formStatus','nettniva','id','komponenttype','driftsmerking','message','globalid','classid','spenning']

- I am NOT using any filtering inside the Arcade-expression other than only selecting the fields I want to display in the table.

- I then want to use the ArcadeExpression in both a table and indicator widget (if possible) in the ArcGIS Dashbord.

- When I use "return fs1;" I get data from my first featureLayer. This works but its not what I want., see the attached image "Image1 fs1.png".

- When I use "return fs2;" I get data from my second featureLayer. This works but its not what I want., see the attached image "Image2 fs2.png".

- But when I use "return FeatureSet(Text(dict));" I only get a empty dictionary, see the attached image "Image3 empty dictionary.png".

Is there any easier solution to this problem?

If not, can you see any errors in my Arcade Expression?

Since Im new to Arcade I may need a detailed description, but appreciate any tips 🙂

//Totalt antall rapporterte avvik Tabell //ArcGIS Portal var p = Portal('https://kraftnett.maps.arcgis.com'); //var all_fields = ['objectid','CreationDate','Creator','formStatus','nettniva','id','komponenttype','driftsmerking','message','globalid','classid','spenning'] //Feature: PointObject var itemID_points = 'fbf01e5a639a4a3ea335e089652c109a'; var layerID_points = 0; var fields_points = ['objectid','globalid','creationdate','creator','formStatus','nettniva','komponenttype']; //Pull PointObject data var fs1 = FeatureSetByPortalItem(p, itemID_points, layerID_points, fields_points, false); //Create empty dictionary var dict = { 'fields': [ {'name': 'ObjectId', 'type': 'esriFieldTypeInteger'}, {'name': 'GlobalId', 'type': 'esriFieldTypeString'}, {'name': 'CreationDate', 'type': 'esriFieldTypeDate'}, {'name': 'Creator', 'type': 'esriFieldTypeString'}, {'name': 'FormStatus', 'type': 'esriFieldTypeString'}, {'name': 'Nettniva', 'type': 'esriFieldTypeString'}, {'name': 'KomponentType', 'type': 'esriFieldTypeString'} ], 'geometryType': '', 'features': [] }; var index = 0; //Loop through and add PointFeature data to dictionary for (var feature in fs1) { dict.features[index++] = { 'attributes': { 'objectid': feature['objectid'], 'globalid': feature['globalid'], 'creationdate': feature['creationdate'], 'creator': feature['creator'], 'formStatus': feature['formStatus'], 'nettniva': feature['nettniva'], 'komponenttype': feature['komponenttype'] } } }; //Feature: LineObjects var itemID_lines = '24481a7dc6d342db9c5b43cc8af9b8c1'; var layerID_lines = 0; var fields_lines = ['objectid','globalid','creationdate','creator','formStatus','nettniva','komponenttype']; //Pull LineObject data var fs2 = FeatureSetByPortalItem(p, itemID_lines, layerID_lines, fields_lines, false); //Loop through and add PointFeature data to dictionary for (var feature in fs2) { dict.features[index++] = { 'attributes': { 'objectid': feature['objectid'], 'globalid': feature['globalid'], 'creationdate': feature['creationdate'], 'creator': feature['creator'], 'formStatus': feature['formStatus'], 'nettniva': feature['nettniva'], 'komponenttype': feature['komponenttype'] } } }; //Return result //return fs1; return FeatureSet(Text(dict)); //return dict; //return [fs1, fs2]

Regards Lars

Re: ArcGIS Dashboard Using Arcade to union two datasets (featureLayers)

LarsChristianØstgaard — Fri, 16 Sep 2022 14:18:08 GMT

I found a solution to this problem.

The problem was that the date field was really a datetime field (containing day, month year, hour, minute, second, nanosecond.. So the whole output failed to be displayed due to the creationdate field in datetime was not in esriFieldTypeDate format.

The solution was to create a new field and convert the datetime (yyyy-MM-dd HH:mm:ss.SSS) to date (yyyy-MM-dd HH:mm:ss) and casting this in a esriFieldTypeDate format.

//Totalt antall rapporterte avvik Tabell * Virker // Portal var p = Portal('https://kraftnett.maps.arcgis.com'); // Create FeatureSet for points var fs1 = FeatureSetByPortalItem(p,'fbf01e5a639a4a3ea335e089652c109a', 0, ['globalid','objectid','komponenttype','nettniva','formStatus','creator','CreationDate','id','driftsmerking','message','classid','spenning'], true); // Create Featureset for lines var fs2 = FeatureSetByPortalItem(p,'24481a7dc6d342db9c5b43cc8af9b8c1', 0 ,['globalid','objectid','komponenttype','nettniva','formStatus','creator','CreationDate','id','driftsmerking','message','classid','spenning'], true); // Create empty feature array and feat object for output var features = []; var feat; // Iterate fs1 for (var feature in fs1) { // Filter points by polygon //var pts = Contains(feature, fs2); // Create feature with aggregated values feat = { 'attributes': { 'objecttype': ['PointObject'], 'objectid': feature['objectid'], 'globalid': feature['globalid'], 'komponenttype': feature['komponenttype'], 'nettniva': feature['nettniva'], 'formStatus': feature['formStatus'], 'creator': feature['creator'], 'creationdate': feature['CreationDate'], '_creationdate': Number(Date(Year(feature['CreationDate']), Month(feature['CreationDate']), Day(feature['CreationDate']))), 'id': feature['id'], 'driftsmerking': feature['driftsmerking'], 'message': feature['message'], 'classid': feature['classid'], 'spenning': feature['spenning'] } }; // Push feature into array Push(features, feat); }; for (var feature in fs2) { // Filter points by polygon //var pts = Contains(feature, fs2); // Create feature with aggregated values feat = { 'attributes': { 'objecttype': ['LineObject'], 'objectid': feature['objectid'], 'globalid': feature['globalid'], 'komponenttype': feature['komponenttype'], 'nettniva': feature['nettniva'], 'formStatus': feature['formStatus'], 'creator': feature['creator'], 'creationdate': feature['CreationDate'], '_creationdate': Number(Date(Year(feature['CreationDate']), Month(feature['CreationDate']), Day(feature['CreationDate']))), 'id': feature['id'], 'driftsmerking': feature['driftsmerking'], 'message': feature['message'], 'classid': feature['classid'], 'spenning': feature['spenning'] } }; // Push feature into array Push(features, feat); }; // Create dict for output FeatureSet var out_dict = { 'fields': [ {'name': 'objecttype', 'type': 'esriFieldTypeString'}, {'name': 'objectid', 'type': 'esriFieldTypeOID'}, {'name': 'globalid', 'type': 'esriFieldTypeGlobalID'}, {'name': 'komponenttype', 'type': 'esriFieldTypeString'}, {'name': 'nettniva', 'type': 'esriFieldTypeString'}, {'name': 'formStatus', 'type': 'esriFieldTypeString'}, {'name': 'creator', 'type': 'esriFieldTypeString'}, {'name': 'creationdate', 'type': 'esriFieldTypeString'}, {'name': '_creationdate', 'type': 'esriFieldTypeDate'}, {'name': 'id', 'type': 'esriFieldTypeString'}, {'name': 'driftsmerking', 'type': 'esriFieldTypeString'}, {'name': 'message', 'type': 'esriFieldTypeString'}, {'name': 'classid', 'type': 'esriFieldTypeString'}, {'name': 'spenning', 'type': 'esriFieldTypeString'} ], 'geometryType': '', 'features': features }; // Convert dictionary to feature set. return FeatureSet(Text(out_dict));

Re: ArcGIS Dashboard Using Arcade to union two datasets (featureLayers)

DavidNyenhuis1 — Thu, 15 Jun 2023 19:18:30 GMT

With this week's update to Arcade and ArcGIS Dashboards, date fields in feature set constructors now just work. You no longer have to wrap dates with Number() if you pass the dictionary into the FeatureSet() function (which as of this release accepts a dictionary as opposed to only text based JSON).

Instead of:

return FeatureSet(Text(dict))

Do this:

return FeatureSet(dict)

Learn more in this blog post.

NOTE: For Enterprise users, this update is targeted for 11.2

Re: ArcGIS Dashboard Using Arcade to union two datasets (featureLayers)

LarsChristianØstgaard — Mon, 11 Sep 2023 20:24:22 GMT

Thanks for the update, I will try this

Re: ArcGIS Dashboard Using Arcade to union two datasets (featureLayers)

OussamaMerhi — Mon, 15 Jul 2024 12:51:21 GMT

Hi,

Thanks for the code. In case the two feature sets fs1 and fs2 have the same structure and fields, how can I adjust the code to avoid writing the name of all fields?

Oussama

Re: ArcGIS Dashboard Using Arcade to union two datasets (featureLayers)

DavidNyenhuis1 — Wed, 24 Jul 2024 15:54:33 GMT

Hi @OussamaMerhi,

You can use the Schema() function to get the schema, which includes an array of fields.

// From above example //Pull PointObject data var fs1 = FeatureSetByPortalItem(p, itemID_points, layerID_points, fields_points, false); // Get the schema from the feature set var fs1Schema = Schema(fs1); var fs1Fields = fs1Schema.fields; var fs1GeomType = fs1Schema.geometryType //Create empty dictionary var dict = { 'fields': fs1Fields, 'geometryType': fs1GeomType, 'features': [] };