All Layers and Tables (Project_Tracker_View

Layers:

Layer: survey (0)

Name:

Display Field:

Type:

Geometry Type:

Is View:

Is Updatable View:

Source Schema Changes Allowed:

Description:

Copyright Text:

Min. Scale:

Max. Scale:

Default Visibility:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

Extent:

Drawing Info:

{"labelingInfo":null,"renderer":{"label":"Survey Point","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:

HasM:

Has Attachments:

Has Geometry Properties:

HTML Popup Type:

Object ID Field:

Unique ID Field:

Global ID Field:

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: sqlTypeOther, length: 38, nullable: false, 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)
job_type (type: esriFieldTypeString, alias: Job Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Water: Water], [Sewer: Sewer])
job_number (type: esriFieldTypeString, alias: Water Job Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
job_name (type: esriFieldTypeString, alias: Job Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
inspector_name (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
precon (type: esriFieldTypeString, alias: Precon, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
precon_timestamp (type: esriFieldTypeDate, alias: Precon Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
installation_began (type: esriFieldTypeString, alias: Installation Began, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
beginning_installation_timestam (type: esriFieldTypeDate, alias: Beginning Installation Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
installation_complete (type: esriFieldTypeString, alias: Installation Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
installation_complete_timestamp (type: esriFieldTypeDate, alias: Installation Complete Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
testing_phase_start (type: esriFieldTypeString, alias: Testing Phase Start, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
testing_phase_timestamp (type: esriFieldTypeDate, alias: Testing Phase Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
punch_list_provided (type: esriFieldTypeString, alias: Punch List Provided, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
punch_list_provided_timestamp (type: esriFieldTypeDate, alias: Punch List Provided Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
punch_list_complete (type: esriFieldTypeString, alias: Punch List Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
testing_phase_complete (type: esriFieldTypeString, alias: Testing Phase Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
testing_phase_complete_timestam (type: esriFieldTypeDate, alias: Testing Phase Complete Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
final_tie_in_complete (type: esriFieldTypeString, alias: Final Tie In Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
final_tie_in_timestamp (type: esriFieldTypeDate, alias: Final Tie In Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
as_builtsredlines_complete (type: esriFieldTypeString, alias: As Builts/Redlines Complete, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
as_builtsredlines_timestamp (type: esriFieldTypeDate, alias: As Builts/Redlines Timestamp, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
sewer_job_number (type: esriFieldTypeString, alias: Sewer Job Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
general_expectations (type: esriFieldTypeString, alias: General, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [G1: All methods and materials must abide by the standards set forth by C.E.G.], [G2: Safe work practices in accordance with all federal, state, and local regulations], [G3: All problems or concerns shall be communicated to the project inspector.], ... 1 more ...)
per_plan (type: esriFieldTypeString, alias: Explain expectation to build per plan, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: Yes])
Issues_with_current_plans (type: esriFieldTypeString, alias: Issues with current plans, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Working_Hours (type: esriFieldTypeString, alias: Working Hours, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Expectations_Explained (type: esriFieldTypeString, alias: Expectations Explained?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
structure_materials (type: esriFieldTypeString, alias: Correct materials used for structures?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
structure_damage (type: esriFieldTypeString, alias: Structures are free of damage/defects?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
if_damaged_structure (type: esriFieldTypeString, alias: If damaged, can structure be repaired?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
lifting_apparatus (type: esriFieldTypeString, alias: Correct lifting apparatus for structures?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
sealing_materials (type: esriFieldTypeString, alias: Correct sealing materials on site for structures?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Structure_Manufacturer (type: esriFieldTypeString, alias: Structure Manufacturer, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
pipe_materials (type: esriFieldTypeString, alias: Correct Materials for Pipe?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
pipe_damage (type: esriFieldTypeString, alias: Pipe free of damage/defects?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Pipe_is_clean (type: esriFieldTypeString, alias: Pipe is clean?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
pipe_color (type: esriFieldTypeString, alias: Correct color used for pipe?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
lid_markings (type: esriFieldTypeString, alias: Lids have appropriate markings?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Correct_Castings (type: esriFieldTypeString, alias: Correct Castings?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Yes: No], [Yes0: Yes])
Correct_risers (type: esriFieldTypeString, alias: Correct risers?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
rings_damage (type: esriFieldTypeString, alias: Lids, castings, riser rings free of damage/defects?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
chimney_seal (type: esriFieldTypeString, alias: Contractor aware of chimney seal standards?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
wire_gauge (type: esriFieldTypeString, alias: Wire is correct gauge and color?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
staking_complete (type: esriFieldTypeString, alias: Structures and fittings have been staked?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
locates_completed (type: esriFieldTypeString, alias: Utility locates have been conducted?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
force_main_materials (type: esriFieldTypeString, alias: Correct force main materials?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes], [N/A: N/A])
Correct_valvesARVs_on_site (type: esriFieldTypeString, alias: Correct valves/ARVs on site?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes], [N/A: N/A])
tracing_stations (type: esriFieldTypeString, alias: Contractor is aware of need for tracing stations every 500'?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes], [N/A: N/A])
Meeting_Notes (type: esriFieldTypeString, alias: Meeting Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
notes_materials (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
notes_structure_damage (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
notes_if_damaged_st (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
notes_lids (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
notes_staking (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Heavy_Wall_Fittings (type: esriFieldTypeString, alias: Heavy Wall Fittings?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
notes_fittings (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
General_Expt (type: esriFieldTypeString, alias: General Expectations, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [G1: All materials must abide by C.E.G standards.], [G2: Expectations on safety were mentioned in the meeting.], [G3: Problems or concerns will be brought to project inspector.], ... 2 more ...)
gen_exp (type: esriFieldTypeString, alias: General Expectations, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Hydrostatic (type: esriFieldTypeString, alias: Hydrostatic Pass?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Hydrostatic_Pass_Date (type: esriFieldTypeDate, alias: Hydrostatic Pass Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Water_Expectations_Explained (type: esriFieldTypeString, alias: Expectations Explained?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Water_Meeting_Notes (type: esriFieldTypeString, alias: Meeting Notes, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Water_Working_Hours (type: esriFieldTypeString, alias: Working Hours, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
Water_Issues_with_current_plans (type: esriFieldTypeString, alias: Issues with current plans, SQL Type: sqlTypeOther, length: 10000, nullable: true, editable: true)
water_materials (type: esriFieldTypeString, alias: Correct materials for water main and fittings?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Notes_Water_Main_and_Fittings (type: esriFieldTypeString, alias: Notes: Water Main and Fittings, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
water_defects (type: esriFieldTypeString, alias: Materials free of damage/defects?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Notes_Materials_free_of_damage (type: esriFieldTypeString, alias: Notes: Materials free of damage, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
water_pipe_swab (type: esriFieldTypeString, alias: Pipe swabbing materials on site?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_materials_clean (type: esriFieldTypeString, alias: Materials clean and protected?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_poly_wrap (type: esriFieldTypeString, alias: Correct poly wrap?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_hydrants_manufacturer (type: esriFieldTypeString, alias: Hydrants correct manufacturer?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_hydrants_color (type: esriFieldTypeString, alias: Hydrants correct color?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_hydrant_depth (type: esriFieldTypeString, alias: Hydrants correct bury depth?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_valve_manufacturer (type: esriFieldTypeString, alias: Valve are correct manufacturer?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_valve_direction (type: esriFieldTypeString, alias: Valves are correct open direction?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_tracer_color (type: esriFieldTypeString, alias: Tracer wire correct gauge and color?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_tracer_connector (type: esriFieldTypeString, alias: Correct tracer wire connector?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_pits_lids (type: esriFieldTypeString, alias: Correct lids for meter pits?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_pits_taps (type: esriFieldTypeString, alias: Service line tap saddles/taps are correct materials?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_pits_inserts (type: esriFieldTypeString, alias: Correct inserts for service line?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_pits_setters (type: esriFieldTypeString, alias: Correct E-Z Setters?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_staking (type: esriFieldTypeString, alias: Staking complete?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_utility (type: esriFieldTypeString, alias: Utility locates for conflict areas?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_grade (type: esriFieldTypeString, alias: Project is at correct grade?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_materials_onsite (type: esriFieldTypeString, alias: All materials on site?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
water_stamped_plans (type: esriFieldTypeString, alias: Contractor has stamped plans?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
Reach (type: esriFieldTypeString, alias: Reach, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Additional_Attendee_1 (type: esriFieldTypeString, alias: Additional Attendee Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Additional_Attendee_2 (type: esriFieldTypeString, alias: Additional Attendee Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Additional_Attendee_3 (type: esriFieldTypeString, alias: Additional Attendee Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Additional_Attendee_Water_3 (type: esriFieldTypeString, alias: Additional Attendee Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Additional_Attendee_Water_2 (type: esriFieldTypeString, alias: Additional Attendee Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Additional_Attendee_Water_1 (type: esriFieldTypeString, alias: Additional Attendee Email, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Flowline (type: esriFieldTypeString, alias: 12" Flowline?, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])

Templates:

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

All Layers and Tables (Project_Tracker_View_Layer)

Layers:

Layer: survey (0)