{"action":"created","issue":{"url":"https://api.github.com/repos/mapbox/preprocessorcerer/issues/32","labels_url":"https://api.github.com/repos/mapbox/preprocessorcerer/issues/32/labels{/name}","comments_url":"https://api.github.com/repos/mapbox/preprocessorcerer/issues/32/comments","events_url":"https://api.github.com/repos/mapbox/preprocessorcerer/issues/32/events","html_url":"https://github.com/mapbox/preprocessorcerer/issues/32","id":69907249,"number":32,"title":"Remove extraneous mbtiles records","user":{"login":"rclark","id":515424,"avatar_url":"https://avatars.githubusercontent.com/u/515424?v=3","gravatar_id":"","url":"https://api.github.com/users/rclark","html_url":"https://github.com/rclark","followers_url":"https://api.github.com/users/rclark/followers","following_url":"https://api.github.com/users/rclark/following{/other_user}","gists_url":"https://api.github.com/users/rclark/gists{/gist_id}","starred_url":"https://api.github.com/users/rclark/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rclark/subscriptions","organizations_url":"https://api.github.com/users/rclark/orgs","repos_url":"https://api.github.com/users/rclark/repos","events_url":"https://api.github.com/users/rclark/events{/privacy}","received_events_url":"https://api.github.com/users/rclark/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-04-21T17:33:59Z","updated_at":"2015-04-22T10:03:08Z","closed_at":null,"body":"As part of preprocessing, we should:\r\n\r\n```\r\nDELETE from map where tile_id is null\r\n```\r\n\r\n... followed by vacuum on the database.\r\n\r\n@BergWerkGIS let me know if you have time to take this on, otherwise I'll tackle it."},"comment":{"url":"https://api.github.com/repos/mapbox/preprocessorcerer/issues/comments/95111632","html_url":"https://github.com/mapbox/preprocessorcerer/issues/32#issuecomment-95111632","issue_url":"https://api.github.com/repos/mapbox/preprocessorcerer/issues/32","id":95111632,"user":{"login":"BergWerkGIS","id":4549888,"avatar_url":"https://avatars.githubusercontent.com/u/4549888?v=3","gravatar_id":"","url":"https://api.github.com/users/BergWerkGIS","html_url":"https://github.com/BergWerkGIS","followers_url":"https://api.github.com/users/BergWerkGIS/followers","following_url":"https://api.github.com/users/BergWerkGIS/following{/other_user}","gists_url":"https://api.github.com/users/BergWerkGIS/gists{/gist_id}","starred_url":"https://api.github.com/users/BergWerkGIS/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/BergWerkGIS/subscriptions","organizations_url":"https://api.github.com/users/BergWerkGIS/orgs","repos_url":"https://api.github.com/users/BergWerkGIS/repos","events_url":"https://api.github.com/users/BergWerkGIS/events{/privacy}","received_events_url":"https://api.github.com/users/BergWerkGIS/received_events","type":"User","site_admin":false},"created_at":"2015-04-22T10:03:08Z","updated_at":"2015-04-22T10:03:08Z","body":"@rclark I'm deep into the sprint this week. Would be great if you could tackle it.\r\n\r\nShould even work as a one liner:\r\n```\r\nDELETE from map where tile_id is null; VACUUM;\r\n```\r\nLet me know if you need anything else."}}