{ "currentVersion": 10.71, "cimVersion": "2.4.0", "id": 57, "name": "PoleData", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 13, "name": "ElecPole", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToOne", "role": "esriRelRoleDestination", "keyField": "LocateID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Status", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "LocateID", "type": "esriFieldTypeString", "alias": "LocateID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LocateID" }, { "name": "Administration", "type": "esriFieldTypeString", "alias": "Administration", "domain": { "type": "codedValue", "name": "ElecAdministration", "description": "Administration", "codedValues": [ { "name": "COPA", "code": "COPA" }, { "name": "Cnty", "code": "Cnty" }, { "name": "Nippon", "code": "Nippon" }, { "name": "BPA", "code": "BPA" }, { "name": "Daishowa", "code": "Daishowa" }, { "name": "Fed", "code": "Fed" }, { "name": "Private", "code": "Private" }, { "name": "PUD", "code": "PUD" }, { "name": "Rayonier", "code": "Rayonier" }, { "name": "School 121", "code": "School 121" }, { "name": "Telco", "code": "Telco" }, { "name": "USPS", "code": "USPS" }, { "name": "WSDOT", "code": "WSDOT" }, { "name": "POPA", "code": "POPA" }, { "name": "OMH", "code": "OMH" }, { "name": "CPI", "code": "CPI" }, { "name": "McKinley", "code": "McKinley" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": "COPA", "modelName": "Administration" }, { "name": "PoleOwner", "type": "esriFieldTypeString", "alias": "CityDept", "domain": { "type": "codedValue", "name": "ElecPoleOwner", "description": "Pole ownership", "codedValues": [ { "name": "CPI", "code": "CPI" }, { "name": "PACL", "code": "PACL" }, { "name": "Street Dept", "code": "Street Dept" }, { "name": "SWaste Dept", "code": "SWaste Dept" }, { "name": "Water Dept", "code": "Water Dept" }, { "name": "WWater Dept", "code": "WWater Dept" }, { "name": "Wave Cable", "code": "Wave Cable" }, { "name": "Parks Dept", "code": "Parks Dept" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": "PACL", "modelName": "PoleOwner" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "domain": { "type": "codedValue", "name": "ElecMaterials", "description": "Elec Materials", "codedValues": [ { "name": "Aluminum", "code": "Aluminum" }, { "name": "Fiberglass", "code": "Fiberglass" }, { "name": "Metal", "code": "Metal" }, { "name": "Steel", "code": "Steel" }, { "name": "Wood", "code": "Wood" }, { "name": "Concrete", "code": "Concrete" }, { "name": "PVC", "code": "PVC" }, { "name": "CIC", "code": "CIC" }, { "name": "DB", "code": "DB" }, { "name": "RSC", "code": "RSC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Material" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "InspDate", "type": "esriFieldTypeDate", "alias": "InspDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspDate" }, { "name": "TreatDate", "type": "esriFieldTypeDate", "alias": "TreatDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TreatDate" }, { "name": "AbandonDate", "type": "esriFieldTypeDate", "alias": "AbandonDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AbandonDate" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": { "type": "codedValue", "name": "ElecStatus", "description": "Elec Status", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Demolished", "code": "Demolished" }, { "name": "Inactive", "code": "Inactive" }, { "name": "Proposed", "code": "Proposed" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Sold", "code": "Sold" }, { "name": "Maintenance", "code": "Maintenance" }, { "name": "Obsolete", "code": "Obsolete" }, { "name": "Replace", "code": "Replace" }, { "name": "Outage", "code": "Outage" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 12, "defaultValue": "Active", "modelName": "Status" }, { "name": "PoleFraming", "type": "esriFieldTypeString", "alias": "PoleFraming", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleFraming" }, { "name": "PoleCond", "type": "esriFieldTypeDouble", "alias": "PoleCond", "domain": { "type": "codedValue", "name": "ElecPoleCond", "description": "Pole condition", "codedValues": [ { "name": "Replace", "code": 1 }, { "name": "Poor", "code": 2 }, { "name": "Fair", "code": 3 }, { "name": "Good", "code": 4 }, { "name": "Excellent", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PoleCond" }, { "name": "InspectCodes", "type": "esriFieldTypeString", "alias": "InspectCodes", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "InspectCodes" }, { "name": "Cable", "type": "esriFieldTypeString", "alias": "Cable", "domain": { "type": "codedValue", "name": "ElecYesNo_2", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "No", "modelName": "Cable" }, { "name": "Telco", "type": "esriFieldTypeString", "alias": "Telco", "domain": { "type": "codedValue", "name": "ElecYesNo_2", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "No", "modelName": "Telco" }, { "name": "CPI", "type": "esriFieldTypeString", "alias": "CPI", "domain": { "type": "codedValue", "name": "ElecYesNo_2", "description": "Yes No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": "No", "modelName": "CPI" }, { "name": "Remarks", "type": "esriFieldTypeString", "alias": "Remarks", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Remarks" }, { "name": "Subtype", "type": "esriFieldTypeString", "alias": "Subtype", "domain": { "type": "codedValue", "name": "ElecPoleType", "description": "Pole type", "codedValues": [ { "name": "Utility", "code": "Utility" }, { "name": "Telephone", "code": "Telephone" }, { "name": "Power", "code": "Power" }, { "name": "Signal", "code": "Signal" }, { "name": "Light", "code": "Light" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 24, "defaultValue": "Utility", "modelName": "Subtype" }, { "name": "PoleClass", "type": "esriFieldTypeInteger", "alias": "PoleClass", "domain": { "type": "codedValue", "name": "ElecPoleClass", "description": "Pole classification", "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 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PoleClass" }, { "name": "PoleHt", "type": "esriFieldTypeInteger", "alias": "PoleHt", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PoleHt" }, { "name": "WSketch", "type": "esriFieldTypeString", "alias": "WSketch", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "WSketch" }, { "name": "Lights", "type": "esriFieldTypeString", "alias": "Lights", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Lights" }, { "name": "WmdsNo", "type": "esriFieldTypeInteger", "alias": "WmdsNo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WmdsNo" } ], "indexes": [ { "name": "R832_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2318LocateID", "fields": "LocateID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "PoleData", "description": "", "prototype": { "attributes": { "Lights": null, "WmdsNo": null, "LocateID": null, "Administration": "COPA", "PoleOwner": "PACL", "Material": null, "InstallDate": null, "InspDate": null, "TreatDate": null, "AbandonDate": null, "Status": "Active", "PoleFraming": null, "PoleCond": null, "InspectCodes": null, "Cable": "No", "Telco": "No", "CPI": "No", "Remarks": null, "Subtype": "Utility", "PoleClass": null, "PoleHt": null, "WSketch": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 2000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }