{ "preferredTimeReference": null, "useStandardizedQueries": true, "maxRecordCount": 1000, "description": null, "attachmentProperties": [ { "fieldName": "ATTACHMENTID", "isEnabled": true, "name": "id" }, { "fieldName": "GLOBALID", "isEnabled": true, "name": "globalid" }, { "fieldName": "KEYWORDS", "isEnabled": false, "name": "keywords" }, { "fieldName": "ATT_NAME", "isEnabled": true, "name": "name" }, { "fieldName": "CONTENT_TYPE", "isEnabled": true, "name": "contentType" }, { "fieldName": "DATA_SIZE", "isEnabled": true, "name": "size" }, { "fieldName": "EXIFINFO", "isEnabled": false, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "domain": null, "name": "ATTACHMENTID", "length": 4, "alias": "ATTACHMENTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "domain": null, "name": "GLOBALID", "length": 38, "alias": "GLOBALID", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": true, "domain": null, "name": "ATT_NAME", "length": 250, "alias": "ATT_NAME", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "domain": null, "name": "CONTENT_TYPE", "length": 150, "alias": "CONTENT_TYPE", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "domain": null, "name": "DATA_SIZE", "length": 4, "alias": "DATA_SIZE", "type": "esriFieldTypeInteger" } ], "datesInUnknownTimezone": false, "type": "Table", "subtypes": [], "relationships": [{ "keyField": "FACILITYID", "role": "esriRelRoleDestination", "catalogID": "{0CD9092D-30CC-443A-ABC2-2B29BFD911CA}", "composite": false, "name": "Outfalls", "relatedTableId": 24, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }], "indexes": [ { "name": "R1640_SDE_ROWID_UK", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_1640", "isUnique": false, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "GDB_29773_FACILI", "isUnique": false, "description": "", "fields": "FACILITYID", "isAscending": true }, { "name": "UUID_OID_1640", "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID", "isAscending": true } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "cimVersion": "3.6.0", "isDataArchived": true, "id": 35, "archivingInfo": { "startArchivingMoment": 1612263800000, "supportsQueryWithHistoricMoment": true }, "hasAttachments": true, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsTrueCurve": false, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsQueryWithDistance": true, "supportsQueryAttachmentOrderByFields": true, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsPagination": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "subtypeFieldName": null, "supportsStatistics": true, "capabilities": "Query,Map,Data", "supportsExceedsLimitStatistics": true, "isDataVersioned": true, "supportsAdvancedQueries": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "currentVersion": 12, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, PBF", "name": "OutfallInspectionTable", "displayField": "FACILITYID", "copyrightText": null, "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "INSSTART", "length": 8, "alias": "Start DateTime", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "FACILITYID", "length": 50, "alias": "Facility Identifier", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "DISCOVERED", "length": 30, "alias": "Catchbasin Found", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LOCATION", "length": 20, "alias": "Location", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "Condition", "description": "The condition of the asset", "type": "codedValue", "codedValues": [ { "code": "Excellent", "name": "Excellent" }, { "code": "Very Good", "name": "Very Good" }, { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "Very Poor", "name": "Very Poor" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CONDITION", "length": 50, "alias": "Condition", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Discharge_Wtr_Color", "description": "Discharge Water Color", "type": "codedValue", "codedValues": [ { "code": "1", "name": "Clear" }, { "code": "2", "name": "Cloudy" }, { "code": "3", "name": "Yellow" }, { "code": "4", "name": "Green" }, { "code": "5", "name": "Brown" }, { "code": "6", "name": "Other" }, { "code": "7", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "COLOR", "length": 50, "alias": "Color", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallOdor", "description": "Outfall Odor", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Musty", "name": "Musty" }, { "code": "Sewage", "name": "Sewage" }, { "code": "Rotten Eggs", "name": "Rotten Eggs" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ODOR", "length": 50, "alias": "Odor", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallClarity", "description": "Outfall Clarity", "type": "codedValue", "codedValues": [ { "code": "Clear", "name": "Clear" }, { "code": "Cloudy", "name": "Cloudy" }, { "code": "Opaque", "name": "Opaque" }, { "code": "Susp. Solids", "name": "Susp. Solids" }, { "code": "Other", "name": "Other" }, { "code": "None", "name": "None" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "TURBITY", "length": 50, "alias": "Clarity/Turbidity", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "OILSHEEN", "length": 50, "alias": "Oil Sheen", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FIELDTEST", "length": 50, "alias": "Samples Taken", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "NOTES", "length": 255, "alias": "Site Notes", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "INSEND", "length": 8, "alias": "End DateTime", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "WORKKEY", "length": 50, "alias": "Workorder ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "INSPECTOR", "length": 50, "alias": "Inspection User", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallInspectStatus", "description": "Status of Outfall Inspection", "type": "codedValue", "codedValues": [ { "code": "Completed", "name": "Completed" }, { "code": "Maintenance Needed", "name": "Maintenance Needed (system needs repaired)" }, { "code": "Further Investigation Needed", "name": "Further Investigation Needed (discharge/flow present)" }, { "code": "Enforcement Action Needed", "name": "Enforcement Action Needed (flow present but cause known)" }, { "code": "Cleanup Needed", "name": "CleanupNeeded" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "INSSTATUS", "length": 50, "alias": "Inspection Status", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LASTUPDATE", "length": 8, "alias": "Last Update Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "LASTEDITOR", "length": 50, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallRain", "description": "Time Since Last Rainfall", "type": "codedValue", "codedValues": [ { "code": "<72", "name": "<72 Hours" }, { "code": ">72", "name": ">72 Hours" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "RainfallTime", "length": 50, "alias": "Time Since Last Rainfall", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallRainAmt", "description": "Amount of Last Rainfall", "type": "codedValue", "codedValues": [ { "code": "< 0.1\"", "name": "<0.1\"" }, { "code": ">0.1\"", "name": ">0.1\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "RainfallAmt", "length": 50, "alias": "Amount of Last Rainfall", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "AirTemp", "length": 50, "alias": "Air Temperture", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallInvestType", "description": "Outfall Investigation Type", "type": "codedValue", "codedValues": [ { "code": "Routine Screening", "name": "Routine Screening" }, { "code": "Response to Complaint", "name": "Response to Complaint" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "InvestType", "length": 50, "alias": "Investigation Type", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Flow", "length": 50, "alias": "Flow", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FlowDepth", "alias": "FlowDepth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FlowWidth", "alias": "FlowWidth", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "FlowVelocity", "alias": "FlowVelocity", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallFloatable", "description": "Outfall Floatables", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Oil Sheen", "name": "Oil Sheen" }, { "code": "Suds", "name": "Suds" }, { "code": "Algae", "name": "Algae" }, { "code": "Sewage", "name": "Sewage" }, { "code": "Garbage", "name": "Garbage" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Floatables", "length": 50, "alias": "Floatables", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallDeposits", "description": "Outfall Deposits or Stains", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Sediment", "name": "Sediment" }, { "code": "Oily", "name": "Oily" }, { "code": "Rust", "name": "Rust" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "DepositsStains", "length": 50, "alias": "Deposits/Stains", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallVegetation", "description": "Outfall Vegetation", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Normal", "name": "Normal" }, { "code": "Excessive Growth", "name": "Excessive Growth" }, { "code": "Inhibited Growth", "name": "Inhibited Grown" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Vegetation", "length": 50, "alias": "Vegetation", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallStructureCon", "description": "Outfall Structure Condition", "type": "codedValue", "codedValues": [ { "code": "Normal", "name": "Normal" }, { "code": "Other", "name": "Other" }, { "code": "Cracks", "name": "Cracks" }, { "code": "Corrosion", "name": "Corrosion" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "StructuralCondition", "length": 50, "alias": "StructuralCondition", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "YesNo", "description": "A yes/no indicator", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "PhotosTaken", "length": 50, "alias": "PhotosTaken", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChemParaTemp", "length": 50, "alias": "Chemical Parameter Temperature", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChemParapH", "length": 50, "alias": "Chem Parameter pH", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChemParaCond", "length": 50, "alias": "Chemical Parameter Conductivity", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChemParaDetergent", "length": 50, "alias": "Chemical Parameter Detergent", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChemParaAmmonia", "length": 50, "alias": "Chemical Parameter Ammonia", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ChemParaTurb", "length": 50, "alias": "Chemical Parameter Turbidity", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "WaterTemp", "length": 10, "alias": "Water Temp", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ImpactedLnth", "description": "Length of Impacted Stream", "type": "codedValue", "codedValues": [ { "code": "<10'", "name": "<10'" }, { "code": "10'-50'", "name": "10'-50'" }, { "code": ">50'", "name": ">50'" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ImpactedLnth", "length": 50, "alias": "Length of Impacted Stream", "type": "esriFieldTypeString" }, { "nullable": true, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "OutfallFlowType", "description": "Outfall Flow Type", "type": "codedValue", "codedValues": [ { "code": "Trickle", "name": "Trickle" }, { "code": "Low Flow", "name": "Low Flow" }, { "code": "Heavy Flow", "name": "Heavy Flow" }, { "code": "Not Applicable", "name": "N/A" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FlowType", "length": 50, "alias": "Flow Type", "type": "esriFieldTypeString" } ], "dateFieldsTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" } }