[postgis-users] Loading only polygon with shp2pgsql

Matt Lynch matt at terraEngine.com
Tue Sep 23 10:29:46 PDT 2003


Hi strk,

Thanks, that looks like exactly what I need!
I found it at
http://postgis.refractions.net/pipermail/postgis-users/2003-May/002477.h
tml.

Matt

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of strk
Sent: Tuesday, September 23, 2003 10:07 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Loading only polygon with shp2pgsql


Hi matt,
Some time ago I posted a patch to make shp2pgsql work whitout
accompaining 
DBF. Might be used for your case.Search the archives for this subect:

	Subject: [postgis-users] [PATCH] shp2pgsql without DBF

--strk;


matt wrote:
> Hi Randy,
> 
> I have been a little skimpy on describing what I am doing, so here 
> goes.
> 
> I have an application which will allow users access to shape and 
> raster data for a defined region.  The region is specified by a
polygon.
> 
> I am now writing a web app to handle the administration side.  In the 
> web app I allow administrators to upload shape files which then are 
> loaded into a table.  My problem is that I don't want to trust the 
> administrators to not include attributes in the shape file.  I 
> anticipate the temptation to use existing shape files will be too 
> great. So I would like to somehow extract only the polygon.
> 
> Thanks,
> 
> Matt
> 
> 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of 
> Randy James
> Sent: Monday, September 22, 2003 11:18 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Loading only polygon with shp2pgsql
> 
> 
> Hi
> 
> I would make your polygons a file without any attributes in its table 
> and than use join to attach your attributes from another table. But 
> i'm not sure if thats what you are looking for.
> 
> Cheers
> Randy
> 
> --- Matt Lynch <matt at terraEngine.com> wrote:
> > Hi,
> > 
> > I am wondering if there is a way for me to load the
> > polygon information
> > from a shape file only (i.e. without attribute data)?
> > 
> > I am currently using shp2pgsql with -a to append to a table, but 
> > want to avoid problems if I append a shape file with a new
> > attribute associated.
> > 
> > Thanks,
> > 
> > Matt
> > 
> > ---
> > Outgoing mail is certified Virus Free.
> > Checked by AVG anti-virus system
> > (http://www.grisoft.com).
> > Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
> >  
> > 
> > 
> > 
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> >
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software 
> http://sitebuilder.yahoo.com
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
>  
> 
> 
> 
> _______________________________________________
> postgis-users mailing list postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003
 





More information about the postgis-users mailing list