|
select * from BMS.BridgeDetails where SurveyYear>=2019 and noofspans =1 order by NoofSpans
|
|
select distinct NoofSpans from BMS.BridgeDetails where SurveyYear>=2019 order by NoofSpans
|
|
select distinct BridgeCode ,Latitude, Longitude, Altitude, bridgeovertopped, SignBoardDamaged, NoofLanes
|
|
, NoofSpans, ArrangementofSpans, OverallBridgelength, DesignLoading, Repairsdonepriortoinventory
|
|
, PCU, ApproachSlabprovided, Length, ApproachRoadTotalWidth, Typeofwearingcoat, OverallDeckwidth
|
|
, Carriagewaywidth, DrainageSpoutsprovided, Noofspouts, WearingCoatThickness, AbutmentwallRailingtype
|
|
, Width, Height, CCofRCCPost, FootpathonBridge, SolidorHallow, FootPathWidthLHS, FootPathWidthRHS
|
|
, KerbonBridge, KerbWidthLHS, KerbWidthRHS, ExpansionJointExists, ExpansionJointsTypes, Remarks
|
|
from BMS.BridgeDetails where SurveyYear>=2019 order by NoofSpans
|
|
|
|
select * from BMS.LocationDetails where SurveyYear>=2019
|
|
select * from BMS.LocationDetails where SurveyYear>=2020
|
|
select distinct SurveyYear, RoadCode, BridgeID, Chainage, Direction, CDNumber, BridgeNameNo, NameofRiverNallah
|
|
, FunctionofBridge, TypeoftheBridge, YearofConstruction, Nameofnearbyplace, DateofInspection
|
|
, ContractorFirm, SupervisedConsultant, DesignConsultant, State, District, Remarks
|
|
from BMS.LocationDetails where SurveyYear>=2019
|
|
AND BridgeID IN (
|
|
'BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900',
|
|
'BD:SH005:0012.157','BI:MDR_PND08_003:0002.200','BD:SH015A:0026.696','BD:SH015A:0031.248','BI:MDR_PND02_003:0006.700','BD:SH063B:0043.886',
|
|
'BI:MDR_PND17_009:0006.350','BI:SH006:0003.255','BI:ODR_RBD08_003:0001.900','BI:ODR_RBD08_003:0003.720','BI:ODR_PND03_001:0004.530',
|
|
'BI:MDR_RBD22_007:0016.645','BI:MDR_RBD22_007:0015.905','BI:ODR_PND20_003:0000.150','BI:SH320:0010.250','BI:MDR_RBD22_007:0009.875',
|
|
'BI:MDR_PND12_002:0000.450','BI:MDR_RBD01_004:0003.100','BI:MDR_PND08_001:0005.400','BI:MDR_PND02_007:0000.610','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.DeckSurfaceCondition
|
|
select * from BMS.DeckSurfaceCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.DeckSurfaceCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, DeckSurfaceMaterialType, DeckSurfaceCrackingType, CrackingCond, AreaofFineCracking
|
|
, AreaofWideCracking, areaofsurfacecrack, Potholes, Ravelling, totalareaofdepression, CorrugationsRipples, Spalling
|
|
, ReinforcementExposed, PoorConcrete, FootpathType, NatureOfDamage, totalnumberofductsblocked, FootpathDamagedPortion
|
|
, percentageoffootpathdamaged, pondingofwater, SurfaceConditionSeverity, SurfaceConditionExtent, Remarks
|
|
from BMS.DeckSurfaceCondition --where SurveyYear>=2019
|
|
where BridgeCode IN (
|
|
'BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900')
|
|
--'BD:SH005:0012.157','BI:MDR_PND08_003:0002.200','BD:SH015A:0026.696','BD:SH015A:0031.248','BI:MDR_PND02_003:0006.700'
|
|
--,'BD:SH063B:0043.886','BI:MDR_PND17_009:0006.350','BI:SH006:0003.255','BI:ODR_RBD08_003:0001.900','BI:ODR_RBD08_003:0003.720'
|
|
--,'BI:ODR_PND03_001:0004.530','BI:MDR_RBD22_007:0016.645','BI:MDR_RBD22_007:0015.905',
|
|
--'BI:SH320:0010.250','BI:MDR_RBD22_007:0009.875','BI:MDR_PND12_002:0000.450','BI:MDR_PND02_007:0000.610'
|
|
--) and SpanNo>=20
|
|
|
|
select distinct SurveyYear from BMS.BearingCondition
|
|
select * from BMS.BearingCondition where SurveyYear>=2019
|
|
select distinct BridgeCode, AbutPierNo, BearingType, Cleanliness, Greasing, LossofShape, Others, Rusting
|
|
, Compressionbulgingofsides, SurfaceCracking, RadialCrackinginthebulges, ExcessiveShearDeformation
|
|
, cracksatpedestal, Typeofcracks, WidthofCrack, NumberofCracks, AnchorBoltsDamaged, Numberoflocationswherenutsareloose
|
|
, Nutsmissinglocationno, Freemovementofthebearing, Bearingsinproperposition, Natureofcrackinseismicrestrainer, Cracksintheseismicrestrainer
|
|
, SpallingDelaminationofConcrete, ExposedCorrodedreinforcement, Anypartbroken, DislodgementMovementBuckling, PaintDamage, RustingofSteel
|
|
, LoosenutsBoltsCrackedweldetc, ElementinspectedbutnotMeasured, BearingConditionSeverity, BearingConditionExtent, Remarks
|
|
from BMS.BearingCondition where BridgeCode IN (
|
|
'BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900',
|
|
'BD:SH005:0012.157','BI:MDR_PND08_003:0002.200','BD:SH015A:0026.696','BD:SH015A:0031.248','BI:MDR_PND02_003:0006.700','BD:SH063B:0043.886',
|
|
'BI:MDR_PND17_009:0006.350','BI:SH006:0003.255','BI:ODR_RBD08_003:0001.900','BI:ODR_RBD08_003:0003.720','BI:ODR_PND03_001:0004.530',
|
|
'BI:MDR_RBD22_007:0016.645','BI:MDR_RBD22_007:0015.905','BI:ODR_PND20_003:0000.150','BI:SH320:0010.250','BI:MDR_RBD22_007:0009.875',
|
|
'BI:MDR_PND12_002:0000.450','BI:MDR_RBD01_004:0003.100','BI:MDR_PND08_001:0005.400','BI:MDR_PND02_007:0000.610','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.DrainSpoutCondition
|
|
select * from BMS.DrainSpoutCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.DrainSpoutCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, NoofspoutsfilledwithdebrisNum, CorrosionofGrills, NospoutswithoutgrillsNum, PropercrossslopeinSuperStructure
|
|
, OrientationofDrainagepipe, PipeMaterial, LeachingSpallingNearPipe, noofspoutsendedatsoffit, Noofspoutpipesmissing, Pipeprojectionbelowsoffit
|
|
, collectionpitatdrainage, Remarks from BMS.DrainSpoutCondition
|
|
where BridgeCode IN (
|
|
'BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900',
|
|
'BD:SH005:0012.157','BI:MDR_PND08_003:0002.200','BD:SH015A:0026.696','BD:SH015A:0031.248','BI:MDR_PND02_003:0006.700','BD:SH063B:0043.886',
|
|
'BI:MDR_PND17_009:0006.350','BI:SH006:0003.255','BI:ODR_RBD08_003:0001.900','BI:ODR_RBD08_003:0003.720','BI:ODR_PND03_001:0004.530',
|
|
'BI:MDR_RBD22_007:0016.645','BI:MDR_RBD22_007:0015.905','BI:ODR_PND20_003:0000.150','BI:SH320:0010.250','BI:MDR_RBD22_007:0009.875',
|
|
'BI:MDR_PND12_002:0000.450','BI:MDR_RBD01_004:0003.100','BI:MDR_PND08_001:0005.400','BI:MDR_PND02_007:0000.610','BI:MDR_PND01_001:0000.123')
|
|
|
|
------------------------------------------------------------------------------------------------------------------
|
|
select distinct SurveyYear from BMS.DeckSurfaceCondition
|
|
select * from BMS.DeckSurfaceCondition where SurveyYear>=2019
|
|
select distinct BridgeCode, SpanNo, DeckSurfaceMaterialType, DeckSurfaceCrackingType, CrackingCond, AreaofFineCracking
|
|
, AreaofWideCracking, areaofsurfacecrack, Potholes, Ravelling, totalareaofdepression, CorrugationsRipples, Spalling
|
|
, ReinforcementExposed, PoorConcrete, FootpathType, NatureOfDamage, totalnumberofductsblocked, FootpathDamagedPortion
|
|
, percentageoffootpathdamaged, pondingofwater, SurfaceConditionSeverity, SurfaceConditionExtent, Remarks
|
|
from BMS.DeckSurfaceCondition
|
|
where BridgeCode IN (
|
|
'BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.BearingCondition
|
|
select * from BMS.BearingCondition where SurveyYear>=2019
|
|
select distinct BridgeCode, AbutPierNo, BearingType, Cleanliness, Greasing, LossofShape, Others, Rusting
|
|
, Compressionbulgingofsides, SurfaceCracking, RadialCrackinginthebulges, ExcessiveShearDeformation
|
|
, cracksatpedestal, Typeofcracks, WidthofCrack, NumberofCracks, AnchorBoltsDamaged, Numberoflocationswherenutsareloose
|
|
, Nutsmissinglocationno, Freemovementofthebearing, Bearingsinproperposition, Natureofcrackinseismicrestrainer, Cracksintheseismicrestrainer
|
|
, SpallingDelaminationofConcrete, ExposedCorrodedreinforcement, Anypartbroken, DislodgementMovementBuckling, PaintDamage, RustingofSteel
|
|
, LoosenutsBoltsCrackedweldetc, ElementinspectedbutnotMeasured, BearingConditionSeverity, BearingConditionExtent, Remarks
|
|
from BMS.BearingCondition
|
|
where BridgeCode IN (
|
|
'BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.DrainSpoutCondition
|
|
select * from BMS.DrainSpoutCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.DrainSpoutCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, NoofspoutsfilledwithdebrisNum, CorrosionofGrills, NospoutswithoutgrillsNum, PropercrossslopeinSuperStructure
|
|
, OrientationofDrainagepipe, PipeMaterial, LeachingSpallingNearPipe, noofspoutsendedatsoffit, Noofspoutpipesmissing, Pipeprojectionbelowsoffit
|
|
, collectionpitatdrainage, Remarks from BMS.DrainSpoutCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.JointCondition
|
|
select * from BMS.JointCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.JointCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentPierNumber, ExpansionJointType, Concretedamageatexpansionjoint, Damageorcorrosiontometalparts
|
|
, Damagetorubberwaterseals, LooseorDamagedfixtures, Signsofleakageunderneaththedeck, DebrisorVegetationinjoint, CheckforProperVerticalAlignment
|
|
, soundatexpjoint, JointConditionSeverity, JointConditionExtent, Remarks
|
|
from BMS.JointCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.FoundationCondition
|
|
select * from BMS.FoundationCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.FoundationCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentPierNumber, FoundationMaterialType, FoundationScourobserved, ScourDepth, FoundationSettlementisobserved
|
|
, settlementobserved, Cracking, Spalling, NoOfbarsexposedNum, Corrosionofreinforcement, Bulging, PoorPointing, DeteriorationofBricksorStones
|
|
, damagedbedprotection, damageduetoflotingbodies, Probleamduetooverloading, LocationOfCracksConcrete, NatureofCracksConcrete, WidthofcracksConcrete
|
|
, LengthofCracksConcrete, PercentageOfVisualSurfaceCracked, NumberofspallsLocationConcrete, TotalAreaOfSpallingConcrete, Depthofspallingconcrete
|
|
, PercentageofCorrosion, ElementInspectedbutnotmeasured, AbutmentFoundationConditionExtent, AbutmentFoundationConditionSeverity
|
|
, PierFoundationConditionExtent, PierFoundationConditionSeverity, Remarks
|
|
from BMS.FoundationCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.ProtectionWorksCondition
|
|
select * from BMS.ProtectionWorksCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.ProtectionWorksCondition order by SpanNo
|
|
select distinct BridgeCode, ApproachesSideslopesintact, Guardrailstoneprovided, ApproachesRaincutsavailable, ApproachesPitchingdamaged
|
|
, DamagedboulderapronpitchingArea, NoticeablescourIfAny, DamagedToewallLength, Damagedflooringarea, Damagedboulderapronarea, Noticeablescour
|
|
, DamagedcutoffwallLength, Duetoleakageordamage, Debriesatabutmentandpier, Remainsofoldbridge, gestructureunderbridge, vegetationonapproach
|
|
, WorksConditionSeverity, WorksConditionExtent, Remarks
|
|
from BMS.ProtectionWorksCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.RailingCondition
|
|
select * from BMS.RailingCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.RailingCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, RailingType, Damagetoouter, Looseordamagedfixings, DeteriarationofpaintSqm, NumberofpipesmissingNum
|
|
, Totallengthofmissingpipes, NumberofpostsmissingNum, Cracks, DetailsofDamagedRailing, DamagedCrashBarrier, Spalling, LengthRequiredtotalreplacement
|
|
, RailingConditionSeverity, RailingConditionExtent, Remarks
|
|
from BMS.RailingCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.AbutmentCondition
|
|
select * from BMS.AbutmentCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.RailingCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentNo, AbutmentCapMaterialType, RCCCracking, RCCSpalling, NoofBarsExposedRCC, RCCCorrosionofreinforcement
|
|
, PoorConcrete, vegetationoverthecap, AbutmentMaterialType, MasonryCracking, MasonrySpalling, MasonryBulging, PoorPointing, DeteriorationofBricksorStones
|
|
, NoofBarsExposedMAS, CorrosionofReinforcement, DamagetoRCCPCCcoping, WeepHolesblocked, TotalPercentageofsurfacecracked, DeformationinDirtWall
|
|
, DecscriptionofDamage, Cracksindirtwall, PercentageofSurfacecracked, NumberofspallsLocation, Impactduetofloatingbodies, LocationofCracks
|
|
, Natureofcracks, Widthofcracks, EleInsptdbutnotmesrd, AbutmentConditionSeverity, AbutmentConditionExtent, Remarks
|
|
from BMS.AbutmentCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.PierCondition
|
|
select * from BMS.PierCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.PierCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentPierNumber, PierCapMaterialType, RCCCracking, RCCSpalling, RCCNoofbarsexposed, RCCCorrosionofreinforcement
|
|
, PoorConcrete, Vegetationoverthecap, TotalPercentageofsurfacecracked, PierMaterialType, MasonryNoofbarsexposed, MasonryCracking, MasonryBulging
|
|
, PoorPointing, DeteriorationofBricksorStones, DamagetoRCCPCCcoping, WeepHolesblocked, Numberlocationofloosejoints, lossofjointmaterialiden
|
|
, shiftedstonesorbr, plasterovermasonryAbutment, crackingdamaged, DetailofvegetationgrowthatJoints, Impactduetofloatingbodies, lossofjointmaterial
|
|
, Conditionofplasterovermasonrypier, NumberLocationoflooseorshiftedstones, PierConditionSeverity, PierConditionExtent, Remarks
|
|
from BMS.PierCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.WallCondition
|
|
select * from BMS.WallCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.WallCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentPierNumber, Side, WallMaterialType, Cracking, BulgingSqm, PoorPointing, DeteriorationofBricksorStones
|
|
, DamagetoRCCPCCcopingCum, WeepHolesblockedNum, IsVegetationfromthewall, LocationofCracks, NatureofCracks, WidthofCrack, Lengthofcrack
|
|
, PercentageofVisualSurfaceCracked, NumberofspallsLocation, Totalareaofspalling, DeteriorationandCorrosion, PartialCollapseofWingwall
|
|
, PercentageofCorrosion, Settlementmovem, NumberandLocationofloosejoints, Numberofjointlost, Locationoflooseorshiftedstones, ConditionofPlasteronwingwallreturn
|
|
, NoofsplitCracking, DetailOfVegetationgrowthatjoints, WallConditionSeverity, WallConditionExtent, Remarks
|
|
from BMS.WallCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.GirderCondition
|
|
select * from BMS.GirderCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.GirderCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, Typeofcracks, Lengthofcrack, NumberofcracksNum, widthofcracks, Locationofcracks, Spalling
|
|
, NoOfbarsexposedNum, Corrosionofreinforcement, PoorConcrete, DeflectionVisible, conditionofconnections, conditionofpaintings
|
|
, conditionofsteelnumbers, AnchorForCrossPreStressing, NoOfanchordamagedinspan, DegreeofCorrosionatAnchorage, DescofDmgofDucts
|
|
, NumberofLooseStrands, NoOfstrandsatanchorage, Inspectedbutnotmeasured, SpallsinaSpan, NumberOfSpallLocation, numberofBarsExposedandCorroded
|
|
, PercentageOfCorrosion, Floreseffectedlocationno, GirderConditionSeverity, GirderConditionExtent, Remarks
|
|
from BMS.GirderCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.DeckSlabCondition
|
|
select * from BMS.DeckSlabCondition where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.DeckSlabCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, Typeofcracks, Lengthofcrack, Numberofcracks, widthofcracks, Locationofcracks, NumberofSpalls
|
|
, Spalling, DepthOfEachSpall, Noofbarsexposed, Corrosionofreinforcement, PercentageofCorrosion, PitCorrosion
|
|
, Locationofcorrosionofreinforcement, PoorConcrete, Floreseffectedlocationno, DeflectionVisible, Excessivevibrationisobserved
|
|
, ConditionofConnections, ConditionofPainting, ConditionofSteelMembers, hitslabbyhammer, pondingofwater, locationsofspotswhereconcretediscoloured
|
|
, AnchorForCrossPreStressing, NumberofDamagedAnchorinaSpan, DescriptionofDamage, DegreeofCorrosionoftheAnchorageend, DescriptionofDamageofDucts
|
|
, NumberofLooseStrands, TotalNumberofStrandsateachAnchorage, ElementinspectedbutnotMeasured, VerticalDeflectionofContilevertip
|
|
, ModerateDeflection, ExcessiveDeflection, ConditionofJointBetweenDeckSlabandGirders, dripcourseatedgofslab, SlabConditionSeverity, SlabconditionExtent, Remarks
|
|
from BMS.DeckSlabCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyID from BMS.CrossGirderCondition
|
|
select * from BMS.CrossGirderCondition where SurveyID>=2019
|
|
select distinct SpanNo from BMS.CrossGirderCondition order by SpanNo
|
|
select distinct BridgeCode, SpanNo, TypeofCracks, LengthofCrack, Noofcracks, widthofcracks, Locationofcracks, Spalling, NoofBarsExposed
|
|
, CorrosionofReinforcement, LocationofCorrosion, PoorConcrete, ConditionofConnections, ConditionofPaintings, ConditionofSteelNumbers, Remarks
|
|
from BMS.CrossGirderCondition
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.ApproachProtectionInventory
|
|
select * from BMS.ApproachProtectionInventory where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.ApproachProtectionInventory order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentNumber, Side, WallType, MaterialType, ApproachProtectionWallType, ApprProtnLngofWall, ApprProtnHtofWall, [location], Remarks
|
|
from BMS.ApproachProtectionInventory
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.HydraulicDetails
|
|
select * from BMS.HydraulicDetails where SurveyYear>=2019
|
|
select distinct BridgeCode, TypeofBedMaterial, IstheStreamerodable, SkewAngle, ToplevelofdeckRL, SoffitRLofdeck, HFL
|
|
, Clearventsize, Clearverticaldistance, MinimumRLofbed, DesignVelocity, DesignDischarge, DesignScourLevelatmiddleRL
|
|
, Catchmentarea, BridgeGradient, BridgeCategory, StreamCategory, Whetherlocatedinbackwaterschemicalzone
|
|
, Crossingtherivertype, Isthereanysignboardoverthebridge, Isthereanyservicecrossingtheriverthroughth, LocationofService
|
|
, Servicelineatonesideorbothsideofbridge, Defectsinservicelines, leakagefromserviceline, Markingofpierlocations
|
|
, Typeofpierprotection, MarkingofAbutmentlocations, DateofInventory, Remarks, Typeofabutprotection
|
|
from BMS.HydraulicDetails
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.SuperStructureDetails
|
|
select * from BMS.SuperStructureDetails where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.SuperStructureDetails order by SpanNo
|
|
select distinct BridgeCode, SpanNo, Typeofsuperstructure, DeckSlab, DeckSlabThicknessM, LongitudinalGirdersNos
|
|
, LongitudinalGirdersSpacingM, LongitudinalGirdersDepthM, LongitudinalGirdersWidthM, CrossGirdersNos, Crsgirdmonolthkwtdkslb
|
|
, Numberofarchineachspan, CentretoCentreSpacingofArchM, ArchDepthofspandrelatsupportM, ArchDepthofspandrelatCrownM
|
|
, SteelMembersConnectionType, DateofInventory, Dimsteelmem, Material, DeckslabtransversallyPrestressed, Remarks, StructuralSystem
|
|
from BMS.SuperStructureDetails
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.AbutmentDetails
|
|
select * from BMS.AbutmentDetails where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.AbutmentDetails order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentNo, AbutmentType, AbutmentMaterial, NumberofColumns, Thicknesstop, Thicknessbottom
|
|
, Height, TotalWidthofAbutment, Lengthofcap, Widthofcap, Heightofcap, gapbtwdirtwalltosuperstructuremm, DirtWallMaterialType
|
|
, Dirtwallthickness, Dirtwallheight, AbutmentWallType, AbutmentWallMaterialType, AngleofwingwallReturnwall, WallLength
|
|
, AbutmentwallRailingtype, AbutmentwallRailingMaterialtype, RailingLength, BearingAbutmentType, NoofBearings, Earthquakerestrainerdampenerisprovided, Remarks
|
|
from BMS.AbutmentDetails
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.FoundationAbutmentInventory
|
|
select * from BMS.FoundationAbutmentInventory where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.FoundationAbutmentInventory order by SpanNo
|
|
select distinct BridgeCode, SpanNo, AbutmentNo, FoundationType, WidthofRaft, ThicknessofRaft, LengthofRaft, NoofWells, DiaofWell, LengthofDepthofWell, Remarks
|
|
from BMS.FoundationAbutmentInventory
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.PierDetails
|
|
select * from BMS.PierDetails where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.PierDetails order by SpanNo
|
|
select distinct BridgeCode, SpanNo, PierNo, PierType, PierMaterial, ThicknesstopM, ThicknessbottomM, LengthattopM, LengthatbottomM
|
|
, HeightM, NoofColumns, DiaOfColumnsM, SpacingofColumnsM, HeightofColumnM, UniformheightofcapM, WidthofcapM, TaperedheightofcapM
|
|
, LengthofcapM, Cuteasewaterisprovided, CutEaseWaterType, CutEaseWaterThicknessM, BearingPier, NoOfBearings, erthquakrestrindampnsprovd, Remarks
|
|
from BMS.PierDetails
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.FoundationPierInventory
|
|
select * from BMS.FoundationPierInventory where SurveyYear>=2019
|
|
select distinct SpanNo from BMS.FoundationPierInventory order by SpanNo
|
|
select distinct BridgeCode, SpanNo, PierNo, FoundationType, WidthofRaft, ThicknessofRaft, LengthofRaft, NoofWells, DiaofWell, LengthofWell, Remarks
|
|
from BMS.FoundationPierInventory
|
|
where BridgeCode IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|
|
|
|
select distinct SurveyYear from BMS.CulvertInventory
|
|
select * from BMS.CulvertInventory where SurveyYear>=2019
|
|
select distinct RoadCode, CulvertCode, Chainage, Direction, Latitude, Longitude, CDNumber, StructureType, NoofSpans
|
|
, SpanWidth, SpanHeight, ClearRoadWidth, TotalCulvertWidth, Fill, DeckSlabThickness, HeadWallType
|
|
, HeadWallLength, HeadWallThickness, ProtectionUS, ProtectionDS, FlowDirection, ToeWallType, NoofPipesorVents, PipeDiameter, WingWall, SurveyDate
|
|
from BMS.CulvertInventory
|
|
|
|
select distinct SurveyYear from BMS.CulvertCondition
|
|
select * from BMS.CulvertCondition where SurveyYear>=2019
|
|
select distinct CulvertCode, ConditionofDeckSlab, ConditionofHeadWall, ConditionofReturnWall, ConditionofParapet, VegetationUS
|
|
, VegetationDS, Choked, ScourUS, ScourDS, WaterWayAdequacy, ConditionofPipe, ConditionofWingWall, Remarks
|
|
from BMS.CulvertCondition where CulvertCode in (
|
|
'CI:MDR_PND01_001:0000.300',
|
|
'CI:MDR_PND01_001:0000.400',
|
|
'CI:MDR_PND01_001:0000.400',
|
|
'CI:MDR_PND01_001:0000.450',
|
|
'CI:MDR_PND01_001:0000.600',
|
|
'CI:MDR_PND01_001:0000.800',
|
|
'CI:MDR_PND01_001:0000.900',
|
|
'CI:MDR_PND01_001:0001.000',
|
|
'CI:MDR_PND01_001:0001.100',
|
|
'CI:MDR_PND01_001:0001.300'
|
|
)
|
|
|
|
select distinct SurveyYear from BMS.LocationDetails
|
|
select * from BMS.LocationDetails where SurveyYear>=2019
|
|
select distinct RoadCode, BridgeID, Chainage, Direction, CDNumber, BridgeNameNo, NameofRiverNallah, FunctionofBridge
|
|
, TypeoftheBridge, YearofConstruction, Nameofnearbyplace, DateofInspection, ContractorFirm, SupervisedConsultant, DesignConsultant, State, District, Remarks
|
|
from BMS.LocationDetails where BridgeID IN ('BD:SH014:0072.623','BD:SH006A:0029.448','BD:SH015A:0039.398','BD:ODR_RBD06_002:0002.891','BI:MDR_PND02_003:0006.900','BI:MDR_PND01_001:0000.123')
|