Name: survey
Display Field: objectid
Type: Feature Layer
Geometry Type: esriGeometryPoint
Has Views: true
Source Schema Changes Allowed: true
Views
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":"Inspection Form","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: true
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)
- inspector_name (type: esriFieldTypeString, alias: Inspector Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- inspection_date_time (type: esriFieldTypeDate, alias: Inspection Date & Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- inspection_report_number (type: esriFieldTypeString, alias: Inspection Report Number, 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, Coded Values: [AerationBasin: Aeration Basin 001 - Diffusers and Gaskets], [BASUpgrade: BAS Upgrade Project], [BluePillar: Blue Pillar Monitoring System], ... 32 more ...)
- contractor_name (type: esriFieldTypeString, alias: Contractor Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contractor_superintendent_name (type: esriFieldTypeString, alias: Contractor Superintendent Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- inspection_type (type: esriFieldTypeString, alias: Inspection Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- list_of_equipment_materials_del (type: esriFieldTypeString, alias: List of Equipment / Materials Delivered To Site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- general_description_of_work_bei (type: esriFieldTypeString, alias: General Description of Work Being Performed TODAY On Project, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- weather_raining (type: esriFieldTypeString, alias: Weather (Raining), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- weather_temperature (type: esriFieldTypeString, alias: Weather (Temperature), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- contractors_on_site (type: esriFieldTypeString, alias: Contractors on site?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- if_yes_which_firms (type: esriFieldTypeString, alias: If yes, which firms?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_work_performed_on_site_toda (type: esriFieldTypeString, alias: Was work performed on site today?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- if_no_please_list_why (type: esriFieldTypeString, alias: If no, please list why, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_heavy_equipment_used_on_sit (type: esriFieldTypeString, alias: Was heavy equipment used on site today?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- if_yes_please_explain_why (type: esriFieldTypeString, alias: If yes, please explain why, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- is_quality_of_work_satisfactory (type: esriFieldTypeString, alias: Is quality of work satisfactory?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- if_not_please_list_why (type: esriFieldTypeString, alias: If not, please list why?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_all_contracted_work_inspect (type: esriFieldTypeString, alias: Was all contracted work inspected today?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_35 (type: esriFieldTypeString, alias: If not, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_materials_were_delivered_wer (type: esriFieldTypeString, alias: If materials were delivered, were they satisfactory?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_36 (type: esriFieldTypeString, alias: If not, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- any_damages_to_tamu_property (type: esriFieldTypeString, alias: Any damages to TAMU property?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_37 (type: esriFieldTypeString, alias: If yes, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_any_insulation_removed (type: esriFieldTypeString, alias: Was any insulation removed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- if_insulation_was_removed_was_a (type: esriFieldTypeString, alias: If insulation was removed, was an asbestos sample taken?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- why_was_an_asbestos_sample_not_ (type: esriFieldTypeString, alias: Why was an asbestos sample not taken?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_excavation_or_digging_requi (type: esriFieldTypeString, alias: Was excavation, digging, and/or boring required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_49 (type: esriFieldTypeString, alias: If yes, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_yes_were_locates_called_in (type: esriFieldTypeString, alias: If yes, were locates called in?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_53 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_yes_was_the_excavation_andor (type: esriFieldTypeString, alias: If yes, was the excavation and/or boring plan review & approval completed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_54 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- if_yes_is_the_proper_shoring_in (type: esriFieldTypeString, alias: If yes, is the proper shoring in place?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_55 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- are_ppe_requirements_being_foll (type: esriFieldTypeString, alias: Are PPE requirements being followed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_56 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_a_lifting_crane_permit_post (type: esriFieldTypeString, alias: Was a crane lift performed?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_58 (type: esriFieldTypeString, alias: If yes, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_a_crane_permit_sent (type: esriFieldTypeString, alias: Was a crane lift permit sent?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_58a (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- storm_water_pollution_plan_required (type: esriFieldTypeString, alias: Is a storm water pollution plan required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- was_a_storm_water_permit_posted (type: esriFieldTypeString, alias: Was a storm water pollution plan posted?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_59 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- was_tree_protection_in_place_wh (type: esriFieldTypeString, alias: Was tree protection in place where required?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- field_60 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- were_there_ues_provided_materia (type: esriFieldTypeString, alias: Were there UES provided materials?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_62 (type: esriFieldTypeString, alias: If yes, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- is_this_project_on_schedule (type: esriFieldTypeString, alias: Is this project on schedule?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_63 (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- any_unusual_happenings_to_be_re (type: esriFieldTypeString, alias: Any unusual happenings to be reported?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_64 (type: esriFieldTypeString, alias: If yes, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- describe_impact_weather_has_had (type: esriFieldTypeString, alias: Describe impact weather has had on project today, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- describe_any_corrective_recomme (type: esriFieldTypeString, alias: Describe any corrective recommendations / requirements, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- list_any_other_observations_fee (type: esriFieldTypeString, alias: List any other observations / feeback, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- any_additional_observations_fee (type: esriFieldTypeString, alias: Any additional observations / feedback?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- additional_observations_feedbac (type: esriFieldTypeString, alias: Additional observations / feedback, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- project_manager_title (type: esriFieldTypeString, alias: Project Manager Title, 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)
- was_cutting_required (type: esriFieldTypeString, alias: Does the work reuired cutting, welding, and/or spark producing?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- was_cutting_permit_present (type: esriFieldTypeString, alias: If yes, was a permit present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_55a (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- high_potential_system_isolation_required (type: esriFieldTypeString, alias: Does the work required isolation of high potential systems (ie., electricity, steam, heating hot water, etc.)?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- was_isolation_permit_present (type: esriFieldTypeString, alias: If yes, was a permit present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_55b (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- confined_space_required (type: esriFieldTypeString, alias: Does the work require working in a confined space?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [n_a: N/A])
- confined_space_permit_present (type: esriFieldTypeString, alias: If yes, was a permit present, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
- field_55c (type: esriFieldTypeString, alias: If no, please explain, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Relationships:
- Inspection_Form_photos (1) -- Related To: photos (1)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 1/27/2021 1:46:47 PM
Schema Last Edit Date: 1/27/2021 1:46:47 PM
Data Last Edit Date: 1/27/2021 1:46:47 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat