[postgis-users] PostGIS 2.0 Shapefile and DBF Loader

[Carson Gray]

Yes, I read that you could use that. However, I am using PostgreSQL and
PostGIS for class and the homework assignments ask us to use it.
Frustrating getting Mac to work with certain programs.

On Fri, Mar 22, 2019 at 5:00 PM Regina Obe <lr at pcorp.us> wrote:

> Carson,
>
>
>
> I should add – if you haven't checked out QGIS and you are new to PostGIS
> please do – https://qgis.org
>
>
>
> It has binaries for Mac, Windows, Linux and has a pretty nice tool called
> DbManager that allows you to load data into PostGIS in many formats
> (including ESRI Shapefile)
>
>
>
>
> https://docs.qgis.org/testing/en/docs/training_manual/databases/db_manager.html
>
>
>
> Hope that helps,
>
> Regina
>
>
>
>
>
> *From:* Regina Obe [mailto:lr at pcorp.us]
> *Sent:* Friday, March 22, 2019 4:44 PM
> *To:* 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> *Subject:* RE: [postgis-users] PostGIS 2.0 Shapefile and DBF Loader
>
>
>
> Carson,
>
>
>
> You'd need shp2pgsql-gui installed (and pgAdmin3 didn't come with that).
> That always got packaged with the desktop distributions that included
> PostGIS.
>
>
>
> All pgAdmin3 really helped you with was prefilling the connection info,
> which turned out to be more convenient than I thought.  It's amazing how
> lazy I've become.
>
>
>
> If you can find where the shp2pgsql-gui binary is installed on your system
> you can launch it directly and then click the "View connection details" and
> fill in the information that pgAdmin3 would so conveniently fill in for you.
>
>
>
>
>
>
>
>
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org
> <postgis-users-bounces at lists.osgeo.org>] *On Behalf Of *Carson Gray
> *Sent:* Friday, March 22, 2019 3:38 PM
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *Subject:* Re: [postgis-users] PostGIS 2.0 Shapefile and DBF Loader
>
>
>
> Should I just download pgAdmin 3?
>
>
>
> On Fri, Mar 22, 2019 at 2:25 PM Paul Ramsey <pramsey at cleverelephant.ca>
> wrote:
>
> I wonder if we could do some thing native in pgadmin4 with shapely
>
>
> On Mar 22, 2019, at 11:15 AM, Carson Gray <carson.gray3 at gmail.com> wrote:
>
> I am very new to this and need to upload shapefiles to pgAdmin 4 and my
> instructions say to use the Shapefile Loader.
>
>
>
> On Fri, Mar 22, 2019 at 2:12 PM Regina Obe <lr at pcorp.us> wrote:
>
> Carson,
>
>
>
> Do you compile your own PostGIS or you get from a distribution.  We still
> have shp2pgsql-gui in PostGIS code base, and I still ship it as part of the
> Windows EDB builds.
>
>
>
> Unfortunately pgAdmin4 plugin architecture changed from pgAdmin3 days, so
> shp2gpsql-gui cannot work as a plugin under pgAdmin4.
>
>
>
> I took it out of our upcoming PostGIS In Action book we are doing because
> of that and hoping we'll have a replacement for it soon that piggy backs on
> shp2pgsql commandline.
>
>
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Carson Gray
> *Sent:* Friday, March 22, 2019 1:50 PM
> *To:* postgis-users at lists.osgeo.org
> *Subject:* [postgis-users] PostGIS 2.0 Shapefile and DBF Loader
>
>
>
> Hello,
>
>
>
> I have a Macbook Pro and am using PGAdmin 4 and PostGIS. I cannot seem to
> find the PostGIS 2.0 Shapefile and DBF Loader. Can anyone help with this?
> Is there something else I need to download? Thanks.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190322/0a39b492/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 61142 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190322/0a39b492/attachment.png>