exporting data from camera – using gps-photo … · 2011-04-07 · exporting data from camera –...

Exporting data from Camera – Using GPS-Photo Link GIS PROProcedure is critical

– Separate camera folders for each camera is required on the download computer.

• Downloads are automatically placed in a date folder

– Software transfers and converts the data (after set up)

– Staff member to delete data off camera and hand camera back.

Procedure Document for Assigned Staff Developed

1Presenter Darren Shepherd - Shepherd Services Pty Ltd

Presenter Darren Shepherd - Shepherd Services Pty Ltd 2

Presenter Darren Shepherd - Shepherd Services Pty Ltd 3

Presenter Darren Shepherd - Shepherd Services Pty Ltd 4

Presenter Darren Shepherd - Shepherd Services Pty Ltd 5

GIS Software Outputs

CSV Output– Photo number & name is linked to dimension and

activity dataMapping

– Google Earth– MapInfo– ESRI

Photos are tagged with memo details and GPS data

6Presenter Darren Shepherd - Shepherd Services Pty Ltd

Lon Lat TimeStamp Original FixType GPSValidSerialNum

MemoTitle1 Memo1

MemoTitle2 Memo2

MemoTitle3 Memo3

MemoTitle4 Memo4

MemoTitle5 Memo5

143.5421 -18.2897 3/03/2009 4:33RIMG1554.JPG 3d T 34100058Activity

Reinstate Gravel Shoulders Width m 2Length m 250

Emergency Work No

Number of 1

143.5372 -18.2897 3/03/2009 4:37RIMG1555.JPG 3d T 34100058Activity

Reinstate Gravel Shoulders Width m 2Length m 500

Emergency Work No

Number of 1

143.5322 -18.2894 3/03/2009 4:40RIMG1556.JPG 3d T 34100058Activity

Reinstate Gravel Shoulders Width m 2Length m 500

Emergency Work No

Number of 1

143.5266 -18.2887 3/03/2009 4:42RIMG1557.JPG 3d T 34100058Activity

Reinstate Gravel Shoulders Width m 2Length m 500

Emergency Work No

Number of 1

143.5039 -18.2847 3/03/2009 4:46RIMG1558.JPG 3d T 34100058Activity

Seal Pavement Saturation Width m 2Length m 5

Emergency Work No

Number of 1

143.4442 -18.2919 3/03/2009 4:56RIMG1559.JPG 3d T 34100058Activity

Reinstate Gravel Shoulders Width m 2Length m 500

Emergency Work No

Number of 1

143.4236 -18.2918 3/03/2009 5:01RIMG1560.JPG 2d F 34100058Activity

Reinstate Gravel Shoulders Width m 2Length m 500

Emergency Work No

Number of 1

143.4032 -18.2896 3/03/2009 5:06RIMG1561.JPG 3d T 34100058Activity

Seal Pavement Saturation Width m 2Length m 10

Emergency Work No

Number of 1

143.3245 -18.2874 3/03/2009 5:25RIMG1562.JPG 3d T 34100058ActivityRemoval Silt/Debris Width m 15Length m 150

Emergency Work No

Number of 1

143.3245 -18.2874 3/03/2009 5:29RIMG1563.JPG 3d T 34100058Activity

Replace GuidePost Width m 8Length m 100

Emergency Work No

Number of 6

143.3245 -18.2874 3/03/2009 5:30RIMG1564.JPG 3d T 34100058ActivityReplace Signs Width m 8Length m 100

Emergency Work No

Number of 6

CSV Export

Data is ready for loading into database application for estimating process, yet processing can be completed in Excel.

7Presenter Darren Shepherd - Shepherd Services Pty Ltd

Photo – Water Mark

8Presenter Darren Shepherd - Shepherd Services Pty Ltd

Google Earth Output

9Presenter Darren Shepherd - Shepherd Services Pty Ltd

GIS (MapInfo & ESRI) Export

10Presenter Darren Shepherd - Shepherd Services Pty Ltd

Presenter Darren Shepherd - Shepherd Services Pty Ltd 11

Processing of data using MapInfo – Road Names/Chainages-

Requires accurately mapped road locations.

Presenter Darren Shepherd - Shepherd Services Pty Ltd 12

Processing of data using MapInfoRequires the creation of chainage points along the roads

Presenter Darren Shepherd - Shepherd Services Pty Ltd 13

Processing of data using MapInfoAssigning road names, numbers and chainage to the flood damage points data.

Using a buffering process toadd attribute information

Presenter Darren Shepherd - Shepherd Services Pty Ltd 14

Using MapInfo as an auditing tool

Locating sites that have been submitted in a previous claim.

MapInfo - Result

15Presenter Darren Shepherd - Shepherd Services Pty Ltd

Positive and NegativePositive Negative

The supervisors had no problems with the use of the cameras

Process is more technical. However this didn’t cause any problems at Etheridge.

Matching photo with defects is not a problem as directly linked

SD card failure. We had 1 occur. I suggest you buy the best SD cards. We used cheaper ones and changed after this occurred.

Saves a huge amount of time in processing the data. Ability to complete more Auditing.

Possibility that memo fields don’t get fill in. Didn’t seem to be a problem at Etheridge.

Having the road centreline and chainage in GIS makes the collection process far quicker than the manual method of assignment of road name and chainage.

GPS can not engage at time. Need to check this each time. Procedure was put in place to resolve this.

Location by GPS ensures accurate location in comparison with trip meter location. Where origin issues as well as trip meter accuracy is a common problem.

16Presenter Darren Shepherd - Shepherd Services Pty Ltd

Claims ProcessWhy we used a database application.

– Easy of Auditing and checking.

– Printing reports is difficult and time consuming in excel

– Any changes to estimate and reporting is time consuming in excel.

– Linking photos is an issue in excel.

17Presenter Darren Shepherd - Shepherd Services Pty Ltd

Claim Process – Database Application• Imported collection data into database

– Photo’s and attribute data????• Easy ability to check qty’s and activities assigned• Easy to make modifications.• Standard submission reports and workforce

reports developed in system and can be run by site, road or event or any combination.

• Easy to re-run reports again.• System completes claim submission reports and

totals.

18Presenter Darren Shepherd - Shepherd Services Pty Ltd

Site Details

Dissected Estimate

19Presenter Darren Shepherd - Shepherd Services Pty Ltd

Lump sum estimates by site

Batch loading of photos

20Presenter Darren Shepherd - Shepherd Services Pty Ltd

Submission Reports

21Presenter Darren Shepherd - Shepherd Services Pty Ltd

Data Checks &Workforce Reports• Very useful

database reports for outside staff and for initial checking of data

22Presenter Darren Shepherd - Shepherd Services Pty Ltd

Submission Reports

Road summary

23

Site summary

Presenter Darren Shepherd - Shepherd Services Pty Ltd

Future Development

• Use of GIS in the field, by Laptops or PDA, instead of using hard copy printouts.

Presenter Darren Shepherd - Shepherd Services Pty Ltd 24

Final comments• Database application requires consulting assistance

to prepare the submission.

• GPS Camera definitely made it easier for field collection, yet some importing processes are more complex. Time saved in field and processing make this the best method.

• A review of cost for implementation hasn’t been completed for this presentation.

25Presenter Darren Shepherd - Shepherd Services Pty Ltd