[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Res: Re: [postgis-users] dbf2pgsql type utility
From: "Ezequias Rodrigues da Rocha" <ezequias () recife ! pe ! gov ! br>
Date: 2005-05-30 20:15:06
Message-ID: 429B744A.000001.03532 () DC_EZEQUIAS
[Download RAW message or body]
Yes there is a utility to do that.
It is on the contrib directory contrib of source Postgresql. The instalation
is on the folder you found it. Look for it.
I didn't try to compile this utility but if you have sucess please tell me.
Best regards
Ezequias Rodrigues da Rocha
-------Mensagem original-------
De: strk@refractions.net
Data: 05/26/05 17:53:44
Para: PostGIS Users Discussion
Assunto: Re: [postgis-users] dbf2pgsql type utility
On Thu, May 26, 2005 at 04:31:00PM -0400, Kralidis,Tom [Burlington] wrote:
>
> > > Hi,
> > >
> > > I have some pure attribute data which I will join to
> > spatial tables in
> > > PostGIS. They are formatted as .dbf files.
> > >
> > > Is there a dbf2pgsql type utility to do this? Or will I have to
> > > resort to Perl and roll my own?
> >
> > What about patching shp2pgsql instead ?
> >
>
> I'd love to. However that won't work for my this Tuesday deliverable.
> At any rate, what (at a high level) would be involved in patching
> shp2pgsql.c to do this? I could see this being extended via a "-t" flag
> which means "just insert the .dbf table".
>
> In the short-term, if anyone has any ideas, that would be much
> appreciated.
I'd use no flags, allowing use of what's available (shp only / dbf only).
You should handle the failures in OpenShape and somehow notify absence
of either shape or dbf file still counting number of rows.
--strk;
>
> ..Tom
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[Attachment #3 (Text/HTML)]
<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>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic