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