Build a javascript function to display ODATA in a clean tabular format

[artitangri]

The City of San Jose has a web service that returns various datasets in the OData format.

Please help build a flexible OData reader that displays the data into a table with sortable columns.

Here are two possible test cases:

• Planning Permits Data
• Parking Data

Hopefully our solution can take any call and create different tabular displays with only small or no modifications.

If possible, the tabular display should allow you to download a CSV.

[captaincole]

@3vivekb Is this webpage going to be connected to a different project or will it be siloed in itself?

[3vivekb]

@thielCole This project will be contained within the ckan portal for the vta/san jose collaboration.

It would be a data preview in a site like http://data2.vta.org/dataset/test_082516_01.

@Kyle-Falconer could speak about this with more detail.

[artitangri]

Yes, this is for city of san jose to be able to publish live data from API to the CKAN portal. I will be there tomorrow to answer any questions.

[captaincole]

So you just want a tab style box that allows you to export the data to csv?

Ah with a table also. Ok, let me see what I can put together. I will probably use DataTables as its the easiest table plugin I know of. That or I have been playing with another pivot table library recently that could be good.

[captaincole]

@artitangri Do you know what the values mean? If you did I could make some visuals for it.

Here are the values

          "Status":"30",
    "gx_location":"  CITYWIDE   , SAN JOSE CA ",
    "ASSESSORS_PARCEL_NUMBER":null,
    "ZONING":"A",
    "APPLICANT":"Building DIvision, PBCE, City of San Jose Mr James Son",
    "OWNERNAME":"CITY OF SAN JOSE  City Attorney ",
    "ISSUEUSER":"TCHAULE",
    "PROJECTMANAGER":null,
    "FOLDERNUMBER":"2016-132501-PP",
    "FOLDERDESCRIPTION":"Envir Public Projects",
    "FOLDERNAME":"PP16-090",
    "REFERENCEFILE":"PP16-090",
    "SUBDESCRIPTION":"Exempt",
    "WORKDESCRIPTION":null,
    "ISSUEDATE":"2016-09-02T00:00:00",
    "FINALDATE":null,
    "FOLDERRSN":"1684603"

[captaincole]

Another set of examples incase it helps.

     "Status":"30",
     "gx_location":"1057  LINCOLN AV  , SAN JOSE CA 95125-6011",
     "ASSESSORS_PARCEL_NUMBER":"26457074",
     "ZONING":"CP",
     "APPLICANT":" JASON LAMMERS",
     "OWNERNAME":" JASON LAMMERS",
     "ISSUEUSER":"DFONG",
     "PROJECTMANAGER":"DFONG",
     "FOLDERNUMBER":"2016-105616-DV",
     "FOLDERDESCRIPTION":"Development Permit",
     "FOLDERNAME":"SP16-013",
     "REFERENCEFILE":"SP16-013",
     "SUBDESCRIPTION":"Special Use Permit",
     "WORKDESCRIPTION":"None",
     "ISSUEDATE":"2016-09-21T00:00:00",
     "FINALDATE":"2016-10-03T00:00:00",
     "FOLDERRSN":"1657572"

[artitangri]

This is how we would like to have it look like (in a tabular format) http://data.sanjoseca.gov/dataviews/230615/LAST-30-DAYS-PLANN-PERMI/

Ideally, the solution should be generic that it can be adapted to any dataset. So basically, depending on what data the API returns it should pick up the column names and display the data in a tabular format. No hard-coded column names.

[Kyle-Falconer]

Here's the repo for this project: https://github.com/codeforsanjose/odata-reader