{ "currentVersion": 10.91, "id": 168, "name": "Sanitary Sewer MH Inspection", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "globalid", "displayField": "Creator", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "CreationDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CreationDate" }, { "name": "Creator", "type": "esriFieldTypeString", "alias": "Creator", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Creator" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "EditDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Editor" }, { "name": "Date_Inspect", "type": "esriFieldTypeDate", "alias": "Date of Inspection", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Inspect" }, { "name": "SMH_ID", "type": "esriFieldTypeString", "alias": "SMH_ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SMH_ID" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Inspector" }, { "name": "Surface_Cover", "type": "esriFieldTypeString", "alias": "Surface Cover", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Surface_Cover" }, { "name": "OtherSurf", "type": "esriFieldTypeString", "alias": "Other - Surface Cover", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherSurf" }, { "name": "Grade2MH", "type": "esriFieldTypeDouble", "alias": "Grade to Manhole", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Grade2MH" }, { "name": "CoverDia", "type": "esriFieldTypeDouble", "alias": "Cover Diameter", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CoverDia" }, { "name": "CoverCond", "type": "esriFieldTypeString", "alias": "Cover Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CoverCond" }, { "name": "CastCond", "type": "esriFieldTypeString", "alias": "Casting Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CastCond" }, { "name": "ManholeTyp", "type": "esriFieldTypeString", "alias": "Manhole Type", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ManholeTyp" }, { "name": "ManholeCond", "type": "esriFieldTypeString", "alias": "Manhole Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ManholeCond" }, { "name": "StepCond", "type": "esriFieldTypeString", "alias": "Step Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StepCond" }, { "name": "StepType", "type": "esriFieldTypeString", "alias": "Step Type", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "StepType" }, { "name": "OtherStep", "type": "esriFieldTypeString", "alias": "Other - Step Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OtherStep" }, { "name": "ApronCond", "type": "esriFieldTypeString", "alias": "Apron Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ApronCond" }, { "name": "DropMH", "type": "esriFieldTypeString", "alias": "Drop Manhole?", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "DropMH" }, { "name": "InfiltAmount", "type": "esriFieldTypeString", "alias": "Infiltration Amount", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InfiltAmount" }, { "name": "InfiltLoc", "type": "esriFieldTypeString", "alias": "Infiltration Location", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "InfiltLoc" }, { "name": "OutletLoc", "type": "esriFieldTypeString", "alias": "Outlet Location", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "OutletLoc" }, { "name": "TotalDepth", "type": "esriFieldTypeDouble", "alias": "Depth to Invert", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TotalDepth" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments/Notes", "domain": null, "editable": true, "nullable": true, "length": 1000, "defaultValue": null, "modelName": "Comments" }, { "name": "SYS_TRANSFER_DATE", "type": "esriFieldTypeDate", "alias": "SYS_TRANSFER_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SYS_TRANSFER_DATE" }, { "name": "rowid", "type": "esriFieldTypeGUID", "alias": "rowid", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "rowid" } ], "indexes": [ { "name": "R25429_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_25429", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "Sanitary Sewer MH Inspection", "description": "", "prototype": { "attributes": { "SYS_TRANSFER_DATE": null, "Comments": null, "rowid": null, "CreationDate": null, "Creator": null, "EditDate": null, "Editor": null, "Date_Inspect": null, "SMH_ID": null, "Inspector": null, "Surface_Cover": null, "OtherSurf": null, "Grade2MH": null, "CoverDia": null, "CoverCond": null, "CastCond": null, "ManholeTyp": null, "ManholeCond": null, "StepCond": null, "StepType": null, "OtherStep": null, "ApronCond": null, "DropMH": null, "InfiltAmount": null, "InfiltLoc": null, "OutletLoc": null, "TotalDepth": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Extract", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 5000, "maxRecordCountFactor": 1 }