[OSM-dev] Inserting with planet-to-db [more offenders]

Stefan de Konink skinkie at xs4all.nl
Sun Oct 21 16:41:32 BST 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

This value holds 295 characters and thus will overflow the varchar(255),
 I'll increase the amount now to 512 but some folks also put in huge names.


The offending one:

  <node id="28841588" lat="55.7926255" lon="-4.9018335"
timestamp="2007-05-07T17:04:51Z">
    <tag k="created_by" v="JOSM" />
    <tag k="note" v="In memory of Charles Cayley aged 17 and William
Jewell aged 19, Midshipmen of HMS Shearwater. Two promising young
officers drowned by the upsetting of their boat near this place 17th May
1844. This monument is erected in token of their worth by Captain
Robinson and Officers of the above vessel." />
    <tag k="historic" v="monument" />
  </node>
  <node id="28841589" lat="55.7926457" lon="-4.9022531"
timestamp="2007-05-07T17:04:51Z">
    <tag k="created_by" v="JOSM" />
  </node>
  <node id="28841590" lat="55.7501350" lon="-4.9365638"
timestamp="2007-05-07T17:04:52Z">
    <tag k="created_by" v="JOSM" />


Until the point I inserted these are:
[ 20979764,     "' No left turn from WB Davenport, 7:30a-6:30p M-S, no
left turn from EB Davenport 7:30a-6:30p M-S except TTC'" ]
[ 23655915,     "' Jugendherbergsstr. 1; 54470; Bernkastel-Kues;
01.01.-23.12. und 27.12.-31.12.; ; 0049-(0)6531-2395;;created_by'"     ]
[ 23656456,     "' Dewitzer Chaussee 07; 17094; Burg Stargard;
01.01.-20.12. und 29.12.-31.12.; ; 0049-(0)39603-20207;;created_by'"     ]
[ 23657509,     "' Heidberg 33; 18273; Güstrow; 10.01.-20.12. und
28.12.-31.12.; jh-guestrow at t-online.de; 0049-(0)3843-840;created_by'"
     ]
[ 23657521,     "' Jochstrasse 10; 82467; Garmisch-Partenkirchen;
01.01.-14.11. und 27.12.-31.12.; ; 0049-(0)8821-2980;;created_by'"    ]
[ 23657631,     "' Manheimer Strasse 12; 39245; Gommern; 01.01.-23.12.
und 28.12.-31.12.; ; 0049-(0)39200-40080;;created_by'"   ]
[ 23657683,     "' An der Jugendherberge 32; 18181; Seeheilbad
Graal-Müritz; 01.01.-20.12. und 29.12.-31.12.; ;
0049-(0)38206-775;created_by'" ]
[ 23657694,     "' Jugendherberge 01; 19300; Grabow; 01.01.-20.12. und
29.12.-31.12.; ; 0049-(0)38756-27954;;created_by'"       ]
[ 23658634,     "' Dorfstrasse 20; 15748; Märkisch Buchholz;
Ganzjährig geöffnet. Reservierung erwünscht in der Zeit vom
01.11.-2;created_by'"      ]
[ 23660486,     "' Prebelow 02; 16831; Kleinzerlang; Ganzjährig.
Reservierung erwünscht in der Zeit vom 01.11.-28.02.;
jh-prebelow at ju;created_by'"    ]
[ 23660869,     "' Bottelter 8; 54439; Saarburg; 01.01.-09.01.;
01.02.-30.11. und 27.12.-31.12.; ; 0049-(0)6581-2555;;created_by'"      ]
[ 23662384,     "' Im Langfigtal 8; 53505; Altenahr; 01.01.-23.12. und
27.12.-31.12.; ; 0049-(0)2643-1880;;created_by'" ]



Someone must have noticed this before? Or is everyone storing name/value
as 'text'?


Stefan
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFHG3MsYH1+F2Rqwn0RCroKAJ9NRTtdNS0Zg35PUX8/3EnYy0BajACaAy3B
2eU+v2e3u39HQ2OIokx9odE=
=CXFm
-----END PGP SIGNATURE-----




More information about the dev mailing list