Layers:

Layer: Work Order Channels (0)

Name: Work Order Channels

Display Field: ReachNum

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 6000851.048372135
YMin: 2095657.1187086403
XMax: 6165363.7921806425
YMax: 2292161.268022388
Spatial Reference: 102646  (2230)



Drawing Info:
Renderer:
Class Breaks Renderer:
Field: Work_Order_Count
Min. Value: 1.0
ClassBreakInfos:
• Class Maximum Value: 24
  Label: 1 - 24
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [255, 224, 224, 255]
  Width: 2
• Class Maximum Value: 89
  Label: 25 - 89
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [235, 165, 155, 255]
  Width: 2
• Class Maximum Value: 212
  Label: 90 - 212
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [207, 112, 95, 255]
  Width: 2
• Class Maximum Value: 901
  Label: 213 - 901
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [176, 65, 48, 255]
  Width: 2
• Class Maximum Value: 5674
  Label: 902 - 5674
  Description:
  Symbol:
  Style: esriSLSSolid
  Color: [143, 10, 10, 255]
  Width: 2
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• Work_Order_Count ( type: esriFieldTypeInteger, alias: Work Orders Per Reach, editable: true, nullable: true, defaultValue: null, modelName: Work_Order_Count )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ReachNum ( type: esriFieldTypeString, alias: ReachNum, editable: true, nullable: true, length: 14, defaultValue: null, modelName: ReachNum )
• Shape_STLength_1 ( type: esriFieldTypeDouble, alias: Shape_STLength_1, editable: true, nullable: false, defaultValue: null, modelName: Shape_STLength_1 )
Templates:
• Name: Work Order Channels
  Description:
  Prototype:
  ReachNum: null
  Work_Order_Count: null
  Shape_STLength_1: 0
  
  Drawing Tool: esriFeatureEditToolLine

Layer: Channels (1)

Name: Channels

Display Field: FACILITYNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The original linework was directly converted from MicroStation CAD files without much corrections, therefore the database undergoes continual editing of channel alignments to be spatially accurate when overlaid with OC Survey parcel landbase. Where needed, as-built plan sheets were georeferenced and channel alignments traced from the sheets. The "Data of Data" field indicates when the channel segment was corrected or otherwise confirmed to be accurate.

