In addition to basic datasets we also support Insurance datasets which combine a location and policy dataset together. Insurance datasets are able to be used in the Policy Exposed Limit feature or the Portfolio Composition App in SpatialKey. There are a few additional pieces of information that are required when generating a XML file for an insurance dataset. Note that these are in addition to the items described in the basic XML file generation article.

There are various examples with each section in this document.  In addition to these, we have created sample datasets with accompanying complete XML descriptor files for Download to help get you started.

If you’d rather step through an XML file than read through this entire support article, here are a couple of examples to get you started:

Example XML for dataset with single peril

<?xml version="1.0" encoding="UTF-8"?>
<insuranceImport>
    <linkColumn>
<!---See Link Datasets for details and options--->
        <policyColumn>account id</policyColumn>
        <locationColumn>account id</locationColumn>
    </linkColumn>
    <feature>PolicyExposedLimit</feature>
<!---See Features for details and options--->
    <permissions>
<!---See Dataset Permissions for details and options--->
        <addAllUsers>true</addAllUsers>
        <denyExporting>true</denyExporting>
        <hideFromUI>false</hideFromUI>
    </permissions>
    <notifications>
<!---See Notification Options for details and options--->
        <sendEmail>true</sendEmail>
        <clientNotification>true</clientNotification>
    </notifications>
    <locationDataset>
        <latlon />
<!---See Geocoding Options for details and options, 
if this were an example using actual geocoding, 
you would need to add the <geocode /> section here instead--->
        <type>CSV</type>
<!---See Dataset Information for details and options--->
        <filename>Sample Locations.csv</filename>
        <name>Sample Insurance Locations and Policies</name>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-12-05T16:03:21.476-05:00</preparedDate>
        <expirationDate>2013-12-15T16:09:08.113-05:00</expirationDate>
        <pointThematicLayer>
           <thematicDataset>US_Postal</thematicDataset>
<!---See Thematic Mapping Options for details and options--->
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_Counties</thematicDataset>
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_States</thematicDataset>
        </pointThematicLayer>
        <locationColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>hurricane site limit</name>
            <label>hurricane site limit</label>
            <perilMapping peril="hurricane">limit</perilMapping>
<!---See Peril Specific Metrics for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>year built</name>
            <label>year built</label>
            <type>Date</type>
            <format>Year</format>
        </locationColumn>
        <locationColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>total insured value</name>
            <label>total insured value</label>
            <insuranceMapping>tiv</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>state</name>
            <label>state</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>site id</name>
            <label>site id</label>
            <insuranceMapping>site_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>hurricane site deductible</name>
            <label>hurricane site deductible</label>
            <perilMapping peril="hurricane">deductible</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>location id</name>
            <label>location id</label>
            <insuranceMapping>location_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>city</name>
            <label>city</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>square footage</name>
            <label>square footage</label>
            <type>Integer</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane gross aal</name>
            <label>hurricane gross aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>postal code</name>
            <label>postal code</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane ground up aal</name>
            <label>hurricane ground up aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>longitude</name>
            <label>longitude</label>
            <type>Longitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>latitude</name>
            <label>latitude</label>
            <type>Latitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>occupancy</name>
            <label>occupancy</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>construction</name>
            <label>construction</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>number of stories</name>
            <label>number of stories</label>
            <type>Integer</type>
        </locationColumn>
    </locationDataset>
    <peril>hurricane</peril>
<!---This is a single peril example,
See Define Perils for details and options--->
    <policyDataset>
        <type>CSV</type>        
        <name>Policies</name>
        <filename>Sample Policies.csv</filename>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-11-19T16:24:31.203-05:00</preparedDate>
        <policyColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>limit</name>
            <label>limit</label>
            <insuranceMapping>limit</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>Line of Business</name>
            <label>line of business</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>blanket/minimum deductible</name>
            <label>blanketminimum deductible</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>premium</name>
            <label>premium</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>underwriter</name>
            <label>underwriter</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>attachment point</name>
            <label>attachment point</label>
            <insuranceMapping>attach_point</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
           <name>policy id</name>
            <label>policy id</label>
            <type>Integer</type>
            <insuranceMapping>policy_id</insuranceMapping>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>product line</name>
            <label>product line</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>expiration date</name>
            <label>expiration date</label>
            <type>Date</type>
            <format>Day</format>
        </policyColumn>
        <policyColumn>
            <name>branch</name>
            <label>branch</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>maximum deductible</name>
            <label>maximum deductible</label>
            <insuranceMapping>max_deductible</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>layer amount</name>
            <label>layer amount</label>
            <insuranceMapping>layer</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
    </policyDataset>
