You are not logged in.

Announcement

*** NOTICE: forum.openstreetmap.org is being retired. Please request a category for your community in the new ones as soon as possible using this process, which will allow you to propose your community moderators.
Please create new topics on the new site at community.openstreetmap.org. We expect the migration of data will take a few weeks, you can follow its progress here.***

Pages: 1

#1 2013-07-26 14:12:34

Lübeck
Member
Registered: 2009-02-17
Posts: 2,874

Hilfe bei einer Tagchange-Visualisierung

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 :-)

Redmi Note 9 Pro  mit Android 11, Tablet Android 8.1, PC: Win10

Offline

#2 2013-07-26 16:00:04

fx99
Member
From: Baden-Württemberg
Registered: 2009-06-02
Posts: 1,930

Re: Hilfe bei einer Tagchange-Visualisierung

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

Offline

#3 2013-07-26 18:36:12

wambacher
Member
From: Schlangenbad/Wambach, Germany
Registered: 2009-12-16
Posts: 16,769
Website

Re: Hilfe bei einer Tagchange-Visualisierung

Lübeck wrote:

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.

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.
hm3havk2yimb.png
iwsxjiloo3x.png

Gruss
Walter

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

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

Last edited by wambacher (2013-07-26 18:43:47)

Osm Software Watchlist  Osm Emergency Map
Osm Healthcare Map

Offline

#4 2013-07-26 19:36:43

Lübeck
Member
Registered: 2009-02-17
Posts: 2,874

Re: Hilfe bei einer Tagchange-Visualisierung

hi !

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

and user_id != 55462; ist egal

Nummern bei denen die aktuelle Hausnummer auch die der Ersterfassung ist ist ok !

Läßt sich das noch anpassen ?

Ansonsten +100

gruß jan :-)

Redmi Note 9 Pro  mit Android 11, Tablet Android 8.1, PC: Win10

Offline

#5 2013-07-26 20:22:28

wambacher
Member
From: Schlangenbad/Wambach, Germany
Registered: 2009-12-16
Posts: 16,769
Website

Re: Hilfe bei einer Tagchange-Visualisierung

Lübeck wrote:

Läßt sich das noch anpassen ?

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.

Osm Software Watchlist  Osm Emergency Map
Osm Healthcare Map

Offline

#6 2013-07-26 21:40:34

Lübeck
Member
Registered: 2009-02-17
Posts: 2,874

Re: Hilfe bei einer Tagchange-Visualisierung

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

Redmi Note 9 Pro  mit Android 11, Tablet Android 8.1, PC: Win10

Offline

#7 2013-07-26 21:44:13

Lübeck
Member
Registered: 2009-02-17
Posts: 2,874

Re: Hilfe bei einer Tagchange-Visualisierung

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

Redmi Note 9 Pro  mit Android 11, Tablet Android 8.1, PC: Win10

Offline

#8 2013-07-26 22:27:48

wambacher
Member
From: Schlangenbad/Wambach, Germany
Registered: 2009-12-16
Posts: 16,769
Website

Re: Hilfe bei einer Tagchange-Visualisierung

Lübeck wrote:

Postgis ruht - will erst mal nächste Woche auf dem Stammtisch wegen qgis schauen und dann mein entsprechendes Buch lesen.

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

Osm Software Watchlist  Osm Emergency Map
Osm Healthcare Map

Offline

Pages: 1

Board footer

Powered by FluxBB