[postgis-devel] shp2pgsql

[David Haynes II]

Hello,

We haven't really focused on developing the parallel uploading of the
shapefile. We have instead focused on introducing parallel spatial
analysis. However, this is something we might explore in the future.

On Sun, Jan 24, 2016 at 6:38 PM, Stefan Keller <sfkeller at gmail.com> wrote:

> David, PostGIS developers
>
> David: Is there any update on parallelizing shp2pgsql?
>
> Devs (and David): Are there any plans to complement shp2pgsql with
> something like GeoPackage-to-PostGIS (gpkg2pgsql) ?
>
> I sometimes refer to vector GeoPackage as the "Shapefile of the
> future". Rémi's pointer to OGR is also valuable. But I'd expect that a
> standalone tool like gpkg2pgsql could eventually be easier to be
> realized and tuned.
>
> :Stefan
>
>
> 2015-02-18 17:37 GMT+01:00 Brent Wood <pcreso at pcreso.com>:
> > You might look at the capabilities of systems like Netezza & Teradata.
> They
> > have also adapted various tools around Postgres/Postgis to support
> > parallelisation.
> >
> > This comment on Netezza might be of interest:
> > http://geothought.blogspot.co.nz/2008/09/netezza-spatial.html
> >
> > Cheers
> >
> > Brent Wood
> >
> > ________________________________
> > From: David Haynes II <dahaynes at umn.edu>
> > To: PostGIS Development Discussion <postgis-devel at lists.osgeo.org>
> > Sent: Thursday, February 19, 2015 5:15 AM
> > Subject: Re: [postgis-devel] shp2pgsql
> >
> > Nothing published yet, but we are developing a working document.
> > Mostly we are testing this viability of spatial datasets and if a
> platform
> > supports complex spatial queries (i.e. vector raster overlay distributed
> > across a series of nodes). In addition we plan to conducting testing on
> tile
> > size and raster density in relation to these complex queries.
> >
> >
> >
> > On Wed, Feb 18, 2015 at 9:48 AM, Rémi Cura <remi.cura at gmail.com> wrote:
> >
> > Hey,
> > I find this research type very interesting.
> > Do you have something published about your experiment and test of various
> > cluster-postgres flavours?
> >
> > About loading geometry into your cluster, you may prefer to change OGR,
> > which can read a lot more formats
> > (and is however slower than postgis shp2pgsql).
> >
> > Cheers,
> > Rémi-C
> >
> > 2015-02-18 16:37 GMT+01:00 Stephen Woodbridge <woodbri at swoodbridge.com>:
> >
> > On 2/18/2015 10:21 AM, David Haynes II wrote:
> >
> > Hello,
> >
> > I am working on a project that conducts high performance spatial
> > analysis using postgresql and PostGIS. We have been searching for
> > platforms that allow PostGIS to run in parallel. We have evaluated
> > Postgres-xc and postgres-xl and determined that they do not meet our use
> > case. Currently, I am evaluating CitusDB, but there seem to be some
> > obstacles there as well. However, we are working on developing our own
> > platform using Stado, which is dervied from GridSQL.
> >
> > We have had some initial results that look pretty promising and we are
> > looking to modify the source code of the shp2pgsql to work with our new
> > platform. If someone could provide the location of the code we would
> > greatly appreciate it. Currently we are creating are geometries using
> > the ST_GeomFromTxt function.
> >
> >
> > http://trac.osgeo.org/postgis/browser/trunk/loader
> >
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
> >
> >
> >
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
> >
> >
> >
> >
> > --
> > David Haynes, Ph.D.
> > Research Associate Terra Populus
> > Minnesota Population Center
> > www.terrapop.org
> >
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
> >
> >
> >
> > _______________________________________________
> > postgis-devel mailing list
> > postgis-devel at lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-devel
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-devel




-- 
David Haynes, Ph.D.
Research Associate Terra Populus
Minnesota Population Center
612-626-3933
www.terrapop.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20160125/82caa0c9/attachment.html>