[postgis-users] pgsql2shp output truncated

Ben Madin ben at ausvet.com.au
Mon Dec 16 23:46:51 PST 2013


G’day all,

I’ve been using pgsql2shp to create shape files for a client by creating a table which contains global level 1 administrative boundaries (3670 records). When I connect to the db, I can see this many records and display the appropriate geometries. 

select ccode, admin1, mapcode, st_mem_size(geom), st_isvalidreason(geom) from polbnda2013 where ccode like 'ZWE' ORDER BY 1,2;
 ccode |       admin1        | mapcode | st_mem_size | st_isvalidreason 
-------+---------------------+---------+-------------+------------------
 ZWE   | BULAWAYO            |    3230 |        2496 | Valid Geometry
 ZWE   | HARARE              |    3231 |        3264 | Valid Geometry
 ZWE   | MANICALAND          |    3232 |      108992 | Valid Geometry
 ZWE   | MASHONALAND CENTRAL |    3233 |       63616 | Valid Geometry
 ZWE   | MASHONALAND EAST    |    3234 |       34080 | Valid Geometry
 ZWE   | MASHONALAND WEST    |    3235 |       24432 | Valid Geometry
 ZWE   | MASVINGO            |    3236 |       29840 | Valid Geometry
 ZWE   | MATABELELAND NORTH  |    3237 |       28832 | Valid Geometry
 ZWE   | MATABELELAND SOUTH  |    3238 |       69792 | Valid Geometry
 ZWE   | MIDLANDS            |    3239 |       31296 | Valid Geometry
(10 rows)


When I run 

pgsql2shp -b -p 5432 -f outputs/2013/polbnda2013 -g geom -u ben -P noway oiemaps outputs.polbnda2013 
Initializing... 
Done (postgis major version: 2).
Output shape: Polygon
Dumping: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX [3665 rows].


The five rows missing are the last five rows in the table (Zimbabwe…). 

Ahh you say - an error in the data for Zimbabwe! But, if I just export Zimbabwe :

pgsql2shp -b -r -p 5432 -f outputs/2013/polbnda2013 -g geom -u ben -P caitlin oiemaps "SELECT * FROM polbnda2013 WHERE ccode LIKE 'ZWE' ORDER BY ccode, admin1"
Initializing... 
Done (postgis major version: 2).
Output shape: Polygon
Dumping: X [10 rows].


Due to the resolution I’m looking at about a 130MB output file, so I won’t email it in here, but the batch processing is being done on an AWS EC2 server running Ubuntu 12.04LTS (This is the third server I have tried running it on)

 PostgreSQL 9.3.2 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 4.6.3-1ubuntu5) 4.6.3, 64-bit
 POSTGIS="2.1.0 r11822" GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.7.1, 23 September 2009" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8" LIBJSON="UNKNOWN" RASTER


Has anyone seen anything similar, any ideas where I can start. 

cheers

Ben




-- 

Ben Madin

t : +61 8 6102 5535
m : +61 448 887 220
e : ben at ausvet.com.au

AusVet Animal Health Services
Western Australia

AusVet's website:  http://www.ausvet.com.au

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this email are the opinion of the writer only and are not endorsed by AusVet Animal Health Services unless expressly stated otherwise. Although AusVet uses virus scanning software we do not accept liability for viruses or similar in any attachments. Thanks for reading.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131217/dfcb0f40/attachment.html>


More information about the postgis-users mailing list