{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Outfall Inspections", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ReviewerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "PrimaryInspector", "type": "esriFieldTypeString", "alias": "Primary Inspector", "length": 50, "domain": { "type": "codedValue", "name": "D5Inspectors", "description": "D5Inspectors", "codedValues": [ { "name": "Robert Potts", "code": "Robert Potts" }, { "name": "Andrew Allan", "code": "Andrew Allan" }, { "name": "Craig Eudell", "code": "Craig Eudell" }, { "name": "Leilani Ferrell", "code": "Leilani Ferrell" }, { "name": "Esteban Lopez", "code": "Esteban Lopez" }, { "name": "Edward Northey", "code": "Edward Northey" }, { "name": "Emily Rogers", "code": "Emily Rogers" }, { "name": "Lisa Bally", "code": "Lisa Bally" }, { "name": "Jennifer Cappelleti", "code": "Jennifer Cappelleti" }, { "name": "Daryl Meyers", "code": "Daryl Myers" }, { "name": "Brian McKee", "code": "Brian McKee" }, { "name": "Dustin Hampton", "code": "Dustin Hampton" }, { "name": "Chris Thompson", "code": "Chris Thompson" }, { "name": "Carlos Colon", "code": "Carlos Colon" }, { "name": "Richard Wawrzyniak", "code": "Richard Wawrzyniak" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SecondaryInspector", "type": "esriFieldTypeString", "alias": "Secondary Inspector", "length": 50, "domain": { "type": "codedValue", "name": "D5Inspectors", "description": "D5Inspectors", "codedValues": [ { "name": "Robert Potts", "code": "Robert Potts" }, { "name": "Andrew Allan", "code": "Andrew Allan" }, { "name": "Craig Eudell", "code": "Craig Eudell" }, { "name": "Leilani Ferrell", "code": "Leilani Ferrell" }, { "name": "Esteban Lopez", "code": "Esteban Lopez" }, { "name": "Edward Northey", "code": "Edward Northey" }, { "name": "Emily Rogers", "code": "Emily Rogers" }, { "name": "Lisa Bally", "code": "Lisa Bally" }, { "name": "Jennifer Cappelleti", "code": "Jennifer Cappelleti" }, { "name": "Daryl Meyers", "code": "Daryl Myers" }, { "name": "Brian McKee", "code": "Brian McKee" }, { "name": "Dustin Hampton", "code": "Dustin Hampton" }, { "name": "Chris Thompson", "code": "Chris Thompson" }, { "name": "Carlos Colon", "code": "Carlos Colon" }, { "name": "Richard Wawrzyniak", "code": "Richard Wawrzyniak" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WeatherCondition", "type": "esriFieldTypeString", "alias": "Weather Condition", "length": 64, "domain": null }, { "name": "DateLastPrecipitation", "type": "esriFieldTypeDate", "alias": "Date Last Precipitation", "length": 8, "domain": null }, { "name": "QuantityLastPrecipitation", "type": "esriFieldTypeDouble", "alias": "Quantity of Precipitation (inches)", "domain": null }, { "name": "InspectionType", "type": "esriFieldTypeString", "alias": "Inspection Type", "length": 50, "domain": { "type": "codedValue", "name": "InspectionType", "description": "Inspection Types", "codedValues": [ { "name": "Routine", "code": "Routine" }, { "name": "Annual", "code": "Annual" }, { "name": "Return - Field Inspection", "code": "Return - Field Inspection" }, { "name": "Return - Desktop Inspection", "code": "Return - Desktop Inspection" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AestheticsCondition", "type": "esriFieldTypeString", "alias": "Aesthetics Condition", "length": 50, "domain": { "type": "codedValue", "name": "Ratings", "description": "Ratings", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AestheticsComments", "type": "esriFieldTypeString", "alias": "Aesthetics Comments", "length": 1073741822, "domain": null }, { "name": "ErosionUnderminingCondition", "type": "esriFieldTypeString", "alias": "Erosion / Undermining Condition", "length": 50, "domain": { "type": "codedValue", "name": "Ratings", "description": "Ratings", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ErosionUnderminingComments", "type": "esriFieldTypeString", "alias": "Erosion / Undermining Comments", "length": 1073741822, "domain": null }, { "name": "StructuralCondition", "type": "esriFieldTypeString", "alias": "Structural Condition", "length": 50, "domain": { "type": "codedValue", "name": "Ratings", "description": "Ratings", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructuralComments", "type": "esriFieldTypeString", "alias": "Structural Comments", "length": 1073741822, "domain": null }, { "name": "SedimentAccumulation", "type": "esriFieldTypeString", "alias": "Sediment Accumulation", "length": 50, "domain": { "type": "codedValue", "name": "Ratings", "description": "Ratings", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SedimentAccumulationComments", "type": "esriFieldTypeString", "alias": "Sediment Accumulation Comments", "length": 1073741822, "domain": null }, { "name": "VegetationCondition", "type": "esriFieldTypeString", "alias": "Vegetation Condition", "length": 50, "domain": { "type": "codedValue", "name": "Ratings", "description": "Ratings", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "VegetationComments", "type": "esriFieldTypeString", "alias": "Vegetation Comments", "length": 1073741822, "domain": null }, { "name": "OutfallVisibility", "type": "esriFieldTypeString", "alias": "Outfall Visibility", "length": 50, "domain": { "type": "codedValue", "name": "OutfallInspectionVisibility", "description": "Outfall Inspection Visibility", "codedValues": [ { "name": "Above Surface Water", "code": "Above Surface Water" }, { "name": "Partially Submerged", "code": "Partially Submerged" }, { "name": "Submerged", "code": "Submerged" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OutfallVisibilityComments", "type": "esriFieldTypeString", "alias": "Outfall Visibility Comments", "length": 1073741822, "domain": null }, { "name": "AntiBackflowDevicePresent", "type": "esriFieldTypeString", "alias": "Anti-Backflow Device Present", "length": 4, "domain": { "type": "codedValue", "name": "OutfallAntiBackflow", "description": "Anti Backflow Device Choices", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "AntiBackflowDeviceComments", "type": "esriFieldTypeString", "alias": "Anti-Backflow Device Comments", "length": 1073741822, "domain": null }, { "name": "ManateeGratePresent", "type": "esriFieldTypeString", "alias": "Manatee Grate Present", "length": 4, "domain": { "type": "codedValue", "name": "OutfallManateeGrate", "description": "Manatee Grate Present Choices", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "NA", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ManateeGrateComments", "type": "esriFieldTypeString", "alias": "Manatee Grate Comments", "length": 1073741822, "domain": null }, { "name": "FlowPresent", "type": "esriFieldTypeString", "alias": "Flow Present", "length": 4, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Selections", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlowPresentComments", "type": "esriFieldTypeString", "alias": "Flow Present Comments", "length": 1073741822, "domain": null }, { "name": "FlowCondition", "type": "esriFieldTypeString", "alias": "Flow Condition", "length": 50, "domain": { "type": "codedValue", "name": "Ratings", "description": "Ratings", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlowConditionComments", "type": "esriFieldTypeString", "alias": "Flow Condition Comments", "length": 1073741822, "domain": null }, { "name": "IllicitDischargePresent", "type": "esriFieldTypeString", "alias": "Illicit Discharge Present", "length": 4, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Selections", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IllicitDischargeComments", "type": "esriFieldTypeString", "alias": "Illicit Discharge Comments", "length": 1073741822, "domain": null }, { "name": "SafetyHazards", "type": "esriFieldTypeString", "alias": "Safety Hazards", "length": 4, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes No Selections", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SafetyComments", "type": "esriFieldTypeString", "alias": "Safety Hazard Comments", "length": 1073741822, "domain": null }, { "name": "InspectionResult", "type": "esriFieldTypeString", "alias": "Inspection Result", "length": 50, "domain": { "type": "codedValue", "name": "OufallInspectionResult", "description": "Outfall Inspection Result", "codedValues": [ { "name": "Outfall is functioning as designed", "code": "Outfall is functioning as designed" }, { "name": "Outfall is not functioning as designed", "code": "Outfall is not functioning as designed" }, { "name": "Not Applicable", "code": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InspectionResultComments", "type": "esriFieldTypeString", "alias": "Inspection Result Comments", "length": 1073741822, "domain": null }, { "name": "Report", "type": "esriFieldTypeString", "alias": "Report", "length": 1073741822, "domain": null }, { "name": "ReviewerName", "type": "esriFieldTypeString", "alias": "Reviewer Name", "length": 50, "domain": null }, { "name": "ReviewDate", "type": "esriFieldTypeDate", "alias": "Review Date", "length": 8, "domain": null }, { "name": "QAStatus", "type": "esriFieldTypeString", "alias": "QA Status", "length": 20, "domain": { "type": "codedValue", "name": "QAStatus", "description": "QA Status", "codedValues": [ { "name": "Passed", "code": "Passed" }, { "name": "Requires Edits", "code": "Requires Edits" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QAComments", "type": "esriFieldTypeString", "alias": "QA Comments", "length": 1073741822, "domain": null }, { "name": "InspectionReviewNeeded", "type": "esriFieldTypeString", "alias": "Inspection Review Needed", "length": 4, "domain": null }, { "name": "MaintenanceReviewNeeded", "type": "esriFieldTypeString", "alias": "Maintenance Review Needed", "length": 4, "domain": null }, { "name": "Created_User", "type": "esriFieldTypeString", "alias": "Created User", "length": 255, "domain": null }, { "name": "Created_Date", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "Last_Editor", "type": "esriFieldTypeString", "alias": "Last Editor", "length": 255, "domain": null }, { "name": "Last_Edited_Date", "type": "esriFieldTypeDate", "alias": "Last Edited Date", "length": 8, "domain": null }, { "name": "MaintenanceRequired", "type": "esriFieldTypeString", "alias": "Maintenance Required", "length": 4, "domain": null }, { "name": "OrigParentGUIDText", "type": "esriFieldTypeString", "alias": "OrigParentGUIDText", "length": 50, "domain": null }, { "name": "OrigInspectionGUIDText", "type": "esriFieldTypeString", "alias": "OrigInspectionGUIDText", "length": 50, "domain": null }, { "name": "ParentGUID", "type": "esriFieldTypeGUID", "alias": "ParentGUID", "length": 38, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R277_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_3731_ParentG", "fields": "ParentGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_277", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 7, "name": "D5OutfallMaintenanceNeeds", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{807D0A03-72A9-4C66-A4CF-D86E2938BBFE}" }, { "id": 2, "name": "D5Outfalls", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "ParentGUID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{6AC423DE-7C5C-48B5-A49F-E72EADE33D26}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "02d09fe5f6794803b3449ba1df1d8162" }