Table of Contents

Structures Sample

Structure import samples are available in the following file formats:

 

Microsoft Excel Worksheet

Account ID Account Number Account Name Structure ID Structure Type Ownership Type Insurance Responsibility Structure Name Site Identifier Date Added Date Dropped Address Address 2 Address 3 City State Zip County Block Number Tax Lot Number Tax Area Type Construction Category Tax Area ISO Construction Source Floor Area Year Built Stories Stories Height Basement Type Basement Height Stories Above Ground Stories Below Ground Sq Ft Above Ground Sq Ft Below Ground Percent Finished Below Ground Construction Component Construction Type Percent of Total Material Type Construction Component - Other Construction Type - Other Occupant Contact ID Occupant Company Name Occupant First Name Occupant Last Name Occupant Address Occupant Address 2 Occupant Address 3 Occupant City Occupant State Occupant Zip Occupant Phone Occupant E-mail Occupant Fax Occupancy Type Percent Occupied Percent Sprinkled Percent Manual Fire Alarm Percent Automatic Fire Detection Percent Security Detection Alarm System Automatic External Defibrillator Fire Detection System Fire Suppression System Security Alarm Security Camera Sprinkler System Flood Zone Earthquake Zone Wind Zone Value Effective Date Value Source Contents Value Insured Value My Company Id My Company Question
1   DIV-A Division A   Single Family Home OWNED - USED BY OWNER   My House   9/12/2021   123 State Street         19063   100 200 Square Feet 1-Frame 2200   2200 1996 2 20 Finished 9 2 1 1800 400 50 Exterior Walls 90 Wood Flooring Type Marble     John Doe       Media PA 19063       Leased - Inside the Organization 100         Central No None Yes Active Yes None A18     04/12/2012 Appraisal 172959 325000 S01523518A Yes
2 12176   Maintenance   Shed LEASED - OUTSIDE THE ORGANIZATION   Lawn Maintenance Shed   09/01/2018   15 Front Street         19101               600 2018 1 10     1 0 600 0 0             Greenlawn LLC.           Philadelphia PA 19101       Leased - Outside the Organization 100               No   Yes         09/01/2018     25500    
3                                                                                                                                                      
 

JSON File

