[postgis-users] Fwd: Pushing all the shapefiles into the Postgres

[Smaran Harihar]

Hey thanks a lot Michi. It works like a charm.

On Thu, Nov 22, 2012 at 3:21 AM, <Michael.Scholz at dlr.de> wrote:

>  Moin.****
>
> The PostGIS documentation is a good starting point. You can use the
> command line shp2pgsql loader (
> http://postgis.refractions.net/documentation/manual-2.0/using_postgis_dbmanagement.html#shp2pgsql_usage)
> which comes with your PostGIS installation. ****
>
> ** **
>
> To batch-load shapefiles on Ubuntu shell, you could use a for-loop.
> Example: ****
>
> user at server:/your/directory> for shape in **.shp; do shp2pgsql -c -D -s
> 4326 -I $shape yourschema.${shape%.**} | psql -d yourdatabase; done****
>
> ** **
>
> Set all parameters of shp2pgsql according to your needs, especially the
> SRID (-s).****
>
> ** **
>
> Ahoi! Michi****
>
> ** **
>
> *Von:* postgis-users-bounces at lists.osgeo.org [mailto:
> postgis-users-bounces at lists.osgeo.org] *Im Auftrag von *Smaran Harihar
> *Gesendet:* Mittwoch, 21. November 2012 20:23
> *An:* PostGIS Users Discussion
> *Betreff:* [postgis-users] Fwd: Pushing all the shapefiles into the
> Postgres****
>
> ** **
>
> And I am working on the command line as I am on remote Ubuntu Server. So
> the Introduction <http://workshops.opengeo.org/postgis-intro/> given in
> the OpenGeo Workshop is not really helpful.
>
> Thanks,****
>
> Smaran****
>
> ---------- Forwarded message ----------
> From: *Smaran Harihar* <smaran.harihar at gmail.com>
> Date: Wed, Nov 21, 2012 at 12:04 PM
> Subject: Pushing all the shapefiles into the Postgres
> To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
>
>
> Hi Guys,****
>
> ** **
>
> I have been working with lots of shapefiles and hosting them on the
> Geoserver (around 8k). Now the Geoserver is completely stalled and fetching
> the data is almost not possible. I have installed the complete OpenGeo
> Suite and till now have not played with the PostGIS. I guess adding the
> shapefiles to the PostGIS will surely speed up the process.****
>
> ** **
>
> The problem is I am new to PostGIS, so can someone share some ideas where
> I should begin and how I can add the shapefiles to the PostGIS database.
> ****
>
> ** **
>
> --
> Thanks & Regards****
>
> Smaran Harihar****
>
> ** **
>
>
>
> ****
>
> ** **
>
> --
> Thanks & Regards****
>
> Smaran Harihar****
>
> ** **
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>


-- 
Thanks & Regards
Smaran Harihar
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121125/ac810b43/attachment.html>