Scroll

Add Drillable Regions to Google Maps (BETA)

Caution: This article describes an extensibility example which is currently in development. As with any beta products, there may be bugs or flaws. Use with discretion, test extensively, and please let us know of any issues you find.

Google Maps currently support several levels of "drilling", which refers to the ability to double-click on a highlighted region to zoom into its component pieces. For example, double-clicking on the United States shows data from each state. Double-clicking on a state shows data from each county.

Currently the United States supports five levels of data. In descending order:

  • Country
  • State
  • County
  • Postal Code
  • City

The lowest level of data on your map will appear as either a highlighted region or a drop pin, depending on your selection.

Countries outside of the United States do not support the State, County, or Postal Code levels by default. This is because each level of regions requires specialized boundary data, which specifies the geographical outline of each region by coordinates. The data is stored and referenced from a "polygon" file, the US version which we provide for download on this site.

You can add boundary data for other countries using a script file that we provide:

Download the script.

The requirements are:

  1. Locate the raw boundary data in one of several formats from the relevant country's census bureau, or another geographical provider. Each drill level should be a separate file.
  2. Have Python installed in order to run the script.
  3. Make sure to append all the data to the same polygon file (at the moment, Exago BI only reads from one polygon file).

For information on usage, see the README file included with the attached script.

Note that in the Google Maps Wizard, region levels are referred to by their United States equivalents. So Canadian provinces, for example, would be referred to as "states".


Hidden Article Information

Article Author
Alexander Agoado
created 2018-08-15 14:16:58 UTC
updated 2018-09-17 13:34:09 UTC

Labels
state, chart, drilldown, code, country, database, drill, wizard, sqlite, level, county, province, zip, postal, post, polygon,
Have more questions? Submit a request