Define GMaps Plugin Shapefile Keys
Shape Data Keys
Shape data keys provides absolute control over what contents from a Shape File are displayed inside of GMaps Plugin. Using DBF Key and Shape Data Key properties, dashboard designers can show/hide any shapes from a shapefile while using any sort order from business intelligence dashboard queries.
For example, if the contents of a DBF file are listed as: "AZ, CA, NM, KY" and the dashboard query returns data listed as "CA, NM, AZ". this scenario presents two challenges:
- The sort order from the DBF is different from the actual dashboard data
- Not all regions from the SHP / DBF are required for the required map analysis.
The DBF Key and Shape Data Keys are not required properties. However, if these properties are NOT defined, GMaps Plugin will display all shapes from the shape file and require you to use the data order from the DBF file.
Shape File Order Keys- The Shape File Order Keys are obtained directly from the DBF file and contain a distinct range of values obtained directly from the DBF file. The DBF file contains the labels/ids for each shape within a shape file and can be opened. (learn how to extract DBF data). Upon extracting the DBF data from the shapefile and binding it to the DBF key property, you can change the values but NOT the sort order. If you need to change the data order, you will do so when binding the Shape Data Keys.
Data Order Keys- The Shape Data Key property will contain a distinct range of values used to match the DBF Keys. During dashboard runtime, GMaps Plugin will evaluate the Shape Data Key and search for a matching DBF key. When the Shape Data Key matches the DBF Key, the corresponding shapes will display in GMaps Plugin. Otherwise the shapes are NOT displayed. The Shape Data Keys will define the data order for other GMaps Plugin properties including:Address/Long,Lat
Selector Source Data
Colors (alerts tab)
Alerts Targets (when using % alerts)
- Select the configuration icon from the GMaps Plugin property sheet
- Click on "Shape File URL"
- Bind the DBF Key to a data range obtained from the DBF file.
Note: The actual values within the DBF key can be changed to meet the requirements of your data source so you can modify the DBF key to match what your dashboard queries return. For example, if the DBF file value is "District of Columbia," you can modify the value to "DC"
without impacting the dashboard.
- Bind the Shape Data Key to a data range where you will control what shapes are visible from the .SHP file.
You have downloaded a shapefile connected the URL publish and no shapefile shows up. The following will walk you through a checklist to ensure you have everything configured correctly.
1. Does the shapefile does not appear at alla
a. Make sure the URL to your shapefile is bound to 1 cell
b. Make sure the URL to the shapefile is correct
c. In the shape data options, make sure that shapefile is selected and not CSV or Spreadsheet
2. Is your shape file located on your local computer or on a web server?
This question is critical because there could be some security settings that you need to configure the first time you implement shapefiles or any Xcelsius connectivity for that matter.
Click here to learn how to configure local and remote Flash Player security settings
3. Is your web server IIS?
If you are loading .SHP files onto IIS, you will need to allow the shapefile MIME type because it is not supported out of the box. IIS is the only known web application server requiring extra configuration. Other web servers like Apache or Tomcat do not require similar steps. Click here to learn how to enable SHP MIME support
4. Is the Shapefile Projection Incorrect
If you did NOT obtain your shape data from Centigon Solutions, there is a chance that your shapefile is not configured properly for use in Google Maps. Different GIS data sets are captured for different purposes and saved with a specific projection. In many cases shapefiles obtained for use with GMaps Plugin simply have the wrong projection applied. The good news is that its extremely easy to change this using any GIS software. Our favorite is an open source tool called Quantum GIS. Instructions for downloading and re-projecting your shapefiles with Quantum GIS are available here: Editing Shapefiles
If you require help with this, our knowledgeable support staff is always here to help you: email@example.com
5. Is the Shapefile Size too big?
If your shapefile is large in size (1.5 MB) there is a chance that GMaps Plugin is simply lagging trying to consume and render all of the data points that make up your shapefile. If this is a scenario you are running into, there are several ways to simplify your shapefile. You can learn how to simplify your shapefiles in our editing shapefiles tutorial or contact support
Filtering and Drilling geo-data