[postgis-users] Multicurve

[Simon Greener]

Can you convert the data into WKT?

If so, create a CSV file with the WKT in a single column eg WKT (other attributes in other fields)

Then add a wkt column to the target table:

alter table <target> add column wkt text;

eg
create table foo (id serial, geom geometry);
alter table foo add column wkt text;

Then use COPY to load from the CSV into the table writing the WKT to your WKT column.

Then execute UPDATE to populate the geom column and drop the WKT column.
Or, don't create a wkt column but create a before insert trigger to create the geom from the wkt.

regards
Simon
On Sat, 12 Jan 2019 08:13:44 +1100, Clifford Snow <clifford at snowandsnow.us> wrote:

> Lately some of the data from local governments contain road data with multicurve geometry. Attempting to load with shp2pgsql fails.
> I've been using ogr2ogr with the -nlt option to specify MULTILINESTRING.
> Is there any better work arounds? According to PostGIS, it does support multicurve geometries.
> Thanks in advance,
> Clifford
>
> -- at osm_seattle
> osm_seattle.snowandsnow.us
> OpenStreetMap: Maps with a human touch



-- 
Regards
Simon
--------------------------------------------------------------------------------------------------------
Spatial Advice & Solutions Architecture
Database Spatial Stored Procedure Designer
Oracle Spatial, SQL Server, PostGIS, MySQL, ArcSDE FME
Awarded "2011 Oracle Spatial Excellence Award for Education and Research"
A: 39 Cliff View Drive, Allens Rivulet, 7150, Tas, Aust
W: www.spdba.com.au
E: simon at spdba.com.au
V: +61 362 396 397
M: +61 418 396 391
GITC Supplier: T1005
Skype: sggreener
Long: 147.20515 (147° 12' 18" E)
Lat: -43.01530 (43° 00' 55" S)
GeoHash: r22em9r98wg
NAC:W80CK 7SWP3
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190113/b64c33eb/attachment.html>