View In:   ArcGIS Online Map Viewer

Name: ITSSQLSandbox.DBO.Signal4CrashEvent

Display Field: ReportingAgency

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 879b3b5297be40d6926d361817c77297

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

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: -82.88714645999994
YMin: 5.6843418860808015E-14
XMax: 5.6843418860808015E-14
YMax: 30.351194620000058
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [71, 0, 133, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 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: 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:

• S4DecimalDegreesLongitude ( type: esriFieldTypeDouble, alias: S4DecimalDegreesLongitude, editable: true, nullable: true, defaultValue: null, modelName: S4DecimalDegreesLongitude )
• S4DecimalDegreesLatitude ( type: esriFieldTypeDouble, alias: S4DecimalDegreesLatitude, editable: true, nullable: true, defaultValue: null, modelName: S4DecimalDegreesLatitude )
• LRSMilePoint ( type: esriFieldTypeDouble, alias: LRSMilePoint, editable: true, nullable: true, defaultValue: null, modelName: LRSMilePoint )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ReportNumber ( type: esriFieldTypeInteger, alias: ReportNumber, editable: true, nullable: false, defaultValue: null, modelName: ReportNumber )
• ReportingAgency ( type: esriFieldTypeString, alias: ReportingAgency, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ReportingAgency )
• CrashDate ( type: esriFieldTypeString, alias: CrashDate, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CrashDate )
• CrashTime ( type: esriFieldTypeString, alias: CrashTime, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CrashTime )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: City )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: County )
• CrashStreet ( type: esriFieldTypeString, alias: CrashStreet, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CrashStreet )
• IntersectingStreet ( type: esriFieldTypeString, alias: IntersectingStreet, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: IntersectingStreet )
• OffsetDistance ( type: esriFieldTypeInteger, alias: OffsetDistance, editable: true, nullable: true, defaultValue: null, modelName: OffsetDistance )
• OffsetDirection ( type: esriFieldTypeString, alias: OffsetDirection, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: OffsetDirection )
• CrashType ( type: esriFieldTypeString, alias: CrashType, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CrashType )
• Vehicles ( type: esriFieldTypeInteger, alias: Vehicles, editable: true, nullable: true, defaultValue: null, modelName: Vehicles )
• NonMotorists ( type: esriFieldTypeInteger, alias: NonMotorists, editable: true, nullable: true, defaultValue: null, modelName: NonMotorists )
• Fatalities ( type: esriFieldTypeInteger, alias: Fatalities, editable: true, nullable: true, defaultValue: null, modelName: Fatalities )
• Injuries ( type: esriFieldTypeInteger, alias: Injuries, editable: true, nullable: true, defaultValue: null, modelName: Injuries )
• AlcoholRelated ( type: esriFieldTypeSmallInteger, alias: AlcoholRelated, editable: true, nullable: true, defaultValue: null, modelName: AlcoholRelated )
• DistractionRelated ( type: esriFieldTypeSmallInteger, alias: DistractionRelated, editable: true, nullable: true, defaultValue: null, modelName: DistractionRelated )
• DrugRelated ( type: esriFieldTypeSmallInteger, alias: DrugRelated, editable: true, nullable: true, defaultValue: null, modelName: DrugRelated )
• EstimatedDamages ( type: esriFieldTypeInteger, alias: EstimatedDamages, editable: true, nullable: true, defaultValue: null, modelName: EstimatedDamages )
• WeatherCondition ( type: esriFieldTypeString, alias: WeatherCondition, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WeatherCondition )
• LightCondition ( type: esriFieldTypeString, alias: LightCondition, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LightCondition )
• CrashSeverity ( type: esriFieldTypeString, alias: CrashSeverity, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CrashSeverity )
• WithinCityLimits ( type: esriFieldTypeSmallInteger, alias: WithinCityLimits, editable: true, nullable: true, defaultValue: null, modelName: WithinCityLimits )
• FirstHarmfulEvent ( type: esriFieldTypeString, alias: FirstHarmfulEvent, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FirstHarmfulEvent )
• FirstHELocation ( type: esriFieldTypeString, alias: FirstHELocation, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FirstHELocation )
• FirstHERelationToJct ( type: esriFieldTypeString, alias: FirstHERelationToJct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: FirstHERelationToJct )
• SchoolBusRelated ( type: esriFieldTypeSmallInteger, alias: SchoolBusRelated, editable: true, nullable: true, defaultValue: null, modelName: SchoolBusRelated )
• Pedestrians ( type: esriFieldTypeInteger, alias: Pedestrians, editable: true, nullable: true, defaultValue: null, modelName: Pedestrians )
• IncapacitatingInjuries ( type: esriFieldTypeInteger, alias: IncapacitatingInjuries, editable: true, nullable: true, defaultValue: null, modelName: IncapacitatingInjuries )
• RoadSurfaceCondition ( type: esriFieldTypeString, alias: RoadSurfaceCondition, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: RoadSurfaceCondition )
• ContributingCircumstanceRoad1 ( type: esriFieldTypeString, alias: ContributingCircumstanceRoad1, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ContributingCircumstanceRoad1 )
• ContributingCircumstanceRoad2 ( type: esriFieldTypeString, alias: ContributingCircumstanceRoad2, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ContributingCircumstanceRoad2 )
• ContributingCircumstanceRoad3 ( type: esriFieldTypeString, alias: ContributingCircumstanceRoad3, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: ContributingCircumstanceRoad3 )
• LRSRoadway ( type: esriFieldTypeString, alias: LRSRoadway, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LRSRoadway )

Templates:

• Name: ITSSQLSandbox.DBO.Signal4CrashEvent
  Description:
  Prototype:
  ContributingCircumstanceRoad3: null
  S4DecimalDegreesLongitude: null
  S4DecimalDegreesLatitude: null
  LRSMilePoint: null
  LRSRoadway: null
  ReportNumber: 0
  ReportingAgency: null
  CrashDate: null
  CrashTime: null
  City: null
  County: null
  CrashStreet: null
  IntersectingStreet: null
  OffsetDistance: null
  OffsetDirection: null
  CrashType: null
  Vehicles: null
  NonMotorists: null
  Fatalities: null
  Injuries: null
  AlcoholRelated: null
  DistractionRelated: null
  DrugRelated: null
  EstimatedDamages: null
  WeatherCondition: null
  LightCondition: null
  CrashSeverity: null
  WithinCityLimits: null
  FirstHarmfulEvent: null
  FirstHELocation: null
  FirstHERelationToJct: null
  SchoolBusRelated: null
  Pedestrians: null
  IncapacitatingInjuries: null
  RoadSurfaceCondition: null
  ContributingCircumstanceRoad1: null
  ContributingCircumstanceRoad2: 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:   Field Groups   Contingent Values

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