{
 "layers": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 0,
   "name": "Application Sites",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102719,
    "latestWkid": 2264,
    "xyTolerance": 0.02083333333333329,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -1.2184189999999976E8,
    "falseY": -9.365899999999982E7,
    "xyUnits": 1536.0000000000032,
    "falseZ": -100000,
    "zUnits": 10000,
    "falseM": -100000,
    "mUnits": 10000
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSSquare",
      "color": [
       0,
       0,
       0,
       255
      ],
      "size": 2,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 0
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": [
     {
      "labelExpressionInfo": {
       "expression": "$feature.addrssFullAddress",
       "title": "Custom"
      },
      "labelPlacement": "esriServerPointLabelPlacementAboveRight",
      "deconflictionStrategy": "dynamic",
      "stackLabel": true,
      "stackAlignment": "dynamic",
      "removeDuplicates": "none",
      "stackRowLength": 24,
      "useCodedValues": true,
      "maxScale": 0,
      "minScale": 5000,
      "name": "Class 1",
      "priority": -1,
      "symbol": {
       "type": "esriTS",
       "color": [
        0,
        0,
        0,
        255
       ],
       "backgroundColor": null,
       "borderLineColor": null,
       "borderLineSize": null,
       "verticalAlignment": "bottom",
       "horizontalAlignment": "left",
       "rightToLeft": false,
       "angle": 0,
       "xoffset": 0,
       "yoffset": 0,
       "kerning": true,
       "haloColor": null,
       "haloSize": null,
       "font": {
        "family": "Tahoma",
        "size": 10,
        "style": "normal",
        "weight": "normal",
        "decoration": "none"
       }
      }
     }
    ]
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 1124258.152343735,
    "ymin": 668545.5175781101,
    "xmax": 1298065.5026041567,
    "ymax": 830248.3164062351,
    "spatialReference": {
     "wkid": 102719,
     "latestWkid": 2264,
     "vcsWkid": 105703,
     "latestVcsWkid": 6360,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -121841900,
     "falseY": -93659000,
     "xyUnits": 3048.0060960121928,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "heightModelInfo": {
    "heightModel": "gravity_related_height",
    "vertCRS": "NAVD88_height_(ftUS)",
    "heightUnit": "us-foot"
   },
   "supportsVCSProjection": true,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "ctylmtCITYNAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "DistTo_SewerPipe",
     "type": "esriFieldTypeDouble",
     "alias": "DistTo_SewerPipe",
     "domain": null
    },
    {
     "name": "DistTo_WaterPipe",
     "type": "esriFieldTypeDouble",
     "alias": "DistTo_WaterPipe",
     "domain": null
    },
    {
     "name": "addrssFullAddress",
     "type": "esriFieldTypeString",
     "alias": "Full Address from Original Address Record",
     "length": 100,
     "domain": null
    },
    {
     "name": "addrssMSAG",
     "type": "esriFieldTypeString",
     "alias": "MSAG Community Name",
     "length": 30,
     "domain": null
    },
    {
     "name": "addrssPostComm",
     "type": "esriFieldTypeString",
     "alias": "Postal Community Name",
     "length": 40,
     "domain": null
    },
    {
     "name": "addrssCITY",
     "type": "esriFieldTypeString",
     "alias": "City by Address Record",
     "length": 20,
     "domain": null
    },
    {
     "name": "addrssETJ",
     "type": "esriFieldTypeString",
     "alias": "ETJ from Address Record",
     "length": 20,
     "domain": null
    },
    {
     "name": "addrssCADCITY",
     "type": "esriFieldTypeString",
     "alias": "CAD City by Address Record",
     "length": 10,
     "domain": null
    },
    {
     "name": "ctylmtCITYNAME",
     "type": "esriFieldTypeString",
     "alias": "City By CityLimit Boundary",
     "length": 20,
     "domain": null
    },
    {
     "name": "parcelREID",
     "type": "esriFieldTypeString",
     "alias": "REID from Parcel",
     "length": 20,
     "domain": null
    },
    {
     "name": "parcelPIN",
     "type": "esriFieldTypeString",
     "alias": "PIN from Parcel",
     "length": 14,
     "domain": null
    },
    {
     "name": "parcelPINEXT",
     "type": "esriFieldTypeString",
     "alias": "PIN_EXT",
     "length": 4,
     "domain": null
    },
    {
     "name": "parcelOwner",
     "type": "esriFieldTypeString",
     "alias": "parcelOwner",
     "length": 600,
     "domain": null
    },
    {
     "name": "parcelOwnerMail1",
     "type": "esriFieldTypeString",
     "alias": "parcelOwnerMail1",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelOwnerMail2",
     "type": "esriFieldTypeString",
     "alias": "parcelOwnerMail2",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelOwnerMail3",
     "type": "esriFieldTypeString",
     "alias": "parcelOwnerMail3",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelOwnerMail_City",
     "type": "esriFieldTypeString",
     "alias": "parcelOwnerMail_City",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelOwnerMail_State",
     "type": "esriFieldTypeString",
     "alias": "parcelOwnerMail_State",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelOwnerMail_ZIP",
     "type": "esriFieldTypeString",
     "alias": "parcelOwnerMail_ZIP",
     "length": 255,
     "domain": null
    },
    {
     "name": "waterSystem",
     "type": "esriFieldTypeString",
     "alias": "waterSystem",
     "length": 254,
     "domain": null
    },
    {
     "name": "waterMATERIAL",
     "type": "esriFieldTypeString",
     "alias": "Water Pipe Material",
     "length": 254,
     "domain": null
    },
    {
     "name": "waterYEARBUILT",
     "type": "esriFieldTypeString",
     "alias": "YEARBUILT of water pipe",
     "length": 254,
     "domain": null
    },
    {
     "name": "waterAssetid",
     "type": "esriFieldTypeString",
     "alias": "Asset ID of nearest water pipe",
     "length": 255,
     "domain": null
    },
    {
     "name": "waterOwnedby",
     "type": "esriFieldTypeString",
     "alias": "water pipe Owned By",
     "length": 255,
     "domain": null
    },
    {
     "name": "waterMaintainedby",
     "type": "esriFieldTypeString",
     "alias": "water pipe Maintained By",
     "length": 255,
     "domain": null
    },
    {
     "name": "waterAssettype",
     "type": "esriFieldTypeString",
     "alias": "Type of Water Pipe",
     "length": 255,
     "domain": null
    },
    {
     "name": "waterSubtype",
     "type": "esriFieldTypeString",
     "alias": "Water Pipe Subtype",
     "length": 255,
     "domain": null
    },
    {
     "name": "sewerAssettype",
     "type": "esriFieldTypeString",
     "alias": "Sewer Pipe Type",
     "length": 254,
     "domain": null
    },
    {
     "name": "sewerSize",
     "type": "esriFieldTypeString",
     "alias": "Sewer Size",
     "length": 254,
     "domain": null
    },
    {
     "name": "sewerMaterial",
     "type": "esriFieldTypeString",
     "alias": "Sewer Pipe Material",
     "length": 254,
     "domain": null
    },
    {
     "name": "sewerYearInstall",
     "type": "esriFieldTypeString",
     "alias": "Sewer Year Installed",
     "length": 254,
     "domain": null
    },
    {
     "name": "sewerInstallationYear",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Sewer InstallationYear",
     "domain": null
    },
    {
     "name": "sewerOwnedBy",
     "type": "esriFieldTypeString",
     "alias": "Sewer Owner",
     "length": 255,
     "domain": null
    },
    {
     "name": "sewerMaintby",
     "type": "esriFieldTypeString",
     "alias": "Sewer Maintainer",
     "length": 255,
     "domain": null
    },
    {
     "name": "sewerAssetid",
     "type": "esriFieldTypeString",
     "alias": "Sewer Asset ID",
     "length": 64,
     "domain": null
    },
    {
     "name": "sewerSubtype",
     "type": "esriFieldTypeString",
     "alias": "Sewer Subtype",
     "length": 255,
     "domain": null
    },
    {
     "name": "zoningZoneCode",
     "type": "esriFieldTypeString",
     "alias": "zoningZoneCode",
     "length": 255,
     "domain": null
    },
    {
     "name": "zoningMERGE_SRC",
     "type": "esriFieldTypeString",
     "alias": "Zoning MERGE_SRC",
     "length": 255,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "townshipName",
     "type": "esriFieldTypeString",
     "alias": "Township Name",
     "length": 20,
     "domain": null
    },
    {
     "name": "votingPrecinct",
     "type": "esriFieldTypeString",
     "alias": "Voting Precinct",
     "length": 255,
     "domain": null
    },
    {
     "name": "schoolElem",
     "type": "esriFieldTypeString",
     "alias": "Elementary School District",
     "length": 255,
     "domain": null
    },
    {
     "name": "schoolMiddle",
     "type": "esriFieldTypeString",
     "alias": "Middle School District",
     "length": 255,
     "domain": null
    },
    {
     "name": "schoolHigh",
     "type": "esriFieldTypeString",
     "alias": "High School District",
     "length": 255,
     "domain": null
    },
    {
     "name": "fireStation",
     "type": "esriFieldTypeString",
     "alias": "Fire Station District",
     "length": 255,
     "domain": null
    },
    {
     "name": "overlayVAD_YN",
     "type": "esriFieldTypeString",
     "alias": "Within Half Mile of VAD",
     "length": 255,
     "domain": null
    },
    {
     "name": "overlayAdultCare_YN",
     "type": "esriFieldTypeString",
     "alias": "Within Half Mile of Adult Care Facility",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelLatestDeed_Date",
     "type": "esriFieldTypeDate",
     "alias": "Latest Recorded Deed Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "parcelLatestDeed_BookPage",
     "type": "esriFieldTypeString",
     "alias": "Latest Recorded Deed Book/Page",
     "length": 255,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R6484_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S4701_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "BURKE.AppsPermitsInspections",
     "relatedTableId": 11,
     "role": "esriRelRoleOrigin",
     "keyField": "addrssFullAddress",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{8E6820FA-31E1-4FA9-9753-24541B79571A}"
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": true,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "hasZ": true,
   "hasM": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": false,
   "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true},
   "useStandardizedQueries": true,
   "supportedSpatialRelationships": [
    "esriSpatialRelIntersects",
    "esriSpatialRelContains",
    "esriSpatialRelCrosses",
    "esriSpatialRelEnvelopeIntersects",
    "esriSpatialRelIndexIntersects",
    "esriSpatialRelOverlaps",
    "esriSpatialRelTouches",
    "esriSpatialRelWithin",
    "esriSpatialRelRelation"
   ],
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": {
    "timeZone": "Eastern Standard Time",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "fba00c21bc994528b943facd947ee40f"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 11,
   "name": "Application Submissions",
   "type": "Table",
   "description": null,
   "hasAttachments": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "applicant_name",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "SiteAddress",
     "type": "esriFieldTypeString",
     "alias": "SiteAddress",
     "length": 900,
     "domain": null
    },
    {
     "name": "appid",
     "type": "esriFieldTypeString",
     "alias": "Application ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "appType",
     "type": "esriFieldTypeString",
     "alias": "Application Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "appSubtype",
     "type": "esriFieldTypeString",
     "alias": "Application Subtype",
     "length": 255,
     "domain": null
    },
    {
     "name": "appDate",
     "type": "esriFieldTypeDate",
     "alias": "Application Date",
     "length": 8,
     "domain": null
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "Application Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "internal_status",
     "type": "esriFieldTypeString",
     "alias": "Status as per Internal Staff",
     "length": 255,
     "domain": null
    },
    {
     "name": "internal_decisionDate",
     "type": "esriFieldTypeDate",
     "alias": "Date of Application Decision by Staff",
     "length": 8,
     "domain": null
    },
    {
     "name": "appNote",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "appGroup",
     "type": "esriFieldTypeString",
     "alias": "Application Group",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_id",
     "type": "esriFieldTypeString",
     "alias": "Applicant ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_type",
     "type": "esriFieldTypeString",
     "alias": "Applicant Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_name",
     "type": "esriFieldTypeString",
     "alias": "Applicant Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_address",
     "type": "esriFieldTypeString",
     "alias": "Applicant Address",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_address2",
     "type": "esriFieldTypeString",
     "alias": "Applicant Address Line 2",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_city",
     "type": "esriFieldTypeString",
     "alias": "Applicant City",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_state",
     "type": "esriFieldTypeString",
     "alias": "Applicant State",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_ZIP",
     "type": "esriFieldTypeString",
     "alias": "Applicant ZIP",
     "length": 255,
     "domain": null
    },
    {
     "name": "internal_comments",
     "type": "esriFieldTypeString",
     "alias": "Comments by Internal Staff",
     "length": 3000,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "appURL_Tyler",
     "type": "esriFieldTypeString",
     "alias": "Tyler Munis Application URL",
     "length": 255,
     "domain": null
    },
    {
     "name": "project_YN",
     "type": "esriFieldTypeString",
     "alias": "Part of a Project?",
     "length": 255,
     "domain": null
    },
    {
     "name": "projid",
     "type": "esriFieldTypeString",
     "alias": "Project ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "parcelREID",
     "type": "esriFieldTypeString",
     "alias": "Parcel REID",
     "length": 255,
     "domain": null
    },
    {
     "name": "contractorName",
     "type": "esriFieldTypeString",
     "alias": "Contractor Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "internal_phasing",
     "type": "esriFieldTypeString",
     "alias": "Internal Phase 1",
     "length": 255,
     "domain": null
    },
    {
     "name": "internal_activeflag",
     "type": "esriFieldTypeString",
     "alias": "Internal Active or Closed",
     "length": 255,
     "domain": null
    },
    {
     "name": "SiteAddress_backup",
     "type": "esriFieldTypeString",
     "alias": "SiteAddress Backup",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R6509_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_6509",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_10353_SiteAddress",
     "fields": "SiteAddress",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "BURKE.InspectionsTable",
     "relatedTableId": 12,
     "role": "esriRelRoleOrigin",
     "keyField": "appid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{D5139378-C526-44B1-912C-33EA81CDDE99}"
    },
    {
     "id": 2,
     "name": "BURKE.ProjectsTable",
     "relatedTableId": 13,
     "role": "esriRelRoleOrigin",
     "keyField": "appid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{7306C8C6-95DE-4522-98E0-2D7B7CC6B45F}"
    },
    {
     "id": 0,
     "name": "BURKE.ApplicationSites",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "SiteAddress",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{8E6820FA-31E1-4FA9-9753-24541B79571A}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": {
    "timeZone": "Eastern Standard Time",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "fba00c21bc994528b943facd947ee40f"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 12,
   "name": "Inspections Table",
   "type": "Table",
   "description": null,
   "hasAttachments": true,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "OBJECTID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "appid",
     "type": "esriFieldTypeString",
     "alias": "Application ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "inspid",
     "type": "esriFieldTypeString",
     "alias": "Inspection ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "type",
     "type": "esriFieldTypeString",
     "alias": "Inspection Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "inspector",
     "type": "esriFieldTypeString",
     "alias": "Inspector Assigned",
     "length": 255,
     "domain": null
    },
    {
     "name": "passfail",
     "type": "esriFieldTypeString",
     "alias": "Pass or Fail",
     "length": 255,
     "domain": null
    },
    {
     "name": "deptid",
     "type": "esriFieldTypeString",
     "alias": "Department ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "contractorid",
     "type": "esriFieldTypeString",
     "alias": "Contractor ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "date_insp_created",
     "type": "esriFieldTypeDate",
     "alias": "Date Inspection-Request was Created",
     "length": 8,
     "domain": null
    },
    {
     "name": "date_requested",
     "type": "esriFieldTypeDate",
     "alias": "Date Customer Requested for Inspection",
     "length": 8,
     "domain": null
    },
    {
     "name": "date_scheduled",
     "type": "esriFieldTypeDate",
     "alias": "Scheduled Time for Inspection",
     "length": 8,
     "domain": null
    },
    {
     "name": "date_performed",
     "type": "esriFieldTypeDate",
     "alias": "Date Inspection was Performed",
     "length": 8,
     "domain": null
    },
    {
     "name": "scheduledby",
     "type": "esriFieldTypeString",
     "alias": "Scheduled By",
     "length": 255,
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R6515_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_10360_appid",
     "fields": "appid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_6515",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "BURKE.AppsPermitsInspections",
     "relatedTableId": 11,
     "role": "esriRelRoleDestination",
     "keyField": "appid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{D5139378-C526-44B1-912C-33EA81CDDE99}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": {
    "timeZone": "Eastern Standard Time",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "fba00c21bc994528b943facd947ee40f"
  },
  {
   "currentVersion": 11.3,
   "cimVersion": "3.3.0",
   "id": 13,
   "name": "Projects Table",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "OBJECTID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "appid",
     "type": "esriFieldTypeString",
     "alias": "Application ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "projid",
     "type": "esriFieldTypeString",
     "alias": "Project ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "projName",
     "type": "esriFieldTypeString",
     "alias": "Project Name",
     "length": 255,
     "domain": null
    },
    {
     "name": "projDesc",
     "type": "esriFieldTypeString",
     "alias": "Project Description",
     "length": 255,
     "domain": null
    },
    {
     "name": "projStatus",
     "type": "esriFieldTypeString",
     "alias": "Project Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "projDept",
     "type": "esriFieldTypeString",
     "alias": "Project Department",
     "length": 255,
     "domain": null
    },
    {
     "name": "projType",
     "type": "esriFieldTypeString",
     "alias": "Project Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "projOpened",
     "type": "esriFieldTypeDate",
     "alias": "Date Project Opened",
     "length": 8,
     "domain": null
    },
    {
     "name": "projClosed",
     "type": "esriFieldTypeDate",
     "alias": "Date Project Closed",
     "length": 8,
     "domain": null
    },
    {
     "name": "feedbackStatus",
     "type": "esriFieldTypeString",
     "alias": "Internal Feedback Status",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R6516_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_10756_appid",
     "fields": "appid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 2,
     "name": "BURKE.AppsPermitsInspections",
     "relatedTableId": 11,
     "role": "esriRelRoleDestination",
     "keyField": "appid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{7306C8C6-95DE-4522-98E0-2D7B7CC6B45F}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": false,
   "useStandardizedQueries": true,
   "advancedQueryCapabilities": {
    "useStandardizedQueries": true,
    "supportsStatistics": true,
    "supportsPercentileStatistics": true,
    "supportsHavingClause": true,
    "supportsOrderBy": true,
    "supportsDistinct": true,
    "supportsCountDistinct": true,
    "supportsPagination": true,
    "supportsTrueCurve": false,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsAdvancedQueryRelated": true,
    "supportsQueryRelatedPagination": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": {
    "timeZone": "Eastern Standard Time",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "fba00c21bc994528b943facd947ee40f"
  }
 ]
}