Vector Format Conversion Using ogr2ogr - Revision history

Ellis Symons: /* Convert Single Layer To/From GPKG */

2022-07-07T11:27:10Z

Convert Single Layer To/From GPKG

← Older revision		Revision as of 21:27, 7 July 2022
Line 28:		Line 28:
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" 2d_code_M01_R.shp all_layers.gpkg</pre>		<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>		'''Convert Single Layer From GPKG and convert the layer type'''<br>
⚫	<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 <b><u>[https://gdal.org/programs/ogr2ogr.html#ogr2ogr gdal ogr2ogr documention]</u></b> for other options.		:* ''<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>
	'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>		'''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>		<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>		'''Convert Single SHP Into a New GPKG Where Layer Name is Different From Database Name'''<br>

Ellis Symons: /* Convert Single Layer To/From GPKG */

2022-07-07T11:25:53Z

Convert Single Layer To/From GPKG

← Older revision		Revision as of 21:25, 7 July 2022
Line 29:		Line 29:
	'''Convert Single Layer From GPKG and convert the layer type'''<br>		'''Convert Single Layer From GPKG and convert the layer type'''<br>
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt POLYGON 2d_code_M01_R.shp all_layers.gpkg</pre>		<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.		:* ''<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.
	'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>		'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>
	<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>		<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>

Ellis Symons: /* Convert Single Layer To/From GPKG */

2022-07-07T11:25:17Z

Convert Single Layer To/From GPKG

← Older revision		Revision as of 21:25, 7 July 2022
Line 29:		Line 29:
	'''Convert Single Layer From GPKG and convert the layer type'''<br>		'''Convert Single Layer From GPKG and convert the layer type'''<br>
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt POLYGON 2d_code_M01_R.shp all_layers.gpkg</pre>		<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>		'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>
	<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>		<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>

Ellis Symons: /* Convert Single Layer To/From GPKG */

2022-07-07T11:21:54Z

Convert Single Layer To/From GPKG

← Older revision		Revision as of 21:21, 7 July 2022
Line 28:		Line 28:
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" 2d_code_M01_R.shp all_layers.gpkg</pre>		<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>		'''Convert Single Layer From GPKG and convert the layer type'''<br>
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt [POLYGON~~\|LINESTRING\|POINT]~~ 2d_code_M01_R.shp all_layers.gpkg</pre>		<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt POLYGON 2d_code_M01_R.shp all_layers.gpkg</pre>
	'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>		'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt [POLYGON~~\|LINESTRING\|POINT]~~ -explodecollections 2d_code_M01_R.shp all_layers.gpkg</pre>		<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>		'''Convert Single SHP Into a New GPKG Where Layer Name is Different From Database Name'''<br>
	:* ''<tt>-nln <layername></tt>'': assigns the name of the layer within database		:* ''<tt>-nln <layername></tt>'': assigns the name of the layer within database

Ellis Symons: /* Convert Single Layer To/From GPKG */

2022-07-07T11:21:13Z

Convert Single Layer To/From GPKG

← Older revision		Revision as of 21:21, 7 July 2022
Line 27:		Line 27:
	'''Convert Single Layer From GPKG''' - ''Uses an SQL statement to select all features from a given layer''<Br>		'''Convert Single Layer From GPKG''' - ''Uses an SQL statement to select all features from a given layer''<Br>
	<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" 2d_code_M01_R.shp all_layers.gpkg</pre>		<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>
			<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt [POLYGON\|LINESTRING\|POINT] 2d_code_M01_R.shp all_layers.gpkg</pre>
			'''Convert Single Layer From GPKG and convert the layer type and convert multipart geometries to singlepart'''<br>
			<pre>ogr2ogr.exe -f "ESRI Shapefile" -sql "SELECT * FROM '2d_code_M01_R'" -nlt [POLYGON\|LINESTRING\|POINT] -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>		'''Convert Single SHP Into a New GPKG Where Layer Name is Different From Database Name'''<br>
	:* ''<tt>-nln <layername></tt>'': assigns the name of the layer within database		:* ''<tt>-nln <layername></tt>'': assigns the name of the layer within database

Ellis Symons: /* Converting MIF File With Multiple Geometry Types */

2022-05-31T12:03:30Z

Converting MIF File With Multiple Geometry Types

← Older revision		Revision as of 22:03, 31 May 2022
Line 39:		Line 39:
	:* ''<tt>-where <clause></tt>'': "-where" can be used to specify a clause to only select a given geometry type		:* ''<tt>-where <clause></tt>'': "-where" can be used to specify a clause to only select a given geometry type
	<pre>		<pre>
	ogr2ogr.exe -f "ESRI Shapefile" -where ""OGR_GEOMETRY='Point'" 2d_zsh_P.shp 2d_zsh.mif		ogr2ogr.exe -f "ESRI Shapefile" -where "OGR_GEOMETRY='Point'" 2d_zsh_P.shp 2d_zsh.mif
	ogr2ogr.exe -f "ESRI Shapefile" -where ""OGR_GEOMETRY='LineString'" 2d_zsh_L.shp 2d_zsh.mif		ogr2ogr.exe -f "ESRI Shapefile" -where "OGR_GEOMETRY='LineString'" 2d_zsh_L.shp 2d_zsh.mif
	ogr2ogr.exe -f "ESRI Shapefile" -where ""OGR_GEOMETRY='Polygon'" 2d_zsh_R.shp 2d_zsh.mif		ogr2ogr.exe -f "ESRI Shapefile" -where "OGR_GEOMETRY='Polygon'" 2d_zsh_R.shp 2d_zsh.mif
	</pre>		</pre>
	'''MIF With Multiple Geometry Types To a Single GPKG'''<Br>		'''MIF With Multiple Geometry Types To a Single GPKG'''<Br>

Ellis Symons: /* Converting MIF File With Multiple Geometry Types */

2022-05-31T12:03:17Z

Converting MIF File With Multiple Geometry Types

← Older revision		Revision as of 22:03, 31 May 2022
Line 46:		Line 46:
	:* ''<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.		:* ''<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>		<pre>
	ogr2ogr.exe -f GPKG -nln 2d_zsh_P -where ""OGR_GEOMETRY='Point'" -nlt POINT 2d_zsh.gpkg 2d_zsh.mif		ogr2ogr.exe -f GPKG -nln 2d_zsh_P -where "OGR_GEOMETRY='Point'" -nlt POINT 2d_zsh.gpkg 2d_zsh.mif
	ogr2ogr.exe -f GPKG -nln 2d_zsh_L -where ""OGR_GEOMETRY='LineString'" -nlt LINESTRING -append 2d_zsh.gpkg 2d_zsh.mif		ogr2ogr.exe -f GPKG -nln 2d_zsh_L -where "OGR_GEOMETRY='LineString'" -nlt LINESTRING -append 2d_zsh.gpkg 2d_zsh.mif
	ogr2ogr.exe -f GPKG -nln 2d_zsh_R -where ""OGR_GEOMETRY='Polygon'" -nlt POLYGON -append 2d_zsh.gpkg 2d_zsh.mif		ogr2ogr.exe -f GPKG -nln 2d_zsh_R -where "OGR_GEOMETRY='Polygon'" -nlt POLYGON -append 2d_zsh.gpkg 2d_zsh.mif
	</pre>		</pre>
	<br>		<br>

Ellis Symons at 15:16, 11 April 2022

2022-04-11T15:16:07Z

← Older revision		Revision as of 01:16, 12 April 2022
Line 50:		Line 50:
	ogr2ogr.exe -f GPKG -nln 2d_zsh_R -where ""OGR_GEOMETRY='Polygon'" -nlt POLYGON -append 2d_zsh.gpkg 2d_zsh.mif		ogr2ogr.exe -f GPKG -nln 2d_zsh_R -where ""OGR_GEOMETRY='Polygon'" -nlt POLYGON -append 2d_zsh.gpkg 2d_zsh.mif
	</pre>		</pre>
			<br>
			{{Tips Navigation
			\|uplink=[[GDAL_Tips_and_Tricks#GDAL_Programs\| Back to GDAL Tips and Tricks]]
			}}

Ellis Symons at 11:29, 11 April 2022

2022-04-11T11:29:39Z

← Older revision		Revision as of 21:29, 11 April 2022
Line 16:		Line 16:
	==Bulk Format Conversion==		==Bulk Format Conversion==
	<Br>		<Br>
	'''Convert All Files Within Folder to GPKG'''<br>		'''Convert All Files Within Folder to a Single GPKG'''<br>
	<pre>ogr2ogr.exe -f GPKG all_layers.gpkg ./path/to/dir</pre>		<pre>ogr2ogr.exe -f GPKG all_layers.gpkg ./path/to/dir</pre>
	'''Convert All Files Within Folder to GPKG with Wildcard'''<br>		'''Convert All Files Within Folder to a Single GPKG with Wildcard'''<br>
	<pre>ogr2ogr.exe -f GPKG all_layers.gpkg ./path/to/dir/*.shp</pre>		<pre>ogr2ogr.exe -f GPKG all_layers.gpkg ./path/to/dir/*.shp</pre>
	'''Convert All Files From a GPKG to a SHP'''<br>		'''Convert All Files From a GPKG to a SHP'''<br>

Ellis Symons at 11:23, 11 April 2022

2022-04-11T11:23:34Z

← Older revision		Revision as of 21:23, 11 April 2022
Line 44:		Line 44:
	</pre>		</pre>
	'''MIF With Multiple Geometry Types To a Single GPKG'''<Br>		'''MIF With Multiple Geometry Types To a Single GPKG'''<Br>
	:* ''<tt>-nlt <geometry_type></tt>'': Defines geometry type for 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.		:* ''<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>		<pre>
	ogr2ogr.exe -f GPKG -nln 2d_zsh_P -where ""OGR_GEOMETRY='Point'" -nlt POINT 2d_zsh.gpkg 2d_zsh.mif		ogr2ogr.exe -f GPKG -nln 2d_zsh_P -where ""OGR_GEOMETRY='Point'" -nlt POINT 2d_zsh.gpkg 2d_zsh.mif