Re: [mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread Flavio Carmo
Hi, Sorry, but i cant upload the shapes to postgres. The shapefiles are modified using arcview and the data in the postgres is modified using a custom desktop software that my client uses for about 5 years. The software open the shapefiles, then using a ODBC connection with postgres, make the

RE: [mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread Fawcett, David (MPCA)
[mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Flavio Carmo Sent: Monday, November 29, 2010 1:49 PM To: Stephen Woodbridge Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Re: Join from SHP file to PostgreSQL table Hi, Sorry, but i cant upload the shapes to postgres

Re: [mapserver-users] Re: Join from SHP file to PostgreSQL table

2010-11-29 Thread Brent Fraser
Flavio, I'm currently experimenting with joining a shapefile to a MS Access file using OGR and ODBC (and stock mapserver v 5.2.1 from MS4W). Works ok: CONNECTIONTYPE OGR CONNECTION 'G:/GeoData/Parcels/Alberta/t_505033.shp' DATA SELECT * FROM t_505033 LEFT JOIN