View In:   ArcGIS Online Map Viewer

Name: RoadCenterline_BusTripSummary

Display Field: fullname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: I summarized all the bus trips taken on each route over the course of a week between 11/28/2022 and 12/17/2022. This summary data was then joined to street centerline segments, which are divided at each intersection. This produced a consolidated data layer showing the bus traffic on each street segment over the week.

Service Item Id: e04e53a2891d40f6808ad8b0dd8d9447

Copyright Text: City of Pullman GIS | Transit

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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

Extent:

XMin: -1.30504184173E7
YMin: 5893406.940300003
XMax: -1.3034159454300001E7
YMax: 5904219.035400003
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [97, 51, 142, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid_1 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid_1, alias: OBJECTID_1 )
• centerlineid ( modelName: centerlineid, nullable: true, editable: true, defaultValue: null, length: 20, alias: Centerline ID, type: esriFieldTypeString )
• fullname ( modelName: fullname, nullable: true, editable: true, defaultValue: null, length: 300, alias: Full Road Name, type: esriFieldTypeString , Coded Values: [Airport Complex: Airport Complex] , [Airport Complex N: Airport Complex N] , [Court St: Court St] , ...428 more... )
• roadclass ( modelName: roadclass, nullable: true, editable: true, defaultValue: null, length: 20, alias: Road Class, type: esriFieldTypeString , Coded Values: [Freeway: Freeway] , [Highway: Highway] , [Ramp: Ramp] , ...12 more... )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• stantecunique ( modelName: stantecunique, nullable: true, editable: true, defaultValue: null, alias: Stantec Unique ID, type: esriFieldTypeInteger )
• fromstreet ( modelName: fromstreet, nullable: true, editable: true, defaultValue: null, length: 255, alias: From Street Intersection, type: esriFieldTypeString )
• tostreet ( modelName: tostreet, nullable: true, editable: true, defaultValue: null, length: 255, alias: To Street Intersection, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• roadname ( modelName: roadname, nullable: true, editable: true, defaultValue: null, length: 255, alias: Road Name, type: esriFieldTypeString )
• speedlimit ( modelName: speedlimit, nullable: true, editable: true, defaultValue: 25, alias: Speed Limit, type: esriFieldTypeSmallInteger , Coded Values: [10: 10 MPH] , [15: 15 MPH] , [20: 20 MPH] , ...12 more... )
• ownedby ( modelName: ownedby, nullable: true, editable: true, defaultValue: CoP, length: 255, alias: Owned By, type: esriFieldTypeString , Coded Values: [CoP: CoP - City of Pullman] , [WSU: WSU - Washington State University] , [County: Whitman County] , ...3 more... )
• roadmatrixid ( modelName: roadmatrixid, nullable: true, editable: true, defaultValue: null, length: 255, alias: RoadMatrix ID, type: esriFieldTypeString )
• maintby ( modelName: maintby, nullable: true, editable: true, defaultValue: CoP, length: 255, alias: Maintained By, type: esriFieldTypeString , Coded Values: [CoP: CoP - City of Pullman] , [WSU: WSU - Washington State University] , [County: Whitman County] , ...3 more... )
• snowmaintpriority ( modelName: snowmaintpriority, nullable: true, editable: true, defaultValue: Priority Three, length: 255, alias: Snow Maintenance Priority, type: esriFieldTypeString , Coded Values: [Priority One: Priority One] , [Priority Two: Priority Two] , [Priority Three: Priority Three] , ...5 more... )
• objectid ( modelName: System-maintained ObjectID, nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• join_count ( modelName: join_count, nullable: true, editable: true, defaultValue: null, alias: Join_Count, type: esriFieldTypeInteger )
• target_fid ( modelName: target_fid, nullable: true, editable: true, defaultValue: null, alias: TARGET_FID, type: esriFieldTypeInteger )
• centerlineid_1 ( modelName: centerlineid_1, nullable: true, editable: true, defaultValue: null, length: 20, alias: Centerline ID, type: esriFieldTypeString )
• orig_fid ( modelName: orig_fid, nullable: true, editable: true, defaultValue: null, alias: ORIG_FID, type: esriFieldTypeInteger )
• shape_id ( modelName: shape_id, nullable: true, editable: true, defaultValue: null, length: 500, alias: shape_id, type: esriFieldTypeString )
• route_id ( modelName: route_id, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_id, type: esriFieldTypeString )
• agency_id ( modelName: agency_id, nullable: true, editable: true, defaultValue: null, length: 500, alias: agency_id, type: esriFieldTypeString )
• route_short_name ( modelName: route_short_name, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_short_name, type: esriFieldTypeString )
• route_long_name ( modelName: route_long_name, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_long_name, type: esriFieldTypeString )
• route_desc ( modelName: route_desc, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_desc, type: esriFieldTypeString )
• route_type ( modelName: route_type, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_type, type: esriFieldTypeString )
• route_url ( modelName: route_url, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_url, type: esriFieldTypeString )
• route_color ( modelName: route_color, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_color, type: esriFieldTypeString )
• route_text_color ( modelName: route_text_color, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_text_color, type: esriFieldTypeString )
• route_type_text ( modelName: route_type_text, nullable: true, editable: true, defaultValue: null, length: 500, alias: route_type_text, type: esriFieldTypeString )
• mercatorlength ( modelName: mercatorlength, nullable: true, editable: true, defaultValue: null, alias: MercatorLength, type: esriFieldTypeDouble )
• weekly_trips ( modelName: weekly_trips, nullable: true, editable: true, defaultValue: null, alias: weekly_trips, type: esriFieldTypeSmallInteger )
• weekly_trips_join ( modelName: weekly_trips_join, nullable: true, editable: true, defaultValue: null, length: 255, alias: weekly_trips_join, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: RoadCenterline_BusTripSummary
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata