docker-cartodb icon indicating copy to clipboard operation
docker-cartodb copied to clipboard

How to enable internal geocoder in Builder and for other users

Open sindile opened this issue 7 years ago • 1 comments

  1. How to enable the internal geocoder API for other accounts as it works for the user 'geocoder'

  2. How to enable the internal geocoder in builder for bother user 'geocoder' and other users. I did try this - bundle exec rake cartodb:db:configure_geocoder_extension_for_non_org_users[geocoder,true] I get an error at the end Sequel::Postgres::Database (0.9ms) SELECT * FROM "users" WHERE ("username" = 'geocoder') LIMIT 1 ERROR geocoder

As indicated the internal geocoder works via the API for the user geocoder

If I run the following: http://cartodb.local/user/geocoder/api/v2/sql?q=SELECT%20(geocode_postalcode_points(Array[%2710013%27,%27G9H%27,%2703782%27],%20Array[%27USA%27,%20%27Canada%27,%20%27US%27])).*

I do get a response: {"rows":[{"q":"10013","c":"USA","iso3":"USA","geom":"0101000020E610000090679AEE4D8052C0C4C6BC8E385C4440","success":true},{"q":"G9H","c":"Canada","iso3":"CAN","geom":"0101000020E610000096B20C71AC1B52C0423EE8D9AC2A4740","success":true},{"q":"03782","c":"US","iso3":"USA","geom":"0101000020E6100000AE47E17A140652C0E10B93A982B14540","success":true}],"time":0.038,"fields":{"q":{"type":"string"},"c":{"type":"string"},"iso3":{"type":"string"},"geom":{"type":"geometry"},"success":{"type":"boolean"}},"total_rows":3}

sindile avatar Mar 09 '18 07:03 sindile

Having the same exact question.

mapninja avatar Sep 03 '19 16:09 mapninja