{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 10, "name": "Outfall_Inspections", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Outfall", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "Outfall_ID", "composite": false, "catalogID": "{69C1FC5B-EA1F-4F7A-9BF5-30EDDD9C4629}" } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "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, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Date", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Receiving_Waterbody", "type": "esriFieldTypeString", "alias": "Receiving Waterbody", "domain": { "type": "codedValue", "name": "SW_Receiving_Water_Body", "description": "", "codedValues": [ { "name": "Black Crook Creek", "code": "Black Crook Creek" }, { "name": "Timber Creek", "code": "Timber Creek" }, { "name": "Walnut River", "code": "Walnut River" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": "Other", "modelName": "Receiving_Waterbody" }, { "name": "Approx_Temp", "type": "esriFieldTypeInteger", "alias": "Approx Temp", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Approx_Temp" }, { "name": "Wind_Present", "type": "esriFieldTypeString", "alias": "Wind Present?", "domain": { "type": "codedValue", "name": "Yes/No", "description": "Text", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "Yes", "modelName": "Wind_Present" }, { "name": "Precipitation_In_Past_3_Days", "type": "esriFieldTypeString", "alias": "Precipitation in the past 3 days", "domain": { "type": "codedValue", "name": "Yes/No", "description": "Text", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "No", "modelName": "Precipitation_In_Past_3_Days" }, { "name": "Precipitation_Amount_Inches", "type": "esriFieldTypeDouble", "alias": "Precipitation Amount - Inches", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Precipitation_Amount_Inches" }, { "name": "Pipe_Flow", "type": "esriFieldTypeString", "alias": "Pipe Flow", "domain": { "type": "codedValue", "name": "SW_Flow", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Trickle", "code": "Trickle" }, { "name": "Steady", "code": "Steady" }, { "name": "1/4 pipe flow or more", "code": "1/4 pipe flow or more" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "None", "modelName": "Pipe_Flow" }, { "name": "Seepage_Flow", "type": "esriFieldTypeString", "alias": "Seepage Flow", "domain": { "type": "codedValue", "name": "SW_Flow", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Trickle", "code": "Trickle" }, { "name": "Steady", "code": "Steady" }, { "name": "1/4 pipe flow or more", "code": "1/4 pipe flow or more" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "None", "modelName": "Seepage_Flow" }, { "name": "Flow_Color", "type": "esriFieldTypeString", "alias": "Color (if flow is present)", "domain": { "type": "codedValue", "name": "SW_Flow_Color", "description": "", "codedValues": [ { "name": "Brown", "code": "Brown" }, { "name": "Clear", "code": "Clear" }, { "name": "Green", "code": "Green" }, { "name": "No Flow", "code": "No Flow" }, { "name": "Red", "code": "Red" }, { "name": "White", "code": "White" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "No Flow", "modelName": "Flow_Color" }, { "name": "Obv_Debris_Pollution_None", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - None", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Obv_Debris_Pollution_None" }, { "name": "Obv_Debris_Pollution_Foam", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - Foam", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Obv_Debris_Pollution_Foam" }, { "name": "Obv_Debris_Pollution_Green_Scum", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - Floating Green Scum", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Obv_Debris_Pollution_Green_Scum" }, { "name": "Obv_Debris_Pollution_Oil_Film", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - Oil/Film", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Obv_Debris_Pollution_Oil_Film" }, { "name": "Obv_Debris_Pollution_Veg_Mat", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - Vegative Mat", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Obv_Debris_Pollution_Veg_Mat" }, { "name": "Obv_Debris_Pollution_Sew_Solids", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - Sewage Solids", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Obv_Debris_Pollution_Sew_Solids" }, { "name": "Odor_None", "type": "esriFieldTypeSmallInteger", "alias": "Odor - None", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Odor_None" }, { "name": "Odor_Musty", "type": "esriFieldTypeSmallInteger", "alias": "Odor - Musty", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Odor_Musty" }, { "name": "Odor_Sewage", "type": "esriFieldTypeSmallInteger", "alias": "Odor - Sewage", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Odor_Sewage" }, { "name": "Water_Clarity_Clear", "type": "esriFieldTypeSmallInteger", "alias": "Water Clarity - Clear", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "Water_Clarity_Clear" }, { "name": "Water_Clarity_Cloudy", "type": "esriFieldTypeSmallInteger", "alias": "Water Clarity - Cloudy", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Water_Clarity_Cloudy" }, { "name": "Water_Clarity_Opaque", "type": "esriFieldTypeSmallInteger", "alias": "Water Clarity - Opaque", "domain": { "type": "codedValue", "name": "BooleanSymbolValue", "description": "Valid values are Yes and No.", "codedValues": [ { "name": "Yes", "code": 1 }, { "name": "No", "code": 0 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "defaultValue": 0, "modelName": "Water_Clarity_Opaque" }, { "name": "Obv_Debris_Pollution_Total", "type": "esriFieldTypeSmallInteger", "alias": "Obvious Debris/Pollution - Total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Obv_Debris_Pollution_Total" }, { "name": "Odor_Total", "type": "esriFieldTypeSmallInteger", "alias": "Odor - Total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Odor_Total" }, { "name": "Water_Clarity_Total", "type": "esriFieldTypeSmallInteger", "alias": "Water Clarity -Total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Water_Clarity_Total" }, { "name": "Grand_Total", "type": "esriFieldTypeSmallInteger", "alias": "Grand Total", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Grand_Total" }, { "name": "Sediment_Conditions", "type": "esriFieldTypeString", "alias": "Sediment Conditions", "domain": { "type": "codedValue", "name": "SW_Sediment_Condition", "description": "", "codedValues": [ { "name": "Open", "code": "Open" }, { "name": "1/4 Full", "code": "1/4 Full" }, { "name": "1/2 Full", "code": "1/2 Full" }, { "name": "3/4 Full", "code": "3/4 Full" }, { "name": "Plugged", "code": "Plugged" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Open", "modelName": "Sediment_Conditions" }, { "name": "Structure_Conditions", "type": "esriFieldTypeString", "alias": "Structure Conditions", "domain": { "type": "codedValue", "name": "SW_Structure_Condition", "description": "", "codedValues": [ { "name": "Excellent", "code": "Excellent" }, { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Good", "modelName": "Structure_Conditions" }, { "name": "Trash_Litter_Present", "type": "esriFieldTypeString", "alias": "Trash or Litter Present?", "domain": { "type": "codedValue", "name": "Yes/No", "description": "Text", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "No", "modelName": "Trash_Litter_Present" }, { "name": "Yard_Waste_Observed", "type": "esriFieldTypeString", "alias": "Yard Waste Observed?", "domain": { "type": "codedValue", "name": "Yes/No", "description": "Text", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "No", "modelName": "Yard_Waste_Observed" }, { "name": "General_Comments", "type": "esriFieldTypeString", "alias": "General Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "General_Comments" }, { "name": "Potential_Sources_Action_Taken", "type": "esriFieldTypeString", "alias": "Potential Sources / Action Taken", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Potential_Sources_Action_Taken" }, { "name": "Follow_Up_Required", "type": "esriFieldTypeString", "alias": "Follow up required?", "domain": { "type": "codedValue", "name": "Yes/No", "description": "Text", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unk", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": "No", "modelName": "Follow_Up_Required" }, { "name": "Outfall_ID", "type": "esriFieldTypeSmallInteger", "alias": "Outfall ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Outfall_ID" }, { "name": "Photo_Name", "type": "esriFieldTypeString", "alias": "Photo Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Photo_Name" }, { "name": "Date", "type": "esriFieldTypeDate", "alias": "Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": { "type": "codedValue", "name": "SW_Inspector", "description": "", "codedValues": [ { "name": "KRK", "code": "KRK" }, { "name": "JMS", "code": "JMS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "KRK", "modelName": "Inspector" }, { "name": "Photo", "type": "esriFieldTypeString", "alias": "Photo", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Photo" }, { "name": "Weather", "type": "esriFieldTypeString", "alias": "Weather", "domain": { "type": "codedValue", "name": "SW_Weather", "description": "", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Cloudy", "code": "Cloudy" }, { "name": "Partly Cloudy", "code": "Partly Cloudy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": "Partly Cloudy", "modelName": "Weather" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" } ], "indexes": [ { "name": "R228_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G322Outfall_ID", "fields": "Outfall_ID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_228", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_228", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Outfall_Inspections", "description": "", "prototype": { "attributes": { "Weather": "Partly Cloudy", "Photo": null, "Receiving_Waterbody": "Other", "Approx_Temp": null, "Wind_Present": "Yes", "Precipitation_In_Past_3_Days": "No", "Precipitation_Amount_Inches": null, "Pipe_Flow": "None", "Seepage_Flow": "None", "Flow_Color": "No Flow", "Obv_Debris_Pollution_None": 1, "Obv_Debris_Pollution_Foam": 0, "Obv_Debris_Pollution_Green_Scum": 0, "Obv_Debris_Pollution_Oil_Film": 0, "Obv_Debris_Pollution_Veg_Mat": 0, "Obv_Debris_Pollution_Sew_Solids": 0, "Odor_None": 1, "Odor_Musty": 0, "Odor_Sewage": 0, "Water_Clarity_Clear": 1, "Water_Clarity_Cloudy": 0, "Water_Clarity_Opaque": 0, "Obv_Debris_Pollution_Total": null, "Odor_Total": null, "Water_Clarity_Total": null, "Grand_Total": null, "Sediment_Conditions": "Open", "Structure_Conditions": "Good", "Trash_Litter_Present": "No", "Yard_Waste_Observed": "No", "General_Comments": null, "Potential_Sources_Action_Taken": null, "Follow_Up_Required": "No", "Outfall_ID": null, "Photo_Name": null, "Date": null, "Inspector": "KRK" } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "a1134ac33aed4992a69e4f8d08da3d4b" }