Copyright Text: Flood Programs

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 5976449.843893796
YMin: 2061794.4108436406
XMax: 6307693.094463721
YMax: 2352467.7779865563
Spatial Reference: 102646  (2230)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 0]
Width: 1
Label:
Description:
Transparency: 0
Labeling Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FacilityID ( type: esriFieldTypeInteger, alias: FacilityID, editable: true, nullable: true, defaultValue: null, modelName: FacilityID )
• FacilitySystem ( type: esriFieldTypeString, alias: FacilitySystem, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilitySystem )
• FacilityType ( type: esriFieldTypeString, alias: FacilityType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FacilityType )
• Ownership ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Ownership )
• OwnerType ( type: esriFieldTypeString, alias: OwnerType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OwnerType )
• Watershed ( type: esriFieldTypeString, alias: Watershed, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Watershed )
• ReachNum ( type: esriFieldTypeString, alias: ReachNum, editable: true, nullable: true, length: 14, defaultValue: null, modelName: ReachNum )
• ReachDesc ( type: esriFieldTypeString, alias: ReachDesc, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ReachDesc )
• StaDS ( type: esriFieldTypeString, alias: StaDS, editable: true, nullable: true, length: 7, defaultValue: null, modelName: StaDS )
• StaUS ( type: esriFieldTypeString, alias: StaUS, editable: true, nullable: true, length: 7, defaultValue: null, modelName: StaUS )
• Length ( type: esriFieldTypeInteger, alias: Length, editable: true, nullable: true, defaultValue: null, modelName: Length )
• FacilityDesc ( type: esriFieldTypeString, alias: FacilityDesc, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FacilityDesc )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Material )
• Base ( type: esriFieldTypeDouble, alias: Base, editable: true, nullable: true, defaultValue: null, modelName: Base )
• Height ( type: esriFieldTypeDouble, alias: Height, editable: true, nullable: true, defaultValue: null, modelName: Height )
• DwgID ( type: esriFieldTypeInteger, alias: DwgID, editable: true, nullable: true, defaultValue: null, modelName: DwgID )
• DrawingNum ( type: esriFieldTypeString, alias: DrawingNum, editable: true, nullable: true, length: 16, defaultValue: null, modelName: DrawingNum )
• Note ( type: esriFieldTypeString, alias: Note, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Note )
• PermitNum ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 20, defaultValue: NA, modelName: PermitNum )
• DateofData ( type: esriFieldTypeDate, alias: DateofData, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateofData )
• MSTAR_ASSET ( type: esriFieldTypeString, alias: MSTAR_ASSET, editable: true, nullable: true, length: 25, defaultValue: CULVERT, modelName: MSTAR_ASSET )
• FACILITYNAME ( type: esriFieldTypeString, alias: FACILITYNAME, editable: true, nullable: true, length: 70, defaultValue: null, modelName: FACILITYNAME )
• MStar_User ( type: esriFieldTypeString, alias: MStar_User, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MStar_User )
• Shape_STLength_1 ( type: esriFieldTypeDouble, alias: Shape_STLength_1, editable: true, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• Rank ( type: esriFieldTypeDouble, alias: Rank, editable: true, nullable: true, defaultValue: null, modelName: Rank )
• ProjectName ( type: esriFieldTypeString, alias: ProjectName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectName )
• ProjectNum ( type: esriFieldTypeString, alias: ProjectNum, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ProjectNum )
• ReachRank ( type: esriFieldTypeDouble, alias: ReachRank, editable: true, nullable: true, defaultValue: null, modelName: ReachRank )
• FACILITYNUMBER ( type: esriFieldTypeString, alias: FACILITYNUMBER, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FACILITYNUMBER )
• PrjCost ( type: esriFieldTypeDouble, alias: PrjCost, editable: true, nullable: true, defaultValue: null, modelName: PrjCost )
• OM_Assigned_Area ( type: esriFieldTypeSmallInteger, alias: OM_Assigned_Area, editable: true, nullable: true, defaultValue: null, modelName: OM_Assigned_Area )
• inspect_status_fall ( type: esriFieldTypeString, alias: inspect_status_fall, editable: true, nullable: true, length: 20, defaultValue: null, modelName: inspect_status_fall )
• inspect_status_spring ( type: esriFieldTypeString, alias: inspect_status_spring, editable: true, nullable: true, length: 20, defaultValue: null, modelName: inspect_status_spring )
• OM_Inspect_Req ( type: esriFieldTypeString, alias: OM_Inspect, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OM_Inspect_Req )
• mip_year ( type: esriFieldTypeString, alias: mip_year, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mip_year )
• miles_length ( type: esriFieldTypeDouble, alias: miles_length, editable: true, nullable: true, defaultValue: null, modelName: miles_length )
• reach_mip_year ( type: esriFieldTypeString, alias: reach_mip_year, editable: true, nullable: true, length: 20, defaultValue: null, modelName: reach_mip_year )
• eng_eval_req ( type: esriFieldTypeString, alias: eng_eval_req, editable: true, nullable: true, length: 10, defaultValue: null, modelName: eng_eval_req )
• location ( type: esriFieldTypeString, alias: location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: location )
• jurisdiction ( type: esriFieldTypeString, alias: jurisdiction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: jurisdiction )
• Property_ID ( type: esriFieldTypeString, alias: AIM Property ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Property_ID )
• Current_OM_Inspector ( type: esriFieldTypeString, alias: Current OM Inspector, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Current_OM_Inspector )
• App_Link ( type: esriFieldTypeString, alias: Application Link, editable: true, nullable: true, length: 500, defaultValue: null, modelName: App_Link )
• Charge_Number ( type: esriFieldTypeString, alias: Charge_Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Charge_Number )
• SupervisorialDistrict ( type: esriFieldTypeSmallInteger, alias: Supervisorial District, editable: true, nullable: true, defaultValue: null, modelName: SupervisorialDistrict )
Templates:
• Name: Channels
  Description:
  Prototype:
  Charge_Number: null
  SupervisorialDistrict: null
  FacilityID: null
  FacilitySystem: null
  FacilityType: null
  Ownership: null
  OwnerType: null
  Watershed: null
  ReachNum: null
  ReachDesc: null
  StaDS: null
  StaUS: null
  Length: null
  FacilityDesc: null
  Material: null
  Base: null
  Height: null
  DwgID: null
  DrawingNum: null
  Note: null
  PermitNum: NA
  DateofData: null
  MSTAR_ASSET: CULVERT
  FACILITYNAME: null
  MStar_User: null
  Shape_STLength_1: 0
  Rank: null
  ProjectName: null
  ProjectNum: null
  ReachRank: null
  FACILITYNUMBER: null
  PrjCost: null
  OM_Assigned_Area: null
  inspect_status_fall: null
  inspect_status_spring: null
  OM_Inspect_Req: null
  mip_year: null
  miles_length: null
  reach_mip_year: null
  eng_eval_req: null
  location: null
  jurisdiction: null
  Property_ID: null
  Current_OM_Inspector: null
  App_Link: null
  
  Drawing Tool: esriFeatureEditToolLine

Relationships:

• Channels_MaintStar_WO_Dynamic (0) -- Related To: Work Order Info. (2)

Tables:

Table: Work Order Info. (2)

Name: Work Order Info.

Display Field: craft_name

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• wo_no ( type: esriFieldTypeString, alias: wo_no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wo_no )
• issued ( type: esriFieldTypeDate, alias: issued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: issued )
• target ( type: esriFieldTypeDate, alias: target, editable: true, nullable: true, length: 8, defaultValue: null, modelName: target )
• closed ( type: esriFieldTypeDate, alias: closed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: closed )
• wo_status ( type: esriFieldTypeString, alias: wo_status, editable: true, nullable: true, length: 1, defaultValue: null, modelName: wo_status )
• system_id ( type: esriFieldTypeString, alias: system_id, editable: true, nullable: true, length: 25, defaultValue: null, modelName: system_id )
• wo_task ( type: esriFieldTypeString, alias: wo_task, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: wo_task )
• wo_type ( type: esriFieldTypeString, alias: wo_type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wo_type )
• problem ( type: esriFieldTypeString, alias: problem, editable: true, nullable: true, length: 500, defaultValue: null, modelName: problem )
• reason ( type: esriFieldTypeString, alias: reason, editable: true, nullable: true, length: 500, defaultValue: null, modelName: reason )
• wo_udf1 ( type: esriFieldTypeString, alias: wo_udf1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf1 )
• wo_udf2 ( type: esriFieldTypeString, alias: wo_udf2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf2 )
• wo_udf3 ( type: esriFieldTypeString, alias: wo_udf3, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf3 )
• wo_udf4 ( type: esriFieldTypeString, alias: wo_udf4, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf4 )
• wo_udf5 ( type: esriFieldTypeString, alias: wo_udf5, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf5 )
• elapsed_hr ( type: esriFieldTypeDouble, alias: elapsed_hr, editable: true, nullable: true, defaultValue: null, modelName: elapsed_hr )
• wo_udf6 ( type: esriFieldTypeString, alias: wo_udf6, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf6 )
• wo_udf7 ( type: esriFieldTypeString, alias: wo_udf7, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf7 )
• wo_udf8 ( type: esriFieldTypeString, alias: wo_udf8, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf8 )
• wo_udf9 ( type: esriFieldTypeString, alias: wo_udf9, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf9 )
• wo_acct ( type: esriFieldTypeString, alias: wo_acct, editable: true, nullable: true, length: 21, defaultValue: null, modelName: wo_acct )
• project_no ( type: esriFieldTypeString, alias: project_no, editable: true, nullable: true, length: 50, defaultValue: null, modelName: project_no )
• sup_notes ( type: esriFieldTypeString, alias: sup_notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: sup_notes )
• county_prob ( type: esriFieldTypeString, alias: county_prob, editable: true, nullable: true, length: 20, defaultValue: null, modelName: county_prob )
• claim_filed ( type: esriFieldTypeString, alias: claim_filed, editable: true, nullable: true, length: 20, defaultValue: null, modelName: claim_filed )
• cust_prob ( type: esriFieldTypeString, alias: cust_prob, editable: true, nullable: true, length: 20, defaultValue: null, modelName: cust_prob )
• action_next ( type: esriFieldTypeString, alias: action_next, editable: true, nullable: true, length: 20, defaultValue: null, modelName: action_next )
• work_code ( type: esriFieldTypeString, alias: work_code, editable: true, nullable: true, length: 20, defaultValue: null, modelName: work_code )
• priority_cd ( type: esriFieldTypeString, alias: priority_cd, editable: true, nullable: true, length: 10, defaultValue: null, modelName: priority_cd )
• maint_code ( type: esriFieldTypeString, alias: maint_code, editable: true, nullable: true, length: 12, defaultValue: null, modelName: maint_code )
• wk_code ( type: esriFieldTypeString, alias: wk_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: wk_code )
• wo_udf10 ( type: esriFieldTypeString, alias: wo_udf10, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf10 )
• wo_udf11 ( type: esriFieldTypeString, alias: wo_udf11, editable: true, nullable: true, length: 50, defaultValue: null, modelName: wo_udf11 )
• w_in_progress ( type: esriFieldTypeString, alias: w_in_progress, editable: true, nullable: true, length: 10, defaultValue: null, modelName: w_in_progress )
• work_request_no ( type: esriFieldTypeString, alias: work_request_no, editable: true, nullable: true, length: 10, defaultValue: null, modelName: work_request_no )
• approved_by ( type: esriFieldTypeString, alias: approved_by, editable: true, nullable: true, length: 25, defaultValue: null, modelName: approved_by )
• approved_by_descr ( type: esriFieldTypeString, alias: approved_by_descr, editable: true, nullable: true, length: 20, defaultValue: null, modelName: approved_by_descr )
• assign_to ( type: esriFieldTypeString, alias: assign_to, editable: true, nullable: true, length: 25, defaultValue: null, modelName: assign_to )
• assign_to_descr ( type: esriFieldTypeString, alias: assign_to_descr, editable: true, nullable: true, length: 20, defaultValue: null, modelName: assign_to_descr )
• loc_id ( type: esriFieldTypeString, alias: loc_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: loc_id )
• loc_desc ( type: esriFieldTypeString, alias: loc_desc, editable: true, nullable: true, length: 500, defaultValue: null, modelName: loc_desc )
• craft_name ( type: esriFieldTypeString, alias: craft_name, editable: true, nullable: true, length: 20, defaultValue: null, modelName: craft_name )
• ttl_hrs ( type: esriFieldTypeDouble, alias: ttl_hrs, editable: true, nullable: true, defaultValue: null, modelName: ttl_hrs )
• ttl_cost ( type: esriFieldTypeDouble, alias: ttl_cost, editable: true, nullable: true, defaultValue: null, modelName: ttl_cost )
• ttl_qty ( type: esriFieldTypeDouble, alias: ttl_qty, editable: true, nullable: true, defaultValue: null, modelName: ttl_qty )
• labor_cost ( type: esriFieldTypeDouble, alias: labor_cost, editable: true, nullable: true, defaultValue: null, modelName: labor_cost )
• parts_cost ( type: esriFieldTypeDouble, alias: parts_cost, editable: true, nullable: true, defaultValue: null, modelName: parts_cost )
• misc_cost ( type: esriFieldTypeDouble, alias: misc_cost, editable: true, nullable: true, defaultValue: null, modelName: misc_cost )
• contractor_cost ( type: esriFieldTypeDouble, alias: contractor_cost, editable: true, nullable: true, defaultValue: null, modelName: contractor_cost )
• wrkqty_cost ( type: esriFieldTypeDouble, alias: wrkqty_cost, editable: true, nullable: true, defaultValue: null, modelName: wrkqty_cost )
• equipment_cost ( type: esriFieldTypeDouble, alias: equipment_cost, editable: true, nullable: true, defaultValue: null, modelName: equipment_cost )
• wo_cost ( type: esriFieldTypeDouble, alias: wo_cost, editable: true, nullable: true, defaultValue: null, modelName: wo_cost )
• crew_cost ( type: esriFieldTypeDouble, alias: crew_cost, editable: true, nullable: true, defaultValue: null, modelName: crew_cost )
• crew_ctr ( type: esriFieldTypeDouble, alias: crew_ctr, editable: true, nullable: true, defaultValue: null, modelName: crew_ctr )
• misc_ctr ( type: esriFieldTypeDouble, alias: misc_ctr, editable: true, nullable: true, defaultValue: null, modelName: misc_ctr )
• contractor_ctr ( type: esriFieldTypeDouble, alias: contractor_ctr, editable: true, nullable: true, defaultValue: null, modelName: contractor_ctr )
• wrkqty_ctr ( type: esriFieldTypeDouble, alias: wrkqty_ctr, editable: true, nullable: true, defaultValue: null, modelName: wrkqty_ctr )
• equipment_ctr ( type: esriFieldTypeDouble, alias: equipment_ctr, editable: true, nullable: true, defaultValue: null, modelName: equipment_ctr )
• first_name ( type: esriFieldTypeString, alias: first_name, editable: true, nullable: true, length: 15, defaultValue: null, modelName: first_name )
• last_name ( type: esriFieldTypeString, alias: last_name, editable: true, nullable: true, length: 15, defaultValue: null, modelName: last_name )
• phone1 ( type: esriFieldTypeString, alias: phone1, editable: true, nullable: true, length: 16, defaultValue: null, modelName: phone1 )
• phone2 ( type: esriFieldTypeString, alias: phone2, editable: true, nullable: true, length: 16, defaultValue: null, modelName: phone2 )
• email ( type: esriFieldTypeString, alias: email, editable: true, nullable: true, length: 99, defaultValue: null, modelName: email )
• street_number ( type: esriFieldTypeString, alias: street_number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: street_number )
• street_name ( type: esriFieldTypeString, alias: street_name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: street_name )
• cross_street ( type: esriFieldTypeString, alias: cross_street, editable: true, nullable: true, length: 30, defaultValue: null, modelName: cross_street )
• city ( type: esriFieldTypeString, alias: city, editable: true, nullable: true, length: 30, defaultValue: null, modelName: city )
• state ( type: esriFieldTypeString, alias: state, editable: true, nullable: true, length: 30, defaultValue: null, modelName: state )
• zip_code ( type: esriFieldTypeString, alias: zip_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: zip_code )
• loc_desc2 ( type: esriFieldTypeString, alias: loc_desc2, editable: true, nullable: true, length: 500, defaultValue: null, modelName: loc_desc2 )
• complaint ( type: esriFieldTypeString, alias: complaint, editable: true, nullable: true, length: 500, defaultValue: null, modelName: complaint )
• comments ( type: esriFieldTypeString, alias: comments, editable: true, nullable: true, length: 500, defaultValue: null, modelName: comments )
• problem_street_number ( type: esriFieldTypeString, alias: problem_street_number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: problem_street_number )
• problem_street_name ( type: esriFieldTypeString, alias: problem_street_name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_street_name )
• problem_cross_street ( type: esriFieldTypeString, alias: problem_cross_street, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_cross_street )
• problem_city ( type: esriFieldTypeString, alias: problem_city, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_city )
• problem_state ( type: esriFieldTypeString, alias: problem_state, editable: true, nullable: true, length: 30, defaultValue: null, modelName: problem_state )
• problem_zip_code ( type: esriFieldTypeString, alias: problem_zip_code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: problem_zip_code )
• notes ( type: esriFieldTypeString, alias: notes, editable: true, nullable: true, length: 500, defaultValue: null, modelName: notes )
• use_cust_address ( type: esriFieldTypeString, alias: use_cust_address, editable: true, nullable: true, length: 1, defaultValue: null, modelName: use_cust_address )
• rating ( type: esriFieldTypeDouble, alias: rating, editable: true, nullable: true, defaultValue: null, modelName: rating )
• unit_id ( type: esriFieldTypeString, alias: unit_id, editable: true, nullable: true, length: 25, defaultValue: null, modelName: unit_id )
• unit_type ( type: esriFieldTypeString, alias: unit_type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: unit_type )
• sub_type ( type: esriFieldTypeString, alias: sub_type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: sub_type )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Templates:
• Name: Work Order Info.
  Description:
  Prototype:
  sub_type: null
  wo_no: null
  issued: null
  target: null
  closed: null
  wo_status: null
  system_id: null
  wo_task: null
  wo_type: null
  problem: null
  reason: null
  wo_udf1: null
  wo_udf2: null
  wo_udf3: null
  wo_udf4: null
  wo_udf5: null
  elapsed_hr: null
  wo_udf6: null
  wo_udf7: null
  wo_udf8: null
  wo_udf9: null
  wo_acct: null
  project_no: null
  sup_notes: null
  county_prob: null
  claim_filed: null
  cust_prob: null
  action_next: null
  work_code: null
  priority_cd: null
  maint_code: null
  wk_code: null
  wo_udf10: null
  wo_udf11: null
  w_in_progress: null
  work_request_no: null
  approved_by: null
  approved_by_descr: null
  assign_to: null
  assign_to_descr: null
  loc_id: null
  loc_desc: null
  craft_name: null
  ttl_hrs: null
  ttl_cost: null
  ttl_qty: null
  labor_cost: null
  parts_cost: null
  misc_cost: null
  contractor_cost: null
  wrkqty_cost: null
  equipment_cost: null
  wo_cost: null
  crew_cost: null
  crew_ctr: null
  misc_ctr: null
  contractor_ctr: null
  wrkqty_ctr: null
  equipment_ctr: null
  first_name: null
  last_name: null
  phone1: null
  phone2: null
  email: null
  street_number: null
  street_name: null
  cross_street: null
  city: null
  state: null
  zip_code: null
  loc_desc2: null
  complaint: null
  comments: null
  problem_street_number: null
  problem_street_name: null
  problem_cross_street: null
  problem_city: null
  problem_state: null
  problem_zip_code: null
  notes: null
  use_cust_address: null
  rating: null
  unit_id: null
  unit_type: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• Channels (0) -- Related To: Channels (1)

Table: Work Order Data Only (3)

Name: Work Order Data Only

Display Field: WorkOrderNumber

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false


HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:
• WorkOrderNumber ( type: esriFieldTypeString, alias: WorkOrderNumber, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WorkOrderNumber )
• WorkOrderIssued ( type: esriFieldTypeDate, alias: WorkOrderIssued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkOrderIssued )
• WorkOrderTargetClosed ( type: esriFieldTypeDate, alias: WorkOrderTargetClosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkOrderTargetClosed )
• WorkOrderClosed ( type: esriFieldTypeDate, alias: WorkOrderClosed, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WorkOrderClosed )
• WorkOrderStatus ( type: esriFieldTypeString, alias: WorkOrderStatus, editable: true, nullable: true, length: 1, defaultValue: null, modelName: WorkOrderStatus )
• ObjectID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: ObjectID )
Templates:
• Name: Work Order Data Only
  Description:
  Prototype:
  WorkOrderStatus: null
  WorkOrderNumber: null
  WorkOrderIssued: null
  WorkOrderTargetClosed: null
  WorkOrderClosed: null
  
  Drawing Tool: esriFeatureEditToolNone