[Geomoose-users] mapfile shp2img error

[Dan Little]

I'd suggest a few things:
1) Remove the "src=...." from the mapfile.  Reprojection is done with the PROJECTION directives.
2) Then use st_setsrid (http://postgis.refractions.net/documentation/manual-svn/ST_SetSRID.html)
update table_name
set wkb_geometry = st_setsrid(wkb_geometry, 999999) -- Where "999999" is the appropriate SRID for your projection.




----- Original Message ----
> From: t faustino <geomatrix3d at gmail.com>
> To: geomoose-users at lists.sourceforge.net
> Sent: Wed, November 18, 2009 6:57:04 PM
> Subject: [Geomoose-users] mapfile shp2img error
> 
> I know that this is more of a mapserver issue but I've been searching
> and can't find a solution. Was hoping someone has come across this
> that can point me in the right direction:
> 
> my shp2img error:
> 
> error- 2 geometeries with different SRIDs
> 
> My mapfile:
> 
> CONNECTION postgis
> DATA dbname=whatever password=whatever etc etc...........using unqiue
> srid=26967'
> 
> I guess what confuses me most is my postgres tables are set using epsg
> 2240 (NAD83 Georgia West FIPS 1002)
> 
> Having my mapfile point directly to the shapefiles load correctly
> without error but I want to use postgres with postgis.
> 
> Anyone with mapfile samples using postgres/postgis that can help?
> -- 
> "If one advances confidently in the direction of his dreams, and
> endeavors to live the life which he has imagined, he will meet with a
> success unexpected in common hours."  ~Thoreau
> 
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geomoose-users