{ "currentVersion": 10.91, "id": 122, "name": "Traffic Controller", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 7, "name": "trController", "relatedTableId": 153, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CabinetID", "composite": false }, { "id": 12, "name": "trController", "relatedTableId": 119, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "SignalID", "composite": false } ], "isDataVersioned": true, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": false, "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 }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "SurveyName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Facility ID or Asset ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "FacilityID" }, { "name": "LegacyID", "type": "esriFieldTypeString", "alias": "Legacy ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "LegacyID" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 130, "defaultValue": null, "modelName": "Address" }, { "name": "Location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Location" }, { "name": "WarrantyDate", "type": "esriFieldTypeDate", "alias": "Warranty Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WarrantyDate" }, { "name": "PurchaseDate", "type": "esriFieldTypeDate", "alias": "Purchase Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PurchaseDate" }, { "name": "InstallDate", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InstallDate" }, { "name": "AssetCost", "type": "esriFieldTypeDouble", "alias": "Asset Cost", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssetCost" }, { "name": "Condition", "type": "esriFieldTypeDouble", "alias": "Condition", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Condition" }, { "name": "ConditionDate", "type": "esriFieldTypeDate", "alias": "Condition Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ConditionDate" }, { "name": "LifecycleStatus", "type": "esriFieldTypeString", "alias": "LifecycleStatus", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "LifecycleStatus" }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Comments" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "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" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "Owner" }, { "name": "UsefulLife", "type": "esriFieldTypeDouble", "alias": "Useful Life", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UsefulLife" }, { "name": "MaintainedBy", "type": "esriFieldTypeString", "alias": "Maintained By", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "MaintainedBy" }, { "name": "ContractorID", "type": "esriFieldTypeString", "alias": "Contractor Number/Name", "domain": { "type": "codedValue", "name": "DomContractor", "description": "DomContractor", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ContractorID" }, { "name": "ImagePath", "type": "esriFieldTypeString", "alias": "ImagePath", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ImagePath" }, { "name": "SurveyDate", "type": "esriFieldTypeDate", "alias": "Survey Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SurveyDate" }, { "name": "SurveyName", "type": "esriFieldTypeString", "alias": "Surveyor Name", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SurveyName" }, { "name": "EditDate", "type": "esriFieldTypeDate", "alias": "Date and Time Edit Was Made", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EditDate" }, { "name": "EditorName", "type": "esriFieldTypeString", "alias": "Name of Editor", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "EditorName" }, { "name": "Source", "type": "esriFieldTypeString", "alias": "Source", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Source" }, { "name": "DataSourceType", "type": "esriFieldTypeString", "alias": "Data Source Type", "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" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DataSourceType" }, { "name": "DataSourceReference", "type": "esriFieldTypeString", "alias": "Data Source Reference", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "DataSourceReference" }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Type" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Controller Material", "domain": { "type": "codedValue", "name": "transDomControllerMaterial", "description": "transDomControllerMaterial", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Material" }, { "name": "CabinetType", "type": "esriFieldTypeString", "alias": "Cabinet Type", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CabinetType" }, { "name": "SignalType", "type": "esriFieldTypeString", "alias": "Signal Type", "domain": { "type": "codedValue", "name": "transDomSignalHeadType", "description": "transDomSignalHeadType", "codedValues": [ { "name": "Signal", "code": "1" }, { "name": "Pedestrian", "code": "2" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SignalType" }, { "name": "FlasherType", "type": "esriFieldTypeString", "alias": "Flasher Type", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "FlasherType" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "transDomManufacturer", "description": "transDomManufacturer", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "ModelNumber", "type": "esriFieldTypeString", "alias": "Model Number", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "ModelNumber" }, { "name": "SerialNumber", "type": "esriFieldTypeString", "alias": "Serial Number", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SerialNumber" }, { "name": "CalibrationRange", "type": "esriFieldTypeString", "alias": "Calibration Range", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CalibrationRange" }, { "name": "LSCount", "type": "esriFieldTypeSmallInteger", "alias": "LS Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LSCount" }, { "name": "FlashCount", "type": "esriFieldTypeSmallInteger", "alias": "Flash Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FlashCount" }, { "name": "TRCount", "type": "esriFieldTypeSmallInteger", "alias": "TR Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TRCount" }, { "name": "IsolateCount", "type": "esriFieldTypeSmallInteger", "alias": "Isolate Count", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IsolateCount" }, { "name": "PowerSource", "type": "esriFieldTypeString", "alias": "Power Source", "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" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PowerSource" }, { "name": "Voltage", "type": "esriFieldTypeString", "alias": "Voltage", "domain": { "type": "codedValue", "name": "DomVoltage", "description": "DomVoltage", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "Voltage" }, { "name": "PowerSourceLocation", "type": "esriFieldTypeString", "alias": "Power Source Location", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PowerSourceLocation" }, { "name": "FuseType", "type": "esriFieldTypeString", "alias": "Fuse Type", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "FuseType" }, { "name": "PanelLightVoltage", "type": "esriFieldTypeString", "alias": "Panel Light Voltage", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PanelLightVoltage" }, { "name": "PanelLightModelNumber", "type": "esriFieldTypeString", "alias": "Panel Light Model Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PanelLightModelNumber" }, { "name": "UPS", "type": "esriFieldTypeString", "alias": "UPS Type", "domain": { "type": "codedValue", "name": "transDomUPSType", "description": "transDomUPSType", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "UPS" }, { "name": "PLC", "type": "esriFieldTypeString", "alias": "PLC", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "PLC" }, { "name": "RelatedInput", "type": "esriFieldTypeString", "alias": "Related Input", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "RelatedInput" }, { "name": "RelatedOutput", "type": "esriFieldTypeString", "alias": "Related Output", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "RelatedOutput" }, { "name": "OM", "type": "esriFieldTypeString", "alias": "OM", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "OM" }, { "name": "CabinetID", "type": "esriFieldTypeString", "alias": "CabinetID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CabinetID" }, { "name": "PrimaryRoad", "type": "esriFieldTypeString", "alias": "Main Street", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "PrimaryRoad" }, { "name": "SecondaryRoad", "type": "esriFieldTypeString", "alias": "Cross Street", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "SecondaryRoad" }, { "name": "TertiaryRoad", "type": "esriFieldTypeString", "alias": "Tertiary Street", "domain": null, "editable": true, "nullable": true, "length": 75, "defaultValue": null, "modelName": "TertiaryRoad" }, { "name": "ComputerName", "type": "esriFieldTypeString", "alias": "Computer Name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ComputerName" }, { "name": "OpDate", "type": "esriFieldTypeDate", "alias": "Operation Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OpDate" }, { "name": "OpTime", "type": "esriFieldTypeString", "alias": "Operation Time", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "OpTime" }, { "name": "OperatedBy", "type": "esriFieldTypeString", "alias": "Operated By", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OperatedBy" }, { "name": "SignalID", "type": "esriFieldTypeString", "alias": "Signal ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "SignalID" } ], "indexes": [ { "name": "R351_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2709SignalID", "fields": "SignalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2709CabinetID", "fields": "CabinetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2709FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Traffic Controller", "description": "", "prototype": { "attributes": { "OperatedBy": null, "SignalID": null, "FacilityID": null, "LegacyID": null, "Address": null, "Location": null, "WarrantyDate": null, "PurchaseDate": null, "InstallDate": null, "AssetCost": null, "Condition": null, "ConditionDate": null, "LifecycleStatus": null, "Comments": null, "Owner": null, "UsefulLife": null, "MaintainedBy": null, "ContractorID": null, "ImagePath": null, "SurveyDate": null, "SurveyName": null, "EditDate": null, "EditorName": null, "Source": null, "DataSourceType": null, "DataSourceReference": null, "Type": null, "Material": null, "CabinetType": null, "SignalType": null, "FlasherType": null, "Manufacturer": null, "ModelNumber": null, "SerialNumber": null, "CalibrationRange": null, "LSCount": null, "FlashCount": null, "TRCount": null, "IsolateCount": null, "PowerSource": null, "Voltage": null, "PowerSourceLocation": null, "FuseType": null, "PanelLightVoltage": null, "PanelLightModelNumber": null, "UPS": null, "PLC": null, "RelatedInput": null, "RelatedOutput": null, "OM": null, "CabinetID": null, "PrimaryRoad": null, "SecondaryRoad": null, "TertiaryRoad": null, "ComputerName": null, "OpDate": null, "OpTime": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "de73effa61484703b7120fe733135131" }