<\/HEAD>
Toto je způsob, jak KDOT poskytl souhrnná data o stavu vozovky PM2 z dat extrahovaných z našeho HPMS Dashboard pro použití našimi MPO. <\/P>
<\/P>
zde jsou prahové hodnoty:<\/P>
<\/P>
<\/P>
<\/P>
Pak přidejte tento zvrat:<\/P>
Pro desátý mílový úsek, aby byl považován za good, musí být všechny tři měřítka good. Pokud jsou dvě jakákoli poor, pak je celkově poor. <\/SPAN><\/P><\/P>Takže nejprve přidám pole pro měřítko "LEVEL", a zde je, jak jsem tato měřítka interpretoval, od 1good do 3poor, pomocí následujícího kódu pro SQL Server management studio.<\/P><\/P>Typy povrchů vozovky jsou samozřejmě kódované hodnoty HPMS.<\/P> <\/SPAN><\/P> <\/SPAN>update<\/SPAN> [shared]<\/SPAN>.<\/SPAN>[PM2_2017]<\/SPAN><\/P> <\/SPAN>set<\/SPAN> IRI_LEVEL <\/SPAN>=<\/SPAN> 0<\/SPAN>,<\/SPAN> RUTTING_LEVEL <\/SPAN>=<\/SPAN> 0<\/SPAN>,<\/SPAN> CRACKING_LEVEL <\/SPAN>=<\/SPAN> 0<\/SPAN>,<\/SPAN> FAULTING_LEVEL <\/SPAN>=<\/SPAN> 0<\/SPAN>,<\/SPAN> [PM_LEVEL] <\/SPAN>=<\/SPAN> 0<\/SPAN><\/P> <\/SPAN>where<\/SPAN> 1<\/SPAN>=<\/SPAN>1<\/SPAN><\/P> <\/SPAN><\/P> <\/SPAN>update<\/SPAN> [shared]<\/SPAN>.<\/SPAN>[PM2_2017]<\/SPAN><\/P> <\/SPAN>set<\/SPAN> IRI_LEVEL <\/SPAN>=<\/SPAN>1<\/><\/>\n\n<\n<P>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n 9.5pt; color: black;"> 2
kde RUTTING_VN >= 0.2 a RUTTING_VN <=0.4
A SURFACE_TYPE_VN V (2, 6, 7, 8)
update [shared].[PM2_2017]
nastavit RUTTING_LEVEL = 3
kde RUTTING_VN > 0,4
  ; A N D SURFACE_TYPE_VN I N ( 2 , 6 , 7 , 8 )
