Changes between Version 2 and Version 3 of UsersWikiPostGIS23UbuntuPGSQL96Apt

Timestamp:

Mar 25, 2017, 11:56:50 PM (7 years ago)

Author:

robe

Comment:

—

UsersWikiPostGIS23UbuntuPGSQL96Apt

@@ -243 +243 @@
 For more information, visit the [http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01 Boston GIS] tutorial in the section "Load Towns Data"
 
+== ogr_fdw foreign data wrapper for spatial data ==
+
+Unfortunately seems PostgreSQL Apt does not include ogr_fdw spatial data wrapper.
+The wrapper utilizes GDAL, so much of plumbing needed is already installed for you as part of PostGIS.
+Compiling isn't too difficult.  On a vanilla Ubuntu, I was able to compile and install with following:
+
+
+{{{
+#for compiling ogr_fdw
+cd ~/
+mkdir sources
+cd sources
+sudo apt-get install git
+sudo apt-get install postgresql-server-dev-9.6
+sudo apt-get install make
+sudo apt-get install gcc
+sudo apt-get install libgdal1-dev
+
+sudo git clone -b master https://github.com/pramsey/pgsql-ogr-fdw.git pgsql_ogr_fdw
+cd pgsql_ogr_fdw
+export PATH=/usr/lib/postgresql/9.6/bin:$PATH 
+make && make install
+}}}
+
+After you done, you can install the ogr_fdw extension in your database
+
+
+{{{
+sudo -u postgres psql
+}}}
+
+{{{
+
+\connect gisdb;
+CREATE EXTENSION ogr_fdw SCHEMA postgis;
+CREATE SCHEMA IF NOT EXISTS staging ;
+
+-- here I assume you have a file in root of /gis_data folder that postgres process has read rights to
+-- any file that gdal can read will do e.g shape file, CSV, etc
+CREATE SERVER svr_shp
+  FOREIGN DATA WRAPPER ogr_fdw
+  OPTIONS (
+    datasource '/gis_data',
+    format 'ESRI Shapefile' );
+
+
+-- this will link in all your shapefile tables in folder gis_data as foreign tables
+IMPORT FOREIGN SCHEMA ogr_all 
+FROM SERVER svr_shp INTO staging;
+
+
+}}}