[postgis-users] load more than one shape files to one table?

Thomas Zuberbuehler tzuberbuehler at datacomm.ch
Mon Nov 13 11:14:26 PST 2006


steve,

thank you. but i think my problem exists further. a route consists
more than one segment. this segments form a route. if i load a route
with shp2pgsql, as you suggest, i am going in disorder, not? then i
can't differentiate the route, can i?

thank you.
thomas

2006/11/13, Stephen Woodbridge <woodbri at swoodbridge.com>:
> Thomas Zuberbuehler wrote:
> > hello
> >
> > i have more than 150 shape files with routes (every one contains one
> > route). can i load this files to postgis and *only* one table which
> > contains all routes? there could be a problem: a shape file contains
> > more than one multilines.
> >
> > shapefile type: arc
> > postgis type: multilinestring[2]
> >
> > someone has an idea?
>
> shp2pgsql has an option to create just the table.
>
> To run it once to create the table, then run it 150 times for your
> shapefiles but don't have it do the table create.
>
> -Steve
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Thomas Zuberbuehler
http://www.zubi.li



More information about the postgis-users mailing list