{"issue":{"created_at":"2011-11-20T23:18:40Z","state":"open","updated_at":"2011-11-20T23:18:40Z","user":{"gravatar_id":"ac3d27a05c19e3186ca963af363956b9","id":93353,"url":"https://api.github.com/users/gundersen","login":"gundersen","avatar_url":"https://secure.gravatar.com/avatar/ac3d27a05c19e3186ca963af363956b9?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"comments":0,"body":"@springmeyer, \r\nHow easy can we make it to join a CSV file to SQLite in TileMill?\r\n\r\nFor example say I have a CSV file of Country names and a SQLite file with the geometries for all countries. If I could easily join the country columns I could just use my CSV file to create a shaded polygon map. \r\n\r\nAs you know @dhcole is working w/ @ajashton + data team to package a significant amount of SQLite files as part of Dept. Ed work and we could add these to MapBox geodata cloud, which is why I'm asking. Here is the current backlog\r\n\r\n> ### spatial\r\n- Census blocks\r\n- Census tracks \r\n- school districts\r\n- zipcodes\r\n- (maybe) legislative districts (atlas specific)\r\n- counties\r\n- media markets (atlas specific)\r\n- congressional districts\r\n- states \r\n- countries\r\n","assignee":{"gravatar_id":"edd0be6c7c035b58bb2712284da41f1f","id":20300,"url":"https://api.github.com/users/springmeyer","login":"springmeyer","avatar_url":"https://secure.gravatar.com/avatar/edd0be6c7c035b58bb2712284da41f1f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png"},"id":2299948,"number":941,"pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"labels":[{"name":"wishlist","color":"00ff09","url":"https://api.github.com/repos/mapbox/tilemill/labels/wishlist"}],"title":"joining CSVs to SQlite in TileMill","closed_at":null,"html_url":"https://github.com/mapbox/tilemill/issues/941","milestone":null,"url":"https://api.github.com/repos/mapbox/tilemill/issues/941"},"action":"opened"}