{ "layers": [], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "OCConstruction.DBO.JOC_Add_Proj_Info", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Budget_BFAST_Num", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Project_Number", "type": "esriFieldTypeDouble", "alias": "Project Number", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Project_Number" }, { "name": "Budget_BFAST_Num", "type": "esriFieldTypeString", "alias": "Budget/BFAST Numbers", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Budget_BFAST_Num" }, { "name": "Cost", "type": "esriFieldTypeDouble", "alias": "Cost of Contrat/% Completed (Prog Pay)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Cost" }, { "name": "Fiscal_Year", "type": "esriFieldTypeString", "alias": "Fiscal Year", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Fiscal_Year" }, { "name": "SWPP_Risk_Level", "type": "esriFieldTypeString", "alias": "SWPP Risk Level", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SWPP_Risk_Level" }, { "name": "Construction_Milestones", "type": "esriFieldTypeString", "alias": "Construction Milestones", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Construction_Milestones" }, { "name": "Development_Milestones", "type": "esriFieldTypeString", "alias": "Development Milestones (PM Section)", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Development_Milestones" }, { "name": "Planning_Initiation_Milestones", "type": "esriFieldTypeString", "alias": "Planning/Initiation Milestones (Engineering Section)", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Planning_Initiation_Milestones" }, { "name": "Project_Status", "type": "esriFieldTypeString", "alias": "Project Status", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "Project_Status" }, { "name": "Jan1_Jan5_18", "type": "esriFieldTypeSingle", "alias": "Jan 1 - Jan 5 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jan1_Jan5_18" }, { "name": "Jan8_Jan12_18", "type": "esriFieldTypeSingle", "alias": "Jan 8 - Jan 12 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jan8_Jan12_18" }, { "name": "Jan15_Jan19_18", "type": "esriFieldTypeSingle", "alias": "Jan 15 - Jan 19 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jan15_Jan19_18" }, { "name": "Jan22_Jan26_18", "type": "esriFieldTypeSingle", "alias": "Jan 22 - Jan 26 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jan22_Jan26_18" }, { "name": "Jan29_Feb2_18", "type": "esriFieldTypeSingle", "alias": "Jan 29 - Feb 2 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jan29_Feb2_18" }, { "name": "Feb5_Feb9_18", "type": "esriFieldTypeSingle", "alias": "Feb 5 - Feb 9 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Feb5__Feb9_18" }, { "name": "Feb12_Feb16_18", "type": "esriFieldTypeSingle", "alias": "Feb12 - Feb 16 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Feb12__Feb16_18" }, { "name": "Feb19_Feb23_18", "type": "esriFieldTypeSingle", "alias": "Feb 19 - Feb 23 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Feb19__Feb23_18" }, { "name": "Feb26_Mar2_18", "type": "esriFieldTypeSingle", "alias": "Feb 26 - Mar 2 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Feb26__Mar2_18" }, { "name": "Mar5_Mar9_18", "type": "esriFieldTypeSingle", "alias": "Mar 5 - Mar 9 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mar5_Mar9_18" }, { "name": "Mar12_Mar16_18", "type": "esriFieldTypeSingle", "alias": "Mar 12 - Mar 16 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mar12_Mar16_18" }, { "name": "Mar19_Mar23_18", "type": "esriFieldTypeSingle", "alias": "Mar 19 - Mar 23 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mar19_Mar23_18" }, { "name": "Mar26_Mar30_18", "type": "esriFieldTypeSingle", "alias": "Mar 26 - Mar 30 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Mar26_Mar30_18" }, { "name": "Apr2_Apr6_18", "type": "esriFieldTypeSingle", "alias": "Apr 2 - Apr 6 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Apr2_Apr6_18" }, { "name": "Apr9_Apr13_18", "type": "esriFieldTypeSingle", "alias": "Apr 9 - Apr 13 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Apr9_Apr13_18" }, { "name": "Apr16_Apr20_18", "type": "esriFieldTypeSingle", "alias": "Apr 16 - Apr 20 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Apr16_Apr20_18" }, { "name": "Apr23_Apr27_18", "type": "esriFieldTypeSingle", "alias": "Apr 23 - Apr 27 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Apr23_Apr27_18" }, { "name": "Apr30_May4_18", "type": "esriFieldTypeSingle", "alias": "Apr 30 - May 4 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Apr30_May4_18" }, { "name": "May7_May11_18", "type": "esriFieldTypeSingle", "alias": "May 7 - May 11 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "May7_May11_18" }, { "name": "May14_May18_18", "type": "esriFieldTypeSingle", "alias": "May 14 - May 18 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "May14_May18_18" }, { "name": "May21_May25_18", "type": "esriFieldTypeSingle", "alias": "May 21 - May 25 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "May21_May25_18" }, { "name": "May28_Jun1_18", "type": "esriFieldTypeSingle", "alias": "May 28 - Jun 1 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "May28_Jun1_18" }, { "name": "Jun4_Jun8_18", "type": "esriFieldTypeSingle", "alias": "Jun 4 - Jun 8 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jun4_Jun8_18" }, { "name": "Jun11_Jun15_18", "type": "esriFieldTypeSingle", "alias": "Jun 11 - Jun 15 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jun11_Jun15_18" }, { "name": "Jun18_Jun22_18", "type": "esriFieldTypeSingle", "alias": "Jun 18 - Jun 22 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jun18_Jun22_18" }, { "name": "Jun25_Jun29_18", "type": "esriFieldTypeSingle", "alias": "Jun 25 - Jun 29 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jun25_Jun29_18" }, { "name": "Jul2_Jul6_18", "type": "esriFieldTypeSingle", "alias": "Jul 2 - Jul 6 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jul2_Jul6_18" }, { "name": "Jul9_Jul13_18", "type": "esriFieldTypeSingle", "alias": "Jul 9 - Jul 13 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jul9_Jul13_18" }, { "name": "Jul16_Jul20_18", "type": "esriFieldTypeSingle", "alias": "Jul 16 - Jul 20 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jul16_Jul20_18" }, { "name": "Jul23_Jul27_18", "type": "esriFieldTypeSingle", "alias": "Jul 23 - Jul 27 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jul23_Jul27_18" }, { "name": "Jul30_Aug3_18", "type": "esriFieldTypeSingle", "alias": "Jul 30 - Aug 3 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Jul30_Aug3_18" }, { "name": "Aug6_Aug10_18", "type": "esriFieldTypeSingle", "alias": "Aug 6 - Aug 10 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Aug6_Aug10_18" }, { "name": "Aug13_Aug17_18", "type": "esriFieldTypeSingle", "alias": "Aug 13 - Aug 17 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Aug13_Aug17_18" }, { "name": "Aug20_Aug24_18", "type": "esriFieldTypeSingle", "alias": "Aug 20 - Aug 24 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Aug20_Aug24_18" }, { "name": "Aug27_Aug31_18", "type": "esriFieldTypeSingle", "alias": "Aug 27 - Aug 31 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Aug27_Aug31_18" }, { "name": "Sep3_Sep7_18", "type": "esriFieldTypeSingle", "alias": "Sep 3 - Sep 7 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sep3_Sep7_18" }, { "name": "Sep10_Sep14_18", "type": "esriFieldTypeSingle", "alias": "Sep 10 - Sep 14 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sep10_Sep14_18" }, { "name": "Sep17_Sep21_18", "type": "esriFieldTypeSingle", "alias": "Sep 17 - Sep 21 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sep17_Sep21_18" }, { "name": "Sep24_Sep28_18", "type": "esriFieldTypeSingle", "alias": "Sep 24 - Sep 28 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sep24_Sep28_18" }, { "name": "Oct1_Oct5_18", "type": "esriFieldTypeSingle", "alias": "Oct 1 - Oct 5 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Oct1_Oct5_18" }, { "name": "Oct8_Oct12_18", "type": "esriFieldTypeSingle", "alias": "Oct 8 - Oct 12 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Oct8_Oct12_18" }, { "name": "Oct15_Oct19_18", "type": "esriFieldTypeSingle", "alias": "Oct 15 - Oct 19 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Oct15_Oct19_18" }, { "name": "Oct22_Oct26_18", "type": "esriFieldTypeSingle", "alias": "Oct 22 - Oct 26 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Oct22_Oct26_18" }, { "name": "Oct29_Nov2_18", "type": "esriFieldTypeSingle", "alias": "Oct 29 - Nov 2 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Oct29_Nov2_18" }, { "name": "Nov5_Nov9_18", "type": "esriFieldTypeSingle", "alias": "Nov 5 - Nov 9 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Nov5_Nov9_18" }, { "name": "Nov12_Nov16_18", "type": "esriFieldTypeSingle", "alias": "Nov 12 - Nov 16 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Nov12_Nov16_18" }, { "name": "Nov19_Nov23_18", "type": "esriFieldTypeSingle", "alias": "Nov 19 - Nov 23 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Nov19_Nov23_18" }, { "name": "Nov26_Nov30_18", "type": "esriFieldTypeSingle", "alias": "Nov 26 - Nov 30 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Nov26_Nov30_18" }, { "name": "Dec3_Dec7_18", "type": "esriFieldTypeSingle", "alias": "Dec 3 - Dec 7 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Dec3_Dec7_18" }, { "name": "Dec10_Dec14_18", "type": "esriFieldTypeSingle", "alias": "Dec 10 - Dec 14 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Dec10_Dec14_18" }, { "name": "Dec17_Dec21_18", "type": "esriFieldTypeSingle", "alias": "Dec 17 - Dec 21 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Dec17_Dec21_18" }, { "name": "Dec24_Dec28_18", "type": "esriFieldTypeSingle", "alias": "Dec 24 - Dec 28 2018", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Dec24_Dec28_18" }, { "name": "Project_Name", "type": "esriFieldTypeString", "alias": "Project Name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "Project_Name" }, { "name": "Cost_1", "type": "esriFieldTypeString", "alias": "Cost_1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Cost_1" }, { "name": "Phase", "type": "esriFieldTypeSmallInteger", "alias": "Phase", "domain": { "type": "codedValue", "name": "Phases", "description": "", "codedValues": [ { "name": "Initial/Planning", "code": 1 }, { "name": "Active Construction/Development", "code": 2 }, { "name": "Closeout", "code": 3 }, { "name": "Litigation", "code": 4 }, { "name": "Mitigation", "code": 5 }, { "name": "Complete", "code": 6 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Phase" }, { "name": "Contractor", "type": "esriFieldTypeString", "alias": "Contractor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Contractor" }, { "name": "Job_Code", "type": "esriFieldTypeString", "alias": "Job_Code", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Job_Code" }, { "name": "District_Project_Sponsor", "type": "esriFieldTypeString", "alias": "District_Project_Sponsor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "District_Project_Sponsor" }, { "name": "PM_INSP", "type": "esriFieldTypeString", "alias": "PM_INSP", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "PM_INSP" }, { "name": "Active_1", "type": "esriFieldTypeSmallInteger", "alias": "Active_1", "domain": { "type": "codedValue", "name": "Yes/No", "description": "", "codedValues": [ { "name": "No", "code": 0 }, { "name": "Yes", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "defaultValue": 1, "modelName": "Active_1" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" } ], "indexes": [ { "name": "R30_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_836_Project_", "fields": "Project_Number", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "OCConstruction.DBO.JOC_Add_Proj_Info", "description": "", "prototype": { "attributes": { "last_edited_user": null, "last_edited_date": null, "Project_Number": null, "Budget_BFAST_Num": null, "Cost": null, "Fiscal_Year": null, "SWPP_Risk_Level": null, "Construction_Milestones": null, "Development_Milestones": null, "Planning_Initiation_Milestones": null, "Project_Status": null, "Jan1_Jan5_18": null, "Jan8_Jan12_18": null, "Jan15_Jan19_18": null, "Jan22_Jan26_18": null, "Jan29_Feb2_18": null, "Feb5_Feb9_18": null, "Feb12_Feb16_18": null, "Feb19_Feb23_18": null, "Feb26_Mar2_18": null, "Mar5_Mar9_18": null, "Mar12_Mar16_18": null, "Mar19_Mar23_18": null, "Mar26_Mar30_18": null, "Apr2_Apr6_18": null, "Apr9_Apr13_18": null, "Apr16_Apr20_18": null, "Apr23_Apr27_18": null, "Apr30_May4_18": null, "May7_May11_18": null, "May14_May18_18": null, "May21_May25_18": null, "May28_Jun1_18": null, "Jun4_Jun8_18": null, "Jun11_Jun15_18": null, "Jun18_Jun22_18": null, "Jun25_Jun29_18": null, "Jul2_Jul6_18": null, "Jul9_Jul13_18": null, "Jul16_Jul20_18": null, "Jul23_Jul27_18": null, "Jul30_Aug3_18": null, "Aug6_Aug10_18": null, "Aug13_Aug17_18": null, "Aug20_Aug24_18": null, "Aug27_Aug31_18": null, "Sep3_Sep7_18": null, "Sep10_Sep14_18": null, "Sep17_Sep21_18": null, "Sep24_Sep28_18": null, "Oct1_Oct5_18": null, "Oct8_Oct12_18": null, "Oct15_Oct19_18": null, "Oct22_Oct26_18": null, "Oct29_Nov2_18": null, "Nov5_Nov9_18": null, "Nov12_Nov16_18": null, "Nov19_Nov23_18": null, "Nov26_Nov30_18": null, "Dec3_Dec7_18": null, "Dec10_Dec14_18": null, "Dec17_Dec21_18": null, "Dec24_Dec28_18": null, "Project_Name": null, "Cost_1": null, "Phase": null, "Contractor": null, "Job_Code": null, "District_Project_Sponsor": null, "PM_INSP": null, "Active_1": 1, "created_user": null, "created_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }