P+ utca??

[Ferenc Veres]

Sziasztok!

P   38912093 (osm ID, vonal)
P+  86322991
Z+  38776454
Z+  38776466

Csatolok egy fájlt a 3 karakternél rövidebb nevű utak listájával. A 
legtöbb ilyen turistaút, mint a fentiek.

Értem, hogy kell valami megjelölés arra az esetre, amikor még nincs 
kapcsolatba szervezve. Kérdésem, hogy ez jó e így, vagy mást kellene 
csinálni?

Utca-adatbázist tervezgetek, azzal jöttek elő. De sok teteje nem lenne a 
P+ és hasonló nevű utcáknak. Persze legrosszabb esetben kizárom ami 
ilyen rövid nevű.

Vicces dolgokat lehet találni SQL lekérdezésekkel. Pl volt egy ház ami 
"boundary" volt. :-) Persze az "x", "Út" nevű utak és "Oo" nevű 
kerékpárutak is érdekesek.. :-) Lehet, hogy ezek a name=10 meg name=33 
meg "ref"-be tartozna, most nincs erőm kikutatni.

Feri

ui: osm2pgsql SQL a csatolt fájlhoz:

SELECT name,highway,osm_id FROM planet_osm_line WHERE highway != '' AND 
Length(name) < 3
--------- következő rész ---------
"name";"highway";"osm_id"
"K▲";"track";28707757
"PO";"track";72673710
"K▲";"track";80262984
"K▲";"track";80262971
"K▲";"track";80262974
"P+";"track";72673709
"K▲";"track";72673708
"PO";"track";79379881
"P■";"unclassified";4292924
"K▲";"secondary";4292979
"P■";"unclassified";42682684
"P■";"unclassified";31571551
"K▲";"secondary";42448307
"P■";"unclassified";106963954
"P■";"unclassified";106963957
"K▲";"unclassified";42448280
"P■";"unclassified";106963956
"P■";"unclassified";106963965
"P■";"unclassified";106963950
"K▲";"footway";41519887
"P■";"unclassified";106963963
"p■";"track";42448690
"P■";"unclassified";8294881
"P";"unclassified";4292940
"P■";"footway";39009421
"P▲";"footway";39855903
"K+";"track";42450983
"K";"footway";38913199
"P■";"footway";39010052
"P+";"footway";39855922
"P+";"path";39855910
"K▲";"track";39855926
"K▲";"footway";43549882
"K▲";"footway";123111758
"Z+";"track";41520014
"PZ";"footway";41526525
"Z";"footway";39010049
"P";"footway";38912093
"P●";"footway";39010034
"Z●";"footway";39087308
"Z";"footway";41526911
"K+";"footway";42450018
"Z▲";"footway";42485608
"K▙";"track";39009441
"Z+";"footway";42551468
"P+";"path";86322991
"Z+";"footway";38776454
"Z+";"footway";38776466
"Z+";"footway";112792963
"Z+";"footway";112792962
"S";"track";37919980
"Z+";"footway";37919957
"Z▲";"footway";38806862
"Z●";"track";41673502
"S▲";"footway";38912638
"P+";"footway";38902048
"Z+";"footway";47977689
"S";"footway";41578981
"S▲";"footway";38912565
"S+";"footway";41578593
"K●";"footway";35783826
"P+";"footway";37978433
"P+";"footway";112790585
"P+";"footway";112790586
"P▲";"footway";38002667
"P+";"footway";113184863
"Z+";"footway";41192050
"PO";"unclassified";35783572
"S▲";"footway";41119861
"S▲";"footway";41133379
"S";"footway";38911858
"P+";"footway";113559673
"P+";"footway";35783487
"PO";"footway";110975871
"K●";"footway";42808237
"Z+";"footway";37761685
"S";"footway";41531441
"S";"footway";120586168
"Z";"footway";69975168
"Z";"footway";69975171
"P+";"track";71896629
"P+";"track";71896624
"P+";"track";69975170
"P+";"track";71897008
"Z";"track";69805242
"Z";"residential";80130456
"P";"track";80130457
"Út";"tertiary";113384367
"x";"residential";32909289
"10";"primary";150094693
"10";"primary";32858760
"10";"primary";150094708
"10";"primary";155161092
"10";"primary";150094712
"10";"primary";150094714
"10";"primary";150094687
"x";"unclassified";33607299
"x";"residential";32977982
"x";"residential";32986527
"x";"residential";32986529
"Út";"residential";85433012
"Út";"residential";77681609
"Út";"service";118054893
"K";"path";106936367
"Út";"service";135792667
"K";"path";106936392
"K";"path";155310539
"Út";"residential";122851311
"Út";"track";135698942
"Út";"track";135698944
"Út";"track";135698945
"K";"path";106936374
"Út";"track";135698943
"Út";"track";135698946
"2";"path";148759322
"nn";"residential";42053300
"Oo";"cycleway";113380735
"Oo";"cycleway";113380720
"Oo";"cycleway";113380724
"Oo";"cycleway";113380715
"K¤";"track";104381893
"Z";"track";132236941
"Z";"track";132236939
"Z+";"track";144160968
"Z";"track";132236444
"S+";"track";132236445
"Z";"track";82117435
"P";"track";29434073
"K+";"track";81809501
"P";"track";132231531
"P";"path";29434118
"S+";"track";132235879
"K";"path";108317917
"P";"path";81809485
"P";"track";132235413
"K+";"track";132236448
"P";"path";29434212
"P+";"path";29433370
"S+";"track";132231529
"S+";"track";132232410
"S";"track";132234795
"S";"footway";132235414
"S";"path";29433329
"S4";"path";29433290
"S";"track";132234794
"S";"track";132237564
"S";"track";132234793
"K";"path";132234796
"Z+";"path";29433089
"Z";"path";29432956
"Z+";"path";29432914
"P+";"path";108317907
"Út";"tertiary";39504163
"Út";"residential";126551896
"Út";"tertiary";126551898
"Út";"tertiary";126551892
"Út";"tertiary";126551895
"Út";"residential";126551897
"Út";"tertiary";126551890
"Út";"tertiary";126551899
"Út";"tertiary";126551891
"Út";"tertiary";126551894
"Út";"tertiary";126551893
"Út";"tertiary";126551889
"?";"residential";32764636
"?";"residential";32764676
"?";"residential";32764658
"?";"residential";32764687
"?";"residential";32857009
"?";"residential";32857013
"?";"residential";32764739
"?";"residential";32764700
"?";"residential";32764649
"?";"secondary";25924978
"?";"secondary";25924977
"Út";"track";126706684
"Út";"path";126706683
"Út";"track";125955516
"Út";"track";125955517
"Út";"track";125955514
"Út";"track";125955515
"Út";"tertiary";126053035
"Oo";"cycleway";132404305
"Út";"residential";107101040
"Út";"residential";38098710
"Út";"tertiary";126053027
"Út";"tertiary";127046872
"Út";"residential";38098712
"Út";"tertiary";77457383
"Út";"tertiary";77457385
"Út";"residential";127056475
"Út";"residential";127056478
"Út";"residential";127056476
"Út";"residential";127056479
"Út";"residential";127056472
"Út";"residential";127056473
"Út";"unclassified";127056477
"Út";"residential";127056474
"33";"primary";146629634
"33";"primary";146629372