{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INSTRUCTIONS","CHECKLIST","GEOPAK","COMMENTS","QAQC STATEMENT"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,5,0],[31,0,34,0],[36,0,38,0],[28,0,29,0],[7,0,11,0],[13,0,26,0]]}
["This QA/QC Checklist workbook has a customizable checklist that can be adjusted to show only items that the Survey PM is requiring the Survey Consultant to deliver for a particular project.  It is intended that this QA/QC Checklist be included with the MDOT Request for Survey Consultant Servicesso that the Survey Consultant is aware from the beginning of the contracting process of all of the items they must deliver.  There are some cases in which files or items are shown but end-up not being required.  This list should greatly reduce the amount of \"n/a\" comments."]
[]
[]
[]
[]
[]
[]
["This workbook contains multiple sheets: INSTRUCTIONS, CHECKLIST, GEOPAK, COMMENTS and QA/QC STATEMENT.  Once the checklist has been customized for your project, you can either print each sheet separately to a PDF and then combine them manually, or print the entire workbook to a PDF and manually delete the Instructions page.  We are looking into a \"Print\" macro that will print all sheets except the Instructions sheet to one PDF."]
[]
[]
[]
[]
[]
["The CHECKLIST sheet contains two categories, files to be uploaded to ProjectWise and items to be included in the Survey Portfolio PDF.  Each category is separated into sections.  For the ProjectWise category, the heading of each section begins with PWISE- and is shaded gray.  Following PWISE- is the name of the folder in ProjectWise (the first section is for files that go directly into the main project folder, not a sub-folder like the rest of the sections).  For the Survey Portfolio PDF category, the heading of each section begins with SURVEY PORTFOLIO PDF- and is shaded blue.  Following  SURVEY PORTFOLIO PDF- is the name of the bookmark section within the PDF.  To select the files and items you want included as a deliverable, simply place an \"x\" in that row in column \"D\".  Once you have an \"x\" next to all the items you want, click the \"Filter\" button (cell G1) and all rows with no \"x\" will be hidden.  To show all rows again, click the \"Show All\" (cell F1) button.  Due to the size of some of the rows, there are often page formatting issues once the checklist is filtered.  At this time, you must manually adjust  the page break locations to avoid having partially filled pages.  Go to the print preview and look at each page, if any page breaks need to be adjusted go back to the Checklist sheet, make sure the view is set to \"Page Break Preview\".  Navigate to the page break that needs to be adjusted, and then click and drag the page break to the desired location.  This may be an iterative process.   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The GEOPAK sheet contains the QC items required for the CAD deliverables.  This checklist can also be filtered, but since the fully expanded list fits all on one page, no page break formatting is required."]
[]
[]
["The COMMENTS sheet provides a place for the Survey Consultant to add any comments they have for the files or items that are included in the checklists.  Each item has an \"Item #\" which is in row \"A\" of the Checklist and GEOPAK sheets.  This number goes in the \"Item #\" column and the corresponding comment goes in the \"Comment\" column.  "]
[]
[]
[]
[]
["The QA/QC STATEMENT contains the QA/QC Compliance Statement that is required to be signed & sealed by the QA/QC officer for the Survey Consultant.  This page will typically not be modified and only needs to be included with the PDF."]

{"sheet":"CHECKLIST","index":1,"n_rows":190,"n_cols":4,"rows_kept":190,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[188,0,188,2],[94,0,94,2],[96,0,96,2],[6,1,7,1],[23,0,23,2],[29,0,29,2],[36,0,36,2],[50,0,50,2],[88,0,88,2],[11,0,11,2],[4,3,5,3],[6,4,7,4],[186,0,186,2],[181,0,181,2],[163,0,163,2],[156,0,156,2],[150,0,150,2],[146,0,146,2],[6,2,7,2],[6,0,7,0],[73,0,73,2],[108,0,108,2],[134,0,134,2],[8,0,8,2],[15,0,15,2]]}
["Michigan Department of Transportation"]
["Survey QA/QC Checklist"]
[]
[]
[null,"Revision Date:","2016-06-06","Required Item"]
[]
["Item #","QA/QC Review\nby Consultant","MDOT Survey Project Manager:________________\nConsultant Firm:____________________                           Consultant Project Manager:_______________\nMDOT Job Number:____________________                     Control Section:____________________\nDesign Project Manager (if sub):_________________","x"]
[null,null,null,"x"]
["PWISE - MAIN PROJECT FOLDER",null,null,"x"]
[1,null,"XXXXXX_MDOT_0222_20YY-MM-DD.pdf\nMDOT Form 222 (5/01) Survey Notes Receipt and Transmittal filled out with pertinent information and signed\n(e-signature is acceptable).  Once all files are uploaded to ProjectWise, change state to ‘Next’ and send the\nauto-generated e-mail to the MDOT Survey PM.","x"]
[2,null,"XXXXXX_Survey_Portfolio_20YY-MM-DD.pdf\nBookmarked Adobe PDF of pertinent project documents (See end of this document for items to be included in the portfolio):","x"]
["PWISE - ALIGNMENT & ROW FOLDER",null,null,"x"]
[3,null,"XXXXXX_Prop_20YY-MM-DD.doc\nA Microsoft Word document containing all property corners found / located in the field with the Northing, Easting, description of the corner location and monument, station and offset.The header should outline the company name, month and year of property corner location. Witnesses of individual property corners are not required.","x"]
[4,null,"XXXXXX_Prop_20YY-MM-DD.txt\nText document containing all found property/ROW monumentation in comma separated file in the following format: Point Number,Northing,Easting,Elevation,Description."]
[5,null,"XXXXXX_Images_ROW_20YY-MM-DD.zip\nDigital photos relating to ROW/property monumentation.  The name of each file should relate to the propert/controlling corner being photographed when possible.  All files are to be saved in one zip file."]
["PWISE - CONTROL FOLDER"]
[6,null,"XXXXXX_MDOT_Monument_monument number.doc\nMDOT Monument Establishment Data Sheet for Primary Control\navailable at: http://mdotwiki.state.mi.us/design/index.php/Chapter_10_-_Deliverables"]
[7,null,"XXXXXX_Images_Control_20YY-MM-DD.zip\nDigital photos relating to site control.  The name of each file should relate to the control point being photographed.  All files are to be saved in one zip file."]
[8,null,"Total Station RAW Data\nRAW data pertaining to Primary and Intermediate Control"]
[9,null,"GPS RAW Data\nRAW data pertaining to Primary and Intermediate Control"]
[10,null,"GPS RINEX Data\nGPS RAW data pertaining to Primary and Intermediate Control converted to RINEX format"]
[11,null,"MSRN RINEX Data\nThe RINEX files for the MSRN stations used by OPUS"]
[12,null,"Vertical RAW Data\nElectronic raw data files for all vertical control established.  "]
["PWISE - MAPPING FOLDER",null,null,"x"]
[13,null,"XXXXXX_Struc_Inventory_20XX-MM-DD.pdf\nDrainage structure inventory report compatible with MDOT software and correlated to the connectivity drawing in .xls spreadsheet format or MISIS output report in .pdf","x"]
[14,null,"XXXXXX_Photos_Mapping_20YY-MM-DD.zip\nZIP file of all digital photos of the structure(s) and end sections or headwalls with the name of the file being the structure number. For multiple photos of a structure, add a letter to the end starting with \"A\".  The numbering shall match with the information in Drainage Structure Inventory Report.","x"]
[15,null,"XXXXXX_Feature_Code.txt\nIndividual utility / drainage station and offset reports generated by feature code in the .dgn drawing.","x"]
[16,null,"XXXXXX_Connectivity_20YY-MM-DD.dgn\n3D Map of the project area generated from PowerGEOPAK that shows all the drainage structures collected for the project with lines connecting each structure at the proper invert elevations."]
[17,null,"XXXXXX_Mapping_Raw.zip\nElectronic raw data files for all mapping to be contained in a subfolder titled “Mapping Raw” with each day being contained in a subfolder for that day.  Multiple instruments per day require multiple subfolders."]
["PWISE - STLS (STATIC TERRESTRIAL LASER SCANNING)  FOLDER"]
[18,null,"Georeferenced Registered Proprietary Database"]
[19,null,".LAS file (version 1.2 or later) "]
[20,null,".POD file(s)"]
[21,null,"ASCII text file "]
[22,null,"Check that the following items are in compliance:\n       Adjoining scans used in DTM creation have correct required point density spacing\n       Scans have Min 20% overlap\n       Distance between scan setups are less than 500 ft.\n       Registration residuals between control points of adjacent scan setups\n       Clear overlaid photography on scan points\n       Scans control points traversed, Geo-referenced to correct to state plane zone, and NAVD88 datum\n       Scan control with unique numbering from Intermediate Control\n       4 control points visible in each independent scan, and meet the requirement in Appendix C-3\n       Ground Points are monumented in accordance with Appendix C-3-f\n       Correct use of Intermediate Control as described in Appendix C-3-g"]
[23,null,"XXXXXX_Scanning_QA_QC_20YY-MM-DD.dgn\nA .dgn format file contains information described as “Scanning QA/QC”. The points inside are correctly coded and are the correct feature.  (is this original description from the current QA/QC sufficient?)"]
["PWISE - MTL (MOBIL TERRESTRIAL LIDAR) FOLDER"]
[24,null,"Point Cloud Files\nProvided on electronic media of an appropriate size to contain all project information without separating on more than one media.  Two complete (2) copies have been provided to MDOT Lansing Survey Support Unit. A third (3rd) copy has been provided for use by the MDOT Region Surveyor or Design Engineer. (See Appendix F)"]
[25,null,"XXXXXX_MTL_Mission_Plan.tpm and .kml / .kmz\nMTL Planning files - Trajectory plan with planned target(control and validation) files in TopoDot Mission planning format, and kml/kmz format "]
[26,null,"XXXXXX_MTL_Survey_3D_date.dgn\n3D MicroStation DGN file containing all mapping, meeting MDOT Cadd requirements"]
[27,null,"XXXXXX_MTL_ExTriangle_3D_date.dgn\n3D MicroStation DGN triangle file containing the terrain surface triangles"]
[28,null,"XXXXXX_MTL_ExDTM_date.tin\nTerrain surface saved as a GEOPAK .TIN file generated from the point cloud data"]
[29,null,"LiDAR data has been tiled and saved as colorized .POD (Point Tools/MicroStation point cloud file) files using photo images"]
[30,null,"XXXXXX_POD_Tile_Index_date.dgn\nDGN index file showing tile layout and naming of POD files"]
[31,null,"LiDAR data has been tiled and submitted in .LAS/.LAZ (version 1.2 or later) format with RGB values and intensity values (File formats XYZIRGB or XYZRGBI) colorized from photo images"]
[32,null,"XXXXXX_LAS_Tile_Index_date.dgn\nDGN index file showing tile layout and naming of .LAS files"]
[33,null,"Photo mosaic/Images along route that support the LiDAR .POD/.LAS point cloud"]
[34,null,"Original unedited raw LiDAR dataset in manufacturer’s file format"]
[35,null,"XXXXXX_CntrltoMTL_Diff_3D_date.dgn\nDGN file containing mapping locations of all Control Targets, Validation Targets, GNSS Base Stations, Primary Control points, Intermediate Control points and Benchmarks used or established for the project. The points comply with MDOT features and coding.  The DGN also contains values showing the XYZ differences to the corresponding point in the final LiDAR Point Cloud. File is named"]
[36,null,"XXXXXX_DTM_Compare.dgn and .kmz\n3D MicroStation DGN and KMZ file providing the graphical representation of the resulting differences between the edited project DTM surface and the targets and validation points"]
["PWISE - INTERIM MTL FOLDER"]
[37,null,"Processing Trajectories, Scan Line Processing and Point Cloud Registration (Workflow of tasks done prior to data extraction/mapping tasks)"]
[38,null,"XXXXXX_Targets.txt\nCoordinate list of the Target points used for the Mobile mapping and the adjustment reports establishing these points."]
[39,null,"XXXXXX_ValidationPts.txt\nCoordinate list of the Validation points used for the Mobile mapping and the adjustment reports establishing these points."]
[40,null,"XXXXXX_PtCloud_Compare.dgn and .kmz\n3D MicroStation DGN and a KMZ file providing the graphical representation of the resulting differences between the project Point Cloud dataset and the targets and validation points"]
[41,null,"XXXXXX_MTL_Interim_Report_20YY-MM-DD.pdf\nNarrative report describing the actions taken to process and refine the trajectories and the results obtained.  Including, but not limited to, the following items:"]
[42,null,"Smooth Best Estimated Trajectory (SBET) resulting accuracies report (precision) for Trajectories "]
[43,null,"Describe and show any areas of the project where the data, as collected, exceeded the maximum elapsed time or distance traveled of uncorrected IMU drift due to GNSS signal loss or obstruction."]
[44,null,"Total Number of all Targets/Points/Validations "]
[45,null,"Number of  Control Targets"]
[46,null,"Number of Object Points (i.e. Pick Points) "]
[47,null,"Number of Validation Points"]
[48,null,"Manufacturer/software/consultant reports and printouts showing the results of the trajectory processing and refinement and accuracy level achieved"]
[49,null,"Manufacturer/software/consultant reports and printouts showing the results of the scan line point cloud processing, registration to control and accuracy level achieved"]
[50,null,"Cloud to Target registration – Statistics and comparison of how the point cloud fit to the targets"]
[51,null,"Comparison of elevation data between overlapping (side lap) runs and to the project validation/control elevations located in the overlap area"]
[52,null,"Comparison of elevation data between overlapping (cross lap) runs and to the project validation/control elevations located in the overlap area"]
[53,null,"Comparison of points at the area of overlap (end lap) if more than one GNSS base is used"]
[54,null,"Project targets and control points have been Geo-referenced to correct Michigan State Plane Zone, vertical datum (NAVD88), utilizing GEOID12A"]
[55,null,"Project Accuracy reports of collected GNSS data as well as PDOP and SV visibility"]
[56,null,"Project Accuracy reports of collected IMU data"]
[57,null,"Project Trajectory reports including a comparison of the forward and reverse runs as well as the combined forward/reverse run"]
[58,null,"Comparison spreadsheet showing the differences (fit) of the resultant combined point cloud to the validation points. This spreadsheet shall include a resultant summary in NSSDA format of all the validation points (minimum of 20 required) showing the 95% difference in horizontal X and Y, and Vertical Z for the project"]
["PWISE - STRUCTURES FOLDER"]
[59,null,"XXXXXX_Elevation_Sketches_structure designation.pdf\nSketch of both sides of structure in elevation view with the following information displayed: "]
[60,null,"Bridge Seat Elevations"]
[61,null,"Reference Point Elevations"]
[62,null,"Top of Footing Elevations"]
[63,null,"Underclearance Elevations"]
[64,null,"Water Surface Elevation"]
[65,null,"Other Elevations ________________"]
[66,null,"Dimensions of Existing Substructure Elements"]
[67,null,"XXXXXX_Plan_Sketches_structure designation.pdf\nSketch of structure in plan view with the following information displayed: "]
[68,null,"Dimensions of Existing Substructure Elements"]
[69,null,"Face to Face Existing Substructure Measurments"]
[70,null,"Reference Point Elevation, Stationing & Coordinates"]
[71,null,"Angle of Crossing of Existing Substructure Units with bridge Alignment"]
[72,null,"XXXXXX_Images_Structures_structure designation_20YY-MM-DD.zip\nZIP file of all digital photos of the structure.  If multiple structures, create a separate zip file for each."]
["PWISE - HYDRAULICS FOLDER"]
[73,null,"XXXXXX_Hydraulics_20YY-MM-DD.dgn\nThis DGN is a COPY of the S-XXXXXX_Survey_3D_20YY-MM-DD.dgn file.  All levels not pertaining to items required in the Hydraulics Survey Scope should be turned off, then use the \"Save Setings\" command."]
[74,null,"XXXXXX_Riparian_Owners.pdf\nMap of the riparian owners and addresses in the four quadrants of the structure and stream"]
[75,null,"XXXXXX_Hydro_Chains_20YY-MM-DD.csv\nThe HYDRO chains in specific MDOT format"]
[76,null,"XXXXXX_High_Pt_Chains_20YY-MM-DD.csv\nThe HIPTC chains in specific MDOT format"]
[77,null,"XXXXXX_Photos_Hydraulics_water course name_20YY-MM-DD.zip\nZIP file of all digital photos of the water course.  If multiple water courses, create a separate zip file for each."]
["PWISE - MISCELLANEOUS FOLDER",null,null,"x"]
[78,null,"Data not assignable to one of the other five sections may be placed here and must be discussed in the survey report.  Examples of appropriate site specific information might be: newspaper articles, photos of the project site looking up and down the roadway, various aspects of a structure, etc. Photos shall be submitted in native format and annotated. All documents (excluding photos taken at time of survey) must be included in the Survey Portfolio PDF.","x"]
["PWISE - RID FOLDER",null,null,"x"]
[79,null,"S-XXXXXX_Survey_Info_Sheet_20YY-MM-DD.doc\nThis document will list all Primary Control, Intermediate Control, and Photogrammetry Target points, Bench Marks, PLSS Corners, and Alignment Points.  Each point shall include a Northing, Easting, Elevation, standard deviation (2 sigma) in each coordinate, point scale factor, description of the monument, station and offset and witnesses.  The header should outline the company name, month and year of point establishment, datum, geoid used, SPC zone, the formula to convert from grid to ground distances, average combined scale factor, and the horizontal and vertical control points held fixed in the adjustments.","x"]
[80,null,"S-XXXXX_ControlPts_20YY-MM-DD.txt\nA comma delimited file (ASCII text) of the points included in the Survey Info Sheet shall be created to include the Point name / number, Northing, Easting, Elevation, and Description ","x"]
[81,null,"S-XXXXXX_Align_ROW_20YY-MM-DD.dgn\nAn alignment and ROW drawing (.dgn format) with:\n       Point numbers and coordinates of the POB and POE.\n       Alignment attributes on appropriate levels.\n       Alignment annotation shall be as follows “Roadway + Legal or Non-Legal +Ali.” For guidance on\n          alignment annotation please refer to the document titled, “Adaptation of Proposed Alignment/ROW\n          Concepts.”        (www.michigan.gov/documents/mdot/MDOT_Design_Plan_and_Process_Changes_102512_402398_7.pdf)\n       An alignment key including the following:\n            Route Name\n            Origin Name, Origin Year & Origin Job Number\n            \"as retraced for\" Job Number\n            Year of retracement\n          e.g. - M-43 LEGAL (A) ALI = M-43 1954 Construction Alignment from Project 82-24 as retraced for Job\n          Number 111659 in 2011.\n       Complete curve data including:\n            Deflection angle (RT or LT), radius, external, tangent length\n            PC, PI and PT stations and coordinates\n       Section Corner ties annotated by bearing and distance along the section line from found PLSS corners to\n          the intersection with the alignment.\n       The location of the existing Right of Way \n       Right of Way attributes on appropriate levels.\n       Checked the Direction Ahead Bearing and Direction Back Bearing from the curve data to the Tangent\n          Bearing coming in to and out of the curve data to ensure that they are the same to prevent non-tangential\n          curves.","x"]
[82,null,"S-XXXXXX_Align_XML_20YY-MM-DD.xml\nAlignment(s) exported to an LandXML format. \nNote: Alignments must start on a tangent segment not on a curve segment. Curves containing delta’s of 180 degrees or greater must be broken into two curve segments.\n","x"]
[83,null,"jobXXX.gpk\nA .gpk file with the alignment and Right of Way chains (linear features) stored.","x"]
[84,null,"D-XXXXXX_Parcel_20YY-MM-DD.dgn\nThe master parcel drawing.  This file is originated by MDOT Real Estate with approximate parcel boundaries, the survey consultant updates this file with the surveyed parcel boundaries once the boundary survey of the parcels are completed (this file can be submitted ahead of finalized Certificates of Survey)"]
[85,null,"S-XXXXXX_Survey_3D_20YY-MM-DD.dgn\n3D - Map of the project area generated from PowerGEOPAK","x"]
[86,null,"S-XXXXXX_Survey_2D_20YY-MM-DD.dgn\nExport out a 2D Planimetric Map from the 3D Map of the project area generated from the PowerGEOPAK","x"]
[87,null,"S-XXXXXX_ExDTM_20YY-MM-DD.tin\n.tin file format of surface.","x"]
[88,null,"S-XXXXXX_ExTriangle_20YY-MM-DD.dgn\n3D triangle file [(contains triangles, clip boundary(ies) and voids (i.e. - obscured areas)]","x"]
[89,null,"S-XXXXXX_ExTriangle_XML_20YY-MM-DD.xml\nThe 3D triangle file exported to a LandXML format","x"]
["SURVEY PORTFOLIO PDF - ADMINISTRATIVE SECTION",null,null,"x"]
[90,null,"Vicinity Map\nScreen capture from Street Atlas, Google Maps, or some other resource with the POB and POE labeled","x"]
[91,null,"Surveyor’s Project Report, divided into subsections, containing a complete synopsis of project survey including, but not limited to: ","x"]
[92,null,"Explanation of any deviation from the Scope and/or the Standards.","x"]
[93,null,"Basis of horizontal and vertical control, with specific emphasis on datum sources used (list CORS and NAVD benchmarks tied), equipment, software, methods used to establish the coordinates and methods used to detect errors and eliminate them. If RTK is used, explain the methodology, equipment and procedure used. Include a detailed explanation relating to CORS usage or site calibration (Base Station) (for level loops, Primary and Intermediate Control networks).","x"]
[94,null,"Indicate Geoid Model used.","x"]
[95,null,"Statement indicating whether Precise or Rapid ephemeris has been used to process final solutions (OPUS RS can not be used).","x"]
[96,null,"Statement indicating  adherence to observation procedures per Appendix B of the current version of the Standards of Practice for use of OPUS to establish the horizontal datum.","x"]
[97,null,"Statement indicating that OPUS elevations have not been used for determining vertical control for the project, unless approved by the Survey Project Manager.","x"]
[98,null,"Statement indicating that for groups of control points spaced less than 1500 feet apart, the following procedures were followed: All of the points are submitted to OPUS and the baselines between the groups of points shall be calculated using conventional post processing techniques, using the OPUS derived values as a check.\n","x"]
[99,null,"Statement indicating that if a mark is used in multiple lists, such as a control point and a bench mark; it shall carry the same designation in each.  All lists shall include the mark name or number, description of the monument, station and offset, and coordinates.","x"]
[100,null,"Provide a complete discussion of all Alignments relative to the project. Specify information and methods used to determine the location and designation of each such as accepted monumentation and documents used to support your determination.","x"]
[101,null,"Property boundary issues addressed, with specific information that may be useful for a surveyor to retrace or an engineer during design.  If necessary, include a summary of conversations with property owners and their concerns.","x"]
[102,null,"Mapping information for the project should be summarized per the Standards Of Practice dialog. ","x"]
[103,null,"Any mapping issues encountered, with specific information that may be useful for an engineer during design.","x"]
[104,null,"Any information obtained regarding drainage issues observed or reported by local authorities or residents should be discussed","x"]
[105,null,"Explanation of how the Reference Point locations were determined for Bridge Surveys."]
[106,null,"Discuss the contents of anything that appears in the Miscellaneous section.","x"]
[107,null,"The signed, sealed, and dated “PROFESSIONAL SURVEYOR’S   CERTIFICATION FOR MDOT PROJECTS” as detailed in the Standards of Practice.","x"]
[108,null,"Alignment information must be certified, signed and sealed by the Professional Surveyor as described in the Alignment section of the Standards of Practice.","x"]
[109,null,"MDOT Survey Project Check List\nThis Form, completed, signed & sealed, indicating that all project related items are accounted for.","x"]
[110,null,"QA/QC Certification\nSigned and sealed by the lead QA/QC person (See the Survey Standards of Practice (May 2014) Quality Assurance/Quality Control section – Page 27.) - NOTE: This is not the QA/QC statement from the QA/QC Checklist.","x"]
[111,null,"Notice to Proceed\nMDOT form 5180 Acceptance of Priced Proposal & Authorization for Consultant to Proceed attached documents as received from MDOT Contract Services Division (remove Cost Derivation pages).","x"]
[112,null,"MDOT Form 5102 - Change of Scope\nOnly required if there was an actual change of scope after initial authorization."]
[113,null,"Work Permits Required for the Project","x"]
[114,null,"Correspondence\nMinutes of Meetings, phone conversations, emails and any other project related correspondence.","x"]
["SURVEY PORTFOLIO PDF - CONTROL SECTION",null,null,"x"]
[115,null,"MDOT Monument Establishment Sheet\nAll Primary Control Points established and or used as part of this project (contact Lansing survey Support Office for template).","x"]
[116,null,"NGS Data Sheets.","x"]
[117,null,"NGS Mark Recovery Forms.","x"]
[118,null,"GPS v EDM Control Comparison\nInclude a table of GPS and EDM observations for Primary Control showing: Average Combined Scale Factor, Measured GPS Grid Distance, Calculated GPS Ground Distance, Measured EDM Ground Distance and Δ Distance (GPS Ground – EDM Ground).","x"]
[119,null,"Field Notes\nScanned copies of field notes pertaining to control work.","x"]
[120,null,"Primary Control Plot\nPlot(s) of the GPS network(s) from GPS software and sketch(s) or plot(s) of network or traverse with legible point numbers for Primary Control.","x"]
[121,null,"Intermediate Control Plot\nPlot(s) of the GPS network(s) from GPS software and sketch(s) or plot(s) of network or traverse with legible point numbers for Intermediate Control.","x"]
[122,null,"Reports for Primary Control horizontal adjustments including: (Check all that apply).\n            Minimally                   Fully\n          Constrained            Constrained\n                                                                input parameters, a-priori, centering error, etc\n                                                                raw unadjusted closures \n                                                                final coordinates with standard deviations (2 sigma)\n                                                                vector input data and analysis.  \n                                                                histograms  \n                                                                error ellipses  \n                                                                traverse closures  \n                                                                statistical test results  \n                                                                horizontal and vertical datums, ellipsoid, SPC zone and units (IF)\n                                                                name of the adjustment program used with \n                                                                      version or release. \n           OR supply all written calculations to support the final results.  \n          Only Non-trivial vectors used \n","x"]
[123,null,"Reports for Intermediate Control horizontal adjustments including: (Check all that apply).\n            Minimally                   Fully\n          Constrained            Constrained\n                                                                input parameters, a-priori, centering error, etc\n                                                                raw unadjusted closures \n                                                                final coordinates with standard deviations (2 sigma)\n                                                                vector input data and analysis  \n                                                                histograms  \n                                                                error ellipses  \n                                                                traverse closures  \n                                                                statistical test results  \n                                                                horizontal and vertical datums, ellipsoid, SPC zone and units (IF)\n                                                                name of the adjustment program used with \n                                                                      version or release. \n           OR supply all written calculations to support the final results.  \n          Only Non-trivial vectors used \n","x"]
[124,null,"OPUS Requirements\nStation Observation Sheets and copies of the OPUS Extended Output files.","x"]
[125,null,"Reports for Vertical adjustments including: (Check all that apply).\n            Minimally                   Fully\n          Constrained            Constrained\n                                                                input parameters\n                                                                raw unadjusted closures \n                                                                final elevations with standard deviations (2 sigma)\n                                                                loop closures  \n                                                                statistical test results.  \n                                                                horizontal and vertical datums, ellipsoid, SPC zone and units (IF)\n                                                                name of the adjustment program used with version or release. \n           OR supply all written calculations to support the final results.","x"]
["SURVEY PORTFOLIO PDF - ALIGNMENT & ROW SECTION",null,null,"x"]
[126,null,"Research\nResearch information used to establish alignment and ROW such as:\n         ■   MDOT survey records\n         ■   MDOT deeds/easements, ROW releases, adjacent private land owner deeds.\n         ■   LCRCs for PLSS corners\n         ■   Recorded/Unrecorded Plats\n         ■   Recorded/Unrecorded Surveys\n         ■   Tax descriptions of adjacent properties","x"]
[127,null,"Tax Maps\nMark maps with location and point numbers of the property corners located in the field.","x"]
[128,null,"Field Notes\nScanned copies of field notes pertaining to alignment and ROW work.","x"]
["SURVEY PORTFOLIO PDF - MAPPING SECTION",null,null,"x"]
[129,null,"Research\nResearch information related to project mapping such as:\n         ■   Old MDOT plans\n         ■   Aerial photos/images\n         ■   Plans/Maps from local agencies","x"]
[130,null,"Field Notes\nScanned copies of field notes pertaining to mapping.","x"]
[131,null,"Calculations\nOnly relative to mapping such as temporary Control Points/Benchmarks."]
[132,null,"Utility Maps/Plans","x"]
[133,null,"Utility Company List\nInclude company name, address, phone number and contact person.","x"]
["SURVEY PORTFOLIO PDF - STATIC TERESTRIAL LASER SCANNING (STLS) SECTION"]
[134,null,"Scanning Report\nMust contain all of minimum requirements of Appendix C-1-b items."]
[135,null,"Sketch of scanning setups and target locations"]
[136,null,"Scanning Control Point list"]
[137,null,"Registration residuals"]
[138,null,"QA/QC spreadsheet for check shots"]
[139,null,"Field Notes\nScanned copies of field notes pertaining to STLS."]
["SURVEY PORTFOLIO PDF - MOBILE TERESTRIAL LiDAR (MTL) SECTION"]
[140,null,"Location map\nShowing the MDOT project limits area, coverage of the MTL acquisition and the locations of GNSS base stations and CORS used."]
[141,null,"MTL Final Report\nSpecifically describes the Mobile LiDAR project and includes the following:"]
[142,null,"Final version of Interim Report developed in the Processing Trajectories, Scan Line Processing and Point Cloud Registration section prepared for the interim early delivery to MDOT."]
[143,null,"Planning, acquisition, processing, and point cloud preparation"]
[144,null,"Describes, at a minimum, how the requirements of Appendix D were met"]
[145,null,"Describes how the MTL acquisition was controlled, whether via use of CORS (list CORS used and distances from project) or via local GNSS base station(s) (and methods used to establish) or some other method for tying the MTL to the project coordinates."]
[146,null,"Describes the limits of MTL, limits of any supplemental survey mapping and how the data was merged if required for the overall project"]
[147,null,"Statement that LiDAR acquisition has been done when pavement is dry. If not, explain and describe weather conditions and conditions of pavement surface"]
[148,null,"Statement that LiDAR acquisition settings and operating speed were done in a manner to maintain accurate data and consistent data spacing throughout the project"]
[149,null,"Statement that LiDAR acquisition included collection of images along the trajectory routes to colorize the point cloud"]
[150,null,"List the number of passes completed along each corridor or per trajectory that were used to acquire point cloud data and limit resulting obscured areas:\nNumber of Passes = _____________\n"]
[151,null,"List the percentage of side overlap of adjacent scan passes:  ______________%"]
[152,null,"Data extracted from LiDAR point clouds have been delivered with a consistent spacing used by all operators.\nList average spacing between vertices when extracting line features: ___________ feet.   \nList average spacing used in extracting spot shots (e.g. parking areas, terrain, slopes, etc.): ________ft. by ________ ft. grid.\n"]
[153,null,"Comparison spreadsheet showing the fit of the control points/targets to the final point cloud. This spreadsheet shall include a resultant summary in NSSDA format showing the 95% differences in horizontal X and Y, and Vertical Z for the project. (The TopoDOT Control points to point cloud analysis tool that outputs a spreadsheet and chart diagram is one accepted option.)"]
[154,null,"Comparison spreadsheet showing the differences (fit) of the final project DTM surface to the validation points. This spreadsheet shall include a resultant summary in NSSDA format showing the 95% differences in horizontal X and Y, and Vertical Z for the project"]
[155,null,"Comparison spreadsheet showing the differences (fit) of the final project DTM surface to the validation points. This spreadsheet shall include a resultant summary in NSSDA format showing the 95% differences in horizontal X and Y, and Vertical Z for the project."]
[156,null,"Field Notes\nScanned copies of field notes pertaining to MTL."]
["SURVEY PORTFOLIO PDF - STUCTURES SECTION"]
[157,null,"Elevation View Sketch\nInsert the Elevation View Sketch of the structure(s)."]
[158,null,"Plan View Sketch\nInsert the Plan View Sketch of the structure(s)."]
[159,null,"MDOT Culvert Form(s)\nInsert the appropriate MDOT culvert form(s)"]
[160,null,"Field Notes\nScanned copies of field notes pertaining to structures."]
["SURVEY PORTFOLIO PDF - HYDRAULICS SECTION"]
[161,null,"Field Notes\nScanned copies of field notes pertaining to hydraulics."]
["SURVEY PORTFOLIO PDF - MISCELLANEOUS SECTION"]
[162,null,"Documents from the Miscellaneous folder.  Photos taken during the project will not be inserted here."]

