{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 69, "name": "Signal Poles", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Type", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": { "type": "codedValue", "name": "TS_SignalPoleType", "description": "Traffic Signal Pole Type", "codedValues": [ { "name": "Standard", "code": "Standard" }, { "name": "Pedestrian", "code": "Pedestrian" }, { "name": "Span Wood", "code": "Span Wood" }, { "name": "Span Metal", "code": "Span Metal" }, { "name": "Other", "code": "Other" }, { "name": "Green Decorative", "code": "Green Decorative" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "TravelDirection", "type": "esriFieldTypeString", "alias": "TravelDirection", "length": 50, "domain": { "type": "codedValue", "name": "TS_SignalPoleTravelDirection", "description": "Traffic Signal Pole Travel Direction", "codedValues": [ { "name": "NB", "code": "NB" }, { "name": "SB", "code": "SB" }, { "name": "EB", "code": "EB" }, { "name": "WB", "code": "WB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Color", "type": "esriFieldTypeString", "alias": "Color", "length": 50, "domain": { "type": "codedValue", "name": "TS_SignalPoleColor", "description": "Traffic Signal Pole Color", "codedValues": [ { "name": "Galvanized", "code": "Galvanized" }, { "name": "Green", "code": "Green" }, { "name": "Black", "code": "Black" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MastHeight", "type": "esriFieldTypeSmallInteger", "alias": "MastHeight", "domain": { "type": "codedValue", "name": "TS_SignalPoleMastHeight", "description": "Traffic Signal Pole Mast Height", "codedValues": [ { "name": "5", "code": 5 }, { "name": "10", "code": 10 }, { "name": "12", "code": 12 }, { "name": "15", "code": 15 }, { "name": "17", "code": 17 }, { "name": "20", "code": 20 }, { "name": "30", "code": 30 }, { "name": "35", "code": 35 }, { "name": "40", "code": 40 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ArmLength", "type": "esriFieldTypeSmallInteger", "alias": "ArmLength", "domain": { "type": "codedValue", "name": "TS_SignalPoleArmLength", "description": "Traffic Signal Pole Arm Length", "codedValues": [ { "name": "24", "code": 24 }, { "name": "28", "code": 28 }, { "name": "32", "code": 32 }, { "name": "36", "code": 36 }, { "name": "40", "code": 40 }, { "name": "44", "code": 44 }, { "name": "48", "code": 48 }, { "name": "50", "code": 50 }, { "name": "55", "code": 55 }, { "name": "60", "code": 60 }, { "name": "65", "code": 65 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FoundationType", "type": "esriFieldTypeString", "alias": "FoundationType", "length": 25, "domain": { "type": "codedValue", "name": "TS_SignalPoleFoundationType", "description": "Traffic Signal Pole Foundation Type", "codedValues": [ { "name": "24-A", "code": "24-A" }, { "name": "30-A", "code": "30-A" }, { "name": "36-A", "code": "36-A" }, { "name": "36-B", "code": "36-B" }, { "name": "42-A", "code": "42-A" }, { "name": "48-A", "code": "48-A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LuminaireQTY", "type": "esriFieldTypeSmallInteger", "alias": "LuminaireQTY", "domain": { "type": "codedValue", "name": "TS_SignalLuminaireQuantity", "description": "Traffic Signal Luminaire Quantity", "codedValues": [ { "name": "0", "code": 0 }, { "name": "1", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoliceEnforceLight", "type": "esriFieldTypeString", "alias": "PoliceEnforceLight", "length": 10, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "EthernetExtendersQTY", "type": "esriFieldTypeSmallInteger", "alias": "EthernetExtendersQTY", "domain": { "type": "codedValue", "name": "TS_SignalEthernetExtenderQuantity", "description": "Traffic Signal Ethernet Extender Quantity", "codedValues": [ { "name": "0", "code": 0 }, { "name": "1", "code": 1 }, { "name": "2", "code": 2 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "InstallDate", "length": 8, "domain": null }, { "name": "Lifecycle", "type": "esriFieldTypeString", "alias": "Lifecycle", "length": 50, "domain": { "type": "codedValue", "name": "LifeCycle", "description": "Life Cycle", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Abandoned", "code": "Abandoned" }, { "name": "Removed", "code": "Removed" }, { "name": "Proposed", "code": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 100, "domain": null }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 25, "domain": null }, { "name": "F_Key", "type": "esriFieldTypeString", "alias": "F_Key", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R1178_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_1178", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1686F_Key", "fields": "F_Key", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1686AssetID", "fields": "AssetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_1178", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 6, "name": "SP_OptiComPreempHeads", "relatedTableId": 55, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 10, "name": "SP_Pullboxes", "relatedTableId": 59, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 7, "name": "SP_PedButtons", "relatedTableId": 56, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "SP_PTZCameras", "relatedTableId": 58, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 15, "name": "sde.SDE.SP_WindDampers", "relatedTableId": 63, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "SP_Detection", "relatedTableId": 54, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "SP_Cameras", "relatedTableId": 53, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 8, "name": "SP_PedHeads", "relatedTableId": 57, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 11, "name": "SP_RadioCommunications", "relatedTableId": 60, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 12, "name": "SP_SignalHeads", "relatedTableId": 61, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "SP_Signs", "relatedTableId": 62, "role": "esriRelRoleOrigin", "keyField": "AssetID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "TrafficSignals", "relatedTableId": 10, "role": "esriRelRoleDestination", "keyField": "F_Key", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }