{"id":140,"date":"2015-12-17T02:18:37","date_gmt":"2015-12-17T02:18:37","guid":{"rendered":"https:\/\/www.acugis.com\/docs\/?p=140"},"modified":"2017-03-13T22:31:27","modified_gmt":"2017-03-13T22:31:27","slug":"load-shp-file","status":"publish","type":"post","link":"https:\/\/acugis.com\/docs\/postgis\/load-shp-file\/","title":{"rendered":"Loading SHP Files"},"content":{"rendered":"

Loading SHP Files<\/span><\/h2>\n

This post will cover loading shp files to your PostGIS database.<\/p>\n

We’ll look at loading files via our shp2pgsql GUI in your control panel, as well as via command line (SSH) and via your desktop.<\/p>\n

In this demonstration, we will be using the states_basic21.zip file from the ESRI ArcGIS site, which you can download at:<\/p>\n

https:\/\/www.arcgis.com\/home\/item.html?id=f7f805eb65eb4ab787a0a3e1116ca7e5<\/a><\/p>\n

If you do not already have a PostGIS database ready, you will need to:<\/p>\n

1. Create a PostgreSQL database<\/a><\/p>\n

2. Install PostGIS extensions<\/a> into the database we created.<\/p>\n

(Video tutorials courtesy of our brainfurnace.com<\/a> site).<\/p>\n

<\/h3>\n

<\/h3>\n

Loading via our control panel shp2pgsql tool<\/span><\/span><\/h3>\n

With our PostGIS database, we’ll load the ESRI file using the shp2pgsql tool in your control panel.<\/p>\n

1. In your control panel, under GIS Tools, click on the shp2pgsql icon:<\/strong><\/span><\/h6>\n

\"shp2pgsql\"<\/p>\n

 <\/p>\n

2. Upload the\u00a0states_basic21.zip file (do not<\/strong> unzip it – you need all of the files!):<\/span><\/h6>\n

 <\/p>\n

\"upload-shp-file\"<\/p>\n

 <\/p>\n

3.\u00a0 Select the database and select states.shp from the “File to Load” dropdown.<\/span><\/h6>\n

\"shp2pgsql\"<\/p>\n

Using the defaults, which is fine for most cases, a new table called ‘states’ will be created with a GEOM column.<\/p>\n

Optionally, you can set the table name to something else, set the SRID, append to an existing table, and specify the schema.<\/p>\n

4. Log into phpPgAdmin<\/a>, and you should see the states table has been created:<\/span><\/h6>\n

\"phppgadmin\"<\/p>\n

 <\/p>\n

Loading via Command Line (SSH).<\/span><\/span><\/h3>\n

You can also load your shp files via the command line.<\/p>\n

1. Start and SSH session and upload the zip file (or download it using wget).<\/span><\/h6>\n
2. Unzip the file.
\n<\/span><\/h6>\n

user@demo [~\/home]# unzip – q states_21basic.zip<\/p>\n

3. Move into the shp fil directory directory :<\/span><\/h6>\n

user@demo [~\/home]# cd states_basic<\/p>\n

user@demo [~\/states_basic]#<\/p>\n

4. Issue ls to check all of the file are present.<\/span><\/h6>\n

user@demo [~\/states_basic]# ls
\n.\/\u00a0\u00a0 states.dbf\u00a0 states.sbn\u00a0 states.shp\u00a0\u00a0\u00a0\u00a0\u00a0 states.shx
\n..\/\u00a0 states.prj\u00a0 states.sbx\u00a0 states.shp.xml<\/p>\n

5. Issue the following to load the file into your database using the defaults:<\/span><\/h6>\n

user@demo [~\/states_basic]# shp2pgsql states states | psql -d demo_db<\/p>\n

6. You should see something like below when using defaults:<\/span><\/h6>\n

Shapefile type: Polygon
\nPostgis type: MULTIPOLYGON[2]
\nPassword:
\nSET
\nSET
\nBEGIN
\nCREATE TABLE
\nALTER TABLE
\naddgeometrycolumn
\n—————————————————–
\npublic.states.geom SRID:0 TYPE:MULTIPOLYGON DIMS:2
\n(1 row)<\/p>\n

INSERT 0 1
\nINSERT 0 1
\nINSERT 0 1
\nINSERT 0 1
\nINSERT 0 1
\nINSERT 0 1
\nINSERT 0 1<\/p>\n

……………….
\nINSERT 0 1
\nCOMMIT
\nuser@demo [~\/states_basic]#<\/p>\n

For a list shp2pgsql command line options, see:<\/p>\n

http:\/\/www.bostongis.com\/pgsql2shp_shp2pgsql_quickguide.bqg<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

Loading via Desktop Client
\n<\/span><\/span><\/h3>\n

If you have installed PgAdminIII on your Desktop (or using the stand alone shp2pgsql GUI), follow below:<\/p>\n

1. Download the states_basic21.zip file and UNZIP it on your desktop<\/span><\/h6>\n
2. In PgAdminIII, go to plugins > PostGIS Shapefile and DBF Loader:<\/span><\/h6>\n

\"desktop-shp-file-a\"<\/p>\n

3. Click on View Connection Details and add your connection information:<\/span><\/h6>\n

\"desktop-shp-file-1\"<\/p>\n

 <\/p>\n

4. Click on Options (note they are the same as the tool in our control panel):<\/span><\/h6>\n

\"options\"<\/p>\n

 <\/p>\n

5. Navigate to the location you have unzip the shp file to:<\/span><\/h6>\n

\"desktop-shp-file\"<\/p>\n

6. Click the Open button and then click on Import.
\n<\/span><\/h6>\n

If all went well, you should see something like below displayed in the panel:<\/p>\n

connecting:\u00a0 host=mydomain.com port=5432 user=demo password=’********’ dbname=demo_db<\/p>\n

==============================
\nImporting with configuration: states, public, geom, C:\\Documents and Settings\\user\\Desktop\\db-demo\\states_21basic\\states, mode=c, dump=1, simple=0, geography=0, index=1, shape=1, srid=0
\nShapefile type: Polygon
\nPostGIS type: MULTIPOLYGON[2]
\nShapefile import completed.<\/p>\n

 <\/p>\n

NOTE:<\/strong><\/span> In all the above cases, we did not set a SRID<\/em>. For our demonstrations with the states_basic21 file, this will not be an issue. In other instances, it will be required.\u00a0 We will look at setting the SRID, as well as updating it, in subsequent installments.<\/p>\n

If you have any questions or require assistance, please create a support ticket.<\/p>\n","protected":false},"excerpt":{"rendered":"

Loading SHP Files This post will cover loading shp files to your PostGIS database. We’ll look at loading files via our shp2pgsql GUI in your control panel, as well as via command line (SSH) and via your desktop. In this demonstration, we will be using the states_basic21.zip file from the ESRI ArcGIS site, which you … <\/p>\n

Continue reading “Loading SHP Files”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-140","post","type-post","status-publish","format-standard","hentry","category-postgis"],"_links":{"self":[{"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/posts\/140"}],"collection":[{"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/comments?post=140"}],"version-history":[{"count":9,"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"predecessor-version":[{"id":249,"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/posts\/140\/revisions\/249"}],"wp:attachment":[{"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/acugis.com\/docs\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}