| Versions |
  |
|
| Author |
 Topic  |
|
garygid
USA
1322 Posts |
 Posted - 18 janv. 2007 : 08:43:04
|
Amesdp:
I wanted to see the Lon,Lat for a "deleted" entry, because ...
In your first "printout" of the spreadsheet above, record
3 deletes someting (either camera 1 or 2) but one cannot tell
which camera it deletes. You can only tell by matching the
Lon,Lat, right? |
 |
|
|
garygid
USA
1322 Posts |
Posted - 18 janv. 2007 : 09:11:19
|
Maybe I am not understanding correctly about "edited" and "deleted"
records. From your first "printout" it looks like a "new" record
is put into the file when the camera is "created", and then
never changed again.
If it is edited, an "edited" record is added to the file, but
the "new" record remains. However, the "edited" record's data
logically (but not physically) replaces the "new" record's data.
For example, record 12, 14, and 15 are "replacements" for 7.
So, when you write out the data, without the "old garbage",
record 7, 12, and 14 would not be written, but 15 would
be written as "new". Right?
Likewise, when there is a "deleted" record, neither it, nor
its co-located "new" record (and "edited" records, if any)
should be written out.
Record 3 deletes either 1 or 2, correct?
and Records 8,9,10,11 delete all but record 7, right?
Then, if 17 deleted the camera at (123.1366581 49.14830167),
and from the data there, we cannot tell which camera it deletes,
then records 7, 12, 14, 15, and 17 would not be written out.
Right?
So, the database, in normal use, only gets added to, never
changed in the middle?
Or, do I totally misunderstand?
Thanks for your Good Work, and kindness for helping me. |
|
|
|
garygid
USA
1322 Posts |
Posted - 18 janv. 2007 : 09:17:31
|
If I am correct, then a "cleaned up" output file would have
no records with "edited" or "deleted" status, all the records
would be marked as "new" status.
But, as my wife reminded me, I was wrong once before ... (grin). |
|
|
|
Amesdp
Canada
435 Posts |
Posted - 18 janv. 2007 : 16:54:00
|
I haven't done a lot of experimenting on the Mio yet, but you appear to be correct, garygid. This speedcam database is even dumber than it first appears. Each new record written for a particular camera coordinate supersedes the previous one.
So if you see:
1: -123, 49 New
2: -123, 49 Edited
3: -123, 49 Deleted
It means that a camera was created, edited, and then deleted, and should not appear any more. |
Edited by - Amesdp on 18 janv. 2007 16:55:30 |
|
|
|
garygid
USA
1322 Posts |
Posted - 18 janv. 2007 : 19:15:46
|
Amesdp:
OK, thanks for checking. I thought that I remembered reading somewhere
that the SPUD "database" was a "simple" (read "idiot"?) database.
Suggestion: maybe a good "feature" for your SpudTool is to give it a
"raw" mode for advanced experiments, and a default "end-user" mode.
The "raw" mode would read all the SPUD entries into the spreadsheet
(as you do now) and write all the spreadsheet entries to the new SPUD
(in whatever sorted order that they appear in the spreadsheet).
The "Garbage-Clean" function could be invoked (whenever desired by the
user) to clean out the "unused" records in the spreadsheet, independent
of writing anything to a file.
The "end-user" mode would hide the complexity of the "edited" and
"deleted" records. It would read the raw data (as above), but do an
automatic Garbage-Clean just after it populates the spreadsheet.
Thus, the end-user would see only "new" records. This user could edit
the "new" records directly, and write the changed (but still "new")
spreadsheet entries out to a SPUD file. This end user can simply
delete a "new" record to get rid of a camera, and copy and paste
spreadsheet rows (or import) to add new entries. Maybe a warning of
"Two cameras at the same location" should be given before writing,
when needed (see below).
With this method, the read and write are really just "raw",
and the "end-user" sees only the effective entries, just like
one would see on the map.
Maybe a "Proximity-Check" would be a good function, allowing the
user to select one of several "distances"? One "distance" could
be to only complain if the Lon,Lat is co-located, or "At-Same-Spot".
But, a "readby" warning could be given using a setable "distance"
of within plus or minus delta_Latitude and delta_Longitude (and it
would be easy to implement).
One further thing, here we see the Lat,Lon as degrees and decimal
parts of a degree (dd.dddddD). You might also provide display of the
lat and lon in the "dd mm ss.ss" or "dd mm.mmmmm" formats (probably
display as strings).
When importing, it would be an important compatibility feature
to allow the different Lon,Lat formats to be read and converted.
For other fields, maybe have default text strings to use for
inport and export, but also allow the user to assign a text string
(in your options) for importing, exporting, and display of each
field's variables?
Just ideas, if you think they are good, but do not want to spend
the time to do them, maybe I can help.
When your Excel SpudTool_V1 is available to try, please let us know.
Thanks, Gary
|
|
|
|
Amesdp
Canada
435 Posts |
Posted - 18 janv. 2007 : 19:29:06
|
First part already done. If the option "Show deleted and superseded records" = Yes, you get the raw version. Records which are superseded or deleted are marked in light blue color, and records which are superseded by a later record have a forward reference to the superseding record. If you set the option = No, all deleted and superseded records are removed, and you see only the clean version. There's a record count field in the header now that shows how many total records were read and how many are actually valid cams.
As for a proximity check, that would be easy to do. I don't have time to try every idea, but the spreadsheet program is really easy to edit or extend for anyone who has Excel. I'll gladly advise anyone who wants to add something. I'll probably move on to a Google Earth exporter right now, so I can visualize the cams on my PC for editing.
A working version of the spreadsheet is available to anyone who wants to help with testing, just email me at "amesdp at gmail dot com" and I'll mail back a copy. |
Edited by - Amesdp on 21 janv. 2007 17:27:30 |
|
|
|
garygid
USA
1322 Posts |
Posted - 20 janv. 2007 : 00:55:14
|
Works quite well, but one time after changing the
option to "not read obsolete" cameras, it left one "stray"
line in Excel, but I reread again, and that line went away.
Formatting the Lon,Lat numbers to always show 8 decimal places
might be good. As it is, trailing zeros cause the number to
"shift" to the right, making it harder to scan and compare.
I have not yet tried the export to Google earth, but it is a
great feature. Then, Import locations from the same?
Also, a read-file (and add) instead of a clear and reread,
to compbine data from two SPUD (or google) files?
However, great work in a short time.
Thanks for letting me try it.
|
|
|
|
Amesdp
Canada
435 Posts |
Posted - 20 janv. 2007 : 01:03:18
|
The leftover "stray" is because I took out the code to clear trailing unused lines after deleting superseded records, but the strays won't be saved or exported because of the blank line at the end of the valid records. But I'll clean it up.
Today I added GPX import so we can import cam files from external sources in GPX format.
I suppose I could add a Google Earth import too - both GPX and Google Earth are similar xml formats.
This is an Excel spreadsheet, so you're free to change the formats on the first page to whatever you want. You can even add extra columns to show the lat/longs in different formats, automatically calculated. |
|
|
|
ZzRicezZ
20 Posts |
Posted - 21 janv. 2007 : 05:55:08
|
Question.. I got POI entry for redlight camera and speedtraps, is there an easy way to add them into the SpeedcamUpdates?
Used the GPXtoSPUD program to get the POI into speedcamupdate. Question.. Do I still need the POI after I got them into SPUD? |
Edited by - ZzRicezZ on 21 janv. 2007 06:33:29 |
|
|
|
Amesdp
Canada
435 Posts |
Posted - 21 janv. 2007 : 07:25:35
|
| Someone suggested keeping a POI duplicating each speedcam just so you can find them easily later to delete or edit, since there's no way to list speedcams and edit from the list view on the Mio. But my spreadsheet editor will do that, so there's no need for the duplicate POI listing if you use the spreadsheet. |
|
|
|
torowl
Canada
105 Posts |
Posted - 21 janv. 2007 : 08:33:19
|
Adding description about Mobile Cameras speed limit.
|
|
|
|
Amesdp
Canada
435 Posts |
Posted - 21 janv. 2007 : 17:30:42
|
The latest version of the Speedcams spreadsheet has a Description field for each cam, but of course it can't be saved in the SPUD file, only imported from and exported to other formats. If we find some examples of imported files that have speed limits in the description or comments, it's easy to create a little text parser to extract it, but there's no fixed format.
I also put in the functions to check for proximity to other cams, and to import from Google Earth. |
Edited by - Amesdp on 21 janv. 2007 17:33:11 |
|
|
|
ZzRicezZ
20 Posts |
Posted - 21 janv. 2007 : 19:02:17
|
| Hi i'm using Amesdp program and I notice fixed speed cam and Red Light Cam both show the same icon on the map. Fixed cameras from torowl first post. Is that normal? |
|
|
|
torowl
Canada
105 Posts |
Posted - 21 janv. 2007 : 20:07:59
|
| In the map, they are all the same icon. When you are approaching the camera, it will alarm with different picture on the screen. |
|
|
|
Amesdp
Canada
435 Posts |
Posted - 21 janv. 2007 : 20:43:15
|
You have to select Visible Warning = Detailed under the Safety Cams option in MioMap to see the pop-up details as you approach the cam.
I've been doing some more testing on the road, and I can't get cams to alarm at all unless Direction = All Directions. I think MioMap has a bug in handling angles. Maybe the angle of approach to the cam has to be so exact that it can never work with real-world positioning errors. |
|
|
|
Topic |
|
|
|
| This page was generated in 1,28 seconds. |
 |
|
- 
- 
SpeedcamUpdates.spud Data Structure Specification
