{
 "layers": [
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 0,
   "name": "Watersheds.SDE.ProjectInformation",
   "type": "Feature Layer",
   "description": "Watersheds.SDE.ProjectInformation",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 103069,
    "latestWkid": 6488,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -120561100,
    "falseY": -95444400,
    "xyUnits": 3048.0060960121928,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "simple",
     "symbol": {
      "type": "esriSMS",
      "style": "esriSMSCircle",
      "color": [
       87,
       48,
       155,
       255
      ],
      "size": 4,
      "angle": 0,
      "xoffset": 0,
      "yoffset": 0,
      "outline": {
       "color": [
        0,
        0,
        0,
        255
       ],
       "width": 0.7
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": -120561100,
    "ymin": -95444400,
    "xmax": 1566270.000020802,
    "ymax": 744920.5799635649,
    "spatialReference": {
     "wkid": 103069,
     "latestWkid": 6488,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -120561100,
     "falseY": -95444400,
     "xyUnits": 3048.0060960121928,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": true,
   "attachmentProperties": [
    {
     "name": "id",
     "fieldName": "ATTACHMENTID",
     "isEnabled": true
    },
    {
     "name": "globalid",
     "fieldName": "GLOBALID",
     "isEnabled": true
    },
    {
     "name": "keywords",
     "fieldName": "KEYWORDS",
     "isEnabled": false
    },
    {
     "name": "name",
     "fieldName": "ATT_NAME",
     "isEnabled": true
    },
    {
     "name": "contentType",
     "fieldName": "CONTENT_TYPE",
     "isEnabled": true
    },
    {
     "name": "size",
     "fieldName": "DATA_SIZE",
     "isEnabled": true
    },
    {
     "name": "exifInfo",
     "fieldName": "EXIFINFO",
     "isEnabled": false
    }
   ],
   "attachmentFields": [
    {
     "name": "ATTACHMENTID",
     "type": "esriFieldTypeOID",
     "alias": "ATTACHMENTID",
     "editable": false,
     "nullable": false,
     "length": 4,
     "domain": null
    },
    {
     "name": "GLOBALID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GLOBALID",
     "editable": false,
     "nullable": false,
     "length": 38,
     "domain": null
    },
    {
     "name": "ATT_NAME",
     "type": "esriFieldTypeString",
     "alias": "ATT_NAME",
     "editable": true,
     "nullable": false,
     "length": 250,
     "domain": null
    },
    {
     "name": "CONTENT_TYPE",
     "type": "esriFieldTypeString",
     "alias": "CONTENT_TYPE",
     "editable": true,
     "nullable": false,
     "length": 150,
     "domain": null
    },
    {
     "name": "DATA_SIZE",
     "type": "esriFieldTypeInteger",
     "alias": "DATA_SIZE",
     "editable": true,
     "nullable": false,
     "length": 4,
     "domain": null
    }
   ],
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "WPname",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "WPid",
     "type": "esriFieldTypeString",
     "alias": "WPid",
     "length": 25,
     "domain": null
    },
    {
     "name": "WPname",
     "type": "esriFieldTypeString",
     "alias": "WPname",
     "length": 100,
     "domain": null
    },
    {
     "name": "WPlocation",
     "type": "esriFieldTypeString",
     "alias": "WPlocation",
     "length": 50,
     "domain": null
    },
    {
     "name": "WPtype",
     "type": "esriFieldTypeString",
     "alias": "WPtype",
     "length": 30,
     "domain": null
    },
    {
     "name": "WPscope",
     "type": "esriFieldTypeString",
     "alias": "WPscope",
     "length": 255,
     "domain": null
    },
    {
     "name": "WPstatus",
     "type": "esriFieldTypeString",
     "alias": "WPstatus",
     "length": 30,
     "domain": null
    },
    {
     "name": "WPphase",
     "type": "esriFieldTypeString",
     "alias": "WPphase",
     "length": 50,
     "domain": null
    },
    {
     "name": "WPstart",
     "type": "esriFieldTypeDate",
     "alias": "WPstart",
     "length": 8,
     "domain": null
    },
    {
     "name": "WPcomplete",
     "type": "esriFieldTypeDate",
     "alias": "WPcomplete",
     "length": 8,
     "domain": null
    },
    {
     "name": "WPmonitor",
     "type": "esriFieldTypeString",
     "alias": "WPmonitor",
     "length": 255,
     "domain": null
    },
    {
     "name": "Property",
     "type": "esriFieldTypeString",
     "alias": "Property",
     "length": 50,
     "domain": null
    },
    {
     "name": "MS4Permit",
     "type": "esriFieldTypeString",
     "alias": "MS4Permit",
     "length": 5,
     "domain": null
    },
    {
     "name": "WPcost",
     "type": "esriFieldTypeInteger",
     "alias": "WPcost",
     "domain": null
    },
    {
     "name": "WPgrant",
     "type": "esriFieldTypeInteger",
     "alias": "WPgrant",
     "domain": null
    },
    {
     "name": "Designer",
     "type": "esriFieldTypeString",
     "alias": "Designer",
     "length": 50,
     "domain": null
    },
    {
     "name": "DesignPM",
     "type": "esriFieldTypeString",
     "alias": "DesignPM",
     "length": 15,
     "domain": null
    },
    {
     "name": "Contractor",
     "type": "esriFieldTypeString",
     "alias": "Contractor",
     "length": 50,
     "domain": null
    },
    {
     "name": "ConInspector",
     "type": "esriFieldTypeString",
     "alias": "ConInspector",
     "length": 10,
     "domain": null
    },
    {
     "name": "ConManager",
     "type": "esriFieldTypeString",
     "alias": "ConManager",
     "length": 50,
     "domain": null
    },
    {
     "name": "Council",
     "type": "esriFieldTypeString",
     "alias": "Council",
     "length": 50,
     "domain": null
    },
    {
     "name": "MDE12DIG",
     "type": "esriFieldTypeString",
     "alias": "MDE12DIG",
     "length": 15,
     "domain": null
    },
    {
     "name": "ADC",
     "type": "esriFieldTypeString",
     "alias": "ADC",
     "length": 50,
     "domain": null
    },
    {
     "name": "Watershed",
     "type": "esriFieldTypeString",
     "alias": "Watershed",
     "length": 50,
     "domain": null
    },
    {
     "name": "NorthingFT",
     "type": "esriFieldTypeDouble",
     "alias": "NorthingFT",
     "domain": null
    },
    {
     "name": "EastingFT",
     "type": "esriFieldTypeDouble",
     "alias": "EastingFT",
     "domain": null
    },
    {
     "name": "WPlans",
     "type": "esriFieldTypeString",
     "alias": "WPlans",
     "length": 50,
     "domain": null
    },
    {
     "name": "Source",
     "type": "esriFieldTypeString",
     "alias": "Source",
     "length": 100,
     "domain": null
    },
    {
     "name": "Source_id",
     "type": "esriFieldTypeString",
     "alias": "Source_id",
     "length": 50,
     "domain": null
    },
    {
     "name": "Source_Priority",
     "type": "esriFieldTypeSmallInteger",
     "alias": "Source_Priority",
     "domain": null
    },
    {
     "name": "notes",
     "type": "esriFieldTypeString",
     "alias": "notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "GlobalID",
     "type": "esriFieldTypeGlobalID",
     "alias": "GlobalID",
     "length": 38,
     "domain": null
    },
    {
     "name": "PrintOut",
     "type": "esriFieldTypeString",
     "alias": "PrintOut",
     "length": 5,
     "domain": null
    },
    {
     "name": "LFlink",
     "type": "esriFieldTypeString",
     "alias": "LFlink",
     "length": 255,
     "domain": null
    },
    {
     "name": "Temp",
     "type": "esriFieldTypeString",
     "alias": "Temp",
     "length": 50,
     "domain": null
    },
    {
     "name": "DesignPM2",
     "type": "esriFieldTypeString",
     "alias": "DesignPM2",
     "length": 255,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R15_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_15",
     "fields": "GlobalID",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "UUID_OID_15",
     "fields": "GlobalID,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_11_WPid",
     "fields": "WPid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    },
    {
     "name": "S3_idx",
     "fields": "Shape",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "CapitalAgreements",
     "relatedTableId": 1,
     "role": "esriRelRoleOrigin",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToOne",
     "composite": false,
     "catalogID": "{DAC88D05-5DCE-47D9-837C-0D6B0B94F10A}"
    },
    {
     "id": 1,
     "name": "CapitalStatus",
     "relatedTableId": 4,
     "role": "esriRelRoleOrigin",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{145E1E28-DD75-443E-99F9-47096A67E195}"
    },
    {
     "id": 2,
     "name": "CapitalReviews",
     "relatedTableId": 3,
     "role": "esriRelRoleOrigin",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToOne",
     "composite": false,
     "catalogID": "{ED12FA1B-B0D8-4019-A584-6125DB04950B}"
    },
    {
     "id": 3,
     "name": "CapitalExpenditures",
     "relatedTableId": 5,
     "role": "esriRelRoleOrigin",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{C54B2EB0-DBA3-42F2-91CC-915E887088EA}"
    },
    {
     "id": 4,
     "name": "CapitalPermits",
     "relatedTableId": 2,
     "role": "esriRelRoleOrigin",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToOne",
     "composite": false,
     "catalogID": "{7BF61F5D-3FFB-471D-B1FF-967A4DA7D558}"
    }
   ],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "maxSelectionCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, geoJSON, PBF",
   "isDataVersioned": true,
   "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,
    "supportsQueryAttachments": true,
    "supportsQueryAttachmentsWithReturnUrl": true,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": {
    "timeZone": "Eastern Standard Time",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 1,
   "name": "Watersheds.SDE.CapitalAgreements",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "WPname",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "WPname",
     "type": "esriFieldTypeString",
     "alias": "WPname",
     "length": 255,
     "domain": null
    },
    {
     "name": "WPid",
     "type": "esriFieldTypeString",
     "alias": "WPid",
     "length": 255,
     "domain": null
    },
    {
     "name": "NOprop",
     "type": "esriFieldTypeDouble",
     "alias": "NOprop",
     "domain": null
    },
    {
     "name": "FLOODneed",
     "type": "esriFieldTypeString",
     "alias": "FLOODneed",
     "length": 255,
     "domain": null
    },
    {
     "name": "FLOODob",
     "type": "esriFieldTypeString",
     "alias": "FLOODob",
     "length": 255,
     "domain": null
    },
    {
     "name": "FLOODdate",
     "type": "esriFieldTypeDate",
     "alias": "FLOODdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "FLOODloc",
     "type": "esriFieldTypeString",
     "alias": "FLOODloc",
     "length": 255,
     "domain": null
    },
    {
     "name": "AGREEdate",
     "type": "esriFieldTypeDate",
     "alias": "AGREEdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "AGREEloc",
     "type": "esriFieldTypeString",
     "alias": "AGREEloc",
     "length": 255,
     "domain": null
    },
    {
     "name": "AGREEnote",
     "type": "esriFieldTypeString",
     "alias": "AGREEnote",
     "length": 255,
     "domain": null
    },
    {
     "name": "PLATSneed",
     "type": "esriFieldTypeString",
     "alias": "PLATSneed",
     "length": 255,
     "domain": null
    },
    {
     "name": "PLATob",
     "type": "esriFieldTypeString",
     "alias": "PLATob",
     "length": 255,
     "domain": null
    },
    {
     "name": "PLATSdate",
     "type": "esriFieldTypeDate",
     "alias": "PLATSdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PLATSloc",
     "type": "esriFieldTypeString",
     "alias": "PLATSloc",
     "length": 255,
     "domain": null
    },
    {
     "name": "AGREEneed",
     "type": "esriFieldTypeString",
     "alias": "temp1",
     "length": 255,
     "domain": null
    },
    {
     "name": "AGREEob",
     "type": "esriFieldTypeString",
     "alias": "temp2",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R20_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_18_WPid",
     "fields": "WPid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 0,
     "name": "ProjectInformation",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToOne",
     "composite": false,
     "catalogID": "{DAC88D05-5DCE-47D9-837C-0D6B0B94F10A}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "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",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  },
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 2,
   "name": "Watersheds.SDE.CapitalPermits",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "WPname",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "WPname",
     "type": "esriFieldTypeString",
     "alias": "WPname",
     "length": 255,
     "domain": null
    },
    {
     "name": "WPid",
     "type": "esriFieldTypeString",
     "alias": "WPid",
     "length": 255,
     "domain": null
    },
    {
     "name": "SWM",
     "type": "esriFieldTypeString",
     "alias": "SWM",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatus",
      "description": "Permit Status",
      "codedValues": [
       {
        "name": "Final",
        "code": "Final"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st Review",
        "code": "1st Review"
       },
       {
        "name": "2nd Review",
        "code": "2nd Review"
       },
       {
        "name": "Expiration",
        "code": "Expiration"
       },
       {
        "name": "Update",
        "code": "Update"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pre-app",
        "code": "Pre-app"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SWMdate",
     "type": "esriFieldTypeDate",
     "alias": "SWMdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "SWMloc",
     "type": "esriFieldTypeString",
     "alias": "SWMloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SWMwaiver",
     "type": "esriFieldTypeString",
     "alias": "SWMwaiver",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatusWaiver",
      "description": "Status of permit waiver",
      "codedValues": [
       {
        "name": "Submitted",
        "code": "Submitted"
       },
       {
        "name": "Approved",
        "code": "Approved"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pending",
        "code": "Pending"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SWMwaiverDate",
     "type": "esriFieldTypeDate",
     "alias": "SWMwaiverDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "SWMwaiverLoc",
     "type": "esriFieldTypeString",
     "alias": "SWMwaiverLoc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "GRADE",
     "type": "esriFieldTypeString",
     "alias": "GRADE",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatus",
      "description": "Permit Status",
      "codedValues": [
       {
        "name": "Final",
        "code": "Final"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st Review",
        "code": "1st Review"
       },
       {
        "name": "2nd Review",
        "code": "2nd Review"
       },
       {
        "name": "Expiration",
        "code": "Expiration"
       },
       {
        "name": "Update",
        "code": "Update"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pre-app",
        "code": "Pre-app"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "GRADEdate",
     "type": "esriFieldTypeDate",
     "alias": "GRADEdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "GRADEloc",
     "type": "esriFieldTypeString",
     "alias": "GRADEloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "MDE",
     "type": "esriFieldTypeString",
     "alias": "MDE",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatus",
      "description": "Permit Status",
      "codedValues": [
       {
        "name": "Final",
        "code": "Final"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st Review",
        "code": "1st Review"
       },
       {
        "name": "2nd Review",
        "code": "2nd Review"
       },
       {
        "name": "Expiration",
        "code": "Expiration"
       },
       {
        "name": "Update",
        "code": "Update"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pre-app",
        "code": "Pre-app"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "MDEdate",
     "type": "esriFieldTypeString",
     "alias": "MDEdate",
     "length": 255,
     "domain": null
    },
    {
     "name": "MDEloc",
     "type": "esriFieldTypeString",
     "alias": "MDEloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "ACOE",
     "type": "esriFieldTypeString",
     "alias": "ACOE",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatus",
      "description": "Permit Status",
      "codedValues": [
       {
        "name": "Final",
        "code": "Final"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st Review",
        "code": "1st Review"
       },
       {
        "name": "2nd Review",
        "code": "2nd Review"
       },
       {
        "name": "Expiration",
        "code": "Expiration"
       },
       {
        "name": "Update",
        "code": "Update"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pre-app",
        "code": "Pre-app"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "ACOEdate",
     "type": "esriFieldTypeDate",
     "alias": "ACOEdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ACOEloc",
     "type": "esriFieldTypeString",
     "alias": "ACOEloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "NOI",
     "type": "esriFieldTypeString",
     "alias": "NOI",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatus",
      "description": "Permit Status",
      "codedValues": [
       {
        "name": "Final",
        "code": "Final"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st Review",
        "code": "1st Review"
       },
       {
        "name": "2nd Review",
        "code": "2nd Review"
       },
       {
        "name": "Expiration",
        "code": "Expiration"
       },
       {
        "name": "Update",
        "code": "Update"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pre-app",
        "code": "Pre-app"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "NOIdate",
     "type": "esriFieldTypeDate",
     "alias": "NOIdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "NOIloc",
     "type": "esriFieldTypeString",
     "alias": "NOIloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SHA",
     "type": "esriFieldTypeString",
     "alias": "SHA",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatus",
      "description": "Permit Status",
      "codedValues": [
       {
        "name": "Final",
        "code": "Final"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st Review",
        "code": "1st Review"
       },
       {
        "name": "2nd Review",
        "code": "2nd Review"
       },
       {
        "name": "Expiration",
        "code": "Expiration"
       },
       {
        "name": "Update",
        "code": "Update"
       },
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pre-app",
        "code": "Pre-app"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SHAdate",
     "type": "esriFieldTypeDate",
     "alias": "SHAdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "SHAloc",
     "type": "esriFieldTypeString",
     "alias": "SHAloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SWMAB",
     "type": "esriFieldTypeString",
     "alias": "SWMAB",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatusAB",
      "description": "Permit status for asbuilt submittals",
      "codedValues": [
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st review",
        "code": "1st review"
       },
       {
        "name": "2nd review",
        "code": "2nd review"
       },
       {
        "name": "Approved",
        "code": "Approved"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "SWMABdate",
     "type": "esriFieldTypeDate",
     "alias": "SWMABdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "SWMABloc",
     "type": "esriFieldTypeString",
     "alias": "SWMABloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "STRAB",
     "type": "esriFieldTypeString",
     "alias": "STRAB",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "PermitStatusAB",
      "description": "Permit status for asbuilt submittals",
      "codedValues": [
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "Pending",
        "code": "Pending"
       },
       {
        "name": "1st review",
        "code": "1st review"
       },
       {
        "name": "2nd review",
        "code": "2nd review"
       },
       {
        "name": "Approved",
        "code": "Approved"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "STRABdate",
     "type": "esriFieldTypeDate",
     "alias": "STRABdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "STRAABloc",
     "type": "esriFieldTypeString",
     "alias": "STRABloc",
     "length": 50,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "Notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R19_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_17_WPid",
     "fields": "WPid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 4,
     "name": "ProjectInformation",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToOne",
     "composite": false,
     "catalogID": "{7BF61F5D-3FFB-471D-B1FF-967A4DA7D558}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "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",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  },
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 3,
   "name": "Watersheds.SDE.CapitalReviews",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "WPname",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "WPname",
     "type": "esriFieldTypeString",
     "alias": "WPname",
     "length": 255,
     "domain": null
    },
    {
     "name": "WPid",
     "type": "esriFieldTypeString",
     "alias": "WPid",
     "length": 255,
     "domain": null
    },
    {
     "name": "BCI",
     "type": "esriFieldTypeDouble",
     "alias": "BCITEMP",
     "domain": {
      "type": "codedValue",
      "name": "OtherReviewStatus",
      "description": "",
      "codedValues": [
       {
        "name": "10%",
        "code": 0.1
       },
       {
        "name": "30%",
        "code": 0.3
       },
       {
        "name": "75%",
        "code": 0.75
       },
       {
        "name": "90%",
        "code": 0.9
       },
       {
        "name": "100%",
        "code": 1
       },
       {
        "name": "N/A",
        "code": 0
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BCIdate",
     "type": "esriFieldTypeDate",
     "alias": "BCIdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "BCIloc",
     "type": "esriFieldTypeString",
     "alias": "BCIloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "WSloc",
     "type": "esriFieldTypeString",
     "alias": "WSloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "PR",
     "type": "esriFieldTypeDouble",
     "alias": "PR",
     "domain": {
      "type": "codedValue",
      "name": "OtherReviewStatus",
      "description": "",
      "codedValues": [
       {
        "name": "10%",
        "code": 0.1
       },
       {
        "name": "30%",
        "code": 0.3
       },
       {
        "name": "75%",
        "code": 0.75
       },
       {
        "name": "90%",
        "code": 0.9
       },
       {
        "name": "100%",
        "code": 1
       },
       {
        "name": "N/A",
        "code": 0
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "PRdate",
     "type": "esriFieldTypeDate",
     "alias": "PRdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PRloc",
     "type": "esriFieldTypeString",
     "alias": "PRloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "HCPSdate",
     "type": "esriFieldTypeDate",
     "alias": "HCPSdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "HCPSloc",
     "type": "esriFieldTypeString",
     "alias": "HCPSloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "PermitLoc",
      "description": "Where the permit resides",
      "codedValues": [
       {
        "name": "to reviewer",
        "code": "to reviewer"
       },
       {
        "name": "from reviewer",
        "code": "from reviewer"
       },
       {
        "name": "to consultant",
        "code": "to consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "WS",
     "type": "esriFieldTypeDouble",
     "alias": "WSTEMP",
     "domain": {
      "type": "codedValue",
      "name": "OtherReviewStatus",
      "description": "",
      "codedValues": [
       {
        "name": "10%",
        "code": 0.1
       },
       {
        "name": "30%",
        "code": 0.3
       },
       {
        "name": "75%",
        "code": 0.75
       },
       {
        "name": "90%",
        "code": 0.9
       },
       {
        "name": "100%",
        "code": 1
       },
       {
        "name": "N/A",
        "code": 0
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "HCPS",
     "type": "esriFieldTypeDouble",
     "alias": "HCPSTEMP",
     "domain": {
      "type": "codedValue",
      "name": "OtherReviewStatus",
      "description": "",
      "codedValues": [
       {
        "name": "10%",
        "code": 0.1
       },
       {
        "name": "30%",
        "code": 0.3
       },
       {
        "name": "75%",
        "code": 0.75
       },
       {
        "name": "90%",
        "code": 0.9
       },
       {
        "name": "100%",
        "code": 1
       },
       {
        "name": "N/A",
        "code": 0
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "WSdate",
     "type": "esriFieldTypeDate",
     "alias": "WSdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "Notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R21_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_19_WPid",
     "fields": "WPid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 2,
     "name": "ProjectInformation",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToOne",
     "composite": false,
     "catalogID": "{ED12FA1B-B0D8-4019-A584-6125DB04950B}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "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",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  },
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 4,
   "name": "Watersheds.SDE.CapitalStatus",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "WPname",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "WPname",
     "type": "esriFieldTypeString",
     "alias": "WPname",
     "length": 255,
     "domain": null
    },
    {
     "name": "WPid",
     "type": "esriFieldTypeString",
     "alias": "WPid",
     "length": 255,
     "domain": null
    },
    {
     "name": "StreamClosure",
     "type": "esriFieldTypeString",
     "alias": "StreamClosure",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "StreamClosure",
      "description": "Stream closure periods",
      "codedValues": [
       {
        "name": "N/A",
        "code": "N/A"
       },
       {
        "name": "I (Mar 1 to Jun 15)",
        "code": "I (Mar 1 to Jun 15)"
       },
       {
        "name": "III (Oct 1 to Apr 30)",
        "code": "III (Oct 1 to Apr 30)"
       },
       {
        "name": "IV (Mar 1 to May 31)",
        "code": "IV (Mar 1 to May 31)"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BondEndDate",
     "type": "esriFieldTypeDate",
     "alias": "BondEndDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "BondInspec",
     "type": "esriFieldTypeDate",
     "alias": "BondInspec",
     "length": 8,
     "domain": null
    },
    {
     "name": "TreeSurvey",
     "type": "esriFieldTypeDate",
     "alias": "TreeSurvey",
     "length": 8,
     "domain": null
    },
    {
     "name": "CONpercent",
     "type": "esriFieldTypeDouble",
     "alias": "CONpercent",
     "domain": null
    },
    {
     "name": "CONcomplete",
     "type": "esriFieldTypeDate",
     "alias": "CONcomplete",
     "length": 8,
     "domain": null
    },
    {
     "name": "CONstart",
     "type": "esriFieldTypeDate",
     "alias": "CONstart",
     "length": 8,
     "domain": null
    },
    {
     "name": "PreCon",
     "type": "esriFieldTypeDate",
     "alias": "PreCon",
     "length": 8,
     "domain": null
    },
    {
     "name": "Plans_SpecPrint",
     "type": "esriFieldTypeString",
     "alias": "Plans_SpecPrint",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "Workflow",
      "description": "Workflow",
      "codedValues": [
       {
        "name": "Yes",
        "code": "Yes"
       },
       {
        "name": "No",
        "code": "No"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "BID",
     "type": "esriFieldTypeDate",
     "alias": "BID",
     "length": 8,
     "domain": null
    },
    {
     "name": "NEXTsubmit",
     "type": "esriFieldTypeDate",
     "alias": "NEXTsubmit",
     "length": 8,
     "domain": null
    },
    {
     "name": "WPR",
     "type": "esriFieldTypeDouble",
     "alias": "WPR",
     "domain": {
      "type": "codedValue",
      "name": "StatusComplete",
      "description": "Status Complete for Capital Projects",
      "codedValues": [
       {
        "name": "10%",
        "code": 0.1
       },
       {
        "name": "30%",
        "code": 0.3
       },
       {
        "name": "75%",
        "code": 0.75
       },
       {
        "name": "90%",
        "code": 0.9
       },
       {
        "name": "100%",
        "code": 1
       },
       {
        "name": "NTP",
        "code": 0
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "WPRdate",
     "type": "esriFieldTypeDate",
     "alias": "WPRdate",
     "length": 8,
     "domain": null
    },
    {
     "name": "WPRloc",
     "type": "esriFieldTypeString",
     "alias": "WPRloc",
     "length": 255,
     "domain": {
      "type": "codedValue",
      "name": "StatusLoc",
      "description": "Where the plans reside for WPR reviews",
      "codedValues": [
       {
        "name": "to consultant",
        "code": "to consultant"
       },
       {
        "name": "from consultant",
        "code": "from consultant"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDefaultValue"
     }
    },
    {
     "name": "NOTES",
     "type": "esriFieldTypeString",
     "alias": "NOTES",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R18_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_16_WPid",
     "fields": "WPid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 1,
     "name": "ProjectInformation",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{145E1E28-DD75-443E-99F9-47096A67E195}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "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",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  },
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 5,
   "name": "Watersheds.SDE.CapitalExpenditures",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "WPid",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "WPid",
     "type": "esriFieldTypeString",
     "alias": "WPid",
     "length": 255,
     "domain": null
    },
    {
     "name": "PhaseType",
     "type": "esriFieldTypeString",
     "alias": "PhaseType",
     "length": 255,
     "domain": null
    },
    {
     "name": "TaskType",
     "type": "esriFieldTypeString",
     "alias": "TaskType",
     "length": 255,
     "domain": null
    },
    {
     "name": "TaskStart",
     "type": "esriFieldTypeString",
     "alias": "TaskStart",
     "length": 255,
     "domain": null
    },
    {
     "name": "TaskComplete",
     "type": "esriFieldTypeString",
     "alias": "TaskComplete",
     "length": 255,
     "domain": null
    },
    {
     "name": "BidNo",
     "type": "esriFieldTypeString",
     "alias": "BidNo",
     "length": 255,
     "domain": null
    },
    {
     "name": "Account",
     "type": "esriFieldTypeString",
     "alias": "Account",
     "length": 255,
     "domain": null
    },
    {
     "name": "status",
     "type": "esriFieldTypeString",
     "alias": "status",
     "length": 255,
     "domain": null
    },
    {
     "name": "FiscalYR",
     "type": "esriFieldTypeDouble",
     "alias": "FiscalYR",
     "domain": null
    },
    {
     "name": "PO",
     "type": "esriFieldTypeString",
     "alias": "PO",
     "length": 255,
     "domain": null
    },
    {
     "name": "PObalance",
     "type": "esriFieldTypeString",
     "alias": "PObalance",
     "length": 255,
     "domain": null
    },
    {
     "name": "POoriginal",
     "type": "esriFieldTypeDouble",
     "alias": "POoriginal",
     "domain": null
    },
    {
     "name": "POupdated",
     "type": "esriFieldTypeDouble",
     "alias": "POupdated",
     "domain": null
    },
    {
     "name": "POactual",
     "type": "esriFieldTypeDouble",
     "alias": "POactual",
     "domain": null
    },
    {
     "name": "POgrant",
     "type": "esriFieldTypeDouble",
     "alias": "POgrant",
     "domain": null
    },
    {
     "name": "POother",
     "type": "esriFieldTypeDouble",
     "alias": "POother",
     "domain": null
    },
    {
     "name": "LastInvoice",
     "type": "esriFieldTypeString",
     "alias": "LastInvoice",
     "length": 255,
     "domain": null
    },
    {
     "name": "Contractor",
     "type": "esriFieldTypeString",
     "alias": "Contractor",
     "length": 255,
     "domain": null
    },
    {
     "name": "PM",
     "type": "esriFieldTypeString",
     "alias": "PM",
     "length": 255,
     "domain": null
    },
    {
     "name": "Notes",
     "type": "esriFieldTypeString",
     "alias": "Notes",
     "length": 255,
     "domain": null
    },
    {
     "name": "WPname",
     "type": "esriFieldTypeString",
     "alias": "WPname",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "R23_SDE_ROWID_UK",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "GDB_428_WPid",
     "fields": "WPid",
     "isAscending": true,
     "isUnique": false,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [
    {
     "id": 3,
     "name": "ProjectInformation",
     "relatedTableId": 0,
     "role": "esriRelRoleDestination",
     "keyField": "WPid",
     "cardinality": "esriRelCardinalityOneToMany",
     "composite": false,
     "catalogID": "{C54B2EB0-DBA3-42F2-91CC-915E887088EA}"
    }
   ],
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 2000,
   "supportsStatistics": true,
   "supportsExceedsLimitStatistics": true,
   "supportsAdvancedQueries": true,
   "supportedQueryFormats": "JSON, PBF",
   "isDataVersioned": true,
   "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",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  },
  {
   "currentVersion": 11.4,
   "cimVersion": "3.4.0",
   "id": 6,
   "name": "Watersheds.SDE.ConstructionCosts",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "wpid",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "wpid",
     "type": "esriFieldTypeString",
     "alias": "wpid",
     "length": 255,
     "domain": null
    },
    {
     "name": "fiscalyr",
     "type": "esriFieldTypeDouble",
     "alias": "fiscalyr",
     "domain": null
    },
    {
     "name": "PO",
     "type": "esriFieldTypeString",
     "alias": "PO",
     "length": 255,
     "domain": null
    },
    {
     "name": "POactual",
     "type": "esriFieldTypeDouble",
     "alias": "POactual",
     "domain": null
    },
    {
     "name": "ESRI_OID",
     "type": "esriFieldTypeOID",
     "alias": "ESRI_OID",
     "domain": null
    }
   ],
   "indexes": null,
   "subtypes": [],
   "relationships": [],
   "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",
    "timeZoneIANA": "America/New_York",
    "respectsDaylightSaving": true
   },
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "uniqueIdInfo": {
    "type": "simple",
    "fields": [
     "wpid"
    ],
    "OIDFieldContainsHashValue": true
   },
   "maxUniqueIDCount": 100000,
   "serviceItemId": "7665ee383bf54eb1887fc87344e8e5a3"
  }
 ]
}