Manuele Pesenti manuelep

Reorder and Orient MULTILINESTRING Components in PostGIS

This PostgreSQL/PostGIS function, reorder_multilinestring, takes a MULTILINESTRING geometry and returns a new MULTILINESTRING with components reordered and oriented based on geometric criteria. It is particularly useful for GIS applications where the order and orientation of line segments matter, such as routing, network analysis, or pipeline management.

Features

Component extraction: Splits the input multilinestring into individual lines using ST_Dump.
Sequence ordering: Orders line components by minimum distance between consecutive endpoints, creating a coherent path.
Orientation of components: Ensures each line is oriented correctly to connect smoothly to the previous line.
Merging of close components: Optionally merges consecutive components into a single LINESTRING if the distance between them is below a configurable threshold.

If you're using this, try

https://github.com/alexcouper/captainhook

At the time of writing it provides git hook checks for pdb, pep8 and python3 syntax straight out of the box.

	import plotly.graph_objs as go
	import plotly.io as pio

	#orca serve

	if __name__ == '__main__':

	pio.orca.config.port = 8005

	data = [

	#!/usr/bin/env python
	# -- coding: utf-8 --

	import unittest, json

	from woohook import *

	class TestWoo(unittest.TestCase):

	def test_authenticate(self):

	<?php // only copy if needed

	/**
	* Removes coupon form, order notes, and several billing fields if the checkout doesn't require payment.
	*
	* REQUIRES PHP 5.3+
	*
	* Tutorial: http://skyver.ge/c
	*/
	function sv_free_checkout_fields() {

	#!/bin/bash

	git clone --recursive https://github.com/web2py/web2py.git web2py_temp
	cd web2py_temp
	git checkout tags/R-2.11.2
	git submodule update --init --recursive
	python scripts/make_min_web2py.py ../web2py
	mv applications/admin ../web2py/applications/
	cd ../
	rm -rf web2py_temp

	#!/bin/bash

	# INSTALL ORACLE INSTANT CLIENT #
	#################################

	# NOTE: Oracle requires at least 1176 MB of swap (or something around there).
	# If you are using CentOS in a VMWare VM, there's a good chance that you don't have enough by default.
	# If this describes you and you need to add more swap, see the
	# "Adding a Swap File to a CentOS System" section, here:
	# http://www.techotopia.com/index.php/Adding_and_Managing_CentOS_Swap_Space

	<!-- copy this to YOUR_THEME.tmTheme-->
	<dict>
	<key>name</key>
	<string>diff: deleted</string>
	<key>scope</key>
	<string>markup.deleted</string>
	<key>settings</key>
	<dict>
	<key>background</key>
	<string>#EAE3CA</string>

	#!/bin/bash

	sudo kextunload -b org.virtualbox.kext.VBoxUSB
	sudo kextunload -b org.virtualbox.kext.VBoxNetFlt
	sudo kextunload -b org.virtualbox.kext.VBoxNetAdp
	sudo kextunload -b org.virtualbox.kext.VBoxDrv

	sudo kextload /Library/Extensions/VBoxDrv.kext -r /Library/Extensions/
	sudo kextload /Library/Extensions/VBoxNetFlt.kext -r /Library/Extensions/
	sudo kextload /Library/Extensions/VBoxNetAdp.kext -r /Library/Extensions/

	from chardet.universaldetector import UniversalDetector
	import os.path
	import sys
	import dbfUtils
	import sys
	from osgeo import osr
	from urllib import urlencode
	from urllib2 import urlopen
	import json