Tables:

Table: TravelBehaviorInventory2019Trip (0)

Name: TravelBehaviorInventory2019Trip

Display Field: depart_time

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 7d61a5f455874cfbaa477734d7462ef9

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

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