# _LOG_FindAndReplace

OldValue:
SELECT main_cat.cat_name, sub_cat.sub_cat_name, count(rates.grading) AS max_grade
FROM (main_cat INNER JOIN rates ON main_cat.cat_id=rates.cat_id) INNER JOIN sub_cat ON (main_cat.cat_id=sub_cat.cat_id) AND (sub_cat.sub_cat_id=rates.sub_cat_id)
WHERE (RATES.grading>[ENTER VALUE])
GROUP BY main_cat.cat_name, sub_cat.sub_cat_name
ORDER BY count(rates.grading) DESC;


OldValue:
SELECT projects.proj_id, projects.proj_num, rates.proj_id, main_cat.cat_num, main_cat.cat_name, sub_cat.sub_cat_num, sub_cat.sub_cat_name, rates.grading
FROM (projects INNER JOIN (main_cat INNER JOIN rates ON main_cat.cat_id=rates.cat_id) ON projects.proj_id=rates.proj_id) INNER JOIN sub_cat ON main_cat.cat_id=sub_cat.cat_id;


OldValue:
SELECT main_cat.cat_name, sub_cat.sub_cat_name, rates.grading
FROM (main_cat INNER JOIN rates ON main_cat.cat_id=rates.cat_id) INNER JOIN sub_cat ON (main_cat.cat_id=sub_cat.cat_id) AND (sub_cat.sub_cat_id=rates.sub_cat_id)
WHERE (((rates.grading)>=3));


OldValue:
SELECT rates.grading, rates.cat_id, [main_cat Query1].comment_num, [main_cat Query1].proj_num
FROM [main_cat Query1] INNER JOIN rates ON [main_cat Query1].rate_id=rates.rate_id;


OldValue:
SELECT main_cat.cat_name, Count(main_cat.cat_name) AS Total_count
FROM projects INNER JOIN (main_cat INNER JOIN rates ON main_cat.cat_id=rates.cat_id) ON projects.proj_id=rates.proj_id
GROUP BY main_cat.cat_name, rates.cat_id, main_cat.cat_id
ORDER BY main_cat.cat_id;


OldValue:
SELECT *
FROM projects
WHERE (projects.proj_num>" 57284");


OldValue:
SELECT *
FROM projects
WHERE (projects.proj_num="57284");


OldValue:
SELECT *
FROM projects
WHERE projects.proj_num="51218";


OldValue:
SELECT *
FROM projects
WHERE (project.proj_pm="Steve Frey");


OldValue:
SELECT TOP 10 main_cat.cat_name, sub_cat.sub_cat_name, Count(rates.grading) AS No_Grading, projects.proj_num, main_cat.cat_id, sub_cat.sub_cat_id, rates.remarks, rates.major_issue, rates.new_material, rates.new_technique, rates.new_spec
FROM projects INNER JOIN ((main_cat INNER JOIN rates ON main_cat.cat_id=rates.cat_id) INNER JOIN sub_cat ON (main_cat.cat_id=sub_cat.cat_id) AND (sub_cat.sub_cat_id=rates.sub_cat_id)) ON projects.proj_id=rates.proj_id
WHERE (((rates.grading)>=4))
GROUP BY main_cat.cat_name, sub_cat.sub_cat_name, projects.proj_num, main_cat.cat_id, sub_cat.sub_cat_id, rates.remarks, rates.major_issue, rates.new_material, rates.new_technique, rates.new_spec
HAVING (((main_cat.cat_id)=1) AND ((sub_cat.sub_cat_id)=1))
ORDER BY Count(rates.grading) DESC;


OldValue:
SELECT main_cat.cat_name, sub_cat.sub_cat_name, *
FROM (main_cat INNER JOIN rates ON main_cat.cat_id=rates.cat_id) INNER JOIN sub_cat ON (main_cat.cat_id=sub_cat.cat_id) AND (sub_cat.sub_cat_id=rates.sub_cat_id)
WHERE (((main_cat.cat_id)=1));


OldValue:
SELECT main_cat.cat_name, main_cat.cat_id FROM main_cat ORDER BY main_cat.cat_name;


