<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16481" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>I apologize for this
cross-posting, but wasn't quite sure which list would be
best.</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>I converted a query
from PostGIS to MapInfo for one of our GIS specialists here, and
apparently all the fields came out as varchar(254) and when they try to resave
the file in MapInfo - it doesn't allow them to (I forget the error). Aside
from that, reading the file seems fine and you can see the features. If I
do the same but to shape format, then the fields have the correct field sizes
and everything.</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>Is there something I
am doing wrong here or is this just a limitation of the Ogr Mapinfo
driver?</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>My command is
below</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>ogr2ogr -f "MapInfo
File" -a_srs "EPSG:2249" update PG:"host=zdnd1 dbname=dnddts" -sql "SELECT pid,
cm_id, st_num, st_name, name_suf, unit_num, zipcode, ptype, lu, exmpt_code,
ownocc, "owner", address, city_state, mail_zip,landval, bldgval, totalval,
gross_tax, legal_area, year_built, year_remod, gross_area, area, num_floors,
"class", r_bldg_stl, r_roof_typ,r_ext_fin, total__rms, r_bdrms, r_full_bth,
r_half_bth, r_kitch, r_heat_typ, r_ac, r_fplace, s_num_bldg, s_bldg_sty,
s_unit_res, s_unit_com, s_unit_rc, s_ext_fin, u_base_flr, u_num_prk, u_corner,
u_orient, u_num_rms, u_num_beds, u_bths, u_half_bth, u_kitch, u_heat, u_ac,
u_fplaces,xcoord,ycoord , the_geom FROM parceltime where pid_year = '2007'" -nln
"UPDATE"</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>Please don't ask why
the output table is called UPDATE. It just is for legacy reasons and
wasn't a name I chose.</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial size=2>I'm using FWTools
1.3.1.</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2>Regina</FONT></SPAN></DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=930045512-15102007><FONT face=Arial
size=2></FONT></SPAN> </DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>