{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 119, "name": "Traffic Signal Head", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SurveyName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID or Asset ID", "length": 40, "domain": null }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "length": 40, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 130, "domain": null }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "length": 250, "domain": null }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "length": 8, "domain": null }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "length": 8, "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "length": 8, "domain": null }, { "name": "AssetCost", "type": "esriFieldTypeDouble", "alias": "Asset Cost", "domain": null }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "length": 8, "domain": null }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "length": 10, "domain": { "type": "codedValue", "name": "DomLifecycleStatus", "description": "DomLifecycleStatus", "codedValues": [ { "name": "Abandoned", "code": "AB" }, { "name": "Disposed", "code": "DISP" }, { "name": "In Service", "code": "IS" }, { "name": "Out of Service", "code": "OOS" }, { "name": "Reserved", "code": "RES" }, { "name": "Spare", "code": "SPR" }, { "name": "Not City Owned", "code": "NCO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 250, "domain": null }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 7, "domain": { "type": "codedValue", "name": "DomOwner", "description": "DomOwner", "codedValues": [ { "name": "Private", "code": "-1" }, { "name": "Other", "code": "-2" }, { "name": "City of Santa Ana", "code": "1" }, { "name": "Orange County", "code": "2" }, { "name": "Caltrans", "code": "3" }, { "name": "Public", "code": "4" }, { "name": "Costa Mesa", "code": "5" }, { "name": "Discovery Center", "code": "6" }, { "name": "Fountian Valley", "code": "7" }, { "name": "CDA", "code": "8" }, { "name": "Association", "code": "9" }, { "name": "OCTA", "code": "10" }, { "name": "OC Flood Control District", "code": "11" }, { "name": "Irvine Ranch Water District", "code": "12" }, { "name": "Santa Ana Unified School District", "code": "13" }, { "name": "Contractor", "code": "14" }, { "name": "SCE", "code": "15" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "UsefulLife", "type": "esriFieldTypeDouble", "alias": "Useful Life", "domain": null }, { "name": "MaintainedBy", "type": "esriFieldTypeString", "alias": "Maintained By", "length": 25, "domain": { "type": "codedValue", "name": "DomMaintBy", "description": "DomMaintBy", "codedValues": [ { "name": "Private", "code": "-1" }, { "name": "Other", "code": "-2" }, { "name": "City of Santa Ana", "code": "1" }, { "name": "Orange County", "code": "2" }, { "name": "Caltrans", "code": "3" }, { "name": "Public", "code": "4" }, { "name": "Discovery Center", "code": "6" }, { "name": "Fountain Valley", "code": "7" }, { "name": "CDA", "code": "8" }, { "name": "Association", "code": "9" }, { "name": "Costa Mesa", "code": "5" }, { "name": "OCTA", "code": "10" }, { "name": "OC Flood Control District", "code": "11" }, { "name": "Irvine Ranch Water District", "code": "12" }, { "name": "Santa Ana Unified School District", "code": "13" }, { "name": "Contractor", "code": "14" }, { "name": "SCE", "code": "15" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ContractorID", "type": "esriFieldTypeString", "alias": "Contractor Number/Name", "length": 25, "domain": { "type": "codedValue", "name": "DomContractor", "description": "DomContractor", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ImagePath", "type": "esriFieldTypeString", "alias": "ImagePath", "length": 100, "domain": null }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "Survey Date", "length": 8, "domain": null }, { "name": "SurveyName", "type": "esriFieldTypeString", "alias": "Surveyor Name", "length": 25, "domain": null }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Date and Time Edit Was Made", "length": 8, "domain": null }, { "name": "EditorName", "type": "esriFieldTypeString", "alias": "Name of Editor", "length": 25, "domain": null }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "length": 25, "domain": { "type": "codedValue", "name": "DomSource", "description": "DomSource", "codedValues": [ { "name": "Consultant", "code": "-1" }, { "name": "Other", "code": "-2" }, { "name": "City of Santa Ana PWA", "code": "1" }, { "name": "City of Santa Ana Other", "code": "2" }, { "name": "Orange County", "code": "3" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataSourceType", "type": "esriFieldTypeString", "alias": "Data Source Type", "length": 50, "domain": { "type": "codedValue", "name": "DomDataSourceType", "description": "DomDataSourceType", "codedValues": [ { "name": "As-built Record Plan", "code": "ASBUILT" }, { "name": "AutoCAD Drawing", "code": "AUTOCADDRAWING" }, { "name": "Estimated Feature Location", "code": "ESTIMATED" }, { "name": "Existing Records", "code": "EXISTING" }, { "name": "Field Measured", "code": "FIELDMEASURED" }, { "name": "Field Notes", "code": "FIELDNOTES" }, { "name": "Markup", "code": "MARKUP" }, { "name": "Overall System Map", "code": "OVERALL" }, { "name": "Planimetric Landbase", "code": "PLANIMETRICLANDBASE" }, { "name": "Record Drawing", "code": "RECORDDRAWING" }, { "name": "Sketch", "code": "SKETCH" }, { "name": "Tax Map", "code": "TAXMAP" }, { "name": "VRS Collected", "code": "VRSCOLLECTED" }, { "name": "Construction Plan", "code": "CONSTRUCTION" }, { "name": "Conventional Survey", "code": "CONVENTIONALSURVEY" }, { "name": "Subcentimeter GPS", "code": "GPSCM" }, { "name": "Submeter GPS", "code": "GPSM" }, { "name": "SubFoot GPS", "code": "SUBFOOTGPS" }, { "name": "Mobile Mapping LiDAR", "code": "MMLiDAR" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DataSourceReference", "type": "esriFieldTypeString", "alias": "Data Source Reference", "length": 250, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomSignalHeadType", "description": "transDomSignalHeadType", "codedValues": [ { "name": "Signal", "code": "1" }, { "name": "Pedestrian", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 25, "domain": { "type": "codedValue", "name": "transDomMaterial", "description": "transDomMaterial", "codedValues": [ { "name": "Concrete", "code": "CONC" }, { "name": "Fiberlyte", "code": "FBLT" }, { "name": "Other", "code": "OTH" }, { "name": "Steel", "code": "STL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Height", "type": "esriFieldTypeDouble", "alias": "Height", "domain": null }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 25, "domain": { "type": "codedValue", "name": "transDomManufacturer", "description": "transDomManufacturer", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Phase", "type": "esriFieldTypeString", "alias": "Phase", "length": 2, "domain": { "type": "codedValue", "name": "transDomPhase", "description": "transDomPhase", "codedValues": [ { "name": "Current Project", "code": "C" }, { "name": "Future Project", "code": "F" }, { "name": "Immediate Priority Project", "code": "T1" }, { "name": "Secondary Priority Project", "code": "T2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PowerSource", "type": "esriFieldTypeString", "alias": "Power Source", "length": 25, "domain": { "type": "codedValue", "name": "transDomPowerSource", "description": "transDomPowerSource", "codedValues": [ { "name": "N/A - City", "code": "1" }, { "name": "Powered Overhead", "code": "2" }, { "name": "Powered Underground", "code": "3" }, { "name": "Unknown", "code": "-99" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PowerType", "type": "esriFieldTypeString", "alias": "Power Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomPowerType", "description": "transDomPowerType", "codedValues": [ { "name": "Distribution", "code": "1" }, { "name": "Standalone", "code": "2" }, { "name": "Unknown", "code": "-99" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "Model Number", "length": 40, "domain": null }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "length": 40, "domain": null }, { "name": "Orientation", "type": "esriFieldTypeString", "alias": "Orientation", "length": 10, "domain": { "type": "codedValue", "name": "transDomCardinalDirection", "description": "transDomCardinalDirection", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northwest", "code": "NW" }, { "name": "Northeast", "code": "NE" }, { "name": "Southwest", "code": "SW" }, { "name": "Southeast", "code": "SE" }, { "name": "North/South", "code": "NS" }, { "name": "East/West", "code": "EW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "HeadSize", "type": "esriFieldTypeDouble", "alias": "Head Size", "domain": null }, { "name": "CabinetType", "type": "esriFieldTypeString", "alias": "Cabinet Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomCabinetType", "description": "transDomCabinetType", "codedValues": [ { "name": "332", "code": "332" }, { "name": "334", "code": "334" }, { "name": "336", "code": "336" }, { "name": "G", "code": "G" }, { "name": "M", "code": "M" }, { "name": "P38", "code": "P38" }, { "name": "P44", "code": "P44" }, { "name": "ATC", "code": "ATC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CabinetSize", "type": "esriFieldTypeString", "alias": "Cabinet Size", "length": 14, "domain": null }, { "name": "CabinetLocation", "type": "esriFieldTypeString", "alias": "Cabinet Location", "length": 250, "domain": null }, { "name": "CabinetID", "type": "esriFieldTypeString", "alias": "Cabinet ID", "length": 40, "domain": null }, { "name": "ControllerType", "type": "esriFieldTypeString", "alias": "Controller Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomControllerType", "description": "transDomControllerType", "codedValues": [ { "name": "2070-L", "code": "20L" }, { "name": "2070-N", "code": "20N" }, { "name": "2070-V", "code": "20V" }, { "name": "820-A", "code": "82A" }, { "name": "870", "code": "87V" }, { "name": "ECONOLITE ASC3", "code": "ECO" }, { "name": "MODEL 170", "code": "170" }, { "name": "NEMA TS1", "code": "TS1" }, { "name": "NEMA TS2", "code": "TS2" }, { "name": "ECONOLITE COBALT", "code": "COB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CameraType", "type": "esriFieldTypeString", "alias": "Camera Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomCameraType", "description": "transDomCameraType", "codedValues": [ { "name": "Axis Q6035-E", "code": "AXQE" }, { "name": "Cohu Helios 3920 HD", "code": "HDCM" }, { "name": "Cohu Idome 3920 Analog", "code": "IDOM" }, { "name": "Positioner", "code": "POST" }, { "name": "Cohu RISE", "code": "CHRS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SwitchType", "type": "esriFieldTypeString", "alias": "Switch Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomSwitchType", "description": "transDomSwitchType", "codedValues": [ { "name": "EtherWan ED3141", "code": "ED1" }, { "name": "EtherWan ED3175", "code": "ED2" }, { "name": "EtherWan EX71620", "code": "EX1" }, { "name": "EtherWan EX73242", "code": "EX2" }, { "name": "EtherWan EX71800", "code": "EX3" }, { "name": "EtherWan EX73221", "code": "EX4" }, { "name": "EtherWan EX73240", "code": "EX5" }, { "name": "EtherWan EX96026", "code": "EX6" }, { "name": "EtherWan EX96044", "code": "EX7" }, { "name": "EtherWan EX71802", "code": "EX8" }, { "name": "GDI 2070-6 19.2 FSK", "code": "GDI" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SwitchConfiguration", "type": "esriFieldTypeString", "alias": "Switch", "length": 50, "domain": null }, { "name": "Maintenance", "type": "esriFieldTypeString", "alias": "Maintenance", "length": 500, "domain": null }, { "name": "MountType", "type": "esriFieldTypeString", "alias": "Mount Type", "length": 10, "domain": { "type": "codedValue", "name": "transDomMountType", "description": "transDomMountType", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LampType", "type": "esriFieldTypeString", "alias": "Lamp Type", "length": 10, "domain": { "type": "codedValue", "name": "transDomLampType", "description": "transDomLampType", "codedValues": [ { "name": "HIGH PRESSURE SODIUM", "code": "1" }, { "name": "METAL HALIDE", "code": "2" }, { "name": "OTHER", "code": "0" }, { "name": "LED", "code": "3" }, { "name": "UNDETERMINABLE", "code": "-1" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "IndicatorColor", "type": "esriFieldTypeString", "alias": "Indicator Color", "length": 25, "domain": { "type": "codedValue", "name": "transDomColor", "description": "transDomColor", "codedValues": [ { "name": "Red", "code": "1" }, { "name": "Yellow", "code": "2" }, { "name": "White", "code": "3" }, { "name": "Green", "code": "4" }, { "name": "Blue", "code": "5" }, { "name": "Black", "code": "6" }, { "name": "Yellow/Black", "code": "7" }, { "name": "Unknown", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "DisplayType", "type": "esriFieldTypeString", "alias": "Display Type (Pedestrian Only)", "length": 10, "domain": null }, { "name": "LaneNum", "type": "esriFieldTypeDouble", "alias": "Lane Number", "domain": null }, { "name": "BackPlate", "type": "esriFieldTypeString", "alias": "BackPlate", "length": 10, "domain": { "type": "codedValue", "name": "transDomMaterial", "description": "transDomMaterial", "codedValues": [ { "name": "Concrete", "code": "CONC" }, { "name": "Fiberlyte", "code": "FBLT" }, { "name": "Other", "code": "OTH" }, { "name": "Steel", "code": "STL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructType", "type": "esriFieldTypeString", "alias": "StructType", "length": 50, "domain": { "type": "codedValue", "name": "transDomStructType", "description": "transDomStructType", "codedValues": [ { "name": "Sign Pole", "code": "1" }, { "name": "Mastarm", "code": "10" }, { "name": "Signal Pole", "code": "2" }, { "name": "Span Wire Pole", "code": "3" }, { "name": "Light Pole", "code": "4" }, { "name": "Utility Pole", "code": "5" }, { "name": "Other Pole", "code": "6" }, { "name": "Bridge", "code": "7" }, { "name": "Building Wall", "code": "8" }, { "name": "Barricade", "code": "9" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "StructHeight", "type": "esriFieldTypeDouble", "alias": "StructHeight", "domain": null }, { "name": "StructID", "type": "esriFieldTypeString", "alias": "StructID", "length": 20, "domain": null }, { "name": "PrimaryRoad", "type": "esriFieldTypeString", "alias": "Main Street", "length": 75, "domain": null }, { "name": "SecondaryRoad", "type": "esriFieldTypeString", "alias": "Cross Street", "length": 75, "domain": null }, { "name": "TertiaryRoad", "type": "esriFieldTypeString", "alias": "Tertiary Street", "length": 75, "domain": null }, { "name": "DistanceinFeet", "type": "esriFieldTypeDouble", "alias": "Distance in Feet", "domain": null }, { "name": "MeasureFrom", "type": "esriFieldTypeString", "alias": "Measure From", "length": 50, "domain": null }, { "name": "Rotation", "type": "esriFieldTypeDouble", "alias": "Map Symbol Rotation", "domain": null }, { "name": "OpDate", "type": "esriFieldTypeDate", "alias": "Operation Date", "length": 8, "domain": null }, { "name": "OpTime", "type": "esriFieldTypeString", "alias": "Operation Time", "length": 5, "domain": null }, { "name": "OperatedBy", "type": "esriFieldTypeString", "alias": "Operated By", "length": 30, "domain": null }, { "name": "ComputerName", "type": "esriFieldTypeString", "alias": "Computer Name", "length": 30, "domain": null }, { "name": "DetectionType", "type": "esriFieldTypeString", "alias": "Detection Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomDetectionType", "description": "transDomDetectionType", "codedValues": [ { "name": "Other", "code": "0" }, { "name": "Pedestrian Push Button", "code": "1" }, { "name": "Video Detection", "code": "2" }, { "name": "Timer", "code": "3" }, { "name": "Detection Pad", "code": "4" }, { "name": "Loop Detection", "code": "5" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "FlashingType", "type": "esriFieldTypeString", "alias": "Flashing Type", "length": 25, "domain": { "type": "codedValue", "name": "transDomFlashingType", "description": "transDomFlashingType", "codedValues": [ { "name": "Activated Flashing Beacon", "code": "CABC" }, { "name": "RRFB", "code": "CALED" }, { "name": "Pre-Timed Flashing Beacon", "code": "PTFB" }, { "name": "In-Roadway Warning Lights", "code": "INPV" }, { "name": "School Zone", "code": "SCHL" }, { "name": "Other", "code": "OTHER" }, { "name": "Pedestrian", "code": "PED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "indexes": [ { "name": "R354_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2712FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 12, "name": "trSignalHead", "relatedTableId": 121, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 13, "name": "trSignalHead", "relatedTableId": 122, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 9, "name": "trSignalHead", "relatedTableId": 151, "role": "esriRelRoleOrigin", "keyField": "FacilityID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "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": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": false, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "f9fee8785fd74733b3d6fc793426670a" }