[Proposal] Open Data XLS | PDF to JSON

Question

[Proposal] Open Data XLS | PDF to JSON

pasindud opened this issue 10 years ago · 27 comments

pasindud commented 10 years ago

Please comment on your thoughts

dhammikamare commented 10 years ago

👍

pasindud commented 10 years ago

bump

Answer 1 · 2014-11-11T15:53:03.000Z

How about XLS|PDF to JSON. Since SQL itself has lots of limitations now a days specially in mobile and client side of web. I think it'll be great if we can have JSON data as there are ways to convert JSON to SQL if someone wants.
Then even by a simple request you can have the data tunnel to apps that you build.

Answer 2 · 2014-11-11T16:31:51.000Z

Hi @dhammika-marasinghe
Yea that is a great idea actually. I shall change the topic.

Change

Open Data XLS | PDF to SQL  ->  Open Data XLS | PDF to JSON

Answer 3 · 2014-11-11T17:34:54.000Z

@dhammika-marasinghe There about 80 data sets suggestion on where to start ?

Answer 4 · 2014-11-11T17:43:50.000Z

seems like Central bank, Motor Traffic, ICTA and Police has more useful information for the developers

Answer 5 · 2014-11-11T18:13:29.000Z

Can you list down set of data sets ??

Answer 6 · 2014-11-11T18:40:43.000Z

I think this is a great idea!
What about starting with datasets under Population: population, literacy rate and colombo consumer price index? I think they would be among the most useful.

Answer 7 · 2014-11-11T19:13:40.000Z

@dshgna Great !

We can start from here Link

Answer 8 · 2014-12-04T06:29:14.000Z

Guys are you guys working on this?

Answer 9 · 2014-12-04T15:43:03.000Z

hoping to start my work after 2 weeks finishing all these conferences,
projects, exams, ... :p

On Thu, Dec 4, 2014 at 11:59 AM, Pasindu De Silva notifications@github.com
wrote:

Guys are you guys working on this?

—
Reply to this email directly or view it on GitHub
#2 (comment)
.

Dhammika Marasinghe
Computer Engineering Undergraduate,
Department of Computer Engineering,
University of Peradeniya

Mobile | +940770776737
LinkedIn | dhammikamarasinghe
http://lk.linkedin.com/in/dhammikamarasinghe/
Facebook | dhammika.marasinghe.net
https://www.facebook.com/dhammika.marasinghe.net
Google+ | DhammikaBandaraMarasinghe
http://google.com/+DhammikaBandaraMarasinghe

Answer 10 · 2014-12-06T13:23:36.000Z

I'll be starting after Dec 12th. Got final year project.

Answer 11 · 2014-12-29T10:55:52.000Z

Guys made a translisteration singlish api download and have a look https://github.com/CodeLanka/singlish-api

Answer 12 · 2014-12-29T11:05:38.000Z

brilliant! i'll check this out as soon as i can. btw, is this the right issue for this comment?

Answer 13 · 2014-12-29T11:09:50.000Z

oh it seems not

Answer 14 · 2015-01-03T04:44:38.000Z

@dshgna bump

Answer 15 · 2015-01-04T01:02:52.000Z

Check these guys

Annual Population Growth rate

http://codelanka.github.io/open-data-visualization/visualization/annual_population_growth_rate

Dataset to JSON - https://github.com/CodeLanka/open-data-api

*dataset has missing metadata

Answer 16 · 2015-01-28T15:52:59.000Z

We can get datasets from Health Ministry also ( Specially about disaster management, etc. ), I can help with that.

Answer 17 · 2015-02-17T13:23:01.000Z

Hi.. Since we are still in the very early stages of this, wouldn't it better to plan this project with a focus on where web technologies are headed? My suggestion is to use the linked data approach, using RDF.

Check this: http://www.w3.org/TR/ld-bp/

(I'm also new to these so don't really have much of an idea about the scale of doing such a project though)

Answer 18 · 2015-02-18T11:10:58.000Z

@pubudu91 do you know a sample which adheres to this so we can check it?

Answer 19 · 2015-02-18T11:12:00.000Z

http://opendatahandbook.org/ something to look into

Answer 20 · 2015-02-19T03:58:44.000Z

I would more like to get the data to JSON so later when we have to adhere to standards we can run scripts to transform them.

Answer 21 · 2015-02-19T17:32:41.000Z

@pasindud http://www.w3.org/wiki/TaskForces/CommunityProjects/LinkingOpenData/DataSets < try this one

Answer 22 · 2015-02-25T17:04:38.000Z

It would also be useful/interesting to get data-sets from the department of transportation. I haven't been able to find any, but I'll try contacting them (hopefully I won't be turned down).
Also, I'll look into converting the data-sets already provided into JSON.
(Sorry if my comment seems out of place, I'm new here ._. )

Answer 23 · 2015-04-22T11:12:30.000Z

has anyone seen this initiative: http://dev.socrata.com/ ?

edit: it's a commercial company, but i think there's something to be learned from their approach

Answer 24 · 2015-04-23T16:30:45.000Z

@hliyan That's exactly what I wanted to accomplish.
This is worth a look too. www.youtube.com/watch?v=RrPZza_vZ3w
It's rather long though.

Answer 25 · 2015-05-30T18:25:06.000Z

Apologies for my absence. Was overwhelmed with work, so I couldn't really contribute much to the projects recently, but I've been coding a couple of Python scripts that would let me efficiently convert the data-set's from gov.lk to a more computer readable format. I'll keep you updated.