X-Received: by 2002:ad4:4841:: with SMTP id t1mr5365455qvy.187.1591828256212; Wed, 10 Jun 2020 15:30:56 -0700 (PDT)
X-Received: by 2002:a25:400e:: with SMTP id n14mr8358566yba.424.1591828255873; Wed, 10 Jun 2020 15:30:55 -0700 (PDT)
Path: csiph.com!xmission!news.alt.net!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Wed, 10 Jun 2020 15:30:55 -0700 (PDT)
In-Reply-To: <XnsABD928EDA5F3Yazorman@127.0.0.1>
Complaints-To: groups-abuse@google.com
Injection-Info: google-groups.googlegroups.com; posting-host=156.39.0.199; posting-account=l2bzzwoAAABu-fdSSbYhIW6Ic9fVTF16
NNTP-Posting-Host: 156.39.0.199
References: <b8df0410-a799-45e8-b128-4c8a62b38ed6o@googlegroups.com> <XnsABD8DEF547D6EYazorman@127.0.0.1> <25356606-299b-4623-809d-0d6eb9af0906o@googlegroups.com> <XnsABD8F11BF16BFYazorman@127.0.0.1> <4b1c3504-2511-4c3c-a5fb-b880e39caeb6o@googlegroups.com> <XnsABD928EDA5F3Yazorman@127.0.0.1>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <07f4ed04-6ddf-42e8-afac-655b93b690e3o@googlegroups.com>
Subject: Re: Unable to query xml data in sql server
From: chris H <chris.sjpd@gmail.com>
Injection-Date: Wed, 10 Jun 2020 22:30:56 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 766
Xref: csiph.com comp.databases.ms-sqlserver:2045

On Wednesday, June 10, 2020 at 3:15:07 PM UTC-7, Erland Sommarskog wrote:
> chris H (chris.sjpd@gmail.com) writes:
> > That is a complete xml file.  When I doubleclick to open it, it does no=
t have root tag.=20
> >=20
>=20
> I would say it's not an XML file then. An XML file has exactly a single r=
oot tag. SQL Server supports repeated root tags, but there are no root tags=
 at all here.
>=20
> I get this error from sp_xml_preparedocument:
>=20
> Msg 6602, Level 16, State 2, Procedure sp_xml_preparedocument, Line 1 [Ba=
tch Start Line 0]
> The error description is 'Only one top level element is allowed in an XML=
 document.'.
>=20
>=20
> DECLARE @x xml =3D=20
> ' <AccidentReportNumber-AllPages>2020-200320523</AccidentReportNumber-All=
Pages>
>  <AddressFullText>1493 CRESTHAVEN LN,SAN JOSE, CA,  95118</AddressFullTex=
t>
>  <InjuredWas_driver>1</InjuredWas_driver>
>  <PedestrianActionA-AllPages>1</PedestrianActionA-AllPages>
>  <MotorVehicleInvolvedWithC-AllPages>1</MotorVehicleInvolvedWithC-AllPage=
s>
>  <CollisionOccurredDate-AllPages>02-01-2020</CollisionOccurredDate-AllPag=
es>
>  <Time-AllPages>1547</Time-AllPages>'
>=20
> DECLARE @hDoc int
> EXEC sp_xml_preparedocument @hDoc OUTPUT, @x
>=20
>=20
>  SELECT *
> FROM OPENXML(@hDoc, '/', 1)
> WITH=20
> (
> 	[AccidentReportNumber-AllPages] varchar(20),
>     AddressFullText varchar(100) '/trafficunit/driver',
>     "InjuredWas_driver" int '/involvedPeople',
>     [PedestrianActionA-AllPages] int,
>     [MotorVehicleInvolvedWithC-AllPages] int,
>     [CollisionOccurredDate-AllPages]  date,
>     [Time-AllPages]  int
> )
>=20
> EXEC sp_xml_removedocument @hDoc OUTPUT

