{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": ["count"], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Table", "relationships": [{ "keyField": "FEATURE_ID", "role": "esriRelRoleDestination", "catalogID": "{9E560B8F-13EB-4CE9-B0C1-126A54FA2620}", "composite": false, "name": "StormwaterDevice", "relatedTableId": 16, "id": 1, "cardinality": "esriRelCardinalityOneToOne" }], "cimVersion": "3.6.0", "isDataArchived": false, "id": 23, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml", "standardMaxRecordCount": 32000, "isDataVersioned": false, "templates": [{ "name": "Existing_SW_Pipe_Outlet_Inspections", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "GEN_LOC": null, "DATE_RAIN": null, "watershed": null, "XCOORD": null, "CLEANING": null, "COMMENTS": null, "FEATURE_ID": null, "SV_DATE": null, "STRUCT_RATING": null, "OUT_MAT": null, "FLAG": null, "OUT_TYPE": null, "EROSION": null, "FLOW": null, "POND": null, "GPS_STATUS": null, "FieldID": null, "FLOODING": null, "INACCESS": null, "WTR_SURF": null, "SURF_COV": null, "YCOORD": null, "ELEVATION": null, "OUT_REHAB": null, "Enabled": 1, "Outfall": null, "StructID": null, "SEWAGE": null, "labelname": null, "MAINT_RATE": null, "TRUE_OUTFALL": null, "NORTH_ARROW": null, "AncillaryRole": null, "ADDRESS": null, "TURBIDITY": null, "ROW": null, "DEPTH": null }} }], "supportsAdvancedQueries": true, "currentVersion": 12, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "OBJECTID", "name": "Existing_SW_Pipe_Outlet_Inspections", "displayField": "labelname", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "AncillaryRole", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "AncillaryRole", "alias": "AncillaryRole", "type": "esriFieldTypeSmallInteger" }, { "modelName": "Enabled", "nullable": true, "editable": true, "defaultValue": 1, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "EnabledDomain", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "False" }, { "code": 1, "name": "True" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "Enabled", "alias": "Enabled", "type": "esriFieldTypeSmallInteger" }, { "modelName": "SV_DATE", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SV_DATE", "length": 8, "alias": "Survey Date", "type": "esriFieldTypeDate" }, { "modelName": "StructID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "StructID", "length": 25, "alias": "FinalStructure_ID", "type": "esriFieldTypeString" }, { "modelName": "FieldID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "FieldID", "length": 25, "alias": "OriginalField_ID", "type": "esriFieldTypeString" }, { "modelName": "XCOORD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "XCOORD", "alias": "XCoord", "type": "esriFieldTypeDouble" }, { "modelName": "YCOORD", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "YCOORD", "alias": "YCoord", "type": "esriFieldTypeDouble" }, { "modelName": "ELEVATION", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ELEVATION", "alias": "Elevation", "type": "esriFieldTypeDouble" }, { "modelName": "NORTH_ARROW", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomNorthArrow", "description": "Diameter of Pipe", "type": "codedValue", "codedValues": [ { "code": 1, "name": "1" }, { "code": 2, "name": "2" }, { "code": 3, "name": "3" }, { "code": 4, "name": "4" }, { "code": 5, "name": "5" }, { "code": 6, "name": "6" }, { "code": 7, "name": "7" }, { "code": 8, "name": "8" }, { "code": 9, "name": "9" }, { "code": 10, "name": "10" }, { "code": 11, "name": "11" }, { "code": 12, "name": "12" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "NORTH_ARROW", "alias": "North Arrow", "type": "esriFieldTypeSmallInteger" }, { "modelName": "ADDRESS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ADDRESS", "length": 254, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "GEN_LOC", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomGenLoc", "description": "General Location", "type": "codedValue", "codedValues": [ { "code": "In Street", "name": "In Street" }, { "code": "In Sidewalk", "name": "In Sidewalk" }, { "code": "Front Yard", "name": "Front Yard" }, { "code": "Back Yard", "name": "Back Yard" }, { "code": "Side Yard", "name": "Side Yard" }, { "code": "Driveway", "name": "Driveway" }, { "code": "Parking Lot", "name": "Parking Lot" }, { "code": "Ditch/Swale", "name": "Ditch/Swale" }, { "code": "Open Area", "name": "Open Area" }, { "code": "Creek/Stream", "name": "Creek/Stream" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "GEN_LOC", "length": 15, "alias": "General Location", "type": "esriFieldTypeString" }, { "modelName": "ROW", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomROW", "description": "Right-of-Way", "type": "codedValue", "codedValues": [ { "code": "Inside Right-of-Way", "name": "Inside Right-of-Way" }, { "code": "Outside Right-of-Way", "name": "Outside Right-of-Way" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "ROW", "length": 25, "alias": "Right-of-Way", "type": "esriFieldTypeString" }, { "modelName": "SURF_COV", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomSurfCov", "description": "Type of ground cover at feature", "type": "codedValue", "codedValues": [ { "code": "Pavement", "name": "Pavement" }, { "code": "Gravel", "name": "Gravel" }, { "code": "Grass", "name": "Grass" }, { "code": "Dirt", "name": "Dirt" }, { "code": "Other", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "SURF_COV", "length": 10, "alias": "Surface Cover", "type": "esriFieldTypeString" }, { "modelName": "DEPTH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DEPTH", "alias": "Depth", "type": "esriFieldTypeDouble" }, { "modelName": "STRUCT_RATING", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomStructRating", "description": "Structure Rating", "type": "codedValue", "codedValues": [ { "code": "Failed", "name": "Failed" }, { "code": "Failing", "name": "Failing" }, { "code": "Critical", "name": "Critical" }, { "code": "Serious", "name": "Serious" }, { "code": "Poor", "name": "Poor" }, { "code": "Fair", "name": "Fair" }, { "code": "Satisfactory", "name": "Satisfactory" }, { "code": "Good", "name": "Good" }, { "code": "Very Good", "name": "Very Good" }, { "code": "Excellent", "name": "Excellent" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "STRUCT_RATING", "length": 15, "alias": "Structure Rating", "type": "esriFieldTypeString" }, { "modelName": "MAINT_RATE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomDebris", "description": "Evidence of Debris", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Slight", "name": "Slight (Flow Not Impeded/Routine cleaning only)" }, { "code": "Mild", "name": "Mild (Flow Partially Impeded)" }, { "code": "Moderate", "name": "Moderate (Flow Impeded/Immediate Cleaning Necessary)" }, { "code": "Heavy", "name": "Heavy (Flow Blocked/Immediate Cleaning Necessary)" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "MAINT_RATE", "length": 55, "alias": "Maintenance Rating", "type": "esriFieldTypeString" }, { "modelName": "CLEANING", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomCleaning", "description": "Cleaning Required", "type": "codedValue", "codedValues": [ { "code": "No cleaning", "name": "No cleaning" }, { "code": "Clean Opening/Grate", "name": "Clean Opening/Grate" }, { "code": "Clean interior of structure", "name": "Clean interior of structure" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "CLEANING", "length": 30, "alias": "Cleaning", "type": "esriFieldTypeString" }, { "modelName": "FLOW", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomFlow", "description": "Is water flowing", "type": "codedValue", "codedValues": [ { "code": "Flowing", "name": "Flowing" }, { "code": "Not Flowing", "name": "Not Flowing" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FLOW", "length": 15, "alias": "Flow", "type": "esriFieldTypeString" }, { "modelName": "DATE_RAIN", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DATE_RAIN", "length": 8, "alias": "Date Last Rain", "type": "esriFieldTypeDate" }, { "modelName": "SEWAGE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomSewage", "description": "Evidence of Sewage", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Sewer odor", "name": "Sewer odor" }, { "code": "Grey water", "name": "Grey water" }, { "code": "Floatables", "name": "Floatables" }, { "code": "Sewer odor/Grey water", "name": "Sewer odor/Grey water" }, { "code": "Sewer odor/Floatables", "name": "Sewer odor/Floatables" }, { "code": "Grey water/Floatables", "name": "Grey water/Floatables" }, { "code": "Sewer odor/Grey water/Floatables", "name": "Sewer odor/Grey water/Floatables" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "SEWAGE", "length": 35, "alias": "Sewage", "type": "esriFieldTypeString" }, { "modelName": "TURBIDITY", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomTurbidity", "description": "Turbidity", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Clear", "name": "Clear" }, { "code": "Cloudy", "name": "Cloudy" }, { "code": "Muddy", "name": "Muddy" }, { "code": "Undetermined", "name": "Undetermined" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "TURBIDITY", "length": 15, "alias": "Turbidity", "type": "esriFieldTypeString" }, { "modelName": "WTR_SURF", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomWtrSurf", "description": "Description of water surface in structure", "type": "codedValue", "codedValues": [ { "code": "None", "name": "None" }, { "code": "Oil sheen", "name": "Oil sheen" }, { "code": "Soap suds", "name": "Soap suds" }, { "code": "Surface scum", "name": "Surface scum" }, { "code": "Undetermined", "name": "Undetermined" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "WTR_SURF", "length": 15, "alias": "Water Surface", "type": "esriFieldTypeString" }, { "modelName": "GPS_STATUS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomInventory", "description": "Inventory type", "type": "codedValue", "codedValues": [ { "code": "GPS", "name": "GPS" }, { "code": "Not Found", "name": "Not Found" }, { "code": "Obscured", "name": "Obscured" }, { "code": "Inaccessible", "name": "Inaccessible" }, { "code": "GIS Placed", "name": "GIS Placed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "GPS_STATUS", "length": 15, "alias": "GPS Status", "type": "esriFieldTypeString" }, { "modelName": "FLAG", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomStructFlag", "description": "Flag on Structures", "type": "codedValue", "codedValues": [ { "code": "No", "name": "No" }, { "code": "Immediate Action Required", "name": "Immediate Action Required" }, { "code": "Futher Investigation", "name": "Further Investigation" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FLAG", "length": 30, "alias": "Attention Flag", "type": "esriFieldTypeString" }, { "modelName": "INACCESS", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomInaccess", "description": "Description of Inaccessibility at Structure", "type": "codedValue", "codedValues": [ { "code": "Property Owner Denied Access", "name": "Property Owner Denied Access" }, { "code": "Fenced Area - Access Denied", "name": "Fenced Area - Access Denied" }, { "code": "Pet - Access Denied", "name": "Pet - Access Denied" }, { "code": "Equipment Needed to Remove Slab/Lid", "name": "Equipment Needed to Remove Slab/Lid" }, { "code": "Buried", "name": "Buried" }, { "code": "Other", "name": "Other" }, { "code": "Not Applicable", "name": "Not Applicable" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "INACCESS", "length": 40, "alias": "Inaccessibility", "type": "esriFieldTypeString" }, { "modelName": "COMMENTS", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "COMMENTS", "length": 254, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "OUT_TYPE", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomEndType", "description": "Culvert End/PipeInlet/PipeOutlet Type", "type": "codedValue", "codedValues": [ { "code": "Headwall/Endwall", "name": "Headwall/Endwall" }, { "code": "Projected from Fill", "name": "Projected from Fill" }, { "code": "Mitered end", "name": "Mitered end" }, { "code": "Flared end section", "name": "Flared end section" }, { "code": "Pipe", "name": "Pipe" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "OUT_TYPE", "length": 20, "alias": "Pipe Outlet Type", "type": "esriFieldTypeString" }, { "modelName": "OUT_MAT", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomStructMat", "description": "Structure Material", "type": "codedValue", "codedValues": [ { "code": "Concrete", "name": "Concrete" }, { "code": "Brick", "name": "Brick" }, { "code": "Concrete and Brick", "name": "Concrete and Brick" }, { "code": "Stone", "name": "Stone" }, { "code": "Skim Coat", "name": "Skim Coat" }, { "code": "Corrugated Metal", "name": "Corrugated Metal" }, { "code": "Plastic", "name": "Plastic" }, { "code": "Other", "name": "Other" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "OUT_MAT", "length": 20, "alias": "Pipe Outlet Material", "type": "esriFieldTypeString" }, { "modelName": "OUT_REHAB", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomRehab", "description": "Inlet Rehabilitation", "type": "codedValue", "codedValues": [ { "code": "No Rehab", "name": "No Rehab" }, { "code": "Repair", "name": "Repair" }, { "code": "Replace", "name": "Replace" }, { "code": "Not Applicable", "name": "Not Applicable" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "OUT_REHAB", "length": 15, "alias": "Pipe Outlet Rehab", "type": "esriFieldTypeString" }, { "modelName": "FLOODING", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomBoolean", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "Y", "name": "Yes" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "FLOODING", "length": 7, "alias": "Flooding", "type": "esriFieldTypeString" }, { "modelName": "EROSION", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomBoolean", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "Y", "name": "Yes" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "EROSION", "length": 7, "alias": "Erosion", "type": "esriFieldTypeString" }, { "modelName": "POND", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomBoolean", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "Y", "name": "Yes" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "POND", "length": 7, "alias": "Discharge to Pond", "type": "esriFieldTypeString" }, { "modelName": "TRUE_OUTFALL", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "SWDomBoolean", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "N", "name": "No" }, { "code": "Y", "name": "Yes" }, { "code": "Unknown", "name": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "TRUE_OUTFALL", "length": 7, "alias": "Discharge to Channel", "type": "esriFieldTypeString" }, { "modelName": "watershed", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "watershed", "length": 10, "alias": "watershed", "type": "esriFieldTypeString" }, { "modelName": "labelname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "labelname", "length": 25, "alias": "labelname", "type": "esriFieldTypeString" }, { "modelName": "Outfall", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Outfall", "length": 50, "alias": "Outfall", "type": "esriFieldTypeString" }, { "modelName": "FEATURE_ID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "FEATURE_ID", "length": 50, "alias": "FEATURE_ID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/GMT+5", "respectsDaylightSaving": false, "timeZone": "Eastern Standard Time" }, "bigIntegerRestrictedTo53Bits": true, "preferredTimeReference": null, "useStandardizedQueries": true, "globalIdField": "", "description": "", "syncCanReturnChanges": false, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "R81_SDE_ROWID_UK", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "G720FEATURE_ID", "isUnique": false, "description": "", "isAscending": true, "fields": "FEATURE_ID" } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsStatistics": true, "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsQueryRelatedPagination": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": false, "supportsCountDistinct": true, "supportsCurrentUserQueries": true, "supportsAdvancedQueryRelated": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsReturningQueryExtent": true, "supportsQueryWithLodSR": false, "supportsReturningGeometryEnvelope": false, "supportsPagination": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "fullTextSearchableFields": [] }, "subtypeField": "", "supportsValidateSQL": true, "serviceItemId": "df55517e9a5e4d21b4919d766fd03e8c", "supportsCoordinatesQuantization": false, "types": [], "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "copyrightText": "" }