Hilfe bei einer Tagchange-Visualisierung

Communities Deutschland (Germany)
1

hi !

in der Lübecker Altstadt ist irgendwie etwas falsch gelaufen.

Ich hatte schon fast alle Hausnummern erfaßt und nun sind in einige Bereichen die Nummern geändert. Völlig daneben.

In der Chronik stehen die noch drin.

Ich könnte nun alle Häuser kontrollieren - aber das wäre eine Arbeit … die Ursache ist nicht bekannt.

Könnte einer der DB-Anwender auf einfache Art und Weise eine Abfrage bauen und visiualisieren (auch als Liste) wo die Hausnummer geändert wurde seit Jahresbeginn - ich spreche nicht von der Ersterfassung. Es ist nämlich nicht jedes Haus.

Es würde mir sehr weiterhelfen !

Gruß Jan :slight_smile:

2

http://overpass-turbo.eu/ mit

<!--
This is an example Overpass query.
Try it out by pressing the Run button above!
You can find more examples with the Load tool.
-->
<query type="way">
<newer than="2013-01-01T00:00:00Z"/>  
  <has-kv k="addr:housenumber" />
  <bbox-query {{bbox}}/><!--this is auto-completed with the
                   current map view coordinates.-->
</query>
<!-- added by auto repair -->
<union>
  <item/>
  <recurse type="down"/>
</union>
<!-- end of auto repair -->
<print/>

Findet alle ways mit Hausnummern nach 1.1.13

3

OK:


select id,tags->'addr:housenumber' housenumber,tstamp 
  from ways
 where tags ? 'addr:housenumber'
   and bbox && st_MakeEnvelope(10.66306, 53.85928, 10.72052, 53.87593)
   and tstamp > '2013-01-01T00:00:00Z'
   and user_id != 55462;

ergibt 96 Buildings als way, die zuletzt nicht von dir bearbeitet worden sind:


    id     | housenumber |       tstamp        