</insuranceImport>

Example XML for dataset with multiple perils

<?xml version="1.0" encoding="UTF-8"?>
<insuranceImport>
    <linkColumn>
<!---See Link Datasets for details and options--->
        <policyColumn>account id</policyColumn>
        <locationColumn>account id</locationColumn>
    </linkColumn>
    <feature>PolicyExposedLimit</feature>
<!---See Features for details and options--->
    <permissions>
<!---See Dataset Permissions for details and options--->
        <addAllUsers>true</addAllUsers>
        <denyExporting>true</denyExporting>
        <hideFromUI>false</hideFromUI>
    </permissions>
        <notifications>
<!---See Notification Options for details and options--->
        <sendEmail>true</sendEmail>
        <clientNotification>true</clientNotification>
    </notifications>
    <locationDataset>
        <latlon />
<!---See Geocoding Options for details and options, 
if this were an example using actual geocoding, 
you would need to add the <geocode /> section here instead--->
        <type>CSV</type>
<!---See Dataset Information for details and options--->
        <filename>Sample Locations.csv</filename>
        <name>Sample Insurance Locations and Policies</name>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-12-05T16:03:21.476-05:00</preparedDate>
        <expirationDate>2013-12-15T16:09:08.113-05:00</expirationDate>
        <pointThematicLayer>
<!---See Thematic Mapping Options for details and options--->
            <thematicDataset>US_Postal</thematicDataset>
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_Counties</thematicDataset>
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_States</thematicDataset>
        </pointThematicLayer>
        <locationColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>hurricane site limit</name>
            <label>hurricane site limit</label>
            <perilMapping peril="Hurricane">limit</perilMapping>
<!---See Peril Specific Metrics for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>year built</name>
            <label>year built</label>
            <type>Date</type>
            <format>Year</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake gross aal</name>
            <label>earthquake gross aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>total insured value</name>
            <label>total insured value</label>
            <insuranceMapping>tiv</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake site deductible</name>
            <label>earthquake site deductible</label>
            <perilMapping peril="Earthquake">deductible</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>state</name>
            <label>state</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>site id</name>
            <label>site id</label>
            <insuranceMapping>site_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake risk</name>
            <label>earthquake risk</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane site deductible</name>
            <label>hurricane site deductible</label>
            <perilMapping peril="Hurricane">deductible</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>location id</name>
            <label>location id</label>
            <insuranceMapping>location_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>city</name>
            <label>city</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane risk</name>
            <label>hurricane risk</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>square footage</name>
            <label>square footage</label>
            <type>Integer</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane gross aal</name>
            <label>hurricane gross aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake ground up aal</name>
            <label>earthquake ground up aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>postal code</name>
            <label>postal code</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane ground up aal</name>
            <label>hurricane ground up aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>longitude</name>
            <label>longitude</label>
            <type>Longitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>latitude</name>
            <label>latitude</label>
            <type>Latitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>occupancy</name>
            <label>occupancy</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>earthquake site limit</name>
            <label>earthquake site limit</label>
            <perilMapping peril="Earthquake">limit</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>construction</name>
            <label>construction</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>number of stories</name>
            <label>number of stories</label>
            <type>Integer</type>
        </locationColumn>
    </locationDataset>
    <policyDataset>
        <type>CSV</type>        
        <name>Policies</name>
        <filename>Sample Policies.csv</filename>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-11-19T16:24:31.203-05:00</preparedDate>
        <policyColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>limit</name>
            <label>limit</label>
            <insuranceMapping>limit</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>Line of Business</name>
            <label>line of business</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>blanket/minimum deductible</name>
            <label>blanketminimum deductible</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>premium</name>
            <label>premium</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>underwriter</name>
            <label>underwriter</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>peril</name>
            <label>peril</label>
            <type>String</type>
            <insuranceMapping>peril</insuranceMapping>
<!---This is a multi peril example,
See Define Perils for details and options--->
        </policyColumn>
        <policyColumn>
            <name>attachment point</name>
            <label>attachment point</label>
            <insuranceMapping>attach_point</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
           <name>policy id</name>
            <label>policy id</label>
            <type>Integer</type>
            <insuranceMapping>policy_id</insuranceMapping>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>product line</name>
            <label>product line</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>expiration date</name>
            <label>expiration date</label>
            <type>Date</type>
            <format>Day</format>
        </policyColumn>
        <policyColumn>
            <name>branch</name>
            <label>branch</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>maximum deductible</name>
            <label>maximum deductible</label>
            <insuranceMapping>max_deductible</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>layer amount</name>
            <label>layer amount</label>
            <insuranceMapping>layer</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
    </policyDataset>
