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