Postgres Pro
Downloads
Home   >   mailing lists

Re: techniques for bulk load of spatial data - Mailing list pgsql-general

From Brent Wood
Subject Re: techniques for bulk load of spatial data
Date
Msg-id 4CF7542D0200007B00033D4A@gwia.niwa.co.nz
Whole thread Raw
In response to techniques for bulk load of spatial data  (Mario Corchero <mariocj89@gmail.com>)
List pgsql-general
Tree view


On 2010-11-30 14.29, Mario Corchero wrote:
> Hi, I'm a student of Computer Science,
> I know diffrents techniques of bulk load, but I need to know how
> specifically postgreSQL make a bulk load of spatial data, could anyone

If you are using spatial data in Postgres, this might usefully be addressesd to the Postgis list. Refer to http://www.postgis.org

When you say "bulk" loading of spatial data, is this hundreds of thousands or billions of records? Are you needing to include coordinate system/projection info?

Have you looked at ogr2ogr or shp2pgsql, or SPIT in QGIS, all of which can lod data into PostGIS, depending on how big a bulk you are talking about.

If your spatial data is available in Postgis WKB format, you could generate a file to use with Postgres copy command?


Regards,

  Brent Wood




Brent Wood
DBA/GIS consultant
NIWA, Wellington
New Zealand


Please consider the environment before printing this email.

NIWA is the trading name of the National Institute of Water & Atmospheric Research Ltd.

pgsql-general by date:

Previous
From: "Jolles, Peter M (GE Energy)"
Date:
Subject: Re: Cannot start Postgres- FATAL: invalid cache id: 19
Next
From: Vick Khera
Date:
Subject: Re: Cannot start Postgres- FATAL: invalid cache id: 19