Skip Navigation
Jump
Anyone having acceptable performance with SQL Server + odbc?
  • What is your latency? Can you move data closer to where db is (cloud)? Did you change isolation level? Or recovery model? Did you try bcp? Any indexes you have in table should be deleted?

    4
  • Jump
    Open Source Street View...
  • Actually, there is. There is mapillary (bought by Meta at some point) and KartaView (I don't think it is that popular). Code is not free, but licence for images is permissive. My personal favorite is Panoramax - completely open source, open licence and even federated!, but it is still in early stages, but keep an eye on it, looks promising. As always, problem with these efforts is not source code, but rather data.

    57
  • Jump
    Is it possible to receive an electric shock when you *stop* touching something?
  • I am not expert, but seems plausable. Shock comes from high voltage electric charge jumping from metal to skin. If you press it, you are part of the electric charge. If you are far away, charge cannot jump. Problem is only when you are couple of centimeters close to it. AFAIK, this is not current, but electric discharge, I think it cannot kill you (it is just very unpleasant), but maybe someone else knows better?

    4
  • Jump
    Meta, Microsoft, Amazon and TomTom have launched their open map dataset
  • Licence is compatible, but data they have is of...questionable quality...to say at least. For example, I think building dataset is Odbl and I think it contains ML-detected buildings. These got released years ago (becase they had to release it as OdbL to mix them in their maps). Rarely who imported these buildings in OSM as there are lot pf false positives and what not. So, just because they released something under odbl/cdla doesn't mean it is good for OSM and that it could be imported (for example speed profiles, if we ever get real gold data). Overture is more of a playground for big tech to play without OSM telling them what is good and what is not

    2
  • Jump
    GNSS recommendations for gpx traces?
  • If you are looking to get data on your route (speed, distance), regular gps will do, errors are not high, as these error cancel each other usually. If you plan mapping for OSM - also really not worth it, as OSM is generally not more precise than 2-5m. I have dual-frequency phone and I am not impressed (accuracy is bit better, but I didn't have wow effect). If I choose again, I would optimize my purchase for battery life (far more important in nature:D)

    1