How to join multiple nearest neighbouring nodes using postgresql or python?How to create a line layer which connects a point layer to a line layer?How do I plot a line on a map, or obtain the latitude and longitude coordinates of such a line, that is 120km north of the US-Canada border?PostgreSQL PL/Python Function for “IF” conditionPostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Incomplete spatial join in PostgreSQLCreate PostgreSQL function using pythonHow to find nearest nodes of polyline in QGIS using PythonCompute 3D seismic fold with QGIS and PythonAlignment and distribution tools for shapefiles?Shortest path with certain points

Why "Having chlorophyll without photosynthesis is actually very dangerous" and "like living with a bomb"?

how to check a propriety using r studio

How is it possible to have an ability score that is less than 3?

Is it possible to run Internet Explorer on OS X El Capitan?

Watching something be written to a file live with tail

Has there ever been an airliner design involving reducing generator load by installing solar panels?

How to format long polynomial?

Why is Minecraft giving an OpenGL error?

Was any UN Security Council vote triple-vetoed?

Codimension of non-flat locus

Why does Kotter return in Welcome Back Kotter?

Cross compiling for RPi - error while loading shared libraries

Can a vampire attack twice with their claws using multiattack?

Decision tree nodes overlapping with Tikz

Why doesn't H₄O²⁺ exist?

Client team has low performances and low technical skills: we always fix their work and now they stop collaborate with us. How to solve?

Alternative to sending password over mail?

Why doesn't a class having private constructor prevent inheriting from this class? How to control which classes can inherit from a certain base?

Rock identification in KY

Theorems that impeded progress

