Finding a company address

42 views
Skip to first unread message

Hosioneh

unread,
Aug 30, 2018, 3:33:30 PM8/30/18
to OpenRefine

1. Is there a way to lookup company information from google map if I have its name?

for example AIMIA is input and output is like the following. It is extracted from Google maps page.
Address: 130 King St W, Toronto, ON M5X 1K6
JJX9+46 Toronto, Ontario
Website: aimia.com

if yes
my second question is:

2. Is there a way to look it up in a certain area such as country or city?

for example Siemens, Toronto is input and output is like the following. It is extracted from Google maps page.
Address: 1577 North Service Rd E, Oakville, ON L6H 0H6
F8QG+52 Oakville, Ontario
website: siemens.ca

aurielle perlmann

unread,
Aug 30, 2018, 3:37:06 PM8/30/18
to openr...@googlegroups.com
You should check out google maps api's you get a number of free searches a day - which you can expand up to something like 10,000 or 50,000 if you just for adding a credit card (but still dont pay)

then you can fetch the results from the api

sample:
search endpoint:


--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


--
Aurielle Perlmann
Sr. Datafox Analyst

Hosioneh

unread,
Aug 31, 2018, 8:28:49 AM8/31/18
to OpenRefine
Thank you!

Is there a way to use it as a reconcile service in OR?

Ettore Rizza

unread,
Aug 31, 2018, 2:48:16 PM8/31/18
to OpenRefine
Open Corporates offers a reconciliation service that could probably help you, but I think it's freemium. If your companies are big enough, the totally free Wikidata reconciliation service could be a solution.

Ettore Rizza

unread,
Aug 31, 2018, 2:50:43 PM8/31/18
to OpenRefine
Sorry, I probably misenderstood your question. Did you mean: an automatic reconciliation service with Google Maps? In thiscas, the answer is no. This service does not exist yet.

Hosioneh

unread,
Sep 4, 2018, 9:35:56 AM9/4/18
to OpenRefine
Thank you Ettore,
Yes, I mean reconcile with Google Map.
sorry to hear that it doesn't exist.
Reply all
Reply to author
Forward
0 new messages