{
  "structures": [
    {
      "accountId": "",
      "accountNumber": "DIV-A",
      "accountName": "Division A",
      "structureId": "",
      "structureType": "Single Family Home",
      "ownershipType": "OWNED - USED BY OWNER",
      "insuranceResponsibility": "",
      "structureName": "My House",
      "siteIdentifier": "",
      "dateAdded": "9/12/2021",
      "dateDropped": "",
      "address": "123 State Street",
      "address2": "",
      "address3": "",
      "city": "",
      "state": "",
      "zip": "19063",
      "county": "",
      "blockNumber": "100",
      "taxLotNumber": "200",
      "taxAreaType": "Square Feet",
      "taxArea": "2200",
      "constructionCategory": "1-Frame",
      "isoConstructionSource": "",
      "floorArea": "2200",
      "yearBuilt": "1996",
      "stories": "2",
      "storiesHeight": "20",
      "basementType": "Finished",
      "basementHeight": "9",
      "storiesAboveGround": "2",
      "storiesBelowGround": "1",
      "sqFtAboveGround": "1800",
      "sqFtBelowGround": "400",
      "percentFinishedBelowGround": "50",
      "constructionTypes": [
        {
          "constructionComponent": "Exterior Walls",
          "constructionTypePercentofTotal": "90",
          "materialType": "Wood"
        }
      ],
      "constructionTypesOther": [
        {
          "constructionComponentOther": "Flooring Type",
          "constructionTypeOther": "Marble"
        }
      ],
      "occupancies": [
        {
          "occupantContactId": "",
          "occupantCompanyName": "",
          "occupantFirstName": "John",
          "occupantLastName": "Doe",
          "occupantAddress": "",
          "occupantAddress2": "",
          "occupantAddress3": "",
          "occupantCity": "Media",
          "occupantState": "PA",
          "occupantZip": "19063",
          "occupantPhone": "",
          "occupantEmail": "",
          "occupantFax": "",
          "occupancyType": "Leased - Inside the Organization",
          "percentOccupied": "100"
        }
      ],
      "protections": [
        {
          "percentSprinkled": "",
          "percentManualFireAlarm": "",
          "percentAutomaticFireDetection": "",
          "percentSecurityDetection": "",
          "alarmSystem": "Central",
          "automaticExternalDefibrillator": "No",
          "fireDetectionSystem": "None",
          "fireSuppressionSystem": "Yes",
          "securityAlarm": "Active",
          "securityCamera": "Yes",
          "sprinklerSystem": "None"
        }
      ],
      "floodZone": "A18",
      "earthquakeZone": "",
      "windZone": "",
      "values": [
        {
          "valuationType": "Insured Value",
          "valueAmount": "325000",
          "valueEffectiveDate": "04/12/2012",
          "valueSource": "Appraisal"
        },
        {
          "valuationType": "Contents Value",
          "valueAmount": "172959",
          "valueEffectiveDate": "01/01/2021",
          "valueSource": ""
        }
      ],
      "userDefinedFields": [
        {
          "fieldName": "My Company Id",
          "fieldValue": "S01523518A"
        },
        {
          "fieldName": "My Company Question",
          "fieldValue": "Yes"
        }
      ]
    },
    {
      "accountId": "12176",
      "accountNumber": "",
      "accountName": "Maintenance",
      "structureId": "",
      "structureType": "Shed",
      "ownershipType": "LEASED - OUTSIDE THE ORGANIZATION",
      "insuranceResponsibility": "",
      "structureName": "Lawn Maintenance Shed",
      "siteIdentifier": "",
      "dateAdded": "09/01/2018",
      "dateDropped": "",
      "address": "15 Front Street",
      "address2": "",
      "address3": "",
      "city": "",
      "state": "",
      "zip": "19101",
      "county": "",
      "blockNumber": "",
      "taxLotNumber": "",
      "taxAreaType": "",
      "taxArea": "",
      "constructionCategory": "",
      "isoConstructionSource": "",
      "floorArea": "600",
      "yearBuilt": "2018",
      "stories": "1",
      "storiesHeight": "10",
      "basementType": "",
      "basementHeight": "",
      "storiesAboveGround": "1",
      "storiesBelowGround": "0",
      "sqFtAboveGround": "600",
      "sqFtBelowGround": "0",
      "percentFinishedBelowGround": "0",
      "constructionTypes": [
        {
          "constructionComponent": "",
          "constructionTypePercentofTotal": "",
          "materialType": ""
        }
      ],
      "constructionTypesOther": [
        {
          "constructionComponentOther": "",
          "constructionTypeOther": ""
        }
      ],
      "occupancies": [
        {
          "occupantContactId": "",
          "occupantCompanyName": "Greenlawn LLC.",
          "occupantFirstName": "",
          "occupantLastName": "",
          "occupantAddress": "",
          "occupantAddress2": "",
          "occupantAddress3": "",
          "occupantCity": "Philadelphia",
          "occupantState": "PA",
          "occupantZip": "19101",
          "occupantPhone": "",
          "occupantEmail": "",
          "occupantFax": "",
          "occupancyType": "Leased - Outside the Organization",
          "percentOccupied": "100"
        }
      ],
      "protections": [
        {
          "percentSprinkled": "",
          "percentManualFireAlarm": "",
          "percentAutomaticFireDetection": "",
          "percentSecurityDetection": "",
          "alarmSystem": "",
          "automaticExternalDefibrillator": "",
          "fireDetectionSystem": "",
          "fireSuppressionSystem": "No",
          "securityAlarm": "",
          "securityCamera": "Yes",
          "sprinklerSystem": ""
        }
      ],
      "floodZone": "",
      "earthquakeZone": "",
      "windZone": "",
      "values": [
        {
          "valuationType": "Insured Value",
          "valueAmount": "25500",
          "valueEffectiveDate": "09/01/2018",
          "valueSource": ""
        }
      ],
      "userDefinedFields": []
    }
  ]
}
 

