topic Creating Dashboard elements with GeoJSON in ArcGIS API for Python Questions

Creating Dashboard elements with GeoJSON

Wirescan — Mon, 08 Feb 2021 18:25:22 GMT

Hello! So we have been using the ArcGIS Dashboard for some time and we are now making use of the recently added submodule arcgis.apps.dashboard.

One of the issuess we are facing is creating a dashboard elements(charts,gauge etc) with GeoJSON related data. When the Python API tries to create a Dashboard chart element, it usually looks after table data. But since we are dealing with GeoJSON, the data it is stored in propertie objects and not tables.

File "D:\Anaconda\envs\agol_env\lib\site-packages\arcgis\apps\dashboard\_gauge\_gauge.py", line 507, in objectid_field return self._item.tables[0].properties["objectIdField"] IndexError: list index out of range

Creating dashboard elements with GeoJSON related object works fine manually on the ArcGIS Online website.

Re: Creating Dashboard elements with GeoJSON

MehdiPira1 — Tue, 09 Feb 2021 05:07:03 GMT

Hi @Wirescan ,

No sure exactly what you're trying to achieve.

Is it possible to share your script?

Re: Creating Dashboard elements with GeoJSON

Wirescan — Tue, 09 Feb 2021 08:42:38 GMT

All 3 elements are taking advantage of the same feature layer. The difference is that element 3 is requiring it through a webmap widget.

Here is the script:

### ITEMS item_name= 'Faerder Cable Network As Found' item_geojson_related = gis.content.search(query='title: "{0}"'.format(item_name), max_items=1, item_type='Feature Layer')[0] webmap_name = 'Faerder Windmill Park Static View' webmap_item = gis.content.search(query='title: "{0}"'.format(webmap_name), max_items=1, item_type='Web Map')[0] webmap = WebMap(webmap_item) ### DASHBOARD ELEMENTS # Element 1 - Cable Capacitance capacitance_chart = SerialChart(item_geojson_related, name='Cable Capacitance', categories_from='features', description='Cable Capacitance') capacitance_chart.data.category_field = 'CableID' capacitance_chart.data.add_value_field('Measureed Capacitance (pF/m)') # Element 2 - Cable Inductance inductance_chart = SerialChart(item_geojson_related, name='Cable Inductance', categories_from='features', description='Cable Inductance') inductance_chart.data.category_field = 'CableID' inductance_chart.data.add_value_field('Measured Inductance (micro Henry/m)') # Element 3 - Gauge gauge = Gauge(webmap, name='Average Delta G in Visible Cable Network', layer=0, description='Average Delta G in Visible Cable Network') gauge.data.value_type = 'statistic' gauge.data.statistics = 'Average' gauge.data.statistics_field = 'Delta_G' gauge.gauge_options.shape = 'horseshoe'

Element 1&2 returns this error:

File "C:/Users/Henrik/AppData/Roaming/JetBrains/PyCharmCE2020.2/scratches/scratch_4.py", line 23, in <module> capacitance_chart.data.category_field = 'CableID' File "D:\Anaconda\envs\agol_env\lib\site-packages\arcgis\apps\dashboard\_serialchart\_serial_chart.py", line 916, in category_field if self._field_type(value) == '<M8[ns]': File "D:\Anaconda\envs\agol_env\lib\site-packages\arcgis\apps\dashboard\_serialchart\_serial_chart.py", line 1048, in _field_type f_type = self._item.tables[0].query().sdf[field_name].dtype IndexError: list index out of range

Re: Creating Dashboard elements with GeoJSON

PraktikantPraktikant — Mon, 24 Jan 2022 09:08:53 GMT

I also have the same issue like @Wirescan. When will this bug be fixed?