Project

General

Profile

Actions
Copy link

Data Services #1910

closed

Update Chainage for AccidentData

Added by Madhuri Pinky Mendu about 1 month ago. Updated 16 days ago.

Status:
Closed
Priority:
Normal
Assignee:
Madhuri Pinky Mendu
Start date:
22/05/2025
Due date:
% Done:

0%

Estimated time:
Deployed In:
Category:

Description

Some chainages are not updated/missing.
Total MDR and SH roads are 18278, but chainage updated only for 18230 records.
On 22-05-25,I have verified the data for why those are not updated. And tried to execute the chainageupdate sp to update chainage but, chainages are not updated
need to check sp and update the remaining chainages.

Files

AccDtls_ChainagesNotUpdated.xlsx (40.9 KB) AccDtls_ChainagesNotUpdated.xlsx 48RecordsDataVerification Madhuri Pinky Mendu, 03/06/2025 06:08 PM
Actions
Copy link
 #1

Updated by Madhuri Pinky Mendu 28 days ago

On 02Jun2025, I have verified data and SP
some chainages were not updated in the AccidentDetails table,
Due to distance of Gps latLongs & Accident LatLongs (dbo.CalculateDistance(@Lat, @Long, g.Latitude, g.Longitude) AS Distance) exceeds 50m(Radius).So that's why for 48 records Chainages are not updated. Those are includes in MDR098,MDR100,SH006A,SH008,SH019,SH020,SH020B,SH036,SH087,SH114,SH117,SH123 Roads.

Actions
Copy link
 #2

Updated by Madhuri Pinky Mendu 16 days ago

  • Status changed from In Progress to Closed
Actions
Copy link

Also available in: Atom PDF