{ "currentVersion": 10.81, "id": 8, "name": "sdm_PathDetail", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "PATHGUID", "type": "esriFieldTypeGUID", "alias": "CablePathGUID", "length": 38, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeString", "alias": "Material", "length": 50, "domain": { "type": "codedValue", "name": "sdm_conduitMaterial", "description": "", "codedValues": [ { "name": "FIBER", "code": "FIBER" }, { "name": "STEEL", "code": "STEEL" }, { "name": "WOOD", "code": "WOOD" }, { "name": "PVC", "code": "PVC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "STATUS", "type": "esriFieldTypeInteger", "alias": "Status", "domain": { "type": "codedValue", "name": "sdm_facilityStatus", "description": "STATUS", "codedValues": [ { "name": "Proposed", "code": 11 }, { "name": "Existing", "code": 101 }, { "name": "Abandoned", "code": 121 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WORKORDER", "type": "esriFieldTypeString", "alias": "Work Order", "length": 25, "domain": null }, { "name": "SEQUENCE", "type": "esriFieldTypeString", "alias": "sequence", "length": 50, "domain": null }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "Category", "length": 50, "domain": { "type": "codedValue", "name": "sdm_pathcategory", "description": "Categorizes the type of path if not used in the name", "codedValues": [ { "name": "conduit", "code": "conduit" }, { "name": "innerduct", "code": "innerduct" }, { "name": "microduct", "code": "microduct" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CABLEGUID", "type": "esriFieldTypeGUID", "alias": "CableGuid", "length": 38, "domain": null }, { "name": "DATATYPE", "type": "esriFieldTypeString", "alias": "Data Type", "length": 10, "domain": null }, { "name": "COLOR", "type": "esriFieldTypeString", "alias": "color", "length": 50, "domain": { "type": "codedValue", "name": "sdm_conduitColors", "description": "Hexadecimal color codes", "codedValues": [ { "name": "Black", "code": "0x000000" }, { "name": "White", "code": "0xFFFFFF" }, { "name": "Gray", "code": "0x808080" }, { "name": "Orange", "code": "0xFFA500" }, { "name": "Blue", "code": "0x6464FF" }, { "name": "Black with white stripe", "code": "0x000000;0xFFFFFF" }, { "name": "Black with green stripe", "code": "0x000000;0x00FF00" }, { "name": "Black with orange stripe", "code": "0x000000;0xFFA000" }, { "name": "Black with blue stripe", "code": "0x000000;0x6464FF" }, { "name": "Black with yellow stripe", "code": "0x000000;0xFFF700" }, { "name": "Black with red stripe", "code": "0x000000;0xFF0000" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PATHDETAILPARENT", "type": "esriFieldTypeGUID", "alias": "pathDetailParent", "length": 38, "domain": null }, { "name": "PATHDETAILSIZE", "type": "esriFieldTypeString", "alias": "pathDetailSize", "length": 50, "domain": { "type": "codedValue", "name": "sdm_pathDetailSize", "description": "Sizes of path category, defaulted with conduit sizes", "codedValues": [ { "name": "1.25\"", "code": "1.25\"" }, { "name": "1.5\"", "code": "1.5\"" }, { "name": "2\"", "code": "2\"" }, { "name": "3\"", "code": "3\"" }, { "name": "4\"", "code": "4\"" }, { "name": "6\"", "code": "6\"" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "name", "length": 50, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 20, "domain": { "type": "codedValue", "name": "sdm_company", "description": "", "codedValues": [ { "name": "City", "code": "CIty" }, { "name": "Other", "code": "Other" }, { "name": "County", "code": "County" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CONTRACT", "type": "esriFieldTypeString", "alias": "Contract", "length": 30, "domain": null } ], "indexes": [ { "name": "R406_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_406", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2433PATHGUID", "fields": "PATHGUID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2433PATHDETAILP", "fields": "PATHDETAILPARENT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2433CABLEGUID", "fields": "CABLEGUID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": false, "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 }, "serviceItemId": "ffb3f060314d4996a70e1bc0beadc8bd" }