XML Document

<?xml version="1.0"?>
<import>
  <structure>
    <accountId></accountId>
    <accountNumber>DIV-A</accountNumber>
    <accountName>Division A</accountName>
    <structureId></structureId>
    <structureType>Single Family Home</structureType>
    <ownershipType>OWNED - USED BY OWNER</ownershipType>
    <insuranceResponsibility></insuranceResponsibility>
    <structureName>My House</structureName>
    <siteIdentifier></siteIdentifier>
    <dateAdded>9/12/2021</dateAdded>
    <dateDropped></dateDropped>
    <address>123 State Street</address>
    <address2></address2>
    <address3></address3>
    <city></city>
    <state></state>
    <zip>19063</zip>
    <county></county>
    <blockNumber>100</blockNumber>
    <taxLotNumber>200</taxLotNumber>
    <taxAreaType>Square Feet</taxAreaType>
    <taxArea>2200</taxArea>
    <constructionCategory>1-Frame</constructionCategory>
    <isoConstructionSource></isoConstructionSource>
    <floorArea>2200</floorArea>
    <yearBuilt>1996</yearBuilt>
    <stories>2</stories>
    <storiesHeight>20</storiesHeight>
    <basementType>Finished</basementType>
    <basementHeight>9</basementHeight>
    <storiesAboveGround>2</storiesAboveGround>
    <storiesBelowGround>1</storiesBelowGround>
    <sqFtAboveGround>1800</sqFtAboveGround>
    <sqFtBelowGround>400</sqFtBelowGround>
    <percentFinishedBelowGround>50</percentFinishedBelowGround>
    <constructionType>
      <constructionComponent>Exterior Walls</constructionComponent>
      <constructionTypePercentofTotal>90</constructionTypePercentofTotal>
      <materialType>Wood</materialType>
    </constructionType>
    <constructionTypesOther>
      <constructionComponentOther>Flooring Type</constructionComponentOther>
      <constructionTypeOther>Marble</constructionTypeOther>
    </constructionTypesOther>
    <occupancy>
      <occupantContactId></occupantContactId>
      <occupantCompanyName></occupantCompanyName>
      <occupantFirstName>John</occupantFirstName>
      <occupantLastName>Doe</occupantLastName>
      <occupantAddress></occupantAddress>
      <occupantAddress2></occupantAddress2>
      <occupantAddress3></occupantAddress3>
      <occupantCity>Media</occupantCity>
      <occupantState>PA</occupantState>
      <occupantZip>19063</occupantZip>
      <occupantPhone></occupantPhone>
      <occupantEmail></occupantEmail>
      <occupantFax></occupantFax>
      <occupancyType>Leased - Inside the Organization</occupancyType>
      <percentOccupied>100</percentOccupied>
    </occupancy>
    <protection>
      <percentSprinkled></percentSprinkled>
      <percentManualFireAlarm></percentManualFireAlarm>
      <percentAutomaticFireDetection></percentAutomaticFireDetection>
      <percentSecurityDetection></percentSecurityDetection>
      <alarmSystem>Central</alarmSystem>
      <automaticExternalDefibrillator>No</automaticExternalDefibrillator>
      <fireDetectionSystem>None</fireDetectionSystem>
      <fireSuppressionSystem>Yes</fireSuppressionSystem>
      <securityAlarm>Active</securityAlarm>
      <securityCamera>Yes</securityCamera>
      <sprinklerSystem>None</sprinklerSystem>
    </protection>
    <floodZone>A18</floodZone>
    <earthquakeZone></earthquakeZone>
    <windZone></windZone>
    <value>
      <valuationType>Insured Value</valuationType>
      <valueAmount>325000</valueAmount>
      <valueEffectiveDate>04/12/2012</valueEffectiveDate>
      <valueSource>Appraisal</valueSource>
    </value>
    <value>
      <valuationType>Contents Value</valuationType>
      <valueAmount>172959</valueAmount>
      <valueEffectiveDate>01/01/2021</valueEffectiveDate>
      <valueSource></valueSource>
    </value>
    <userDefinedField>
      <fieldName>My Company Id</fieldName>
      <fieldValue>S01523518A</fieldValue>
    </userDefinedField>
    <userDefinedField>
      <fieldName>My Company Question</fieldName>
      <fieldValue>Yes</fieldValue>
    </userDefinedField>
  </structure>
  <structure>
    <accountId>12176</accountId>
    <accountNumber></accountNumber>
    <accountName>Maintenance</accountName>
    <structureId></structureId>
    <structureType>Shed</structureType>
    <ownershipType>LEASED - OUTSIDE THE ORGANIZATION</ownershipType>
    <insuranceResponsibility></insuranceResponsibility>
    <structureName>Lawn Maintenance Shed</structureName>
    <siteIdentifier></siteIdentifier>
    <dateAdded>09/01/2018</dateAdded>
    <dateDropped></dateDropped>
    <address>15 Front Street</address>
    <address2></address2>
    <address3></address3>
    <city></city>
    <state></state>
    <zip>19101</zip>
    <county></county>
    <blockNumber></blockNumber>
    <taxLotNumber></taxLotNumber>
    <taxAreaType></taxAreaType>
    <taxArea></taxArea>
    <constructionCategory></constructionCategory>
    <isoConstructionSource></isoConstructionSource>
    <floorArea>600</floorArea>
    <yearBuilt>2018</yearBuilt>
    <stories>1</stories>
    <storiesHeight>10</storiesHeight>
    <basementType></basementType>
    <basementHeight></basementHeight>
    <storiesAboveGround>1</storiesAboveGround>
    <storiesBelowGround>0</storiesBelowGround>
    <sqFtAboveGround>600</sqFtAboveGround>
    <sqFtBelowGround>0</sqFtBelowGround>
    <percentFinishedBelowGround>0</percentFinishedBelowGround>
    <constructionType>
      <constructionComponent></constructionComponent>
      <constructionTypePercentofTotal></constructionTypePercentofTotal>
      <materialType></materialType>
    </constructionType>
    <constructionTypesOther>
      <constructionComponentOther></constructionComponentOther>
      <constructionTypeOther></constructionTypeOther>
    </constructionTypesOther>
    <occupancy>
      <occupantContactId></occupantContactId>
      <occupantCompanyName>Greenlawn LLC.</occupantCompanyName>
      <occupantFirstName></occupantFirstName>
      <occupantLastName></occupantLastName>
      <occupantAddress></occupantAddress>
      <occupantAddress2></occupantAddress2>
      <occupantAddress3></occupantAddress3>
      <occupantCity>Philadelphia</occupantCity>
      <occupantState>PA</occupantState>
      <occupantZip>19101</occupantZip>
      <occupantPhone></occupantPhone>
      <occupantEmail></occupantEmail>
      <occupantFax></occupantFax>
      <occupancyType>Leased - Outside the Organization</occupancyType>
      <percentOccupied>100</percentOccupied>
    </occupancy>
    <protection>
      <percentSprinkled></percentSprinkled>
      <percentManualFireAlarm></percentManualFireAlarm>
      <percentAutomaticFireDetection></percentAutomaticFireDetection>
      <percentSecurityDetection></percentSecurityDetection>
      <alarmSystem></alarmSystem>
      <automaticExternalDefibrillator></automaticExternalDefibrillator>
      <fireDetectionSystem></fireDetectionSystem>
      <fireSuppressionSystem>No</fireSuppressionSystem>
      <securityAlarm></securityAlarm>
      <securityCamera>Yes</securityCamera>
      <sprinklerSystem></sprinklerSystem>
    </protection>
    <floodZone></floodZone>
    <earthquakeZone></earthquakeZone>
    <windZone></windZone>
    <value>
      <valuationType>Insured Value</valuationType>
      <valueAmount>25500</valueAmount>
      <valueEffectiveDate>09/01/2018</valueEffectiveDate>
      <valueSource></valueSource>
    </value>
  </structure>
</import>