View In:   ArcGIS Online Map Viewer

Name: SoCalProjects.DBO.Pasadena_injury_collisions_2019_2024

Display Field: Accidno

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: a9be1f91706640458004b0b1bb3cbc7b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.3199888826027056E7
YMin: -1642016.9313147208
XMax: 2.677110169845405E-6
YMax: 1.0676059356455758E7
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [153, 73, 131, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Accidno ( type: esriFieldTypeString, alias: Accidno, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Accidno )
• FP_Geocode ( type: esriFieldTypeInteger, alias: FP_Geocode, editable: true, nullable: true, defaultValue: null, modelName: FP_Geocode )
• Date ( type: esriFieldTypeString, alias: Date, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Date )
• Time ( type: esriFieldTypeInteger, alias: Time, editable: true, nullable: true, defaultValue: null, modelName: Time )
• Day ( type: esriFieldTypeString, alias: Day, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Day )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Street )
• CrossSt ( type: esriFieldTypeString, alias: CrossSt, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CrossSt )
• Distance ( type: esriFieldTypeInteger, alias: Distance, editable: true, nullable: true, defaultValue: null, modelName: Distance )
• Direction ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Direction )
• X ( type: esriFieldTypeInteger, alias: X, editable: true, nullable: true, defaultValue: null, modelName: X )
• Y ( type: esriFieldTypeInteger, alias: Y, editable: true, nullable: true, defaultValue: null, modelName: Y )
• Injury ( type: esriFieldTypeString, alias: Injury, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Injury )
• NoInjured ( type: esriFieldTypeInteger, alias: NoInjured, editable: true, nullable: true, defaultValue: null, modelName: NoInjured )
• NoKilled ( type: esriFieldTypeInteger, alias: NoKilled, editable: true, nullable: true, defaultValue: null, modelName: NoKilled )
• PtyAtFault ( type: esriFieldTypeInteger, alias: PtyAtFault, editable: true, nullable: true, defaultValue: null, modelName: PtyAtFault )
• Cause ( type: esriFieldTypeString, alias: Cause, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Cause )
• HitAndRun ( type: esriFieldTypeString, alias: HitAndRun, editable: true, nullable: true, length: 254, defaultValue: null, modelName: HitAndRun )
• CollisnTyp ( type: esriFieldTypeString, alias: CollisnTyp, editable: true, nullable: true, length: 254, defaultValue: null, modelName: CollisnTyp )
• InvWith ( type: esriFieldTypeString, alias: InvWith, editable: true, nullable: true, length: 254, defaultValue: null, modelName: InvWith )
• PedAction ( type: esriFieldTypeString, alias: PedAction, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PedAction )
• PvtProp ( type: esriFieldTypeInteger, alias: PvtProp, editable: true, nullable: true, defaultValue: null, modelName: PvtProp )
• Violation ( type: esriFieldTypeInteger, alias: Violation, editable: true, nullable: true, defaultValue: null, modelName: Violation )
• Weather ( type: esriFieldTypeString, alias: Weather, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Weather )
• RoadSurf ( type: esriFieldTypeString, alias: RoadSurf, editable: true, nullable: true, length: 254, defaultValue: null, modelName: RoadSurf )
• RoadCond ( type: esriFieldTypeString, alias: RoadCond, editable: true, nullable: true, length: 254, defaultValue: null, modelName: RoadCond )
• Lighting ( type: esriFieldTypeString, alias: Lighting, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Lighting )
• Controls ( type: esriFieldTypeString, alias: Controls, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Controls )
• PartyType1 ( type: esriFieldTypeString, alias: PartyType1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PartyType1 )
• PartyAge1 ( type: esriFieldTypeInteger, alias: PartyAge1, editable: true, nullable: true, defaultValue: null, modelName: PartyAge1 )
• PartySex1 ( type: esriFieldTypeString, alias: PartySex1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PartySex1 )
• Direction1 ( type: esriFieldTypeString, alias: Direction1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Direction1 )
• Movement1 ( type: esriFieldTypeString, alias: Movement1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Movement1 )
• SpecInfo1 ( type: esriFieldTypeString, alias: SpecInfo1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SpecInfo1 )
• Sobriety1 ( type: esriFieldTypeString, alias: Sobriety1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Sobriety1 )
• VehType1 ( type: esriFieldTypeString, alias: VehType1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehType1 )
• VehYear1 ( type: esriFieldTypeString, alias: VehYear1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehYear1 )
• VehMake1 ( type: esriFieldTypeString, alias: VehMake1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehMake1 )
• VehModel1 ( type: esriFieldTypeString, alias: VehModel1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehModel1 )
• SpeedLim1 ( type: esriFieldTypeString, alias: SpeedLim1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SpeedLim1 )
• Damage1 ( type: esriFieldTypeString, alias: Damage1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Damage1 )
• SafetyEq1 ( type: esriFieldTypeString, alias: SafetyEq1, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SafetyEq1 )
• PartyType2 ( type: esriFieldTypeString, alias: PartyType2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PartyType2 )
• PartyAge2 ( type: esriFieldTypeInteger, alias: PartyAge2, editable: true, nullable: true, defaultValue: null, modelName: PartyAge2 )
• PartySex2 ( type: esriFieldTypeString, alias: PartySex2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PartySex2 )
• Direction2 ( type: esriFieldTypeString, alias: Direction2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Direction2 )
• Movement2 ( type: esriFieldTypeString, alias: Movement2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Movement2 )
• SpecInfo2 ( type: esriFieldTypeString, alias: SpecInfo2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SpecInfo2 )
• Sobriety2 ( type: esriFieldTypeString, alias: Sobriety2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Sobriety2 )
• VehType2 ( type: esriFieldTypeString, alias: VehType2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehType2 )
• VehYear2 ( type: esriFieldTypeString, alias: VehYear2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehYear2 )
• VehMake2 ( type: esriFieldTypeString, alias: VehMake2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehMake2 )
• VehModel2 ( type: esriFieldTypeString, alias: VehModel2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: VehModel2 )
• SpeedLim2 ( type: esriFieldTypeString, alias: SpeedLim2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SpeedLim2 )
• Damage2 ( type: esriFieldTypeString, alias: Damage2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Damage2 )
• SafetyEq2 ( type: esriFieldTypeString, alias: SafetyEq2, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SafetyEq2 )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 254, defaultValue: null, modelName: City )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 254, defaultValue: null, modelName: State )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Country )
• Formatted ( type: esriFieldTypeString, alias: Formatted, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Formatted )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Proj_Point ( type: esriFieldTypeString, alias: Proj_Point, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Proj_Point )
• Proj_Line ( type: esriFieldTypeString, alias: Proj_Line, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Proj_Line )
• Group_QC ( type: esriFieldTypeString, alias: Group_QC, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Group_QC )
• OutsidePas ( type: esriFieldTypeInteger, alias: OutsidePas, editable: true, nullable: true, defaultValue: null, modelName: OutsidePas )
• All_Inter ( type: esriFieldTypeInteger, alias: All_Inter, editable: true, nullable: true, defaultValue: null, modelName: All_Inter )
• Sig_Inter ( type: esriFieldTypeInteger, alias: Sig_Inter, editable: true, nullable: true, defaultValue: null, modelName: Sig_Inter )

