Name: NJ_Transit_Bus_Attribute_Informtion_Table_New

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: ObjectId

Unique ID Field:

Name : ObjectId

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• route_name (type: esriFieldTypeInteger, alias: route.name, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• trip_headsign (type: esriFieldTypeString, alias: trip.headsign, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• pattern_id (type: esriFieldTypeInteger, alias: pattern.id, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• first_stop_id (type: esriFieldTypeInteger, alias: first.stop.id, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• first_stop_seq (type: esriFieldTypeInteger, alias: first.stop.seq, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• first_dep_dec (type: esriFieldTypeDouble, alias: first.dep.dec, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• last_stop_id (type: esriFieldTypeInteger, alias: last.stop.id, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• last_stop_seq (type: esriFieldTypeInteger, alias: last.stop.seq, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• last_arr_dec (type: esriFieldTypeDouble, alias: last.arr.dec, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• pattern_dist (type: esriFieldTypeDouble, alias: pattern.dist, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• trip_time (type: esriFieldTypeDouble, alias: trip.time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• avg_stop_spacing (type: esriFieldTypeDouble, alias: avg.stop.spacing, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• avg_op_speed (type: esriFieldTypeDouble, alias: avg.op.speed, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• start_date (type: esriFieldTypeDateOnly, alias: start.date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• end_date (type: esriFieldTypeDateOnly, alias: end.date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• total_days (type: esriFieldTypeInteger, alias: total.days, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• time_period (type: esriFieldTypeString, alias: time.period, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• period_length (type: esriFieldTypeInteger, alias: period.length, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• total_trip_time (type: esriFieldTypeDouble, alias: total.trip.time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• service_day (type: esriFieldTypeString, alias: service.day, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• exception_type (type: esriFieldTypeInteger, alias: exception_type, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• num_dep (type: esriFieldTypeInteger, alias: num.dep, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• avg_cycle_time (type: esriFieldTypeDouble, alias: avg.cycle.time, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• avg_headway_hours (type: esriFieldTypeDouble, alias: avg.headway.hours, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• avg_headway_mins (type: esriFieldTypeDouble, alias: avg.headway.mins, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• avg_freq (type: esriFieldTypeDouble, alias: avg.freq, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• num_buses (type: esriFieldTypeDouble, alias: num.buses, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• current_rev_hour (type: esriFieldTypeDouble, alias: current.rev.hour, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• direction_name (type: esriFieldTypeString, alias: direction.name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• bus_trip_count (type: esriFieldTypeDouble, alias: bus.trip.count, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• boardings_total (type: esriFieldTypeDouble, alias: boardings.total, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• passenger_miles_total (type: esriFieldTypeDouble, alias: passenger.miles.total, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• revenue_miles_total (type: esriFieldTypeDouble, alias: revenue.miles.total, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• revenue_hours_total (type: esriFieldTypeDouble, alias: revenue.hours.total, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• avg_boardings_per_trip (type: esriFieldTypeDouble, alias: avg.boardings.per.trip, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• total_capacity (type: esriFieldTypeDouble, alias: total.capacity, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• seated_capacity (type: esriFieldTypeDouble, alias: seated.capacity, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• routetype (type: esriFieldTypeString, alias: routetype, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• hourly_seated_capacity (type: esriFieldTypeDouble, alias: hourly.seated.capacity, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• hourly_total_capacity (type: esriFieldTypeDouble, alias: hourly.total.capacity, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• psngr_miles_per_bus_mile (type: esriFieldTypeDouble, alias: psngr.miles.per.bus.mile, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• psngr_miles_ratio (type: esriFieldTypeDouble, alias: psngr.miles.ratio, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• psngr_miles_ratio_coach (type: esriFieldTypeString, alias: psngr.miles.ratio.coach, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• contractor_name (type: esriFieldTypeString, alias: contractor.name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ntrips (type: esriFieldTypeInteger, alias: ntrips, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TOTAL_RECOVERY_RATIO (type: esriFieldTypeDouble, alias: TOTAL.RECOVERY.RATIO, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Passenger_Yield (type: esriFieldTypeDouble, alias: Passenger.Yield, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Subsidy_per_Passenger (type: esriFieldTypeDouble, alias: Subsidy.per.Passenger, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• operating_area (type: esriFieldTypeString, alias: operating.area, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• rev_miles_week_est (type: esriFieldTypeDouble, alias: rev.miles.week.est, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• non_rev_miles_week_est (type: esriFieldTypeDouble, alias: non.rev.miles.week.est, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• rev_time_week_est (type: esriFieldTypeDouble, alias: rev.time.week.est, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• dead_time_week_est (type: esriFieldTypeDouble, alias: dead.time.week.est, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• layover_time_week_est (type: esriFieldTypeDouble, alias: layover.time.week.est, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• non_rev_time_week_est (type: esriFieldTypeDouble, alias: non.rev.time.week.est, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• route_variant (type: esriFieldTypeString, alias: route variant, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• first_stop_code (type: esriFieldTypeInteger, alias: first_stop_code, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• first_stop_name (type: esriFieldTypeString, alias: first_stop_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• last_stop_code (type: esriFieldTypeInteger, alias: last_stop_code, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• last_stop_name (type: esriFieldTypeString, alias: last_stop_name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• direction_short (type: esriFieldTypeString, alias: direction.short, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PATTERN_AB (type: esriFieldTypeString, alias: PATTERN_AB, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MUNICIPALI (type: esriFieldTypeString, alias: MUNICIPALI, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PLACE_NO (type: esriFieldTypeString, alias: PLACE_NO, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STOP_NUM (type: esriFieldTypeDouble, alias: STOP_NUM, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• DESCRIPTIO (type: esriFieldTypeString, alias: DESCRIPTIO, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STOP_TYPE (type: esriFieldTypeString, alias: STOP_TYPE, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STREET_DIR (type: esriFieldTypeString, alias: STREET_DIR, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MEASURE (type: esriFieldTypeDouble, alias: MEASURE, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• COUNTYlast (type: esriFieldTypeString, alias: COUNTYlast, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MUNICIPALIlast (type: esriFieldTypeString, alias: MUNICIPALIlast, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• PLACE_NOlast (type: esriFieldTypeString, alias: PLACE_NOlast, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• DESCRIPTIOlast (type: esriFieldTypeString, alias: DESCRIPTIOlast, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STOP_TYPElast (type: esriFieldTypeString, alias: STOP_TYPElast, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• STREET_DIRlast (type: esriFieldTypeString, alias: STREET_DIRlast, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MEASURElast (type: esriFieldTypeDouble, alias: MEASURElast, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• STOP_NUM_first (type: esriFieldTypeDouble, alias: STOP_NUM_first, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• STOP_NUM_last (type: esriFieldTypeDouble, alias: STOP_NUM_last, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• service_day_sequence (type: esriFieldTypeInteger, alias: service.day.sequence, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• time_period_sequence (type: esriFieldTypeInteger, alias: time.period.sequence, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• median_stop_spacing (type: esriFieldTypeDouble, alias: median_stop_spacing, SQL Type: sqlTypeOther, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/19/2024 12:37:54 PM

Schema Last Edit Date: 8/19/2024 12:37:54 PM

Data Last Edit Date: 8/19/2024 12:37:54 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat