All Layers and Tables (service_f3ed641aeabf43178519aafc8e4b01bb)

Layers:

Layer: survey (0)

Name:

Display Field:

Type:

Geometry Type:

Has Views:

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:

{"renderer":{"symbol":{"color":[0,178,255,48],"outline":{"color":[0,178,255,255],"style":"esriSLSSolid","type":"esriSLS","width":2},"style":"esriSFSSolid","type":"esriSFS"},"type":"simple","label":"Washington DWSRF Assistance Request Form"},"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: sqlTypeGUID, length: 38, nullable: false, editable: false)
county_url (type: esriFieldTypeString, alias: county_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
dws_url (type: esriFieldTypeString, alias: dws_url, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
water_system_relationship (type: esriFieldTypeString, alias: Your relationship to water system, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [operator: Operator], [board_member: Board member], [clerk_treasurer: Clerk/treasurer], ... 4 more ...)
water_system_relationship_other (type: esriFieldTypeString, alias: Other, please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
name (type: esriFieldTypeString, alias: Your name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
phone_number (type: esriFieldTypeString, alias: Your phone number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
email (type: esriFieldTypeString, alias: Your email address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
water_system_primary_contact_yes_no (type: esriFieldTypeString, alias: Are you the primary contact person for this water system?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [other: Other])
water_system_primary_contact_yes_no_other (type: esriFieldTypeString, alias: Other, please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
county (type: esriFieldTypeString, alias: County where water system is located., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [adams_county: Adams], [asotin_county: Asotin], [benton_county: Benton], ... 36 more ...)
ws_name_provided (type: esriFieldTypeString, alias: Name of water system(s), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assitance_request_categories (type: esriFieldTypeString, alias: What does this system need help with?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assitance_request_categories_other (type: esriFieldTypeString, alias: Other, please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assistance_request_need (type: esriFieldTypeString, alias: Describe what this system needs assistance with., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assistance_request_other (type: esriFieldTypeString, alias: Describe any other information related to this request., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
request_date (type: esriFieldTypeDate, alias: Date of Request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
satellite_mgt (type: esriFieldTypeString, alias: Does the system have a certified operator or satellite management agency?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
satellite_contact (type: esriFieldTypeString, alias: Name, Phone, Email, Involvement in this request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
gov_body (type: esriFieldTypeString, alias: Does the water system have a governing body able to make decisions and willing to engage with a TA provider?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ta_req (type: esriFieldTypeString, alias: Has the system requested technical assistance from other providers?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [epa_water_ta: EPA Water TA], [iacc: IACC], [rcac: RCAC], ... 2 more ...)
ta_req_other (type: esriFieldTypeString, alias: Please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
followup_datetime (type: esriFieldTypeDate, alias: Date of follow up, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
notes_assistance_req (type: esriFieldTypeString, alias: Notes on specific assistance requested, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
operator_sma (type: esriFieldTypeString, alias: Current operator or SMA, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ta_past (type: esriFieldTypeString, alias: Has the system received technical assistance in the past?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
ta_past_what (type: esriFieldTypeString, alias: For what and from who?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
system_restructure (type: esriFieldTypeString, alias: Has the system considered restructuring or consolidating?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
infrastructure_improve_plans (type: esriFieldTypeString, alias: Describe infrastructure improvement projects ongoing or plans for future., SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
dwsrf_funding (type: esriFieldTypeString, alias: System and DWSRF/funding, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
dwsrf_funding_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
needs_priority (type: esriFieldTypeString, alias: Current Priority Needs of System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
goals_ta (type: esriFieldTypeString, alias: Goals and Intended Outcomes of Technical Assistance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
consolidation_potential_notes (type: esriFieldTypeString, alias: Notes on consolidation potential, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
regional_support_ta (type: esriFieldTypeString, alias: Regional support in system(s) receiving TA for this request, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
prov_contacted (type: esriFieldTypeString, alias: Providers contacted to inquire about assignment (check all that apply), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
prov_contacted_other (type: esriFieldTypeString, alias: Please describe, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
coord_notes (type: esriFieldTypeString, alias: Coordination notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
water_system_tribe_owned (type: esriFieldTypeString, alias: Is this water system owned or operated by a Federally recognized tribe?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
ws_serve_residences_primarily (type: esriFieldTypeString, alias: Does this water system primarily serve residential connections?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [unknown: Unknown])
provider_contact_lead (type: esriFieldTypeString, alias: Provider contact/lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
workplan_notes (type: esriFieldTypeString, alias: Workplan notes:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
external_coord_meeting_date (type: esriFieldTypeDate, alias: External coordination meeting with TA Provider & DOH staff date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
kick_off_meeting_date (type: esriFieldTypeDate, alias: Kick off meeting with TA Provider, DOH staff, and PWS date, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
planning_doc_type (type: esriFieldTypeString, alias: Planning document type, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true, Coded Values: [swsmp: SWSMP], [wsp: WSP])
Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
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)
case_number (type: esriFieldTypeString, alias: Case Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Relationships:

Form_14_internal_coord (1) -- Related To: internal_coord (1)
Form_14_contacts (2) -- Related To: contacts (2)
Form_14_ta_assignment (3) -- Related To: ta_assignment (3)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

Tables:

internal_coord (1)

Name:

Display Field:

Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
county_pulled (type: esriFieldTypeString, alias: County of the Public Water System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pwsname (type: esriFieldTypeString, alias: Select a public water system, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pwsname_other (type: esriFieldTypeString, alias: Please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ws_id (type: esriFieldTypeString, alias: Water System ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
tribal_system_name (type: esriFieldTypeString, alias: Water System name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
pop_size_served (type: esriFieldTypeInteger, alias: Population size served, SQL Type: sqlTypeOther, nullable: true, editable: true)
num_connections (type: esriFieldTypeInteger, alias: Number of connections, SQL Type: sqlTypeOther, nullable: true, editable: true)
dac_yes_no (type: esriFieldTypeString, alias: System serves a disadvantaged community?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
regional_engineer (type: esriFieldTypeString, alias: Regional Engineer, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
regional_planner (type: esriFieldTypeString, alias: Regional Planner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
planning_doc_notes (type: esriFieldTypeString, alias: Planning Document Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
system_notes (type: esriFieldTypeString, alias: Notes on system compliance, capacity, planning issues/history:, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:

Form_14_internal_coord (1) -- Related To: survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

contacts (2)

Name:

Display Field:

Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
contact_name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contact_phone_number (type: esriFieldTypeString, alias: Phone, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
contact_email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:

Form_14_contacts (2) -- Related To: survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date:

ta_assignment (3)

Name:

Display Field:

Type:

Has Views:

Source Schema Changes Allowed:

Description:

Copyright Text:

Max Record Count:

Supported query Formats:

Use Standardized Queries:

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: sqlTypeGUID, length: 38, nullable: false, editable: false)
assignment_status (type: esriFieldTypeString, alias: Assignment status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [active: Active Assignment], [closed_complete: Closed/Complete], [inactive_onhold: Inactive/On Hold], ... 4 more ...)
prov_assigned (type: esriFieldTypeString, alias: Provider assigned, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [rural_communitie_assistance_corporation: Rural Communities Assistance Corporation], [celerity_consulting_group_llc: Celerity Consulting Group, LLC], [public_knowledge: Public Knowledge], ... 9 more ...)
prov_assigned_other (type: esriFieldTypeString, alias: Please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ta_hub (type: esriFieldTypeString, alias: Technical Assistance Hub, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ta_description (type: esriFieldTypeString, alias: Technical Assistance Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ta_description_other (type: esriFieldTypeString, alias: Please specify, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
assign_specifics_deliverables (type: esriFieldTypeString, alias: Assignment specifics and deliverables, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
anticipated_timeline (type: esriFieldTypeString, alias: Anticipated timeline, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
date_closed (type: esriFieldTypeDate, alias: Date of Closeout, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
duration_project (type: esriFieldTypeString, alias: Duration of project assignment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
priority_needs_addressed (type: esriFieldTypeString, alias: Priority needs addressed through TA by:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
goals_outcomes_met (type: esriFieldTypeString, alias: Goals and intended outcomes met:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
system_tmf_increased_how (type: esriFieldTypeString, alias: System has now increased TMF in following ways:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
parentglobalid (type: esriFieldTypeGUID, alias: ParentGlobalID, SQL Type: sqlTypeGUID, length: 38, 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)

Relationships:

Form_14_ta_assignment (3) -- Related To: survey (0)

Is Data Versioned:

Has Contingent Values:

Supports Rollback On Failure Parameter:

Last Edit Date:

Schema Last Edit Date:

Data Last Edit Date: