{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 107, "name": "Pole Equipment Head", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "FACILITYID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FacilityID", "length": 20, "domain": null }, { "name": "PARENTID", "type": "esriFieldTypeString", "alias": "ParentID", "length": 20, "domain": null }, { "name": "INTNUM", "type": "esriFieldTypeSmallInteger", "alias": "Intersection Number", "domain": null }, { "name": "LOCATION", "type": "esriFieldTypeString", "alias": "Location", "length": 100, "domain": null }, { "name": "TRAVDIR", "type": "esriFieldTypeString", "alias": "Travel Direction", "length": 50, "domain": { "type": "codedValue", "name": "TravelDir", "description": "Travel Directions", "codedValues": [ { "name": "Northbound", "code": "NB" }, { "name": "Southbound", "code": "SB" }, { "name": "Eastbound", "code": "EB" }, { "name": "Westbound", "code": "WB" }, { "name": "None", "code": "NA" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PHASE", "type": "esriFieldTypeString", "alias": "Phase", "length": 50, "domain": { "type": "codedValue", "name": "ITSPhase", "description": "ITSPhase", "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": "None", "code": "None" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TYPE", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": { "type": "codedValue", "name": "ITSPoleHeadType", "description": "ITSPoleHeadType", "codedValues": [ { "name": "Vehicle", "code": "Vehicle" }, { "name": "Pedestrian", "code": "Pedestrian" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MODEL", "type": "esriFieldTypeString", "alias": "Model", "length": 50, "domain": { "type": "codedValue", "name": "ITSPoleHeadModel", "description": "ITSPoleHeadModel", "codedValues": [ { "name": "Type A", "code": "Type A" }, { "name": "Type C", "code": "Type C" }, { "name": "Type D", "code": "Type D" }, { "name": "Type F", "code": "Type F" }, { "name": "Type FY", "code": "Type FY" }, { "name": "Type G", "code": "Type G" }, { "name": "Type Optical 3M", "code": "Type Optical 3M" }, { "name": "Type Q", "code": "Type Q" }, { "name": "Type R", "code": "Type R" }, { "name": "Type S", "code": "Type S" }, { "name": "Type T", "code": "Type T" }, { "name": "Pedestrian", "code": "Pedestrian" }, { "name": "Pedestrian - Countdown", "code": "Pedestrian - Countdown" }, { "name": "Pedestrian - LED", "code": "Pedestrian - LED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ISACTIVE", "type": "esriFieldTypeString", "alias": "IsActive", "length": 10, "domain": { "type": "codedValue", "name": "YesNoText", "description": "Yes and No Text Codes and Descriptions", "codedValues": [ { "name": "No", "code": "No" }, { "name": "Yes", "code": "Yes" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 50, "domain": { "type": "codedValue", "name": "ITSStatus", "description": "ITSStatus", "codedValues": [ { "name": "Future", "code": "Future" }, { "name": "In Service", "code": "In Service" }, { "name": "Relocated", "code": "Relocated" }, { "name": "Removed", "code": "Removed" }, { "name": "Shop Disposal", "code": "Shop Disposal" }, { "name": "Shop Test Area (Out of Service)", "code": "Shop Test Area (Out of Service)" }, { "name": "Shop Test Intersection", "code": "Shop Test Intersection" }, { "name": "Shop Tested (Spare)", "code": "Shop Tested (Spare)" }, { "name": "Down (Out of Service)", "code": "Down (Out of Service)" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "COMMENT", "type": "esriFieldTypeString", "alias": "Comment", "length": 100, "domain": null }, { "name": "LEGACYID", "type": "esriFieldTypeString", "alias": "LegacyID", "length": 20, "domain": null }, { "name": "OWNER", "type": "esriFieldTypeString", "alias": "Owner", "length": 20, "domain": { "type": "codedValue", "name": "ITSOwner", "description": "", "codedValues": [ { "name": "Mesa", "code": "Mesa" }, { "name": "Maricopa County", "code": "Maricopa County" }, { "name": "ADOT", "code": "ADOT" }, { "name": "Chandler", "code": "Chandler" }, { "name": "Gilbert", "code": "Gilbert" }, { "name": "Tempe", "code": "Tempe" }, { "name": "Apache Junction", "code": "Apache Junction" }, { "name": "Queen Creek", "code": "Queen Creek" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "CONDITION", "type": "esriFieldTypeSmallInteger", "alias": "Condition", "domain": null }, { "name": "CONDITIONDATE", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "WARRANTYDATE", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "CREATED_BY", "type": "esriFieldTypeString", "alias": "Created By", "length": 20, "domain": null }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "Created Date", "length": 8, "domain": null }, { "name": "MODIFIED_BY", "type": "esriFieldTypeString", "alias": "Modified By", "length": 20, "domain": null }, { "name": "MODIFIED_DATE", "type": "esriFieldTypeDate", "alias": "Modified Date", "length": 8, "domain": null }, { "name": "FEATURE_LABEL", "type": "esriFieldTypeString", "alias": "Feature Label", "length": 256, "domain": null } ], "indexes": [ { "name": "R177_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G852PARENTID", "fields": "PARENTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 19, "name": "ITSPOLE", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C8D75FD9-8799-46A5-92F7-DAC091487404}" }, { "id": 23, "name": "ITSPOLE", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C8D75FD9-8799-46A5-92F7-DAC091487404}" }, { "id": 27, "name": "ITSPOLE", "relatedTableId": 17, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C8D75FD9-8799-46A5-92F7-DAC091487404}" }, { "id": 31, "name": "ITSPOLE", "relatedTableId": 19, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C8D75FD9-8799-46A5-92F7-DAC091487404}" }, { "id": 35, "name": "ITSPOLE", "relatedTableId": 20, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C8D75FD9-8799-46A5-92F7-DAC091487404}" }, { "id": 39, "name": "ITSPOLE", "relatedTableId": 21, "role": "esriRelRoleDestination", "keyField": "PARENTID", "cardinality": "esriRelCardinalityOneToMany", "composite": false, "catalogID": "{C8D75FD9-8799-46A5-92F7-DAC091487404}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "c9b2cd7de1a44f12903a4cbb65092dd0" }