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":"Restroom Access Drayage Trucker and Motorcarrier","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:

Name : objectid

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)
• language_access (type: esriFieldTypeString, alias: Primary Language, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [English: English], [Spanish: Español], [Vietnamese: Tiếng Việt], ... 37 more ...)
• language_other (type: esriFieldTypeString, alias: Not listed, please specify:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• driver_type (type: esriFieldTypeString, alias: What type of driver are you?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [drayage_trucker: Drayage Trucker], [motor_carrier: Motor Carrier])
• complaint_issue (type: esriFieldTypeString, alias: Complaint Issue, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• complaint_other (type: esriFieldTypeString, alias: Please specify below:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• facility_reach_out (type: esriFieldTypeString, alias: Did you try to reach out to staff to request access to the restroom?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• facility_reason (type: esriFieldTypeString, alias: Was there a reason given as to why you could not access the restroom?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• port_name (type: esriFieldTypeString, alias: Name of Port, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [anacortes: Port of Anacortes], [bellingham: Port of Bellingham], [benton: Port of Benton], ... 70 more ...)
• port_other (type: esriFieldTypeString, alias: Please specify below:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• terminal_park (type: esriFieldTypeString, alias: Name of Terminal/Park, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• terminal_park_other (type: esriFieldTypeString, alias: Please specify below:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• locationbusiness_name (type: esriFieldTypeString, alias: Name of Business, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• picking_up_or_dropping (type: esriFieldTypeString, alias: Were you picking up or dropping off at this location?, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• time_at_location (type: esriFieldTypeString, alias: Do you know what time you were at the location?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• time_describe (type: esriFieldTypeString, alias: Please describe why time is unknown, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t1 (type: esriFieldTypeDate, alias: Arrival time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• t2 (type: esriFieldTypeDate, alias: Departure time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• approx_total_time (type: esriFieldTypeString, alias: Total time at location (min), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• issue_description (type: esriFieldTypeString, alias: Please explain what happened providing as much detail as possible, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• first_name (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_name (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• phone_number (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sub_date (type: esriFieldTypeDate, alias: Submission Date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ticketID (type: esriFieldTypeString, alias: Confirmation Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• case_number (type: esriFieldTypeString, alias: Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• person_id (type: esriFieldTypeString, alias: Person ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [new: New Complaint], [in_review: In Review], [closed: Closed])
• cc_process (type: esriFieldTypeString, alias: Complaint Contact Tracking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_date1 (type: esriFieldTypeDate, alias: 1st contact date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_date2 (type: esriFieldTypeDate, alias: 2nd contact date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_date3 (type: esriFieldTypeDate, alias: 3rd contact date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_username1 (type: esriFieldTypeString, alias: cc_username1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_edit1 (type: esriFieldTypeString, alias: 1st contact by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_username2 (type: esriFieldTypeString, alias: cc_username2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_edit2 (type: esriFieldTypeString, alias: 2nd contact by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_username3 (type: esriFieldTypeString, alias: cc_username3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cc_edit3 (type: esriFieldTypeString, alias: 3rd contact by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gate_restroom (type: esriFieldTypeString, alias: Are there restrooms to use anywhere before or in the gate?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• gate_restroom_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• drive_wait_time (type: esriFieldTypeString, alias: Do you or your employer track your drive/wait times?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• drive_wait_time_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_process (type: esriFieldTypeString, alias: Business Contact Tracking, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_date1 (type: esriFieldTypeDate, alias: 1st contact date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_date2 (type: esriFieldTypeDate, alias: 2nd contact date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_date3 (type: esriFieldTypeDate, alias: 3rd contact date/time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_username1 (type: esriFieldTypeString, alias: bc_username1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_edit1 (type: esriFieldTypeString, alias: 1st contact by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_username2 (type: esriFieldTypeString, alias: bc_username2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_edit2 (type: esriFieldTypeString, alias: 2nd contact by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_username3 (type: esriFieldTypeString, alias: bc_username3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bc_edit3 (type: esriFieldTypeString, alias: 3rd contact by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• referred (type: esriFieldTypeString, alias: Forwarded or Referral, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• referred_other (type: esriFieldTypeString, alias: Other, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lni_contact_method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lni_contact_name (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lni_email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lni_message (type: esriFieldTypeString, alias: Email Message, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• Ini_username (type: esriFieldTypeString, alias: Ini_username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lni_date_phone (type: esriFieldTypeDate, alias: Date and time called, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lni_date_email (type: esriFieldTypeDate, alias: Date and time emailed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enforce_contact_method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enforce_contact_name (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enfore_email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enforce_message (type: esriFieldTypeString, alias: Email Message, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• ref_enforce_username (type: esriFieldTypeString, alias: ref_enforce_username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enforce_date_phone (type: esriFieldTypeDate, alias: Date and time called, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• enforce_date_email (type: esriFieldTypeDate, alias: Date and time emailed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lhj_name (type: esriFieldTypeString, alias: Select the LHJ, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [adams: Adams County Integrated Health Care Services], [asotin: Asotin County Public Health], [benton: Benton-Franklin Health District], ... 32 more ...)
• lhj_contact_method (type: esriFieldTypeString, alias: Method, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lhj_contact_name (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lhj_email (type: esriFieldTypeString, alias: Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lhj_message (type: esriFieldTypeString, alias: Email Message, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• lhj_username (type: esriFieldTypeString, alias: lhj_username, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lhj_date_phone (type: esriFieldTypeDate, alias: Date and time called, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lhj_date_email (type: esriFieldTypeDate, alias: Date and time emailed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• investigator_notes (type: esriFieldTypeString, alias: Investigation Notes, SQL Type: sqlTypeOther, length: 1000000, 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)

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: 2/26/2025 1:04:02 AM

Schema Last Edit Date: 2/26/2025 1:04:02 AM

Data Last Edit Date: 4/13/2024 12:32:37 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat