OpenGrid SF 311 data-set SR_Type doesn't have list of values pre-populating in drop-down menu.

[reve0716]

After testing the SF 311 dataset couldn't prepop in dropdown menu an SR Type. Spoke with Vince says plenario doesnt support column summary this will be an OpenGrid application change. I created an SMS Ticket 12135 to track the issue.

[reve0716]

@rladines Is there anything you need from our team in regards to this issue? Jonathan has a table he is pulling from to obtain a list the sr_types not sure if this with help our cause but can discuss in meeting today.

[rladines]

@reve0716 Ideally, you'd want to use the source of data, in this case, the Plenar.io API to get the list of unique SR Types. I'm not sure that this is possible using the Plenar.io API. Something to ask the Plenar.io folks?

[reve0716]

@rladines Vince stated plenar-io doesn't support column summary, so I don't think he would have the data unless its available in open data portal (Jonathan setup).
I'll ask Jonathan about his file he uses to identify the SR Types, maybe he could give us an answer.

[rladines]

@reve0716 I started doing some more analysis on this last week. Found that we do have the latest code on the OpenGrid client for the dropdown/auto-complete.

Though, the OpenGrid Planar.io service side will need to be updated to support listofValuesId on the meta, as this is currently not implemented, and to support population of unique values for selected columns like SR Types, as you have requested on this issue. Per Jon Levy's email, there's a way to grab the list of unique values from Socrata directly. We just have to design this so the auto-complete feature can be extended to other fields in the future.

[reve0716]

Develop a plan to design auto complete feature (list of values) for OG.

[reve0716]

@setup meeting for Wednesday for 311 SR Type

[reve0716]

Place on Hold