5

I'm completely new to PostgreSQL and PostGIS. I finally got both installed and have the PostGIS extension installed. I'm running the PostGIS shapefile import manager. I select my shapefile and click import. It says shapefile import completed but I do not see it in the file in the database. Any thoughts?

enter image description here

1

2

enter image description here

Matt
  • 1,672
  • 16
  • 24
Christopher Harrod
  • 189
  • 2
  • 14
  • What parameters did you use, a screen shot may be appropriate? Do you have, or have you given, permission to the tool to 'see' the database? RDBMS is not like filesystem data, there's so much more to it, for example did you create a new database using the PostGIS template? – Michael Stimson Mar 11 '15 at 04:28
  • http://tinypic.com/r/znvt3l/8 http://tinypic.com/r/znvt3l/8 http://tinypic.com/r/n3x7v5/8 http://tinypic.com/r/o8rmgl/8

    here are the screenshots in sequential order.

     – Christopher Harrod Mar 11 '15 at 04:50
  • It is best to edit and insert the image into your question, many users may be unable to go to web hosting sites due to I.T. restrictions. – Michael Stimson Mar 11 '15 at 05:02
  • DO NOT IMPORT INTO TEMPLATE_POSTGIS use that template to create a live database. Do you have PGAdminIII? – Michael Stimson Mar 11 '15 at 05:04
  • I created that template myself. I don't know what you mean by creating a live database. I tried creating a newdatabase and added the postgis extensions to it. I then tried to import again and it didn't show. – Christopher Harrod Mar 11 '15 at 05:08
  • When you install PostGIS it creates a template_postgis database that you need to use to create a spatially enabled database. – Michael Stimson Mar 11 '15 at 05:09
  • It didn't do that for me. So I created my own with the same name and added the extensions. It says it's installed when I go the app stack builder. – Christopher Harrod Mar 11 '15 at 05:11
  • Then something went wrong during the install. Uninstall and reinstall PostGIS. The template_postgis is critical to maintaining a PostGIS database.. answer coming soon. – Michael Stimson Mar 11 '15 at 05:13
  • template_postgis is old school. At least the windows installer, we no longer install a template_postgis database, since using CREATE EXTENSION postgis; is the new way of installing postgis. – Regina Obe Mar 12 '15 at 08:17
  • Chris, yah what you have looks fine, but did you mean to load the table in your template-postgis or you spatialdata. Your screen shot shows you had selected template-postgis, so the table would be in there and given templates by default you would make read-only who knows what that actually did. – Regina Obe Mar 12 '15 at 08:19

1 Answers1

5

Using PGAdminIII create a database using the template_postgis as a template, this copies all the triggers, functions and tables into a new database. Right click on the databases symbol and select 'new database':

enter image description here

Then you can import data into it. It is probably best to not use the pg_admin user but if you're the only one seeing the database that should be fine. Have a read of Roles and Privileges to see about creating a 'user' or users identity(s).

If you don't have template_postgis in your database then perhaps you can create it (or here) but I found it best (easier) to uninstall and reinstall PostGIS.

Community
  • 1
Michael Stimson
  • 25,566
  • 2
  • 35
  • 74
  • Hey Michael, Thanks for the help. I installed postgis again and it created a sample database with 7 extensions. I then followed your instructions above. The new database looked identical to the sample database. I then tried to import the shapefile with no luck again. It said it succeeded but it doesn't show up in the tree. alkdjslsjd! – Christopher Harrod Mar 11 '15 at 05:35
  • Are you looking in the public schema? DB=>Schemas=>public=>tables. Perhaps it doesn't like SRID=0 but that doesn't seem likely, not every spatial reference is a SRID. Confirm that you're connecting with PGAdmin as the same user (postgres), it might be there but you may not be able to see it. Also it might help if you have a postgres schema... there was something about that but I don't remember if it's a SDE or PostGIS requirement. – Michael Stimson Mar 11 '15 at 05:47
  • Both answers are correct above. The shp files were importing but I wasn't looking in the right place. I needed to be in DB=>Schemas=>public=>tables. Thanks Michael – Christopher Harrod Mar 12 '15 at 05:35