</insuranceImport>

Link policy and location files together

Identify a column in the location that links with a column in the policy file.

Example XML

<linkColumn>
    <policyColumn>account id</policyColumn>
    <locationColumn>account id</locationColumn>
</linkColumn>

Define feature 

Currently supported features:

  • Policy Exposed Limit
  • Portfolio Composition

You can either or both of these for a given insurance dataset.

Example XML

<feature>PolicyExposedLimit</feature>
<feature>PortfolioComposition</feature>

Define perils

Defining a peril or perils is a necessary step for insurance datasets. If your policy file covers a single peril, you can define the specific peril name in the XML file. If your policy files covers multiple perils, you must specify a column in the policy dataset that defines the peril for each policy in the file.

Single peril XML example

<peril>hurricane</peril>

Multi peril XML example

<policyColumn>
    <name>peril</name>
    <label>peril</label>
    <type>String</type>
    <insuranceMapping>peril</insuranceMapping>
</policyColumn>

Peril specific metrics

Define peril specific metrics like limits, deductibles and AALs in the XML file.  To do this, you need to know your specified peril name (single peril) or the peril names in the peril column (multiple perils). For each peril specific metric, define which peril is represents.

Example XML

<locationColumn>
    <name>earthquake site deductible</name>
    <label>earthquake site deductible</label>
    <perilMapping peril="Earthquake">deductible</perilMapping>
    <type>Currency</type>
    <format>USD</format>
</locationColumn>
<locationColumn>
    <name>hurricane site deductible</name>
    <label>hurricane site deductible</label>
    <perilMapping peril="Hurricane">deductible</perilMapping>
    <type>Currency</type>
    <format>USD</format>
</locationColumn>

Insurance properties

The table below describes a various insurance properties that can be defined in a dataset, which file they are expected in, and whether the property is required or optional for the Policy Exposed Limit feature or portfolio Composition app.

File Insurance Property Policy Exposed Limit
(Learn about this feature)
Portfolio Composition
(Learn about this feature)
location location_id required required
tiv required required
site_id optional
occupancy optional
year_built optional
square_footage optional
construction optional
num_stories optional
limit  optional **
deductible  optional **
gross_aal optional **
gu_aal optional **
custom_1 optional
custom_2 optional
policy policy_id required required
limit required optional
layer required optional
attach_point required optional
blanket_min_deductible optional optional
peril optional * required
max_deductible optional optional
line_of_business required
premium optional
product_line optional
branch optional
underwriter optional
exp_date optional
custom_1 optional
custom_2 optional

* If a peril column is not specified, then a peril value needs to be specified in the XML configuration for a single peril. If multiple perils are in the policy data then this column is required. See peril definition section for more details.

** Ground Up AAL and Gross AAL are specified per peril. If multiple perils are in the policy file, both Ground Up and Gross AALs can be specified for each peril. See peril specific metrics section for more details.

** Site limits and site deductibles are specified per peril. If multiple perils are in the policy file, site limits and site deductibles can be specified for each peril.  See peril specific metrics section for more details.

Example XML

<locationColumn>
    <name>Total Insured Value</name>
    <label>Total Insured Value</label>
    <insuranceMapping>tiv</insuranceMapping>
    <type>Currency</type>
    <format>USD</format>
</locationColumn>

Download Sample Datasets and XML Descriptor Files

We have walked through each additional piece of the XML file when importing an insurance dataset, but how do all of these pieces come together in the final XML Descriptor File?

Example XML for dataset with single peril

<?xml version="1.0" encoding="UTF-8"?>
<insuranceImport>
    <linkColumn>
<!---See Link Datasets for details and options--->
        <policyColumn>account id</policyColumn>
        <locationColumn>account id</locationColumn>
    </linkColumn>
    <feature>PolicyExposedLimit</feature>
<!---See Features for details and options--->
    <permissions>
<!---See Dataset Permissions for details and options--->
        <addAllUsers>true</addAllUsers>
        <denyExporting>true</denyExporting>
        <hideFromUI>false</hideFromUI>
    </permissions>
    <notifications>
<!---See Notification Options for details and options--->
        <sendEmail>true</sendEmail>
        <clientNotification>true</clientNotification>
    </notifications>
    <locationDataset>
        <latlon />
<!---See Geocoding Options for details and options, 
if this were an example using actual geocoding, 
you would need to add the <geocode /> section here instead--->
        <type>CSV</type>