-----------+-------------+---------------------
 120803724 | 57          | 2013-07-01 22:50:20
 153804074 | 52          | 2013-02-08 19:35:39
  37326551 | 2-4         | 2013-01-13 16:07:00
 188355266 | 31          | 2013-01-18 23:55:13
 217138855 | 15          | 2013-06-11 17:48:40
 147129461 | 26-28       | 2013-06-02 11:07:42
 147253616 | 27          | 2013-06-07 02:28:05
 125502332 | 3           | 2013-03-20 23:40:17
 147510565 | 2           | 2013-06-27 11:24:57
 147510644 | 53-55       | 2013-06-27 11:24:57
 132889574 | 24          | 2013-02-08 19:35:39
 146207077 | 15          | 2013-03-04 14:00:34
 142273292 | 73          | 2013-05-12 11:47:48
 142273303 | 63          | 2013-05-12 11:47:46
 142273307 | 65          | 2013-05-12 11:47:47
 142274355 | 49          | 2013-05-12 11:47:45
 142274380 | 51          | 2013-05-12 11:47:46
 142274397 | 57-59       | 2013-05-12 11:47:46
 142352145 | 17          | 2013-05-12 11:47:41
 142352149 | 40          | 2013-05-12 11:47:44
 142352153 | 33          | 2013-05-12 11:47:44
 217843123 | 64          | 2013-05-12 11:47:47
 142274357 | 53          | 2013-05-12 11:47:46
 142274898 | 3-7         | 2013-05-12 11:47:43
 142348417 | 6           | 2013-05-12 11:47:46
 142273309 | 69-71       | 2013-05-12 11:47:47
 142349095 | 18          | 2013-05-12 11:47:41
 142349100 | 27          | 2013-05-12 11:47:42
 142349116 | 20          | 2013-05-12 11:47:42
 142349135 | 14          | 2013-05-12 11:47:40
 142352119 | 39          | 2013-05-12 11:47:44
 142352128 | 3           | 2013-05-12 11:47:43
 142352129 | 41          | 2013-05-12 11:47:45
 142352136 | 35          | 2013-05-12 11:47:44
 142352138 | 31          | 2013-05-12 11:47:43
 142352140 | 27          | 2013-05-12 11:47:42
 145402725 | 67          | 2013-05-12 11:47:47
 159949115 | 57          | 2013-01-09 23:23:16
 159850292 | 37          | 2013-01-09 23:20:27
 159850214 | 49          | 2013-01-09 23:21:16
 147003442 | 54-56       | 2013-02-08 19:35:40
 147003487 | 70          | 2013-02-08 18:59:59
 147252055 | 35          | 2013-03-06 16:00:14
 147134949 | 44-46       | 2013-03-06 16:00:09
 147429555 | 69-71       | 2013-01-13 11:33:08
 204610277 | 2           | 2013-02-08 00:43:29
 204704444 | 62          | 2013-02-08 19:35:40
 204704446 | 64          | 2013-02-08 19:35:40
 103004327 | 47          | 2013-01-09 22:47:08
 135870431 | 4           | 2013-01-13 11:27:17
 135870432 | 2           | 2013-01-13 11:27:17
 149098802 | 15          | 2013-01-09 23:18:35
 147491195 | 16          | 2013-01-20 19:33:55
 149146094 | 55          | 2013-01-09 22:47:09
 149146097 | 53          | 2013-01-09 22:47:09
 149146099 | 49          | 2013-01-09 22:47:08
 149146100 | 51          | 2013-01-09 22:47:08
 147911874 | 20          | 2013-01-06 02:01:26
 147151445 | 40          | 2013-04-21 17:53:45
 142274374 | 3           | 2013-05-12 11:47:43
 142352121 | 52          | 2013-05-12 11:47:46
 142352123 | 42          | 2013-05-12 11:47:45
 142352133 | 50          | 2013-05-12 11:47:45
 142352118 | 46          | 2013-05-12 11:47:45
 142352144 | 44          | 2013-05-12 11:47:45
 142352146 | 48          | 2013-05-12 11:47:45
 217843120 | 60          | 2013-05-12 11:47:46
 217843121 | 62          | 2013-05-12 11:47:46
 217843124 | 66          | 2013-05-12 11:47:47
 146455718 | 14          | 2013-04-19 11:55:40
 153789584 | 21          | 2013-04-07 16:57:51
 169225843 | 1           | 2013-04-15 14:51:06
 169225821 | 1 - 1a      | 2013-04-17 09:52:31
 142349097 | 2           | 2013-05-12 11:47:42
 142349102 | 8           | 2013-05-12 11:47:48
 142348415 | 10          | 2013-05-12 11:47:40
 142348416 | 12          | 2013-05-12 11:47:40
 142348419 | 8a          | 2013-05-12 11:47:48
 142348420 | 8           | 2013-05-12 11:47:48
 142348422 | 2           | 2013-05-12 11:47:42
 142349096 | 15          | 2013-05-12 11:47:40
 142349109 | 4-6         | 2013-05-12 11:47:44
 142349123 | 10          | 2013-05-12 11:47:40
 142349129 | 13          | 2013-05-12 11:47:40
 142352120 | 9           | 2013-05-12 11:47:48
 142352122 | 4           | 2013-05-12 11:47:44
 142352127 | 37          | 2013-05-12 11:47:44
 142352131 | 2           | 2013-05-12 11:47:42
 142352134 | 1           | 2013-05-12 11:47:39
 142352152 | 29          | 2013-05-12 11:47:42
 220428296 | 6           | 2013-05-12 11:47:46
 142355182 | 104         | 2013-04-11 17:08:45
 154712004 | 8           | 2013-04-15 14:54:26
 125585657 | 39          | 2013-03-30 01:21:54
  30156901 | 66-68       | 2013-02-08 18:59:58
  29044800 | 62          | 2013-03-06 16:00:16
(96 rows)

und


\t
select array((select id 
                from ways
               where tags ? 'addr:housenumber'
                 and bbox && st_MakeEnvelope(10.66306, 53.85928, 10.72052, 53.87593)
                 and tstamp > '2013-01-01T00:00:00Z'
                 and user_id != 55462)
           );
\t

ergibt das Ganze als Liste der IDs - mehr braucht Josm nicht beim “Datei/Objekt herunterladen”


{120803724,153804074,37326551,188355266,217138855,147129461,147253616,125502332,147510565,147510644,132889574,146207077,142273292,142273303,142273307,142274355,142274380,142274397,142352145,142352149,142352153,217843123,142274357,142274898,142348417,142273309,142349095,142349100,142349116,142349135,142352119,142352128,142352129,142352136,142352138,142352140,145402725,159949115,159850292,159850214,147003442,147003487,147252055,147134949,147429555,204610277,204704444,204704446,103004327,135870431,135870432,149098802,147491195,149146094,149146097,149146099,149146100,147911874,147151445,142274374,142352121,142352123,142352133,142352118,142352144,142352146,217843120,217843121,217843124,146455718,153789584,169225843,169225821,142349097,142349102,142348415,142348416,142348419,142348420,142348422,142349096,142349109,142349123,142349129,142352120,142352122,142352127,142352131,142352134,142352152,220428296,142355182,154712004,125585657,30156901,29044800}

