Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- "
- Adott két pontlista (mindegyik kb 2000 pont). Ezek kvázi ellenőrző pontok, de pontszám nélkül! Szóval hagyományos összehasonlítás nem megoldható. Ti milyen programban oldanátok azt meg hogy csak koordináta alapján keresse meg a két listában az "összeillő" pontokat és számoljon rá eltérést?
- ...
- FRISSÍTÉS: A két lista mégsem ugyanannyi pontból áll, (500 vs 2000) szóval bőven van olyan pont aminek nincs "párja".
- "
- A.txt
- -----
- x y
- 85.92 72.85
- 11.66 1.62
- 68.26 33.07
- 86.03 71.64
- 41.84 32.38
- 49.67 23.6
- 83.09 65.6
- 91.78 78.33
- 38.13 74.69
- B.txt
- -----
- x y
- 85.92 72.85
- 12.00 2.53
- 68.29 33.09
- 86.44 72.47
- 42.6 33.14
- 50.37 24.43
- 83.1 65.63
- 91.87 78.37
- 38.17 74.68
- Download: https://www.gaia-gis.it/spatialite-2.3.1/spatialite-gui-win-x86-1.2.1.zip
- [ https://www.gaia-gis.it/spatialite-2.3.1/binaries.html ]
- [ http://www.gaia-gis.it/spatialite-2.4.0/spatialite-sql-2.4.html ]
- Run: spatialite-gui.exe
- 1. Files / "Load CSV/TXT" / A.txt -> tabla "A"
- 2. Files / "Load CSV/TXT" / B.txt -> tabla "B"
- 3. Run SQL:
- SELECT a.y, a.x, b.y, b.x, distance(a.geom,b.geom)
- FROM ( SELECT y,x,geomfromtext('POINT('||x||' '||y||')',23700) geom FROM "A" ) a,
- ( SELECT y,x,geomfromtext('POINT('||x||' '||y||')',23700) geom FROM "B" ) b
- --where distance(a.geom,b.geom)<1
- ORDER BY 5
- 4. RESULT:
- 72.850000 85.920000 72.850000 85.920000 0.000000
- 65.600000 83.090000 65.630000 83.100000 0.031623
- 33.070000 68.260000 33.090000 68.290000 0.036056
- 74.690000 38.130000 74.680000 38.170000 0.041231
- 78.330000 91.780000 78.370000 91.870000 0.098489
- 72.850000 85.920000 72.470000 86.440000 0.644050
- 71.640000 86.030000 72.470000 86.440000 0.925743
- 1.620000 11.660000 2.530000 12.000000 0.971442
- 32.380000 41.840000 33.140000 42.600000 1.074802
- 23.600000 49.670000 24.430000 50.370000 1.085772
- 71.640000 86.030000 72.850000 85.920000 1.214990
- 71.640000 86.030000 65.630000 83.100000 6.686180
- 65.600000 83.090000 72.470000 86.440000 7.643258
- 72.850000 85.920000 65.630000 83.100000 7.751181
- 65.600000 83.090000 72.850000 85.920000 7.782763
- 78.330000 91.780000 72.470000 86.440000 7.928127
- 78.330000 91.780000 72.850000 85.920000 8.023092
- 72.850000 85.920000 78.370000 91.870000 8.116212
- 71.640000 86.030000 78.370000 91.870000 8.910584
- 32.380000 41.840000 24.430000 50.370000 11.660334
- 23.600000 49.670000 33.140000 42.600000 11.874195
- 78.330000 91.780000 65.630000 83.100000 15.382861
- 65.600000 83.090000 78.370000 91.870000 15.497138
- 33.070000 68.260000 24.430000 50.370000 19.867101
- 23.600000 49.670000 33.090000 68.290000 20.898911
- 33.070000 68.260000 33.140000 42.600000 25.660095
- 32.380000 41.840000 33.090000 68.290000 26.459528
- 65.600000 83.090000 33.090000 68.290000 35.720304
- 33.070000 68.260000 65.630000 83.100000 35.782387
- 74.690000 38.130000 33.140000 42.600000 41.789752
- 32.380000 41.840000 2.530000 12.000000 42.207204
- 71.640000 86.030000 33.090000 68.290000 42.435953
- 32.380000 41.840000 74.680000 38.170000 42.458908
- 23.600000 49.670000 2.530000 12.000000 43.162180
- 33.070000 68.260000 72.470000 86.440000 43.392078
- 72.850000 85.920000 33.090000 68.290000 43.493385
- 33.070000 68.260000 72.850000 85.920000 43.523833
- 1.620000 11.660000 33.140000 42.600000 44.167794
- 1.620000 11.660000 24.430000 50.370000 44.930615
- 65.600000 83.090000 74.680000 38.170000 45.828515
- 74.690000 38.130000 65.630000 83.100000 45.873571
- 72.850000 85.920000 74.680000 38.170000 47.785054
- 74.690000 38.130000 72.850000 85.920000 47.825409
- 71.640000 86.030000 74.680000 38.170000 47.956451
- 74.690000 38.130000 72.470000 86.440000 48.360981
- 78.330000 91.780000 33.090000 68.290000 50.974873
- 33.070000 68.260000 78.370000 91.870000 51.083482
- 33.070000 68.260000 74.680000 38.170000 51.349783
- 74.690000 38.130000 33.090000 68.290000 51.382736
- 74.690000 38.130000 24.430000 50.370000 51.728959
- 65.600000 83.090000 33.140000 42.600000 51.895007
- 23.600000 49.670000 74.680000 38.170000 52.358537
- 65.600000 83.090000 24.430000 50.370000 52.588661
- 32.380000 41.840000 65.630000 83.100000 52.990094
- 23.600000 49.670000 65.630000 83.100000 53.703685
- 78.330000 91.780000 74.680000 38.170000 53.734110
- 74.690000 38.130000 78.370000 91.870000 53.865852
- 71.640000 86.030000 33.140000 42.600000 58.038047
- 72.850000 85.920000 33.140000 42.600000 58.766542
- 71.640000 86.030000 24.430000 50.370000 59.164345
- 32.380000 41.840000 72.850000 85.920000 59.840348
- 32.380000 41.840000 72.470000 86.440000 59.969727
- 72.850000 85.920000 24.430000 50.370000 60.069118
- 23.600000 49.670000 72.850000 85.920000 61.152473
- 23.600000 49.670000 72.470000 86.440000 61.158072
- 33.070000 68.260000 2.530000 12.000000 64.014680
- 1.620000 11.660000 33.090000 68.290000 64.786710
- 78.330000 91.780000 33.140000 42.600000 66.789284
- 32.380000 41.840000 78.370000 91.870000 67.956464
- 78.330000 91.780000 24.430000 50.370000 67.970568
- 23.600000 49.670000 78.370000 91.870000 69.141832
- 74.690000 38.130000 2.530000 12.000000 76.745309
- 1.620000 11.660000 74.680000 38.170000 77.720935
- 65.600000 83.090000 2.530000 12.000000 95.034799
- 1.620000 11.660000 65.630000 83.100000 95.921602
- 71.640000 86.030000 2.530000 12.000000 101.275036
- 72.850000 85.920000 2.530000 12.000000 102.024844
- 1.620000 11.660000 72.850000 85.920000 102.899274
- 1.620000 11.660000 72.470000 86.440000 103.013450
- 78.330000 91.780000 2.530000 12.000000 110.047664
- 1.620000 11.660000 78.370000 91.870000 111.014443
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