<!---See Dataset Information for details and options--->
        <filename>Sample Locations.csv</filename>
        <name>Sample Insurance Locations and Policies</name>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-12-05T16:03:21.476-05:00</preparedDate>
        <expirationDate>2013-12-15T16:09:08.113-05:00</expirationDate>
        <pointThematicLayer>
           <thematicDataset>US_Postal</thematicDataset>
<!---See Thematic Mapping Options for details and options--->
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_Counties</thematicDataset>
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_States</thematicDataset>
        </pointThematicLayer>
        <locationColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>hurricane site limit</name>
            <label>hurricane site limit</label>
            <perilMapping peril="hurricane">limit</perilMapping>
<!---See Peril Specific Metrics for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>year built</name>
            <label>year built</label>
            <type>Date</type>
            <format>Year</format>
        </locationColumn>
        <locationColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>total insured value</name>
            <label>total insured value</label>
            <insuranceMapping>tiv</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>state</name>
            <label>state</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>site id</name>
            <label>site id</label>
            <insuranceMapping>site_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>hurricane site deductible</name>
            <label>hurricane site deductible</label>
            <perilMapping peril="hurricane">deductible</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>location id</name>
            <label>location id</label>
            <insuranceMapping>location_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>city</name>
            <label>city</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>square footage</name>
            <label>square footage</label>
            <type>Integer</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane gross aal</name>
            <label>hurricane gross aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>postal code</name>
            <label>postal code</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane ground up aal</name>
            <label>hurricane ground up aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>longitude</name>
            <label>longitude</label>
            <type>Longitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>latitude</name>
            <label>latitude</label>
            <type>Latitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>occupancy</name>
            <label>occupancy</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>construction</name>
            <label>construction</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>number of stories</name>
            <label>number of stories</label>
            <type>Integer</type>
        </locationColumn>
    </locationDataset>
    <peril>hurricane</peril>
<!---This is a single peril example,
See Define Perils for details and options--->
    <policyDataset>
        <type>CSV</type>        
        <name>Policies</name>
        <filename>Sample Policies.csv</filename>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-11-19T16:24:31.203-05:00</preparedDate>
        <policyColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>limit</name>
            <label>limit</label>
            <insuranceMapping>limit</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>Line of Business</name>
            <label>line of business</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>blanket/minimum deductible</name>
            <label>blanketminimum deductible</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>premium</name>
            <label>premium</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>underwriter</name>
            <label>underwriter</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>attachment point</name>
            <label>attachment point</label>
            <insuranceMapping>attach_point</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
           <name>policy id</name>
            <label>policy id</label>
            <type>Integer</type>
            <insuranceMapping>policy_id</insuranceMapping>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>product line</name>
            <label>product line</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>expiration date</name>
            <label>expiration date</label>
            <type>Date</type>
            <format>Day</format>
        </policyColumn>
        <policyColumn>
            <name>branch</name>
            <label>branch</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>maximum deductible</name>
            <label>maximum deductible</label>
            <insuranceMapping>max_deductible</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>layer amount</name>
            <label>layer amount</label>
            <insuranceMapping>layer</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
    </policyDataset>
</insuranceImport>

Example XML for dataset with multiple perils

<?xml version="1.0" encoding="UTF-8"?>
<insuranceImport>
    <linkColumn>
<!---See Link Datasets for details and options--->
        <policyColumn>account id</policyColumn>
        <locationColumn>account id</locationColumn>
    </linkColumn>
    <feature>PolicyExposedLimit</feature>
<!---See Features for details and options--->
    <permissions>
<!---See Dataset Permissions for details and options--->
        <addAllUsers>true</addAllUsers>
        <denyExporting>true</denyExporting>
        <hideFromUI>false</hideFromUI>
    </permissions>
        <notifications>
<!---See Notification Options for details and options--->
        <sendEmail>true</sendEmail>
        <clientNotification>true</clientNotification>
    </notifications>
    <locationDataset>
        <latlon />
<!---See Geocoding Options for details and options, 
if this were an example using actual geocoding, 
you would need to add the <geocode /> section here instead--->
        <type>CSV</type>
<!---See Dataset Information for details and options--->
        <filename>Sample Locations.csv</filename>
        <name>Sample Insurance Locations and Policies</name>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-12-05T16:03:21.476-05:00</preparedDate>
        <expirationDate>2013-12-15T16:09:08.113-05:00</expirationDate>
        <pointThematicLayer>
