{ "currentVersion": 10.91, "id": 17, "name": "telecom.GISDATA.Duct", "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": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Creation User", "length": 50, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 50, "domain": null }, { "name": "IPID", "type": "esriFieldTypeGUID", "alias": "Item of Plant ID", "length": 38, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "Comments", "length": 100, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 20, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 20, "domain": null }, { "name": "PARTNUMBER", "type": "esriFieldTypeString", "alias": "Part Number", "length": 20, "domain": null }, { "name": "MATERIAL", "type": "esriFieldTypeInteger", "alias": "Material", "domain": { "type": "codedValue", "name": "WS1_ConduitMaterial", "description": "Provides options for the type of Anchor. Used with the Coduit.Material, Duct.Material, and Innerduct.Material attributes", "codedValues": [ { "name": "HDPE", "code": 1 }, { "name": "PVC", "code": 2 }, { "name": "SplitHDPE", "code": 3 }, { "name": "SplitPVC", "code": 4 }, { "name": "BlackIronPipe", "code": 5 }, { "name": "BlackSteelPipe", "code": 6 }, { "name": "CastIronPipe", "code": 7 }, { "name": "ClaySewerPipe", "code": 8 }, { "name": "FlexDuct", "code": 9 }, { "name": "SteelCasing", "code": 10 }, { "name": "TerraCotta", "code": 11 }, { "name": "Wood", "code": 12 }, { "name": "Quad", "code": 13 }, { "name": "Unknown", "code": 14 }, { "name": "NotApplicable", "code": 15 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MATERIALCOST", "type": "esriFieldTypeDouble", "alias": "Material Cost", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "CALCULATEDLENGTH", "type": "esriFieldTypeDouble", "alias": "Calculated Length", "domain": null }, { "name": "MEASUREDLENGTH", "type": "esriFieldTypeDouble", "alias": "Measured Length", "domain": { "type": "range", "name": "WS1_Measured Length", "description": "Provides range limits for the Measure Length. Used with the MeasuredLength attribute on the following classes: Conduit, CopperCable, FiberCable, Duct, Innerduct and Span.", "range": [ 1, 10000 ], "mergePolicy": "esriMPTSumValues", "splitPolicy": "esriSPTGeometryRatio" } }, { "name": "ACCOUNTCODE", "type": "esriFieldTypeString", "alias": "Account Code", "length": 20, "domain": null }, { "name": "INSTALLATIONDATE", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "CONDUITID", "type": "esriFieldTypeGUID", "alias": "Conduit ID", "length": 38, "domain": null }, { "name": "DUCTNUMBER", "type": "esriFieldTypeInteger", "alias": "Duct Number", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 100, "domain": null } ], "indexes": [ { "name": "FDO_OBJECTID", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "FDO_GLOBALID", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G48CONDUITID", "fields": "CONDUITID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G48IPID", "fields": "IPID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 10, "name": "FiberCable", "relatedTableId": 11, "role": "esriRelRoleOrigin", "keyField": "IPID", "cardinality": "esriRelCardinalityManyToMany", "composite": false }, { "id": 13, "name": "Innerduct", "relatedTableId": 18, "role": "esriRelRoleOrigin", "keyField": "IPID", "cardinality": "esriRelCardinalityOneToMany", "composite": true }, { "id": 6, "name": "Conduit", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "ConduitID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "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 }, "dateFieldsTimeReference": null }