{"push_id":636175837,"size":45,"distinct_size":1,"ref":"refs/heads/master","head":"847af48c226d0699370911da3e078c95e60a99eb","before":"f178c4d52cfc0c4a496d9a3d76dbdb81818c74c0","commits":[{"sha":"de3db0330682f09e328173f5a0812086fd5f3da2","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"Initial commit","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/de3db0330682f09e328173f5a0812086fd5f3da2"},{"sha":"8946d8243d8c2daad30bec01413fbcfbdb83f24d","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"structure","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/8946d8243d8c2daad30bec01413fbcfbdb83f24d"},{"sha":"e7f26c2dc5b5c737f38a867710e21915aabd2b6d","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"grunt","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/e7f26c2dc5b5c737f38a867710e21915aabd2b6d"},{"sha":"2367858474ca559061dcb5b8bc6fb1bb41fbc75c","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"added date and fix deploy","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/2367858474ca559061dcb5b8bc6fb1bb41fbc75c"},{"sha":"ccd131796d00f0f2b1f02f1e726d70212ea22a5e","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"added date and fix deploy","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/ccd131796d00f0f2b1f02f1e726d70212ea22a5e"},{"sha":"e4d5e2c5c8d35db4c04eb5ad0bc9eba4320b58c2","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"fix deploy","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/e4d5e2c5c8d35db4c04eb5ad0bc9eba4320b58c2"},{"sha":"35432d409aa90a609bfe3b9c10b331d3d425de07","author":{"email":"aa743a0aaec8f7d7a1f01442503957f4d7a2d634@simbiotica.es","name":"David González"},"message":"Optimizes scatterplot SQL\n\nInstead of selecting all the points we can query just for unique x,y combinations, and add a \"density\" field in case we want to use it in the chart. This will mean less points to draw in svg.\r\n\r\nIn many cases however we will still have too many points for the browser to handle, so we can think of re-writing this query in a way we can lower data resolution, add max, min or category filters, etc. The idea is that if the result of a query contains too many points (due to memory or just because they won't fit reasonably in the chart) we give the user options by either lowering the resolution or filtering the dataset.\r\n\r\nThe query would then look something like this:\r\n\r\nwith table as\r\n( SELECT \r\n-- We can round, average or use other functions etc. to lower resolution or aggregate\r\nfunction(columnA) as x, \r\nfunction(columnA) as y\r\nFROM selectedTable \r\nWHERE\r\n-- max, min and category filters go here\r\n)\r\n--And then \r\nSELECT x,y, COUNT((x,y)) AS density FROM table GROUP BY x,y","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/35432d409aa90a609bfe3b9c10b331d3d425de07"},{"sha":"c0c6db370c9d29a480970992cbeee9b50e0a39d2","author":{"email":"ee20dc104860330f4d8c64477492e09ed328a8dd@icloud.com","name":"David Inga"},"message":"Merge pull request #1 from d4weed/patch-2\n\nOptimizes scatterplot SQL","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/c0c6db370c9d29a480970992cbeee9b50e0a39d2"},{"sha":"434710e2fab4482e3e89df885ac996814c2661ff","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"removed Gemfile","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/434710e2fab4482e3e89df885ac996814c2661ff"},{"sha":"85c0790987d461b59335d51ff382d7e6da834aeb","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"Merge branch 'develop' of github.com:davidsingal/tocapu into develop\n\n* 'develop' of github.com:davidsingal/tocapu:\n  Optimizes scatterplot SQL","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/85c0790987d461b59335d51ff382d7e6da834aeb"},{"sha":"7e33bd502808cd1afeaf2d0a38c1e9ff7a001806","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"removed jquery","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/7e33bd502808cd1afeaf2d0a38c1e9ff7a001806"},{"sha":"e884493e681a0a27f894bb3b5dd69067e8828e7c","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"removed backbone and underscore","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/e884493e681a0a27f894bb3b5dd69067e8828e7c"},{"sha":"d617b1d5bebd73e73a8cc9c781c0a79e66038fd2","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"grid and layout","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/d617b1d5bebd73e73a8cc9c781c0a79e66038fd2"},{"sha":"0a80598f639ab8565e4cf8170568764407494be3","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"fix lg screen columns","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/0a80598f639ab8565e4cf8170568764407494be3"},{"sha":"e2b6c0248bd8a67dbe40a7ed3e6187fc97e50dd6","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"form serialize","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/e2b6c0248bd8a67dbe40a7ed3e6187fc97e50dd6"},{"sha":"762bfa506fb80ab1bdc72e5d578717a1a25ec658","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"theme and account","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/762bfa506fb80ab1bdc72e5d578717a1a25ec658"},{"sha":"f8341650f12e240ee9524e0df8be3cd354ed1e70","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"application layout styles","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/f8341650f12e240ee9524e0df8be3cd354ed1e70"},{"sha":"a118937ff83321c560c4813998f4fae5a6d84b82","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"api key has been removed - Fixes #2","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/a118937ff83321c560c4813998f4fae5a6d84b82"},{"sha":"d3aae36c6021d984c438b0124ab2469fa80d1e24","author":{"email":"d1e5255acac020387c60ee1538c510f00596bd55@icloud.com","name":"David Inga"},"message":"query view","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/d3aae36c6021d984c438b0124ab2469fa80d1e24"},{"sha":"66a0b2a467248c53ac1fab7c5a113a116e2fa97d","author":{"email":"ee20dc104860330f4d8c64477492e09ed328a8dd@simbiotica.es","name":"David Inga"},"message":"columns","distinct":false,"url":"https://api.github.com/repos/Vizzuality/tocapu/commits/66a0b2a467248c53ac1fab7c5a113a116e2fa97d"}]}