{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 2, "name": "Outfall Evaluations", "type": "Table", "description": null, "copyrightText": null, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "editable": false, "nullable": false, "length": 38, "domain": null }, { "name": "KEYWORDS", "type": "esriFieldTypeString", "alias": "KEYWORDS", "editable": true, "nullable": true, "length": 2048, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "supportsAttachmentsResizing": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "currWeather", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "currWeather", "type": "esriFieldTypeString", "alias": "Current Weather", "length": 50, "domain": { "type": "codedValue", "name": "hWeather", "description": "Current Weather", "codedValues": [ { "name": "Clear Skies", "code": "ClearSkies" }, { "name": "Cloudy", "code": "Cloudy" }, { "name": "Rain", "code": "Rain" }, { "name": "Snow", "code": "Snow" }, { "name": "Frozen Ground", "code": "FrozenGround" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Temperature", "type": "esriFieldTypeString", "alias": "Temperature", "length": 50, "domain": null }, { "name": "TeamMembers", "type": "esriFieldTypeString", "alias": "Evaluation Team Members", "length": 150, "domain": null }, { "name": "structCond", "type": "esriFieldTypeString", "alias": "Structural Condition", "length": 200, "domain": { "type": "codedValue", "name": "hCondition", "description": "New, Good, Broken, Impaired", "codedValues": [ { "name": "Like New", "code": "LikeNew" }, { "name": "Good", "code": "Good" }, { "name": "Broken", "code": "Broken" }, { "name": "Impaired", "code": "Impaired" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "waterFlow", "type": "esriFieldTypeString", "alias": "Flow Observations", "length": 50, "domain": { "type": "codedValue", "name": "hStreamFlow", "description": "Stream Flow", "codedValues": [ { "name": "Zero flow", "code": "ZeroFlow" }, { "name": "Stagnant", "code": "Stagnant" }, { "name": "Slow", "code": "Slow" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Swift", "code": "Swift" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "visColor", "type": "esriFieldTypeString", "alias": "Color Assessment", "length": 50, "domain": { "type": "codedValue", "name": "hColor", "description": "Clear, Light Brown, Dark Brown", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Light Brown", "code": "LightBrown" }, { "name": "Dark Brown", "code": "DarkBrown" }, { "name": "Green", "code": "Green" }, { "name": "Grey", "code": "Grey" }, { "name": "Black", "code": "Black" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "visColorOther", "type": "esriFieldTypeString", "alias": "Desc of other color", "length": 100, "domain": null }, { "name": "visTurbidity", "type": "esriFieldTypeString", "alias": "Turbidity Assessment", "length": 50, "domain": { "type": "codedValue", "name": "hTurbidity", "description": "Clear, Slight, Moderate", "codedValues": [ { "name": "Clear", "code": "Clear" }, { "name": "Slightly", "code": "Slightly" }, { "name": "Moderate", "code": "Moderate" }, { "name": "Highly", "code": "Highly" }, { "name": "Opaque", "code": "Opaque" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "visTurbOther", "type": "esriFieldTypeString", "alias": "Desc of other Turbidity", "length": 100, "domain": null }, { "name": "visFloatable", "type": "esriFieldTypeString", "alias": "Floatable Assessment", "length": 50, "domain": { "type": "codedValue", "name": "hFloatables", "description": "None, Trash, Sewage...", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Trash", "code": "Trash" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Foam", "code": "Foam" }, { "name": "Oil Sheen", "code": "OilSheen" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "visFloatOther", "type": "esriFieldTypeString", "alias": "Desc of Other Floatables", "length": 100, "domain": null }, { "name": "visDeposits", "type": "esriFieldTypeString", "alias": "Deposit/Stain Assessment", "length": 50, "domain": { "type": "codedValue", "name": "hDeposits", "description": "Deposits Stains", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Mineral", "code": "Mineral" }, { "name": "Sediment", "code": "Sediment" }, { "name": "Oily", "code": "Oily" }, { "name": "Grease", "code": "Grease" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "visDepOther", "type": "esriFieldTypeString", "alias": "Desc. of other Deposit/Stains", "length": 100, "domain": null }, { "name": "visVegatation", "type": "esriFieldTypeString", "alias": "Vegatation Assessment", "length": 50, "domain": { "type": "codedValue", "name": "hVegatation", "description": "Vegatation", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Normal", "code": "Normal" }, { "name": "Excessive", "code": "Excessive" }, { "name": "Algae", "code": "Algae" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "visVegOther", "type": "esriFieldTypeString", "alias": "Desc. of other Vegatation", "length": 100, "domain": null }, { "name": "odorAssessment", "type": "esriFieldTypeString", "alias": "Odor Assessment", "length": 50, "domain": { "type": "codedValue", "name": "hOdor", "description": "None, Musty, Sewage...", "codedValues": [ { "name": "Rotten Egg", "code": "RottenEgg" }, { "name": "None", "code": "None" }, { "name": "Musty", "code": "Musty" }, { "name": "Sewage", "code": "Sewage" }, { "name": "Gas", "code": "Gas" }, { "name": "Oil", "code": "Oil" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "odorOther", "type": "esriFieldTypeString", "alias": "Desc of other Odor", "length": 100, "domain": null }, { "name": "resultTemp", "type": "esriFieldTypeString", "alias": "Analysis Temp", "length": 50, "domain": null }, { "name": "resultCopper", "type": "esriFieldTypeString", "alias": "Analysis Copper", "length": 50, "domain": null }, { "name": "resultConductivity", "type": "esriFieldTypeString", "alias": "Analysis Conductivity", "length": 50, "domain": null }, { "name": "resultNitrate", "type": "esriFieldTypeString", "alias": "Analysis Nitrate", "length": 50, "domain": null }, { "name": "resultpH", "type": "esriFieldTypeString", "alias": "Analysis pH", "length": 50, "domain": null }, { "name": "resultNitrite", "type": "esriFieldTypeString", "alias": "Analysis Nitrite", "length": 50, "domain": null }, { "name": "resultAmmonia", "type": "esriFieldTypeString", "alias": "Analysis Ammonia", "length": 50, "domain": null }, { "name": "resultPhosphorous", "type": "esriFieldTypeString", "alias": "Analysis Phosphorus", "length": 50, "domain": null }, { "name": "surfactants", "type": "esriFieldTypeString", "alias": "Surfactants", "length": 50, "domain": { "type": "codedValue", "name": "hSurfacants", "description": "High, Low, None", "codedValues": [ { "name": "High", "code": "High" }, { "name": "Medium", "code": "Medium" }, { "name": "Low", "code": "Low" }, { "name": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pollSource1", "type": "esriFieldTypeString", "alias": "Pollution Source1", "length": 50, "domain": { "type": "codedValue", "name": "hPollSource", "description": "Pollution Source", "codedValues": [ { "name": "Debris/Trash", "code": "Debris/Trash" }, { "name": "Construction Runoff", "code": "Constructionrunoff" }, { "name": "Road Crossing", "code": "RoadCrossing" }, { "name": "Septic System", "code": "SepticSystem" }, { "name": "Gully Erosion", "code": "GullyErosion" }, { "name": "Upland Source", "code": "UplandSource" }, { "name": "Stream Bank Erosion", "code": "StreamBankErosion" }, { "name": "Tile Outlet", "code": "TileOutlet" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pollSource2", "type": "esriFieldTypeString", "alias": "Pollution Source2", "length": 50, "domain": { "type": "codedValue", "name": "hPollSource", "description": "Pollution Source", "codedValues": [ { "name": "Debris/Trash", "code": "Debris/Trash" }, { "name": "Construction Runoff", "code": "Constructionrunoff" }, { "name": "Road Crossing", "code": "RoadCrossing" }, { "name": "Septic System", "code": "SepticSystem" }, { "name": "Gully Erosion", "code": "GullyErosion" }, { "name": "Upland Source", "code": "UplandSource" }, { "name": "Stream Bank Erosion", "code": "StreamBankErosion" }, { "name": "Tile Outlet", "code": "TileOutlet" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pollSource3", "type": "esriFieldTypeString", "alias": "Pollution Source3", "length": 50, "domain": { "type": "codedValue", "name": "hPollSource", "description": "Pollution Source", "codedValues": [ { "name": "Debris/Trash", "code": "Debris/Trash" }, { "name": "Construction Runoff", "code": "Constructionrunoff" }, { "name": "Road Crossing", "code": "RoadCrossing" }, { "name": "Septic System", "code": "SepticSystem" }, { "name": "Gully Erosion", "code": "GullyErosion" }, { "name": "Upland Source", "code": "UplandSource" }, { "name": "Stream Bank Erosion", "code": "StreamBankErosion" }, { "name": "Tile Outlet", "code": "TileOutlet" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pollSource4", "type": "esriFieldTypeString", "alias": "Pollution Source4", "length": 50, "domain": { "type": "codedValue", "name": "hPollSource", "description": "Pollution Source", "codedValues": [ { "name": "Debris/Trash", "code": "Debris/Trash" }, { "name": "Construction Runoff", "code": "Constructionrunoff" }, { "name": "Road Crossing", "code": "RoadCrossing" }, { "name": "Septic System", "code": "SepticSystem" }, { "name": "Gully Erosion", "code": "GullyErosion" }, { "name": "Upland Source", "code": "UplandSource" }, { "name": "Stream Bank Erosion", "code": "StreamBankErosion" }, { "name": "Tile Outlet", "code": "TileOutlet" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pollSource5", "type": "esriFieldTypeString", "alias": "Pollution Source5", "length": 50, "domain": { "type": "codedValue", "name": "hPollSource", "description": "Pollution Source", "codedValues": [ { "name": "Debris/Trash", "code": "Debris/Trash" }, { "name": "Construction Runoff", "code": "Constructionrunoff" }, { "name": "Road Crossing", "code": "RoadCrossing" }, { "name": "Septic System", "code": "SepticSystem" }, { "name": "Gully Erosion", "code": "GullyErosion" }, { "name": "Upland Source", "code": "UplandSource" }, { "name": "Stream Bank Erosion", "code": "StreamBankErosion" }, { "name": "Tile Outlet", "code": "TileOutlet" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "pollSourceOther", "type": "esriFieldTypeString", "alias": "Desc of other Pollution Source", "length": 50, "domain": null }, { "name": "StreamBottom", "type": "esriFieldTypeString", "alias": "Stream Bottom", "length": 50, "domain": { "type": "codedValue", "name": "hStreamBottom", "description": "Stream Bottom Types", "codedValues": [ { "name": "Cobble/Gravel", "code": "Cobble/Gravel" }, { "name": "Sand (Course)", "code": "Sand" }, { "name": "Muck/Silt (fine)", "code": "Muck/Silt" }, { "name": "Hardpan (solid clay)", "code": "Hardpan" }, { "name": "Artificial", "code": "Artificial" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "streamBottomOther", "type": "esriFieldTypeString", "alias": "Desc of other Stream Bottom", "length": 50, "domain": null }, { "name": "FollowUp", "type": "esriFieldTypeString", "alias": "Follow Up Required", "length": 50, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Priority", "type": "esriFieldTypeString", "alias": "Priority", "length": 50, "domain": { "type": "codedValue", "name": "hPriority", "description": "Immediate, High, Low", "codedValues": [ { "name": "Immediate", "code": "Immediate" }, { "name": "High", "code": "High" }, { "name": "Low", "code": "Low" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "dFacilityID", "type": "esriFieldTypeString", "alias": "dFacilityID", "length": 50, "domain": null }, { "name": "inspectionDate", "type": "esriFieldTypeDate", "alias": "inspectionDate", "length": 8, "domain": null }, { "name": "waterDepth", "type": "esriFieldTypeString", "alias": "waterDepth", "length": 50, "domain": null }, { "name": "lastRain", "type": "esriFieldTypeString", "alias": "Date of Last Rain", "length": 50, "domain": null }, { "name": "structCondOther", "type": "esriFieldTypeString", "alias": "structCondOther", "length": 100, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Biology", "type": "esriFieldTypeString", "alias": "Biology Assessment", "length": 20, "domain": { "type": "codedValue", "name": "dBiologyAssess", "description": "Outfall Insp. Biology Assessment", "codedValues": [ { "name": "Bacterial Sheen", "code": "Bacterial" }, { "name": "Algae", "code": "Algae" }, { "name": "Slime", "code": "Slime" }, { "name": "N/A", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Rel_GlobalID", "type": "esriFieldTypeGUID", "alias": "OutfallID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1312_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_11408_dFacil", "fields": "dFacilityID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1312", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1312", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_11408_Rel_Gl", "fields": "Rel_GlobalID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "dDischargePoint", "relatedTableId": 8, "role": "esriRelRoleDestination", "keyField": "Rel_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7A0100B9-2C58-4F47-B7F1-0995763ACD2C}" }, { "id": 2, "name": "dDischargePoint", "relatedTableId": 7, "role": "esriRelRoleDestination", "keyField": "Rel_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7A0100B9-2C58-4F47-B7F1-0995763ACD2C}" }, { "id": 4, "name": "dDischargePoint", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "Rel_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7A0100B9-2C58-4F47-B7F1-0995763ACD2C}" }, { "id": 9, "name": "dDischargePoint", "relatedTableId": 13, "role": "esriRelRoleDestination", "keyField": "Rel_GlobalID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7A0100B9-2C58-4F47-B7F1-0995763ACD2C}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "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, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "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": "eb5354993fe842fb833a9f08db748d06" }