[postgis-users] Geography/geometry

[Simon Greener]

Thanks.

I couldn't see how this would help as this is structural not mathematical.

But I am trying to bring the parts back together.


S
On Tue, 22 Jan 2019 10:01:36 +1100, Martin Davis <mtnclimb at gmail.com> wrote:

> Could the problem be the use of the ogr2ogr option -nlt POLYGON ?  Some of the input geometries are multipolygons, and it sounds like the way to >handle this with ogr2ogr is to use GEOMETRY or PROMOTE_TO_MULTI [1][2]
>
> [1] https://www.gdal.org/ogr2ogr.html
> [2] https://gis.stackexchange.com/a/195223
>
> On Mon, Jan 21, 2019 at 1:00 PM Simon Greener <simon at spatialdbadvisor.com> wrote:
>> The shapefile (from OSM) can be accessed here:
>>
>> https://www.dropbox.com/s/jbptp3ycmc8cqzi/gis_osm_county_a_free_1.rar?dl=0
>>
>> The command used to load is:
>>
>> ogr2ogr -overwrite -progress -skipfailures -a_srs "EPSG:4326" ^
>>  -f "PostgreSQL" PG:"dbname='gisdb' host='localhost' port='5432' user='postgres'  ^
>>  gis_osm_county_a_free_1.shp -nln data.osm_county -nlt POLYGON ^
>> -lco LAUNDER=YES -lco GEOMETRY_NAME=geog4326 -lco GEOM_TYPE=geography -lco FID=ID -lco DIM=2 -lco SPATIAL_INDEX=YES
>> Am I missing something with the ogr2ogr command for the load?
>>
>>



-- 
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/20190122/603b836c/attachment.html>