{ "currentVersion": 10.61, "id": 60, "name": "Manhole Attributes", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "STENCILYEAR", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "MANHLEDIAM", "type": "esriFieldTypeSmallInteger", "alias": "Diameter", "domain": null }, { "name": "MANHLEMATR", "type": "esriFieldTypeSmallInteger", "alias": "Material", "domain": { "type": "codedValue", "name": "MATERIALS", "description": "MATERIALS FOR UTILITIES", "codedValues": [ { "name": "VCP", "code": 1 }, { "name": "DIP", "code": 2 }, { "name": "PVC", "code": 3 }, { "name": "AC", "code": 5 }, { "name": "HDP", "code": 6 }, { "name": "BLK", "code": 7 }, { "name": "BRK", "code": 8 }, { "name": "CON", "code": 9 }, { "name": "???", "code": 999 }, { "name": "CASTIP", "code": 4 }, { "name": "CIPP", "code": 10 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FRAMETYPE", "type": "esriFieldTypeSmallInteger", "alias": "Frame Type", "domain": { "type": "codedValue", "name": "FRAMETYPE", "description": "UTILITY STRUCTURE FRAME TYPES", "codedValues": [ { "name": "BEEHIVE - SHORT", "code": 1 }, { "name": "BEEHIVE - TALL", "code": 2 }, { "name": "CURB BOX", "code": 3 }, { "name": "CIRCULAR", "code": 4 }, { "name": "RECTANGULAR", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "FRAMEHGT", "type": "esriFieldTypeSmallInteger", "alias": "Frame Height", "domain": { "type": "codedValue", "name": "FRAMEHEIGHT", "description": "UTILITY STRUCTURE FRAME HEIGHTS", "codedValues": [ { "name": "LOW BOY", "code": 1 }, { "name": "4 INCH", "code": 2 }, { "name": "5 INCH", "code": 3 }, { "name": "6 INCH", "code": 4 }, { "name": "7 INCH", "code": 5 }, { "name": "8 INCH", "code": 6 }, { "name": "9 INCH", "code": 7 }, { "name": "NONE", "code": 8 }, { "name": "10 INCH", "code": 9 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "LIDTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Lid Type", "domain": { "type": "codedValue", "name": "STORM LID TYPES", "description": "STORM MANHOLE LID TYPES", "codedValues": [ { "name": "OPEN", "code": 1 }, { "name": "CLOSED W/ OPEN PICKHOLE", "code": 2 }, { "name": "CLOSED W/ CLOSED PICKHOLE", "code": 3 }, { "name": "CLOSED W/ CLOSED PICKHOLE AND GASKET", "code": 4 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STEPS", "type": "esriFieldTypeSmallInteger", "alias": "Steps", "domain": { "type": "codedValue", "name": "STEPS", "description": "PRESENCE OF STEPS", "codedValues": [ { "name": "YES", "code": 1 }, { "name": "NO", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RIMELEV", "type": "esriFieldTypeDouble", "alias": "Rim Elevation", "domain": null }, { "name": "UNDERDRAIN", "type": "esriFieldTypeSmallInteger", "alias": "Underdrain", "domain": { "type": "codedValue", "name": "UNDERDRAIN", "description": "PRESENCE OF UNDERDRAIN", "codedValues": [ { "name": "YES", "code": 1 }, { "name": "NO", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "RINGNUMBER", "type": "esriFieldTypeSmallInteger", "alias": "Number of Rings", "domain": null }, { "name": "RINGMATR", "type": "esriFieldTypeSmallInteger", "alias": "Ring Material", "domain": { "type": "codedValue", "name": "RINGMATERIAL", "description": "MANHOLE RING MATERIAL", "codedValues": [ { "name": "CONCRETE", "code": 1 }, { "name": "PLASTIC", "code": 2 }, { "name": "BRICK", "code": 3 }, { "name": "OTHER", "code": 99 }, { "name": "UNKNOWN", "code": 999 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "NDEIDSTRM", "type": "esriFieldTypeDouble", "alias": "Structure ID", "domain": null }, { "name": "STENCILYEAR", "type": "esriFieldTypeString", "alias": "Stencil Year", "length": 4, "domain": null }, { "name": "MAINTBY", "type": "esriFieldTypeSmallInteger", "alias": "MAINTBY", "domain": { "type": "codedValue", "name": "CBMAINT", "description": "CATCH BASIN MAINTENANCED BY", "codedValues": [ { "name": "VILLAGE OF LISLE", "code": 1 }, { "name": "DUPAGE COUNTY", "code": 2 }, { "name": "STATE OF ILLINOIS", "code": 3 }, { "name": "PRIVATE", "code": 4 }, { "name": "OTHER", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "INSPECT", "type": "esriFieldTypeSmallInteger", "alias": "INSPECT", "domain": { "type": "codedValue", "name": "YES OR NO", "description": "", "codedValues": [ { "name": "Y", "code": 1 }, { "name": "N", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R1211_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G4032NDEIDSTRM", "fields": "NDEIDSTRM", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "MANHOLE FEATURES", "relatedTableId": 33, "role": "esriRelRoleDestination", "keyField": "NDEIDSTRM", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }