Name: TravelBehaviorInventory2019Trip

Display Field: depart_time

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 4306aaa2a51648d5a68eefffe7ae147a

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• person_id ( type: esriFieldTypeInteger, alias: person_id, editable: true, nullable: true, defaultValue: null, modelName: person_id )
• trip_num ( type: esriFieldTypeInteger, alias: trip_num, editable: true, nullable: true, defaultValue: null, modelName: trip_num )
• trip_id ( type: esriFieldTypeDouble, alias: trip_id, editable: true, nullable: true, defaultValue: null, modelName: trip_id )
• hh_id ( type: esriFieldTypeInteger, alias: hh_id, editable: true, nullable: true, defaultValue: null, modelName: hh_id )
• person_num ( type: esriFieldTypeInteger, alias: person_num, editable: true, nullable: true, defaultValue: null, modelName: person_num )
• day_num ( type: esriFieldTypeInteger, alias: day_num, editable: true, nullable: true, defaultValue: null, modelName: day_num )
• travel_date ( type: esriFieldTypeDate, alias: travel_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: travel_date )
• day_complete ( type: esriFieldTypeInteger, alias: day_complete, editable: true, nullable: true, defaultValue: null, modelName: day_complete )
• leg_num ( type: esriFieldTypeInteger, alias: leg_num, editable: true, nullable: true, defaultValue: null, modelName: leg_num )
• linked_trip_num ( type: esriFieldTypeInteger, alias: linked_trip_num, editable: true, nullable: true, defaultValue: null, modelName: linked_trip_num )
• depart_time ( type: esriFieldTypeString, alias: depart_time, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: depart_time )
• arrive_time ( type: esriFieldTypeString, alias: arrive_time, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: arrive_time )
• o_bg ( type: esriFieldTypeDouble, alias: o_bg, editable: true, nullable: true, defaultValue: null, modelName: o_bg )
• o_county ( type: esriFieldTypeInteger, alias: o_county, editable: true, nullable: true, defaultValue: null, modelName: o_county )
• o_state ( type: esriFieldTypeInteger, alias: o_state, editable: true, nullable: true, defaultValue: null, modelName: o_state )
• d_bg ( type: esriFieldTypeDouble, alias: d_bg, editable: true, nullable: true, defaultValue: null, modelName: d_bg )
• d_county ( type: esriFieldTypeInteger, alias: d_county, editable: true, nullable: true, defaultValue: null, modelName: d_county )
• d_state ( type: esriFieldTypeInteger, alias: d_state, editable: true, nullable: true, defaultValue: null, modelName: d_state )
• d_purpose_other ( type: esriFieldTypeString, alias: d_purpose_other, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_purpose_other )
• duration ( type: esriFieldTypeDouble, alias: duration, editable: true, nullable: true, defaultValue: null, modelName: duration )
• duration_imputed ( type: esriFieldTypeDouble, alias: duration_imputed, editable: true, nullable: true, defaultValue: null, modelName: duration_imputed )
• distance ( type: esriFieldTypeDouble, alias: distance, editable: true, nullable: true, defaultValue: null, modelName: distance )
• speed_mph_imputed ( type: esriFieldTypeDouble, alias: speed_mph_imputed, editable: true, nullable: true, defaultValue: null, modelName: speed_mph_imputed )
• vehicle_park_cost ( type: esriFieldTypeString, alias: vehicle_park_cost, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_park_cost )
• taxi_cost ( type: esriFieldTypeString, alias: taxi_cost, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: taxi_cost )
• boarding_station ( type: esriFieldTypeString, alias: boarding_station, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: boarding_station )
• alighting_station ( type: esriFieldTypeString, alias: alighting_station, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: alighting_station )
• depart_time_imputed ( type: esriFieldTypeString, alias: depart_time_imputed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: depart_time_imputed )
• mode_type_p_1 ( type: esriFieldTypeDouble, alias: mode_type_p_1, editable: true, nullable: true, defaultValue: null, modelName: mode_type_p_1 )
• mode_type_p_2 ( type: esriFieldTypeDouble, alias: mode_type_p_2, editable: true, nullable: true, defaultValue: null, modelName: mode_type_p_2 )
• mode_type_p_3 ( type: esriFieldTypeDouble, alias: mode_type_p_3, editable: true, nullable: true, defaultValue: null, modelName: mode_type_p_3 )
• mode_type_p_4 ( type: esriFieldTypeDouble, alias: mode_type_p_4, editable: true, nullable: true, defaultValue: null, modelName: mode_type_p_4 )
• predicted_mode_probability ( type: esriFieldTypeDouble, alias: predicted_mode_probability, editable: true, nullable: true, defaultValue: null, modelName: predicted_mode_probability )
• day_weight ( type: esriFieldTypeDouble, alias: day_weight, editable: true, nullable: true, defaultValue: null, modelName: day_weight )
• trip_rate_factor ( type: esriFieldTypeDouble, alias: trip_rate_factor, editable: true, nullable: true, defaultValue: null, modelName: trip_rate_factor )
• trip_weight ( type: esriFieldTypeDouble, alias: trip_weight, editable: true, nullable: true, defaultValue: null, modelName: trip_weight )
• linked_trip_id ( type: esriFieldTypeString, alias: linked_trip_id, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: linked_trip_id )
• bike_park_loc ( type: esriFieldTypeString, alias: bike_park_loc, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bike_park_loc )
• bus_payment_type ( type: esriFieldTypeString, alias: bus_payment_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bus_payment_type )
• d_purpose ( type: esriFieldTypeString, alias: d_purpose, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_purpose )
• d_purpose_category ( type: esriFieldTypeString, alias: d_purpose_category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_purpose_category )
• d_purpose_category_imputed ( type: esriFieldTypeString, alias: d_purpose_category_imputed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_purpose_category_imputed )
• d_purpose_imputed ( type: esriFieldTypeString, alias: d_purpose_imputed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_purpose_imputed )
• hh_day_complete ( type: esriFieldTypeString, alias: hh_day_complete, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_day_complete )
• hh_member_1 ( type: esriFieldTypeString, alias: hh_member_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_1 )
• hh_member_10 ( type: esriFieldTypeString, alias: hh_member_10, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_10 )
• hh_member_11 ( type: esriFieldTypeString, alias: hh_member_11, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_11 )
• hh_member_2 ( type: esriFieldTypeString, alias: hh_member_2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_2 )
• hh_member_3 ( type: esriFieldTypeString, alias: hh_member_3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_3 )
• hh_member_4 ( type: esriFieldTypeString, alias: hh_member_4, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_4 )
• hh_member_5 ( type: esriFieldTypeString, alias: hh_member_5, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_5 )
• hh_member_6 ( type: esriFieldTypeString, alias: hh_member_6, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_6 )
• hh_member_7 ( type: esriFieldTypeString, alias: hh_member_7, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_7 )
• hh_member_8 ( type: esriFieldTypeString, alias: hh_member_8, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_8 )
• hh_member_9 ( type: esriFieldTypeString, alias: hh_member_9, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: hh_member_9 )
• invalid_purpose_flag ( type: esriFieldTypeString, alias: invalid_purpose_flag, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: invalid_purpose_flag )
• is_access ( type: esriFieldTypeString, alias: is_access, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: is_access )
• is_egress ( type: esriFieldTypeString, alias: is_egress, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: is_egress )
• missing_distance ( type: esriFieldTypeString, alias: missing_distance, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: missing_distance )
• missing_speed ( type: esriFieldTypeString, alias: missing_speed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: missing_speed )
• mode_1 ( type: esriFieldTypeString, alias: mode_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_1 )
• mode_2 ( type: esriFieldTypeString, alias: mode_2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_2 )
• mode_3 ( type: esriFieldTypeString, alias: mode_3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_3 )
• mode_type ( type: esriFieldTypeString, alias: mode_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_type )
• mode_type_detailed ( type: esriFieldTypeString, alias: mode_type_detailed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_type_detailed )
• mode_type_predicted ( type: esriFieldTypeString, alias: mode_type_predicted, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_type_predicted )
• num_hh_travelers ( type: esriFieldTypeString, alias: num_hh_travelers, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: num_hh_travelers )
• num_non_hh_travelers ( type: esriFieldTypeString, alias: num_non_hh_travelers, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: num_non_hh_travelers )
• num_travelers ( type: esriFieldTypeString, alias: num_travelers, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: num_travelers )
• o_purpose_category_imputed ( type: esriFieldTypeString, alias: o_purpose_category_imputed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_purpose_category_imputed )
• o_purpose_imputed ( type: esriFieldTypeString, alias: o_purpose_imputed, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_purpose_imputed )
• participation_group ( type: esriFieldTypeString, alias: participation_group, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: participation_group )
• rail_payment_type ( type: esriFieldTypeString, alias: rail_payment_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: rail_payment_type )
• scooter_park_loc ( type: esriFieldTypeString, alias: scooter_park_loc, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: scooter_park_loc )
• synthetic_trip ( type: esriFieldTypeString, alias: synthetic_trip, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: synthetic_trip )
• taxi_who_paid ( type: esriFieldTypeString, alias: taxi_who_paid, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: taxi_who_paid )
• travel_dow ( type: esriFieldTypeString, alias: travel_dow, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: travel_dow )
• trip_survey_complete ( type: esriFieldTypeString, alias: trip_survey_complete, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_survey_complete )
• unlinked_trip ( type: esriFieldTypeString, alias: unlinked_trip, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: unlinked_trip )
• vehicle_driver ( type: esriFieldTypeString, alias: vehicle_driver, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_driver )
• vehicle_park_loc ( type: esriFieldTypeString, alias: vehicle_park_loc, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_park_loc )
• vehicle_park_type ( type: esriFieldTypeString, alias: vehicle_park_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_park_type )
• vehicle_park_who_paid ( type: esriFieldTypeString, alias: vehicle_park_who_paid, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_park_who_paid )
• veh_id ( type: esriFieldTypeString, alias: veh_id, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: veh_id )
• trip_o_county ( type: esriFieldTypeString, alias: trip_o_county, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_o_county )
• trip_d_county ( type: esriFieldTypeString, alias: trip_d_county, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_d_county )
• trip_o_in_mpo ( type: esriFieldTypeString, alias: trip_o_in_mpo, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_o_in_mpo )
• trip_d_in_mpo ( type: esriFieldTypeString, alias: trip_d_in_mpo, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_d_in_mpo )
• trip_o_city ( type: esriFieldTypeString, alias: trip_o_city, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_o_city )
• trip_d_city ( type: esriFieldTypeString, alias: trip_d_city, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_d_city )
• trip_o_cbg ( type: esriFieldTypeDouble, alias: trip_o_cbg, editable: true, nullable: true, defaultValue: null, modelName: trip_o_cbg )
• trip_d_cbg ( type: esriFieldTypeDouble, alias: trip_d_cbg, editable: true, nullable: true, defaultValue: null, modelName: trip_d_cbg )
• trip_o_thrive_category ( type: esriFieldTypeString, alias: trip_o_thrive_category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_o_thrive_category )
• trip_o_thrive_category_broad ( type: esriFieldTypeString, alias: trip_o_thrive_category_broad, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_o_thrive_category_broad )
• trip_o_urban_rural_suburban ( type: esriFieldTypeString, alias: trip_o_urban_rural_suburban, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_o_urban_rural_suburban )
• trip_d_thrive_category ( type: esriFieldTypeString, alias: trip_d_thrive_category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_d_thrive_category )
• trip_d_thrive_category_broad ( type: esriFieldTypeString, alias: trip_d_thrive_category_broad, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_d_thrive_category_broad )
• trip_d_urban_rural_suburban ( type: esriFieldTypeString, alias: trip_d_urban_rural_suburban, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_d_urban_rural_suburban )
• mode_group ( type: esriFieldTypeString, alias: mode_group, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mode_group )
• distance_adj ( type: esriFieldTypeDouble, alias: distance_adj, editable: true, nullable: true, defaultValue: null, modelName: distance_adj )
• d_purpose_category_broad ( type: esriFieldTypeString, alias: d_purpose_category_broad, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_purpose_category_broad )
• o_purpose_category_broad ( type: esriFieldTypeString, alias: o_purpose_category_broad, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_purpose_category_broad )
• trip_season ( type: esriFieldTypeString, alias: trip_season, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: trip_season )

