<\/HEAD>
Dit is hoe KDOT de PM2 Pavement Condition samenvattingsgegevens leverde uit de gegevens die zijn geëxtraheerd uit ons HPMS Dashboard voor gebruik door onze MPO's. <\/P>
<\/P>
hier zijn de drempelwaarden:<\/P>
<\/P>
<\/P>
<\/P>
Voeg dan deze wending toe:<\/P>
Voor het tiende mijlsegment om gb7good te zijn, moeten alle drie de metingen gb7good zijn. Als er twee pb7poor zijn, dan is het geheel pb7poor. <\/SPAN><\/P><\/P>Dus, eerst voeg ik velden toe voor de maat "LEVEL", en hier is hoe ik deze maten interpreteerde, van 1gb7good tot 3pb7poor, met behulp van de volgende code voor SQL Server management studio.<\/P><\/P>De wegdektype zijn uiteraard de HPMS gecodeerde waarden.<\/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<\ /span ><\ p >  ; <\ /span >where<\ /span > IRI_VN <\ /span ><<\ /span >95 <\ /span ><\ p > <\ /span >AND<\ /span > SURFACE_TYPE_VN <\ /span >NOT<\ /span> < spanstyle = " font - size :9 .5 pt;color :gray ;" >IN<\ / span > < spanstyle = " font - size :9 .5 pt;color :gray ;" >(</ span > < spanstyle = " font - size :9 .5 pt;color :black ;" >0</ span > < spanstyle = " font - size :9 .5 pt;color :gray ;" >,</ span > < spanstyle = " font - size :9 .5 pt;color :black ;" >1</ span > < spanstyle = " font - size :9 .5 pt;color :gray ;" >,</ span > < spanstyle = " font - size :9 .5 pt;color :black ;" >11</ span > < spanstyle = " font - size :9 .5 pt;color :gray ;" >)</ span ><\ p > <\ /span ><\ p >update<\ /span > [shared]<\ /span >.<\ /span >
[PM2_2017]
</p>
</p> 9.5pt; kleur: zwart;"> 2
waar RUTTING_VN >= 0.2 en RUTTING_VN <=0.4
EN SURFACE_TYPE_VN IN (2, 6, 7, 8)
update [shared].[PM2_2017]
stel in RUTTING_LEVEL = 3
waar RUTTING_VN >0.4
EN SURFACE_TYPE_VN IN (2,6,7,8)
update [shared].[PM2_2017]
stel in CRACKING_LEVEL =1
update [shared].[PM2_2017]
stel in CRACKING_LEVEL =2
waar < spanstijl= 9.5pt; kleur: blauw;">waar<\/SPAN>
CRACKING_percent_VN <\/SPAN>><\/SPAN>10 <\/SPAN><\/P> <\/SPAN>EN<\/SPAN> SURFACE_TYPE_VN <\/SPAN>IN<\/SPAN> (<\/SPAN>5<\/SPAN>);<\/SPAN><\/P> <\/SPAN><\/P> <\/SPAN>update<\/SPAN> [shared]<\/SPAN>.<\/SPAN>[PM2_2017]<\/SPAN><\/P> <\/SPAN>set<\/SPAN> CRACKING_LEVEL <\/SPAN>=<\/SPAN> 3<\/SPAN><\/P> <\/SPAN>waar<\/SPAN> CRACKING_percent_VN <\/SPAN>><\/SPAN>15 <\/SPAN><\/P> <\/SPAN>EN<\/SPAN> SURFACE_TYPE_VN <\/SPAN>IN<\/SPAN> (<\/SPAN>10<\/SPAN>,<\/SPAN> 3<\/SPAN>,<\/SPAN> 4<\/SPAN>);<\/SPAN><\/P> <\/SPAN><\/P> <\/SPAN>update<\/span > [shared]< / span >< spanstyle= " font - size : 9 . 5 pt ; color : gray ; "> . < / span >< spanstyle= " font - size : 9 . 5 pt ; color : black ; "> [PM2_2017]< / span >< / p >< p >< spanstyle= " font - size : 9 . 5 pt ; color : black ; ">& nbsp ; < / span >< spanstyle= " font - size : 9 . 5 pt ; color : blue ; "> set < / span >< spanstyle= " font - size : 9 . 5 pt ; color : black ; "> CRACKING_LEVEL < / span >< spanstyle= " font - size : 9 . 5 pt ; color : gray ; "> = < / span >< spanstyle= " font - size : 9 . 5 pt ; color : black ; ">3< / span >< / p >< p >< spanstyle= " font - size : 9 . 5 pt ; color : black ; ">& nbsp ; < / span >< spanstyle= " font - size : 9 . 5 pt ; color : blue ; "> waar < / span >< spanstyle= " font - size : 9 . 5 pt ; color : black ; "> CRACKING_percent_VN < / span >< spanstyle= " font - size : 9 . 5 pt ; color : gray ; "> & gt ; < / span >< spanstyle= " font - size : 9 . 5 pt ; color : black ; ">20< / span >< / p >< p >< spanstyle= " font - size : 9 . 5 pt ; color : black ; ">& nbsp;& nbsp;< / span >< spanstyle= " font - size : " > EN waar<\/SPAN> IRI_LEVEL <\/SPAN>=<\/SPAN>1 <\/SPAN>EN<\/SPAN> CRACKING_LEVEL <\/SPAN>=<\/SPAN> 1 <\/SPAN>EN<\/SPAN> (<\/SPAN>RUTTING_LEVEL <\/SPAN>=<\/SPAN> 1 <\/SPAN>OF<\/SPAN> FAULTING_LEVEL <\/SPAN>=<\/SPAN> 1<\/SPAN>)<\/SPAN><\/P> <\/SPAN><\/P> <\/SPAN>update<\/SPAN> [shared]<\/SPAN>.<\/SPAN>[PM2_2017]<\/SPAN><\/P> <\/SPAN>set<\/SPAN> PM_LEVEL <\/SPAN>=<\/SPAN> 3<\/SPAN><\/P> <\/SPAN>waar <\/SPAN>(<\/SPAN>IRI_LEVEL <\/SPAN>=<\/SPAN>3 <\/SPAN>EN<\/SPAN> CRACKING_LEVEL <\/SPAN>=<\/SPA...
