{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 8, "name": "Outfall Dry Weather Inspection Data", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "InspecctName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "DateTime", "type": "esriFieldTypeDate", "alias": "Enter today's date and time", "length": 8, "domain": null }, { "name": "InspecctName", "type": "esriFieldTypeString", "alias": "Inspector(s)", "length": 255, "domain": null }, { "name": "SkyCond", "type": "esriFieldTypeString", "alias": "What are the current sky conditions?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_SkyCond", "description": "", "codedValues": [ { "name": "Clear (<30% Cloud)", "code": "Clear" }, { "name": "Partly Sunny (30-70% Cloud)", "code": "PartlySunny" }, { "name": "Mostly Cloudy (>70% Cloud)", "code": "MostlyCloudy" }, { "name": "Overcast (100% Cloud)", "code": "Overcast" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CurrTemp", "type": "esriFieldTypeInteger", "alias": "What is the current temperature (F)", "domain": null }, { "name": "WindyCalm", "type": "esriFieldTypeString", "alias": "Is it windy or calm?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_WindyCalm", "description": "", "codedValues": [ { "name": "Calm", "code": "calm" }, { "name": "Windy", "code": "windy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "WindSpeed", "type": "esriFieldTypeInteger", "alias": "Wind Speed (MPH)", "domain": null }, { "name": "WindDir", "type": "esriFieldTypeString", "alias": "Wind Direction", "length": 255, "domain": { "type": "codedValue", "name": "cvd_WindDir", "description": "", "codedValues": [ { "name": "North", "code": "n" }, { "name": "Northeast", "code": "ne" }, { "name": "East", "code": "e" }, { "name": "Southeast", "code": "se" }, { "name": "South", "code": "s" }, { "name": "Southwest", "code": "sw" }, { "name": "West", "code": "w" }, { "name": "Northwest", "code": "nw" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RainYN", "type": "esriFieldTypeString", "alias": "Has it rain in last 3 days?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_RainYN", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RainAmt", "type": "esriFieldTypeDouble", "alias": "If yes, how much rain? (Inches 0.00)", "domain": null }, { "name": "PipeFlow", "type": "esriFieldTypeString", "alias": "Describe the current pipe flow", "length": 255, "domain": { "type": "codedValue", "name": "cvd_PipeFlow", "description": "", "codedValues": [ { "name": "None", "code": "none" }, { "name": "Trickle", "code": "trickle" }, { "name": "Steady", "code": "steady" }, { "name": "¼ pipe flow or more", "code": "quarterpipeplus" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SeepageFlow", "type": "esriFieldTypeString", "alias": "Describe the seepage flow", "length": 255, "domain": { "type": "codedValue", "name": "cvd_SeepageFlow", "description": "", "codedValues": [ { "name": "None", "code": "none" }, { "name": "Trickle", "code": "trickle" }, { "name": "Steady", "code": "steady" }, { "name": "¼ pipe flow or more", "code": "quarterpipeplus" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ColorFlow", "type": "esriFieldTypeString", "alias": "What is the color? (if flow is present)", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ColorFlow", "description": "", "codedValues": [ { "name": "Clear", "code": "clear" }, { "name": "White", "code": "white" }, { "name": "Grey", "code": "grey" }, { "name": "Black", "code": "black" }, { "name": "Orange", "code": "orange" }, { "name": "Light Brown", "code": "ltbrown" }, { "name": "Brown", "code": "brown" }, { "name": "Dark Brown", "code": "dkbrown" }, { "name": "Yellow", "code": "yellow" }, { "name": "Red", "code": "red" }, { "name": "Red Brown", "code": "redbrown" }, { "name": "Green", "code": "green" }, { "name": "Blue", "code": "blue" }, { "name": "Purple", "code": "purple" }, { "name": "Other (specify)", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "othercolor", "type": "esriFieldTypeString", "alias": "Specify other color", "length": 255, "domain": null }, { "name": "OutfallID", "type": "esriFieldTypeString", "alias": "Outfall ID", "length": 255, "domain": null }, { "name": "signDesg", "type": "esriFieldTypeString", "alias": "Sign Designation", "length": 255, "domain": null }, { "name": "outfallLocation", "type": "esriFieldTypeString", "alias": "Outfall Location", "length": 255, "domain": null }, { "name": "receivingwaters", "type": "esriFieldTypeString", "alias": "Receiving Waters", "length": 255, "domain": null }, { "name": "pipesize", "type": "esriFieldTypeInteger", "alias": "Pipe Size", "domain": null }, { "name": "pipetype", "type": "esriFieldTypeString", "alias": "Pipe Type", "length": 255, "domain": null }, { "name": "DebrisObs", "type": "esriFieldTypeString", "alias": "If there is obvious debris or pollution, score all that are applicable in the questions below", "length": 255, "domain": null }, { "name": "DebNone", "type": "esriFieldTypeString", "alias": "DebNone", "length": 255, "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dn", "type": "esriFieldTypeString", "alias": "dn", "length": 255, "domain": null }, { "name": "DebFoam", "type": "esriFieldTypeString", "alias": "Is foam present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_foam", "description": "", "codedValues": [ { "name": "0 - There is no foam present", "code": "0 - There is no foam present" }, { "name": "3 - There is foam present", "code": "3 - There is foam present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dfm", "type": "esriFieldTypeString", "alias": "dfm", "length": 255, "domain": null }, { "name": "DebFloat", "type": "esriFieldTypeString", "alias": "Is floating green scum present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_scum", "description": "", "codedValues": [ { "name": "0 - There is no floating green scum present", "code": "0 - There is no floating green scum present" }, { "name": "3 - There is floating green scum present", "code": "3 - There is floating green scum present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dfl", "type": "esriFieldTypeString", "alias": "dfl", "length": 255, "domain": null }, { "name": "DebOil", "type": "esriFieldTypeString", "alias": "Is there is oil or a film present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_oil_film", "description": "", "codedValues": [ { "name": "0 - There is no oil or film present", "code": "0 - There is no oil or film present" }, { "name": "9 - There is oil or film present", "code": "9 - There is oil or film present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "doil", "type": "esriFieldTypeString", "alias": "doil", "length": 255, "domain": null }, { "name": "DebVeg", "type": "esriFieldTypeString", "alias": "Is a vegitative mat present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_veg_mat", "description": "", "codedValues": [ { "name": "0 - There is no vegitative mat present", "code": "0 - There is no vegitative mat present" }, { "name": "9 - There is a vegitative mat present", "code": "9 - There is a vegitative mat present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "dv", "type": "esriFieldTypeString", "alias": "dv", "length": 255, "domain": null }, { "name": "DebSew", "type": "esriFieldTypeString", "alias": "Is there sewage or septic present", "length": 255, "domain": { "type": "codedValue", "name": "cvd_sew_sep", "description": "", "codedValues": [ { "name": "0 - There is no sewage or septic present", "code": "0 - There is no sewage or septic present" }, { "name": "10 - There is sewage or septic present", "code": "10 - There is sewage or septic present" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ds", "type": "esriFieldTypeString", "alias": "ds", "length": 255, "domain": null }, { "name": "DebrisScore", "type": "esriFieldTypeInteger", "alias": "Debris Score - add the last five values", "domain": null }, { "name": "Odor", "type": "esriFieldTypeString", "alias": "Odor Score - Select one", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Odor", "description": "", "codedValues": [ { "name": "0 - None / Natural", "code": "0 - None / Natural" }, { "name": "5 - Musty", "code": "5 - Musty" }, { "name": "10 - Sewage / Septic", "code": "10 - Sewage / Septic" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OdorScore", "type": "esriFieldTypeInteger", "alias": "Odor Score - Select one", "domain": null }, { "name": "Clarity", "type": "esriFieldTypeString", "alias": "Clarity Score - Select one", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Clarity", "description": "", "codedValues": [ { "name": "0 - Clear", "code": "0 - Clear" }, { "name": "5 - Cloudy", "code": "5 - Cloudy" }, { "name": "10 - Opaque", "code": "10 - Opaque" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ClarityScore", "type": "esriFieldTypeInteger", "alias": "Clarity Score", "domain": null }, { "name": "TotalScore", "type": "esriFieldTypeInteger", "alias": "Total Score - add the debris, odor and clarity scores", "domain": null }, { "name": "SedimentLevel", "type": "esriFieldTypeString", "alias": "What Best describes the sediment level?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_SedimentLevel", "description": "", "codedValues": [ { "name": "Open", "code": "open" }, { "name": "¼ Full", "code": "quarter" }, { "name": "½ Full", "code": "half" }, { "name": "¾ Full", "code": "3quarter" }, { "name": "Plugged", "code": "plugged" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructureCond", "type": "esriFieldTypeString", "alias": "How would you describe the structure's condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_StructureCond", "description": "", "codedValues": [ { "name": "Excellent", "code": "excellent" }, { "name": "Good", "code": "good" }, { "name": "Fair", "code": "fair" }, { "name": "Poor", "code": "poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TrashLitter", "type": "esriFieldTypeString", "alias": "Is there trash or litter present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_TrashLitter", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "YardWaste", "type": "esriFieldTypeString", "alias": "Is yard waste present?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_YardWaste", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GenComments", "type": "esriFieldTypeString", "alias": "Comments?", "length": 255, "domain": null }, { "name": "PotSourceActions", "type": "esriFieldTypeString", "alias": "Have you located any potential sources and describe any actions you have taken?", "length": 255, "domain": null }, { "name": "followup", "type": "esriFieldTypeString", "alias": "Is follow-up reguired?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_followup", "description": "", "codedValues": [ { "name": "Yes", "code": "yes" }, { "name": "No", "code": "no" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "sig", "type": "esriFieldTypeString", "alias": "Initial", "length": 255, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "latlong", "type": "esriFieldTypeString", "alias": "Latitude and Longitude (Decimal Degrees)", "length": 255, "domain": null }, { "name": "New_outfall", "type": "esriFieldTypeString", "alias": "Outfall Details", "length": 255, "domain": null }, { "name": "new_old", "type": "esriFieldTypeString", "alias": "new_old", "length": 255, "domain": null }, { "name": "OutfallID_New", "type": "esriFieldTypeString", "alias": "Outfall ID", "length": 255, "domain": null }, { "name": "latty", "type": "esriFieldTypeString", "alias": "latty", "length": 255, "domain": null }, { "name": "longy", "type": "esriFieldTypeString", "alias": "longy", "length": 255, "domain": null }, { "name": "latlong_new", "type": "esriFieldTypeString", "alias": "Latitude and Longitude", "length": 255, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null } ], "indexes": [ { "name": "R878_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_878", "fields": "globalid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_878", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_4855_Facilit", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1621869164000 }, "serviceItemId": "195a5bdaa2c3458abc97e6eaa794d4bc" }