Templates:

• Name: TravelBehaviorInventory2019Trip
  Description:
  Prototype:
  o_purpose_category_broad: null
  trip_season: null
  person_id: null
  trip_num: null
  trip_id: null
  hh_id: null
  person_num: null
  day_num: null
  travel_date: null
  day_complete: null
  leg_num: null
  linked_trip_num: null
  depart_time: null
  arrive_time: null
  o_bg: null
  o_county: null
  o_state: null
  d_bg: null
  d_county: null
  d_state: null
  d_purpose_other: null
  duration: null
  duration_imputed: null
  distance: null
  speed_mph_imputed: null
  vehicle_park_cost: null
  taxi_cost: null
  boarding_station: null
  alighting_station: null
  depart_time_imputed: null
  mode_type_p_1: null
  mode_type_p_2: null
  mode_type_p_3: null
  mode_type_p_4: null
  predicted_mode_probability: null
  day_weight: null
  trip_rate_factor: null
  trip_weight: null
  linked_trip_id: null
  bike_park_loc: null
  bus_payment_type: null
  d_purpose: null
  d_purpose_category: null
  d_purpose_category_imputed: null
  d_purpose_imputed: null
  hh_day_complete: null
  hh_member_1: null
  hh_member_10: null
  hh_member_11: null
  hh_member_2: null
  hh_member_3: null
  hh_member_4: null
  hh_member_5: null
  hh_member_6: null
  hh_member_7: null
  hh_member_8: null
  hh_member_9: null
  invalid_purpose_flag: null
  is_access: null
  is_egress: null
  missing_distance: null
  missing_speed: null
  mode_1: null
  mode_2: null
  mode_3: null
  mode_type: null
  mode_type_detailed: null
  mode_type_predicted: null
  num_hh_travelers: null
  num_non_hh_travelers: null
  num_travelers: null
  o_purpose_category_imputed: null
  o_purpose_imputed: null
  participation_group: null
  rail_payment_type: null
  scooter_park_loc: null
  synthetic_trip: null
  taxi_who_paid: null
  travel_dow: null
  trip_survey_complete: null
  unlinked_trip: null
  vehicle_driver: null
  vehicle_park_loc: null
  vehicle_park_type: null
  vehicle_park_who_paid: null
  veh_id: null
  trip_o_county: null
  trip_d_county: null
  trip_o_in_mpo: null
  trip_d_in_mpo: null
  trip_o_city: null
  trip_d_city: null
  trip_o_cbg: null
  trip_d_cbg: null
  trip_o_thrive_category: null
  trip_o_thrive_category_broad: null
  trip_o_urban_rural_suburban: null
  trip_d_thrive_category: null
  trip_d_thrive_category_broad: null
  trip_d_urban_rural_suburban: null
  mode_group: null
  distance_adj: null
  d_purpose_category_broad: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata