{
 "layers": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 0,
   "name": "All CIP Projects",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 2913,
    "latestWkid": 2913,
    "xyTolerance": 0.0032808398950131233,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -111333600,
    "falseY": -98152500,
    "xyUnits": 3048,
    "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": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       0,
       0,
       0,
       0
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        110,
        110,
        110,
        255
       ],
       "width": 0.4
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 7586052.149278209,
    "ymin": 601073.630905509,
    "xmax": 7626691.213254586,
    "ymax": 696891.0889107585,
    "spatialReference": {
     "wkid": 2913,
     "latestWkid": 2913,
     "xyTolerance": 0.0032808398950131233,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -111333600,
     "falseY": -98152500,
     "xyUnits": 3048,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "PROJECTNAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "SHAPE.STArea()",
     "type": "esriFieldTypeDouble",
     "alias": "SHAPE.STArea()",
     "domain": null
    },
    {
     "name": "SHAPE.STLength()",
     "type": "esriFieldTypeDouble",
     "alias": "SHAPE.STLength()",
     "domain": null
    },
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "PROJECTNUM",
     "type": "esriFieldTypeString",
     "alias": "PROJECTNUM",
     "length": 10,
     "domain": null
    },
    {
     "name": "PROJECTNAME",
     "type": "esriFieldTypeString",
     "alias": "PROJECTNAME",
     "length": 100,
     "domain": null
    },
    {
     "name": "PROJCAT",
     "type": "esriFieldTypeString",
     "alias": "PROJCAT",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "WS1_CIPCategory",
      "description": "CIP Project Categories",
      "codedValues": [
       {
        "name": "Civic",
        "code": "CIV"
       },
       {
        "name": "Sanitary",
        "code": "SAN"
       },
       {
        "name": "Storm",
        "code": "STM"
       },
       {
        "name": "Transportation",
        "code": "TSP"
       },
       {
        "name": "Water",
        "code": "WTR"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "ACTIVE",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ACTIVE",
     "domain": {
      "type": "codedValue",
      "name": "WS1_YesNoBinary",
      "description": "Binary True/False Yes/No",
      "codedValues": [
       {
        "name": "Yes",
        "code": 1
       },
       {
        "name": "No",
        "code": 0
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "LASTUPDATE",
     "type": "esriFieldTypeDate",
     "alias": "LASTUPDATE",
     "length": 8,
     "domain": null
    },
    {
     "name": "LASTEDITOR",
     "type": "esriFieldTypeString",
     "alias": "LASTEDITOR",
     "length": 50,
     "domain": null
    },
    {
     "name": "DATE_CREATED",
     "type": "esriFieldTypeDate",
     "alias": "DATE_CREATED",
     "length": 8,
     "domain": null
    },
    {
     "name": "CREATED_BY",
     "type": "esriFieldTypeString",
     "alias": "CREATED_BY",
     "length": 50,
     "domain": null
    },
    {
     "name": "Globalid",
     "type": "esriFieldTypeGlobalID",
     "alias": "Globalid",
     "length": 38,
     "domain": null
    },
    {
     "name": "NAC",
     "type": "esriFieldTypeString",
     "alias": "NAC",
     "length": 150,
     "domain": null
    },
    {
     "name": "ProjectStatusCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatusCode",
     "length": 20,
     "domain": {
      "type": "codedValue",
      "name": "WS1_CIP_StatusCode",
      "description": "CIP Status Code",
      "codedValues": [
       {
        "name": "Completed",
        "code": "COMP"
       },
       {
        "name": "Future",
        "code": "FUTR"
       },
       {
        "name": "On Hold",
        "code": "HOLD"
       },
       {
        "name": "In Progress",
        "code": "INPR"
       },
       {
        "name": "Pending",
        "code": "PEND"
       },
       {
        "name": "Delete",
        "code": "DEL"
       },
       {
        "name": "Replace",
        "code": "REPL"
       },
       {
        "name": "Planned",
        "code": "PLAN"
       }
      ],
      "mergePolicy": "esriMPTDefaultValue",
      "splitPolicy": "esriSPTDuplicate"
     }
    },
    {
     "name": "ProjectCIPYear",
     "type": "esriFieldTypeString",
     "alias": "ProjectCIPYear",
     "length": 20,
     "domain": null
    },
    {
     "name": "ProjectCIPYearNum",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectCIPYearNum",
     "domain": null
    },
    {
     "name": "SHAPE",
     "type": "esriFieldTypeGeometry",
     "alias": "SHAPE",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "SHAPE",
    "type": "esriFieldTypeGeometry",
    "alias": "SHAPE"
   },
   "indexes": [
    {
     "name": "R12768_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_12768",
     "fields": "Globalid",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "UUID_OID_12768",
     "fields": "Globalid,OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S10864_idx",
     "fields": "SHAPE",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "subtypes": [],
   "relationships": [],
   "canModifyLayer": true,
   "canScaleSymbols": false,
   "hasLabels": false,
   "capabilities": "Map,Query,Data",
   "maxRecordCount": 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,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasGeometryProperties": true,
   "geometryProperties": {
    "shapeAreaFieldName": "SHAPE.STArea()",
    "shapeLengthFieldName": "SHAPE.STLength()",
    "units": "esriFeet",
    "mapUnits": {"uwkid": 9002}
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true,
   "serviceItemId": "d334952b2f744694adbd7cb62a92bb85"
  }
 ],
 "tables": [
  {
   "currentVersion": 11.2,
   "cimVersion": "3.2.0",
   "id": 7,
   "name": "CapitalProjects.dbo.Projects",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "ProjectName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ProjectID",
     "type": "esriFieldTypeOID",
     "alias": "ProjectID",
     "domain": null
    },
    {
     "name": "ProjectNumber",
     "type": "esriFieldTypeString",
     "alias": "ProjectNumber",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProjectName",
     "type": "esriFieldTypeString",
     "alias": "ProjectName",
     "length": 150,
     "domain": null
    },
    {
     "name": "ProjectConsultant",
     "type": "esriFieldTypeString",
     "alias": "ProjectConsultant",
     "length": 50,
     "domain": null
    },
    {
     "name": "ProjectContractor",
     "type": "esriFieldTypeString",
     "alias": "ProjectContractor",
     "length": 50,
     "domain": null
    },
    {
     "name": "ProjectStatusCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatusCode",
     "length": 4,
     "domain": null
    },
    {
     "name": "ProjectTypes",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectTypes",
     "domain": null
    },
    {
     "name": "ProjectStatus",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatus",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectDescription",
     "type": "esriFieldTypeString",
     "alias": "ProjectDescription",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectProblem",
     "type": "esriFieldTypeString",
     "alias": "ProjectProblem",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectJustification",
     "type": "esriFieldTypeString",
     "alias": "ProjectJustification",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectScope",
     "type": "esriFieldTypeString",
     "alias": "ProjectScope",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectRemarks",
     "type": "esriFieldTypeString",
     "alias": "ProjectRemarks",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectMap",
     "type": "esriFieldTypeString",
     "alias": "ProjectMap",
     "length": 1073741822,
     "domain": null
    },
    {
     "name": "ProjectCIPYear",
     "type": "esriFieldTypeString",
     "alias": "ProjectCIPYear",
     "length": 12,
     "domain": null
    },
    {
     "name": "ProjectFund",
     "type": "esriFieldTypeString",
     "alias": "ProjectFund",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProjectNew",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectNew",
     "domain": null
    },
    {
     "name": "ProjectAsOfDate",
     "type": "esriFieldTypeDate",
     "alias": "ProjectAsOfDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProjectStartDate",
     "type": "esriFieldTypeDate",
     "alias": "ProjectStartDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PWApproved",
     "type": "esriFieldTypeSmallInteger",
     "alias": "PWApproved",
     "domain": null
    },
    {
     "name": "PWApprovedBy",
     "type": "esriFieldTypeString",
     "alias": "PWApprovedBy",
     "length": 50,
     "domain": null
    },
    {
     "name": "PWApprovedTs",
     "type": "esriFieldTypeDate",
     "alias": "PWApprovedTs",
     "length": 8,
     "domain": null
    },
    {
     "name": "FinApproved",
     "type": "esriFieldTypeSmallInteger",
     "alias": "FinApproved",
     "domain": null
    },
    {
     "name": "FinApprovedBy",
     "type": "esriFieldTypeString",
     "alias": "FinApprovedBy",
     "length": 50,
     "domain": null
    },
    {
     "name": "FinApprovedTs",
     "type": "esriFieldTypeDate",
     "alias": "FinApprovedTs",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProjectSubstantialDate",
     "type": "esriFieldTypeDate",
     "alias": "ProjectSubstantialDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProjectCompletionDate",
     "type": "esriFieldTypeDate",
     "alias": "ProjectCompletionDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProjectCompletionTBD",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectCompletionTBD",
     "domain": null
    },
    {
     "name": "ProjectDurationDays",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectDurationDays",
     "domain": null
    },
    {
     "name": "ProjectAuthorizedCost",
     "type": "esriFieldTypeDouble",
     "alias": "ProjectAuthorizedCost",
     "domain": null
    },
    {
     "name": "ProjectEstimatedCost",
     "type": "esriFieldTypeDouble",
     "alias": "ProjectEstimatedCost",
     "domain": null
    },
    {
     "name": "ProjectActualCost",
     "type": "esriFieldTypeDouble",
     "alias": "ProjectActualCost",
     "domain": null
    },
    {
     "name": "ProjectCategory",
     "type": "esriFieldTypeString",
     "alias": "ProjectCategory",
     "length": 20,
     "domain": null
    },
    {
     "name": "ProjectWebFlag",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectWebFlag",
     "domain": null
    },
    {
     "name": "ProjectAllowFundingUpdates",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectAllowFundingUpdates",
     "domain": null
    },
    {
     "name": "ProjectFundingArtOrdinance",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectFundingArtOrdinance",
     "domain": null
    },
    {
     "name": "ProjectFundingMSTIP",
     "type": "esriFieldTypeSmallInteger",
     "alias": "ProjectFundingMSTIP",
     "domain": null
    },
    {
     "name": "ProjectStatusDashboard",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatusDashboard",
     "length": 10,
     "domain": null
    },
    {
     "name": "ProjectStatusCADD",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatusCADD",
     "length": 50,
     "domain": null
    },
    {
     "name": "ProjectStatusSurvey",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatusSurvey",
     "length": 50,
     "domain": null
    },
    {
     "name": "ProjectStatusConstruction",
     "type": "esriFieldTypeString",
     "alias": "ProjectStatusConstruction",
     "length": 50,
     "domain": null
    },
    {
     "name": "ProjectComments",
     "type": "esriFieldTypeString",
     "alias": "ProjectComments",
     "length": 2147483647,
     "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,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true,
    "supportsCurrentUserQueries": true
   },
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "serviceItemId": "d334952b2f744694adbd7cb62a92bb85"
  }
 ]
}