{"id":6360,"date":"2020-05-27T19:39:18","date_gmt":"2020-05-27T19:39:18","guid":{"rendered":"https:\/\/max-drake.cc\/?p=6360"},"modified":"2020-05-28T22:24:49","modified_gmt":"2020-05-28T22:24:49","slug":"kepler-gl-and-crimes-data","status":"publish","type":"post","link":"https:\/\/max-drake.cc\/?p=6360","title":{"rendered":"Kepler.gl and London Crimes Geo data & GitHub Gist, Hub, Hooks, github additions"},"content":{"rendered":"\n

I saw this video on Kepler & React<\/a><\/strong> and was excited about the Kepler app. I want to try it with NZ covid data that I’m getting from some API endpoints. But its not structured in a GeoJson format. This is a tool that Uber have developed and shared, which is nice of them. <\/p>\n\n\n\n

I’m using notepad++ & online json to CSV to order the data. One file has all the httml <paths> for regions in NZ as well as lat\/long points, another file has regional numbers by timeline, so I need to get the Lat\/long onto each timeline record for each region. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After playing around with the data it wasn’t too impressive visually on the map, so I went on and used the UK Police crimes API which I converted to CSV and got the map below. I saved it as a HTML file<\/a><\/strong> that you can view in your browser and can alsoactivate link by by clicking on image below (I haven’t used that feature before<\/em>):<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

Its fun to explore, I played with it for at least half a day, in fact most of the time was doing data manipulation and cleaning for inputting information into the online tool. <\/p>\n\n\n\n

The api I used for the above data was: where you put lat\/long in and also month. I haven’t looked up the docs for that API but may explore it later, it is fun to use. <\/p>\n\n\n\n

https://data.police.uk\/api\/crimes-street\/all-crime?lat=51.509865&lng=-0.118092&date=2020-03<\/code><\/pre>\n\n\n\n
API docs can be found here<\/a><\/strong>. You can also download CSV and that could have been a better option as I converted the JSON output to CSV because kepler.gl wanted a geoJSON file and in the JSON file the lat\/long were blended in a single column so hard to differentiate for the map. <\/p>\n\n\n\n
Add data to the map- Using GIST<\/span><\/h3>\n\n\n\n
The first I’d heard about Gists and was in the video above, and I thought this was a handy way to get an endpoint JSON file for an API. <\/p>\n\n\n\n
So I thought I’d try it out with Keplr.gl. The first time I tried to add an API URL to kepler.gl ity wanted the file extension and the api I was using didn’t need one, so I thought I’d try using GIST to make that endpoint by copying\/pasting the data , showing it RAW and getting the link. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
I had the file in raw, but it didn’t load into Kepler.gl because I’d made it a private repository instead of a public one, so I had to go back and delete the existing file (I couldn’t find setting where to change from private to public<\/em>)  and re-do the whole exercise. <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Kepler.gl puilled it in fine after I made it a public GIST, so that was OK. <\/p>\n\n\n\n
Link to creation of gist here<\/a><\/strong>. I think its a single file share, and works as an endpoiint for me. <\/p>\n\n\n\n
Just on that, GitLab<\/a><\/strong> has CI\/CL continuous integration\/Cont ..   . I may have to explore that later too there is a free tier to the services.<\/p>\n\n\n\n
Other Git services<\/h3>\n\n\n\n
I came across Git marketplace and put a query  in YT for indfromation on best add-ins and came up with this video:<\/p>\n\n\n\n
\n