{"action":"closed","issue":{"url":"https://api.github.com/repos/CartoDB/cartodb/issues/2503","labels_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2503/labels{/name}","comments_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2503/comments","events_url":"https://api.github.com/repos/CartoDB/cartodb/issues/2503/events","html_url":"https://github.com/CartoDB/cartodb/issues/2503","id":58925961,"number":2503,"title":"the_geom is empty but there are geometries in the map (after georeferencing)","user":{"login":"iriberri","id":1730320,"avatar_url":"https://avatars.githubusercontent.com/u/1730320?v=3","gravatar_id":"","url":"https://api.github.com/users/iriberri","html_url":"https://github.com/iriberri","followers_url":"https://api.github.com/users/iriberri/followers","following_url":"https://api.github.com/users/iriberri/following{/other_user}","gists_url":"https://api.github.com/users/iriberri/gists{/gist_id}","starred_url":"https://api.github.com/users/iriberri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/iriberri/subscriptions","organizations_url":"https://api.github.com/users/iriberri/orgs","repos_url":"https://api.github.com/users/iriberri/repos","events_url":"https://api.github.com/users/iriberri/events{/privacy}","received_events_url":"https://api.github.com/users/iriberri/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":{"login":"javisantana","id":30147,"avatar_url":"https://avatars.githubusercontent.com/u/30147?v=3","gravatar_id":"","url":"https://api.github.com/users/javisantana","html_url":"https://github.com/javisantana","followers_url":"https://api.github.com/users/javisantana/followers","following_url":"https://api.github.com/users/javisantana/following{/other_user}","gists_url":"https://api.github.com/users/javisantana/gists{/gist_id}","starred_url":"https://api.github.com/users/javisantana/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/javisantana/subscriptions","organizations_url":"https://api.github.com/users/javisantana/orgs","repos_url":"https://api.github.com/users/javisantana/repos","events_url":"https://api.github.com/users/javisantana/events{/privacy}","received_events_url":"https://api.github.com/users/javisantana/received_events","type":"User","site_admin":false},"milestone":null,"comments":1,"created_at":"2015-02-25T16:18:10Z","updated_at":"2015-02-25T16:44:57Z","closed_at":"2015-02-25T16:44:57Z","body":"* Uploaded [this file](https://gist.github.com/iriberri/4bc0a861552770f6975c)\r\n* Tried to georeference by admin regions: state column + usa column as country.\r\n* Fails because the usa column contains empty spaces\r\n* Run these two queries:\r\n  * update sample_data_with_state_names_3 set usa = 'USA' WHERE usa ilike '%USA'\r\n  * update sample_data_with_state_names_3 set usa = 'CANADA' WHERE usa ilike '%canada'\r\n* Try to georeference again. State column + Usa column as country.\r\n* Message says that 36 out of 39 have been geocoded (or something like that).\r\n* Go to map view: I get the message: no georeferenced table. I still see the geometries there...\r\n* In table view, the_geom is null for all rows and cartodb_georef_status is null too.\r\n\r\nTable: https://team.cartodb.com/u/iriberri/tables/sample_data_with_state_names_3/table\r\nScreenshots:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1730320/6374570/1879cd2c-bd12-11e4-8e4f-43a22db3a094.png)\r\n\r\n![image](https://cloud.githubusercontent.com/assets/1730320/6374575/1f7a176c-bd12-11e4-8b81-1c7dff81fe3e.png)\r\n\r\n  "}}