Assalomu alaykum, yordam.uz saytimizga xush kelibsiz.
Bu saytda o`zingizni qiziqtirgan savollarga javob olishingiz va o`z sohangiz bo`yicha savollarga javob berishingiz mumkin. Bizning Oilamizga a'zo bo`lganingiz uchun chuqur Minnatdorchilik bildiramiz !!!

Chiziqdan (Linestring) atrofi 50 metrlik yo`lak yasash

+5 ovoz
51 marta ko‘rilgan
so‘radi 10 may, 17 Bilmasvoy (904 bal)

Menda koordinatalar sistemasida bitta yo`lak bor, keyin Radius bor.

postgis dan foydalanaman. Menga shu radiusli geometriya kerak. Yo`lakni ichida yotganini tekshira olishim uchun. Nima qilsam bo`ladi?

LINESTRING(69.25382137298584 41.31532698663419,69.2561388015747 41.315141645580816,69.25626754760742 41.31470649494966,69.25604224205017 41.313175386303485,69.2539930343628 41.31334461586899,69.25353169441223 41.31315926917909)

Bu mening nuqtam, radius 50 metr bo`lgan yo`lak geometry kerak.

1 ta javob

+3 ovoz
javob berdi 10 may, 17 Saidolim (3,566 bal)
tanlangan 10 may, 17 Bilmasvoy
 
Eng yaxshi javob
select ST_AsText(ST_Transform(geometry(
            ST_Buffer(geography(
                ST_Transform(ST_SetSRID(ST_GeomFromText('LINESTRING(69.25382137298584 41.31532698663419,69.2561388015747 41.315141645580816,69.25626754760742 41.31470649494966,69.25604224205017 41.313175386303485,69.2539930343628 41.31334461586899,69.25353169441223 41.31315926917909)'), 4326), 4326 )),
                50)),
            4326))

Bu yerda:

ST_GeomFromText - WKT dan geometriya yasaydi, sizning holatda, LINESTRING shaklida berilgan matndan geometriya holatiga o`tkazadi

ST_SetSRID - srid ID ni biriktiradi, yer yuzi bilan ishlash uchun

ST_Buffer - Bufferning vazifasi, ayni siz aytgan Radius bilan ishlash. Buni boshqa geometriyalarga ham ishlatsa bo`ladi

ST_Transform - yerning koordinatalariga moslash uchun

ST_AsText - geometriyani Matn shaklida ko`rish uchun ishlatiladi, geometriyani matnga o`giradi

Sizning misol uchun natija:

POLYGON((69.2562018243669 41.3155895167874,69.2563229124738 41.3155701060612,69.2564360937953 41.3155322950133,69.2565365076943 41.3154777074668,69.2566198418683 41.3154086877189,69.2566825175468 41.3153281998584,69.2567218431794 41.3152397004665,69.2568505855209 41.3148045492013,69.2568640277595 41.3147310220937,69.256861270634 41.3146568289124,69.2566359513669 41.3131257214549,69.2566117234502 41.3130394202874,69.2565656492758 41.3129583350764,69.2564994963997 41.3128855763803,69.2564158026049 41.31282393533,69.2563177785424 41.3127757765596,69.2562091845652 41.3127429475006,69.2560941864792 41.312726707515,69.2559771957455 41.3127276795876,69.2541112526107 41.3128817761129,69.2538126059105 41.3127617924827,69.2537043612858 41.31272811002,69.2535894812988 41.3127109966588,69.2534723806384 41.3127111100434,69.2533575593259 41.3127284458168,69.2532494297958 41.3127623377882,69.2531521473414 41.3128114835326,69.2530694504383 41.3128739944381,69.2530045170826 41.3129474682796,69.2529598426624 41.3130290815301,69.2529371440555 41.3131156978617,69.2529372936412 41.3132039886701,69.2529602857623 41.3132905609889,69.2530052369286 41.3133720878789,69.253070419756 41.3134454362832,69.2531533293397 41.3135077874322,69.25325077951 41.3135567451721,69.2537121214785 41.3137420929693,69.2538222024596 41.3137761906618,69.2539390640135 41.313793158733,69.254058067732 41.3137923236952,69.2555143063353 41.3136720670617,69.2556628567219 41.3146816270073,69.2556491666347 41.3147278971179,69.2537583667431 41.3148791140563,69.2536436866416 41.3148969871457,69.2535358347931 41.3149313847728,69.2534389558203 41.3149809850806,69.2533567726943 41.3150438819889,69.2532924436684 41.3151176584387,69.2532484409075 41.3151994792737,69.2532264554787 41.3152862001885,69.2532273323547 41.3153744885593,69.253251037929 41.3154609515128,69.2532966612933 41.3155422663123,69.2533624492307 41.3156153080513,69.2534458735809 41.3156772697448,69.2535437283913 41.3157257702058,69.2536522531198 41.3157589455575,69.2537672771562 41.3157755208663,69.2538843801064 41.3157748591402,69.2562018243669 41.3155895167874))

Assalomu alaykum, yordam.uz saytimizga xush kelibsiz.

Bu saytda o`zingizni qiziqtirgan savollarga javob olishingiz va o`z sohangiz bo`yicha savollarga javob berishingiz mumkin.

Bizning Oilamizga a'zo bo`lganingiz uchun chuqur Minnatdorchilik bildiramiz !!!

Telegram kanal YordamUzRss

...