where and how to get all business phone list for entire city

Question

Where

google, microsoft, yelp, hereMap

ESRI does not provide phone, only provide business name
 

How

use tool extract and download POI in .csv format, then open it with excel

 

 

 

Step 1.

find your city boundary layer from any county GIS website.

 

 

 los angeles county city boundary is here

https://transparentgov.net/json2tree/esri/server/folder2.html?org=https%3A%2F%2Fpublic.gis.lacounty.gov%2Fpublic%2Frest%2Fservices&url=https%3A%2F%2Fpublic.gis.lacounty.gov%2Fpublic%2Frest%2Fservices&arcgis_online_token=&timeout=9000&select_folder=28&select_layer=0&select_folder_text=LACounty_StreetMap+%3Csup%3EMapServer%3C%2Fsup%3E&select_layer_text=0+%26%23x21E2%3B+Cities+and+Communities+%3Csup%3EFeature+Layer%3Csub%3E+esriGeometryPolygon%3C%2Fsub%3E%3C%2Fsup%3E

 

 

 

San bernadino county city boundary is here

https://transparentgov.net/json2tree/esri/server/folder2.html?url=https%3A%2F%2Fservices.arcgis.com%2FaA3snZwJfFkVyDuP%2FArcGIS%2Frest%2Fservices&org=https%3A%2F%2Fservices.arcgis.com%2FaA3snZwJfFkVyDuP%2FArcGIS%2Frest%2Fservices&arcgis_online_token=&select_folder=102&select_layer=0&select_folder_text=Cities_and_Towns+%3Csup%3EFeatureServer%3C%2Fsup%3E&select_layer_text=0+%26%23x21E2%3B+Cities+and+Towns+%3Csup%3EFeature+Layer%3Csub%3E+esriGeometryPolygon%3C%2Fsub%3E%3C%2Fsup%3E

 

 

 

 

river-side county city boundary is here

https://transparentgov.net/json2tree/esri/server/folder2.html?org=https%3A%2F%2Fgis.countyofriverside.us%2Farcgis_mapping%2Frest%2Fservices&url=https%3A%2F%2Fgis.countyofriverside.us%2Farcgis_mapping%2Frest%2Fservices&arcgis_online_token=&timeout=9000&select_folder=45&select_layer=100&select_folder_text=General+%3Csup%3EMapServer%3C%2Fsup%3E&select_layer_text=100+%26%23x21E2%3B+CITIES+%3Csup%3EFeature+Layer%3Csub%3E+esriGeometryPolygon%3C%2Fsub%3E%3C%2Fsup%3E

 

 

 

 

 

orange county city boundary is here

https://transparentgov.net/json2tree/esri/server/folder2.html?org=https%3A%2F%2Focgis.com%2Farcpub%2Frest%2Fservices&url=https%3A%2F%2Focgis.com%2Farcpub%2Frest%2Fservices&arcgis_online_token=&timeout=9000&select_folder=383&select_layer=0&select_folder_text=City_Boundaries+%3Csup%3EMapServer%3C%2Fsup%3E&select_layer_text=0+%26%23x21E2%3B+City+Boundaries+%3Csup%3EFeature+Layer%3Csub%3E+esriGeometryPolygon%3C%2Fsub%3E%3C%2Fsup%3E

 

 

 

 

 

 

 

 

Step 2.

click google POI download tool

 

 

 

 

 

 

Step 3.

search by city name, or zip code

 

 

 

 

 

Step 4.

click map to draw a circle, which will extract massive poi

 

 

 

 

 

 

 

Step 5.

click download .csv button

 

 

Step 6.

open .csv file in excel, phone list show up