I am interested in a Geospacial Dataset - It can be static

Capranica, Stephen (NAZ-V) 20 Reputation points
2024-02-05T15:53:35.81+00:00

I am not interested in making an app for public use. I am interested in the data itself for internal use on a project dedicated to understanding the different types of Convenience stores based on store attributes. I have Address and Lat/Long lookups for over 147k "stores" and I want to identify each store location of interest on the following

  1. If each location offers gas/fuel (the number of pumps would be great but a simple Y/N would work,
  2. whether it offers food services (hot meals/or sit down), as well as
  3. The size of the physical location of the convenience store in square feet or some size to determine the inside of the store space

I do not need it to continuously update or use the information in any dynamic fashion like in developing an application, but is there any open source or way for me to reference and use data from Bing Maps or Microsoft to find convenience stores and the relevant information associated with them?

Azure Open Datasets
Azure Open Datasets
An Azure service that provides curated open data for machine learning workflows.
29 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,093 questions
Azure Maps
Azure Maps
An Azure service that provides geospatial APIs to add maps, spatial analytics, and mobility solutions to apps.
764 questions
Windows Maps
Windows Maps
A Microsoft app that provides voice navigation and turn-by-turn driving, transit, and walking directions.
257 questions
0 comments No comments
{count} votes

Accepted answer
  1. rbrundritt 18,816 Reputation points Microsoft Employee
    2024-02-05T16:49:33.9+00:00

    I'm not aware of any map service (Bing, Azure, google...) that offers this level of data. Large convivence store chains may have data sets for their own stores, but may not make that publicly available as a raw data set (they might have a store locator app on their website with these details).

    That said, you may be able to get some of this data with varying accuracy/coverage in the following ways:

    • Use Bing's Location Recognition. Check the Type and OtherTypes properties of the business results. Look for "Gas Stations", "Restaurant", "Fast Food" and that will give you some insights. You won't get the number of pumps or if it is sit down restaurant or not.
    • As for the size, the best you would likely be able to do is to try and get the building footprint polygon for the building, and then calculate the area of that. You could assume a percentage smaller is store space. This will be error prone as some gas stations have covered pump areas, while others don't. There are a few different ways to get the building data, for a bulk job like this I would look at downloading the building footprint data and loading into a database you can query: https://www.microsoft.com/en-us/maps/bing-maps/building-footprints
    • If you want other info, like hours of operation, the Azure Maps POI service has this:
      https://learn.microsoft.com/en-us/rest/api/maps/search/get-search-poi?view=rest-maps-1.0&tabs=HTTP

    https://learn.microsoft.com/en-us/rest/api/maps/search/get-search-poi-category?view=rest-maps-1.0&tabs=HTTP

    https://learn.microsoft.com/en-us/rest/api/maps/search/post-search-fuzzy-batch?view=rest-maps-1.0&tabs=HTTP


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.