{ "layers": [], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "OperationsMaintenance.DBO.VehicleListDOC", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "LeadName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "ObjectId", "domain": null }, { "name": "VehicleNumber", "type": "esriFieldTypeString", "alias": "VehicleNumber", "length": 256, "domain": null }, { "name": "VehicleType", "type": "esriFieldTypeString", "alias": "VehicleType", "length": 4000, "domain": null }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 4000, "domain": { "type": "codedValue", "name": "Status_1", "description": "", "codedValues": [ { "name": "Active", "code": "Active" }, { "name": "Standby", "code": "Standby" }, { "name": "Break", "code": "Break" }, { "name": "Not Assigned", "code": "Not Assigned" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LeadName", "type": "esriFieldTypeString", "alias": "LeadName", "length": 4000, "domain": { "type": "codedValue", "name": "DriverName", "description": "", "codedValues": [ { "name": "A. Banuelos / 94-165", "code": "A. Banuelos / 94-165" }, { "name": "A. Francis / 94-181", "code": "A. Francis / 94-181" }, { "name": "A. Gamez / 94-208", "code": "A. Gamez / 94-208" }, { "name": "A. Garcia / 94-213", "code": "A. Garcia / 94-213" }, { "name": "A. Mesa / 94-177", "code": "A. Mesa / 94-177" }, { "name": "A. Morales / 94-148", "code": "A. Morales / 94-148" }, { "name": "A. Munoz / 94-260", "code": "A. Munoz / 94-260" }, { "name": "A. Ontiveros / 94-268", "code": "A. Ontiveros / 94-268" }, { "name": "A. Razo / 94-129", "code": "A. Razo / 94-129" }, { "name": "A. Renish / 94-169", "code": "A. Renish / 94-169" }, { "name": "A. Rosas / 94-240", "code": "A. Rosas / 94-240" }, { "name": "A. Savoy / 94-223", "code": "A. Savoy / 94-223" }, { "name": "A. Serrano / 94-190", "code": "A. Serrano / 94-190" }, { "name": "A. Trujillo / 94-147", "code": "A. Trujillo / 94-147" }, { "name": "A. Villegas / 94-117", "code": "A. Villegas / 94-117" }, { "name": "B. Glenn / 94-630", "code": "B. Glenn / 94-630" }, { "name": "B. Morgan / 94-221", "code": "B. Morgan / 94-221" }, { "name": "B. Penesa / 94-123", "code": "B. Penesa / 94-123" }, { "name": "B. Quigley / 94-202", "code": "B. Quigley / 94-202" }, { "name": "C. Casillas / 94-200", "code": "C. Casillas / 94-200" }, { "name": "C. Cooke / 94-262", "code": "C. Cooke / 94-262" }, { "name": "C. Ornelas / 94-108", "code": "C. Ornelas / 94-108" }, { "name": "C. Ponce / 94-159", "code": "C. Ponce / 94-159" }, { "name": "C. Reed / 94-155", "code": "C. Reed / 94-155" }, { "name": "C. Ruiz / 94-176", "code": "C. Ruiz / 94-176" }, { "name": "C. Segura / 94-109", "code": "C. Segura / 94-109" }, { "name": "C. Serrano / 94-116", "code": "C. Serrano / 94-116" }, { "name": "C. Siqueiros / 94-179", "code": "C. Siqueiros / 94-179" }, { "name": "C. Williams / 94-127", "code": "C. Williams / 94-127" }, { "name": "D. Fernandez / 94-218", "code": "D. Fernandez / 94-218" }, { "name": "D. Kane / 94-195", "code": "D. Kane / 94-195" }, { "name": "D. Long / 94-115", "code": "D. Long / 94-115" }, { "name": "D. Madrigal / 94-297", "code": "D. Madrigal / 94-297" }, { "name": "D. Martinez / 94-133", "code": "D. Martinez / 94-133" }, { "name": "D. Wilson / 94-199", "code": "D. Wilson / 94-199" }, { "name": "E. Budzinski / 94-236", "code": "E. Budzinski / 94-236" }, { "name": "E. Frondoso / 94-101", "code": "E. Frondoso / 94-101" }, { "name": "E. Garcia / 94-648", "code": "E. Garcia / 94-648" }, { "name": "E. Perez / 94-239", "code": "E. Perez / 94-239" }, { "name": "E. Ruelas / 94-234", "code": "E. Ruelas / 94-234" }, { "name": "E. Vailolo / 94-185", "code": "E. Vailolo / 94-185" }, { "name": "F. Jimenez / 94-051", "code": "F. Jimenez / 94-051" }, { "name": "F. Lucano / 94-140", "code": "F. Lucano / 94-140" }, { "name": "F. Maldonado / 94-171", "code": "F. Maldonado / 94-171" }, { "name": "F. Valdez / 94-186", "code": "F. Valdez / 94-186" }, { "name": "G. Aceves / 94-106", "code": "G. Aceves / 94-106" }, { "name": "G. Shimono / 94-299", "code": "G. Shimono / 94-299" }, { "name": "H. Gonzalez / 94-118", "code": "H. Gonzalez / 94-118" }, { "name": "H. Pineda / 94-149", "code": "H. Pineda / 94-149" }, { "name": "H. Sanchez / 94-206", "code": "H. Sanchez / 94-206" }, { "name": "I. Cortez / 94-228", "code": "I. Cortez / 94-228" }, { "name": "I. Huizar / 94-203", "code": "I. Huizar / 94-203" }, { "name": "J. Arroyo/Guzman / 94-103", "code": "J. Arroyo/Guzman / 94-103" }, { "name": "J. Borboa / 94-138", "code": "J. Borboa / 94-138" }, { "name": "J. Cadena / 94-151", "code": "J. Cadena / 94-151" }, { "name": "J. Callejas / 94-121", "code": "J. Callejas / 94-121" }, { "name": "J. Dresser / 94-649", "code": "J. Dresser / 94-649" }, { "name": "Ja. Garcia / 94-154", "code": "Ja. Garcia / 94-154" }, { "name": "Jo. Garcia / 94-231", "code": "Jo. Garcia / 94-231" }, { "name": "J. Goldsmith / 94-131", "code": "J. Goldsmith / 94-131" }, { "name": "J. Gonzalez / 94-162", "code": "J. Gonzalez / 94-162" }, { "name": "J. Guzman / 94-113", "code": "J. Guzman / 94-113" }, { "name": "J. Harris / 94-196", "code": "J. Harris / 94-196" }, { "name": "J. Morales / 94-110", "code": "J. Morales / 94-110" }, { "name": "J. Payne / 94-172", "code": "J. Payne / 94-172" }, { "name": "J. Phuong / 94-160", "code": "J. Phuong / 94-160" }, { "name": "J. Prause / 94-219", "code": "J. Prause / 94-219" }, { "name": "J. Ramirez / 94-166", "code": "J. Ramirez / 94-166" }, { "name": "J. Stout / 94-175", "code": "J. Stout / 94-175" }, { "name": "J. Urrutia / 94-192", "code": "J. Urrutia / 94-192" }, { "name": "J. Valenzuela / 94-241", "code": "J. Valenzuela / 94-241" }, { "name": "J. Villa / 94-128", "code": "J. Villa / 94-128" }, { "name": "K. Aguilar / 94-134", "code": "K. Aguilar / 94-134" }, { "name": "K. Cazares / 94-209", "code": "K. Cazares / 94-209" }, { "name": "K. Hernandez / 94-242", "code": "K. Hernandez / 94-242" }, { "name": "K. Onuma / 94-102", "code": "K. Onuma / 94-102" }, { "name": "K. Ruiz / 94-125", "code": "K. Ruiz / 94-125" }, { "name": "L. Avila / 94-645", "code": "L. Avila / 94-645" }, { "name": "L. Durazo / 94-254", "code": "L. Durazo / 94-254" }, { "name": "L. Estrada / 94-247", "code": "L. Estrada / 94-247" }, { "name": "L. Frausto / 94-189", "code": "L. Frausto / 94-189" }, { "name": "L. Godinez / 94-187", "code": "L. Godinez / 94-187" }, { "name": "L. Hanson / 94-143", "code": "L. Hanson / 94-143" }, { "name": "L. Medina / 94-183", "code": "L. Medina / 94-183" }, { "name": "L. Shingary / 94-136", "code": "L. Shingary / 94-136" }, { "name": "L. Valencia / 94-141", "code": "L. Valencia / 94-141" }, { "name": "M. Antunez / 94-130", "code": "M. Antunez / 94-130" }, { "name": "M. Avila / 94-132", "code": "M. Avila / 94-132" }, { "name": "M. Barajas / 94-647", "code": "M. Barajas / 94-647" }, { "name": "M. Dolan / 94-644", "code": "M. Dolan / 94-644" }, { "name": "M. Duong / 94-052", "code": "M. Duong / 94-052" }, { "name": "M. Hot / 94-163", "code": "M. Hot / 94-163" }, { "name": "M. Johnson / 94-267", "code": "M. Johnson / 94-267" }, { "name": "M. Lopez / 94-112", "code": "M. Lopez / 94-112" }, { "name": "M. Martinez / 94-055", "code": "M. Martinez / 94-055" }, { "name": "M. Mojica / 94-216", "code": "M. Mojica / 94-216" }, { "name": "M. Murillo / 94-167", "code": "M. Murillo / 94-167" }, { "name": "M. Ortiz / 94-124", "code": "M. Ortiz / 94-124" }, { "name": "M. Ruiz / 94-182", "code": "M. Ruiz / 94-182" }, { "name": "M. Serrano / 94-157", "code": "M. Serrano / 94-157" }, { "name": "M. Westergren / 94-145", "code": "M. Westergren / 94-145" }, { "name": "N. Gonzales / 94-146", "code": "N. Gonzales / 94-146" }, { "name": "N. Nelson / 94-126", "code": "N. Nelson / 94-126" }, { "name": "N. Newman / 94-142", "code": "N. Newman / 94-142" }, { "name": "N. Quimsing / 94-105", "code": "N. Quimsing / 94-105" }, { "name": "O. Cerda / 94-053", "code": "O. Cerda / 94-053" }, { "name": "O. Leon / 94-229", "code": "O. Leon / 94-229" }, { "name": "O. Naranjo / 94-194", "code": "O. Naranjo / 94-194" }, { "name": "O. Rodriguez / 94-269", "code": "O. Rodriguez / 94-269" }, { "name": "P. Salazar / 94-224", "code": "P. Salazar / 94-224" }, { "name": "R. Carlos / 94-226", "code": "R. Carlos / 94-226" }, { "name": "R. Casas / 94-252", "code": "R. Casas / 94-252" }, { "name": "R. Castaneda / 94-220", "code": "R. Castaneda / 94-220" }, { "name": "R. Castro / 94-168", "code": "R. Castro / 94-168" }, { "name": "R. Ceja / 94-120", "code": "R. Ceja / 94-120" }, { "name": "R. Chavez / 94-277", "code": "R. Chavez / 94-277" }, { "name": "R. De La Cruz / 94-197", "code": "R. De La Cruz / 94-197" }, { "name": "R. Garcia / 94-135", "code": "R. Garcia / 94-135" }, { "name": "R. Howell / 94-264", "code": "R. Howell / 94-264" }, { "name": "R. Jimenez / 94-170", "code": "R. Jimenez / 94-170" }, { "name": "R. Mora / 94-191", "code": "R. Mora / 94-191" }, { "name": "R. Mugica / 94-225", "code": "R. Mugica / 94-225" }, { "name": "R. Rivera / 94-204", "code": "R. Rivera / 94-204" }, { "name": "R. Taylor / 94-119", "code": "R. Taylor / 94-119" }, { "name": "R. Tellez / 94-201", "code": "R. Tellez / 94-201" }, { "name": "R. Vega / 94-222", "code": "R. Vega / 94-222" }, { "name": "R. Villa / 94-164", "code": "R. Villa / 94-164" }, { "name": "S. Alvarado / 94-198", "code": "S. Alvarado / 94-198" }, { "name": "S. Laxamana / 94-153", "code": "S. Laxamana / 94-153" }, { "name": "S. Ly / 94-178", "code": "S. Ly / 94-178" }, { "name": "S. Palacios / 94-050", "code": "S. Palacios / 94-050" }, { "name": "S. Rangel / 94-173", "code": "S. Rangel / 94-173" }, { "name": "S. Spray / 94-139", "code": "S. Spray / 94-139" }, { "name": "T. Gillespie / 94-158", "code": "T. Gillespie / 94-158" }, { "name": "T. Loyd / 94-271", "code": "T. Loyd / 94-271" }, { "name": "T. Neilson / 94-257", "code": "T. Neilson / 94-257" }, { "name": "T. Pena / 94-111", "code": "T. Pena / 94-111" }, { "name": "T. Richardson / 94-104", "code": "T. Richardson / 94-104" }, { "name": "T. Todd / 94-174", "code": "T. Todd / 94-174" }, { "name": "V. Cobian / 94-150", "code": "V. Cobian / 94-150" }, { "name": "V. Hernandez / 94-238", "code": "V. Hernandez / 94-238" }, { "name": "V. Tran / 94-217", "code": "V. Tran / 94-217" }, { "name": "W. Jarus / 94-180", "code": "W. Jarus / 94-180" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GroupName", "type": "esriFieldTypeString", "alias": "Group Name", "length": 256, "domain": { "type": "codedValue", "name": "GroupName", "description": "", "codedValues": [ { "name": "Inspection", "code": "Inspection" }, { "name": "Heavy Equipment", "code": "Heavy Equipment" }, { "name": "Dana Point", "code": "Dana Point" }, { "name": "Hand Crew ", "code": "Hand Crew" }, { "name": "Traffic Crew", "code": "Traffic Crew" }, { "name": "Staged Equipment", "code": "Staged Equipment" }, { "name": "Light Construction", "code": "Light Construction" }, { "name": "Storm Patrol", "code": "Storm Patrol" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "CrewMembers", "type": "esriFieldTypeString", "alias": "CrewMembers", "length": 4000, "domain": null }, { "name": "PhoneNumber", "type": "esriFieldTypeString", "alias": "PhoneNumber", "length": 4000, "domain": null }, { "name": "VIN", "type": "esriFieldTypeString", "alias": "VIN", "length": 4000, "domain": null }, { "name": "Description", "type": "esriFieldTypeString", "alias": "Description", "length": 4000, "domain": null }, { "name": "License__", "type": "esriFieldTypeString", "alias": "License #", "length": 4000, "domain": null }, { "name": "JOINID", "type": "esriFieldTypeString", "alias": "JOINID", "length": 4000, "domain": null }, { "name": "VINJOIN", "type": "esriFieldTypeString", "alias": "VINJOIN", "length": 4000, "domain": null }, { "name": "Comments", "type": "esriFieldTypeString", "alias": "Comments", "length": 256, "domain": null } ], "indexes": [ { "name": "R361_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "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, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } } ] }