Accidentally leaked the solution to an assignment, what to do now? (I'm the prof)

Are astronomers waiting to see something in an image from a gravitational lens that they've already seen in an adjacent image?

Two films in a tank, only one comes out with a development error – why?

How can I prevent hyper evolved versions of regular creatures from wiping out their cousins?



How to join multiple nearest neighbouring nodes using postgresql or python?


How to create a line layer which connects a point layer to a line layer?How do I plot a line on a map, or obtain the latitude and longitude coordinates of such a line, that is 120km north of the US-Canada border?PostgreSQL PL/Python Function for “IF” conditionPostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Incomplete spatial join in PostgreSQLCreate PostgreSQL function using pythonHow to find nearest nodes of polyline in QGIS using PythonCompute 3D seismic fold with QGIS and PythonAlignment and distribution tools for shapefiles?Shortest path with certain points






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















I have many short paths SHP file which look like a longer dashed path.
Is there an efficient way to connect these paths to one continuous path?
If possible, I want to avoid a hundred times manually selecting 2 nodes pairwise and joining them. And the distance between all the lines are not same



enter image description here










share|improve this question
























  • If can use PyQGIS - this might help you: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/… Also you could try to convert them into points and then use this tool: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/…

    – Mr. Che
    Apr 2 at 10:32












  • Thank you for reply but i am looking for something using postgis or python

    – poonam patel
    2 days ago

















1















I have many short paths SHP file which look like a longer dashed path.
Is there an efficient way to connect these paths to one continuous path?
If possible, I want to avoid a hundred times manually selecting 2 nodes pairwise and joining them. And the distance between all the lines are not same



enter image description here










share|improve this question
























  • If can use PyQGIS - this might help you: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/… Also you could try to convert them into points and then use this tool: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/…

    – Mr. Che
    Apr 2 at 10:32












  • Thank you for reply but i am looking for something using postgis or python

    – poonam patel
    2 days ago













1












1








1








I have many short paths SHP file which look like a longer dashed path.
Is there an efficient way to connect these paths to one continuous path?
If possible, I want to avoid a hundred times manually selecting 2 nodes pairwise and joining them. And the distance between all the lines are not same



enter image description here










share|improve this question
















I have many short paths SHP file which look like a longer dashed path.
Is there an efficient way to connect these paths to one continuous path?
If possible, I want to avoid a hundred times manually selecting 2 nodes pairwise and joining them. And the distance between all the lines are not same



enter image description here







python postgresql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 2 days ago







poonam patel

















asked Apr 2 at 10:12









poonam patelpoonam patel

112




112












  • If can use PyQGIS - this might help you: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/… Also you could try to convert them into points and then use this tool: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/…

    – Mr. Che
    Apr 2 at 10:32












  • Thank you for reply but i am looking for something using postgis or python

    – poonam patel
    2 days ago

















  • If can use PyQGIS - this might help you: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/… Also you could try to convert them into points and then use this tool: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/…

    – Mr. Che
    Apr 2 at 10:32












  • Thank you for reply but i am looking for something using postgis or python

    – poonam patel
    2 days ago
















If can use PyQGIS - this might help you: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/… Also you could try to convert them into points and then use this tool: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/…

– Mr. Che
Apr 2 at 10:32






If can use PyQGIS - this might help you: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/… Also you could try to convert them into points and then use this tool: docs.qgis.org/testing/en/docs/user_manual/processing_algs/qgis/…

– Mr. Che
Apr 2 at 10:32














Thank you for reply but i am looking for something using postgis or python

– poonam patel
2 days ago





Thank you for reply but i am looking for something using postgis or python

– poonam patel
2 days ago










0






active

oldest

votes












Your Answer








StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317467%2fhow-to-join-multiple-nearest-neighbouring-nodes-using-postgresql-or-python%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Geographic Information Systems Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f317467%2fhow-to-join-multiple-nearest-neighbouring-nodes-using-postgresql-or-python%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Romeo and Juliet ContentsCharactersSynopsisSourcesDate and textThemes and motifsCriticism and interpretationLegacyScene by sceneSee alsoNotes and referencesSourcesExternal linksNavigation menu"Consumer Price Index (estimate) 1800–"10.2307/28710160037-3222287101610.1093/res/II.5.31910.2307/45967845967810.2307/2869925286992510.1525/jams.1982.35.3.03a00050"Dada Masilo: South African dancer who breaks the rules"10.1093/res/os-XV.57.1610.2307/28680942868094"Sweet Sorrow: Mann-Korman's Romeo and Juliet Closes Sept. 5 at MN's Ordway"the original10.2307/45957745957710.1017/CCOL0521570476.009"Ram Leela box office collections hit massive Rs 100 crore, pulverises prediction"Archived"Broadway Revival of Romeo and Juliet, Starring Orlando Bloom and Condola Rashad, Will Close Dec. 8"Archived10.1075/jhp.7.1.04hon"Wherefore art thou, Romeo? To make us laugh at Navy Pier"the original10.1093/gmo/9781561592630.article.O006772"Ram-leela Review Roundup: Critics Hail Film as Best Adaptation of Romeo and Juliet"Archived10.2307/31946310047-77293194631"Romeo and Juliet get Twitter treatment""Juliet's Nurse by Lois Leveen""Romeo and Juliet: Orlando Bloom's Broadway Debut Released in Theaters for Valentine's Day"Archived"Romeo and Juliet Has No Balcony"10.1093/gmo/9781561592630.article.O00778110.2307/2867423286742310.1076/enst.82.2.115.959510.1080/00138380601042675"A plague o' both your houses: error in GCSE exam paper forces apology""Juliet of the Five O'Clock Shadow, and Other Wonders"10.2307/33912430027-4321339124310.2307/28487440038-7134284874410.2307/29123140149-661129123144728341M"Weekender Guide: Shakespeare on The Drive""balcony"UK public library membership"romeo"UK public library membership10.1017/CCOL9780521844291"Post-Zionist Critique on Israel and the Palestinians Part III: Popular Culture"10.2307/25379071533-86140377-919X2537907"Capulets and Montagues: UK exam board admit mixing names up in Romeo and Juliet paper"Istoria Novellamente Ritrovata di Due Nobili Amanti2027/mdp.390150822329610820-750X"GCSE exam error: Board accidentally rewrites Shakespeare"10.2307/29176390149-66112917639"Exam board apologises after error in English GCSE paper which confused characters in Shakespeare's Romeo and Juliet""From Mariotto and Ganozza to Romeo and Guilietta: Metamorphoses of a Renaissance Tale"10.2307/37323537323510.2307/2867455286745510.2307/28678912867891"10 Questions for Taylor Swift"10.2307/28680922868092"Haymarket Theatre""The Zeffirelli Way: Revealing Talk by Florentine Director""Michael Smuin: 1938-2007 / Prolific dance director had showy career"The Life and Art of Edwin BoothRomeo and JulietRomeo and JulietRomeo and JulietRomeo and JulietEasy Read Romeo and JulietRomeo and Julieteeecb12003684p(data)4099369-3n8211610759dbe00d-a9e2-41a3-b2c1-977dd692899302814385X313670221313670221

Creating closest line along the point''s azimuth using PostgreSQL Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Drawing line between points at specific distance in PostGIS?How to efficiently find the closest point over the dateline?How to find the nearest point by using PostGIS function?PostGIS nearest point with LATERAL JOIN in PostgreSQL 9.3+Creating a table and inserting selected streets using plpgsql functionsCreating a table that stores Distances and other columnSaving select query results (year wise) from PostgreSQL/PostGIS to text filesWhat is the information behind this geometry?How to give start and end vertex ids dynamically in pgr_dijkstra?Point to Polygon nearest distance DS_distance is not using geography index & knn <-> or <#> does not give result in orderLine to point conversion with start point and end point detection?

Crop image to path created in TikZ? Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Crop an inserted image?TikZ pictures does not appear in posterImage behind and beyond crop marks?Tikz picture as large as possible on A4 PageTransparency vs image compression dilemmaHow to crop background from image automatically?Image does not cropTikzexternal capturing crop marks when externalizing pgfplots?How to include image path that contains a dollar signCrop image with left size given