Active Topics
-
[HOWTO] Comprehensive Firmware Flashing Guide for N9 (1,580)
to Nokia N9 / N950 by aspergerguy - 8 hrs, 11 mins ago -
Nokia N9-00 Prototype Build S1.12 (RM-680 codename "Dali") (250)
to Nokia N9 / N950 by en0s - 3 days, 4 hrs ago -
[Announce] Maebble - Pebble support for Maemo (118)
to Applications by glo-worm - 3 days, 16 hrs ago -
Possible to flash Leste to eMMC? (6)
to Maemo 7 / Leste by Eri - 4 days, 7 hrs ago - more...
rhouge |
2007-05-22
, 18:31
|
|
Posts: 86 |
Thanked: 3 times |
Joined on Apr 2007
|
#51
|
Originally Posted by gnuite
Bummer. How about the other half of that equation, regarding bringing mapper up to the foreground?
|
|
2007-05-22
, 19:54
|
|
Posts: 481 |
Thanked: 190 times |
Joined on Feb 2006
@ Salem, OR
|
#52
|
Here is an idea.
Make in the db where you want to keep the map tiles two tables.
one coordinates and CRC of the image tile and in the second table the CRC of the image and the image. This way you can exclude duplicates, we'll have only one tile that is blue... or white... or whatever.
you make the CRC as a unique key in the images table.
when you insert, you insert in both tables, in the image table the insert will fail (if the CRC is already there). this way you won't have to check if the image is already in the table before inserting.
What do you think?
-ioan
Make in the db where you want to keep the map tiles two tables.
one coordinates and CRC of the image tile and in the second table the CRC of the image and the image. This way you can exclude duplicates, we'll have only one tile that is blue... or white... or whatever.
you make the CRC as a unique key in the images table.
when you insert, you insert in both tables, in the image table the insert will fail (if the CRC is already there). this way you won't have to check if the image is already in the table before inserting.
What do you think?
-ioan
 |
