{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "Project Data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "RoadName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ProjectID", "type": "esriFieldTypeOID", "alias": "ProjectID", "domain": null }, { "name": "InventoryID", "type": "esriFieldTypeString", "alias": "InventoryID", "length": 255, "domain": null }, { "name": "ParentProjectNum", "type": "esriFieldTypeInteger", "alias": "ParentProjectNum", "domain": null }, { "name": "oldprojnum", "type": "esriFieldTypeString", "alias": "oldprojnum", "length": 255, "domain": null }, { "name": "ALDOTProjNum", "type": "esriFieldTypeString", "alias": "ALDOTProjNum", "length": 255, "domain": null }, { "name": "MunisProjNum", "type": "esriFieldTypeString", "alias": "MunisProjNum", "length": 255, "domain": null }, { "name": "ProjectDesc", "type": "esriFieldTypeString", "alias": "ProjectDesc", "length": 255, "domain": null }, { "name": "work_From", "type": "esriFieldTypeString", "alias": "work_From", "length": 255, "domain": null }, { "name": "work_To", "type": "esriFieldTypeString", "alias": "work_To", "length": 255, "domain": null }, { "name": "BridgeID", "type": "esriFieldTypeString", "alias": "BridgeID", "length": 255, "domain": null }, { "name": "MaintenanceDistrict", "type": "esriFieldTypeInteger", "alias": "MaintenanceDistrict", "domain": null }, { "name": "CommissionDistrict", "type": "esriFieldTypeInteger", "alias": "CommissionDistrict", "domain": null }, { "name": "Territory", "type": "esriFieldTypeInteger", "alias": "Territory", "domain": null }, { "name": "Length_mi", "type": "esriFieldTypeString", "alias": "Length_mi", "length": 255, "domain": null }, { "name": "Width_ft", "type": "esriFieldTypeString", "alias": "Width_ft", "length": 255, "domain": null }, { "name": "PE_Req_y_n", "type": "esriFieldTypeSmallInteger", "alias": "PE_Req_y_n", "domain": null }, { "name": "ROW_Req_Y_N", "type": "esriFieldTypeSmallInteger", "alias": "ROW_Req_Y_N", "domain": null }, { "name": "UtilityConflictsY_N", "type": "esriFieldTypeSmallInteger", "alias": "UtilityConflictsY_N", "domain": null }, { "name": "PvmtGrdPriortoPaving", "type": "esriFieldTypeString", "alias": "PvmtGrdPriortoPaving", "length": 255, "domain": null }, { "name": "ConstructLETDate", "type": "esriFieldTypeDate", "alias": "ConstructLETDate", "length": 8, "domain": null }, { "name": "PE_Estimate", "type": "esriFieldTypeDouble", "alias": "PE_Estimate", "domain": null }, { "name": "ROW_Estimate", "type": "esriFieldTypeDouble", "alias": "ROW_Estimate", "domain": null }, { "name": "Utilities_Estimate", "type": "esriFieldTypeDouble", "alias": "Utilities_Estimate", "domain": null }, { "name": "Construction_Estimate", "type": "esriFieldTypeDouble", "alias": "Construction_Estimate", "domain": null }, { "name": "CEI_Estimate", "type": "esriFieldTypeDouble", "alias": "CEI_Estimate", "domain": null }, { "name": "Labor_Estimate", "type": "esriFieldTypeDouble", "alias": "Labor_Estimate", "domain": null }, { "name": "Equip_Estimate", "type": "esriFieldTypeDouble", "alias": "Equip_Estimate", "domain": null }, { "name": "Materials_Estimate", "type": "esriFieldTypeDouble", "alias": "Materials_Estimate", "domain": null }, { "name": "Contract_Estimate", "type": "esriFieldTypeDouble", "alias": "Contract_Estimate", "domain": null }, { "name": "ProjectNumberTxt", "type": "esriFieldTypeString", "alias": "ProjectNumberTxt", "length": 255, "domain": null }, { "name": "RoadName", "type": "esriFieldTypeString", "alias": "RoadName", "length": 255, "domain": null }, { "name": "Status", "type": "esriFieldTypeInteger", "alias": "Status", "domain": null }, { "name": "ProjectType", "type": "esriFieldTypeInteger", "alias": "ProjectType", "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "CREATED_BY", "length": 100, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "length": 8, "domain": null }, { "name": "MODIFIED_DATE", "type": "esriFieldTypeDate", "alias": "MODIFIED_DATE", "length": 8, "domain": null }, { "name": "MODIFIED_BY", "type": "esriFieldTypeString", "alias": "MODIFIED_BY", "length": 100, "domain": null }, { "name": "ProjectTypeNew", "type": "esriFieldTypeString", "alias": "ProjectTypeNew", "length": 255, "domain": null }, { "name": "ProjectName", "type": "esriFieldTypeString", "alias": "ProjectName", "length": 255, "domain": null }, { "name": "Project_Purpose", "type": "esriFieldTypeString", "alias": "Project_Purpose", "length": 1073741822, "domain": null }, { "name": "ClearGov", "type": "esriFieldTypeSmallInteger", "alias": "ClearGov", "domain": null }, { "name": "projectScope", "type": "esriFieldTypeString", "alias": "projectScope", "length": 1073741822, "domain": null }, { "name": "projectDescription", "type": "esriFieldTypeString", "alias": "projectDescription", "length": 1073741822, "domain": null } ], "indexes": null, "subtypes": [], "relationships": [], "capabilities": "Query,Map,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 }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "7a0aaea1e54d4926a0eeaef80178343c" }