Loading Esri shapefiles in Qlik GeoAnalytics

    It's common that customers keep geodata in shapefiles, here's how to load them in to QlikView and Qlik Sense using Qlik GeoAnalytics.

    Step-by-step guide

    First place the shapefile in zip file. In this example I'm using the Congressional Districts from US Census. A shapefile is actually several files, at least .shp file and .dbf file. Place the zip file on a webserver (Dropbox is handy).

    1. Open the connector and choose "Simplify" (Load can also be used but it's good practice to simplify especially if the shapefile is large (>2MB).
    2. Choose "Auto" for resolution.
    3. Fill in the url: https://www2.census.gov/geo/tiger/TIGER2016/CD/tl_2016_us_cd115.zip or for local files file:///C:/ (Plus required)
    4. A key field is handy but not mandatory, fill in GEOID in this example.
    5. Fill in the CRS: EPSG:4269  (This shapefile is in coordinate system NAD 83, use internet search to find the EPSG code).
    6. Click next, the operation return two tables: one table with index and the simplified geometry and second table with original non-simplified shapes and attributes. Uncheck "Geometry" in the second table if you just want the attributes.
    7. Click Insert script and Load Data

     

     

    URL
    The url must be with direct access to the file. Test by opening the url in a browser, the download should start immediately. Tip, use "dl" instead "www" to get direct access of Dropbox files.

     

    Local files
    For local zip files in a local file system, QGA Plus is required and use the url syntax file:///C:/Users/bps/Desktop/test.zip. Tip, drag and drop a folder to the browser to get the url.

     

    CRS
    A tip to find out the coordinate system is to take look inside the .prj file if such exist. Tip, use a search engine for a key word to find the EPSG code.

     

    See below for example apps for Qlik Sens and QlikView as well as the shapefile example data.

    Please note that when running the QlikView example you need to insert a connection string with the connector.