{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 27, "name": "ITS Device SI Element Inventory - Viewer", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ELEMEN_FILE_NUMBER", "fields": [ { "name": "ELEMEN_FILE_NUMBER", "type": "esriFieldTypeString", "alias": "Element File Number", "length": 10 }, { "name": "SIG_INTERSECT_ELEMENT", "type": "esriFieldTypeString", "alias": "Signalized Intersection Element", "length": 22 }, { "name": "INSTALLATION_DATE", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8 }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "length": 1 }, { "name": "SUPPORT_STYLE", "type": "esriFieldTypeString", "alias": "Support Style", "length": 20 }, { "name": "SUPPORT_TYPE", "type": "esriFieldTypeString", "alias": "Support Type", "length": 25 }, { "name": "MAKE_MODEL_NUMBER", "type": "esriFieldTypeString", "alias": "Make/Model Number", "length": 225 }, { "name": "DESIGN_NUMBER", "type": "esriFieldTypeString", "alias": "Design Number", "length": 7 }, { "name": "TWO_ARM_SUPPORT", "type": "esriFieldTypeString", "alias": "Two Arm Support", "length": 1 }, { "name": "MAST_ARM__A_DESIGN_NUM", "type": "esriFieldTypeString", "alias": "Mast Arm A Design Number", "length": 7 }, { "name": "MAST_ARM__B_DESIGN_NUM", "type": "esriFieldTypeString", "alias": "Mast Arm B Design Number", "length": 7 }, { "name": "SPANWIRE_CONFIGURATION", "type": "esriFieldTypeString", "alias": "Span Wire Configuration", "length": 15 }, { "name": "WOOD_POLE_HEIGHT_FT", "type": "esriFieldTypeInteger", "alias": "Wood Pole Height (ft)" }, { "name": "WOOD_POLE_CLASS", "type": "esriFieldTypeInteger", "alias": "Wood Pole Class" }, { "name": "BANDED_ARM_BRACKET", "type": "esriFieldTypeString", "alias": "Banded Arm Bracket", "length": 1 }, { "name": "RADAR_ATTACHED", "type": "esriFieldTypeString", "alias": "Radar Attached to Bracket Arm", "length": 1 }, { "name": "HWY_LIGHTING_ATTACHED", "type": "esriFieldTypeString", "alias": "Highway Lighting Attached to Bracket Arm", "length": 1 }, { "name": "OTHER_ATTACHED", "type": "esriFieldTypeString", "alias": "Other Attached to Bracket Arm", "length": 1 }, { "name": "APPROACH_DIRECTION", "type": "esriFieldTypeString", "alias": "Approach Direction", "length": 2 }, { "name": "DETECTION_TYPE", "type": "esriFieldTypeString", "alias": "Detection Type", "length": 5 }, { "name": "DETECTION", "type": "esriFieldTypeString", "alias": "Detection", "length": 12 }, { "name": "RADAR_TYPE", "type": "esriFieldTypeString", "alias": "Radar Type", "length": 10 }, { "name": "CLICK_301_INSTALLED", "type": "esriFieldTypeString", "alias": "Click 301 Installed", "length": 1 }, { "name": "VSH_SECTION", "type": "esriFieldTypeString", "alias": "VSH Section (left to right)", "length": 6 }, { "name": "MOVEMENT_TYPE_THRU", "type": "esriFieldTypeString", "alias": "Movement Type - Thru", "length": 1 }, { "name": "MOVEMENT_TYPE_RT", "type": "esriFieldTypeString", "alias": "Movement Type - RT", "length": 1 }, { "name": "MOVEMENT_TYPE_LT", "type": "esriFieldTypeString", "alias": "Movement Type - LT", "length": 1 }, { "name": "MT_BI_MODAL_YELLOW_ARW", "type": "esriFieldTypeString", "alias": "Movement Type - Bi-modal Flashing Yellow Arrow", "length": 1 }, { "name": "MT_FLASHING_YELLOW_ARW", "type": "esriFieldTypeString", "alias": "Movement Type - Flashing Yellow Arrow (FYA)", "length": 1 }, { "name": "MT_PERM_ONLY_FYA", "type": "esriFieldTypeString", "alias": "Movement Type - Permissive Only FYA", "length": 1 }, { "name": "MT_PROGRAMMABLE", "type": "esriFieldTypeString", "alias": "Movement Type - Programmable", "length": 1 }, { "name": "MT_U_TURN", "type": "esriFieldTypeString", "alias": "Movement Type - U-turn", "length": 1 }, { "name": "MT_BICYCLE_HEAD", "type": "esriFieldTypeString", "alias": "Movement Type - Bicycle Head", "length": 1 }, { "name": "PH_VSH_LABEL", "type": "esriFieldTypeString", "alias": "Ph/VSH Label", "length": 2 }, { "name": "HEAD_TYPE", "type": "esriFieldTypeString", "alias": "Head Type", "length": 15 }, { "name": "VISOR_TYPE", "type": "esriFieldTypeString", "alias": "Visor Type", "length": 10 }, { "name": "SIDE__MOUNTED_SIG_HEAD", "type": "esriFieldTypeString", "alias": "Side Mounted Signal Head", "length": 1 }, { "name": "LEDS", "type": "esriFieldTypeString", "alias": "LEDs", "length": 1 }, { "name": "LED_INSTALLATION_DATE", "type": "esriFieldTypeDate", "alias": "LED Installation Date", "length": 8 }, { "name": "HEATED_LED_INSTALL_DT", "type": "esriFieldTypeDate", "alias": "Heated LED Installation Date", "length": 8 }, { "name": "SNOW_SHIELD", "type": "esriFieldTypeString", "alias": "Snow Shield", "length": 1 }, { "name": "ASSOCIATED_PHASE", "type": "esriFieldTypeString", "alias": "Associated Phase", "length": 3 }, { "name": "PEDESTRIAN_PUSHBUTTONS", "type": "esriFieldTypeString", "alias": "Pedestrian Pushbuttons", "length": 3 }, { "name": "ACCESS_PED_PUSHBUTTON", "type": "esriFieldTypeString", "alias": "Accessible Ped Pushbutton", "length": 1 }, { "name": "INVENTORY_COMMENTS", "type": "esriFieldTypeString", "alias": "Inventory Comments", "length": 2500 }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8 }, { "name": "sys_updated_date", "type": "esriFieldTypeDate", "alias": "sys_updated_date", "length": 8 }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38 }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" } ], "indexes": [ { "name": "UUID_139", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G652REL_GLOBALID", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "gdb_ct3_139", "fields": "OBJECTID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "COLLECTOR.ITS_DEVICE_INVENTORY", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7C84B491-F89C-4846-BE1F-8117E23A0A83}" }, { "id": 12, "name": "COLLECTOR.ITS_DEVICE_INVENTORY", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7C84B491-F89C-4846-BE1F-8117E23A0A83}" }, { "id": 19, "name": "COLLECTOR.ITS_DEVICE_INVENTORY", "relatedTableId": 9, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7C84B491-F89C-4846-BE1F-8117E23A0A83}" }, { "id": 25, "name": "COLLECTOR.ITS_DEVICE_INVENTORY", "relatedTableId": 16, "role": "esriRelRoleDestination", "keyField": "REL_GLOBALID", "cardinality": "esriRelCardinalityOneToMany", "composite": true, "catalogID": "{7C84B491-F89C-4846-BE1F-8117E23A0A83}" } ], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "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": true, "archivingInfo": { "supportsQueryWithHistoricMoment": true, "startArchivingMoment": 1707598753000 } }