Changes between Version 19 and Version 20 of UsersWikiPostgisTopology

Timestamp:

Sep 13, 2016, 6:22:09 AM (8 years ago)

Author:

Lars Aksel Opsahl

Comment:

Info about a simple script to convert Simple Feature to Postgis Topology

UsersWikiPostgisTopology

@@ -87 +87 @@
 this implementation follows as for these views structure.
 
+== Convert shape file and simple feature data to Postgis Topology ==
+
+Here is a ref to script that copies small tables with simple feature data into to a postgis topology table which are created on the fly.  This purpose of this script is to make it easier to Postgis Topology on your simple feature data.[[BR]]
+(This script is not created for performance but just to make easier to to get people in to test Postgis Topology on small datasets.)
+
+The script taks at minimum two parameters [[BR]]
+1) Parameters one is schema1.simple_feature_table1 used for input. [[BR]]
+2) Parameter two is the schema2.topology_table_name for the result. [[BR]]
+(More info about parameters can found in the script it self).
+
+Here is an example of how to call it
+
+{{{
+select topo_help_sf_to_topology_case_1('org_rein_sosi_dump.rein_konsesjonomr_flate','topo_test.rein_konsesjonomr_flate');
+}}}
+
+The result of this file will two tables : [[BR]]
+Table 1 : topo_test.rein_konsesjonomr_flate with the attributtes from table one and a topology column [[BR]]
+Table 2 : topo_test.rein_konsesjonomr_flate_v with attributtes from table one and a geometry columns casted from the portgis topology column. [[BR]]
+
+To check out the data use for instance qgis with Plugin: PostGIS Topology Editor from Strk .
+
+if you have some shape files added here som you can test here is a example where I uses shp2pgsl to gether with this script.
+
+{{{
+-- # create schema if not exist
+-- psql sl -c'CREATE SCHEMA IF NOT EXISTS test;'
+
+-- # copy data from shape file to postgis
+-- shp2pgsql -W ISO-8859-1 -d -D -s 4258 data/muni_surface.shp test.muni_surface | psql sl;
+
+-- #copy data from simple feature to topology
+-- psql sl -c "SELECT topo_help_sf_to_topology_case_1('test.muni_surface','test_topo.muni_surface');" 2>> /tmp/importfromtemp.log; 
+}}}
+
+To instal it 
+{{{
+git clone https://github.com/NibioOpenSource/pgtopo_update_sql
+cd pgtopo_update_sql/src/test/sql/import
+cat script/func_* | psql 
+}}}
+
+
+
 == Validating Topology ==