OldValue:
SELECT sub_cat.sub_cat_name, sub_cat.sub_cat_num, sub_cat.sub_cat_id FROM sub_cat WHERE sub_cat.cat_id=cbxCat_id ORDER BY sub_cat.sub_cat_num;


OldValue:
SELECT rates.* FROM rates ORDER BY rates.grading DESC , rates.comment_num;


OldValue:
SELECT OverUnder.* FROM OverUnder ORDER BY OverUnder.proj_id, OverUnder.ou_item_num;


OldValue:
SELECT Contacts.EmpName, Contacts.EmpTitle FROM Contacts WHERE (((Contacts.EmpTitle)="proj_pe"));


OldValue:
SELECT Contacts.EmpName, Contacts.EmpTitle FROM Contacts WHERE (((Contacts.EmpTitle)="proj_pm"));


OldValue:
SELECT Contacts.EmpName, Contacts.EmpTitle FROM Contacts WHERE (((Contacts.EmpTitle)="proj_ce"));


OldValue:
SELECT DISTINCT projects.proj_status FROM projects ORDER BY proj_status;


OldValue:
SELECT co_inputs.* FROM co_inputs ORDER BY co_inputs.proj_id, co_inputs.co_num;


OldValue:
SELECT field_mappings.field_desc, field_mappings.field_name FROM field_mappings ORDER BY field_desc;


OldValue:
SELECT projects.proj_id, projects.proj_num, projects.proj_name FROM projects ORDER BY projects.proj_num;


OldValue:
Single click to highlight and select record:


OldValue:
SELECT DISTINCT [proj_award_dt] FROM Projects ORDER BY [proj_award_dt];


OldValue:
rsMaster.Open "SELECT * FROM " & strTable & ";", con, adOpenStatic, adLockPessimistic


OldValue:
rsNew.Open "SELECT * FROM " & strTable & ";", cnImport, adOpenStatic, adLockReadOnly, adCmdText


OldValue:
MsgBox "Select project record.", , "Error"


OldValue:
strSQL = "SELECT projects.proj_id, projects.proj_num, main_cat.cat_name, sub_cat.sub_cat_name, Count(rates.grading) AS No_Grading " & _


OldValue:
sql = "SELECT " & strTop10 & " main_cat.cat_name, sub_cat.sub_cat_name, Count(rates.grading) AS No_Grading " & _


OldValue:
strSQL = "SELECT " & strTop10 & " main_cat.cat_name, sub_cat.sub_cat_name, count(rates.grading) AS No_Grading " & _


OldValue:
strSQL = "SELECT projects.proj_id, projects.proj_num, main_cat.cat_name, sub_cat.sub_cat_name, " & _


OldValue:
Me.tbxQuery = "SELECT main_cat.cat_name, sub_cat.sub_cat_name " & _


OldValue:
Me.tbxQuery = "SELECT projects.proj_num, main_cat.cat_name, sub_cat.sub_cat_name, " & _


OldValue:
Me.lbxValues.RowSource = "SELECT DISTINCT [" & lbxProjFields.Column(1) & "] FROM Projects ORDER BY [" & lbxProjFields.Column(1) & "];"


OldValue:
rs.Open "SELECT cat_id FROM main_cat WHERE cat_num = " & lngCatNum & ";", con, adOpenStatic, adLockOptimistic, adCmdText


OldValue:
rs.Open "SELECT sub_cat_id FROM sub_cat " & _


OldValue:
rs.Open "SELECT rates.cat_id, Sum(rates.grading) AS TotalGrade " & _


OldValue:
rs.Open "SELECT rates.proj_id, rates.cat_id, rates.sub_cat_id, (Sum(rates.grading)/Count(rates.grading)) as TotalGrade " & _


OldValue:
rs.Open "SELECT rates.proj_id, rates.cat_id, rates.sub_cat_id, Count(rates.grading) As Count " & _


OldValue:
SELECT rates.*, main_cat.cat_name, sub_cat.sub_cat_name FROM (main_cat RIGHT JOIN sub_cat ON main_cat.cat_id=sub_cat.cat_id) RIGHT JOIN rates ON sub_cat.sub_cat_id=rates.sub_cat_id ORDER BY rates.proj_id, rates.grading DESC , rates.comment_num;


OldValue:
SELECT projects.* FROM projects ORDER BY proj_num;


