Remi-C

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!--Created by yFiles for HTML 2.1.0.3-RC3-->
<graphml xsi:schemaLocation="http://graphml.graphdrawing.org/xmlns http://www.yworks.com/xml/schema/graphml.html/2.0/ygraphml.xsd " xmlns="http://graphml.graphdrawing.org/xmlns" xmlns:demostyle="http://www.yworks.com/yFilesHTML/demos/FlatDemoStyle/1.0" xmlns:bpmn="http://www.yworks.com/xml/yfiles-for-html/bpmn/2.0" xmlns:demotablestyle="http://www.yworks.com/yFilesHTML/demos/FlatDemoTableStyle/1.0" xmlns:uml="http://www.yworks.com/yFilesHTML/demos/UMLDemoStyle/1.0" xmlns:compat="http://www.yworks.com/xml/yfiles-compat-arrows/1.0" xmlns:VuejsNodeStyle="http://www.yworks.com/demos/yfiles-vuejs-node-style/1.0" xmlns:y="http://www.yworks.com/xml/yfiles-common/3.0" xmlns:x="http://www.yworks.com/xml/yfiles-common/markup/3.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
	<key id="d0" for="node" attr.type="boolean" attr.name="Expanded" y:attr.uri="http://www.yworks.com/xml/yfiles-common/2.0/folding/Expanded

Remi-C

DROP FUNCTION IF EXISTS find_useless_postgres_file(text);
CREATE OR REPLACE FUNCTION find_useless_postgres_file(    database_name text) 
	RETURNS TABLE(file_name text, file_relative_path text,file_abs_path text,size bigint) AS 
	$BODY$
		DECLARE     
			_useless record; 
		BEGIN  

			RETURN QUERY

Remi-C

SET search_path to patch_connectivity,patch_connectivity_topo,  benchmark_cassette_2013, test_grouping, public, topology ;

ST_StraightSkeleton(geometry geom)

SELECT ST_IsSImple(total_area)
FROM total_area_2

DROP TABLE IF EXISTS total_area_2 ; 
CREATE TABLE total_area_2 AS 

Remi-C

--------------------------
-- Rémi Cura, Thales IGN, 2015
-- this script uses pgrouting to leverage connectivity of patches
-- useful for the journal article about point cloud server
--
-- NOTE: depends on rc_lib extension  : https://github.com/Remi-C/PPPP_utilities
---------------------------


--create a schema, set search_path