{"sheet":"GEOPAK","index":2,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,4,1,4],[2,0,2,2],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3]]}
["Item #","QA/QC Review\nby Consultant","Power GEOPAK File\nNote: Reference to \"Data Acquisition\" (PowerGEOPAK SS2) is synonymous with \"Survey\" in PowerGEOPAK SS3","Required Item"]
[]
[]
[163,null,"The required plot scale is: 1inch = ___ feet","x"]
[164,null,"The correct zone specific seed file was used and the Geographic Coordinate System Library Settings have been verified to ensure that the correct state plane coordinate zone is attached.","x"]
[165,null,"Correct MDOT_DA_FeatureStyles.xml attached prior to data importation.","x"]
[166,null,"Only MDOT Feature Codes per the most current version of the MDOT_DA_FeatureCodes.xml file.","x"]
[167,null,"Appropriate MDOT Level Libraries have been attached to the .dgn file.","x"]
[168,null,"The Control Point list coordinates have been compared to the coordinates in the Data Acquisition / Survey file.","x"]
[169,null,"The Benchmark list elevations have been compared to the elevations in the Data Acquisition / Survey file.","x"]
[170,null,"The Alignment Point list coordinates have been compared to the coordinates in the .dgn file.","x"]
[171,null,"The PLSS Corner list coordinates have been compared to the coordinates in the .dgn file.","x"]
[172,null,"All Survey Linear Features are edited; properly connected; patterns checked for proper direction, correctness, and aesthetics.","x"]
[173,null,"All Survey Linear Feature crossings resolved.","x"]
[174,null,"No Survey Geometry Chains (Alignments / ROW) are expressed as Data Acquisition Elements.","x"]
[175,null,"Hydro Survey Chains checked for correct left to right direction.","x"]
[176,null,"As-Constructed Structure Alignment(s)"]
[177,null,"Deck survey chain(s) for Structure(s)"]
[178,null,"Abutment survey chain(s) for Structure(s)"]
[179,null,"Wing wall survey chain(s) for Structure(s)","x"]
[180,null,"DTM surface names will appear within Data Acquisition in adherence to the following Naming conventions: \n       Road Project – EXRD, EXRD1, EXRD2, etc. for multiple surfaces \n       Structure Project – EXBRG, EXBRG1, EXBRG2\n       Bridge Deck surface if requested  - EXDECK, EXDECK1, EXDECK2\n       Photo Mapping – EXPHO, EXPHO1, EXPHO2\n       Supplemental Photo Survey – EXSUP, EXSUP1, EXSUP2\n       Merged Photo / Supplemental Survey – EXMERG, EXMERG1, EXMERG2\n","x"]
[181,null,"DTM checked for invalid break lines and point data","x"]
[182,null,"DTM triangles checked for spikes and dips","x"]
[183,null,"Long or invalid triangles have been obscured from TIN","x"]
[184,null,"Contours created based on the following object display settings:\n       Contour interval set to___ regular and ___ index\n       All contour colors set to “By Level”\n       Line weights set to “By Level”\n       All contour levels set to correct level per current MDOT Workspace. \n       Character height is dependent on the scale and set to correct proportion / type per current MDOT Workspace font\n          requirements.\n       Final contours written to .dgn after DTM edits and settings checked\n       Correct scale factor for contour labeling.","x"]
[185,null,"Bridge Deck removed from DTM except when required for approach work","x"]
[186,null,"Water course removed from DTM","x"]
[187,null,"Terrain surface beneath bridge decks is included in DTM","x"]
[188,null,"Text size is set to the correct scale and is Annotation Scale Enabled","x"]
[189,null,"Cell scale is correctly set and is Annotation Scale Enabled","x"]
[190,null,"The .dgn files have been compressed. "]

{"sheet":"COMMENTS","index":3,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,1,0,9]]}
["ITEM #","COMMENT"]

{"sheet":"QAQC STATEMENT","index":4,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Yes    No     Scope has been reviewed to insure compliance. (Circle one)\n\n\nI ______________________, P.S. as lead QA/QC Surveyor in charge on this contract authorization have thoroughly reviewed the survey notes and scope of work and certify that all required and requested information has been electronically submitted to MDOT and is in compliance with the MDOT Survey Standards of Practice, the Survey Scope of Work, and this QA/QC Checklist, unless otherwise noted. Any individual check box left blank or marked N/A has been explained in the Comments following the checklist.\n\n\n     \n\n\n\n                                                            _____________________________________\nSEAL                                                        Professional Surveyor signature and date\n"]