Liste ohne {} in Josm als Linien laden, feddich.

Gruss
Walter

p.s. die Werte für die BBOX hab ich einfach aus der unteren Statuszeile der Missing Residentials-Karte kopiert.


Ich sollte wohl mal eine PSQL-Funktion schreiben, die die BBOX aus einem Permalink zusammenbaut. → todo2.txt

4

hi !

erst einmal ein großes Danke - aber ich glaube ich habe mich noch nicht ganz richtig ausgedrückt.

Läßt sich das noch anpassen ?

Ansonsten +100

gruß jan :slight_smile:

5

Jain:

Ich dachte, du hättest jetzt eine eine DB - oder “ruht” das Projekt?

“Deine” Hausnummern hatte ich ausgeblendet, weil du doch die “verschandelten” wissen wolltest. Und die sind doch wohl nicht von dir, oder?
so werden aus 96 mal schnell 1424 zu überprüfende Objekte - ok, ist deine Zeit.

version > 1 sollte reichen.


select array((select id 
                from ways
               where tags ? 'addr:housenumber'
                 and bbox && st_MakeEnvelope(10.66306, 53.85928, 10.72052, 53.87593)
                 and tstamp > '2013-01-01T00:00:00Z'
                 and version > 1)
           );

ergibt


{125388826,147005899,147005904,147005905,147005909,147005931,147025715,147055380,149177902,149177952,149177953,149177959,149177968,149177977,149178010,149178036,149178067,149178134,149178145,149178159,149177911,149178030,149178040,149178102,149178115,149178168,149178172,149178174,149178175,149178208,149178221,157150753,149177895,149178201,149178231,149550800,149550804,149550823,149550842,149599872,149599899,149599926,149599935,149599936,149599946,149599958,149599972,149599985,149599993,149600000,149600012,149600013,149600035,149600078,148181229,148181235,148181239,148181244,148181251,148181255,148181262,148181264,148181265,148181516,148181518,148181520,148181522,148181526,146583192,146583196,146590427,146590439,146590464,146590491,146590509,146590528,147444030,147444038,147444039,147444041,147444053,148020817,146583191,146590474,148020818,221576369,127703859,127703860,127703862,127703863,127703864,127703865,127703866,127703867,134768895,125130039,125130041,125130042,125130043,207585763,149007848,147911896,149007644,149007842,149007913,149007637,149007659,149007679,149007773,149007792,149007813,149550802,149550835,149550849,149600080,149758258,147252517,147252518,147252522,147252524,147252525,149007627,149007675,149007855,149599898,149177905,149177916,149177917,149177921,149177923,149177929,149177930,149177942,149177944,149177945,149177950,149177955,149177962,149177966,149177972,149177973,149177985,149177996,149178009,149178022,149178048,149178050,149178051,149178058,149178087,149178095,149178097,147444080,147005226,147025761,147025764,147055393,147055404,147055412,147055389,147055409,130919981,149178104,149178117,149178123,149178126,149178129,149178139,149178146,149178152,149178154,149178156,149178166,149178192,149178199,149178200,149178209,149178210,149178211,149178214,149178216,149178222,149178229,229571776,142357392,146465850,98321905,147232448,150300988,150301007,150301034,150301038,150301040,153993076,153993078,153993082,153993084,153993086,153993089,153993091,153993102,169701755,168542312,153989169,153989156,153989159,153989173,153946092,153946115,153946129,153958718,153958763,153958770,153958771,153989149,153989152,153989157,153989171,153989178,153989190,153990720,153990733,153990743,153992099,153992100,153992101,153992115,153992118,153992127,153992130,153992131,153992132,153992133,153992134,153993059,153993061,153993065,153993068,153993069,153993073,154485281,154485282,154485283,154485285,149429007,149428988,149428957,149428994,149428998,149429019,149429020,149429023,150302678,146454873,146597770,146620773,147149022,147149025,147149028,147149032,147149040,147149043,147149045,159805186,146620727,146620766,147430459,146620729,146620734,146620741,146620746,146620752,146620762,146620763,146620768,146620772,146477423,135673570,135673730,142357324,153598962,153604681,120803724,150730426,137762106,137762110,137762111,137762113,103004264,154199641,154199646,154199666,154199726,154199731,154199733,154199735,218432705,218432706,218432707,218585500,218585505,218585507,218585510,218585515,218846963,169217540,169221438,169222229,169222248,169222251,169222254,169222255,169222259,209753960,209753961,217138822,217138825,217138829,217138834,217138835,217138848,217138857,217138876,217138877,217138891,217138901,169221436,169221442,169221456,169225822,154199670,154199674,154199678,154199687,154199705,154199713,154199717,209740112,209740134,209740140,209740204,209740229,209740276,169225826,169225829,169225830,169225833,169225840,169225842,169225850,169225860,169666500,209316885,209316887,209316888,209316890,218432704,218585477,218585501,218585511,218585517,209740295,209740323,209740324,209746632,209746639,217138874,217138875,217138879,217138886,217138890,217138894,218432702,218432703,137758060,137758061,137758062,137758063,137758064,137758065,137762079,137762101,137762104,168257097,168257100,168257102,168257103,168257104,168257105,168257106,168257107,168257108,96766389,128374693,128374694,128374695,128374696,128374742,128374809,128374810,128374811,128374812,128374829,128374830,136998075,136998083,136998087,136998105,136998838,136998839,136998843,136998844,136998845,136998848,136998851,136998852,136998855,136998857,136998858,136998861,136998862,137758019,137758020,137758022,137758024,137758025,137758026,137758030,137758031,137758034,137758035,137758036,137758040,137758043,137758045,137758048,137758049,137758050,137758051,137758052,137758054,137758055,137758057,137758058,137611723,137611724,137611725,137611726,137611727,137611728,137611729,137611730,137758023,137758027,137758032,137758046,137758047,137758059,125585275,125585276,125585277,125585278,125585279,125585280,125585281,125585282,125585283,125585284,125585285,125585286,125585287,126461651,126461652,126461653,126461654,126461655,126461656,126461657,126461658,126461659,126461660,124553360,149529951,153604632,153604679,153604695,153605149,153605150,153605155,153605156,153605159,153605160,153605161,153605164,153605165,153604597,153604620,153604659,153604674,153608387,153608391,153606268,153606269,153606270,153606272,153606276,153606277,153606279,153606281,153606284,153606289,153606290,153606291,153606294,153606296,153606297,153606300,153606301,153606302,153606305,153606307,153606310,153606313,153606322,153606335,149178078,149178219,153608377,153608378,153608382,153608388,153608394,153608398,153608401,153608403,153608404,153608406,153608407,153608409,153608414,153608416,153608420,146450414,146450419,146450434,146450437,146450438,146451325,146451326,146451343,146451345,146451353,146451363,146451365,146450400,222874028,146450440,150168944,150168952,150168956,150168961,150168964,150168966,150168969,150168973,150168974,150168977,150168981,150168983,150168987,150168989,150168994,150169006,150169007,150169010,150169017,150169019,150169020,150169021,150169022,150169023,150300976,150300980,150301003,150301018,150301020,150301036,150301138,150447130,150447131,150447132,150447133,150447136,150447137,150447140,150447141,150447142,150447146,150447147,150447149,150447151,150447152,150447156,150447157,150447158,150447160,150447161,150447162,150447167,150447170,150447171,150447174,150447176,150447180,150447186,150447187,150447188,150447189,150447190,150447191,150447192,152798722,152798723,152799194,152800179,152800215,158424685,159305600,116856082,151824959,125730576,125730588,125730649,149428953,149428977,149428990,149429036,153608376,153608385,146451359,146455707,146455709,146455710,146455712,159805137,29044922,228778380,146451357,146451371,139886826,146452347,146452348,146452349,146452350,146452351,146452353,146452355,146452357,146452365,146452366,146465846,146465848,146465849,146465857,146465863,146477390,135776756,135776836,142355176,142357361,142358734,142358737,142358738,142374930,142374931,210228097,153612595,153804074,147429572,146620732,146620738,146620745,146620749,146620756,146620757,146620761,146620767,146620770,146620771,142357294,142357348,188233810,37368043,37368044,37202573,37326551,188355266,217138855,125584693,125584694,125584705,125584708,126186115,126186117,126186119,126186120,126186291,126186292,126186293,126186294,126186295,126186296,126186297,126186298,126186299,126186300,126186301,125016289,125016290,125130062,125130046,125130073,124997799,124997814,125016288,125121215,120314516,125499897,125499898,125499899,147129461,147253616,125730581,125730583,125730584,125730585,125730586,125502332,176134856,150300991,150588334,154442191,154442192,154442195,154442196,154442199,154442202,154442204,154442208,154442211,154442214,154442215,154442218,127703858,125121204,125121205,125121206,125121207,125121208,125121209,125121210,125121216,125121231,125121238,116629998,146590447,146590497,146590501,146590502,146590506,146590511,146590512,146590520,146590524,146590529,146590538,187611329,127566445,125121211,125121214,153958729,153958741,153958743,153958748,153958768,153990718,153990721,153990722,153990723,153990725,153990726,153990731,153990734,153990740,153990768,154096442,154096451,154096459,154096460,154146391,154146393,154146396,154146401,154146403,154146405,154146407,154146408,187009661,105608419,147510565,147510644,28831875,76702928,130800549,132889574,134178945,134178946,135662157,135438330,146211928,146452342,146456371,146458500,146590485,146590489,146382867,146382943,146382966,146382968,146382971,146382977,146383013,146583194,146590426,146590508,146450435,146207077,150301068,142273292,142274345,142273303,142273307,142274355,142274380,142274397,142352145,142352149,142352153,142348402,142348414,142348421,142349104,142349108,142349122,142352476,142352714,142374914,142374918,142374919,142374920,142374923,142374927,142374928,154199732,154117059,154117060,154117070,154117071,154117072,154117074,154117075,154117077,154117080,154117081,154117082,154117085,154117088,154117090,154117098,154117099,154117104,154117108,154117110,217843123,142274357,142274898,142348417,142273309,142349095,142349100,142349116,142349135,142352119,142352128,142352129,142352136,142352138,142352140,145402725,154142802,154142809,154142816,154142817,154142820,154142821,154142824,154142829,154142833,154142835,154142838,154142842,154144175,154144200,154144204,154144210,154144212,154144218,154144223,154144228,154144247,154144251,154144260,154144262,154144270,154711271,154711999,154712009,159949115,159871669,159803289,159850292,159850346,159897049,159850214,147003442,147003487,147252055,147257283,147257292,147257295,147257314,147257322,147257327,147257329,147257336,147257386,147134949,147025747,147429555,204704444,204704446,171858751,101512589,103004327,135776757,135870431,135870432,139886757,139886792,139886801,139886818,139886823,139886848,169335972,169335975,169335984,169225848,169225827,169208295,169234588,169234595,169234597,169234598,169234599,169234600,169234601,169234602,169234604,169234605,169335980,169335982,137758056,137602271,170335223,170335226,170335238,149098802,147491195,149146094,149146097,149146099,149146100,147508129,147508137,148181248,148181528,147510601,148184436,147430466,147911874,149038903,149038904,149007793,217138838,217138849,217138866,217138902,217137288,217137289,217138837,147228087,147228090,147228091,147228095,154096429,153946093,153946095,153946097,153946098,153946099,153946102,153946104,153946105,153946106,153946108,153946111,153946113,153946114,153946116,153946117,153946118,153946122,153946124,153946127,153946130,153946131,153946137,153947100,153947101,153990741,153993087,153993093,153993095,153993098,153993099,154096428,154096422,154096439,154096441,154096444,154096446,154096448,154096449,154096454,154096455,154096456,154096457,154096462,154096464,154096469,154096471,154096472,154096473,154096474,154096479,154096480,154117531,154117532,154117533,154117535,154117538,154117540,154117543,154117544,154117546,154144192,154144168,154144172,154144180,154144259,154145902,154145903,154145905,154145906,154145907,154145909,154145911,154145913,154145914,154145919,154145920,154145924,154145925,154145926,154145927,154145928,154145929,154145931,154145932,154146409,154096496,154096497,153944890,153944921,147151445,209740163,209740252,209740270,209740275,169701754,217137308,217137309,169227282,169227290,169227291,139891548,140017887,140017902,140017952,140017956,140017990,140018000,140018038,140018064,140018066,140018079,140018099,140018112,140018172,140018177,142273271,142273272,142273276,142273278,142273281,142273282,142273283,142273287,142273288,142273289,142273291,142273294,142273295,142273296,142273300,142273301,142273304,142273305,142274347,142274354,142274368,142274374,142274370,142274377,142274379,142274381,142274384,142274385,142274386,142274388,142274390,142274394,142274395,142274396,142274398,142274400,142274401,142352121,142352123,142352133,142352118,142352144,142352146,182458524,217843120,217843121,217843124,130847503,146455718,217137286,217137282,217137285,217137296,217137297,217137291,217137298,217137304,217137310,217137315,217138832,217138833,217138845,217138842,217138858,217138859,217138863,217138865,217138872,217138870,217138897,217138899,217138905,147911882,147911860,147911869,147911876,147911868,147911877,147911878,147911886,147911889,147911890,147911900,149178173,149178206,149529950,153594354,153594359,153594368,153594369,153594371,153594374,153594387,153594395,153594396,153594415,153594423,153594429,153598981,153598994,153599001,153604616,153604628,153604644,153604655,153604683,153604713,108219237,149428951,149428955,149428956,149428958,149428959,149428962,149428963,149428965,149428966,149428967,149428969,149428973,149428979,149428980,149428982,149428983,149428984,149428986,149428987,149428989,149428991,149428995,149428996,149428997,149428993,149429000,149429003,149429008,149429013,149429014,149429017,149429022,149429021,149429024,149429025,149429026,149429035,149429038,149429039,149429043,149429044,149429045,149429046,149429047,149429051,149429052,149550793,149550813,149550846,149542106,149550816,149550824,149599866,149599955,149599959,149599963,149599971,149599982,149599988,149599989,149600020,149600025,149600051,149600053,149600056,149600057,149600059,91675893,149758255,125579486,153789584,147134935,149599941,149599873,149599881,149599886,149599960,149599974,149599975,149599992,149600008,149600034,149600041,125584689,147134945,153598989,153594420,217138880,217138884,217138893,169225843,169225821,142348400,142349097,142349102,142348401,142348415,142348416,142348419,142348420,142348422,142349096,142349109,142349123,142349129,142352120,142352122,142352127,142352131,142352134,142352147,142352141,142352152,220428296,220428297,24276160,139886764,142355182,217137278,217137281,217137287,217137300,217137306,217137311,154712004,153598988,153598999,153599005,153599012,153599922,153599937,153599948,37326554,31663703,125448908,142349099,142349101,142349111,142349127,142349131,142347939,142347942,142347943,142347944,142347948,142347953,142348407,142348408,142348410,142348423,142352479,142352482,142352483,142352486,142352488,142352489,142352491,142352492,142352493,142352495,142352496,142352497,125585657,30156901,150730417,29044800,149529948,149599950,149599957,149600005,149600019,149600029,30815529,51545580,154117068,154117076,147518360,147518361,147518363,149178228,149178205,149178217,147245203,147245210,147245215,150587221}

