Name: TravelBehaviorInventory2021Trip

Display Field: depart_time

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d933c85065a24e838c585ec906a743ee

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 )
• hh_id ( type: esriFieldTypeInteger, alias: hh_id, editable: true, nullable: true, defaultValue: null, modelName: hh_id )
• trip_id ( type: esriFieldTypeDouble, alias: trip_id, editable: true, nullable: true, defaultValue: null, modelName: trip_id )
• person_id ( type: esriFieldTypeInteger, alias: person_id, editable: true, nullable: true, defaultValue: null, modelName: person_id )
• person_num ( type: esriFieldTypeInteger, alias: person_num, editable: true, nullable: true, defaultValue: null, modelName: person_num )
• day_id ( type: esriFieldTypeDouble, alias: day_id, editable: true, nullable: true, defaultValue: null, modelName: day_id )
• 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 )
• travel_dow ( type: esriFieldTypeInteger, alias: travel_dow, editable: true, nullable: true, defaultValue: null, modelName: travel_dow )
• hh_day_complete ( type: esriFieldTypeInteger, alias: hh_day_complete, editable: true, nullable: true, defaultValue: null, modelName: hh_day_complete )
• trip_num ( type: esriFieldTypeInteger, alias: trip_num, editable: true, nullable: true, defaultValue: null, modelName: trip_num )
• trip_weight ( type: esriFieldTypeDouble, alias: trip_weight, editable: true, nullable: true, defaultValue: null, modelName: trip_weight )
• depart_date ( type: esriFieldTypeDate, alias: depart_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: depart_date )
• depart_time ( type: esriFieldTypeString, alias: depart_time, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: depart_time )
• depart_minute ( type: esriFieldTypeInteger, alias: depart_minute, editable: true, nullable: true, defaultValue: null, modelName: depart_minute )
• arrive_date ( type: esriFieldTypeDate, alias: arrive_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: arrive_date )
• arrive_time ( type: esriFieldTypeString, alias: arrive_time, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: arrive_time )
• duration ( type: esriFieldTypeInteger, alias: duration, editable: true, nullable: true, defaultValue: null, modelName: duration )
• arrive_minute ( type: esriFieldTypeInteger, alias: arrive_minute, editable: true, nullable: true, defaultValue: null, modelName: arrive_minute )
• distance ( type: esriFieldTypeDouble, alias: distance, editable: true, nullable: true, defaultValue: null, modelName: distance )
• speed_mph ( type: esriFieldTypeDouble, alias: speed_mph, editable: true, nullable: true, defaultValue: null, modelName: speed_mph )
• o_bg_2010 ( type: esriFieldTypeDouble, alias: o_bg_2010, editable: true, nullable: true, defaultValue: null, modelName: o_bg_2010 )
• o_bg_2020 ( type: esriFieldTypeDouble, alias: o_bg_2020, editable: true, nullable: true, defaultValue: null, modelName: o_bg_2020 )
• o_puma_2010 ( type: esriFieldTypeInteger, alias: o_puma_2010, editable: true, nullable: true, defaultValue: null, modelName: o_puma_2010 )
• d_bg_2010 ( type: esriFieldTypeDouble, alias: d_bg_2010, editable: true, nullable: true, defaultValue: null, modelName: d_bg_2010 )
• d_bg_2020 ( type: esriFieldTypeDouble, alias: d_bg_2020, editable: true, nullable: true, defaultValue: null, modelName: d_bg_2020 )
• d_puma_2010 ( type: esriFieldTypeInteger, alias: d_puma_2010, editable: true, nullable: true, defaultValue: null, modelName: d_puma_2010 )
• leg_num ( type: esriFieldTypeInteger, alias: leg_num, editable: true, nullable: true, defaultValue: null, modelName: leg_num )
• taxi_cost ( type: esriFieldTypeString, alias: taxi_cost, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: taxi_cost )
• linked_trip_id ( type: esriFieldTypeInteger, alias: linked_trip_id, editable: true, nullable: true, defaultValue: null, modelName: linked_trip_id )
• leg_id ( type: esriFieldTypeInteger, alias: leg_id, editable: true, nullable: true, defaultValue: null, modelName: leg_id )
• vehicle_id ( type: esriFieldTypeInteger, alias: vehicle_id, editable: true, nullable: true, defaultValue: null, modelName: vehicle_id )
• arrive_dow ( type: esriFieldTypeString, alias: arrive_dow, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: arrive_dow )
• arrive_hour ( type: esriFieldTypeString, alias: arrive_hour, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: arrive_hour )
• bike_park_location ( type: esriFieldTypeString, alias: bike_park_location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bike_park_location )
• d_county ( type: esriFieldTypeString, alias: d_county, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_county )
• d_in_region ( type: esriFieldTypeString, alias: d_in_region, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_in_region )
• 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_state ( type: esriFieldTypeString, alias: d_state, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_state )
• d_zone ( type: esriFieldTypeString, alias: d_zone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: d_zone )
• depart_dow ( type: esriFieldTypeString, alias: depart_dow, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: depart_dow )
• depart_hour ( type: esriFieldTypeString, alias: depart_hour, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: depart_hour )
• ev_charge_station ( type: esriFieldTypeString, alias: ev_charge_station, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ev_charge_station )
• ev_charge_station_decision ( type: esriFieldTypeString, alias: ev_charge_station_decision, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ev_charge_station_decision )
• ev_charge_station_level_1 ( type: esriFieldTypeString, alias: ev_charge_station_level_1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ev_charge_station_level_1 )
• ev_charge_station_level_2 ( type: esriFieldTypeString, alias: ev_charge_station_level_2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ev_charge_station_level_2 )
• ev_charge_station_level_3 ( type: esriFieldTypeString, alias: ev_charge_station_level_3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ev_charge_station_level_3 )
• ev_charge_station_level_998 ( type: esriFieldTypeString, alias: ev_charge_station_level_998, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ev_charge_station_level_998 )
• 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 )
• 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 )
• 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 )
• 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_county ( type: esriFieldTypeString, alias: o_county, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_county )
• o_in_region ( type: esriFieldTypeString, alias: o_in_region, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_in_region )
• o_purpose ( type: esriFieldTypeString, alias: o_purpose, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_purpose )
• o_purpose_category ( type: esriFieldTypeString, alias: o_purpose_category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_purpose_category )
• o_state ( type: esriFieldTypeString, alias: o_state, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_state )
• o_zone ( type: esriFieldTypeString, alias: o_zone, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: o_zone )
• scooter_park_location ( type: esriFieldTypeString, alias: scooter_park_location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: scooter_park_location )
• taxi_pay ( type: esriFieldTypeString, alias: taxi_pay, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: taxi_pay )
• taxi_who_paid ( type: esriFieldTypeString, alias: taxi_who_paid, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: taxi_who_paid )
• tnc_type ( type: esriFieldTypeString, alias: tnc_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: tnc_type )
• transit_access ( type: esriFieldTypeString, alias: transit_access, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: transit_access )
• transit_egress ( type: esriFieldTypeString, alias: transit_egress, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: transit_egress )
• 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_location ( type: esriFieldTypeString, alias: vehicle_park_location, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_park_location )
• vehicle_park_type ( type: esriFieldTypeString, alias: vehicle_park_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: vehicle_park_type )
• 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_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_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_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 )
• 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 )
• 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: TravelBehaviorInventory2021Trip
  Description:
  Prototype:
  o_purpose_category_broad: null
  trip_season: null
  hh_id: null
  trip_id: null
  person_id: null
  person_num: null
  day_id: null
  day_num: null
  travel_date: null
  travel_dow: null
  hh_day_complete: null
  trip_num: null
  trip_weight: null
  depart_date: null
  depart_time: null
  depart_minute: null
  arrive_date: null
  arrive_time: null
  duration: null
  arrive_minute: null
  distance: null
  speed_mph: null
  o_bg_2010: null
  o_bg_2020: null
  o_puma_2010: null
  d_bg_2010: null
  d_bg_2020: null
  d_puma_2010: null
  leg_num: null
  taxi_cost: null
  linked_trip_id: null
  leg_id: null
  vehicle_id: null
  arrive_dow: null
  arrive_hour: null
  bike_park_location: null
  d_county: null
  d_in_region: null
  d_purpose: null
  d_purpose_category: null
  d_state: null
  d_zone: null
  depart_dow: null
  depart_hour: null
  ev_charge_station: null
  ev_charge_station_decision: null
  ev_charge_station_level_1: null
  ev_charge_station_level_2: null
  ev_charge_station_level_3: null
  ev_charge_station_level_998: 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
  is_access: null
  is_egress: null
  mode_1: null
  mode_2: null
  mode_3: null
  mode_type: null
  mode_type_detailed: null
  num_hh_travelers: null
  num_non_hh_travelers: null
  num_travelers: null
  o_county: null
  o_in_region: null
  o_purpose: null
  o_purpose_category: null
  o_state: null
  o_zone: null
  scooter_park_location: null
  taxi_pay: null
  taxi_who_paid: null
  tnc_type: null
  transit_access: null
  transit_egress: null
  trip_survey_complete: null
  unlinked_trip: null
  vehicle_driver: null
  vehicle_park_location: null
  vehicle_park_type: null
  trip_o_in_mpo: null
  trip_d_in_mpo: null
  trip_o_county: null
  trip_d_county: null
  trip_o_city: null
  trip_d_city: 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
  trip_o_cbg: null
  trip_d_cbg: 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