<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} --></style>
</head>
<body dir="ltr">
<div id="divtagdefaultwrapper" style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p style="margin-bottom: 0in">Hi</p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in">First I tested with lines and that worked find, the lines added the second time snapped to first lines. The data I tested with are found at.</p>
<p style="margin-bottom: 0in"><a href="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/import/data3/edge_1219.prj" id="LPlnk533506">https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/import/data3/edge_1219.</a>shp
.<br>
</p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in"><font size="3"><span style="font-weight: normal">At
<a href="https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisTopology">https://trac.osgeo.org/postgis/wiki/UsersWikiPostgisTopology</a> I have added section
</span></font></p>
<p style="margin-bottom: 0in"></p>
<p style="margin-bottom: 0in"><font size="3">called “</font><font color="#000000"><font face="ArialMT, sans-serif"><font size="3">Convert shape file and simple feature data to Postgis Topology” that has some more info the function </font></font></font><span style="color: rgb(0, 128, 0); font-family: Monaco, monospace; font-size: 15px;">topo_help_sf_to_topology_case_1</span><span style="font-size: 12pt;">.</span></p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in">Here is the sql I tested with for lines that worked ok. <br>
</p>
<p style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt">#
</font></font></font><font color="#7f0055"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><b>create</b></font></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"> test
</font></font></font><font color="#7f0055"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><b>schema</b></font></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"> if
</font></font></font><font color="#7f0055"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><b>not</b></font></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"> exist</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c</font><font color="#0000ff">'CREATE SCHEMA IF NOT EXISTS test2;'</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_buffer_out that contains
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> ok buffered out municipalitie border
</font><font color="#008000">"where komid not in (125)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">shp2pgsql -W ISO-8859-1 -d -D -s 4258 data3/edge_1219 test2.sf_in | psql sl; psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_3.muni_surface');"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_3.muni_surface (append data to topo_3.muni_edge)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_3.muni_edge',0.00001);"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_buffer_in that contains
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> ok buffered </font>
<font color="#7f0055"><b>in</b></font><font color="#000000"> municipalitie border
</font><font color="#008000">"where komid not in (214)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">shp2pgsql -W ISO-8859-1 -d -D -s 4258 data3/edge_1521 test2.sf_in | psql sl; psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_3.muni_surface');"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_3.muni_surface (append data to topo_3.muni_edge)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_3.muni_edge',0.00001);"</font><font color="#000000">
</font></font></font></p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in"></p>
<p style="margin-bottom: 0in">Then I tried the same with surface data and they did not snap to as I expected.
</p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in">The file <a href="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/import/data2/muni_ok.shp" title="https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/import/data2/muni_ok.shp
Cmd+ Klikk eller trykk for å følge koblingen">
https://github.com/NibioOpenSource/pgtopo_update_sql/blob/develop/src/test/sql/import/data2/muni_ok.shp</a> contains the ok surfaces, but not the 4 surfaces where I have moved the border data around. But all edges needed are present in this file since the surface
not added are inclosed by other surfaces.</p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in"><font size="3">The I added the files “<font color="#000000"><font face="Menlo-Regular">muni_buffer_in.shp muni_buffer_in_2.shp muni_buffer_out.shp muni_projected.shp”, my hope was that the edges for this surfaces should snap to
the exiting edges, but that did not seem to happen.</font></font></font></p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in"><font size="3"><font color="#000000"><font face="Menlo-Regular">Her is the code I tested with </font></font></font></p>
<p style="margin-bottom: 0in"><font size="3"><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><br>
</font></font></font></font></p>
<p style="margin-bottom: 0in"><font size="3"><font color="#000000"><font face="Menlo-Regular"></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt">#
</font></font></font><font color="#7f0055"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><b>create</b></font></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"> test
</font></font></font><font color="#7f0055"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><b>schema</b></font></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"> if
</font></font></font><font color="#7f0055"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><b>not</b></font></font></font><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"> exist</font></font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c</font><font color="#0000ff">'CREATE SCHEMA IF NOT EXISTS test2;'</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_ok that contains ok municipalities border
</font><font color="#008000">"where komid not in (125,214,233,301)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font color="#000000"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt">shp2pgsql -W UTF-8 -d -D -s 4258 data2/muni_ok.shp test2.sf_in | psql sl;
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_2.muni_surface (topo
</font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_2.muni_surface will craeted
</font><font color="#7f0055"><b>on</b></font><font color="#000000"> the fly if it does
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> exist)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface',0.00001,false,'new_gid_id',true,true);"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_buffer_out that contains
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> ok buffered out municipalitie border
</font><font color="#008000">"where komid not in (125)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">shp2pgsql -W ISO-8859-1 -d -D -s 4258 data2/muni_buffer_out test2.sf_in | psql sl; psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface');"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_2.muni_surface (append data to topo_2.muni_surface)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface',0.00001);"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_buffer_in that contains
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> ok buffered </font>
<font color="#7f0055"><b>in</b></font><font color="#000000"> municipalitie border
</font><font color="#008000">"where komid not in (214)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">shp2pgsql -W ISO-8859-1 -d -D -s 4258 data2/muni_buffer_in test2.sf_in | psql sl; psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface');"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_2.muni_surface (append data to topo_2.muni_surface)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface',0.00001);"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_projected that contains
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> ok projectes municipalitie border
</font><font color="#008000">"where komid not in (233)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">shp2pgsql -W ISO-8859-1 -d -D -s 4258 data2/muni_projected test2.sf_in | psql sl; psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface');"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_2.muni_surface (append data to topo_2.muni_surface)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface',0.00001);"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><br>
</p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy file muni_buffer_in_2 that contains
</font><font color="#7f0055"><b>not</b></font><font color="#000000"> ok buffered </font>
<font color="#7f0055"><b>in</b></font><font color="#000000"> municipalitie border
</font><font color="#008000">"where komid not in (301)"</font><font color="#000000">
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> test2.sf_in (</font><font color="#7f0055"><b>drop</b></font><font color="#000000">
</font><font color="#7f0055"><b>and</b></font><font color="#000000"> </font><font color="#7f0055"><b>create</b></font><font color="#000000"> if exits)
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">shp2pgsql -W ISO-8859-1 -d -D -s 4258 data2/muni_buffer_in_2 test2.sf_in | psql sl; psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface');"</font><font color="#000000">
</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000"># copy data
</font><font color="#7f0055"><b>from</b></font><font color="#000000"> test2.sf_in
</font><font color="#7f0055"><b>into</b></font><font color="#000000"> </font><font color="#7f0055"><b>table</b></font><font color="#000000"> topo_2.muni_surface (append data to topo_2.muni_surface)</font></font></font></p>
<p align="LEFT" style="margin-bottom: 0in"><font face="Monaco, monospace"><font size="2" style="font-size: 11pt"><font color="#000000">psql sl -c
</font><font color="#008000">"SELECT topo_help_sf_to_topology_case_1('test2.sf_in','topo_2.muni_surface',0.00001);"</font><font color="#000000">
</font></font></font></p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in"><font size="3"><font color="#000000"><font face="Menlo-Regular">Lars</font></font></font></p>
<p></p>
<p style="margin-bottom: 0in"><br>
</p>
<p><br>
</p>
<p><br>
</p>
</div>
</body>
</html>