{
 "currentVersion": 10.71,
 "id": 107,
 "name": "PermitHistory",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "contractorname",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "objectid",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "assetkey",
   "type": "esriFieldTypeString",
   "alias": "Asset Key",
   "length": 20,
   "domain": null
  },
  {
   "name": "workorderid",
   "type": "esriFieldTypeString",
   "alias": "Workorder Key",
   "length": 50,
   "domain": null
  },
  {
   "name": "attachmentid1",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID1",
   "domain": null
  },
  {
   "name": "attachmentid2",
   "type": "esriFieldTypeInteger",
   "alias": "AttachmentID2",
   "domain": null
  },
  {
   "name": "workdate",
   "type": "esriFieldTypeDate",
   "alias": "WorkDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "workby",
   "type": "esriFieldTypeString",
   "alias": "WorkBy",
   "length": 50,
   "domain": null
  },
  {
   "name": "worktype",
   "type": "esriFieldTypeString",
   "alias": "worktype",
   "length": 50,
   "domain": null
  },
  {
   "name": "comments",
   "type": "esriFieldTypeString",
   "alias": "comments",
   "length": 1000,
   "domain": null
  },
  {
   "name": "permittype",
   "type": "esriFieldTypeString",
   "alias": "permittype",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "PermitType",
    "description": "",
    "codedValues": [
     {
      "name": "Connection",
      "code": "Connection"
     },
     {
      "name": "Disconnection",
      "code": "Disconnection"
     },
     {
      "name": "Repair",
      "code": "Repair"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "permitnum",
   "type": "esriFieldTypeString",
   "alias": "permitnum",
   "length": 20,
   "domain": null
  },
  {
   "name": "bldgtype",
   "type": "esriFieldTypeString",
   "alias": "bldgtype",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "sedaBldgType",
    "description": "",
    "codedValues": [
     {
      "name": "Commercial",
      "code": "Commercial"
     },
     {
      "name": "Industrial",
      "code": "Industrial"
     },
     {
      "name": "School",
      "code": "School"
     },
     {
      "name": "Place of Worship",
      "code": "Place of Worship"
     },
     {
      "name": "Hospital",
      "code": "Hospital"
     },
     {
      "name": "Residential",
      "code": "Residential"
     },
     {
      "name": "Single Family",
      "code": "Single Family"
     },
     {
      "name": "Condo/Apts",
      "code": "Condo/Apts"
     },
     {
      "name": "Multi Family",
      "code": "Multi Family"
     },
     {
      "name": "Restaurant (FOG)",
      "code": "Restaurant (FOG)"
     },
     {
      "name": "Bar/Cafe",
      "code": "Bar/Cafe"
     },
     {
      "name": "Recreational",
      "code": "Recreational"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "numberunits",
   "type": "esriFieldTypeSmallInteger",
   "alias": "numberunits",
   "domain": null
  },
  {
   "name": "jobtype",
   "type": "esriFieldTypeString",
   "alias": "jobtype",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "sedaJobType",
    "description": "",
    "codedValues": [
     {
      "name": "New Construction",
      "code": "New Construction"
     },
     {
      "name": "Addition",
      "code": "Addition"
     },
     {
      "name": "Repairs Only",
      "code": "Repairs Only"
     },
     {
      "name": "Remodel",
      "code": "Remodel"
     },
     {
      "name": "Disconnection",
      "code": "Disconnection"
     },
     {
      "name": "Other",
      "code": "Other"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "address",
   "type": "esriFieldTypeString",
   "alias": "address",
   "length": 150,
   "domain": null
  },
  {
   "name": "hub_used",
   "type": "esriFieldTypeString",
   "alias": "hub_used",
   "length": 50,
   "domain": null
  },
  {
   "name": "sewermap",
   "type": "esriFieldTypeDouble",
   "alias": "sewermap",
   "domain": null
  },
  {
   "name": "contractorname",
   "type": "esriFieldTypeString",
   "alias": "contractorname",
   "length": 100,
   "domain": null
  },
  {
   "name": "contractoraddr",
   "type": "esriFieldTypeString",
   "alias": "contractoraddr",
   "length": 150,
   "domain": null
  },
  {
   "name": "contractorphone",
   "type": "esriFieldTypeString",
   "alias": "contractorphone",
   "length": 20,
   "domain": null
  },
  {
   "name": "installer",
   "type": "esriFieldTypeString",
   "alias": "installer",
   "length": 100,
   "domain": null
  },
  {
   "name": "feepaid",
   "type": "esriFieldTypeString",
   "alias": "feepaid",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "sedaYesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "sketchadded",
   "type": "esriFieldTypeString",
   "alias": "sketchadded",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "sedaYesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "connectfeepaid",
   "type": "esriFieldTypeString",
   "alias": "connectfeepaid",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "sedaYesNo",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "connected",
   "type": "esriFieldTypeDate",
   "alias": "connected",
   "length": 8,
   "domain": null
  },
  {
   "name": "asbuiltrecvd",
   "type": "esriFieldTypeDate",
   "alias": "asbuiltrecvd",
   "length": 8,
   "domain": null
  },
  {
   "name": "occ_cert",
   "type": "esriFieldTypeDate",
   "alias": "occ_cert",
   "length": 8,
   "domain": null
  },
  {
   "name": "repairtype",
   "type": "esriFieldTypeString",
   "alias": "repairtype",
   "length": 30,
   "domain": {
    "type": "codedValue",
    "name": "sedaRepairType",
    "description": "",
    "codedValues": [
     {
      "name": "Corrective Maintenance",
      "code": "Corrective Maintenance"
     },
     {
      "name": "Preventative Maintenance",
      "code": "Preventative Maintenance"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "wocomments",
   "type": "esriFieldTypeString",
   "alias": "wocomments",
   "length": 1073741822,
   "domain": null
  },
  {
   "name": "wodescription",
   "type": "esriFieldTypeString",
   "alias": "wodescription",
   "length": 255,
   "domain": null
  },
  {
   "name": "attachmentid3",
   "type": "esriFieldTypeInteger",
   "alias": "attachmentid3",
   "domain": null
  },
  {
   "name": "Work_Origin",
   "type": "esriFieldTypeString",
   "alias": "Work_Origin",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "WorkOrgin",
    "description": "Building Inspection (good)",
    "codedValues": [
     {
      "name": "Emergency",
      "code": "Emergency"
     },
     {
      "name": "Long-Term Maintenance Plan",
      "code": "Long-Term Maintenance Plan"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Inspection_Type",
   "type": "esriFieldTypeString",
   "alias": "Inspection_Type`",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Inspection_Type",
    "description": "Building Inspection\n",
    "codedValues": [
     {
      "name": "Internal",
      "code": "Internal"
     },
     {
      "name": "External",
      "code": "External"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Street_Name",
   "type": "esriFieldTypeString",
   "alias": "Street_Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "Street_No",
   "type": "esriFieldTypeString",
   "alias": "Street_No",
   "length": 50,
   "domain": null
  },
  {
   "name": "Building_Type",
   "type": "esriFieldTypeString",
   "alias": "Building_Type",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Building_Type",
    "description": "Building Inspection",
    "codedValues": [
     {
      "name": "Single Family",
      "code": "Single Family"
     },
     {
      "name": "Multi Family",
      "code": "Multi Family"
     },
     {
      "name": "Apartment",
      "code": "Apartment"
     },
     {
      "name": "Commercial",
      "code": "Commercial"
     },
     {
      "name": "Industrial",
      "code": "Industrial"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Sewer_SubArea",
   "type": "esriFieldTypeString",
   "alias": "Sewer_SubArea",
   "length": 50,
   "domain": null
  },
  {
   "name": "Map_No",
   "type": "esriFieldTypeString",
   "alias": "Map_No",
   "length": 50,
   "domain": null
  },
  {
   "name": "Line_Segment",
   "type": "esriFieldTypeString",
   "alias": "Line_Segment",
   "length": 50,
   "domain": null
  },
  {
   "name": "Upstream_MH",
   "type": "esriFieldTypeString",
   "alias": "Upstream_MH",
   "length": 50,
   "domain": null
  },
  {
   "name": "Downstream_MH",
   "type": "esriFieldTypeString",
   "alias": "Downstream_MH",
   "length": 50,
   "domain": null
  },
  {
   "name": "Owner_Contact_Name",
   "type": "esriFieldTypeString",
   "alias": "Owner_Contact_Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "Owner_Contact_Number",
   "type": "esriFieldTypeString",
   "alias": "Owner_Contact_Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "Inspection_Attempt",
   "type": "esriFieldTypeString",
   "alias": "Inspection_Attempt",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Inspection_Attempt",
    "description": "Building Inspection",
    "codedValues": [
     {
      "name": "1",
      "code": "1"
     },
     {
      "name": "2",
      "code": "2"
     },
     {
      "name": "3",
      "code": "3"
     },
     {
      "name": "Reinspection",
      "code": "Reinspection"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Date_Historical_Flooding",
   "type": "esriFieldTypeString",
   "alias": "Date_Historical_Flooding",
   "length": 50,
   "domain": null
  },
  {
   "name": "Source_Historical_Flooding",
   "type": "esriFieldTypeString",
   "alias": "Source_Historical_Flooding",
   "length": 50,
   "domain": null
  },
  {
   "name": "Actions_Take_After_Flooding",
   "type": "esriFieldTypeString",
   "alias": "Actions_Take_After_Flooding",
   "length": 50,
   "domain": null
  },
  {
   "name": "Foundation_Type",
   "type": "esriFieldTypeString",
   "alias": "Foundation_Typep",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "Foundation_Type",
    "description": "Building Inspection",
    "codedValues": [
     {
      "name": "Slab",
      "code": "Slab"
     },
     {
      "name": "Crawl Space",
      "code": "Crawl Space"
     },
     {
      "name": "Unfinished Basement",
      "code": "Unfinished Basement"
     },
     {
      "name": "Partially Finished Basement",
      "code": "Partially Finished Basement"
     },
     {
      "name": "Finished Basement",
      "code": "Finished Basement"
     },
     {
      "name": "Split-Level",
      "code": "Split-Level"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "RoofDrain_Discharge_to_SS",
   "type": "esriFieldTypeString",
   "alias": "RoofDrain_Discharge_to_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "FoundationDrain_Discharge_to_SS",
   "type": "esriFieldTypeString",
   "alias": "FoundationDrain_Discharge_to_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "Curb_Box_Present",
   "type": "esriFieldTypeString",
   "alias": "Curb_Box_Present",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "YesNO",
    "description": "YesNO",
    "codedValues": [
     {
      "name": "Yes",
      "code": "1"
     },
     {
      "name": "No",
      "code": "2"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "PatioDrain_Discharges_to_SS",
   "type": "esriFieldTypeString",
   "alias": "PatioDrain_Discharges_to_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "DrivewayDrain_Discharges_to_SS",
   "type": "esriFieldTypeString",
   "alias": "DrivewayDrain_Discharges_to_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "WindowWellDrain_to_SS",
   "type": "esriFieldTypeString",
   "alias": "WindowWellDrain_Discharges_to_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "StairwellSidewalkDrain_to_SS",
   "type": "esriFieldTypeString",
   "alias": "StairwellSidewalkDrain_Discharges_to_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "Diverter_Valve_On_Storm_Water",
   "type": "esriFieldTypeString",
   "alias": "Diverter_Valve_On_Storm_Water",
   "length": 50,
   "domain": null
  },
  {
   "name": "Comment",
   "type": "esriFieldTypeString",
   "alias": "Comment",
   "length": 1000,
   "domain": null
  },
  {
   "name": "Picture1",
   "type": "esriFieldTypeInteger",
   "alias": "Picture1",
   "domain": null
  },
  {
   "name": "Picture2",
   "type": "esriFieldTypeInteger",
   "alias": "Picture2",
   "domain": null
  },
  {
   "name": "Combination_Pump",
   "type": "esriFieldTypeString",
   "alias": "Combination_Pump",
   "length": 50,
   "domain": null
  },
  {
   "name": "YardDrain_Discharges_SS",
   "type": "esriFieldTypeString",
   "alias": "YardDrain_Discharges_SS",
   "length": 50,
   "domain": null
  },
  {
   "name": "SuspectConnection",
   "type": "esriFieldTypeString",
   "alias": "SuspectConnection",
   "length": 50,
   "domain": null
  },
  {
   "name": "PermissionGranted",
   "type": "esriFieldTypeString",
   "alias": "PermissionGranted",
   "length": 50,
   "domain": null
  },
  {
   "name": "Dye_Test_Results",
   "type": "esriFieldTypeString",
   "alias": "Dye_Test_Results",
   "length": 50,
   "domain": null
  },
  {
   "name": "Dye_test_comments",
   "type": "esriFieldTypeString",
   "alias": "Dye_test_comments",
   "length": 1000,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R204_SDE_ROWID_UK",
   "fields": "objectid",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "I1599assetkey",
   "fields": "assetkey",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "I1599workdate",
   "fields": "workdate",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 3000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON",
 "isDataVersioned": false,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsHavingClause": true,
  "supportsCountDistinct": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}