On 29/09/11 15:01, Andy Colson wrote:
Hey Mark, I may have guessed wrong. I got a response from the gdal folk,
who said "the null values for Date in this dbf file were indicated by a
string filled with spaces".
Would still be neet if something could be done so shp2pgsql could import
this. The shapefile is 16 Meg, and uncompresses to 157 Meg, you can get
it here:
http://squeakycode.net/parcelAnnoV2.zip
Version: is this what you are looking for?
RCSID: $Id: shp2pgsql-core.h 5983 2010-09-19 11:27:05Z mcayland $
RELEASE: 1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
-Andy
Hi Andy,
Thanks for the example, but I don't appear to be able to recreate this here:
pg90@zeno:~/datasets$ shp2pgsql ParcelAnnoV2 > test.sql
pg90@zeno:~/datasets$ psql -d postgis15 -f test.sql
postgis15=# \d parcelannov2
Table "public.parcelannov2"
Column | Type |
Modifiers
------------+------------------------+------------------------------------------------------------
gid | integer | not null default
nextval('parcelannov2_gid_seq'::regclass)
textstring | character varying(254) |
fontname | character varying(254) |
fontsize | numeric |
bold | smallint |
italic | smallint |
underline | smallint |
verticalal | smallint |
horizontal | smallint |
xoffset | numeric |
yoffset | numeric |
angle | numeric |
fontleadin | numeric |
wordspacin | numeric |
characterw | numeric |
characters | numeric |
flipangle | numeric |
override | integer |
featype | smallint |
bptype | smallint |
book | integer |
page | integer |
recorded | date |
taskid | integer |
the_geom | geometry |
Indexes:
"parcelannov2_pkey" PRIMARY KEY, btree (gid)
Check constraints:
"enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2)
"enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL)
"enforce_srid_the_geom" CHECK (st_srid(the_geom) = (-1))
postgis15=# select * from parcelannov2 where gid = 1;
gid | textstring | fontname | fontsize | bold | italic |
underline | verticalal | horizontal | xoffset | yoffset |
angle | fontleadin | wordspacin | characterw |
characters | flipangle | override | featype | bptype | book |
page | recorded | taskid | the_geom
-----+------------+----------+---------------+------+--------+-----------+------------+------------+---------------+---------------+---------------+---------------+---------------+---------------+
---------------+---------------+----------+---------+--------+------+------+----------+--------+----------
1 | | | 0.00000000000 | 0 | 0 |
0 | 0 | 0 | 0.00000000000 | 0.00000000000 |
0.00000000000 | 0.00000000000 | 0.00000000000 | 0.00000000000 |
0.00000000000 | 0.00000000000 | 0 | 20 | 20 | 0 |
0 | | 0 |
(1 row)
postgis15=# select * from parcelannov2 where gid = 1 and recorded is null;
gid | textstring | fontname | fontsize | bold | italic |
underline | verticalal | horizontal | xoffset | yoffset |
angle | fontleadin | wordspacin | characterw |
characters | flipangle | override | featype | bptype | book |
page | recorded | taskid | the_geom
-----+------------+----------+---------------+------+--------+-----------+------------+------------+---------------+---------------+---------------+---------------+---------------+---------------+
---------------+---------------+----------+---------+--------+------+------+----------+--------+----------
1 | | | 0.00000000000 | 0 | 0 |
0 | 0 | 0 | 0.00000000000 | 0.00000000000 |
0.00000000000 | 0.00000000000 | 0.00000000000 | 0.00000000000 |
0.00000000000 | 0.00000000000 | 0 | 20 | 20 | 0 |
0 | | 0 |
(1 row)
That seems to indicate that the recorded date field is set to NULL as
intended? This is using the current 1.5 branch HEAD.
ATB,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
