db = {
    "AbutmentDesign": [
      {
          "Code": "CONTECH",
          "Desc": "By CONTECH"
      },
      {
          "Code": "Others",
          "Desc": "By Others"
      }
   ],
    "AbutmentType": [
      {
          "Code": "CIP",
          "Desc": "Cast in Place"
      },
      {
          "Code": "Precast",
          "Desc": "Precast"
      },
      {
          "Code": "Other",
          "Desc": "Other"
      }
   ],
    "AccountType": [
      {
          "Code": "Engineer",
          "Desc": "Engineer"
      },
      {
          "Code": "Contractor",
          "Desc": "Contractor"
      },
      {
          "Code": "Agency",
          "Desc": "Agency"
      },
      {
          "Code": "Owner",
          "Desc": "Owner"
      },
      {
          "Code": "Architect",
          "Desc": "Architect"
      },
      {
          "Code": "BusinessPartner",
          "Desc": "Business Partner"
      },
      {
          "Code": "Other",
          "Desc": "Other"
      }
   ],
    "Application": [
      {
          "Code": "Pedestrian_TrailBridge",
          "Desc": "Trail Bridge",
          "IsDefault": false,
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_PipeSupport",
          "Desc": "Pipe Support",
          "IsDefault": false,
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_Overpass",
          "Desc": "Overpass",
          "IsDefault": false,
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_BuildingSkywalk",
          "Desc": "Building Skywalk",
          "IsDefault": false,
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_MezzanineCatwalk",
          "Desc": "Mezzanine/Catwalk",
          "IsDefault": false,
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_Other",
          "Desc": "Other",
          "IsDefault": false,
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Vehicular_Vehicular",
          "Desc": "Vehicular",
          "IsDefault": true,
          "BridgeTypeCode": "Vehicular"
      }
   ],
    "BridgeFinish": [
      {
          "Code": "WeatheringSteel",
          "Desc": "Weathering Steel"
      },
      {
          "Code": "Painted",
          "Desc": "Painted"
      }
   ],
    "BridgeFinishColor": [
      {
          "Code": "Painted_ClayTan",
          "Desc": "Clay Tan",
          "BridgeFinishCode": "Painted"
      },
      {
          "Code": "Painted_Red",
          "Desc": "Red",
          "BridgeFinishCode": "Painted"
      },
      {
          "Code": "Painted_HunterGreen",
          "Desc": "Hunter Green",
          "BridgeFinishCode": "Painted"
      },
      {
          "Code": "Painted_Black",
          "Desc": "Black",
          "BridgeFinishCode": "Painted"
      },
      {
          "Code": "Painted_WarmBrown",
          "Desc": "Warm Brown",
          "BridgeFinishCode": "Painted"
      },
      {
          "Code": "Painted_CobaltBlue",
          "Desc": "Cobalt Blue",
          "BridgeFinishCode": "Painted"
      }
   ],
    "BridgeSpan": [
      {
          "Min": 20,
          "Max": 200,
          "BridgeStyleCode": "Pedestrian_Connector"
      },
      {
          "Min": 20,
          "Max": 200,
          "BridgeStyleCode": "Pedestrian_Link"
      },
      {
          "Min": 20,
          "Max": 200,
          "BridgeStyleCode": "Pedestrian_Capstone"
      },
      {
          "Min": 20,
          "Max": 200,
          "BridgeStyleCode": "Pedestrian_Keystone"
      },
      {
          "Min": 20,
          "Max": 200,
          "BridgeStyleCode": "Pedestrian_Gateway"
      },
      {
          "Min": 50,
          "Max": 150,
          "BridgeStyleCode": "Vehicular_Connector"
      },
      {
          "Min": 50,
          "Max": 150,
          "BridgeStyleCode": "Vehicular_Capstone"
      },
      {
          "Min": 50,
          "Max": 150,
          "BridgeStyleCode": "Vehicular_Keystone"
      },
      {
          "List": "12,18,24,32,36,40,45,50,55,60,65,70,75,80",
          "BridgeStyleCode": "Vehicular_SteelStringer"
      }
   ],
    "BridgeStyle": [
      {
          "Code": "Pedestrian_Connector",
          "Desc": "Connector",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_Link",
          "Desc": "Link",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_Capstone",
          "Desc": "Capstone",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_Keystone",
          "Desc": "Keystone",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_Gateway",
          "Desc": "Gateway",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Vehicular_Capstone",
          "Desc": "Capstone",
          "BridgeTypeCode": "Vehicular"
      },
      {
          "Code": "Vehicular_Connector",
          "Desc": "Connector",
          "BridgeTypeCode": "Vehicular"
      },
      {
          "Code": "Vehicular_Keystone",
          "Desc": "Keystone",
          "BridgeTypeCode": "Vehicular"
      },
      {
          "Code": "Vehicular_SteelStringer",
          "Desc": "Steel Stringer",
          "BridgeTypeCode": "Vehicular"
      }
   ],
      "BridgeWidth": [
      {
          "List": "4,6,8,10,12",
          "BridgeStyleCode": "Pedestrian_Connector"
      },
      {
          "List": "4,6,8,10,12",
          "BridgeStyleCode": "Pedestrian_Link"
      },
      {
          "List": "4,6,8,10,12",
          "BridgeStyleCode": "Pedestrian_Capstone"
      },
      {
          "List": "4,6,8,10,12",
          "BridgeStyleCode": "Pedestrian_Keystone"
      },
      {
          "List": "4,6,8,10,12",
          "BridgeStyleCode": "Pedestrian_Gateway"
      },
      {
          "List": "12,16,20,24,28,32,36,40",
          "BridgeStyleCode": "Vehicular_Connector"
      },
      {
          "List": "12,16,20,24,28,32,36,40",
          "BridgeStyleCode": "Vehicular_Capstone"
      },
      {
          "List": "12,16,20,24,28,32,36,40",
          "BridgeStyleCode": "Vehicular_Keystone"
      },
      {
          "List": "12,16,20,24,28,32,36,40,44,48",
          "BridgeStyleCode": "Vehicular_SteelStringer"
      }
   ],
    "DeckType": [
      {
          "Code": "Pedestrian_Concrete",
          "Desc": "Concrete",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Pedestrian_IPE",
          "Desc": "IPE (Hardwood)",
          "BridgeTypeCode": "Pedestrian"
      },
      {
          "Code": "Vehicular_Concrete",
          "Desc": "Concrete",
          "BridgeTypeCode": "Vehicular"
      }
   ],
    "DesignCode": [
      {
          "Code": "AISC",
          "Desc": "AISC"
      },
      {
          "Code": "AASHTO",
          "Desc": "AASHTO"
      },
      {
          "Code": "CALTRANS",
          "Desc": "CALTRANS"
      }
   ],
    "EndMarket": [
      {
          "Code": "NonBuilding",
          "Desc": "Non-Building"
      },
      {
          "Code": "NonResidential",
          "Desc": "Non-Residential"
      },
      {
          "Code": "Residential",
          "Desc": "Residential"
      },
      {
          "Code": "Unknown",
          "Desc": "Unknown"
      }
   ],
    "EndSubMarket": [
      {
          "Code": "NonBuilding_Airport",
          "Desc": "Airport",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_CountyHighway",
          "Desc": "County- Highway",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_CountyOther",
          "Desc": "County- Other",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_DamsReservoirsRiverDevelopment",
          "Desc": "Dams/Reservoirs/River Development",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_EnergyPowerPlants",
          "Desc": "Energy- Power Plants",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_EnergyTransmission",
          "Desc": "Energy- Transmission",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_EnergyWind",
          "Desc": "Energy- Wind",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_FederalHighway",
          "Desc": "Federal- Highway",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_FederalOther",
          "Desc": "Federal- Other",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_Industrial",
          "Desc": "Industrial",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_Military",
          "Desc": "Military",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_Mining",
          "Desc": "Mining",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_MunicipalHighway",
          "Desc": "Municipal- Highway",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_MunicipalOther",
          "Desc": "Municipal- Other",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_NaturalResourcesTimberForest",
          "Desc": "Natural Resources/Timber/Forest",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_NonpowerUtilititesTelecom",
          "Desc": "Nonpower Utilitites (Telecom)",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_ParksLandscape",
          "Desc": "Parks and Landscape",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_Ports",
          "Desc": "Ports",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_Railroads",
          "Desc": "Railroads",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_SewerageWasteDisposal",
          "Desc": "Sewerage and Waste Disposal",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_StateHighway",
          "Desc": "State- Highway",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_StateOther",
          "Desc": "State- Other",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonBuilding_WaterSupplySystems",
          "Desc": "Water Supply Systems",
          "EndMarketCode": "NonBuilding"
      },
      {
          "Code": "NonResidential_AmusementSocialRecreational",
          "Desc": "Amusement, Social and Recreational",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_GovernmentServiceBuildings",
          "Desc": "Government Service Buildings",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_HospitalsOtherHealthTreatment",
          "Desc": "Hospitals and Other Health Treatment",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_HotelsMotels",
          "Desc": "Hotels and Motels",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_ManufacturingPlantsWarehousesLabs",
          "Desc": "Manufacturing Plants, Warehouses, Labs",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_MixedUseDevelopment",
          "Desc": "Mixed-Use Development",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_OfficeBankBuildings",
          "Desc": "Office and Bank Buildings",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_ParkingGarages",
          "Desc": "Parking Garages",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_ReligiousBuildings",
          "Desc": "Religious Buildings",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_SchoolsLibrariesNonmfgLabs",
          "Desc": "Schools, Libraries and Nonmfg. Labs",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_ShoppingCenters",
          "Desc": "Shopping Centers",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_StoresRestaurants",
          "Desc": "Stores & Restaurants",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "NonResidential_WarehousesExcludesMfgrOwned)",
          "Desc": "Warehouses (excludes Mfgr. Owned)",
          "EndMarketCode": "NonResidential"
      },
      {
          "Code": "Residential_Apartments",
          "Desc": "Apartments",
          "EndMarketCode": "Residential"
      },
      {
          "Code": "Residential_MultiFamilyHouses",
          "Desc": "Multi-Family Houses",
          "EndMarketCode": "Residential"
      },
      {
          "Code": "Residential_SingleFamilyHouses",
          "Desc": "Single-Family Houses",
          "EndMarketCode": "Residential"
      }
   ],
    "Funding": [
      {
          "Code": "Federal",
          "Desc": "Federal"
      },
      {
          "Code": "State",
          "Desc": "State"
      },
      {
          "Code": "County",
          "Desc": "County"
      },
      {
          "Code": "City",
          "Desc": "City"
      },
      {
          "Code": "ISTEAT21",
          "Desc": "ISTEA/T-21"
      },
      {
          "Code": "Private",
          "Desc": "Private"
      },
      {
          "Code": "Other",
          "Desc": "Other"
      }
   ],
    "LifeSafetyRail": [
      {
          "BridgeStyleCode": "Pedestrian_Connector",
          "Code": "Horizontal",
          "Desc": "Horizontal"
      },
      {
          "BridgeStyleCode": "Pedestrian_Connector",
          "Code": "Vertical",
          "Desc": "Vertical"
      },
      {
          "BridgeStyleCode": "Pedestrian_Link",
          "Code": "Horizontal",
          "Desc": "Horizontal"
      },
      {
          "BridgeStyleCode": "Pedestrian_Link",
          "Code": "Vertical",
          "Desc": "Vertical"
      },
      {
          "BridgeStyleCode": "Pedestrian_Capstone",
          "Code": "Horizontal",
          "Desc": "Horizontal"
      },
      {
          "BridgeStyleCode": "Pedestrian_Capstone",
          "Code": "Vertical",
          "Desc": "Vertical"
      },
      {
          "BridgeStyleCode": "Pedestrian_Keystone",
          "Code": "Horizontal",
          "Desc": "Horizontal"
      },
      {
          "BridgeStyleCode": "Pedestrian_Keystone",
          "Code": "Vertical",
          "Desc": "Vertical"
      },
      {
          "BridgeStyleCode": "Pedestrian_Gateway",
          "Code": "Horizontal",
          "Desc": "Horizontal"
      },
      {
          "BridgeStyleCode": "Pedestrian_Gateway",
          "Code": "Vertical",
          "Desc": "Vertical"
      }
   ],
    "MarketingSource": [
      {
          "Code": "BetterRoads",
          "Desc": "Better Roads"
      },
      {
          "Code": "Bridges",
          "Desc": "Bridges"
      },
      {
          "Code": "CENews",
          "Desc": "CE News"
      },
      {
          "Code": "CivilEngineering",
          "Desc": "Civil Engineering"
      },
      {
          "Code": "ENR",
          "Desc": "ENR"
      },
      {
          "Code": "GovernmentProductNews",
          "Desc": "Government Product News"
      },
      {
          "Code": "LandscapeArchitect",
          "Desc": "Landscape Architect"
      },
      {
          "Code": "NACENewsDirectory",
          "Desc": "NACE News Directory"
      },
      {
          "Code": "PublicWorks",
          "Desc": "Public Works"
      },
      {
          "Code": "RoadsAndBridges",
          "Desc": "Roads and Bridges"
      },
      {
          "Code": "SiteSolutions",
          "Desc": "Site Solutions"
      },
      {
          "Code": "SweetsProductNews",
          "Desc": "Sweet's Product News"
      },
      {
          "Code": "OtherPublication",
          "Desc": "Other Publication"
      },
      {
          "Code": "AnotherPerson",
          "Desc": "Another Person"
      },
      {
          "Code": "PersonalReferral",
          "Desc": "Personal Referral"
      },
      {
          "Code": "CONTECHRep",
          "Desc": "A CONTECH representative"
      },
      {
          "Code": "MailedInformation",
          "Desc": "Mailed information"
      },
      {
          "Code": "SearchEngine",
          "Desc": "Search Engine"
      },
      {
          "Code": "InternetLink",
          "Desc": "Internet Link"
      },
      {
          "Code": "Other",
          "Desc": "Other"
      }
   ],
    "RailHeight": [
      {
          "BridgeStyleCode": "Pedestrian_Connector",
          "Code": "42Inch",
          "Desc": "42\" Pedestrian"
      },
      {
          "BridgeStyleCode": "Pedestrian_Connector",
          "Code": "54Inch",
          "Desc": "54\" Bicycle"
      },
      {
          "BridgeStyleCode": "Pedestrian_Link",
          "Code": "42Inch",
          "Desc": "42\" Pedestrian"
      },
      {
          "BridgeStyleCode": "Pedestrian_Link",
          "Code": "54Inch",
          "Desc": "54\" Bicycle"
      },
      {
          "BridgeStyleCode": "Pedestrian_Capstone",
          "Code": "42Inch",
          "Desc": "42\" Pedestrian"
      },
      {
          "BridgeStyleCode": "Pedestrian_Capstone",
          "Code": "54Inch",
          "Desc": "54\" Bicycle"
      },
      {
          "BridgeStyleCode": "Pedestrian_Keystone",
          "Code": "42Inch",
          "Desc": "42\" Pedestrian"
      },
      {
          "BridgeStyleCode": "Pedestrian_Keystone",
          "Code": "54Inch",
          "Desc": "54\" Bicycle"
      },
      {
          "BridgeStyleCode": "Pedestrian_Gateway",
          "Code": "42Inch",
          "Desc": "42\" Pedestrian"
      },
      {
          "BridgeStyleCode": "Pedestrian_Gateway",
          "Code": "54Inch",
          "Desc": "54\" Bicycle"
      }
   ],
    "State": [
      {
          "Code": "USA_AK",
          "Desc": "Alaska"
      },
      {
          "Code": "USA_AL",
          "Desc": "Alabama"
      },
      {
          "Code": "USA_AR",
          "Desc": "Arkansas"
      },
      {
          "Code": "USA_AZ",
          "Desc": "Arizona"
      },
      {
          "Code": "USA_CA",
          "Desc": "California"
      },
      {
          "Code": "USA_CO",
          "Desc": "Colorado"
      },
      {
          "Code": "USA_CT",
          "Desc": "Connecticut"
      },
      {
          "Code": "USA_DE",
          "Desc": "Delaware"
      },
      {
          "Code": "USA_FL",
          "Desc": "Florida"
      },
      {
          "Code": "USA_GA",
          "Desc": "Georgia"
      },
      {
          "Code": "USA_HI",
          "Desc": "Hawaii"
      },
      {
          "Code": "USA_IA",
          "Desc": "Iowa"
      },
      {
          "Code": "USA_ID",
          "Desc": "Idaho"
      },
      {
          "Code": "USA_IL",
          "Desc": "Illinois"
      },
      {
          "Code": "USA_IN",
          "Desc": "Indiana"
      },
      {
          "Code": "USA_KS",
          "Desc": "Kansas"
      },
      {
          "Code": "USA_KY",
          "Desc": "Kentucky"
      },
      {
          "Code": "USA_LA",
          "Desc": "Louisiana"
      },
      {
          "Code": "USA_MA",
          "Desc": "Massachusetts"
      },
      {
          "Code": "USA_MD",
          "Desc": "Maryland"
      },
      {
          "Code": "USA_ME",
          "Desc": "Maine"
      },
      {
          "Code": "USA_MI",
          "Desc": "Michigan"
      },
      {
          "Code": "USA_MN",
          "Desc": "Minnesota"
      },
      {
          "Code": "USA_MO",
          "Desc": "Missouri"
      },
      {
          "Code": "USA_MS",
          "Desc": "Mississippi"
      },
      {
          "Code": "USA_MT",
          "Desc": "Montana"
      },
      {
          "Code": "USA_NC",
          "Desc": "North Carolina"
      },
      {
          "Code": "USA_ND",
          "Desc": "North Dakota"
      },
      {
          "Code": "USA_NE",
          "Desc": "Nebraska"
      },
      {
          "Code": "USA_NH",
          "Desc": "New Hampshire"
      },
      {
          "Code": "USA_NJ",
          "Desc": "New Jersey"
      },
      {
          "Code": "USA_NM",
          "Desc": "New Mexico"
      },
      {
          "Code": "USA_NV",
          "Desc": "Nevada"
      },
      {
          "Code": "USA_NY",
          "Desc": "New York"
      },
      {
          "Code": "USA_OH",
          "Desc": "Ohio"
      },
      {
          "Code": "USA_OK",
          "Desc": "Oklahoma"
      },
      {
          "Code": "USA_OR",
          "Desc": "Oregon"
      },
      {
          "Code": "USA_PA",
          "Desc": "Pennsylvania"
      },
      {
          "Code": "USA_RI",
          "Desc": "Rhode Island"
      },
      {
          "Code": "USA_SC",
          "Desc": "South Carolina"
      },
      {
          "Code": "USA_SD",
          "Desc": "South Dakota"
      },
      {
          "Code": "USA_TN",
          "Desc": "Tennessee"
      },
      {
          "Code": "USA_TX",
          "Desc": "Texas"
      },
      {
          "Code": "USA_UT",
          "Desc": "Utah"
      },
      {
          "Code": "USA_VA",
          "Desc": "Virginia"
      },
      {
          "Code": "USA_VT",
          "Desc": "Vermont"
      },
      {
          "Code": "USA_WA",
          "Desc": "Washington"
      },
      {
          "Code": "USA_WI",
          "Desc": "Wisconsin"
      },
      {
          "Code": "USA_WV",
          "Desc": "West Virginia"
      },
      {
          "Code": "USA_WY",
          "Desc": "Wyoming"
      },
      {
          "Code": "OTHER",
          "Desc": "Other"
      },
      {
          "Code": "INTL",
          "Desc": "International"
      },
      {
          "Code": "USA_PR",
          "Desc": "Puerto Rico"
      }
   ],
    "Type": [
      {
          "Code": "Pedestrian",
          "Desc": "Pedestrian"
      },
      {
          "Code": "Vehicular",
          "Desc": "Vehicular"
      }
   ],
    "UniformLiveLoad": [
      {
          "Code": "Pedestrian_85psfReduced",
          "Desc": "85 psf (reduced)",
          "BridgeTypeCode": "Pedestrian"          
      },
      {
          "Code": "Pedestrian_85psf",
          "Desc": "85 psf",
          "BridgeTypeCode": "Pedestrian"          
      }
   ],
    "VehicularLoad": [
      {
          "Code": "Vehicular_HS20",
          "Desc": "HS20",
          "BridgeTypeCode": "Vehicular"          
      },
      {
          "Code": "Vehicular_HS25",
          "Desc": "HS25",
          "BridgeTypeCode": "Vehicular"          
      }
   ]
};