# co_inputs

co_desc:
Planting Bed Modifications and Wetland Restoration


co_desc:
Removal & Remediation of Contaminated Soil


co_desc:
Meth Markings, Inlaid and Surface Applied


co_desc:
LED Taxiway Edge Lights and LED Lighted Wind Cone


co_desc:
Additional Modifications at A St. & Benson Blvd.


co_desc:
Taxiway Centerline & Holding Position Markings


co_desc:
Runway Safety Area Crushed Aggregate Surface Ciurse, Gading D-1


# OverUnder

ou_desc:
Planting Bed Modifications and Wetland Restoration


ou_desc:
C.O. #1 - Field Office Telecommunications


ou_desc:
C.O. #2 - STE-1 Asphalt For Tack Coat - LS


ou_desc:
C.O. #3 - 300mm Corr. Poly Pipe w/headwall


# projects

proj_desc:
The project consists of replacing existing incandescent runway & taxiway lights with more efficient LED lights and relocating the old regulator building to new regulator building in Adak Island, Alaska located in western end of the Aleutian Chain.  The pr


proj_desc:
This federally funded project will consist of constructing an access road, connecting the community of False Pass to a new landfill site. A pre-engineered bridge will be installed across Ungaman Creek. Riprap protection will be within the creek banks to p


proj_name:
Kenai Peninsula Safety Improvements 2006 / HSIP: CR Avalanche Gate Replacement

proj_desc:
These two projects included signing, shoulder delineators, warning flashers, and a complete intersection upgrade at Willow Street in Kenai that extended from Cooper Landing, Kenai, and Homer; and at seven locations; avalanche signs, gates, and guardrail t


proj_name:
Muldoon Road, Landscaping & Pedestrian Improvements, Phase II

proj_desc:
This project consists of construction of 1300 ft of 10’ pathway with improved drangae systems and landscaping in planting beds and planters from south of Muldoon at Pioneer Drive to Muldoon and Debarr intersection.  The project also includes construction


proj_name:
Lake Otis Pkwy Rehabilitation project Abbott to 68th, and 88th Ave Reconstruction Toloff to Lake Otis

proj_desc:
This is a federally funded project being coordinated by the Municipality of Anchorage which consists of rehabilitating the pavement on approximately 7,900 feet of Lake Otis Pkwy, replacing curb ramps that do not meet current ADA standards, and correcting


proj_name:
Parks Highway Rut Repair: Lucus Road to Big Lake Road

proj_desc:
The project consisted of pavement rehabiliation on the Parks Highway between MP 44 - MP 53.  The project also had guardrail end treatment improvemnts, striping, and drainage improvements at Pittman Road.


proj_desc:
This project will resurface R/W 18/36, relocate the R/W 29 threshold and construct a new taxiway connecting the GA apron to R/W 18/36.


proj_name:
Parks Highway MP 42.1 - MP 44: Crusey Street to Lucus Road

proj_desc:
The project consisted of pavement rehabiliation on the Parks Highway between MP 42.1 - MP 44.  The project also had guardrail end treatment improvemnts, inlaid striping, and major electrical.  The scope included a digout at MP 43.  Electrical improvements


proj_desc:
Construction of a new airport including a runway, taxi-way, apron area and boardwalk.


proj_desc:
This federally funded project rehabilitated the paved roadway surface along Bogard Rd from Trunk Rd to Wasilla-Fishhook Rd and along Wasilla-Fishhook Rd from Seldon Rd to Palmer-Fishhook Rd.  Work items included; paving drainage improvements, guardrail re


proj_name:
Kalifornsky Beach Road Rehabilitation: MP 0 to 4.3 & MP 11 to 16

proj_desc:
The Project scope involved approximately 9.5 miles in two segments of widening, reconstruction, drainage upgrades, and paving of KBeach Road.  Foamed Asphalt treated base was replaced with soil cement reinforced base.  To minimize wetlands impacts, the ex


proj_name:
Sterling Highway Resurfacing MP 93.9 to 89.9

proj_desc:
Pre-level and pave 4 miles of the Sterling Highway between Soldotna and Sterling.


proj_name:
Potter Marsh Trailhead & Access Improvements, Phase II

