{ "currentVersion": 10.61, "id": 20, "name": "LPC_Fiber.ARCFM.F_Fiber", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FiberName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CreationUser", "type": "esriFieldTypeString", "alias": "CreationUser", "length": 50, "domain": null }, { "name": "CreationDate", "type": "esriFieldTypeDate", "alias": "DateCreated", "length": 8, "domain": null }, { "name": "LastUser", "type": "esriFieldTypeString", "alias": "LastUser", "length": 50, "domain": null }, { "name": "DateModified", "type": "esriFieldTypeDate", "alias": "DateModified", "length": 8, "domain": null }, { "name": "FiberNumber", "type": "esriFieldTypeInteger", "alias": "Num", "domain": null }, { "name": "Lessee", "type": "esriFieldTypeString", "alias": "Lessee", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Fiber Lessee", "description": "", "codedValues": [ { "name": "Unite Private Network", "code": "UPN" }, { "name": "Longmont United Hospital", "code": "LUH" }, { "name": "Boulder County", "code": "BC" }, { "name": "Ridgeview Tel", "code": "RVT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ContractNumber", "type": "esriFieldTypeString", "alias": "ContractNumber", "length": 50, "domain": null }, { "name": "ModeType", "type": "esriFieldTypeString", "alias": "ModeType", "length": 25, "domain": { "type": "codedValue", "name": "WS2_Fiber Mode", "description": "", "codedValues": [ { "name": "Singlemode", "code": "Singlemode" }, { "name": "Multimode", "code": "Multimode" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Available", "type": "esriFieldTypeInteger", "alias": "Avail", "domain": { "type": "codedValue", "name": "WS2_Fiber Availability Indicator", "description": "", "codedValues": [ { "name": "Unavailable", "code": 0 }, { "name": "Available", "code": 1 }, { "name": "Damaged", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FiberColor", "type": "esriFieldTypeString", "alias": "FColor", "length": 25, "domain": { "type": "codedValue", "name": "WS2_Fiber Colors", "description": "", "codedValues": [ { "name": "Blue", "code": "255" }, { "name": "Orange", "code": "16744448" }, { "name": "Green", "code": "65280" }, { "name": "Brown", "code": "8404992" }, { "name": "Slate", "code": "12632256" }, { "name": "White", "code": "16777215" }, { "name": "Red", "code": "16711680" }, { "name": "Black", "code": "0" }, { "name": "Yellow", "code": "16776960" }, { "name": "Violet", "code": "16711935" }, { "name": "Rose", "code": "16754856" }, { "name": "Aqua", "code": "655355" }, { "name": "Blue - 1 Stripe", "code": "255-0" }, { "name": "Orange - 1 Stripe", "code": "16744448-0" }, { "name": "Green - 1 Stripe", "code": "65280-0" }, { "name": "Brown - 1 Stripe", "code": "8404992-0" }, { "name": "Slate - 1 Stripe", "code": "512632256-0" }, { "name": "White - 1 Stripe", "code": "16777215-0" }, { "name": "Red - 1 Stripe", "code": "16711680-0" }, { "name": "Black - 1 Stripe", "code": "0-16777215" }, { "name": "Yellow - 1 Stripe", "code": "16776960-0" }, { "name": "Violet - 1 Stripe", "code": "16711935-0" }, { "name": "Rose - 1 Stripe", "code": "16754856-0" }, { "name": "Aqua - 1 Stripe", "code": "655355-0" }, { "name": "Blue - 2 Stripes", "code": "255-0-0" }, { "name": "Orange - 2 Stripes", "code": "16744448-0-0" }, { "name": "Green - 2 Stripes", "code": "65280-0-0" }, { "name": "Brown - 2 Stripes", "code": "8404992-0-0" }, { "name": "Slate - 2 Stripes", "code": "12632256-0-0" }, { "name": "White - 2 Stripes", "code": "16777215-0-0" }, { "name": "Red - 2 Stripes", "code": "16711680-0-0" }, { "name": "Black - 2 Stripes", "code": "0-16777215-16777215" }, { "name": "Yellow - 2 Stripes", "code": "16776960-0-0" }, { "name": "Violet - 2 Stripes", "code": "16711935-0-0" }, { "name": "Rose - 2 Stripes", "code": "16754856-0-0" }, { "name": "Aqua - 2 Stripes", "code": "655355-0-0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FiberName", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Fiber Color Names", "description": "", "codedValues": [ { "name": "BL", "code": "BL" }, { "name": "OR", "code": "OR" }, { "name": "GR", "code": "GR" }, { "name": "BR", "code": "BR" }, { "name": "SL", "code": "SL" }, { "name": "WH", "code": "WH" }, { "name": "RD", "code": "RD" }, { "name": "BK", "code": "BK" }, { "name": "YL", "code": "YL" }, { "name": "VL", "code": "VL" }, { "name": "RS", "code": "RS" }, { "name": "AQ", "code": "AQ" }, { "name": "BL1", "code": "BL1" }, { "name": "OR1", "code": "OR1" }, { "name": "GR1", "code": "GR1" }, { "name": "BR1", "code": "BR1" }, { "name": "SL1", "code": "SL1" }, { "name": "WH1", "code": "WH1" }, { "name": "RD1", "code": "RD1" }, { "name": "BK1", "code": "BK1" }, { "name": "YL1", "code": "YL1" }, { "name": "VL1", "code": "VL1" }, { "name": "RS1", "code": "RS1" }, { "name": "AQ1", "code": "AQ1" }, { "name": "BL2", "code": "BL2" }, { "name": "OR2", "code": "OR2" }, { "name": "GR2", "code": "GR2" }, { "name": "BR2", "code": "BR2" }, { "name": "SL2", "code": "SL2" }, { "name": "WH2", "code": "WH2" }, { "name": "RD2", "code": "RD2" }, { "name": "BK2", "code": "BK2" }, { "name": "YL2", "code": "YL2" }, { "name": "VL2", "code": "VL2" }, { "name": "RS2", "code": "RS2" }, { "name": "AQ2", "code": "AQ2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ReservedFor", "type": "esriFieldTypeString", "alias": "ReservedFor", "length": 50, "domain": { "type": "codedValue", "name": "WS2_Fiber Reserved For Entities", "description": "", "codedValues": [ { "name": "State Government", "code": "State Government" }, { "name": "City", "code": "City" }, { "name": "University", "code": "University" }, { "name": "Fire District", "code": "Fire District" }, { "name": "LPC", "code": "LPC" }, { "name": "Future OLT", "code": "Future OLT" }, { "name": "Fiber Lease", "code": "Fiber Lease" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 25, "domain": { "type": "codedValue", "name": "WS2_Fiber Status", "description": "", "codedValues": [ { "name": "Lit", "code": "Lit" }, { "name": "Dark", "code": "Dark" }, { "name": "Defective", "code": "Defective" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlassType", "type": "esriFieldTypeString", "alias": "GlassType", "length": 25, "domain": { "type": "codedValue", "name": "WS2_Fiber Glass Type", "description": "", "codedValues": [ { "name": "SMF28", "code": "SMF28" }, { "name": "SMF28e", "code": "SMF28e" }, { "name": "TrueWave", "code": "TrueWave" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FIBERPARENT", "type": "esriFieldTypeGUID", "alias": "FIBERPARENT", "length": 38, "domain": null }, { "name": "THISFIBERCLASSMODELNAME", "type": "esriFieldTypeString", "alias": "THISFIBERCLASSMODELNAME", "length": 25, "domain": null }, { "name": "FIBERPARENTCLASSMODELNAME", "type": "esriFieldTypeString", "alias": "FIBERPARENTCLASSMODELNAME", "length": 25, "domain": null }, { "name": "FIBERCHILDCLASSMODELNAME", "type": "esriFieldTypeString", "alias": "FIBERCHILDCLASSMODELNAME", "length": 25, "domain": null }, { "name": "FIBERCIRCUITGLOBALID", "type": "esriFieldTypeGUID", "alias": "FIBERCIRCUITGLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R40_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_40", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G125FIBERCIRCUIT", "fields": "FIBERCIRCUITGLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G125FIBERPARENT", "fields": "FIBERPARENT", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_40", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 11, "name": "Buffer Tube", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "FIBERPARENT", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 14, "name": "Circuit", "relatedTableId": 17, "role": "esriRelRoleDestination", "keyField": "FIBERCIRCUITGLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 30000, "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 }