< span styl e=' font - size : 'color :black;'>   ; </ span > </ p > < p > < span styl e=' font - size : 'color :fuchsia;'> update </ span > < span styl e=' font - size : 'color :black;'> [ shared ] </ span > < span styl e=' font - size : 'color :gray;'> . </ span > < span styl e=' font - size : 'color :black;'> [ PM2_2017 ] </ span > </ p > < p > < span styl e=' font - size : 'color :blue;'> set </ span > < span styl e=' font - size : 'color:black;'> CRACKING_LEVEL </ span > < span styl e=' font - size :'color':gray;'> = </ span > < span styl e=' font - size :'color':black;'>1</ span > </ p > < p > < span styl e=' font - size :'color':black;'> </ span > < span styl e=' font - size :'color':blue;'> kde </ span > < span styl e=' font - size :'color':black;'> CRACKING_percent_VN </ span > < span styl e=' font - size :'color':gray;'><</ span > < span styl e=' font - size :'color':black;'>5</ span > </ p > < p > </ p >
updat e< /sp an >[share d]< /sp an >.< /sp an >[PM2_2017]< /sp an >
set< /sp an >CRACKING_LEVEL< /sp an >=< /sp an >2< /sp an >
< /p >
kde< /sp an >CRACKING_percent_VN< /sp an >>=< /sp an >5< /sp an > < sp an sty le ='fon t-siz e:' col or:g ray ;'>a< / sp an > < sp an sty le ='fon t-siz e:' col or:black ;'>CRACKING_percent_VN< / sp an > <= < sp an sty le ='fon t-siz e:' col or:black ;'>10< / sp an > < sp an sty le ='fon t-siz e:' col or:g ray ;'>A< / sp an > < sp an sty le ='fon t-siz e:' col or:black ;'>SURFACE_TYPE_VN< / sp an > < sp an sty le ='fon t-siz e:' col or:g ray ;'>(< / sp an > < sp an sty le ='fon t-siz e:' col or:black ;'>5< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp an ><;< / sp a n>) ;
update[shared][PM2_2017]setCRACKING_LEVEL =2whereCRACKING_percent_VN >=5 and CRACKING_percent_VN <=15 and SURFACE_TYPE_VN IN (10,3,4);</spa nstyle ="fontsize:"col or:black "> update[shared][PM2_2017]setCRACKING_LEVEL =2whereCRACKING_percent_VN >=5 and CRACKING_percent_VN <=20 and SURFACE_TYPE_VN IN (2,6,7);</spa nstyle ="fontsize:"col or:fuchsia ">update[shared][PM2_2017]setCRACKING_LEVEL =3 9.5pt; color: blue;">kde CRACKING_percent_VN >10
A SURFACE_TYPE_VN V (5);
update [shared].[PM2_2017]
nastavit CRACKING_LEVEL = 3
kde CRACKING_percent_VN >15
A SURFACE_TYPE_VN V (10, 3, 4);
9.5pt; color: blue;">kde<\/SPAN> IRI_LEVEL <\/SPAN>=<\/SPAN>1 <\/SPAN>A<\/SPAN> CRACKING_LEVEL <\/SPAN>=<\/SPAN> 1 <\/SPAN>A<\/SPAN> (<\/SPAN>RUTTING_LEVEL <\/SPAN>=<\/SPAN> 1 <\/SPAN>NEBO<\/SPAN> FAULTING_LEVEL <\/SPAN>=<\/SPAN> 1<\/SPAN>)<\/SPAN><\/P> <\/SPAN><\/P> <\/SPAN>update<\/SPAN> [shared]<\/SPAN>.<\/SPAN>[PM2_2017]<\/SPAN><\/P> <\/SPAN>nastavit<\/SPAN> PM_LEVEL <\/SPAN>=<\/SPAN> 3<\/SPAN><\/P> <\/SPAN>kde <\/SPAN>(<\/SPAN>IRI_LEVEL <\/SPAN>=<\/SPAN>3 <\/SPAN>A<\/SPAN> CRACKING_LEVEL <\/span > = < / span >< span style = " font - size : 9 . 5 pt ;color : black ; ">3< / span >< span style = " font - size : 9 . 5 pt ;color : gray ; ">)< / span >< / p >< p >< span style = " font - size : 9 . 5 pt ;color : black ; ">& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;< / span >< span style = " font - size : 9 . 5 pt ;color : gray ; ">NEBO< / span > < span style = " font - size : 9 . 5 pt ;color : gray ; ">(IRI_LEVEL < / span >< span style = " font - size : 9 . 5 pt ;color : gray ; "> = < / span >< span style = " font - size : 9 . 5 pt ;color : black ; ">3 < / span >< span style = " font - size : 9 . 5 pt ;color : gray ; ">A< / span > RUTTING_LEVEL < / span >< span style = " font - size : 9 . 5 pt ;color : gray ; "> = < / span >< span style = " font - size : 9 . 5 pt ;color : black ; ">3< / span >< span style = " font - size : 9 . 5 pt ;color : gray ; ">)< / span >< / p >< p >< span style = " font - size : 9 . 5 pt ;color : black ; ">& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;< / span >NEBO< /span> (IRI_LEVEL < /span >=< /span >3 <spanstyle=
