{ "currentVersion": 10.81, "id": 4, "name": "gisdata7.GISDATA7.JointUse", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "CREATIONUSER", "typeIdField": "SubtypeCode", "subtypeFieldName": "SubtypeCode", "subtypeField": "SubtypeCode", "defaultSubtypeCode": 1, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "Creation User", "length": 20, "domain": null }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "Last User", "length": 20, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 10, "domain": { "type": "codedValue", "name": "JointUseOwner", "description": "", "codedValues": [ { "name": "Time Warner", "code": "TimeWarner" }, { "name": "Southwestern Bell", "code": "SBC" }, { "name": "TxDot", "code": "TxDot" }, { "name": "Guadalupe Valley Elec", "code": "GVEC" }, { "name": "Guadalupe Valley Telephone", "code": "GVTC" }, { "name": "Pedernales Electric Coop", "code": "PEC" }, { "name": "AT&T", "code": "AT&T" }, { "name": "Alpheus", "code": "ALPHEUS" }, { "name": "Fiberlight", "code": "FIBERLIGHT" }, { "name": "Other", "code": "OTHER" }, { "name": "New Braunfels Utilities", "code": "NBU" }, { "name": "UNK", "code": "UNK" }, { "name": "Not New Braunfels Utilities", "code": "NOTNBU" }, { "name": "Zayo", "code": "Zayo" }, { "name": "Century Link", "code": "CentLink" }, { "name": "MCI Verizon", "code": "MCIVerizon" }, { "name": "Comal County Fair Association", "code": "CCFA" }, { "name": "City of New Braunfels", "code": "CONB" }, { "name": "Charter Spectrum", "code": "Charter" }, { "name": "Frantic", "code": "Frantic" }, { "name": "NBISD", "code": "NBISD" }, { "name": "Astound - Grande", "code": "Astound-Grande" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ATTACHMENTTYPE", "type": "esriFieldTypeString", "alias": "Attachment Type", "length": 10, "domain": { "type": "codedValue", "name": "JointAttachType", "description": "Joint Use Attachment Type", "codedValues": [ { "name": "CATV", "code": "CaTv" }, { "name": "Phone", "code": "Phone" }, { "name": "TxDot", "code": "TxDot" }, { "name": "Fiber", "code": "Fiber" }, { "name": "Telco", "code": "Telco" }, { "name": "Power", "code": "Power" }, { "name": "Guy", "code": "Guy" }, { "name": "Unknown", "code": "UNK" }, { "name": "Cable", "code": "Cable" }, { "name": "Unknown", "code": "Unknown" }, { "name": "Antenna", "code": "Antenna" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "ATTACHMENTHEIGHT", "type": "esriFieldTypeDouble", "alias": "Attachment Height", "domain": null }, { "name": "GUYED", "type": "esriFieldTypeString", "alias": "Guyed Indicator", "length": 1, "domain": { "type": "codedValue", "name": "Yes/No Indicator", "description": "", "codedValues": [ { "name": "No", "code": "N" }, { "name": "Yes", "code": "Y" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 255, "domain": null }, { "name": "SUBTYPECODE", "type": "esriFieldTypeInteger", "alias": "Subtype CD", "domain": null }, { "name": "POLEID", "type": "esriFieldTypeInteger", "alias": "Pole ObjectID", "domain": null }, { "name": "ULSOBJECTIID", "type": "esriFieldTypeInteger", "alias": "ULS Object iID", "domain": null }, { "name": "WorkRequestID", "type": "esriFieldTypeString", "alias": "Work Request ID", "length": 20, "domain": null }, { "name": "DesignID", "type": "esriFieldTypeString", "alias": "Design ID", "length": 20, "domain": null }, { "name": "WorkLocationID", "type": "esriFieldTypeString", "alias": "Work Location ID", "length": 20, "domain": null }, { "name": "WorkFlowStatus", "type": "esriFieldTypeInteger", "alias": "Work Flow Status", "domain": { "type": "codedValue", "name": "MM Work Flow Status", "description": "Miner & Miner Work Flow Status", "codedValues": [ { "name": "None", "code": 0 }, { "name": "In Design", "code": 1 }, { "name": "Pending Approval", "code": 2 }, { "name": "Construction Approved", "code": 3 }, { "name": "In Construction", "code": 4 }, { "name": "Built", "code": 5 }, { "name": "Closed", "code": 6 }, { "name": "Cancelled", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "WorkFunction", "type": "esriFieldTypeInteger", "alias": "Work Function", "domain": { "type": "codedValue", "name": "MM Work Function", "description": "Miner & Miner Work Function", "codedValues": [ { "name": "None", "code": 0 }, { "name": "Install", "code": 1 }, { "name": "Remove", "code": 2 }, { "name": "Abandon", "code": 32 }, { "name": "Retire", "code": 16 }, { "name": "Replace", "code": -10 }, { "name": "Existing", "code": 8192 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "PASubtype", "type": "esriFieldTypeString", "alias": "PASubtype", "length": 25, "domain": null }, { "name": "OGCFID", "type": "esriFieldTypeDouble", "alias": "OGCFID", "domain": null }, { "name": "POGCFID", "type": "esriFieldTypeInteger", "alias": "POGCFID", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Overlashed", "type": "esriFieldTypeString", "alias": "Overlashed", "length": 50, "domain": { "type": "codedValue", "name": "Y\\N", "description": "yes or no", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R1216_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G8279POLEID", "fields": "POLEID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G8279ULSOBJECTII", "fields": "ULSOBJECTIID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "ATTACHMENTTYPE", "fields": "ATTACHMENTTYPE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "OGCFID", "fields": "OGCFID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "OWNER", "fields": "OWNER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "PASubtype", "fields": "PASubtype", "isAscending": true, "isUnique": false, "description": "" }, { "name": "POGCFID", "fields": "POGCFID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_1216", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1216", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "types": [ { "domains": { "OWNER": {"type": "inherited"}, "ATTACHMENTTYPE": {"type": "inherited"}, "GUYED": {"type": "inherited"}, "WorkFlowStatus": {"type": "inherited"}, "WorkFunction": {"type": "inherited"} }, "id": 1, "name": "Joint Use Attachment" } ], "subtypes": [ { "domains": { "OWNER": {"type": "inherited"}, "ATTACHMENTTYPE": {"type": "inherited"}, "GUYED": {"type": "inherited"}, "WorkFlowStatus": {"type": "inherited"}, "WorkFunction": {"type": "inherited"} }, "defaultValues": { "CREATIONUSER": null, "DATECREATED": null, "DATEMODIFIED": null, "LASTUSER": null, "OWNER": null, "ATTACHMENTTYPE": null, "ATTACHMENTHEIGHT": null, "GUYED": null, "COMMENTS": null, "SUBTYPECODE": null, "POLEID": null, "ULSOBJECTIID": null, "WorkRequestID": null, "DesignID": null, "WorkLocationID": null, "WorkFlowStatus": 0, "WorkFunction": 0, "PASubtype": null, "OGCFID": null, "POGCFID": null, "GlobalID": null, "Overlashed": null }, "code": 1, "name": "Joint Use Attachment" } ], "relationships": [ { "id": 0, "name": "Pole", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "PoleID", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "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 }