{ "currentVersion": 10.81, "id": 7, "name": "sdm_Equipment", "type": "Table", "description": null, "hasAttachments": true, "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": "GUID", "length": 38, "domain": null }, { "name": "SPLICEPOINTGUID", "type": "esriFieldTypeGUID", "alias": "SplicePoint GUID", "length": 38, "domain": null }, { "name": "EQUIPMENTGUID", "type": "esriFieldTypeString", "alias": "EquipmentGUID", "length": 255, "domain": null }, { "name": "SUBTYPE", "type": "esriFieldTypeInteger", "alias": "Subtype", "domain": null }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "Name", "length": 50, "domain": null }, { "name": "CIRCUITALIAS", "type": "esriFieldTypeString", "alias": "Alias", "length": 50, "domain": null }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "WORKORDER", "type": "esriFieldTypeString", "alias": "Work Order", "length": 25, "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": "USEDBY", "type": "esriFieldTypeString", "alias": "User", "length": 20, "domain": { "type": "codedValue", "name": "sdm_usedBy", "description": "", "codedValues": [ { "name": "City", "code": "City" }, { "name": "Other", "code": "Other" }, { "name": "County", "code": "County" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "CATEGORY", "type": "esriFieldTypeString", "alias": "Category", "length": 20, "domain": { "type": "codedValue", "name": "sdm_fiberEquipmentCategory", "description": "", "codedValues": [ { "name": "PatchPanel", "code": "PatchPanel" }, { "name": "Splitter", "code": "Splitter" }, { "name": "Electronics", "code": "Electronics" }, { "name": "Wireless", "code": "Wireless" }, { "name": "Microwave", "code": "Microwave" }, { "name": "FTTP", "code": "FTTP" }, { "name": "Ethernet", "code": "Ethernet" }, { "name": "Housing", "code": "Housing" }, { "name": "SONET", "code": "SONET" }, { "name": "Media Converter", "code": "Media Converter" }, { "name": "Router", "code": "Router" }, { "name": "Switch", "code": "Switch" }, { "name": "Proactive Relay", "code": "Proactive Relay" }, { "name": "Telemetry", "code": "Telemetry" }, { "name": "Other", "code": "Other" }, { "name": "Substation Automation", "code": "Substation Auto" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ANGLE", "type": "esriFieldTypeDouble", "alias": "Angle", "domain": null }, { "name": "SPLICEPOINTOID", "type": "esriFieldTypeInteger", "alias": "Splice Point OID", "domain": null }, { "name": "SDMMODIFIED", "type": "esriFieldTypeDate", "alias": "SDM Modified", "length": 8, "domain": null }, { "name": "COUNTDISP", "type": "esriFieldTypeString", "alias": "(R) Count Display", "length": 255, "domain": null }, { "name": "EQUIPMENTSIZE", "type": "esriFieldTypeSmallInteger", "alias": "Size", "domain": null }, { "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": "COMMONPORTTYPE", "type": "esriFieldTypeString", "alias": "(R) Common Port Type", "length": 20, "domain": { "type": "codedValue", "name": "sdm_fiberPortType", "description": "", "codedValues": [ { "name": "SC Ultra Polished", "code": "SC Ultra Polished" }, { "name": "SC Angle Polished", "code": "SC Angle Polished" }, { "name": "ST", "code": "ST" }, { "name": "LC", "code": "LC" }, { "name": "FC", "code": "FC" }, { "name": "MT-RJ", "code": "MT-RJ" }, { "name": "Empty", "code": "Empty" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ACCOUNTCODE", "type": "esriFieldTypeString", "alias": "Account Code", "length": 50, "domain": null }, { "name": "STATIONID", "type": "esriFieldTypeString", "alias": "Station ID", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 50, "domain": null }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": null } ], "indexes": [ { "name": "R405_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_405", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2432SPLICEPOINT", "fields": "SPLICEPOINTOID", "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 }, "dateFieldsTimeReference": null, "serviceItemId": "ffb3f060314d4996a70e1bc0beadc8bd" }