<\/HEAD>
É assim que a KDOT entregou os dados resumidos do PM2 Pavement Condition extraídos do nosso Painel HPMS para uso dos nossos MPOs. <\/P>
<\/P>
aqui estão os valores de limite:<\/P>
<\/P>
<\/P>
<\/P>
Então, adicione esta reviravolta:<\/P>
Para o segmento de décima milha ser considerado boa, todas as treas medidas devem ser boas. Se quaisquer duas forem ruins, ente3o no geral e9 ruim. <\/SPAN><\/P><\/P>Ente3o, primeiro eu adiciono campos para a medida "LEVEL", e aqui este1 como interpretei essas medidas, de 1/boa a 3/ruim, usando o seguinte cf3digo para o SQL Server Management Studio.<\/P><\/P>Os tipos de superfedcie do pavimento se3o os valores codificados HPMS, obviamente.<\/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 style =" font - size : 9 .5 pt ;color :gray ; "> . < / span >< span style =" font - size : 9 .5 pt ;color :black ; "> [PM2_2017]< / span >< / p >< p >< span style =" font - size : 9 .5 pt ;color :black ; ">  ; < / span >< span style =" font - size : 9 .5 pt ;color :blue ; "> set < / span >< span style =" font - size : 9 .5 pt ;color :black ; "> IRI_LEVEL < / span >< span style =" font - size : 9 .5 pt ;color :gray ; "> = < / span >< span style =" font - size : 9 .5 pt ;color :black ; ">1< / span >< / p >< p >< span style =" font - size : 9 .5 pt ;color :black ; ">  ; < / span >< span style =" font - size : 9 .5 pt ;color :blue ; "> where < / span >< span style =" font - size : 9 .5 pt ;color :black ; "> IRI_VN < / span >< span style =" font - size : 9 .5 pt ;color :gray ; "> << / span >< span style =" font - size : 9 .5 pt ;color :black ; ">95 < / span >< / p >< p >< span style =" font - size : 9 .5 pt ;color :black ; "> < / span >< span style =" font - size : 9 .5 pt ;color :gray ; ">AND< / span >< span style =" font - size : 9 .5 pt ;color :black ; "> SURFACE_TYPE_VN < / span >
update [shared].[PM2_2017]
set IRI_LEVEL =2
where IRI_VN >=95 AND IRI_VN <=170</p>
AND SURFACE_TYPE_VN NOT IN (0,1,11);
update [shared].[PM2_2017]
set IRI_LEVEL =3
where IRI_VN >170
AND SURFACE_TYPE_VN NOT IN (0,1,11)
update [shared].[PM2_2017]
set RUTTING_LEVEL =1
where RUTTING_VN <.2
9.5pt; color: black;"> 2
onde RUTTING_VN >= 0.2 e RUTTING_VN <=0.4
E SURFACE_TYPE_VN IN (2, 6, 7, 8)
update [shared].[PM2_2017]
set RUTTING_LEVEL = 3
onde RUTTING_VN >0.4
E SURFACE_TYPE_VN IN onde CRACKING_percent_VN >10
E SURFACE_TYPE_VN EM (5);
update [shared].[PM2_2017]
set CRACKING_LEVEL = 3
onde CRACKING_percent_VN >15
E SURFACE_TYPE_VN EM (10, 3, 4);
& nbsp;& nbsp;& nbsp;& nbsp; update </ span > < spanstyle = " font - size :black "> [ shared ] </ span > < spanstyle = " font - size :gray "> . </ span > < spanstyle = " font - size :black "> [ PM2_2017 ] </ span > </ p > < p > < spanstyle = " font - size :black "> & nbsp;& nbsp;& nbsp;& nbsp; < spanstyle = " font - size :blue "> set </ span > < spanstyle = " font - size :black "> CRACKING_LEVEL </ span > < spanstyle = " font - size :gray "> = </ span > < spanstyle = " font - size :black ">3 </ span > </ p > < p > < spanstyle = " font - size :black "> & nbsp;& nbsp;& nbsp;& nbsp; < spanstyle = " font - size :blue "> onde </ span > < spanstyle = " font - size :black "> CRACKING_percent_VN </ span > < spanstyle = " font - size :gray "> & gt ; </ span > < spanstyle = " font - size :black ">20 </ span > </ p > < p > < spanstyle = " font - size :black "> & nbsp;& nbsp;& nbsp;& nbsp; < spanstyle = " font - size :gray "> E </ span > < spanstyle = " font - size :black "> SURFACE_TYPE_VN </ span > < spanstyle = " font - size :gray "> EM </ span > < spanstyle = " font - size :gray ">( 2,6,7 );
update [shared] . [PM2_2017]
set FAULTING_LEVEL = 1
onde FAULTING_VN < 0,1
e SURFACE_TYPE_VN EM (3,4,10,11)
... 9.5pt; color: blue;">onde
IRI_LEVEL =1 E CRACKING_LEVEL = 1 E (RUTTING_LEVEL = 1 OU FAULTING_LEVEL = 1)
update [shared].[PM2_2017]
set PM_LEVEL = 3
onde (IRI_LEVEL =3 E CRACKING_LEVEL =3)
OU (IRI_LEVEL =3 ERUTTING_LEVEL =3)
& nbsp;& nbsp;& nbsp;& nbsp;& nbsp;& nbsp; OU < /span> ( < /span> IRI_LEVEL < /span> =< /span> 3 < /span> E< /span> FAULTING_LEVEL < /span> =< /span> 3< /span> )< /span> < /p> < span Style =