|
2007-05-22
, 23:05
|
|
Posts: 1,245 |
Thanked: 421 times |
Joined on Dec 2005
|
#53
|
Originally Posted by ioan
Sounds like a good idea, although I'll probably reserve it for tiles that are 103 bytes large, since those are the only ones that are a solid color. All that CRC calculation would be such a waste of CPU.
Here is an idea.
Make in the db where you want to keep the map tiles two tables.
one coordinates and CRC of the image tile and in the second table the CRC of the image and the image. This way you can exclude duplicates, we'll have only one tile that is blue... or white... or whatever.
you make the CRC as a unique key in the images table.
when you insert, you insert in both tables, in the image table the insert will fail (if the CRC is already there). this way you won't have to check if the image is already in the table before inserting.
What do you think?
|
|
2007-05-24
, 11:15
|
|
Posts: 18 |
Thanked: 0 times |
Joined on May 2006
|
#54
|
Maemo Mapperi is great because as far as I know it is currenlty the only available native WMS-client for maemo platform. And WMS allows me to serve my own maps quite easily. Plans for db-utilization sound great, expect that features of PostGIS are perhaps too far from here.
WFS-support for MM would be nice
WFS-support for MM would be nice
|
|
2007-05-24
, 11:44
|
|
Posts: 62 |
Thanked: 3 times |
Joined on Feb 2006
@ Italy
|
#55
|
Originally Posted by ioan
+1 to this.
Here is an idea.
Make in the db where you want to keep the map tiles two tables.
one coordinates and CRC of the image tile and in the second table the CRC of the image and the image.
Or, if there's some fast way to detect if an image is just a single color one while retrieving it, avoid storing it in the database and store just the corresponding color information. So, imagine a table with fields:
coordinates | display
"display" is a short string: when it does begin with "#", the value is considered as a color (to render a monocolor tile for that coordinates), otherwise it is considered as the id of the image to render (picking it from a second table with fields: id | image).
__________________
Nokia 770 with ITOS 3.2006.49-2, aka maemo 2.2, aka gregale
Nokia 770 with ITOS 3.2006.49-2, aka maemo 2.2, aka gregale
|
|
2007-05-24
, 16:52
|
|
Posts: 481 |
Thanked: 190 times |
Joined on Feb 2006
@ Salem, OR
|
#56
|
I did a test with creating a table just for the tile image and the crc32, the table looks like this:
CREATE TABLE testtable ([crc32] VARCHAR (8) PRIMARY KEY UNIQUE, [maptile] BLOB COLLATE NOCASE);
I didn't do anything for coordinates, nothing special to see there.
I ran the test on 213304 map tiles, and at the end, in the database I had 135417 unique tiles (77887 were duplicates!).
The 213304 tiles on my computer use 897MB (size on disk), and the database, after excluding the duplicates is about 290 MB.
I used sqlite3.
-ioan
CREATE TABLE testtable ([crc32] VARCHAR (8) PRIMARY KEY UNIQUE, [maptile] BLOB COLLATE NOCASE);
I didn't do anything for coordinates, nothing special to see there.
I ran the test on 213304 map tiles, and at the end, in the database I had 135417 unique tiles (77887 were duplicates!).
The 213304 tiles on my computer use 897MB (size on disk), and the database, after excluding the duplicates is about 290 MB.
I used sqlite3.
-ioan
|
|
2007-05-24
, 19:20
|
|
Posts: 1,245 |
Thanked: 421 times |
Joined on Dec 2005
|
#57
|
Originally Posted by ioan
How many of those duplicates (if any) are greater than 103 bytes?
I ran the test on 213304 map tiles, and at the end, in the database I had 135417 unique tiles (77887 were duplicates!).
|
|
2007-05-24
, 20:21
|
|
Posts: 481 |
Thanked: 190 times |
Joined on Feb 2006
@ Salem, OR
|
#58
|
Originally Posted by gnuite
I didn't count them... but just now I modified my test app to check that too.. and after a little over 9000 files, I have this:
How many of those duplicates (if any) are greater than 103 bytes?
the caption shows the number of processed files, the list, first field is the size, the second how many duplicates with that size...
I suppose on windows we have 106 bytes not 103.
-ioan
|
|
2007-05-24
, 23:40
|
|
Posts: 2 |
Thanked: 0 times |
Joined on May 2007
|
#59
|
Any plans for adding a Golf Course GPS program that would allow for course maps to be built, shared or downloaded from a respository? Possibly a program similar to Sky Caddie. This would be a superb mapping application.
I really appreciate your present Maemo Mapper program and look forward to version 2.0
I really appreciate your present Maemo Mapper program and look forward to version 2.0
|
|
2007-05-25
, 00:50
|
|
Posts: 165 |
Thanked: 5 times |
Joined on Jan 2007
@ Boston MA USA
|
#60
|
Originally Posted by ioan
Depends on the repository. Also on Windows, I see the following sizes for featureless (duplicate) tiles from the various standard Maemo Mapper map sources:
I suppose on windows we have 106 bytes not 103.
Google Streets: 103 bytes
Virtual Earth Streets: 106 bytes
Virtual Earth Satellite or Hybrid: 1652 bytes
Among my Google Satellite downloads, I have a lot of duplicate 1755 byte files, which in fact are NOT maps, even though they commonly appear clustered in featureless ocean areas. (Some of the true satellite map files are actually smaller.) Opening these files as text reveals the following HTML error page, saved under the target JPG filename:
Code:
<html>
<head>
<title>403 Forbidden</title>
<style>
body {
font-family: Arial, sans-serif;
}
</style>
</head>
<body bgcolor="#ffffff" text="#000000" link="#0000cc" vlink="#551a8b" alink="#ff0000">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td><b><font face=times color=#0039b6 size=10>G</font><font face=times color=#c41200 size=10>o</font><font face=times color=#f3c518 size=10>o</font><font face=times color=#0039b6 size=10>g</font><font face=times color=#30a72f size=10>l</font><font face=times color=#c41200 size=10>e</font></b></td>
<td valign=middle width="100%" style="padding-left: 10px">
<table bgcolor="#e5ecf9" width="100%" cellpadding="0"
cellspacing="0" border="0" style="border-top: 1px solid #3366cc">
<tr>
<td><font size="+1"> <b>Error</b></font></td>
<td align="right" nowrap><font size="-1"> </font></td>
</tr>
</table>
</td>
</tr>
</table>
<blockquote>
<h1>We're sorry...</h1>
<p>... but your query looks similar
to automated requests from a computer virus or spyware
application. To protect our users, we can't process your request
right now.
</p>
<p>We'll restore your access as quickly as possible, so try again soon. In the meantime, if you suspect that your computer or network has been infected,
you might want to run a <a href="http://www.download.com/Antivirus/3150-2239-0.html"> virus checker</a> or <a href="http://www.download.com/sort/3150-8022-0-1-4.html">spyware remover</a> to make sure that your systems are free of viruses and other spurious software.
</p>
<p>We apologize for the inconvenience, and hope we'll see you again on Google.
</blockquote>
<br><table width=100% cellpadding=0 cellspacing=0>
<tr><td bgcolor=#3366cc><img alt="" width=1 height=3></td></tr>
</table>
</body>
</html>