[postgis-users] Importing shapefiles with srid != -1 [SOLVED]

[James Dominy]

Obe, Regina wrote:
>  
> James,
> 
> If you do a combined create table (and append) do you get the same error
> - might also help to create an intermediate file so 
> you can inspect it for strange stuff.  - e.g.
> 
> shp2pgsql -s 4326 -g gisdata provinces.shp prov2 > prov2.sql
> 
> psql psql -h myserver -d mydb -U myuser -f prov2.sql
> 
> What OS are you running?
> Which version of shp2pgsql (which you can see at the top of the screen
> by calling shp2pgsql without args), 
> postgis version?  which you get by doing a SELECT
> postgis_full_version();
> 
> Hope that helps,
> Regina
Ahh, thanks for the suggestions. It was an error in my PHP code, long and 
convoluted to explain. But once I got the PHP code actually producing the 
correct SRID in the modified insertion statements, it all came together. 
Clearly, quotes make a difference ;)

Cheers,
James