{
 "layers": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 0,
   "name": "COB_CIP_5YR",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPoint",
   "sourceSpatialReference": {
    "wkid": 102739,
    "latestWkid": 2277,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -124805500,
    "falseY": -81923100,
    "xyUnits": 3048.006096012192,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "Geographic Information Services\nCity of Bryan / Information Technology\n801 East 29th Street\nBryan, Texas 77803\nPhone: (979) 209-5470\ngis@bryantx.gov\nwww.bryantx.gov/gis\n\n\nCity of Bryan Geographic Information Services Data Disclaimer:\n\nThis geospatial data product is for informational purposes and may not have been prepared for or be suitable for legal, engineering, or surveying purposes. It does not represent an on-the-ground survey conducted by or under the supervision of a registered professional land surveyor and represents only the approximate relative location of property boundaries. This product may not reflect some data otherwise available. This product is not a substitute for obtaining a survey or other professional advice about a specific property, specific question, or situation.\n\nAll data, information, and maps are provided \u201cas is\u201d without warranty or any representation of accuracy, timeliness of completeness. The burden for determining accuracy, completeness, timeliness, merchantability and fitness for or the appropriateness for use rests solely on the requester. The City of Bryan makes no warranties, express or implied, as to the use of the information obtained here. There are no implied warranties of merchantability or fitness for a particular purpose. The requestor acknowledges and accepts all limitations, including the fact that the data, information, and maps are dynamic and in a constant state of maintenance, correction and update.",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "uniqueValue",
     "field1": "Status",
     "uniqueValueInfos": [
      {
       "symbol": {
        "type": "esriPMS",
        "url": "ca699fc6e1f8228483e2fef1639017db",
        "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAzUlEQVQYlY2QMQ6CQBBFX8I2FhQWxCx0FBR2hBuY2IHHkAOQWHMBDoA3wJbSZG+wMbGkNIIxW3AFC0SRyt/MJPP//D8j+BNi0kfOhtzbIa0F7q1CG0UKdFNitM6p/T1yVMmEuClomwIP6ASAsyH398jn+dcuyKC/UBpFIgC83XfTajvU62HolyHSqLe1tcCdhx8Fwh5mAuBWoWVCPN00otfUH6JRpE1BG2S/pPsJ/ag5Tq/umgKvv1AuQ6SwcXtN/Sbp+R87o0iMmqcd8AL8rzws4g5VMgAAAABJRU5ErkJggg==",
        "contentType": "image/png",
        "width": 7,
        "height": 7,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0
       },
       "value": "Approved",
       "label": "Approved"
      },
      {
       "symbol": {
        "type": "esriPMS",
        "url": "85ca3786957660e6efdff0e1d9073800",
        "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAoAAAAKCAYAAACNMs+9AAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA1ElEQVQYlWWQsa3DMAxEXwD1UutAAAEtoCK9R9AILpPKO+SP4ZQawd6AvQdQySqtR0gTG0b+NSTIRxx4jv+6fet6HrpTf08pPWOMXQgBVWXbtgfwOoP3nPM0juNxVUqh1jqp6htYHEBK6blDqoqIICIMw4CZzWZ2ccAtxtjtUK0VgGEY6PseEcHMrg4ghACAiBzW3ntOu84Bq6pSSjnsvPfknAFora3A6gC2bXvUWqfdbtc8z7TW/s5fv1T1bWaziBBCoLW2fqHlN8fFzC5mdgW638A/+u9W+1nHSmAAAAAASUVORK5CYII=",
        "contentType": "image/png",
        "width": 7,
        "height": 7,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0
       },
       "value": "CIP Database",
       "label": "CIP Database"
      },
      {
       "symbol": {
        "type": "esriSMS",
        "style": "esriSMSCircle",
        "color": [
         250,
         115,
         119,
         255
        ],
        "size": 4,
        "angle": 0,
        "xoffset": 0,
        "yoffset": 0,
        "outline": {
         "color": [
          0,
          0,
          0,
          255
         ],
         "width": 0.7
        }
       },
       "value": "Removed",
       "label": "Removed"
      }
     ],
     "fieldDelimiter": ",",
     "authoringInfo": {
      "colorRamp": {
       "type": "multipart",
       "colorRamps": [
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          114,
          114,
          247,
          255
         ],
         "toColor": [
          114,
          114,
          247,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          79,
          150,
          56,
          255
         ],
         "toColor": [
          79,
          150,
          56,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          209,
          96,
          104,
          255
         ],
         "toColor": [
          209,
          96,
          104,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          155,
          208,
          232,
          255
         ],
         "toColor": [
          155,
          208,
          232,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          250,
          204,
          97,
          255
         ],
         "toColor": [
          250,
          204,
          97,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          124,
          74,
          130,
          255
         ],
         "toColor": [
          124,
          74,
          130,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          245,
          122,
          243,
          255
         ],
         "toColor": [
          245,
          122,
          243,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          138,
          120,
          90,
          255
         ],
         "toColor": [
          138,
          120,
          90,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          145,
          250,
          208,
          255
         ],
         "toColor": [
          145,
          250,
          208,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          96,
          247,
          104,
          255
         ],
         "toColor": [
          96,
          247,
          104,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          52,
          138,
          116,
          255
         ],
         "toColor": [
          52,
          138,
          116,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          209,
          250,
          142,
          255
         ],
         "toColor": [
          209,
          250,
          142,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          68,
          119,
          173,
          255
         ],
         "toColor": [
          68,
          119,
          173,
          255
         ]
        }
       ]
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 3503923.986609921,
    "ymin": 1.0209190694695756E7,
    "xmax": 3568686.97453776,
    "ymax": 1.0251905291681096E7,
    "spatialReference": {
     "wkid": 102739,
     "latestWkid": 2277,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -124805500,
     "falseY": -81923100,
     "xyUnits": 3048.006096012192,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "CIP_ProjID",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "CIP_ProjID",
     "type": "esriFieldTypeString",
     "alias": "CIP_ProjID",
     "length": 30,
     "domain": null
    },
    {
     "name": "TYPE",
     "type": "esriFieldTypeString",
     "alias": "TYPE",
     "length": 25,
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 35,
     "domain": null
    },
    {
     "name": "Descr",
     "type": "esriFieldTypeString",
     "alias": "Descr",
     "length": 100,
     "domain": null
    },
    {
     "name": "Web_Link",
     "type": "esriFieldTypeString",
     "alias": "Web_Link",
     "length": 100,
     "domain": null
    },
    {
     "name": "Fiscal_YR",
     "type": "esriFieldTypeString",
     "alias": "Fiscal_YR",
     "length": 25,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "ProjectCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectCode",
     "length": 15,
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R370_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S358_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,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": true
   },
   "supportsDatumTransformation": true,
   "advancedQueryAnalyticCapabilities": {
    "supportsLinearRegression": true,
    "supportsAsync": false,
    "supportsPercentileAnalytic": true
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 1,
   "name": "COB_CIP_join",
   "type": "Feature Layer",
   "description": "",
   "geometryType": "esriGeometryPolygon",
   "sourceSpatialReference": {
    "wkid": 102739,
    "latestWkid": 2277,
    "xyTolerance": 0.003280833333333333,
    "zTolerance": 0.001,
    "mTolerance": 0.001,
    "falseX": -124805500,
    "falseY": -81923100,
    "xyUnits": 3048.006096012192,
    "falseZ": 0,
    "zUnits": 1,
    "falseM": 0,
    "mUnits": 1
   },
   "copyrightText": "",
   "parentLayer": null,
   "subLayers": [],
   "minScale": 0,
   "maxScale": 0,
   "referenceScale": 0.0,
   "drawingInfo": {
    "renderer": {
     "type": "uniqueValue",
     "field1": "CIP_TYPES",
     "defaultSymbol": {
      "type": "esriSFS",
      "style": "esriSFSSolid",
      "color": [
       130,
       130,
       130,
       255
      ],
      "outline": {
       "type": "esriSLS",
       "style": "esriSLSSolid",
       "color": [
        110,
        110,
        110,
        255
       ],
       "width": 0.7
      }
     },
     "defaultLabel": "<all other values>",
     "uniqueValueInfos": [
      {
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         76,
         230,
         0,
         255
        ],
        "outline": {
         "type": "esriSLS",
         "style": "esriSLSSolid",
         "color": [
          110,
          110,
          110,
          255
         ],
         "width": 0.7
        }
       },
       "value": "COMPLETE",
       "label": "COMPLETE"
      },
      {
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         255,
         0,
         0,
         255
        ],
        "outline": {
         "type": "esriSLS",
         "style": "esriSLSDash",
         "color": [
          110,
          110,
          110,
          255
         ],
         "width": 1
        }
       },
       "value": "CONSTRUCTION",
       "label": "CONSTRUCTION"
      },
      {
       "symbol": {
        "type": "esriSFS",
        "style": "esriSFSSolid",
        "color": [
         245,
         245,
         122,
         255
        ],
        "outline": {
         "type": "esriSLS",
         "style": "esriSLSDash",
         "color": [
          110,
          110,
          110,
          255
         ],
         "width": 1
        }
       },
       "value": "DESIGN",
       "label": "DESIGN"
      }
     ],
     "fieldDelimiter": ",",
     "authoringInfo": {
      "colorRamp": {
       "type": "multipart",
       "colorRamps": [
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          215,
          215,
          252,
          255
         ],
         "toColor": [
          215,
          215,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          179,
          252,
          183,
          255
         ],
         "toColor": [
          179,
          252,
          183,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          228,
          194,
          255
         ],
         "toColor": [
          252,
          228,
          194,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          184,
          252,
          244,
          255
         ],
         "toColor": [
          184,
          252,
          244,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          179,
          202,
          255
         ],
         "toColor": [
          252,
          179,
          202,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          234,
          179,
          252,
          255
         ],
         "toColor": [
          234,
          179,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          219,
          252,
          212,
          255
         ],
         "toColor": [
          219,
          252,
          212,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          183,
          179,
          252,
          255
         ],
         "toColor": [
          183,
          179,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          250,
          252,
          179,
          255
         ],
         "toColor": [
          250,
          252,
          179,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          194,
          179,
          255
         ],
         "toColor": [
          252,
          194,
          179,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          182,
          229,
          252,
          255
         ],
         "toColor": [
          182,
          229,
          252,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          252,
          199,
          244,
          255
         ],
         "toColor": [
          252,
          199,
          244,
          255
         ]
        },
        {
         "type": "algorithmic",
         "algorithm": "esriCIELabAlgorithm",
         "fromColor": [
          217,
          197,
          252,
          255
         ],
         "toColor": [
          217,
          197,
          252,
          255
         ]
        }
       ]
      }
     }
    },
    "scaleSymbols": true,
    "transparency": 0,
    "labelingInfo": null
   },
   "defaultVisibility": true,
   "extent": {
    "xmin": 3533873.8699515015,
    "ymin": 1.0212368169968084E7,
    "xmax": 3558853.5663830936,
    "ymax": 1.0247695515979916E7,
    "spatialReference": {
     "wkid": 102739,
     "latestWkid": 2277,
     "xyTolerance": 0.003280833333333333,
     "zTolerance": 0.001,
     "mTolerance": 0.001,
     "falseX": -124805500,
     "falseY": -81923100,
     "xyUnits": 3048.006096012192,
     "falseZ": -100000,
     "zUnits": 10000,
     "falseM": -100000,
     "mUnits": 10000
    }
   },
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText",
   "displayField": "CIP_NAME",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "OBJECTID",
     "type": "esriFieldTypeOID",
     "alias": "OBJECTID",
     "domain": null
    },
    {
     "name": "Id",
     "type": "esriFieldTypeInteger",
     "alias": "Id",
     "domain": null
    },
    {
     "name": "CIP_NAME",
     "type": "esriFieldTypeString",
     "alias": "CIP_NAME",
     "length": 65,
     "domain": null
    },
    {
     "name": "CIP_TYPES",
     "type": "esriFieldTypeString",
     "alias": "CIP_TYPES",
     "length": 30,
     "domain": null
    },
    {
     "name": "PROJ_TYPE",
     "type": "esriFieldTypeString",
     "alias": "PROJ_TYPE",
     "length": 50,
     "domain": null
    },
    {
     "name": "PROJ_NUM",
     "type": "esriFieldTypeString",
     "alias": "PROJ_NUM",
     "length": 25,
     "domain": null
    },
    {
     "name": "INSPECTOR",
     "type": "esriFieldTypeString",
     "alias": "INSPECTOR",
     "length": 30,
     "domain": null
    },
    {
     "name": "ENGINEER",
     "type": "esriFieldTypeString",
     "alias": "ENGINEER",
     "length": 30,
     "domain": null
    },
    {
     "name": "CIP_PAGE",
     "type": "esriFieldTypeString",
     "alias": "CIP_PAGE",
     "length": 100,
     "domain": null
    },
    {
     "name": "PDF_MAP",
     "type": "esriFieldTypeString",
     "alias": "PDF_MAP",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractID",
     "type": "esriFieldTypeInteger",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 50,
     "domain": null
    },
    {
     "name": "CategoryName",
     "type": "esriFieldTypeString",
     "alias": "CategoryName",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractName",
     "type": "esriFieldTypeString",
     "alias": "ContractName",
     "length": 255,
     "domain": null
    },
    {
     "name": "Department",
     "type": "esriFieldTypeString",
     "alias": "Department",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractSignedDate",
     "type": "esriFieldTypeDate",
     "alias": "ContractSignedDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ExpirationDate",
     "type": "esriFieldTypeDate",
     "alias": "ExpirationDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "LastRevised",
     "type": "esriFieldTypeDate",
     "alias": "LastRevised",
     "length": 8,
     "domain": null
    },
    {
     "name": "ReviewBy",
     "type": "esriFieldTypeDate",
     "alias": "ReviewBy",
     "length": 8,
     "domain": null
    },
    {
     "name": "POReq",
     "type": "esriFieldTypeString",
     "alias": "POReq",
     "length": 100,
     "domain": null
    },
    {
     "name": "CompanyNameWith",
     "type": "esriFieldTypeString",
     "alias": "CompanyNameWith",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectName",
     "type": "esriFieldTypeString",
     "alias": "ProjectName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CityJobNumber",
     "type": "esriFieldTypeString",
     "alias": "CityJobNumber",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectCode",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField4",
     "type": "esriFieldTypeString",
     "alias": "UserField4",
     "length": 255,
     "domain": null
    },
    {
     "name": "AwardedDesignContract",
     "type": "esriFieldTypeString",
     "alias": "AwardedDesignContract",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompleteDesign",
     "type": "esriFieldTypeString",
     "alias": "CompleteDesign",
     "length": 255,
     "domain": null
    },
    {
     "name": "BeginConstruction",
     "type": "esriFieldTypeString",
     "alias": "BeginConstruction",
     "length": 255,
     "domain": null
    },
    {
     "name": "Advertise",
     "type": "esriFieldTypeString",
     "alias": "Advertise",
     "length": 255,
     "domain": null
    },
    {
     "name": "BidOpen",
     "type": "esriFieldTypeString",
     "alias": "BidOpen",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField10",
     "type": "esriFieldTypeString",
     "alias": "UserField10",
     "length": 255,
     "domain": null
    },
    {
     "name": "PropertyDate",
     "type": "esriFieldTypeDate",
     "alias": "PropertyDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PropertyValue",
     "type": "esriFieldTypeString",
     "alias": "PropertyValue",
     "length": 255,
     "domain": null
    },
    {
     "name": "MonetaryValue",
     "type": "esriFieldTypeDouble",
     "alias": "MonetaryValue",
     "domain": null
    },
    {
     "name": "PropertyName",
     "type": "esriFieldTypeString",
     "alias": "PropertyName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompanyName",
     "type": "esriFieldTypeString",
     "alias": "CompanyName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CouncilDate",
     "type": "esriFieldTypeDate",
     "alias": "CouncilDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProfLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "ProfLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "GenLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "GenLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "PerformanceBondExpDate",
     "type": "esriFieldTypeDate",
     "alias": "PerformanceBondExpDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "UserDate5",
     "type": "esriFieldTypeDate",
     "alias": "UserDate5",
     "length": 8,
     "domain": null
    },
    {
     "name": "NotesName",
     "type": "esriFieldTypeString",
     "alias": "NotesName",
     "length": 255,
     "domain": null
    },
    {
     "name": "NotesRecap",
     "type": "esriFieldTypeString",
     "alias": "NotesRecap",
     "length": 350,
     "domain": null
    },
    {
     "name": "UserSelectionValue",
     "type": "esriFieldTypeString",
     "alias": "UserSelectionValue",
     "length": 255,
     "domain": null
    },
    {
     "name": "PropertyNote",
     "type": "esriFieldTypeString",
     "alias": "PropertyNote",
     "length": 1000,
     "domain": null
    },
    {
     "name": "Shape",
     "type": "esriFieldTypeGeometry",
     "alias": "Shape",
     "domain": null
    },
    {
     "name": "Shape.STArea()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STArea()",
     "domain": null
    },
    {
     "name": "Shape.STLength()",
     "type": "esriFieldTypeDouble",
     "alias": "Shape.STLength()",
     "domain": null
    }
   ],
   "geometryField": {
    "name": "Shape",
    "type": "esriFieldTypeGeometry",
    "alias": "Shape"
   },
   "indexes": [
    {
     "name": "R470_pk",
     "fields": "OBJECTID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    },
    {
     "name": "S420_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": 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,
    "supportsPagination": true,
    "supportsLod": false,
    "supportsQueryWithLodSR": false,
    "supportsTrueCurve": true,
    "supportsQueryWithDatumTransformation": true,
    "supportsReturningQueryExtent": true,
    "supportsQueryWithDistance": true,
    "supportsSqlExpression": true,
    "supportsTimeRelation": true,
    "supportsSqlFormat": false,
    "supportsQueryAnalytic": 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"
   },
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   },
   "supportsCoordinatesQuantization": true,
   "supportsDynamicLegends": true
  }
 ],
 "tables": [
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 2,
   "name": "CAEEngineeringLookup.dbo.vw_AllContractInfo",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "CategoryName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 50,
     "domain": null
    },
    {
     "name": "CategoryName",
     "type": "esriFieldTypeString",
     "alias": "CategoryName",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractName",
     "type": "esriFieldTypeString",
     "alias": "ContractName",
     "length": 255,
     "domain": null
    },
    {
     "name": "Department",
     "type": "esriFieldTypeString",
     "alias": "Department",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractSignedDate",
     "type": "esriFieldTypeDate",
     "alias": "ContractSignedDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ExpirationDate",
     "type": "esriFieldTypeDate",
     "alias": "ExpirationDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "LastRevised",
     "type": "esriFieldTypeDate",
     "alias": "LastRevised",
     "length": 8,
     "domain": null
    },
    {
     "name": "ReviewBy",
     "type": "esriFieldTypeDate",
     "alias": "ReviewBy",
     "length": 8,
     "domain": null
    },
    {
     "name": "POReq",
     "type": "esriFieldTypeString",
     "alias": "POReq",
     "length": 100,
     "domain": null
    },
    {
     "name": "CompanyNameWith",
     "type": "esriFieldTypeString",
     "alias": "CompanyNameWith",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectName",
     "type": "esriFieldTypeString",
     "alias": "ProjectName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CityJobNumber",
     "type": "esriFieldTypeString",
     "alias": "CityJobNumber",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectCode",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField4",
     "type": "esriFieldTypeString",
     "alias": "UserField4",
     "length": 255,
     "domain": null
    },
    {
     "name": "AwardedDesignContract",
     "type": "esriFieldTypeString",
     "alias": "AwardedDesignContract",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompleteDesign",
     "type": "esriFieldTypeString",
     "alias": "CompleteDesign",
     "length": 255,
     "domain": null
    },
    {
     "name": "BeginConstruction",
     "type": "esriFieldTypeString",
     "alias": "BeginConstruction",
     "length": 255,
     "domain": null
    },
    {
     "name": "Advertise",
     "type": "esriFieldTypeString",
     "alias": "Advertise",
     "length": 255,
     "domain": null
    },
    {
     "name": "BidOpen",
     "type": "esriFieldTypeString",
     "alias": "BidOpen",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField10",
     "type": "esriFieldTypeString",
     "alias": "UserField10",
     "length": 255,
     "domain": null
    },
    {
     "name": "PropertyDate",
     "type": "esriFieldTypeDate",
     "alias": "PropertyDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PropertyValue",
     "type": "esriFieldTypeString",
     "alias": "PropertyValue",
     "length": 255,
     "domain": null
    },
    {
     "name": "MonetaryValue",
     "type": "esriFieldTypeDouble",
     "alias": "MonetaryValue",
     "domain": null
    },
    {
     "name": "PropertyName",
     "type": "esriFieldTypeString",
     "alias": "PropertyName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompanyName",
     "type": "esriFieldTypeString",
     "alias": "CompanyName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CouncilDate",
     "type": "esriFieldTypeDate",
     "alias": "CouncilDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProfLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "ProfLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "GenLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "GenLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "PerformanceBondExpDate",
     "type": "esriFieldTypeDate",
     "alias": "PerformanceBondExpDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "UserDate5",
     "type": "esriFieldTypeDate",
     "alias": "UserDate5",
     "length": 8,
     "domain": null
    },
    {
     "name": "NotesName",
     "type": "esriFieldTypeString",
     "alias": "NotesName",
     "length": 255,
     "domain": null
    },
    {
     "name": "NotesRecap",
     "type": "esriFieldTypeString",
     "alias": "NotesRecap",
     "length": 350,
     "domain": null
    },
    {
     "name": "UserSelectionValue",
     "type": "esriFieldTypeString",
     "alias": "UserSelectionValue",
     "length": 255,
     "domain": null
    },
    {
     "name": "PropertyNote",
     "type": "esriFieldTypeString",
     "alias": "PropertyNote",
     "length": 1000,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 3,
   "name": "CAEEngineeringLookup.dbo.vw_Catagory",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "ContractName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "ContractName",
     "type": "esriFieldTypeString",
     "alias": "ContractName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CategoryName",
     "type": "esriFieldTypeString",
     "alias": "CategoryName",
     "length": 100,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 4,
   "name": "CAEEngineeringLookup.dbo.vw_ContractWithNotes",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "CategoryName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 50,
     "domain": null
    },
    {
     "name": "CategoryName",
     "type": "esriFieldTypeString",
     "alias": "CategoryName",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractName",
     "type": "esriFieldTypeString",
     "alias": "ContractName",
     "length": 255,
     "domain": null
    },
    {
     "name": "Department",
     "type": "esriFieldTypeString",
     "alias": "Department",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractSignedDate",
     "type": "esriFieldTypeDate",
     "alias": "ContractSignedDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ExpirationDate",
     "type": "esriFieldTypeDate",
     "alias": "ExpirationDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "LastRevised",
     "type": "esriFieldTypeDate",
     "alias": "LastRevised",
     "length": 8,
     "domain": null
    },
    {
     "name": "ReviewBy",
     "type": "esriFieldTypeDate",
     "alias": "ReviewBy",
     "length": 8,
     "domain": null
    },
    {
     "name": "POReq",
     "type": "esriFieldTypeString",
     "alias": "POReq",
     "length": 100,
     "domain": null
    },
    {
     "name": "CompanyNameWith",
     "type": "esriFieldTypeString",
     "alias": "CompanyNameWith",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectName",
     "type": "esriFieldTypeString",
     "alias": "ProjectName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CityJobNumber",
     "type": "esriFieldTypeString",
     "alias": "CityJobNumber",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectCode",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField4",
     "type": "esriFieldTypeString",
     "alias": "UserField4",
     "length": 255,
     "domain": null
    },
    {
     "name": "AwardedDesignContract",
     "type": "esriFieldTypeString",
     "alias": "AwardedDesignContract",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompleteDesign",
     "type": "esriFieldTypeString",
     "alias": "CompleteDesign",
     "length": 255,
     "domain": null
    },
    {
     "name": "BeginConstruction",
     "type": "esriFieldTypeString",
     "alias": "BeginConstruction",
     "length": 255,
     "domain": null
    },
    {
     "name": "Advertise",
     "type": "esriFieldTypeString",
     "alias": "Advertise",
     "length": 255,
     "domain": null
    },
    {
     "name": "BidOpen",
     "type": "esriFieldTypeString",
     "alias": "BidOpen",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField10",
     "type": "esriFieldTypeString",
     "alias": "UserField10",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompanyName",
     "type": "esriFieldTypeString",
     "alias": "CompanyName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CouncilDate",
     "type": "esriFieldTypeDate",
     "alias": "CouncilDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProfLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "ProfLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "GenLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "GenLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "PerformanceBondExpDate",
     "type": "esriFieldTypeDate",
     "alias": "PerformanceBondExpDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "UserDate5",
     "type": "esriFieldTypeDate",
     "alias": "UserDate5",
     "length": 8,
     "domain": null
    },
    {
     "name": "NotesName",
     "type": "esriFieldTypeString",
     "alias": "NotesName",
     "length": 255,
     "domain": null
    },
    {
     "name": "NotesRecap",
     "type": "esriFieldTypeString",
     "alias": "NotesRecap",
     "length": 350,
     "domain": null
    },
    {
     "name": "NotesSequence",
     "type": "esriFieldTypeString",
     "alias": "NotesSequence",
     "length": 100,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 5,
   "name": "CAEEngineeringLookup.dbo.vw_ContractWithUserSelectionFields",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "CategoryName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "Status",
     "type": "esriFieldTypeString",
     "alias": "Status",
     "length": 50,
     "domain": null
    },
    {
     "name": "CategoryName",
     "type": "esriFieldTypeString",
     "alias": "CategoryName",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractName",
     "type": "esriFieldTypeString",
     "alias": "ContractName",
     "length": 255,
     "domain": null
    },
    {
     "name": "Department",
     "type": "esriFieldTypeString",
     "alias": "Department",
     "length": 100,
     "domain": null
    },
    {
     "name": "ContractSignedDate",
     "type": "esriFieldTypeDate",
     "alias": "ContractSignedDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ExpirationDate",
     "type": "esriFieldTypeDate",
     "alias": "ExpirationDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "LastRevised",
     "type": "esriFieldTypeDate",
     "alias": "LastRevised",
     "length": 8,
     "domain": null
    },
    {
     "name": "ReviewBy",
     "type": "esriFieldTypeDate",
     "alias": "ReviewBy",
     "length": 8,
     "domain": null
    },
    {
     "name": "POReq",
     "type": "esriFieldTypeString",
     "alias": "POReq",
     "length": 100,
     "domain": null
    },
    {
     "name": "CompanyNameWith",
     "type": "esriFieldTypeString",
     "alias": "CompanyNameWith",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectName",
     "type": "esriFieldTypeString",
     "alias": "ProjectName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CityJobNumber",
     "type": "esriFieldTypeString",
     "alias": "CityJobNumber",
     "length": 255,
     "domain": null
    },
    {
     "name": "ProjectCode",
     "type": "esriFieldTypeString",
     "alias": "ProjectCode",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField4",
     "type": "esriFieldTypeString",
     "alias": "UserField4",
     "length": 255,
     "domain": null
    },
    {
     "name": "AwardedDesignContract",
     "type": "esriFieldTypeString",
     "alias": "AwardedDesignContract",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompleteDesign",
     "type": "esriFieldTypeString",
     "alias": "CompleteDesign",
     "length": 255,
     "domain": null
    },
    {
     "name": "BeginConstruction",
     "type": "esriFieldTypeString",
     "alias": "BeginConstruction",
     "length": 255,
     "domain": null
    },
    {
     "name": "Advertise",
     "type": "esriFieldTypeString",
     "alias": "Advertise",
     "length": 255,
     "domain": null
    },
    {
     "name": "BidOpen",
     "type": "esriFieldTypeString",
     "alias": "BidOpen",
     "length": 255,
     "domain": null
    },
    {
     "name": "UserField10",
     "type": "esriFieldTypeString",
     "alias": "UserField10",
     "length": 255,
     "domain": null
    },
    {
     "name": "CompanyName",
     "type": "esriFieldTypeString",
     "alias": "CompanyName",
     "length": 255,
     "domain": null
    },
    {
     "name": "CouncilDate",
     "type": "esriFieldTypeDate",
     "alias": "CouncilDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "ProfLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "ProfLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "GenLiabilityIns",
     "type": "esriFieldTypeDate",
     "alias": "GenLiabilityIns",
     "length": 8,
     "domain": null
    },
    {
     "name": "PerformanceBondExpDate",
     "type": "esriFieldTypeDate",
     "alias": "PerformanceBondExpDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "UserDate5",
     "type": "esriFieldTypeDate",
     "alias": "UserDate5",
     "length": 8,
     "domain": null
    },
    {
     "name": "UserSelectionType",
     "type": "esriFieldTypeString",
     "alias": "UserSelectionType",
     "length": 24,
     "domain": null
    },
    {
     "name": "UserSelectionValue",
     "type": "esriFieldTypeString",
     "alias": "UserSelectionValue",
     "length": 255,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 6,
   "name": "CAEEngineeringLookup.dbo.vw_KeyElements",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "PropertyDate",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "PropertyDate",
     "type": "esriFieldTypeDate",
     "alias": "PropertyDate",
     "length": 8,
     "domain": null
    },
    {
     "name": "PropertyValue",
     "type": "esriFieldTypeString",
     "alias": "PropertyValue",
     "length": 255,
     "domain": null
    },
    {
     "name": "MonetaryValue",
     "type": "esriFieldTypeDouble",
     "alias": "MonetaryValue",
     "domain": null
    },
    {
     "name": "PropertyNote",
     "type": "esriFieldTypeString",
     "alias": "PropertyNote",
     "length": 1000,
     "domain": null
    },
    {
     "name": "SumInto",
     "type": "esriFieldTypeInteger",
     "alias": "SumInto",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 7,
   "name": "CAEEngineeringLookup.dbo.vw_Notes",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "ContractName",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "ContractName",
     "type": "esriFieldTypeString",
     "alias": "ContractName",
     "length": 255,
     "domain": null
    },
    {
     "name": "NotesName",
     "type": "esriFieldTypeString",
     "alias": "NotesName",
     "length": 255,
     "domain": null
    },
    {
     "name": "NotesRecap",
     "type": "esriFieldTypeString",
     "alias": "NotesRecap",
     "length": 350,
     "domain": null
    },
    {
     "name": "NotesSequence",
     "type": "esriFieldTypeString",
     "alias": "NotesSequence",
     "length": 100,
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  },
  {
   "currentVersion": 10.91,
   "cimVersion": "2.9.0",
   "id": 8,
   "name": "CAEEngineeringLookup.dbo.vw_UserSelections",
   "type": "Table",
   "description": null,
   "hasAttachments": false,
   "htmlPopupType": "esriServerHTMLPopupTypeNone",
   "displayField": "UserSelectionType",
   "typeIdField": null,
   "subtypeFieldName": null,
   "subtypeField": null,
   "defaultSubtypeCode": null,
   "fields": [
    {
     "name": "ContractID",
     "type": "esriFieldTypeOID",
     "alias": "ContractID",
     "domain": null
    },
    {
     "name": "UserSelectionType",
     "type": "esriFieldTypeString",
     "alias": "UserSelectionType",
     "length": 24,
     "domain": null
    },
    {
     "name": "UserSelectionValue",
     "type": "esriFieldTypeString",
     "alias": "UserSelectionValue",
     "length": 255,
     "domain": null
    },
    {
     "name": "Expr1",
     "type": "esriFieldTypeInteger",
     "alias": "Expr1",
     "domain": null
    }
   ],
   "indexes": [
    {
     "name": "FDO_ContractID",
     "fields": "ContractID",
     "isAscending": true,
     "isUnique": true,
     "description": ""
    }
   ],
   "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": false
   },
   "dateFieldsTimeReference": null,
   "preferredTimeReference": null,
   "datesInUnknownTimezone": false,
   "hasMetadata": true,
   "isDataArchived": false,
   "archivingInfo": {
    "supportsQueryWithHistoricMoment": false,
    "startArchivingMoment": -1
   }
  }
 ]
}