proj_desc:
Extension of the existing interpretive boardwalk and a habitat pond.


proj_name:
Chignik Airport Access Road Rehabilitation - Rebid

proj_desc:
Rehabilitate the access road to the airport along two bluff sections, including placement of new armor stone protection.


proj_desc:
This pathway project was put out by the Municipality of Anchorage and admistered by the State of Alaska due to the use of federal funding for a large portion of the work.  The project consisted of connecting previous phases of the Ship Creek Trail project


proj_desc:
Construct a containment berm and two operational pads at the location of the snow disposal facility.  Enclose the new facility by installing chain link fence and operational gates.  In stall two wetland outfall drainage structures.  Connect these new faci


proj_desc:
Reconstruct the RON Parking 12-14 Taxilane and the parking apron to meet wingtip clearance requirements for 747-8s and to adequately support aircraft loading.  Replace aboveground edge lighting with flush edge lights and provided Taxilane and parking lead


proj_desc:
Mill and pave of the Glenn Highway from MP 34-42.


proj_desc:
This state funded project consists of improvements to the Tudor/Bragaw street intersection including median and signal work and construction of additional turn lanes from Florina street intersection to west Tudor Center Drive on Tudor Road and from, Tudor


proj_name:
Atka Airport Runway Extension & Resurfacing

proj_desc:
This federally funded project will reconstruct Atka Airport to include rotating and extending the runway to 100' x 4,500' with a 150' x 5,100' safety area, increasing the taxiway safety area width, relocating the apron and aviation support areas, replacin


proj_name:
CENTRAL REGION HIGHWAY DATA EQUIPMENT 2008

proj_desc:
Upgrade of highway data recording equipment at various locations identified on the plans as sites H-1, H-2, H-3, H-4, H-5, H-6, H-7, H-8, H-9, H-12, H-13, H-13A and H-13B.


proj_desc:
This Federally funded project constructed a barge ramp and staging area consisting of concrete planks and construction matting.  Work was added by Change Order to construct a 500-foot road to the west of the planned barge landing and a new barge ramp.


proj_desc:
This State funded project was split into two NTPs and two additive alternates.  NTP #1 restored the Chignik lagoon runway from 1660'x90' to 1935'x90'; in addition, the project added an apron, a designated runway crossing with flashing beacon system and a


proj_name:
Kenai Area Roads Resurfacing, 2009; Gas Well Road & Wendy Lane

proj_desc:
The project scope involved approximately 2.3 miles (1.6 miles on Gas Well Road and 0.7 miles on Wendy Lane) of crushing and stabilizing the existing pavement and base course creating foamed asphalt base course, drainage improvement, paving, and striping.


proj_desc:
Installation of Class III Riprap along the bank of the Matanuska River where high water has eroded the embankment to the edge of asphalt at MP 63.5. Also includes guardrail replacement and extension, willow cuttings and minor grading.


proj_name:
King Salmon Airport Apron and Taxiway Resurfacing

proj_desc:
This federally funded project resurfaced the Terminal and Air Cargo Aprons as well as Taxiways B, C, D, and E.  Taxiway A was realigned and resurfaced.  New lighting was installed along Taxiway A and the west side of Taxiway B.


proj_desc:
Reconstruct Goodnews Airport by widening and extending the existing runway ; constructing a new aircraft parking apron and aviation suppport area; constructing a new snow removal equipment storage building and pad; constructing a new airport access road;


proj_desc:
Repair runway pavement at Intersections of  R/W's 7/25 & 11/29 and R/W's 18/36 & 11/29 by cold planing, placing tack coat, placing new HMA to match existing pavement, grooving the new pavement and laying out airport pavement markings.  Additive Alternate


proj_desc:
Reconstruction of Trunk Road on a new alignment between the Parks Highway and Palmer-Wasilla Highway, with grading, drainage, paving, signilization, lighting and landscaping.


proj_name:
Minnesota Drive Resurfacing: International Airport Road to 13th Avenue

