Camera database

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
Does anyone have a current camera database in .csv for NZ? I don't really need RLC's but will take it if included.
POI factory has one but it's 7 years old.
 

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
There's a PDF of all stationary "safe speed" camera locations in New Zealand published by police.govt.nz. Would all the stationary speed cams there be "safe speed" cameras?
 

dudeinnz

NZCTG
Moderator
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Oct 14, 2015
Messages
2,272
Reaction score
2,265
Location
Christchurch
Rating - 100%
1   0   0

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
There's a PDF of all stationary "safe speed" camera locations in New Zealand published by police.govt.nz. Would all the stationary speed cams there be "safe speed" cameras?
Yes. But their idea of safe speed and mine differs.
-- Double Post Merged: --
You might use the average values for the zone begins and zone ends to get single GPS coordinates for each camera. Or if the cameras only work for oncoming traffic, you might use just the zone begin coordinates. The CSV must be in the following format:

longitude, latitude, "short description"
That's way beyond my skills and knowledge. Where can I get info on converting that to a database?
 
Last edited:

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
Yes. But their idea of safe speed and mine differs.
-- Double Post Merged: --

That's way beyond my skills and knowledge. Where can I get info on converting that to a database?
You'd have to do it manually. There's only 48 of them, so it wouldn't take so long if you drive in these areas.

Start with the first one:

Twin Coast Discovery Highway | Kaiwaka | -36.170245,174.447012 | -36.190333,174.450727 | August 2018

If the cameras only measure oncoming traffic, you should use the first coordinates (zone begin):

174.447012,-36.170245,"Twin Coast Discovery Highway"

Otherwise, you may have to average the values to get the approximate center:

(174.447012 + 174.450727) / 2 = 174.448869
(-36.170245 + -36.190333) / 2 = -36.180289

174.448869,-36.180289,"Twin Coast Discovery Highway"

Then repeat for the remaining 47 cameras. Obviously it will be a lot more work if you average the coordinates.

Put them all in a text file named Speed-Cameras.csv and copy the file to the folder named /com.johnboysoftware.jbv1 on your device. Then go to Settings > Marks > Manually Import RLC and SC Data, make sure only the SC filename is checked, and click the IMPORT button.
 
Last edited:

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
Does anyone know if all these cameras only measure vehicles traveling in one direction?
 

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
You'd have to do it manually. There's only 48 of them, so it wouldn't take so long if you drive in these areas.

Start with the first one:

Twin Coast Discovery Highway | Kaiwaka | -36.170245,174.447012 | -36.190333,174.450727 | August 2018

If the cameras only measure oncoming traffic, you should use the first coordinates (zone begin):

174.447012,-36.170245,"Twin Coast Discovery Highway"

Otherwise, you may have to average the values to get the approximate center:

(174.447012 + 174.450727) / 2 = 174.448869
(-36.170245 + -36.190333) / 2 = -36.180289

174.448869,-36.180289,"Twin Coast Discovery Highway"

Then repeat for the remaining 47 cameras. Obviously it will be a lot more work if you average the coordinates.

Put them all in a text file named Speed-Cameras.csv and copy the file to the folder named /com.johnboysoftware.jbv1 on your device. Then go to Settings > Marks > Manually Import RLC and SC Data, make sure only the SC filename is checked, and click the IMPORT button.
OK. I get that part, easy enough. But I don't know how to create a database, specifically on a Mac.
I don't want to tie you up on this JB, if you point me in the right direction I'll hunt it down.
-- Double Post Merged: --
Does anyone know if all these cameras only measure vehicles traveling in one direction?
All our cameras detect both directions.
 

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
OK. I get that part, easy enough. But I don't know how to create a database, specifically on a Mac.
I don't want to tie you up on this JB, if you point me in the right direction I'll hunt it down.
-- Double Post Merged: --

All our cameras detect both directions.
You don't have to create a database. You need to create a text file named Speed-Cameras.csv, and put lines of text in it as I described above. If one camera handles both directions, or each zone has two cameras, then you would want to do the averaging. Or if the zones are small enough, and you're gonna use a big warning distance in JBV1, then you could just use the zone begin coordinates.
 

KiwiBloke

Floor it & swerve
Intermediate User
Beginner User
General User
Newly Registered
Joined
Feb 22, 2017
Messages
219
Reaction score
150
Location
New Zealand
Rating - 0%
0   0   0
@LouG Working on it... Been meaning to get onto this for a while but I wasn't sure how best to handle the positional uncertainty (might be possible to get exact locations from Waze somehow, or tap local knowledge). But I like @johnboy00 's approach of averaging for a rough center and use a large warning distance.
-- Double Post Merged: --
@LouG - try this for size.

