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')