Gruss
walter

p.s. ein wenig “Zwangsberatung”:

  • **tags ? ‘addr:housenumber’ ** findet alle ways, die eine beliebige Hausnummer haben (existiert tag?)
  • st_makeenvelope (…) baut eine Bbox
  • ** bbox && st_make…** findet alls Ways, deren Box ganz oder teilweise im großen Bereich liegen. Hier kommt PostGIS zum Tragen.
    Achtung: bbox ist das Feld bbox vom Way (building), der Envelope (Umschlag) ist das Suchgebiet
  • array(…) baut die Liste
    der Rest sollte klar sein.
6

Postgis ruht - will erst mal nächste Woche auf dem Stammtisch wegen qgisschauen und dann mein entsprechendes bBuch Lesen. Gibt mehrere Baustellen. Aber die Hausnummern müssen berichtigt werden!

Gruss jan

7

Postgis ruht - will erst mal nächste Woche auf dem Stammtisch wegen qgisschauen und dann mein entsprechendes bBuch Lesen. Gibt mehrere Baustellen. Aber die Hausnummern müssen berichtigt werden!

Gruss jan

8

Wenn du einen richtigen QGIS-Guru an der Strippe hast: Ich habe riesige Probleme wenn Qgis sich mit der PostGis-DB verbindet. Qgis besorgt sich am Anfang einen Überblick über die im Schema enthaltenen Tabellen und deren Daten - und das dauert ewig! 5 Minuten sind da schon harmlos. Und das Ganze, bevor ich überhaupt ein Filter angeben kann.

Das ging gerade noch als ich “nur” Germany drin hatte aber beim Full Planet mit fast 2G an realen Nodes ist das nicht mehr tragbar.
Eventuell gibt es da einen Trick oder einen Parameter, der darauf Einfluß hat.

Bei kleinen Datenbanken mit den Daten einer Stadt merkt man natürlich relativ wenig davon aber irgendwann ist dann die Schmerzgrenze erreicht.

So, und jetzt widme ich mich wieder meiner Transpiration :wink:

Gruss
walter