{ "currentVersion": 10.71, "id": 57, "name": "REDLINE_POLE", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "structure_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": "datecreated", "type": "esriFieldTypeDate", "alias": "Date Created", "length": 8, "domain": null }, { "name": "lastuser", "type": "esriFieldTypeString", "alias": "Last User", "length": 50, "domain": null }, { "name": "datemodified", "type": "esriFieldTypeDate", "alias": "Date Modified", "length": 8, "domain": null }, { "name": "clli", "type": "esriFieldTypeString", "alias": "CLLI", "length": 100, "domain": null }, { "name": "structure_name", "type": "esriFieldTypeString", "alias": "Structure Name", "length": 255, "domain": null }, { "name": "inventory_status_code", "type": "esriFieldTypeString", "alias": "Inventory Status Code", "length": 150, "domain": { "type": "codedValue", "name": "Status", "description": "Status", "codedValues": [ { "name": "Installed", "code": "Installed" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Design Complete", "code": "DesignComplete" }, { "name": "Installed, As-Built", "code": "InstalledAsBuilt" }, { "name": "Planned", "code": "Planned" }, { "name": "Do Not Build", "code": "Do Not Build" }, { "name": "Existing", "code": "Existing" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "pole_use", "type": "esriFieldTypeString", "alias": "Pole Use", "length": 50, "domain": { "type": "codedValue", "name": "PoleUse", "description": "Pole Use", "codedValues": [ { "name": "Telecommunication", "code": "TELCOM" }, { "name": "Streetlight", "code": "STREET" }, { "name": "Primary", "code": "PRIMARY" }, { "name": "Secondary", "code": "SECONDARY" }, { "name": "Power", "code": "POWER" }, { "name": "Transmission", "code": "TRANS" }, { "name": "Distribution", "code": "DISTR" }, { "name": "Joint", "code": "JOINT" }, { "name": "Telephone", "code": "PHONE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "class", "type": "esriFieldTypeInteger", "alias": "Class", "domain": { "type": "codedValue", "name": "PoleClass", "description": "Pole Class", "codedValues": [ { "name": "1", "code": 1 }, { "name": "2", "code": 2 }, { "name": "3", "code": 3 }, { "name": "4", "code": 4 }, { "name": "5", "code": 5 }, { "name": "6", "code": 6 }, { "name": "7", "code": 7 }, { "name": "8", "code": 8 }, { "name": "9", "code": 9 }, { "name": "10", "code": 10 }, { "name": "H1", "code": 11 }, { "name": "H2", "code": 12 }, { "name": "H3", "code": 13 }, { "name": "H4", "code": 14 }, { "name": "Unknown", "code": 15 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "material", "type": "esriFieldTypeInteger", "alias": "Material", "domain": { "type": "codedValue", "name": "PoleMaterial", "description": "Pole Material", "codedValues": [ { "name": "Wood", "code": 1 }, { "name": "Aluminum", "code": 2 }, { "name": "Concrete", "code": 3 }, { "name": "Steel", "code": 4 }, { "name": "Fiberglass", "code": 5 }, { "name": "Composite", "code": 6 }, { "name": "Other", "code": 7 }, { "name": "Unknown", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "treatmenttype", "type": "esriFieldTypeInteger", "alias": "Treatment Type", "domain": { "type": "codedValue", "name": "PoleTreatmentType", "description": "Pole Treatment Type", "codedValues": [ { "name": "Creosote", "code": 1 }, { "name": "Paint", "code": 2 }, { "name": "Penta", "code": 3 }, { "name": "Chromated Copper Arsenates", "code": 4 }, { "name": "Other", "code": 5 }, { "name": "Copper Naphthenate", "code": 6 }, { "name": "None", "code": 7 }, { "name": "Unknown", "code": 8 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "height", "type": "esriFieldTypeInteger", "alias": "Height", "domain": { "type": "codedValue", "name": "PoleHeight", "description": "Pole Height", "codedValues": [ { "name": "20'", "code": 1 }, { "name": "25'", "code": 2 }, { "name": "30'", "code": 3 }, { "name": "35'", "code": 4 }, { "name": "40'", "code": 5 }, { "name": "45'", "code": 6 }, { "name": "50'", "code": 7 }, { "name": "55'", "code": 8 }, { "name": "60'", "code": 9 }, { "name": "65'", "code": 10 }, { "name": "70'", "code": 11 }, { "name": "75'", "code": 12 }, { "name": "80'", "code": 13 }, { "name": "85'", "code": 14 }, { "name": "90'", "code": 15 }, { "name": "95'", "code": 16 }, { "name": "Greater than 95'", "code": 17 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "Diameter", "domain": null }, { "name": "foundationtype", "type": "esriFieldTypeInteger", "alias": "Height", "domain": { "type": "codedValue", "name": "PoleFoundationType", "description": "Pole Foundation Type", "codedValues": [ { "name": "Set Extra Deep in Earth", "code": 1 }, { "name": "Set Normally in Earth", "code": 2 }, { "name": "Set Normally with Concrete Backfill", "code": 3 }, { "name": "Set on Concrete Foundation", "code": 4 }, { "name": "Other", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "grounded", "type": "esriFieldTypeString", "alias": "Grounded", "length": 5, "domain": { "type": "codedValue", "name": "YesNoText", "description": "Yes\\No Text Values", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "hasriser", "type": "esriFieldTypeString", "alias": "Has Riser", "length": 5, "domain": { "type": "codedValue", "name": "YesNoText", "description": "Yes\\No Text Values", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "risercount", "type": "esriFieldTypeInteger", "alias": "Number of Risers", "domain": null }, { "name": "yearmanufactured", "type": "esriFieldTypeInteger", "alias": "Year Manufactured", "domain": null }, { "name": "installationdate", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "cost", "type": "esriFieldTypeDouble", "alias": "Cost", "domain": null }, { "name": "accountcode", "type": "esriFieldTypeString", "alias": "Account Code", "length": 100, "domain": null }, { "name": "owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 255, "domain": null }, { "name": "owner_contact_number", "type": "esriFieldTypeString", "alias": "Cable Owner Contact Number", "length": 100, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "ipid", "type": "esriFieldTypeString", "alias": "IPID", "length": 90, "domain": null }, { "name": "hyperlink", "type": "esriFieldTypeString", "alias": "Hyperlink", "length": 255, "domain": null }, { "name": "workorderid", "type": "esriFieldTypeString", "alias": "Work Order ID", "length": 50, "domain": null }, { "name": "symbolrotation", "type": "esriFieldTypeDouble", "alias": "Symbol Rotation", "domain": null }, { "name": "threegisid", "type": "esriFieldTypeGUID", "alias": "3-GIS ID", "length": 38, "domain": null }, { "name": "proj_category", "type": "esriFieldTypeString", "alias": "Project Category", "length": 50, "domain": null }, { "name": "replaceflag", "type": "esriFieldTypeString", "alias": "Replace Flag", "length": 50, "domain": { "type": "codedValue", "name": "YesNoText", "description": "Yes\\No Text Values", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" } }, { "name": "status", "type": "esriFieldTypeString", "alias": "STATUS", "length": 50, "domain": null }, { "name": "utilityid", "type": "esriFieldTypeString", "alias": "UTILITYID", "length": 50, "domain": null }, { "name": "city", "type": "esriFieldTypeString", "alias": "CITY", "length": 50, "domain": null }, { "name": "county", "type": "esriFieldTypeString", "alias": "COUNTY", "length": 50, "domain": null }, { "name": "lat", "type": "esriFieldTypeString", "alias": "LAT", "length": 50, "domain": null }, { "name": "long", "type": "esriFieldTypeString", "alias": "LONG", "length": 50, "domain": null }, { "name": "pole_number", "type": "esriFieldTypeString", "alias": "POLE_NUMBER", "length": 50, "domain": null }, { "name": "pole_circuit_number", "type": "esriFieldTypeString", "alias": "POLE_CIRCUIT_NUMBER", "length": 50, "domain": null }, { "name": "pole_station_number", "type": "esriFieldTypeString", "alias": "POLE_STATION_NUMBER", "length": 50, "domain": null }, { "name": "id", "type": "esriFieldTypeGUID", "alias": "ID", "length": 38, "domain": null }, { "name": "redlineid", "type": "esriFieldTypeGUID", "alias": "REDLINEID", "length": 38, "domain": null }, { "name": "edittrackinguser", "type": "esriFieldTypeString", "alias": "EDITTRACKINGUSER", "length": 255, "domain": null }, { "name": "edittrackingdate", "type": "esriFieldTypeDate", "alias": "EDITTRACKINGDATE", "length": 8, "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "length": 38, "domain": null }, { "name": "rotation", "type": "esriFieldTypeDouble", "alias": "Symbol Rotation", "domain": null }, { "name": "contract_id", "type": "esriFieldTypeString", "alias": "Contract Number", "length": 20, "domain": null }, { "name": "planningid", "type": "esriFieldTypeGUID", "alias": "Planning Id", "length": 38, "domain": null }, { "name": "isdelete", "type": "esriFieldTypeSmallInteger", "alias": "Is Delete", "domain": null }, { "name": "timestamp", "type": "esriFieldTypeDate", "alias": "Timestamp", "length": 8, "domain": null }, { "name": "clonetype", "type": "esriFieldTypeString", "alias": "Clone Type", "length": 50, "domain": null }, { "name": "isplanning", "type": "esriFieldTypeSmallInteger", "alias": "Is Planning", "domain": null } ], "indexes": [ { "name": "R324_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_324", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I688redlineid", "fields": "redlineid", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 73, "name": "REDLINE_POINT", "relatedTableId": 15, "role": "esriRelRoleDestination", "keyField": "redlineid", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "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 }