LOL, I have no idea how/why my script works so quickly! Yes, there are APIs available. However, as you already have the data neat-n-tidy in a table, it might be easier to use the database to do the algorithm. An API such as: https://github.com/google/open-location-code/wiki/Plus-codes-API returns a rather long JSON email for each lon/lat which would then need further scripting to retrieve the pluscode.
Yes, it is unfortunate that your tables are dbf. However, if you do have MSAccess, it can import and/or link to dbf files. From there, my example script could be used. Does your table's location data change much/frequently or is it referencial/historic? Depending on your circumstances, I'd happily add a pluscode field to your table for you. For privacy issues, you may want to edit the table to only include the lon/lat and the index/primary key. Bare in mind, though, that my script presently is accurate to the "+" part of the pluscode - which gives a global reference to a square measuring 275 metres on the side On Wednesday, October 14, 2020 at 2:32:13 PM UTC+1 anthony...@gmail.com wrote: > Unfortunately, I'm working with dbf tables. I was hoping that there was a > separate API call that would allow me to send batches of requests. How in > the world are you getting your script to run so quickly? > Thanks > > On Tuesday, October 13, 2020 at 2:05:48 PM UTC-4 theriverm...@gmail.com > wrote: > >> >> Hi, >> >> Perhaps if it is an MSAccess database, you could try my VBA script from >> here: >> https://github.com/google/open-location-code/issues/364 >> >> Given a table that includes lon lat fields, it will generate an >> additional field containing pluscodes to the accuracy of the "+" >> My issue on GitHub was asking for clarification on calculating the >> pluscode to the right of the "+" >> >> My script can work on tables of about 50k records, however, I found that, >> for some reason, the script works better on larger tables when they are >> stored as separate CSV files. >> On Tuesday, October 13, 2020 at 6:50:03 PM UTC+1 anthony...@gmail.com >> wrote: >> >>> Is there a method that would allow for batch requests? I'd like to >>> request a code for each address in my database (around 33k), is the only >>> way to do this is one at a time? >>> >>> Thanks, >> >> -- Public site: http://www.openlocationcode.com/ Github project: https://github.com/google/open-location-code Demo site: http://plus.codes/ --- You received this message because you are subscribed to the Google Groups "Plus Codes Community Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to open-location-code+unsubscr...@googlegroups.com. To view this discussion on the web, visit https://groups.google.com/d/msgid/open-location-code/bdbc6512-75f8-4dec-8b53-8b789f037bd2n%40googlegroups.com.