proj_desc:
This report is a combination of this project and the Minnesota Drive Resurfacing: C Street to International Airport Road project (#51340).  

Work included resurfacing of the highway from C Street to 13th Avenue.  Also included upgrades to curb ramps and


proj_name:
Glenn Hwy MP 92-96 Cascade to Hicks Creek

proj_desc:
Reconstruct roadway, widen and add passing lanes from mile 1 west of Cascade Maintenance &Operations Station (MP 92) to just east of Hicks Creek (MP97). Project also includes replacement of the Hicks Creek Bridge #0547.


proj_desc:
Reconstruct 3.2-miles of Keystone Drive from Boundary to the end of the road. Work includes clearing; excavation and backfill of full road prism; storm drain; culverts; paving; and signs.


proj_name:
Midtown Segment of the North South Trail

proj_desc:
This Federally funded project consists of constructing an asphalt multi-use pathway along "A" Street from 38th Avenue to Fireweed Lane.


proj_name:
Old Seward Hwy: Brandon Street to O'Malley Road

proj_desc:
The improvements included widening the existing road embankment to accommodate an expanded five lanes from Huffman Road to O'Malley Road and three lanes between Brandon Street and Huffman Road.  A Roundabout was installed at the Old Seward Hwy and Huffman


proj_name:
Bethel Airport Improvements, Phase 3, Stage 2, Parallel R/W

proj_desc:
This federally funded project will complete the structual section and install lighting for the new parallel runway, R/W IR-19L and three taxiways connecting R/W 1R-19L and R/W -1L-19R. This work will also include a new standby generator module, airport pr


proj_desc:
The project combines a State-Funded rehabilitation of the Old Glenn Hwy from MP 11.5 to 18, including shoulder widening, pathway, drainage improvements, highway lighting and signal upgrades; and a Federally funded HSIP project from the Mat River Bridge to


proj_name:
Seward Highway MP 37-43, Pavement Refurbishment

proj_desc:
This federally funded project consists of reclaiming, digouts, culvert replacement, paving, guardrail replacement, signing and striping 5.8 miles of road.


proj_name:
Arctic Blvd. 36th to Fireweed & Arctic Blvd. HSIP Improvements

proj_desc:
These Federal Aid projects will provide pavement planing and a new pavement surface with revised traffic markings on Arctic Boulevard from 36th Avenue to Fireweed Lane.  Also included are: widening for right turn lanes at 36th Avenue, medians and miscella


proj_desc:
This federally funded highway safety improvement project resurfaced the Seward Highway from approximately Indian Valley Road to Potter.  Work included planing the shoulders adjacent to existing guardrail, pre-leveling the existing ruts, paving, striping,


proj_desc:
This project consists of repairing the two 10' diameter culverts at Kern Creek, located at approximate milepost 86.3 of the Seward Highway.  The project includes replacement of approximately 100' of each culvert and reconstruction of the effected road sec


proj_desc:
This project relocates the airport and constructs a new runway, apron, taxiway, airport lighting system, rotating beacon, segmented circle, airport acess road and equipment storage building.


proj_desc:
Crow Creek Road Rehabilitation includes drainage improvements, new paved lanes and shoulders and a new bridge across California Creek.


proj_desc:
This project installs 96 low mount electroliers, 6 high tower elecroliers, 4 load centers, underground conduit and conductor, juntion boxes, guardrail and seeding along the Glenn Highway from Artillery Road in Eagle River to the South Birchwood Loop Road


proj_name:
Palmer-Wasilla Hwy Intxs Ph 1 &Vine Rd at Parks Signal

proj_desc:
Provides new signalized intersections on the PW Hwy at Hyer R, Wagon Road, Equestrian Street and Hemmer Road. Upgrades signals at Seward Meridian, Trunk Rd and N49th. Installs new signal at Vine Road/Parks Highway Intersection.


proj_desc:
This state funded project will rehabilitate approximately 1,675 feet of Runway 4/22 by regrading and adding 6 inches of new crushed aggregate surface course; replacing associated runway edge and threshold lights, removing existing threshold panels, instal


proj_desc:
PROVIDE ALL THE NECESSARY ENGINEERING, LABOR, EQUIPMENT, AND MATERIALS TO DESIGN AND CONSTRUCT A SYSTEM-TO-SERVICE INTERCHANGE BETWEEN THE GLENN HIGHWAY AND BRAGAW STREET IN ANCHORAGE ALASKA.


