| View previous topic :: View next topic |
| Author |
Message |
Technical
Occasional Visitor
Joined: Mar 01, 2006
Posts: 4
|
 Posted: Thu Oct 12, 2006 8:09 pm Post subject: Co ordinate Converter |
 |
|
Hi
I have been able to obtain a Excel spreadsheet with all the static, mobile and temp camera locations in my county. The excel sheet has a descriptive location followed by 2 x 6 diget referance data. I think these are os referances. I have been able to briefy verify that there are a number of new sites not shown in the early oct 06 release. Does anyone know of a programme that can be dowloaded to convert this data into the co-ordinates required for submission to the database? :o |
|
| Back to top |
|
 |
BMW330
Pocket GPS Verifier
Joined: May 20, 2006
Posts: 389
Location: Sydney, Australia
|
| Posted: Tue Oct 17, 2006 3:16 pm Post subject: Re: Co ordinate Converter |
|
|
| Technical wrote: | Hi
I have been able to obtain a Excel spreadsheet with all the static, mobile and temp camera locations in my county. The excel sheet has a descriptive location followed by 2 x 6 diget referance data. I think these are os referances. I have been able to briefy verify that there are a number of new sites not shown in the early oct 06 release. Does anyone know of a programme that can be dowloaded to convert this data into the co-ordinates required for submission to the database? :o |
Show me some sample data and I might be able to help... |
|
| Back to top |
|
|
Technical
Occasional Visitor
Joined: Mar 01, 2006
Posts: 4
|
| Posted: Wed Oct 18, 2006 8:22 pm Post subject: Re: Co ordinate Converter |
|
|
| BMW330 wrote: | | Technical wrote: | Hi
I have been able to obtain a Excel spreadsheet with all the static, mobile and temp camera locations in my county. The excel sheet has a descriptive location followed by 2 x 6 diget referance data. I think these are os referances. I have been able to briefy verify that there are a number of new sites not shown in the early oct 06 release. Does anyone know of a programme that can be dowloaded to convert this data into the co-ordinates required for submission to the database? :o |
Show me some sample data and I might be able to help... |
Hi
Sample data as requested
APPROXIMATE MAP REFERENCES
START END
SiteName Easting_Start Northing_Start Easting_End Northing_End
A3102 Snow Hill, Hilmarton 401880 175750 401790 176740
A3102 Lyneham 402227 179066 402460 178636 |
|
| Back to top |
|
|
BMW330
Pocket GPS Verifier
Joined: May 20, 2006
Posts: 389
Location: Sydney, Australia
|
| Posted: Wed Oct 18, 2006 9:12 pm Post subject: Re: Co ordinate Converter |
|
|
| Need 1 or 2 more points please... |
|
| Back to top |
|
|
BMW330
Pocket GPS Verifier
Joined: May 20, 2006
Posts: 389
Location: Sydney, Australia
|
|
| Back to top |
|
|
coconut
Regular Visitor
Joined: Jan 31, 2005
Posts: 87
Location: Staffordshire
|
| Posted: Thu Oct 26, 2006 9:21 am Post subject: They ARE OS Grid References ! |
|
|
Actually guys I think you will find that these are perfectly valid 12 figure OS grid References - accurate to 1 metre !
I have only checked the first one : 401880 175750 which is about a 1/4 mile North of Hilmarton, on the A3102 after it crosses a stream !
The first block of 6 figures are the Eastings and the second block of 6 are the Northings. The first number from eack block identify the Map Sheet ( 100 Km ) - In the above example 4 1 converts to map sheet SU, so the full Grid Ref is SU 01880 75750.
You can decode the Uk map sheets with the following :
Number the grid starting from the bottom left corner ("0,0" ) and you will see how Map sheet SU is arrived at from "4,1" - i.e "4" across ( Eastings ) and "1" up ( Northings ). Along the corridor & up the stairs !
[/img]
_________________
iPhone SE, TomTom Go 5000, Garmin Zumo XT. |
|
| Back to top |
|
|
Oldie
Pocket GPS Moderator
Joined: 22/11/2002 13:33:48
Posts: 992
Location: Surrey, UK
|
| Posted: Thu Oct 26, 2006 8:15 pm Post subject: |
|
|
My POIConverter program http://rjdavies.users.btopenworld.com/html/poiconverter.html will read files that contain Eastings and Northings. Have a look at AutoRoute Pushpins in the Help file after you have installed it.
Richard
_________________
Various TomToms, Garmin eTrex Legend, GPSMAP 60CSx, Oregon 550t, Forerunner 405 |
|
| Back to top |
|
|
|
![]() Posted: Today Post subject: Pocket GPS Advertising |
|
|
We see you’re using an ad-blocker. We’re fine with that and won’t stop you visiting the site.
Have you considered making a donation towards website running costs?. Or you could disable your ad-blocker for this site. We think you’ll find our adverts are not overbearing!
|
|
| Back to top |
|
|
|
Forum FAQ
Search
Usergroups
Profile
Log in for private messages
Log in
