| From: | "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz> |
|---|---|
| To: | <mariocj89(at)gmail(dot)com> |
| Cc: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: techniques for bulk load of spatial data |
| Date: | 2010-12-01 19:09:17 |
| Message-ID: | 4CF7542D0200007B00033D4A@gwia.niwa.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vick Khera | 2010-12-01 19:14:39 | Re: Cannot start Postgres- FATAL: invalid cache id: 19 |
| Previous Message | Jolles, Peter M (GE Energy) | 2010-12-01 18:58:41 | Re: Cannot start Postgres- FATAL: invalid cache id: 19 |