{
 "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": "uniqueValue",
     "field1": "appsite_type",
     "uniqueValueGroups": [
      {
       "heading": "Application Site Type",
       "classes": [
        {
         "label": "Active Address",
         "description": "Active Address",
         "symbol": {
          "type": "esriSMS",
          "style": "esriSMSSquare",
          "color": [
           0,
           0,
           0,
           255
          ],
          "size": 5,
          "angle": 0,
          "xoffset": 0,
          "yoffset": 0,
          "outline": {
           "color": [
            0,
            0,
            0,
            255
           ],
           "width": 0
          }
         },
         "values": [
          [
           "active"
          ]
         ]
        },
        {
         "label": "Retired REID",
         "description": "Retired REID",
         "symbol": {
          "type": "esriSMS",
          "style": "esriSMSCircle",
          "color": [
           230,
           0,
           0,
           255
          ],
          "size": 5,
          "angle": 0,
          "xoffset": 0,
          "yoffset": 0,
          "outline": {
           "color": [
            0,
            0,
            0,
            255
           ],
           "width": 0.6
          }
         },
         "values": [
          [
           "retired"
          ]
         ]
        },
        {
         "label": "No Address, Active REID",
         "description": "No Address, Active REID",
         "symbol": {
          "type": "esriPMS",
          "url": "63a74afa44a8ce5bc04a451f794b9ef2",
          "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAICAYAAADA+m62AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAuklEQVQYlWNhQANS7gxGz3Yy/GNgYLiALM6Cpk6CTYqhRimdQfreTAZ/BgaGF1gVitoxhMuGMQRySDAwfLzIkPz2BEMrNoUSUv4MGRIeEI5cDEPm2xMMc2GmwhVK+TAUSvkxaMD4MsEM0g/mM+S/P8tQiazQQCaUIZpHBWE8yHrldIbsM2kMK0EeAymUkAllKBJ3Y5BGDwHZSAbeZ1sZ6p5tZAgCKfzy7xcDz6VShr3oCkGAlZeBD2QYAM/eKaa5SqbFAAAAAElFTkSuQmCC",
          "contentType": "image/png",
          "width": 7,
          "height": 6,
          "angle": 0,
          "xoffset": 0,
          "yoffset": 0
         },
         "values": [
          [
           "unaddressed"
          ]
         ]
        }
       ]
      }
     ],
     "uniqueValueInfos": [
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSSquare",
        "color": [
         0,
         0,
         0,
         255
        ],
        "size": 5,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0
        }
       },
       "value": "active",
       "label": "Active Address"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         230,
         0,
         0,
         255
        ],
        "size": 5,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.6
        }
       },
       "value": "retired",
       "label": "Retired REID"
      },
      {
       "symbol": {
        "type": "esriPMS",
        "url": "63a74afa44a8ce5bc04a451f794b9ef2",
        "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAICAYAAADA+m62AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAuklEQVQYlWNhQANS7gxGz3Yy/GNgYLiALM6Cpk6CTYqhRimdQfreTAZ/BgaGF1gVitoxhMuGMQRySDAwfLzIkPz2BEMrNoUSUv4MGRIeEI5cDEPm2xMMc2GmwhVK+TAUSvkxaMD4MsEM0g/mM+S/P8tQiazQQCaUIZpHBWE8yHrldIbsM2kMK0EeAymUkAllKBJ3Y5BGDwHZSAbeZ1sZ6p5tZAgCKfzy7xcDz6VShr3oCkGAlZeBD2QYAM/eKaa5SqbFAAAAAElFTkSuQmCC",
        "contentType": "image/png",
        "width": 7,
        "height": 6,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0
       },
       "value": "unaddressed",
       "label": "No Address, Active REID"
      }
     ],
     "fieldDelimiter": ",",
     "authoringInfo": {
      "colorRamp": {
       "type": "multipart",
       "colorRamps": [
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          179,
          180,
          252,
          255
         ],
         "toColor": [
          179,
          180,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          185,
          252,
          179,
          255
         ],
         "toColor": [
          185,
          252,
          179,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          188,
          182,
          255
         ],
         "toColor": [
          252,
          188,
          182,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          197,
          242,
          252,
          255
         ],
         "toColor": [
          197,
          242,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          238,
          192,
          255
         ],
         "toColor": [
          252,
          238,
          192,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          179,
          234,
          255
         ],
         "toColor": [
          252,
          179,
          234,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          238,
          215,
          252,
          255
         ],
         "toColor": [
          238,
          215,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          182,
          252,
          223,
          255
         ],
         "toColor": [
          182,
          252,
          223,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          199,
          222,
          255
         ],
         "toColor": [
          252,
          199,
          222,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          229,
          215,
          255
         ],
         "toColor": [
          252,
          229,
          215,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          217,
          252,
          204,
          255
         ],
         "toColor": [
          217,
          252,
          204,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          179,
          217,
          252,
          255
         ],
         "toColor": [
          179,
          217,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          227,
          179,
          252,
          255
         ],
         "toColor": [
          227,
          179,
          252,
          255
         ]
        }
       ]
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": [
     {
      "labelExpressionInfo": {
       "expression": "$feature.addrssFullAddress",
       "title": "Custom"
      },
      "labelPlacement": "esriServerPointLabelPlacementAboveRight",
      "deconflictionStrategy": "dynamic",
      "stackLabel": false,
      "removeDuplicates": "none",
      "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": [
        255,
        255,
        255,
        255
       ],
       "haloSize": 2,
       "font": {
        "family": "Arial",
        "size": 10,
        "style": "normal",
        "weight": "normal",
        "decoration": "none"
       }
      }
     }
    ]
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 1122764.6536458135,
    "ymin": 668457.3339843601,
    "xmax": 1298065.5026041567,
    "ymax": 830691.8144531101,
    "spatialReference": {
     "wkid": 102719,
     "latestWkid": 2264,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -121841900,
     "falseY": -93659000,
     "xyUnits": 1536.0000000000034,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "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
    },
    {
     "name": "appsite_type",
     "type": "esriFieldTypeString",
     "alias": "Application Site Type",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "000_appSite_SiteLifecycle",
      "description": "Application Site Lifecycle",
      "codedValues": [
       {
        "name": "Retired REID",
        "code": "retired"
       },
       {
        "name": "Active Address",
        "code": "active"
       },
       {
        "name": "No Address, Active REID",
        "code": "unaddressed"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    }
   ],
   "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": 3,
     "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": 1,
   "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
    },
    {
     "name": "Count_AssociatedApps",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Count of Associated Applications",
     "domain": null
    },
    {
     "name": "Fees_AssociatedApps_andInspects",
     "type": "esriFieldTypeSingle",
     "alias": "Sum of Fees of Associated Applications & Inspections",
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "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": ""
    },
    {
     "name": "UUID_6516",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "Applications",
     "relatedTableId": 3,
     "role": "esriRelRoleOrigin",
     "keyField": "projid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{52F83CCF-373D-4EDC-800A-09CE391206ED}"
    }
   ],
   "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": 2,
   "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
    },
    {
     "name": "activeflag",
     "type": "esriFieldTypeString",
     "alias": "Active Flag",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "000_YesNo_String",
      "description": "Yes or No (String)",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "internal_status",
     "type": "esriFieldTypeString",
     "alias": "Internal Status",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicationAddress",
     "type": "esriFieldTypeString",
     "alias": "Application Address from App Record",
     "length": 255,
     "domain": null
    },
    {
     "name": "feeInspect",
     "type": "esriFieldTypeSingle",
     "alias": "Inspection Fees",
     "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": 3,
     "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": 3,
   "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": "appid",
     "type": "esriFieldTypeString",
     "alias": "Application ID",
     "length": 255,
     "domain": null
    },
    {
     "name": "SiteAddress",
     "type": "esriFieldTypeString",
     "alias": "SiteAddress",
     "length": 900,
     "domain": null
    },
    {
     "name": "SiteAddress_backup",
     "type": "esriFieldTypeString",
     "alias": "SiteAddress Backup",
     "length": 255,
     "domain": null
    },
    {
     "name": "InspectionCount",
     "type": "esriFieldTypeSmallInteger",
     "alias": "InspectionCount",
     "domain": null
    },
    {
     "name": "InspectionCompleted",
     "type": "esriFieldTypeSmallInteger",
     "alias": "InspectionCompleted",
     "domain": null
    },
    {
     "name": "parcelREID",
     "type": "esriFieldTypeString",
     "alias": "Parcel REID",
     "length": 255,
     "domain": null
    },
    {
     "name": "applicant_address",
     "type": "esriFieldTypeString",
     "alias": "Applicant Address",
     "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_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": "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": {
      "type": "codedValue",
      "name": "000_YesNo_String",
      "description": "Yes or No (String)",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "fees_forApp",
     "type": "esriFieldTypeSingle",
     "alias": "Application Fees Before Adding Inspections",
     "domain": null
    },
    {
     "name": "fees_plusSumInspections",
     "type": "esriFieldTypeSingle",
     "alias": "Application Fees After Adding Sum of Inspections",
     "domain": null
    },
    {
     "name": "cadastral_Grantor",
     "type": "esriFieldTypeString",
     "alias": "Grantor",
     "length": 255,
     "domain": null
    },
    {
     "name": "cadastral_Grantee",
     "type": "esriFieldTypeString",
     "alias": "Grantee",
     "length": 255,
     "domain": null
    },
    {
     "name": "cadastral_BookPage",
     "type": "esriFieldTypeString",
     "alias": "Book/Page ",
     "length": 255,
     "domain": null
    },
    {
     "name": "cadastral_DocType",
     "type": "esriFieldTypeString",
     "alias": "Document Type",
     "length": 255,
     "domain": null
    },
    {
     "name": "cadastral_PUV",
     "type": "esriFieldTypeSingle",
     "alias": "Present Use Value",
     "domain": null
    },
    {
     "name": "cadastral_TaxDollars",
     "type": "esriFieldTypeSingle",
     "alias": "Tax Dollars",
     "domain": null
    },
    {
     "name": "cadastral_TransferKind",
     "type": "esriFieldTypeString",
     "alias": "Transfer Kind",
     "length": 255,
     "domain": null
    },
    {
     "name": "cadastral_InstNum",
     "type": "esriFieldTypeString",
     "alias": "Instrument Number",
     "length": 255,
     "domain": null
    },
    {
     "name": "cadastral_TransferYear",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Transfer Year",
     "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": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "appid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{D5139378-C526-44B1-912C-33EA81CDDE99}"
    },
    {
     "id": 0,
     "name": "BURKE.ApplicationSites",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "SiteAddress",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{8E6820FA-31E1-4FA9-9753-24541B79571A}"
    },
    {
     "id": 0,
     "name": "Projects",
     "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"
  }
 ]
}