This is all I have to work with :-(  The xml file is coming from an applica=
tion which combines some columns from db & others from the xml form.  I hav=
e spent a lot of time to get it work because we only need data in a few col=
umns


<agency xmlns=3D"" xmlns:xforms=3D"http://www.w3.org/2002/xforms" xmlns:ev=
=3D"http://www.w3.org/2001/xml-events" xmlns:xsd=3D"http://www.w3.org/2001/=
XMLSchema" xmlns:xsi=3D"http://www.w3.org/1999/XMLSchema-instance" xmlns:SO=
AP-ENV=3D"http://schemas.xmlsoap.org/soap/envelope" xmlns:fjs1=3D"http://ww=
w.versaterm.com/rms/ns/RMS_7.2" xmlns:fjs2=3D"http://www.versaterm.com/rms/=
types/RMS_7.2" formLock=3D"off" project_name=3D"mva_california" form_versio=
n=3D"065" form_path=3D"site/version/" formname=3D"vtm_california_mva_v1">
  <PageNum />
  <Pages />
  <TrafficUnit>
    <TrafficUnit_Number>1</TrafficUnit_Number>
    <Driver>
      <BlankOption />
      <TrafficUnit_Number />
      <ID_Num>442240070</ID_Num>
      <RoleTrans>Drv(ACC)</RoleTrans>
      <RoleNumber>1</RoleNumber>
      <AddressFullText>1554 GLENCREST CT,SAN JOSE, CA,  95118</AddressFullT=
ext>
      <AddressStreetText>1554 GLENCREST CT</AddressStreetText>
      <AddressCityStateZip>SAN JOSE, CA,  95118</AddressCityStateZip>
      <City>SAN JOSE</City>
      <State>CA</State>
      <Zip>95118</Zip>
      <StateOfIssue>CA</StateOfIssue>
      <LicenseClass>01</LicenseClass>
      <Sex>F</Sex>
      <Hair>BRO</Hair>
      <Eyes>BRO</Eyes>
      <Height>5'06</Height>
      <Weight>140</Weight>
      <Race>W</Race>
      <DateOfBirth>09-20-1985</DateOfBirth>
      <BirthDateYear>1985</BirthDateYear>
      <BirthDateMonth>09</BirthDateMonth>
      <BirthDateDay>20</BirthDateDay>
      <Age>34</Age>
      <ChargeDescriptionText />
    </Driver>
    <Vehicle>
      <BlankOption />
      <ID_Num>211222</ID_Num>
      <RoleTrans>Involved (ACCIDENTS&amp;STR CHKS)</RoleTrans>
      <RoleNumber>1</RoleNumber>
      <ModelYear>2020</ModelYear>
      <Make>TOYT</Make>
      <Model>SNA</Model>
      <Style>4H</Style>
      <Colour>WHI/</Colour>
      <StateOfIssue>CA</StateOfIssue>
      <AddressFullText />
      <CityState />
      <Zip />
      <VehicleType>1</VehicleType>
      <NumberOfOccupants />
      <InsuranceName>AAA</InsuranceName>
      <InsuranceExpiryDate />
    </Vehicle>
    <MovementProcedingCollisionB />
    <MovementProcedingCollisionC />
    <MovementProcedingCollisionA />
    <MovementProcedingCollisionE>1</MovementProcedingCollisionE>
    <VehicleOwner>
      <BlankOption />
      <ID_Num>442240070</ID_Num>
      <RoleTrans>Drv(ACC)</RoleTrans>
      <RoleNumber>1</RoleNumber>
      <Seat_position />
      <AddressFullText>1554 GLENCREST CT</AddressFullText>
      <CityState>SAN JOSE,  CA</CityState>
      <Zip>95118</Zip>
      <ProvStateOfIssue>CA</ProvStateOfIssue>
      <Age>34</Age>
      <Sex>F</Sex>
      <BirthDateYear>1985</BirthDateYear>
      <BirthDateMonth>09</BirthDateMonth>
      <BirthDateDay>20</BirthDateDay>
    </VehicleOwner>
    <NameSameAsDriver />
    <AddrSameAsDriver />
    <TrafficUnitDriverOtherCheck />
    <TrafficUnitDriverBikeCheck />
    <TrafficUnitDriverParkedCheck />
    <TrafficUnitPedestrianCheck />
    <TrafficUnitDriverCheck>1</TrafficUnitDriverCheck>
    <DispositionVehicleByOfficer />
    <DispositionVehicleByDriver>1</DispositionVehicleByDriver>
    <DispositionVehicleByOther />
    <PriorMechanicalDefectsNone />
    <PriorMechanicalDefectsNarr />
    <DescribeVehDamageUnk />
    <DescribeVehDamageNone />
    <DescribeVehDamageMinor />
    <DescribeVehDamageMod />
    <DescribeVehDamageMajor>1</DescribeVehDamageMajor>
    <DescribeVehDamageRollOver />
    <Damage_14 />
    <Damage_13 />
    <Damage_11>1</Damage_11>
    <Damage_9>1</Damage_9>
    <Damage_7 />
    <Damage_4 />
    <Damage_3 />
    <Damage_2 />
    <Damage_12 />
    <Damage_1 />
    <Damage_10>1</Damage_10>
    <Damage_8 />
    <Damage_6 />
    <Damage_5 />
    <VehicleType1 />
    <VehicleType2 />
    <SpecialInformationA />
    <SpecialInformationB />
    <SpecialInformationC />
    <SpecialInformationE />
    <SpecialInformationD />
    <SpecialInformationF />
    <SpecialInformationG />
    <SpecialInformationI />
    <SpecialInformationH />
    <SpecialInformationJ />
    <SpecialInformationK />
    <SpecialInformationL />
    <SpecialInformationM />
    <SpecialInformationN />
    <SpecialInformationO />
    <OtherAssociatedFactorsC />
    <OtherAssociatedFactorsB />
    <OtherAssociatedFactorsA />
    <OtherAssociatedFactorsE />
    <OtherAssociatedFactorsF />
    <OtherAssociatedFactorsG />
    <OtherAssociatedFactorsH />
    <OtherAssociatedFactorsI />
    <OtherAssociatedFactorsJ />
    <OtherAssociatedFactorsK />
    <OtherAssociatedFactorsL />
    <OtherAssociatedFactorsM />
    <OtherAssociatedFactorsN />
    <OtherAssociatedFactorsO />
    <MovementProcedingCollisionD />
    <MovementProcedingCollisionF />
    <MovementProcedingCollisionG />
    <MovementProcedingCollisionH />
    <MovementProcedingCollisionI />
    <MovementProcedingCollisionJ />
    <MovementProcedingCollisionK />
    <MovementProcedingCollisionL />
    <MovementProcedingCollisionM />
    <MovementProcedingCollisionN />
    <MovementProcedingCollisionO />
    <MovementProcedingCollisionP />
    <MovementProcedingCollisionQ />
    <MovementProcedingCollisionR />
    <SobrietyDrugPhysicalA>1</SobrietyDrugPhysicalA>
    <SobrietyDrugPhysicalC />
    <SobrietyDrugPhysicalB />
    <SobrietyDrugPhysicalE />
    <SobrietyDrugPhysicalD />
    <SobrietyDrugPhysicalF />
    <SobrietyDrugPhysicalG />
    <SobrietyDrugPhysicalH />
    <SobrietyDrugPhysicalI />
    <OnDutyEMV />
    <DriverAirBag-Box-16>M</DriverAirBag-Box-16>
    <DriverSafetyEquipmentUsed-Box-18>G</DriverSafetyEquipmentUsed-Box-18>
    <Direction-Box-5>SE</Direction-Box-5>
    <OnStreetOrHighway>BRANHAM LN</OnStreetOrHighway>
    <SpeedLimit>35</SpeedLimit>
    <DispositionText />
    <OtherAssociatedFactorsAText />
    <OtherAssociatedFactorsACitedYesNO />
    <CAL_T />
    <MC_MX />
    <CA />
    <DOT />
    <TCP_PSC />
  </TrafficUnit>
  <TrafficUnit>
    <TrafficUnit_Number>2</TrafficUnit_Number>
    <Driver>
      <BlankOption />
      <TrafficUnit_Number />
      <ID_Num>442240071</ID_Num>
      <RoleTrans>Drv(ACC)</RoleTrans>
      <RoleNumber>2</RoleNumber>
      <AddressFullText>1493 CRESTHAVEN LN,SAN JOSE, CA,  95118</AddressFull=
Text>
      <AddressStreetText>1493 CRESTHAVEN LN</AddressStreetText>
      <AddressCityStateZip>SAN JOSE, CA,  95118</AddressCityStateZip>
      <City>SAN JOSE</City>
      <State>CA</State>
      <Zip>95118</Zip>
      <StateOfIssue>CA</StateOfIssue>
      <LicenseClass>01</LicenseClass>
      <Sex>M</Sex>
      <Hair>BLK</Hair>
      <Eyes>BRO</Eyes>
      <Height>5'6</Height>
      <Weight>138</Weight>
      <Race>A</Race>
      <DateOfBirth>09-29-1984</DateOfBirth>
      <BirthDateYear>1984</BirthDateYear>
      <BirthDateMonth>09</BirthDateMonth>
      <BirthDateDay>29</BirthDateDay>
      <Age>35</Age>
      <ChargeDescriptionText />
    </Driver>
    <Vehicle>
      <BlankOption />
      <ID_Num>211223</ID_Num>
      <RoleTrans>Involved (ACCIDENTS&amp;STR CHKS)</RoleTrans>
      <RoleNumber>2</RoleNumber>
      <ModelYear>2015</ModelYear>
      <Make>VOLK</Make>
      <Model>TGN</Model>
      <Style>4H</Style>
      <Colour>GRY/</Colour>
      <StateOfIssue>CA</StateOfIssue>
      <AddressFullText />
      <CityState />
      <Zip />
      <VehicleType>1</VehicleType>
      <NumberOfOccupants />
      <InsuranceName>GEICO</InsuranceName>
      <InsuranceExpiryDate />
    </Vehicle>
    <MovementProcedingCollisionB>1</MovementProcedingCollisionB>
    <MovementProcedingCollisionC />
    <MovementProcedingCollisionA />
    <MovementProcedingCollisionE />
    <VehicleOwner>
      <BlankOption />
      <ID_Num>442240071</ID_Num>
      <RoleTrans>Drv(ACC)</RoleTrans>
      <RoleNumber>2</RoleNumber>
      <Seat_position />
      <AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
      <CityState>SAN JOSE,  CA</CityState>
      <Zip>95118</Zip>
      <ProvStateOfIssue>CA</ProvStateOfIssue>
      <Age>35</Age>
      <Sex>M</Sex>
      <BirthDateYear>1984</BirthDateYear>
      <BirthDateMonth>09</BirthDateMonth>
      <BirthDateDay>29</BirthDateDay>
    </VehicleOwner>
    <NameSameAsDriver />
    <AddrSameAsDriver />
    <TrafficUnitDriverOtherCheck />
    <TrafficUnitDriverBikeCheck />
    <TrafficUnitDriverParkedCheck />
    <TrafficUnitPedestrianCheck />
    <TrafficUnitDriverCheck>1</TrafficUnitDriverCheck>
    <DispositionVehicleByOfficer />
    <DispositionVehicleByDriver>1</DispositionVehicleByDriver>
    <DispositionVehicleByOther />
    <PriorMechanicalDefectsNone>1</PriorMechanicalDefectsNone>
    <PriorMechanicalDefectsNarr />
    <DescribeVehDamageUnk />
    <DescribeVehDamageNone />
    <DescribeVehDamageMinor />
    <DescribeVehDamageMod />
    <DescribeVehDamageMajor>1</DescribeVehDamageMajor>
    <DescribeVehDamageRollOver />
    <Damage_14 />
    <Damage_13 />
    <Damage_11 />
    <Damage_9>1</Damage_9>
    <Damage_7 />
    <Damage_4 />
    <Damage_3 />
    <Damage_2 />
    <Damage_12 />
    <Damage_1 />
    <Damage_10>1</Damage_10>
    <Damage_8>1</Damage_8>
    <Damage_6 />
    <Damage_5 />
    <VehicleType1 />
    <VehicleType2 />
    <SpecialInformationA />
    <SpecialInformationB />
    <SpecialInformationC />
    <SpecialInformationE />
    <SpecialInformationD />
    <SpecialInformationF />
    <SpecialInformationG />
    <SpecialInformationI />
    <SpecialInformationH />
    <SpecialInformationJ />
    <SpecialInformationK />
    <SpecialInformationL />
    <SpecialInformationM />
    <SpecialInformationN />
    <SpecialInformationO />
    <OtherAssociatedFactorsC />
    <OtherAssociatedFactorsB />
    <OtherAssociatedFactorsA />
    <OtherAssociatedFactorsE />
    <OtherAssociatedFactorsF />
    <OtherAssociatedFactorsG />
    <OtherAssociatedFactorsH />
    <OtherAssociatedFactorsI />
    <OtherAssociatedFactorsJ />
    <OtherAssociatedFactorsK />
    <OtherAssociatedFactorsL />
    <OtherAssociatedFactorsM />
    <OtherAssociatedFactorsN />
    <OtherAssociatedFactorsO />
    <MovementProcedingCollisionD />
    <MovementProcedingCollisionF />
    <MovementProcedingCollisionG />
    <MovementProcedingCollisionH />
    <MovementProcedingCollisionI />
    <MovementProcedingCollisionJ />
    <MovementProcedingCollisionK />
    <MovementProcedingCollisionL />
    <MovementProcedingCollisionM />
    <MovementProcedingCollisionN />
    <MovementProcedingCollisionO />
    <MovementProcedingCollisionP />
    <MovementProcedingCollisionQ />
    <MovementProcedingCollisionR />
    <SobrietyDrugPhysicalA>1</SobrietyDrugPhysicalA>
    <SobrietyDrugPhysicalC />
    <SobrietyDrugPhysicalB />
    <SobrietyDrugPhysicalE />
    <SobrietyDrugPhysicalD />
    <SobrietyDrugPhysicalF />
    <SobrietyDrugPhysicalG />
    <SobrietyDrugPhysicalH />
    <SobrietyDrugPhysicalI />
    <OnDutyEMV />
    <DriverAirBag-Box-16>L</DriverAirBag-Box-16>
    <DriverSafetyEquipmentUsed-Box-18>G</DriverSafetyEquipmentUsed-Box-18>
    <Direction-Box-5>W</Direction-Box-5>
    <OnStreetOrHighway>BRANHAM LN</OnStreetOrHighway>
    <SpeedLimit>35</SpeedLimit>
    <DispositionText />
    <OtherAssociatedFactorsAText />
    <OtherAssociatedFactorsACitedYesNO />
    <CAL_T />
    <MC_MX />
    <CA />
    <DOT />
    <TCP_PSC />
  </TrafficUnit>
  <ReportingDistrict-AllPages>SOUTHERN</ReportingDistrict-AllPages>
  <InvolvedPeople>
    <InvolvedPeople_Number>1</InvolvedPeople_Number>
    <Person>
      <BlankOption />
      <ID_Num>442240071</ID_Num>
      <RoleTrans>Drv(ACC)</RoleTrans>
      <RoleNumber>2</RoleNumber>
      <Seat_position />
      <AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
      <CityState>SAN JOSE,  CA</CityState>
      <Zip>95118</Zip>
      <ProvStateOfIssue>CA</ProvStateOfIssue>
      <Age>35</Age>
      <Sex>M</Sex>
      <BirthDateYear>1984</BirthDateYear>
      <BirthDateMonth>09</BirthDateMonth>
      <BirthDateDay>29</BirthDateDay>
    </Person>
    <Describe_Injuries />
    <InvolvedInjuryDesc />
    <Witness_Only />
    <Passenger_Only />
    <ExtentOfInjury_Fatal />
    <ExtentOfInjury_Severe />
    <ExtentOfInjury_OtherVisInjury>1</ExtentOfInjury_OtherVisInjury>
    <ExtentOfInjury_ComplaintOfPain>1</ExtentOfInjury_ComplaintOfPain>
    <InjuredWas_driver>1</InjuredWas_driver>
    <InjuredWas_Pedestrian />
    <InjuredWas_Bicyclist />
    <InjuredWas_Other />
    <Victim_ViolentCrimeNotified />
    <PartyNumber>2</PartyNumber>
    <InvolvedAirBag-Box-17>L</InvolvedAirBag-Box-17>
    <InvolvedSafetyEquipmentUsed-Box-19>G</InvolvedSafetyEquipmentUsed-Box-=
19>
    <InvolvedEjection-Box-20 />
    <InvolvedTransportedBy>EMS</InvolvedTransportedBy>
    <InvolvedTransportedTo>GOOD SAMARITAN HOSPITAL</InvolvedTransportedTo>
    <InvolvedInjuryDesc1>SWELLING AND BRUISING ON ARMS / DIZZINESS</Involve=
dInjuryDesc1>
    <InvolvedInjuryDesc2 />
    <InvolvedInjuryDesc3 />
    <Witness_Unit />
    <InjuredWas_passenger />
  </InvolvedPeople>
  <InvolvedPeople>
    <InvolvedPeople_Number>2</InvolvedPeople_Number>
    <Person>
      <BlankOption />
      <ID_Num>442240072</ID_Num>
      <RoleTrans>Inj (ACC)</RoleTrans>
      <RoleNumber>1</RoleNumber>
      <Seat_position />
      <AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
      <CityState>SAN JOSE,  CA</CityState>
      <Zip>95118</Zip>
      <ProvStateOfIssue>CA</ProvStateOfIssue>
      <Age>38</Age>
      <Sex>M</Sex>
      <BirthDateYear>1981</BirthDateYear>
      <BirthDateMonth>12</BirthDateMonth>
      <BirthDateDay>18</BirthDateDay>
    </Person>
    <Describe_Injuries />
    <InvolvedInjuryDesc />
    <Witness_Only />
    <Passenger_Only />
    <ExtentOfInjury_Fatal />
    <ExtentOfInjury_Severe />
    <ExtentOfInjury_OtherVisInjury />
    <ExtentOfInjury_ComplaintOfPain />
    <InjuredWas_driver />
    <InjuredWas_Pedestrian />
    <InjuredWas_Bicyclist />
    <InjuredWas_Other />
    <Victim_ViolentCrimeNotified />
    <PartyNumber>2</PartyNumber>
    <InvolvedAirBag-Box-17>L</InvolvedAirBag-Box-17>
    <InvolvedSafetyEquipmentUsed-Box-19>G</InvolvedSafetyEquipmentUsed-Box-=
19>
    <InvolvedEjection-Box-20 />
    <InvolvedTransportedBy>EMS</InvolvedTransportedBy>
    <InvolvedTransportedTo>GOOD SAM                                        =
         SEAT POS #3</InvolvedTransportedTo>
    <InvolvedInjuryDesc1>NECK AND CHEST PAIN</InvolvedInjuryDesc1>
    <InvolvedInjuryDesc2 />
    <InvolvedInjuryDesc3 />
    <Witness_Unit />
    <InjuredWas_passenger>1</InjuredWas_passenger>
  </InvolvedPeople>
  <InvolvedPeople>
    <InvolvedPeople_Number>3</InvolvedPeople_Number>
    <Person>
      <BlankOption />
      <ID_Num>442240073</ID_Num>
      <RoleTrans>Inj (ACC)</RoleTrans>
      <RoleNumber>2</RoleNumber>
      <Seat_position />
      <AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
      <CityState>SAN JOSE,  CA</CityState>
      <Zip>95118</Zip>
      <ProvStateOfIssue />
      <Age>6</Age>
      <Sex>M</Sex>
      <BirthDateYear>2013</BirthDateYear>
      <BirthDateMonth>09</BirthDateMonth>
      <BirthDateDay>05</BirthDateDay>
    </Person>
    <Describe_Injuries />
    <InvolvedInjuryDesc />
    <Witness_Only />
    <Passenger_Only />
    <ExtentOfInjury_Fatal />
    <ExtentOfInjury_Severe />
    <ExtentOfInjury_OtherVisInjury />
    <ExtentOfInjury_ComplaintOfPain />
    <InjuredWas_driver />
    <InjuredWas_Pedestrian />
    <InjuredWas_Bicyclist />
    <InjuredWas_Other />
    <Victim_ViolentCrimeNotified />
    <PartyNumber>2</PartyNumber>
    <InvolvedAirBag-Box-17>L</InvolvedAirBag-Box-17>
    <InvolvedSafetyEquipmentUsed-Box-19>Q</InvolvedSafetyEquipmentUsed-Box-=
19>
    <InvolvedEjection-Box-20 />
    <InvolvedTransportedBy>EMS</InvolvedTransportedBy>
    <InvolvedTransportedTo>GOOD SAM                                        =
           SEAT POS #4</InvolvedTransportedTo>
    <InvolvedInjuryDesc1>BLOODY MOUTH</InvolvedInjuryDesc1>
    <InvolvedInjuryDesc2 />
    <InvolvedInjuryDesc3 />
    <Witness_Unit />
    <InjuredWas_passenger>1</InjuredWas_passenger>
  </InvolvedPeople>
  <InvolvedPeople>
    <InvolvedPeople_Number>4</InvolvedPeople_Number>
    <Person>
      <BlankOption />
      <ID_Num>442240075</ID_Num>
      <RoleTrans>Inj (ACC)</RoleTrans>
      <RoleNumber>3</RoleNumber>
      <Seat_position />
      <AddressFullText>1493 CRESTHAVEN LN</AddressFullText>
      <CityState>SAN JOSE,  CA</CityState>
      <Zip>95118</Zip>
      <ProvStateOfIssue />
      <Age>3</Age>
      <Sex>M</Sex>
      <BirthDateYear>2016</BirthDateYear>
      <BirthDateMonth>08</BirthDateMonth>
      <BirthDateDay>11</BirthDateDay>
    </Person>
    <Describe_Injuries />
    <InvolvedInjuryDesc />
    <Witness_Only />
    <Passenger_Only />
    <ExtentOfInjury_Fatal />
    <ExtentOfInjury_Severe />
    <ExtentOfInjury_OtherVisInjury />
    <ExtentOfInjury_ComplaintOfPain />
    <InjuredWas_driver />
    <InjuredWas_Pedestrian />
    <InjuredWas_Bicyclist />
    <InjuredWas_Other />
    <Victim_ViolentCrimeNotified />
    <PartyNumber>2</PartyNumber>
    <InvolvedAirBag-Box-17 />
    <InvolvedSafetyEquipmentUsed-Box-19 />
    <InvolvedEjection-Box-20 />
    <InvolvedTransportedBy>EMS</InvolvedTransportedBy>
    <InvolvedTransportedTo>GOOD SAM                                        =
           SEAT POS #6</InvolvedTransportedTo>
    <InvolvedInjuryDesc1>ABDOMINAL PAIN</InvolvedInjuryDesc1>
    <InvolvedInjuryDesc2 />
    <InvolvedInjuryDesc3 />
    <Witness_Unit />
    <InjuredWas_passenger>1</InjuredWas_passenger>
  </InvolvedPeople>
  <Diagram />
  <Diagram2 />
  <AccidentDescriptionText />
  <Latitude-AllPages />
  <Longitude-AllPages />
  <SpecialCondition />
  <CountyTrans-AllPages>SANTA CLARA COUNTY</CountyTrans-AllPages>
  <AccidentWeekday-1-AllPages />
  <AccidentWeekday-2-AllPages />
  <AccidentWeekday-3-AllPages />
  <AccidentWeekday-4-AllPages />
  <AccidentWeekday-5-AllPages />
  <AccidentWeekday-6-AllPages />
  <AccidentWeekday-7-AllPages>[X]</AccidentWeekday-7-AllPages>
  <PropertyOwnerName-AllPages />
  <PropertyOwnerAddress-AllPages />
  <PropertyDamage-AllPages />
  <OtherAssociatedFactorsKText />
  <MovementProcedingCollisionRText />
  <OtherAssociatedFactorsMText />
  <TowAwayYes-AllPages>1</TowAwayYes-AllPages>
  <OtherAssociatedFactorsKCitedYesNo />
  <JudicialDistrict-AllPages>43470</JudicialDistrict-AllPages>
  <PreparersDate-AllPages>02-01-2020</PreparersDate-AllPages>
  <ApprovedBy-AllPages />
  <Description>
    <NarrativeText>
      <LINE>SUMMARY:  On 2-1-20 at about 1547 hrs, emergency services respo=
nded to a two-vehicle collision on</LINE>
      <LINE>Branham Ln at Pinmore Dr. Upon police arrival both vehicles wer=
e disabled in the roadway. </LINE>
      <LINE>Fire/medics assessed all parties for injuries.</LINE>
      <LINE />
      <LINE>STATEMENTS:</LINE>
      <LINE />
      <LINE>  D-1(White) identified herself as the drive of V-1(Toyt) with =
her CDL. D-1 stated that she was</LINE>
      <LINE>making a left turn from the Safeway parking lot to eastbound Br=
anham Ln when she was abruptly struck</LINE>
      <LINE>by V-2(Volk). D-1 said she did not see V-2 approached and specu=
lated that D-2 may have been</LINE>
      <LINE>speeding.  D-1 had a complaint of pain across her neck but decl=
ined medical transport.</LINE>
      <LINE />
      <LINE>  D-2(Joo) identified himself as the driver of V-2(Volk) with h=
is CDL.  D-2 stated that he was</LINE>
      <LINE>simply driving approximately 35 mph in the #1 lane of westbound=
 Branham Ln when V-1(Toyt) abruptly</LINE>
      <LINE>pulled out in front of him.  D-2 stated that he swerved to avoi=
d colliding, however, he had little</LINE>
      <LINE>time to react.</LINE>
      <LINE />
      <LINE>INJURIES:  All 4 occupants of V-2 were transported by ambulance=
 for further assessment of minor to</LINE>
      <LINE>moderate injuries.</LINE>
      <LINE />
      <LINE>CAUSE:  D-1(White) caused the collision when she failed to yiel=
d to all vehicles approaching from</LINE>
      <LINE>opposite direction close enough to be a hazard during any part =
of the turn in violation of 21801(a)</LINE>
      <LINE>VC.</LINE>
    </NarrativeText>
  </Description>
  <PreparersName-AllPages>CRAIG,CHRISTOPHER J (3961)</PreparersName-AllPage=
s>
  <AccidentReportNumber-AllPages>2020-200320523</AccidentReportNumber-AllPa=
ges>
  <PreparersID-AllPages>3961</PreparersID-AllPages>
  <NCIC-AllPages>4313</NCIC-AllPages>
  <ApprovedDate-AllPages />
  <chkCollOther-AllPages />
  <chkTypeSupp_BAUpdate-AllPages />
  <chkTypeSupp_HazMat-AllPages />
  <chkTypeSupp_Fatal-AllPages />
  <chkTypeSupp_SBus-AllPages />
  <chkTypeSupp_HitandRun-AllPages />
  <chkTypeSupp_Other-AllPages />
  <Other_text-AllPages />
  <Coll_Other_text-AllPages />
  <CitationNumber-AllPages />
  <Beat-AllPages>A1</Beat-AllPages>
  <chkStateHywRelated-AllPages />
  <chkNarrative-AllPages>1</chkNarrative-AllPages>
  <Municipality-AllPages>SAN JOSE</Municipality-AllPages>
  <Subject-AllPages />
  <SpecialCondition-AllPages />
  <NumberInjured-AllPages>4</NumberInjured-AllPages>
  <NumberKilled-AllPages />
  <HitAndRunFelony-AllPages />
  <HitAndRunMisdemeanor-AllPages />
  <PhotographsBy-AllPages />
  <PhotographsNone-AllPages />
  <StateHywRelYesNo-AllPages>0</StateHywRelYesNo-AllPages>
  <MilePostInfo1-AllPages />
  <MilePostInfo2-AllPages />
  <MilePostInfo3-AllPages />
  <AtIntersection1-AllPages />
  <AtIntersection2-AllPages />
  <AtIntersection3-AllPages />
  <DispatchNotifiedY-AllPages />
  <DispatchNotifiedN-AllPages />
  <DispatchNotifiedNA-AllPages />
  <ProperyDamageNotifiedYesNo-AllPages />
  <AccidentDescriptionText-AllPages />
  <AtIntersectionWith-AllPages />
  <PrimaryCollisionA-AllPages>1</PrimaryCollisionA-AllPages>
  <PrimaryCollisionB-AllPages />
  <PrimaryCollisionC-AllPages />
  <PrimaryCollisionD-AllPages />
  <VCSectionViolatedText-AllPages>21801(a) VC</VCSectionViolatedText-AllPag=
es>
  <PrimaryCollisionBText-AllPages />
  <VCSectionViolatedCitedYes-AllPages>0</VCSectionViolatedCitedYes-AllPages=
>
  <WeatherA-AllPages>1</WeatherA-AllPages>
  <WeatherB-AllPages />
  <WeatherC-AllPages />
  <WeatherD-AllPages />
  <WeatherE-AllPages />
  <WeatherF-AllPages />
  <WeatherG-AllPages />
  <Weather_visibility-AllPages />
  <WeatherOther-AllPages />
  <LightingA-AllPages>1</LightingA-AllPages>
  <LightingB-AllPages />
  <LightingC-AllPages />
  <LightingD-AllPages />
  <LightingE-AllPages />
  <RoadwaySurfaceA-AllPages>1</RoadwaySurfaceA-AllPages>
  <RoadwaySurfaceB-AllPages />
  <RoadwaySurfaceC-AllPages />
  <RoadwaySurfaceD-AllPages />
  <RoadwayConditionsA-AllPages />
  <RoadwayConditionsB-AllPages />
  <RoadwayConditionsC-AllPages />
  <RoadwayConditionsD-AllPages />
  <RoadwayConditionsE-AllPages />
  <RoadwayConditionsF-AllPages />
  <RoadwayConditionsG-AllPages />
  <RoadwayConditionsH-AllPages>1</RoadwayConditionsH-AllPages>
  <TrafficControlDevicesA-AllPages />
  <TrafficControlDevicesB-AllPages />
  <TrafficControlDevicesC-AllPages />
  <TrafficControlDevicesD-AllPages>1</TrafficControlDevicesD-AllPages>
  <TypeOfCollisionA-AllPages />
  <TypeOfCollisionB-AllPages />
  <TypeOfCollisionC-AllPages />
  <TypeOfCollisionD-AllPages>1</TypeOfCollisionD-AllPages>
  <TypeOfCollisionE-AllPages />
  <TypeOfCollisionF-AllPages />
  <TypeOfCollisionG-AllPages />
  <TypeOfCollisionH-AllPages />
  <MotorVehicleInvolvedWithA-AllPages />
  <MotorVehicleInvolvedWithB-AllPages />
  <MotorVehicleInvolvedWithC-AllPages>1</MotorVehicleInvolvedWithC-AllPages=
>
  <MotorVehicleInvolvedWithD-AllPages />
  <MotorVehicleInvolvedWithE-AllPages />
  <MotorVehicleInvolvedWithF-AllPages />
  <MotorVehicleInvolvedWithG-AllPages />
  <MotorVehicleInvolvedWithH-AllPages />
  <MotorVehicleInvolvedWithI-AllPages />
  <MotorVehicleInvolvedWithJ-AllPages />
  <PedestrianActionA-AllPages>1</PedestrianActionA-AllPages>
  <PedestrianActionB-AllPages />
  <PedestrianActionC-AllPages />
  <PedestrianActionD-AllPages />
  <PedestrianActionE-AllPages />
  <PedestrianActionF-AllPages />
  <PedestrianActionG-AllPages />
  <MotorVehicleInvolvedWithHText-AllPages />
  <MotorVehicleInvolvedWithIText-AllPages />
  <MotorVehicleInvolvedWithJText-AllPages />
  <CollisionOccurredOn2-AllPages>PINMORE DR</CollisionOccurredOn2-AllPages>
  <CollisionOccurredOn1-AllPages>BRANHAM LN</CollisionOccurredOn1-AllPages>
  <RoadwayCGText-AllPages />
  <TypeOfCollisionHText-AllPages />
  <OtherAssocFactorsFCode-Box-22 />
  <CollisionOccurredDate-AllPages>02-01-2020</CollisionOccurredDate-AllPage=
s>
  <Time-AllPages>1547</Time-AllPages>
</agency>