{ "currentVersion": 10.91, "id": 53, "name": "Drain MH Inspection", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Creator", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "length": 8, "domain": null }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "length": 128, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "length": 8, "domain": null }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "length": 128, "domain": null }, { "name": "Date_Inspect", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "length": 8, "domain": null }, { "name": "DMH_ID", "type": "esriFieldTypeString", "alias": "DMH_ID", "length": 255, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "length": 255, "domain": null }, { "name": "Surface_Cover", "type": "esriFieldTypeString", "alias": "Surface Cover", "length": 255, "domain": { "type": "codedValue", "name": "cvd_Surface_Cover_1", "description": "", "codedValues": [ { "name": "Asphalt", "code": "Asphalt" }, { "name": "Concrete", "code": "Concrete" }, { "name": "Earth/Grass", "code": "Earth_Grass" }, { "name": "Other", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OtherSurf", "type": "esriFieldTypeString", "alias": "Other - Surface Cover", "length": 255, "domain": null }, { "name": "Grade2MH", "type": "esriFieldTypeDouble", "alias": "Grade to Manhole", "domain": null }, { "name": "CoverDia", "type": "esriFieldTypeDouble", "alias": "Cover Diameter", "domain": null }, { "name": "CoverCond", "type": "esriFieldTypeString", "alias": "Cover Condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_CoverCond_1", "description": "", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CastCond", "type": "esriFieldTypeString", "alias": "Casting Condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_CastCond_1", "description": "", "codedValues": [ { "name": "Good", "code": "Good1" }, { "name": "Fair", "code": "Fair1" }, { "name": "Poor", "code": "Poor1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ManholeTyp", "type": "esriFieldTypeString", "alias": "Manhole Type", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ManholeTyp_1", "description": "", "codedValues": [ { "name": "Precast", "code": "Precast" }, { "name": "Brick", "code": "Brick" }, { "name": "Block", "code": "Block" }, { "name": "Combination", "code": "Combin" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ManholeCond", "type": "esriFieldTypeString", "alias": "Manhole Condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ManholeCond_1", "description": "", "codedValues": [ { "name": "Good", "code": "Good2" }, { "name": "Fair", "code": "Fair2" }, { "name": "Poor", "code": "Poor2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StepCond", "type": "esriFieldTypeString", "alias": "Step Condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_StepCond_1", "description": "", "codedValues": [ { "name": "Good", "code": "Good3" }, { "name": "Fair", "code": "Fair3" }, { "name": "Poor", "code": "Poor3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StepType", "type": "esriFieldTypeString", "alias": "Step Type", "length": 255, "domain": { "type": "codedValue", "name": "cvd_StepType_1", "description": "", "codedValues": [ { "name": "Re-Rod", "code": "ReRod" }, { "name": "Cast", "code": "Cast" }, { "name": "Reinforced Plastic", "code": "ReinfPlast" }, { "name": "Other", "code": "other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OtherStep", "type": "esriFieldTypeString", "alias": "Other - Step Type", "length": 255, "domain": null }, { "name": "ApronCond", "type": "esriFieldTypeString", "alias": "Apron Condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_ApronCond_1", "description": "", "codedValues": [ { "name": "Good", "code": "Good4" }, { "name": "Fair", "code": "Fair4" }, { "name": "Poor", "code": "Poor4" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DropMH", "type": "esriFieldTypeString", "alias": "Drop Manhole?", "length": 255, "domain": { "type": "codedValue", "name": "cvd_DropMH_1", "description": "", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Outside", "code": "Outside" }, { "name": "Inside", "code": "Inside" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InfiltAmount", "type": "esriFieldTypeString", "alias": "Infiltration Amount", "length": 255, "domain": { "type": "codedValue", "name": "cvd_InfiltAmount_1", "description": "", "codedValues": [ { "name": "None", "code": "None" }, { "name": "Light", "code": "Light" }, { "name": "Medium", "code": "Med" }, { "name": "Heavy", "code": "Heavy" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InfiltLoc", "type": "esriFieldTypeString", "alias": "Infiltration Location", "length": 255, "domain": { "type": "codedValue", "name": "cvd_InfiltLoc_1", "description": "", "codedValues": [ { "name": "Null", "code": "Null" }, { "name": "Pipe", "code": "Pipe" }, { "name": "Invert", "code": "Invert" }, { "name": "Casting", "code": "Casting" }, { "name": "Walls", "code": "Walls" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OutletLoc", "type": "esriFieldTypeString", "alias": "Outlet Location", "length": 255, "domain": { "type": "codedValue", "name": "cvd_OutletLoc_2", "description": "", "codedValues": [ { "name": "North", "code": "North" }, { "name": "Northeast", "code": "Northeast" }, { "name": "East", "code": "East" }, { "name": "Southeast", "code": "Southeast" }, { "name": "South", "code": "South" }, { "name": "Southwest", "code": "Southwest" }, { "name": "West", "code": "West" }, { "name": "Northwest", "code": "Northwest" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TotalDepth", "type": "esriFieldTypeDouble", "alias": "Depth to Invert", "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments/Notes", "length": 1000, "domain": null } ], "indexes": [ { "name": "R25431_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "GDB_168507_DMH_I", "fields": "DMH_ID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "EastLongmeadowGIS.DBO.DrainManhole", "relatedTableId": 12, "role": "esriRelRoleDestination", "keyField": "DMH_ID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "dateFieldsTimeReference": null }