Templates:

• Name: SoCalProjects.DBO.Pasadena_injury_collisions_2019_2024
  Description:
  Prototype:
  All_Inter: null
  Sig_Inter: null
  Accidno: null
  FP_Geocode: null
  Date: null
  Time: null
  Day: null
  Street: null
  CrossSt: null
  Distance: null
  Direction: null
  X: null
  Y: null
  Injury: null
  NoInjured: null
  NoKilled: null
  PtyAtFault: null
  Cause: null
  HitAndRun: null
  CollisnTyp: null
  InvWith: null
  PedAction: null
  PvtProp: null
  Violation: null
  Weather: null
  RoadSurf: null
  RoadCond: null
  Lighting: null
  Controls: null
  PartyType1: null
  PartyAge1: null
  PartySex1: null
  Direction1: null
  Movement1: null
  SpecInfo1: null
  Sobriety1: null
  VehType1: null
  VehYear1: null
  VehMake1: null
  VehModel1: null
  SpeedLim1: null
  Damage1: null
  SafetyEq1: null
  PartyType2: null
  PartyAge2: null
  PartySex2: null
  Direction2: null
  Movement2: null
  SpecInfo2: null
  Sobriety2: null
  VehType2: null
  VehYear2: null
  VehMake2: null
  VehModel2: null
  SpeedLim2: null
  Damage2: null
  SafetyEq2: null
  City: null
  State: null
  Country: null
  Formatted: null
  Latitude: null
  Longitude: null
  Proj_Point: null
  Proj_Line: null
  Group_QC: null
  OutsidePas: null
  
  Drawing Tool: esriFeatureEditToolPoint

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: true

Child Resources:

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