{ "currentVersion": 10.91, "id": 120, "name": "Traffic Signal Preemption", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 6, "name": "trPreemption", "relatedTableId": 153, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CabinetID", "composite": false }, { "id": 10, "name": "trPreemption", "relatedTableId": 149, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "StructID", "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": "transDomPreemptionType", "description": "transDomPreemptionType", "codedValues": [ { "name": "LIGHT", "code": "1" }, { "name": "SOUND", "code": "2" }, { "name": "PAVEMENT LOOP", "code": "3" }, { "name": "RADIO TRANSMISSION", "code": "4" }, { "name": "PUSH BUTTON", "code": "5" }, { "name": "OTHER", "code": "0" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Type" }, { "name": "Manufacturer", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": { "type": "codedValue", "name": "transDomManufacturer", "description": "transDomManufacturer", "codedValues": [], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "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": "Orientation", "type": "esriFieldTypeString", "alias": "Orientation", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Orientation" }, { "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": "CabinetID", "type": "esriFieldTypeString", "alias": "CabinetID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "CabinetID" }, { "name": "StructID", "type": "esriFieldTypeString", "alias": "Structure ID", "domain": null, "editable": true, "nullable": true, "length": 40, "defaultValue": null, "modelName": "StructID" } ], "indexes": [ { "name": "R350_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G2708StructID", "fields": "StructID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2708CabinetID", "fields": "CabinetID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G2708FacilityID", "fields": "FacilityID", "isAscending": true, "isUnique": false, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "Traffic Signal Preemption", "description": "", "prototype": { "attributes": { "CabinetID": null, "StructID": 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, "Manufacturer": null, "ModelNumber": null, "SerialNumber": null, "Orientation": null, "PrimaryRoad": null, "SecondaryRoad": null, "TertiaryRoad": null, "ComputerName": null, "OpDate": null, "OpTime": null, "OperatedBy": 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" }