<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="IncrediMail 1.0" name=GENERATOR></HEAD>
<BODY style="BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px 10px 10px; FONT-FAMILY: Arial" bgColor=#ffffff background="" scroll=yes ORGYPOS="0">
<TABLE id=INCREDIMAINTABLE cellSpacing=0 cellPadding=2 width="100%" border=0>
<TBODY>
<TR>
<TD id=INCREDITEXTREGION style="FONT-SIZE: 12pt; CURSOR: auto; FONT-FAMILY: Arial" width="100%">
<DIV>Yes there is a utility to do that.</DIV>
<DIV> </DIV>
<DIV>It is on the contrib directory contrib of source Postgresql. The instalation is on the folder you found it. Look for it.</DIV>
<DIV> </DIV>
<DIV>I didn't try to compile this utility but if you have sucess please tell me.</DIV>
<DIV> </DIV>
<DIV>Best regards</DIV>
<DIV>Ezequias Rodrigues da Rocha</DIV>
<DIV> </DIV>
<DIV id=IncrediOriginalMessage><I>-------Mensagem original-------</I></DIV>
<DIV> </DIV>
<DIV id=receivestrings>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>De:</B></I> <A href="mailto:strk@refractions.net">strk@refractions.net</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Data:</B></I> 05/26/05 17:53:44</DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Para:</B></I> <A href="mailto:postgis-users@postgis.refractions.net">PostGIS Users Discussion</A></DIV>
<DIV dir=ltr style="FONT-SIZE: 11pt"><I><B>Assunto:</B></I> Re: [postgis-users] dbf2pgsql type utility</DIV></DIV>
<DIV> </DIV>
<DIV>On Thu, May 26, 2005 at 04:31:00PM -0400, Kralidis,Tom [Burlington] wrote:</DIV>
<DIV>></DIV>
<DIV>> > > Hi,</DIV>
<DIV>> > ></DIV>
<DIV>> > > I have some pure attribute data which I will join to</DIV>
<DIV>> > spatial tables in</DIV>
<DIV>> > > PostGIS. They are formatted as .dbf files.</DIV>
<DIV>> > ></DIV>
<DIV>> > > Is there a dbf2pgsql type utility to do this? Or will I have to</DIV>
<DIV>> > > resort to Perl and roll my own?</DIV>
<DIV>> ></DIV>
<DIV>> > What about patching shp2pgsql instead ?</DIV>
<DIV>> ></DIV>
<DIV>></DIV>
<DIV>> I'd love to. However that won't work for my this Tuesday deliverable.</DIV>
<DIV>> At any rate, what (at a high level) would be involved in patching</DIV>
<DIV>> shp2pgsql.c to do this? I could see this being extended via a "-t" flag</DIV>
<DIV>> which means "just insert the .dbf table".</DIV>
<DIV>></DIV>
<DIV>> In the short-term, if anyone has any ideas, that would be much</DIV>
<DIV>> appreciated.</DIV>
<DIV> </DIV>
<DIV>I'd use no flags, allowing use of what's available (shp only / dbf only).</DIV>
<DIV>You should handle the failures in OpenShape and somehow notify absence</DIV>
<DIV>of either shape or dbf file still counting number of rows.</DIV>
<DIV> </DIV>
<DIV>--strk;</DIV>
<DIV> </DIV>
<DIV>></DIV>
<DIV>> ..Tom</DIV>
<DIV>> _______________________________________________</DIV>
<DIV>> postgis-users mailing list</DIV>
<DIV>> <A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV>
<DIV>> <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV>
<DIV>_______________________________________________</DIV>
<DIV>postgis-users mailing list</DIV>
<DIV><A href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A></DIV>
<DIV><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A></DIV></TD></TR>
<TR>
<TD id=INCREDIFOOTER width="100%">
<TABLE cellSpacing=0 cellPadding=0 width="100%">
<TBODY>
<TR>
<TD width="100%"></TD>
<TD id=INCREDISOUND vAlign=bottom align=middle></TD>
<TD id=INCREDIANIM vAlign=bottom align=middle></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE><SPAN id=IncrediStamp><SPAN dir=ltr><A href="http://www.incredimail.com/index.asp?id=54760"><IMG alt="Add FUN to your email - CLICK HERE!" hspace=0 src="http://www2.incredimail.com/contents/stamps/imstp_emo_pt.gif" align=baseline border=0></A></SPAN></SPAN></BODY></HTML>