<!---See Thematic Mapping Options for details and options--->
            <thematicDataset>US_Postal</thematicDataset>
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_Counties</thematicDataset>
        </pointThematicLayer>
        <pointThematicLayer>
            <thematicDataset>US_States</thematicDataset>
        </pointThematicLayer>
        <locationColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>hurricane site limit</name>
            <label>hurricane site limit</label>
            <perilMapping peril="Hurricane">limit</perilMapping>
<!---See Peril Specific Metrics for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>year built</name>
            <label>year built</label>
            <type>Date</type>
            <format>Year</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake gross aal</name>
            <label>earthquake gross aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>total insured value</name>
            <label>total insured value</label>
            <insuranceMapping>tiv</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake site deductible</name>
            <label>earthquake site deductible</label>
            <perilMapping peril="Earthquake">deductible</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>state</name>
            <label>state</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>site id</name>
            <label>site id</label>
            <insuranceMapping>site_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake risk</name>
            <label>earthquake risk</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane site deductible</name>
            <label>hurricane site deductible</label>
            <perilMapping peril="Hurricane">deductible</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>location id</name>
            <label>location id</label>
            <insuranceMapping>location_id</insuranceMapping>
            <type>Integer</type>
            <format>ID</format>
        </locationColumn>
        <locationColumn>
            <name>city</name>
            <label>city</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane risk</name>
            <label>hurricane risk</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>square footage</name>
            <label>square footage</label>
            <type>Integer</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane gross aal</name>
            <label>hurricane gross aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>earthquake ground up aal</name>
            <label>earthquake ground up aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>postal code</name>
            <label>postal code</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>hurricane ground up aal</name>
            <label>hurricane ground up aal</label>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>longitude</name>
            <label>longitude</label>
            <type>Longitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>latitude</name>
            <label>latitude</label>
            <type>Latitude</type>
<!---This type is required because of the selected geocode method,
see Geocoding Options for details and options--->
        </locationColumn>
        <locationColumn>
            <name>occupancy</name>
            <label>occupancy</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>earthquake site limit</name>
            <label>earthquake site limit</label>
            <perilMapping peril="Earthquake">limit</perilMapping>
            <type>Currency</type>
            <format>USD</format>
        </locationColumn>
        <locationColumn>
            <name>construction</name>
            <label>construction</label>
            <type>String</type>
        </locationColumn>
        <locationColumn>
            <name>number of stories</name>
            <label>number of stories</label>
            <type>Integer</type>
        </locationColumn>
    </locationDataset>
    <policyDataset>
        <type>CSV</type>        
        <name>Policies</name>
        <filename>Sample Policies.csv</filename>
        <preparedWith>Spatialkey API</preparedWith>
        <preparedDate>2013-11-19T16:24:31.203-05:00</preparedDate>
        <policyColumn>
<!---See Column Data Types and Formats for details and options--->
            <name>limit</name>
            <label>limit</label>
            <insuranceMapping>limit</insuranceMapping>
<!---See Insurance Properties for details and options--->
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>Line of Business</name>
            <label>line of business</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>account id</name>
            <label>account id</label>
            <type>Integer</type>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>blanket/minimum deductible</name>
            <label>blanketminimum deductible</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>premium</name>
            <label>premium</label>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>underwriter</name>
            <label>underwriter</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>peril</name>
            <label>peril</label>
            <type>String</type>
            <insuranceMapping>peril</insuranceMapping>
<!---This is a multi peril example,
See Define Perils for details and options--->
        </policyColumn>
        <policyColumn>
            <name>attachment point</name>
            <label>attachment point</label>
            <insuranceMapping>attach_point</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
           <name>policy id</name>
            <label>policy id</label>
            <type>Integer</type>
            <insuranceMapping>policy_id</insuranceMapping>
            <format>ID</format>
        </policyColumn>
        <policyColumn>
            <name>product line</name>
            <label>product line</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>expiration date</name>
            <label>expiration date</label>
            <type>Date</type>
            <format>Day</format>
        </policyColumn>
        <policyColumn>
            <name>branch</name>
            <label>branch</label>
            <type>String</type>
        </policyColumn>
        <policyColumn>
            <name>maximum deductible</name>
            <label>maximum deductible</label>
            <insuranceMapping>max_deductible</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
        <policyColumn>
            <name>layer amount</name>
            <label>layer amount</label>
            <insuranceMapping>layer</insuranceMapping>
            <type>Currency</type>
            <format>USD</format>
        </policyColumn>
    </policyDataset>
</insuranceImport>

Check out these downloadable examples

Examples coming soon…