{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 1, "name": "btvgis.SDELOADER.CBInspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "INSDATE", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility Identifier", "length": 50, "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 255, "domain": null }, { "name": "VOLUME", "type": "esriFieldTypeSmallInteger", "alias": "Volume of Debris", "domain": { "type": "codedValue", "name": "CBVolume", "description": "Volume of debris in catch basin", "codedValues": [ { "name": "< 25% of Sump", "code": 1 }, { "name": "25-50% of Sump", "code": 2 }, { "name": "> 50% of Sump", "code": 3 }, { "name": "Outlet Buried", "code": 4 }, { "name": "CB Filled to Rim", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUMPDEPTH", "type": "esriFieldTypeDouble", "alias": "Depth of Sump (Inches)", "domain": null }, { "name": "WALL", "type": "esriFieldTypeString", "alias": "Wall Material", "length": 255, "domain": { "type": "codedValue", "name": "piCatchbasinWallMaterial", "description": "Catchbasin Wall Material", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CONDITION", "type": "esriFieldTypeString", "alias": "Base Condition", "length": 255, "domain": { "type": "codedValue", "name": "CBCondition", "description": "catch basin condition rating", "codedValues": [ { "name": "Excellent", "code": "1" }, { "name": "Good", "code": "2" }, { "name": "Fair", "code": "3" }, { "name": "Poor", "code": "4" }, { "name": "Failure Imminent", "code": "5" }, { "name": "Not Rated", "code": "-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GRATETYPE", "type": "esriFieldTypeSmallInteger", "alias": "Grate Type", "domain": { "type": "codedValue", "name": "CBGrateType", "description": "The type of grate on the CB", "codedValues": [ { "name": "Standard Square", "code": 1 }, { "name": "Rectangle with Bar", "code": 2 }, { "name": "Hurricane", "code": 3 }, { "name": "Directional", "code": 4 }, { "name": "Dome Grate", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DRAINMRKR", "type": "esriFieldTypeString", "alias": "Drain Marker", "length": 255, "domain": { "type": "codedValue", "name": "YesNoUnableToVerify", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unable to Verify", "code": "Unable to Verify" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CLEANED", "type": "esriFieldTypeString", "alias": "Was the Basin Cleaned", "length": 255, "domain": { "type": "codedValue", "name": "YesNoUnableToVerify", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unable to Verify", "code": "Unable to Verify" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTLETHOOD", "type": "esriFieldTypeString", "alias": "Hood on Outlet", "length": 255, "domain": { "type": "codedValue", "name": "YesNoUnableToVerify", "description": "A yes/no indicator", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" }, { "name": "Unable to Verify", "code": "Unable to Verify" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "length": 255, "domain": null }, { "name": "INSPECTOR", "type": "esriFieldTypeString", "alias": "Inspection User", "length": 255, "domain": null }, { "name": "INSSTATUS", "type": "esriFieldTypeString", "alias": "Inspection Status", "length": 255, "domain": { "type": "codedValue", "name": "InspectStatus", "description": "The status of the inspection", "codedValues": [ { "name": "Unassigned", "code": "Unassigned" }, { "name": "Assigned", "code": "Assigned" }, { "name": "In Progress", "code": "In Progress" }, { "name": "Completed", "code": "Completed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INVDEPTH", "type": "esriFieldTypeDouble", "alias": "INVERT DEPTH", "domain": null }, { "name": "RISERONDITION", "type": "esriFieldTypeString", "alias": "Riser Condition", "length": 255, "domain": { "type": "codedValue", "name": "CBCondition", "description": "catch basin condition rating", "codedValues": [ { "name": "Excellent", "code": "1" }, { "name": "Good", "code": "2" }, { "name": "Fair", "code": "3" }, { "name": "Poor", "code": "4" }, { "name": "Failure Imminent", "code": "5" }, { "name": "Not Rated", "code": "-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ASSETID", "type": "esriFieldTypeString", "alias": "Asset ID", "length": 255, "domain": null }, { "name": "RISERMAT", "type": "esriFieldTypeString", "alias": "RISERMAT", "length": 255, "domain": { "type": "codedValue", "name": "piCatchbasinWallMaterial", "description": "Catchbasin Wall Material", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INLETTYPE", "type": "esriFieldTypeString", "alias": "INLETTYPE", "length": 255, "domain": { "type": "codedValue", "name": "piInletTypes", "description": "List of inlet types", "codedValues": [ { "name": "Catchbasin", "code": "Catchbasin" }, { "name": "Rear Yard", "code": "Rear Yard" }, { "name": "Roof", "code": "Roof" }, { "name": "Open Lid Manhole", "code": "Open Lid Manhole" }, { "name": "Closed Lid Manhole", "code": "Closed Lid Manhole" }, { "name": "Standard", "code": "Standard" }, { "name": "Headwall", "code": "Headwall" }, { "name": "Other", "code": "Other" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Drywell", "code": "Drywell" }, { "name": "Trench Drain", "code": "Trench Drain" }, { "name": "Curb Inlet", "code": "Curb Inlet" }, { "name": "Dome/Beehive", "code": "DomeBeehive" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ACCESSDIAM", "type": "esriFieldTypeDouble", "alias": "ACCESSDIAM", "domain": { "type": "range", "name": "piAccessDiameter", "description": "Valid range of infrastructure access diameters", "range": [ 0, 72 ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OUTLETDIAM", "type": "esriFieldTypeDouble", "alias": "OUTLETDIAM", "domain": { "type": "codedValue", "name": "piPipeDiameter", "description": "A list of pipe diameters", "codedValues": [ { "name": "3/4\"", "code": 0.75 }, { "name": "1\"", "code": 1 }, { "name": "1 1/4\"", "code": 1.25 }, { "name": "1 1/2\"", "code": 1.5 }, { "name": "2\"", "code": 2 }, { "name": "2 1/2\"", "code": 2.5 }, { "name": "3\"", "code": 3 }, { "name": "4\"", "code": 4 }, { "name": "6\"", "code": 6 }, { "name": "8\"", "code": 8 }, { "name": "10\"", "code": 10 }, { "name": "12\"", "code": 12 }, { "name": "14\"", "code": 14 }, { "name": "15\"", "code": 15 }, { "name": "16\"", "code": 16 }, { "name": "18\"", "code": 18 }, { "name": "20\"", "code": 20 }, { "name": "21\"", "code": 21 }, { "name": "24\"", "code": 24 }, { "name": "30\"", "code": 30 }, { "name": "36\"", "code": 36 }, { "name": "40\"", "code": 40 }, { "name": "42\"", "code": 42 }, { "name": "48\"", "code": 48 }, { "name": "54\"", "code": 54 }, { "name": "60\"", "code": 60 }, { "name": "66\"", "code": 66 }, { "name": "72\"", "code": 72 }, { "name": "75\"", "code": 75 }, { "name": "96\"", "code": 96 }, { "name": "108\"", "code": 108 }, { "name": "Unknown", "code": 0 }, { "name": "Other", "code": -1 }, { "name": "22\"", "code": 22 }, { "name": "120\"", "code": 120 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "OUTLETMAT", "type": "esriFieldTypeString", "alias": "OUTLETMAT", "length": 255, "domain": { "type": "codedValue", "name": "piPipeMaterial", "description": "The list of pipe materials types based on the NASSCO standards", "codedValues": [ { "name": "ABS Plastic", "code": "ABS" }, { "name": "Asbestos Cement", "code": "AC" }, { "name": "Asphalt", "code": "ASP" }, { "name": "Brick", "code": "BR" }, { "name": "Cast Iron", "code": "CAS" }, { "name": "Clay Tile", "code": "CT" }, { "name": "Concrete (Non-Reinforced)", "code": "CP" }, { "name": "Concrete Segments (Bolted)", "code": "CSB" }, { "name": "Concrete Segments (Unbolted)", "code": "CSU" }, { "name": "Corrugated Metal", "code": "CMP" }, { "name": "Copper", "code": "COP" }, { "name": "Cured In Place", "code": "CIPP" }, { "name": "Ductile Iron", "code": "DIP" }, { "name": "Fiberglass Reinforced", "code": "FRP" }, { "name": "Earth & Geotextile", "code": "EARGEO" }, { "name": "Earthen", "code": "EAR" }, { "name": "Geotextile", "code": "GEO" }, { "name": "Galvanized Pipe", "code": "GP" }, { "name": "Glass Reinforced Cement", "code": "GRC" }, { "name": "Pitch Fiber (Orangeburg)", "code": "OB" }, { "name": "Plastic/Steel Composite", "code": "PSC" }, { "name": "Polyethylene", "code": "PE" }, { "name": "Polypropylene", "code": "PP" }, { "name": "Polyvinyl Chloride", "code": "PVC" }, { "name": "Pre-Stressed Concrete Cylinder", "code": "PCCP" }, { "name": "Reinforced Concrete", "code": "RCP" }, { "name": "Reinforced Plastic (Truss)", "code": "RPM" }, { "name": "Segmented Block", "code": "SB" }, { "name": "Steel", "code": "SP" }, { "name": "Transite", "code": "TTE" }, { "name": "Vitrified Clay", "code": "VCP" }, { "name": "Wood", "code": "WD" }, { "name": "Other", "code": "OTH" }, { "name": "Unknown", "code": "UNK" }, { "name": "Brick Masonry", "code": "BMP" }, { "name": "High Density Polyethylene", "code": "HDPE" }, { "name": "Injection Molded Polypropelyne (open bottom)", "code": "IMPP" }, { "name": "Asphalt Coated Corrugated Metal Pipe", "code": "ACCMP" }, { "name": "Perforated Polyvinyl Chloride", "code": "PPVC" }, { "name": "Perforated Asphalt Coated Corrugated Galvanized Metal Pipe", "code": "PACCGMP" }, { "name": "C900", "code": "C900" }, { "name": "Corrugated Polyethylene Pipe", "code": "CPEP" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Company", "type": "esriFieldTypeString", "alias": "Company", "length": 255, "domain": { "type": "codedValue", "name": "ssCBCleaner", "description": "DPW, contractor", "codedValues": [ { "name": "Contractor", "code": "Contractor" }, { "name": "DPW - Streets", "code": "DPW - Streets" }, { "name": "DPW - Water", "code": "DPW - Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "G2723FACILITYID", "fields": "FACILITYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R1266_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "dff3e6e9ca2d485ab87893eff3539d24" }