Vector Format Conversion Using ogr2ogr: Difference between revisions

Content deleted Content added
 
(2 intermediate revisions by one other user not shown)
Line 28:
<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" 2d_code_M01_R.shp all_layers.gpkg</pre>
'''Convert Single Layer From GPKG and convert the layer type'''<br>
:* ''<tt>-nlt <geometry type></tt>'': assigns the geometry type of the output layer - typical values [POLYGON | LINESTRING | POINT]. See <b><u>[https://gdal.org/programs/ogr2ogr.html#ogr2ogr gdal ogr2ogr documention]</u></b> for other options.
<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt POLYGON 2d_code_M01_R.shp all_layers.gpkg</pre>
:* ''<tt>-nlt <geometry type></tt>'': assigns the geometry type of the output layer - typical values [POLYGON | LINESTRING | POINT]. See [https://gdal.org/programs/ogr2ogr.html#ogr2ogr gdal ogr2ogr documention] for other options.
'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>
:* ''<tt>-explodecollections</tt>'': splits multipart geometries into individual features.
<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt POLYGON -explodecollections 2d_code_M01_R.shp all_layers.gpkg</pre>
'''Convert Single SHP Into a New GPKG Where Layer Name is Different From Database Name'''<br>
Line 49 ⟶ 50:
</pre>
'''MIF With Multiple Geometry Types To a Single GPKG'''<Br>
:* ''<tt>-nlt <geometry_type></tt>'': Defines the geometry type for the output layer. Useful when converting to formats that implement strict checks for geometry types (e.g. Don't allow "Singlepart" geometry and "Multipart" geometry in the same layer).
<pre>
ogr2ogr.exe -f GPKG -nln 2d_zsh_P -where "OGR_GEOMETRY='Point'" -nlt POINT 2d_zsh.gpkg 2d_zsh.mif