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 <cliff...@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
--@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: si...@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
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
