Name: PreLettingChecklist
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)
Drawing Info:
{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"PreLettingChecklist","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: objectid
Unique ID Field:
IsSystemMaintained : True
Global ID Field: globalid
Type ID Field:
Fields:
- objectid (type: esriFieldTypeOID, alias: ObjectID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
- logo (type: esriFieldTypeString, alias: logo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- header (type: esriFieldTypeString, alias: Pre-Letting Checklist, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_name (type: esriFieldTypeString, alias: Project Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_id (type: esriFieldTypeString, alias: SCDOT PIN, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contract_id (type: esriFieldTypeString, alias: Contract ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_lat (type: esriFieldTypeDouble, alias: Latitude of Project Center Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
- project_long (type: esriFieldTypeDouble, alias: Longitude of Project Center Point, SQL Type: sqlTypeOther, nullable: true, editable: true)
- city (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- subregion (type: esriFieldTypeString, alias: subregion, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- district (type: esriFieldTypeInteger, alias: District, SQL Type: sqlTypeOther, nullable: true, editable: true)
- complete_date (type: esriFieldTypeDate, alias: Checklist Completion Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_type (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [safety: Safety], [mpo: MPO/COG], [interstate: Interstate Upgrade], ... 3 more ...)
- rpg (type: esriFieldTypeString, alias: RPG PM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- rpg_pm (type: esriFieldTypeString, alias: Funding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [federal: Federal], [state: State], [ctc: CTC], ... 1 more ...)
- letting_date (type: esriFieldTypeDate, alias: Letting Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- rce (type: esriFieldTypeString, alias: RCE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- other_rce (type: esriFieldTypeString, alias: Other RCE Representative, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- review (type: esriFieldTypeString, alias: Types of Review, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [partial: Partial Project Review], [full: Full Project Review])
- nepa_general (type: esriFieldTypeString, alias: General, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- nepa_file (type: esriFieldTypeString, alias: 1. Are all NEPA commitments on file, known, and accounted for?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas1 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- nepa_commitments (type: esriFieldTypeString, alias: 2. Are there Unique NEPA Commitments that need to be included in the Contract?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas2 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- environmental_site (type: esriFieldTypeString, alias: Environmental Site Assessment - Contamination, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ust_wells (type: esriFieldTypeString, alias: 3. UST or Monitoring Wells Onsite?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas3 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- well_plans (type: esriFieldTypeString, alias: 4. Are UST or Monitoring Well Plan (ESA Phase 1 or 2) included in the Contract and shown on Construction Plans?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas4 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- moratoriums (type: esriFieldTypeString, alias: Moratoriums, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- moratoria (type: esriFieldTypeString, alias: 5. Project Moratoria?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas5 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contract (type: esriFieldTypeString, alias: 19. Is the Permit in the Contract/Proposal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas6 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- bird_treaty (type: esriFieldTypeString, alias: Bird Treaty Act (MBTA), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- mbta_included (type: esriFieldTypeString, alias: 7. MBTA included as a NEPA Commitment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas7 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- usda_inspection (type: esriFieldTypeString, alias: 8. Does this project need to be on USDA list for MBTA inspection?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas8 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- nhpa_section (type: esriFieldTypeString, alias: National Historic Preservation Act (NHPA) Section 4f or Section 6f, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- section_4f (type: esriFieldTypeString, alias: 9. Section 4f impacts or Cemeteries listed as a NEPA Commitment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas9 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- orange_environment (type: esriFieldTypeString, alias: 10. Is temporary barrier fence included in the contract?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas10 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- endangered_species (type: esriFieldTypeString, alias: Endangered Species Act (Section 7), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- endangered_nepa (type: esriFieldTypeString, alias: 11. Section 7 impacts or Endangered Species listed as a NEPA Commitment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas11 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- provision (type: esriFieldTypeString, alias: 12. Is a Special Provision included in the contract, if needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [pending: Pending])
- tas12 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- temporary (type: esriFieldTypeString, alias: 13. Is Temporary Barrier Fencing included in the contract, if needed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable], ... 1 more ...)
- tas13 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- noaa_nmfs (type: esriFieldTypeString, alias: NOAA NMFS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- noaa_nm (type: esriFieldTypeString, alias: 14. Are there NOAA/NMFS NEPA Commitments?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas14 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- unique_com (type: esriFieldTypeString, alias: Unique Commitments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- unique_commitments (type: esriFieldTypeString, alias: 15. Are there other unique commitments?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas15 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- general_i (type: esriFieldTypeString, alias: General, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- usace_permit (type: esriFieldTypeString, alias: 16. Is a USACE permit required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas16 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- determination (type: esriFieldTypeString, alias: 17. Is the Permit Determination correct?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas17 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- drawings (type: esriFieldTypeString, alias: 18. Do the permitted impacts match the Construction Drawings?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [pending: Pending])
- tas18 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- tas19 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- perace (type: esriFieldTypeString, alias: 20. Per ACE permit, has proof of Wetland Mitigation been provided to USACE?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas20 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- acknowledge (type: esriFieldTypeString, alias: 21. Does proof of mitigation require USACE acknowledgment?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas21 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- threshold (type: esriFieldTypeString, alias: 22. For a GP, is the project close to GP Threshold for impacts?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas22 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- threshold1 (type: esriFieldTypeString, alias: 23. Are there Secondary impacts unaccounted for?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas221 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- permit_valid (type: esriFieldTypeString, alias: 24. Is the permit valid? (not expired), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas23 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ocean_and (type: esriFieldTypeString, alias: Bureau of Coastal Management (BCM), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- critical_area (type: esriFieldTypeString, alias: 25. Critical Area Permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)])
- tas24 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- czcletter (type: esriFieldTypeString, alias: 26. CZC Letter from BCM?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas25 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- constructible (type: esriFieldTypeString, alias: 27. Are all the Critical Area Special Conditions for Water Quality & Stormwater constructible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas26 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- consultant_email (type: esriFieldTypeString, alias: 28. Any Critical Area permit special conditions needed to be included in construction documents?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas27 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- monitoring (type: esriFieldTypeString, alias: Monitoring Report, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- monitoring_report (type: esriFieldTypeString, alias: 29. Is a monitoring report required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas28 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- causeway (type: esriFieldTypeString, alias: 30. Does Causeway Removal require a monitoring report?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas29 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- mitigation_site (type: esriFieldTypeString, alias: 31. Are there any restoration or mitigation sites that require monitoring?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas30 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- special_conditions (type: esriFieldTypeString, alias: Other Special Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- commitment_sc (type: esriFieldTypeString, alias: 32. Other documents referenced in S.C. as a Commitment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas31 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- stream_navigable (type: esriFieldTypeString, alias: 33. Is the Stream Navigable?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas32 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dhec_water (type: esriFieldTypeString, alias: 34. Who has jurisdiction over the navigable water?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [state: State (DES)], [federal: Federal (USCG)], [both: Both])
- scdhec (type: esriFieldTypeString, alias: 35. Is a DES Navigation Permit Required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas34 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- navigable_waters (type: esriFieldTypeString, alias: 36. Has the DES Permit for Construction in Navigable Waters been obtained?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)])
- tas35 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- proposal (type: esriFieldTypeString, alias: 37. Is the DES Permit included in the Contract/Proposal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)])
- tas36 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- required_permit (type: esriFieldTypeString, alias: 38. Is a USCG Permit Required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas38 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- uscg_navigation (type: esriFieldTypeString, alias: 39. Has the USCG Navigation permit been obtained?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [pending: Pending])
- tas39 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- uscg_pro (type: esriFieldTypeString, alias: 40. Is the USCG Permit included in the Contract/Proposal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [pending: Pending])
- tas40 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- achievable (type: esriFieldTypeString, alias: 41. If USCG obtained, are permit conditions achievable and who is responsible?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas41 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- doc_block (type: esriFieldTypeString, alias: 42. Is the Environmental Doc. Block accurate on the Cover Sheet?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas42 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- noi_disturbed (type: esriFieldTypeString, alias: 43. Does the Cover Sheet NOI Area match the Coverage Approval Letter?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas43 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- acres_disturbed (type: esriFieldTypeString, alias: 44. Is there a difference of 2 or 3 acres between the permitted area and disturbed area on the cover sheet?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas44 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- summary_estimated (type: esriFieldTypeString, alias: 45. Does the summary of estimated quantities section require Clearing and Grubbing within ROW?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 2 more ...)
- tas45 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- construct_plans (type: esriFieldTypeString, alias: 46. Do the Construction Plans match the USACE Permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable], ... 1 more ...)
- tas46 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- wetland_stream (type: esriFieldTypeString, alias: 47. Are Wetlends/Streams shown on the Construction Plans?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas47 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- usts_wells (type: esriFieldTypeString, alias: 48. Are Monitoring wells or USTs shown on the construction plans?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas48 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- location_based (type: esriFieldTypeString, alias: 49. Are the Sediment Dams/Basins constructible based on these locations?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas49 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- sediment_impact (type: esriFieldTypeString, alias: 50. Will the sediment dam/basin impact wetlands?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas50 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- vagetative_swale (type: esriFieldTypeString, alias: 51. Are there vegetative swales?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas51 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- bca_match (type: esriFieldTypeString, alias: 52. Does the BCA match the permit?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas52 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contractor_grub (type: esriFieldTypeString, alias: 53. Can the contractor Grub in the BCA?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas53 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- orange_barrier (type: esriFieldTypeString, alias: 54. Is temporary barrier fence needed along the NPDES line?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas54 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contractor_dewater (type: esriFieldTypeString, alias: 55. Can the contractor dewater for culvert replacement within the permitted limits?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas55 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- vicinity_project (type: esriFieldTypeString, alias: 56. If PD states No Permit Needed, are there wetlands in the project vicinity that may be of concern?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas56 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- slops (type: esriFieldTypeString, alias: 57. Do the plans have slopes greater than 2:1?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas57 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- jurisdictional (type: esriFieldTypeString, alias: 58. If walls are adjacent to wetlands, are the footers within permitted impact?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas58 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- ground_modification (type: esriFieldTypeString, alias: 59. Are Ground Modifications within the permitted impacts?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas59 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- compliant (type: esriFieldTypeString, alias: 60. Are scupper pads compliant?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable])
- tas60 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- mbta_provision (type: esriFieldTypeString, alias: 61. Is MBTA Special Provision needed for project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas61 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- mbta_contract (type: esriFieldTypeString, alias: 62. Is MBTA Special Provision included in the Contract?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)])
- tas62 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- fence_provision (type: esriFieldTypeString, alias: 63. You indicated yes to one of the questions above (10, 13, 16, and 55), therefore, a temporary barrier
fence is needed. Is the temporary barrier fence special provision included in the contract?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas64 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contract_proposal (type: esriFieldTypeString, alias: 64. Are all required permits in the Contract/ Proposal?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)], ... 1 more ...)
- tas65 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- nepa_commit (type: esriFieldTypeString, alias: 65. Are all Unique NEPA commitments included as a Special Provision?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable], ... 1 more ...)
- tas66 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- special_provision (type: esriFieldTypeString, alias: 66. Are all Unique USACE commitments included as a Special Provision? (if necessary) (i.e. survey required, timing), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)], [na: Not Applicable], ... 1 more ...)
- tas67 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- moamouusfs (type: esriFieldTypeString, alias: 67. Does the project have a MOA / MOU with USFS / NOAA/ USFWS/ County or other agency for this project?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [pending: Pending], [non: Non-Existent (No)])
- tas68 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- responsibilitymoa (type: esriFieldTypeString, alias: 68. Whose responsibility to abide by MOA/ MOU?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [scdot: SCDOT], [contractor: Contractor], [other: Other])
- tas69 (type: esriFieldTypeString, alias: Please list the name(s):, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- part_contract (type: esriFieldTypeString, alias: 69. Does it need to be a part of the Contract?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas70 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- answer (type: esriFieldTypeString, alias: Based on your answers to the above questions (2, 16, 55 or 61), inspections are required., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- usde_inspection (type: esriFieldTypeString, alias: Based on your answers to the above questions (7, 8 or 61), USDA will need to inspect the project., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- spreadsheet (type: esriFieldTypeString, alias: 70. Is the MBTA spreadsheet up to date?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Complete (Yes)], [non: Non-Existent (No)])
- tas74 (type: esriFieldTypeString, alias: Tasks/ Remarks, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- dot_staff (type: esriFieldTypeString, alias: SCDOT Compliance Staff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [chrisn: Chris Neely], [jessicak: Jessica Kennedy], [michaelj: Michael Queen])
- email (type: esriFieldTypeString, alias: Email of the SCDOT Compliance Staff, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- projectwise (type: esriFieldTypeString, alias: Please list the links for the ProjectWise, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- other_funding_type (type: esriFieldTypeString, alias: Other Funding Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/10/2025 5:28:52 PM
Schema Last Edit Date: 4/10/2025 5:28:52 PM
Data Last Edit Date: 4/10/2025 5:28:52 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat