Building Permits Dataset is not functioning properly in opengrid.io

[reve0716]

Building Permits is not functioning properly. When the data-set is ran the results is plotted on the grid. The table grid doesn't display data in the table rows. When clicking on a data point the grid redirects to the right. (Note: The more you selected data points the further to the right the grid re-positions itself until its in the area of the water).

See Images Below:
Empty rows in table

The direction the grid moves toward when selecting a data point

[PriyaDoIT]

Tried to replicate this issue for other data sets such as Business Licenses and Relocated Vehicles, but they were fine. This issue is only happening for the Business Permits dataset.

[nfspeedypur]

The never seeing the popup is due to the number of columns in the dataset. Since we are pulling data from Plenar.io and there is not concept of the popup the code currently puts all columns into the pop up.

One option I could do is include the first X columns in the pop up. My guess is something like 10 or 15 would fit on an average screen.

Also there is data in the table below, but since there is so many columns it is hard to truly see the data.

[PriyaDoIT]

hi @nfspeedypur if we limit the number of columns in the popup would it fix the issue of the map zooming out when clicking on the dot? can we pick and choose which columns appear in the popup instead of the first X columns?
I referenced the data portal and I agree with you regarding the data in the grid view.
https://data.cityofchicago.org/Buildings/Building-Permits/ydr8-5enu
For this data set in particular there are 15 columns for contractor type and another 15 for contractor name and many of them are empty. Is it possible to have the popup only show the columns that have data?

cc: @tomschenkjr

[nfspeedypur]

The issue with picking the columns is that I have no place to store this data. The OpenGrid website has no backing database, since it pulls all of its data from Plenar.io. I can store data in a flat file, but then with each new dataset we would need to go onto the servers and modify the flat files. This solution was something we decided in the beginning was a bad plan.

[PriyaDoIT]

how about only displaying columns with data? if blank, don't display in popup.

[nfspeedypur]

The determination to what columns are in the popup is part of the dataset metadata, so its one setup per dataset done before any data is fetched. What you are requesting would be a change to OpenGrid UI to allow for the removal of fields based on them have no data.

[PriyaDoIT]

per our meeting on 1/20, may need to make these changes on the Plenario side.

[reve0716]

Retested still remains the same