<\/HEAD>
Así es como KDOT entregó el resumen de datos de la Condición del Pavimento PM2 extraídos de nuestro Panel HPMS para uso de nuestros MPOs. <\/P>
<\/P>
aquí están los valores umbral:<\/P>
<\/P>
<\/P>
<\/P>
Luego, añade este giro:<\/P>
Para que el segmento de décima milla sea bueno, las tres medidas deben ser buenas. Si dos son malas entonces en general es malo. <\/SPAN><\/P><\/P>Entonces, primero agrego campos para la medida "LEVEL", y así es como interprete9 estas medidas, de 1bueno a 3malo, usando el siguiente cf3digo para SQL Server management studio.<\/P><\/P>Los tipos de superficie del pavimento son los 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>[PM2_2017]<\/SPAN><\/P> <\/SPAN>set<\/SPAN> IRI_LEVEL <\/> = <\/>1<\/> </\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/><\/>where IRI_VN <<\/>95 <\/>AND SURFACE_TYPE_VN NOT IN (0,1,11)<\/> <\/>update [shared].[PM2_2017]<\/> set IRI_LEVEL =2 where IRI_VN >= ;95 and IRI_VN <= ;170 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 < ;0 .2 AND SURFACE_TYPE_VN IN (2,6,7,8); update [shared].[PM2_2017] set RUTTING_LEVEL = ... 9.5pt; color: black;"> 2
donde RUTTING_VN >= 0.2 y RUTTING_VN <=0.4
Y SURFACE_TYPE_VN EN (2, 6, 7, 8)
update [shared].[PM2_2017]
set RUTTING_LEVEL = 3
donde RUTTING_VN >0.4
& nbsp ; < / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray "> Y < / span > < spanstyle = " font - size : 9 . 5 pt ;color :black "> SURFACE_TYPE_VN < / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray "> EN < / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray ">( < / span > < spanstyle = " font - size : 9 . 5 pt ;color :black ">2< / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray ">, < / span > < spanstyle = " font - size : 9 . 5 pt ;color :black ">6< / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray ">, < / span > < spanstyle = " font - size : 9 . 5 pt ;color :black ">7< / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray ">, < / span > < spanstyle = " font - size : 9 . 5 pt ;color :black ">8< / span > < spanstyle = " font - size : 9 . 5 pt ;color :gray ">) < / span > < / p > < p > < spanstyle = " font - size : fuchsia ;color:black "> update < / span > < spanstyle = " font - size : black ;color:black "> [ shared ]< / span > < spanstyle = " font - size : gray ;color:black ">.< / span > < spanstyle = " font - size : black ;color:black ">[ PM2_2017 ]< / span > < / p > < p > < spanstyle = " font - size : blue ;color:black "> set < / span > < spanstyle = " font - size : black ;color:black "> CRACKING_LEVEL ... (truncated for brevity) ... 9.5pt; color: blue;">donde CRACKING_percent_VN >10
AND SURFACE_TYPE_VN IN (5);
update [shared].[PM2_2017]
set CRACKING_LEVEL = 3
where CRACKING_percent_VN >15
AND SURFACE_TYPE_VN IN (10, 3, 4);
update [shared].[PM2_2017]
set CRACKING_LEVEL = 3
where CRACKING_percent_VN > 20
AND SURFACE_TYPE_VN IN ( 2,6,7 );
update [shared]. [PM2_2017]
set FAULTING_LEVEL = 1
where FAULTING_VN <0.1
and SURFACE_TYPE_VN IN (3,4,10,11)
update [shared].[PM2_2017]
set FAULTING_LEVEL = 2
where FAULTING_VN >=0.1
AND FAULTING_VN <=0.15
AND SURFACE_TYPE_VN IN (3,4,10,11)
update< /sp an > [shared].[PM2_2017]
& nbsp ;< spanclass= 'blue '>set< /sp an > FAULTING_LEVEL = < spanclass= 'black '>3< /sp an >
& nbsp ;< spanclass= 'blue '>where< /sp an > FAULTING_VN & gt ;0 .15< /p >
& nbsp ;< spanclass= 'gray '>AND< /sp an > SURFACE_TYPE_VN IN (3 ,4 ,10 ,11 )< /p >
& nbsp ;< /p >
& nbsp ;< spanclass= 'fuchsia '>update< /sp an > [shared].[PM2_2017]
& nbsp ;< spanclass= 'blue '>set< /sp an > PM_LEVEL = < spanclass= 'black '>1< /sp an >
& nbsp;& nbsp;& nbsp; 9.5pt; color: blue;">donde IRI_LEVEL =1 Y CRACKING_LEVEL = 1 Y (RUTTING_LEVEL = 1 O FAULTING_LEVEL = 1)
update [shared].[PM2_2017]
set PM_LEVEL = 3
donde (IRI_LEVEL =3 Y CRACKING_LEVEL =3<spanstyle =" font - size :
