{ "currentVersion" : 12, "id" : 14, "name" : "Structure IDDE Inspection Form", "type" : "Table", "serviceItemId" : "ff132d981b164c5cb3c95b84790922d2", "cacheMaxAge" : 30, "displayField" : "INSPECTOR", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1690595008889, "schemaLastEditDate" : 1690595008889, "dataLastEditDate" : 1690594788064 }, "relationships" : [ { "id" : 2, "name" : "Structures", "relatedTableId" : 5, "cardinality" : "esriRelCardinalityOneToMany", "role" : "esriRelRoleDestination", "keyField" : "ASSETGUID", "composite" : false } ], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "INSPECTOR", "type" : "esriFieldTypeString", "alias" : "Inspector Name", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOATABLES", "type" : "esriFieldTypeString", "alias" : "Floatables", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "ODOR", "type" : "esriFieldTypeString", "alias" : "Odor", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Odor_5", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "None", "code" : "None" }, { "name" : "Rotten eggs/hydrogen sulfide", "code" : "Rotten eggs/hydrogen sulfide" }, { "name" : "Musty odor", "code" : "Musty odor" }, { "name" : "Sharp, pungent odor", "code" : "Sharp, pungent odor" }, { "name" : "Sweet, fruity", "code" : "Sweet, fruity" }, { "name" : "Gasoline, petroleum", "code" : "Gasoline, petroleum" }, { "name" : "Chlorine", "code" : "Chlorine" }, { "name" : "Other (describe in notes)", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "FOAMFILM", "type" : "esriFieldTypeString", "alias" : "Sewage, Sheens and Scum", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "CONDUCTIVITY", "type" : "esriFieldTypeDouble", "alias" : "Conductivity (micro-Siemens/cm)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "Conductivity", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 20000 ] }, "defaultValue" : 0 }, { "name" : "PH", "type" : "esriFieldTypeDouble", "alias" : "pH", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "pH", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 14 ] }, "defaultValue" : 0 }, { "name" : "SALINITYPPM", "type" : "esriFieldTypeDouble", "alias" : "Salinity (ppm)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "Salinityppm", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 20000 ] }, "defaultValue" : 0 }, { "name" : "ADDTLPARAMETERS", "type" : "esriFieldTypeString", "alias" : "Additional Parameters Screened", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "IDDECLASS", "type" : "esriFieldTypeString", "alias" : "IDDE Classification", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "IDDEClass", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Potential", "code" : "Potential" }, { "name" : "Obvious", "code" : "Obvious" }, { "name" : "Unlikely", "code" : "Unlikely" }, { "name" : "Possible", "code" : "Possible" } ] }, "defaultValue" : null }, { "name" : "LABSAMPLE1", "type" : "esriFieldTypeString", "alias" : "1. Lab Sample Test", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Monitor_Parameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Aluminum, Total", "code" : "Aluminum, Total" }, { "name" : "Ammonia - Nitrogen", "code" : "Ammonia - Nitrogen" }, { "name" : "Arsenic, Total", "code" : "Arsenic, Total" }, { "name" : "Cadmium, Total", "code" : "Cadmium, Total" }, { "name" : "Chloride", "code" : "Chloride" }, { "name" : "Chromium, Total", "code" : "Chromium, Total" }, { "name" : "Copper, Total", "code" : "Copper, Total" }, { "name" : "Lead, Total", "code" : "Lead, Total" }, { "name" : "Nitrogen, Total", "code" : "Nitrogen, Total" }, { "name" : "Oil and Grease", "code" : "Oil and Grease" }, { "name" : "Phosphorus, Total", "code" : "Phosphorus, Total" }, { "name" : "PAHs", "code" : "PAHs" }, { "name" : "Total Dissolved Solids", "code" : "Total Dissolved Solids" }, { "name" : "Total Suspended Solids", "code" : "Total Suspended Solids" }, { "name" : "Turbidity", "code" : "Turbidity" }, { "name" : "pH", "code" : "pH" }, { "name" : "Specific Conductance", "code" : "Specific Conductance" }, { "name" : "Enterococcus", "code" : "Enterococcus" }, { "name" : "E. coli", "code" : "E. coli" }, { "name" : "Fecal Coliform", "code" : "Fecal Coliform" }, { "name" : "Dissolved Oxygen", "code" : "Dissolved Oxygen" }, { "name" : "Temperature", "code" : "Temperature" }, { "name" : "BOD5", "code" : "BOD5" } ] }, "defaultValue" : null }, { "name" : "LABSAMPLE2", "type" : "esriFieldTypeString", "alias" : "2. Lab Sample Test", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Monitor_Parameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Aluminum, Total", "code" : "Aluminum, Total" }, { "name" : "Ammonia - Nitrogen", "code" : "Ammonia - Nitrogen" }, { "name" : "Arsenic, Total", "code" : "Arsenic, Total" }, { "name" : "Cadmium, Total", "code" : "Cadmium, Total" }, { "name" : "Chloride", "code" : "Chloride" }, { "name" : "Chromium, Total", "code" : "Chromium, Total" }, { "name" : "Copper, Total", "code" : "Copper, Total" }, { "name" : "Lead, Total", "code" : "Lead, Total" }, { "name" : "Nitrogen, Total", "code" : "Nitrogen, Total" }, { "name" : "Oil and Grease", "code" : "Oil and Grease" }, { "name" : "Phosphorus, Total", "code" : "Phosphorus, Total" }, { "name" : "PAHs", "code" : "PAHs" }, { "name" : "Total Dissolved Solids", "code" : "Total Dissolved Solids" }, { "name" : "Total Suspended Solids", "code" : "Total Suspended Solids" }, { "name" : "Turbidity", "code" : "Turbidity" }, { "name" : "pH", "code" : "pH" }, { "name" : "Specific Conductance", "code" : "Specific Conductance" }, { "name" : "Enterococcus", "code" : "Enterococcus" }, { "name" : "E. coli", "code" : "E. coli" }, { "name" : "Fecal Coliform", "code" : "Fecal Coliform" }, { "name" : "Dissolved Oxygen", "code" : "Dissolved Oxygen" }, { "name" : "Temperature", "code" : "Temperature" }, { "name" : "BOD5", "code" : "BOD5" } ] }, "defaultValue" : null }, { "name" : "LABSAMPLE3", "type" : "esriFieldTypeString", "alias" : "3. Lab Sample Test", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Monitor_Parameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Aluminum, Total", "code" : "Aluminum, Total" }, { "name" : "Ammonia - Nitrogen", "code" : "Ammonia - Nitrogen" }, { "name" : "Arsenic, Total", "code" : "Arsenic, Total" }, { "name" : "Cadmium, Total", "code" : "Cadmium, Total" }, { "name" : "Chloride", "code" : "Chloride" }, { "name" : "Chromium, Total", "code" : "Chromium, Total" }, { "name" : "Copper, Total", "code" : "Copper, Total" }, { "name" : "Lead, Total", "code" : "Lead, Total" }, { "name" : "Nitrogen, Total", "code" : "Nitrogen, Total" }, { "name" : "Oil and Grease", "code" : "Oil and Grease" }, { "name" : "Phosphorus, Total", "code" : "Phosphorus, Total" }, { "name" : "PAHs", "code" : "PAHs" }, { "name" : "Total Dissolved Solids", "code" : "Total Dissolved Solids" }, { "name" : "Total Suspended Solids", "code" : "Total Suspended Solids" }, { "name" : "Turbidity", "code" : "Turbidity" }, { "name" : "pH", "code" : "pH" }, { "name" : "Specific Conductance", "code" : "Specific Conductance" }, { "name" : "Enterococcus", "code" : "Enterococcus" }, { "name" : "E. coli", "code" : "E. coli" }, { "name" : "Fecal Coliform", "code" : "Fecal Coliform" }, { "name" : "Dissolved Oxygen", "code" : "Dissolved Oxygen" }, { "name" : "Temperature", "code" : "Temperature" }, { "name" : "BOD5", "code" : "BOD5" } ] }, "defaultValue" : null }, { "name" : "ASSETGUID", "type" : "esriFieldTypeGUID", "alias" : "Asset Global ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABSAMPLE4", "type" : "esriFieldTypeString", "alias" : "4. Lab Sample Test", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Monitor_Parameter", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Aluminum, Total", "code" : "Aluminum, Total" }, { "name" : "Ammonia - Nitrogen", "code" : "Ammonia - Nitrogen" }, { "name" : "Arsenic, Total", "code" : "Arsenic, Total" }, { "name" : "Cadmium, Total", "code" : "Cadmium, Total" }, { "name" : "Chloride", "code" : "Chloride" }, { "name" : "Chromium, Total", "code" : "Chromium, Total" }, { "name" : "Copper, Total", "code" : "Copper, Total" }, { "name" : "Lead, Total", "code" : "Lead, Total" }, { "name" : "Nitrogen, Total", "code" : "Nitrogen, Total" }, { "name" : "Oil and Grease", "code" : "Oil and Grease" }, { "name" : "Phosphorus, Total", "code" : "Phosphorus, Total" }, { "name" : "PAHs", "code" : "PAHs" }, { "name" : "Total Dissolved Solids", "code" : "Total Dissolved Solids" }, { "name" : "Total Suspended Solids", "code" : "Total Suspended Solids" }, { "name" : "Turbidity", "code" : "Turbidity" }, { "name" : "pH", "code" : "pH" }, { "name" : "Specific Conductance", "code" : "Specific Conductance" }, { "name" : "Enterococcus", "code" : "Enterococcus" }, { "name" : "E. coli", "code" : "E. coli" }, { "name" : "Fecal Coliform", "code" : "Fecal Coliform" }, { "name" : "Dissolved Oxygen", "code" : "Dissolved Oxygen" }, { "name" : "Temperature", "code" : "Temperature" }, { "name" : "BOD5", "code" : "BOD5" } ] }, "defaultValue" : null }, { "name" : "STAINING", "type" : "esriFieldTypeString", "alias" : "Signs of Staining?", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "DATE_VISIT", "type" : "esriFieldTypeDate", "alias" : "Inspection Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -2209161600000, "precision" : 1 }, { "name" : "INSPECT_TYPE", "type" : "esriFieldTypeString", "alias" : "Type of Inspection", "sqlType" : "sqlTypeOther", "length" : 25, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "InspectType", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Condition Only", "code" : "Condition Only" }, { "name" : "Maintenance Only", "code" : "Maintenance Only" }, { "name" : "Maintenance and Condition", "code" : "Maintenance and Condition" }, { "name" : "IDDE Dry Weather", "code" : "IDDE Dry Weather" }, { "name" : "IDDE Wet Weather", "code" : "IDDE Wet Weather" } ] }, "defaultValue" : null }, { "name" : "STRUCTURE_FOUND", "type" : "esriFieldTypeString", "alias" : "Structure Found?", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "STRUCTURE", "type" : "esriFieldTypeString", "alias" : "Structure Condition", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Poor- requires maintenance", "code" : "0" }, { "name" : "Failing- requires immediate action", "code" : "1" }, { "name" : "Good- inspect within 2 years", "code" : "2" }, { "name" : "Fair- inspect within 1 year", "code" : "3" }, { "name" : "Unknown", "code" : "4" }, { "name" : "N/A", "code" : "5" }, { "name" : "Not Entered", "code" : "6" } ] }, "defaultValue" : null }, { "name" : "GRATE", "type" : "esriFieldTypeString", "alias" : "Grate Condition", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Poor- requires maintenance", "code" : "0" }, { "name" : "Failing- requires immediate action", "code" : "1" }, { "name" : "Good- inspect within 2 years", "code" : "2" }, { "name" : "Fair- inspect within 1 year", "code" : "3" }, { "name" : "Unknown", "code" : "4" }, { "name" : "N/A", "code" : "5" }, { "name" : "Not Entered", "code" : "6" } ] }, "defaultValue" : null }, { "name" : "PAVEMENT", "type" : "esriFieldTypeString", "alias" : "Pavement Condition", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Condition", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Poor- requires maintenance", "code" : "0" }, { "name" : "Failing- requires immediate action", "code" : "1" }, { "name" : "Good- inspect within 2 years", "code" : "2" }, { "name" : "Fair- inspect within 1 year", "code" : "3" }, { "name" : "Unknown", "code" : "4" }, { "name" : "N/A", "code" : "5" }, { "name" : "Not Entered", "code" : "6" } ] }, "defaultValue" : null }, { "name" : "DEPTH_OF_SEDIMENT", "type" : "esriFieldTypeString", "alias" : "Depth of Sediment", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Sediment", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No sediment", "code" : "No sediment" }, { "name" : "Sump less than half full", "code" : "Sump less than half full" }, { "name" : "Sump half full", "code" : "Sump half full" }, { "name" : "Sump full", "code" : "Sump full" }, { "name" : "Structure completely full", "code" : "Structure completely full" } ] }, "defaultValue" : null }, { "name" : "DRY_WEATHER_FLOW", "type" : "esriFieldTypeString", "alias" : "Dry Weather Flow Visible?", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "CNOTES", "type" : "esriFieldTypeString", "alias" : "Condition Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NEEDS_SERVICE", "type" : "esriFieldTypeString", "alias" : "Needs Repair", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "NEEDS_CLEANING", "type" : "esriFieldTypeString", "alias" : "Needs Cleaning", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "BROKEN_PIPE", "type" : "esriFieldTypeString", "alias" : "Pipe Broken", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "FNOTES", "type" : "esriFieldTypeString", "alias" : "Follow up Notes", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATESTORM", "type" : "esriFieldTypeDate", "alias" : "Date of Last Storm", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : -2209161600000, "precision" : 1 }, { "name" : "COLOR", "type" : "esriFieldTypeString", "alias" : "Color of Flow", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Color of Flow", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "N/A", "code" : "N/A" }, { "name" : "Clear", "code" : "Clear" }, { "name" : "Tea/Coffee", "code" : "Tea/Coffee" }, { "name" : "Clear black", "code" : "Clear black" }, { "name" : "Orange-red", "code" : "Orange-red" }, { "name" : "Tan to light brown", "code" : "Tan to light brown" }, { "name" : "Milky/dirty dishwater gray", "code" : "Milky/dirty dishwater gray" }, { "name" : "Milky White", "code" : "Milky White" }, { "name" : "White crusty deposits", "code" : "White crusty deposits" }, { "name" : "Greenish-Bluish", "code" : "Greenish-Bluish" }, { "name" : "Blue", "code" : "Blue" }, { "name" : "Purple", "code" : "Purple" }, { "name" : "Dark red", "code" : "Dark red" }, { "name" : "Other (describe in notes)", "code" : "Other" } ] }, "defaultValue" : null }, { "name" : "CLARITY", "type" : "esriFieldTypeString", "alias" : "Clarity of Flow", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Clarity of Flow", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Clear", "code" : "Clear" }, { "name" : "Cloudy", "code" : "Cloudy" }, { "name" : "Opaque", "code" : "Opaque" } ] }, "defaultValue" : null }, { "name" : "TEMPCELSIUS", "type" : "esriFieldTypeDouble", "alias" : "Temperature (deg F)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "TempCelcius", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 100 ] }, "defaultValue" : 0 }, { "name" : "AMMONIA", "type" : "esriFieldTypeDouble", "alias" : "Ammonia (mg/L)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "Ammonia", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 10 ] }, "defaultValue" : 0 }, { "name" : "CHLORINE", "type" : "esriFieldTypeDouble", "alias" : "Chlorine (mg/L)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "Chlorine", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 2 ] }, "defaultValue" : 0 }, { "name" : "SURFACTANTS", "type" : "esriFieldTypeDouble", "alias" : "Surfactants (mg/L)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "range", "name" : "TempCelcius", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "range" : [ 0, 100 ] }, "defaultValue" : 0 }, { "name" : "REASONILLICIT", "type" : "esriFieldTypeString", "alias" : "Reason for Illicit Suspicion", "sqlType" : "sqlTypeOther", "length" : 150, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABSMPLCOLLECTED", "type" : "esriFieldTypeString", "alias" : "Sample for Lab Collected?", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "LABRESULTS1", "type" : "esriFieldTypeString", "alias" : "1. Lab Sample Results", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABRESULTS2", "type" : "esriFieldTypeString", "alias" : "2. Lab Sample Results", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABRESULTS3", "type" : "esriFieldTypeString", "alias" : "3. Lab Sample Results", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INVESTIIGATION_STATUS", "type" : "esriFieldTypeString", "alias" : "Investigation Status", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Investigation_Status", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Complete", "code" : "0" }, { "name" : "Follow-up needed", "code" : "1" }, { "name" : "Not complete", "code" : "2" }, { "name" : "In progress", "code" : "3" }, { "name" : "Not needed", "code" : "4" } ] }, "defaultValue" : null }, { "name" : "OBSERVED_DUMPING", "type" : "esriFieldTypeString", "alias" : "Observed Signs of Dumping?", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "OBSERVED_DUMPING_NOTES", "type" : "esriFieldTypeString", "alias" : "Dumping Notes", "sqlType" : "sqlTypeOther", "length" : 200, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OBSERVED_WEATHER", "type" : "esriFieldTypeString", "alias" : "Observed Weather", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FLOW_INTENSITY", "type" : "esriFieldTypeString", "alias" : "Flow Intensity", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "FlowVolume", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Low", "code" : "Low" }, { "name" : "Moderate", "code" : "Moderate" }, { "name" : "Heavy", "code" : "Heavy" } ] }, "defaultValue" : null }, { "name" : "STRUCTURE_ACCESSIBLE", "type" : "esriFieldTypeString", "alias" : "Structure Accessible?", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "SCOUR", "type" : "esriFieldTypeString", "alias" : "Signs of Scour?", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Yes_No", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Not Entered", "code" : "Not Entered" }, { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "STAINING_SCOUR_NOTES", "type" : "esriFieldTypeString", "alias" : "Staining/Scour Notes", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABRESULTS4", "type" : "esriFieldTypeString", "alias" : "4. Lab Sample Results", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "CreationDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : -2209161600000, "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "EditDate", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : -2209161600000, "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "StructureID", "type" : "esriFieldTypeString", "alias" : "Structure ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STAND_WATER", "type" : "esriFieldTypeString", "alias" : "Standing Water Observed?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "PIPE_SUMBERGED", "type" : "esriFieldTypeString", "alias" : "Pipe Submerged?", "sqlType" : "sqlTypeOther", "length" : 5, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "YesNo", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Yes", "code" : "Yes" }, { "name" : "No", "code" : "No" } ] }, "defaultValue" : null }, { "name" : "STAND_SUBMERGE_NOTES", "type" : "esriFieldTypeString", "alias" : "Standing Water/Pipe Submerged Notes", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "GlobalID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : "NEWID() WITH VALUES" } ], "indexes" : [ { "name" : "PK__MAYNARD___F4B70D8566F7FEF6", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "G70ASSETGUID", "fields" : "ASSETGUID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "CreationDateIndex", "fields" : "CreationDate", "isAscending" : true, "isUnique" : false, "description" : "CreationDate Field index", "indexType" : "Attribute" }, { "name" : "CreatorIndex", "fields" : "Creator", "isAscending" : false, "isUnique" : false, "description" : "Creator Field index", "indexType" : "Attribute" }, { "name" : "EditDateIndex", "fields" : "EditDate", "isAscending" : true, "isUnique" : false, "description" : "EditDate Field index", "indexType" : "Attribute" }, { "name" : "EditorIndex", "fields" : "Editor", "isAscending" : false, "isUnique" : false, "description" : "Editor Field index", "indexType" : "Attribute" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Structure IDDE Inspection Form", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract,Sync" }