(NB: Will be some time before I'll be transiting through any of these areas, no warranty expressed or implied :shifty:)
 

Attachments

Last edited:

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
@LouG Working on it... Been meaning to get onto this for a while but I wasn't sure how best to handle the positional uncertainty (might be possible to get exact locations from Waze somehow, or tap local knowledge). But I like @johnboy00 's approach of averaging for a rough center and use a large warning distance.
-- Double Post Merged: --
@LouG - try this for size.

(NB: Will be some time before I'll be transiting through any of these areas, no warranty expressed or implied :shifty:)
Nice!
 

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
You don't have to create a database. You need to create a text file named Speed-Cameras.csv, and put lines of text in it as I described above. If one camera handles both directions, or each zone has two cameras, then you would want to do the averaging. Or if the zones are small enough, and you're gonna use a big warning distance in JBV1, then you could just use the zone begin coordinates.
OK Gotcha. I'll give it a go.
Thanks JB.
-- Double Post Merged: --
@LouG Working on it... Been meaning to get onto this for a while but I wasn't sure how best to handle the positional uncertainty (might be possible to get exact locations from Waze somehow, or tap local knowledge). But I like @johnboy00 's approach of averaging for a rough center and use a large warning distance.
-- Double Post Merged: --
@LouG - try this for size.

(NB: Will be some time before I'll be transiting through any of these areas, no warranty expressed or implied :shifty:)
Thank you, I'm deeply indebted, you can have my firstborn.
 

KiwiBloke

Floor it & swerve
Intermediate User
Beginner User
General User
Newly Registered
Joined
Feb 22, 2017
Messages
219
Reaction score
150
Location
New Zealand
Rating - 0%
0   0   0
OK Gotcha. I'll give it a go.
Thanks JB.
-- Double Post Merged: --

Thank you, I'm deeply indebted, you can have my firstborn.
Lol! Let's see how well it works out first...
 

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
OK JB, I've done it as per your instructions. How do I tell if it downloaded OK? After I hit import, I had a SC=0 message on the screen
 

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
OK JB, I've done it as per your instructions. How do I tell if it downloaded OK? After I hit import, I had a SC=0 message on the screen
SC = 0 means no data imported. Give me a bit to see why that file won't import.
-- Double Post Merged: --
It worked for me, SC=48. How did you download the file and copy it to your device?
 
Last edited:

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
I saved the file to my Mac, then sent it via email to my phone and saved it. But then I had to B/T the file to my dedicated phones as they don't have email. The file looked OK when saved to those, but it obviously didn't transfer properly
 

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
I saved the file to my Mac, then sent it via email to my phone and saved it. But then I had to B/T the file to my dedicated phones as they don't have email. The file looked OK when saved to those, but it obviously didn't transfer properly
I saved to my Mac and copied straight to my plugged-in phone. Try that instead. Text files can get screwed up when sent as an email attachment.
 

LouG

PSL +5
Intermediate User
Beginner User
General User
Newly Registered
Joined
Jan 2, 2014
Messages
1,885
Reaction score
1,484
Rating - 0%
0   0   0
OK, sorted it. It must have got corrupted. I sent it another way and it worked fine.
-- Double Post Merged: --
Thanks all, what a great forum this is.
 
Last edited:

Mithheru

Learning to Drive
General User
Newly Registered
Joined
Aug 8, 2018
Messages
50
Reaction score
97
Rating - 0%
0   0   0
@LouG Working on it... Been meaning to get onto this for a while but I wasn't sure how best to handle the positional uncertainty (might be possible to get exact locations from Waze somehow, or tap local knowledge). But I like @johnboy00 's approach of averaging for a rough center and use a large warning distance.
-- Double Post Merged: --
@LouG - try this for size.

(NB: Will be some time before I'll be transiting through any of these areas, no warranty expressed or implied :shifty:)
Guys, why didn't anyone send me a message on this? I need all this type of info in order to keep updating the R3 GPS database (Uniden has fallen behind a bit, particularly in Australia).

I've looked at your file. However, many of the coordinates are not even on roads. You really can't average the position as some of the coordinates in the NZ police data extends over some distance, and includes bends in roads etc.

I don't want to release it publicly, but if anyone wants, I can send files which are based upon my software that spits out all the GPS data contained in the R3 GPS database. At the moment the only camera I don't know the exact location of in New Zealand is the one between -39.62694626,174.3699079 and -39.6312087,174.3771379. At the moment using Google Earth, I reckon this one is probably at -39.62905,174.37359.
 

johnboy00

Geaux Tigers!
Premium Member
Advanced User
Intermediate User
Beginner User
General User
Newly Registered
Joined
Sep 6, 2016
Messages
3,053
Reaction score
4,669
Location
Raleigh, NC
Rating - 0%
0   0   0
I assumed the zones had to be fairly short and straight. How can one camera cover a long zone with curves in it?
 

Donation drives

RDF Server & License Fees (Mar 2019) (ACTIVE)

This donation drive covers the server and licensing fees for RDF for the month of March 2019...
Goal
$334.00
Earned
$430.00
This donation drive ends in

Latest threads

Social Group Activity

Forum statistics

Threads
79,097
Messages
1,178,094
Members
18,143
Latest member
Radarious
Top