3
It seems to work with this syntax
ogrinfo wfs:https://www.mercator.vlaanderen.be/raadpleegdienstenmercatorpubliek/wfs anb_insp:PS.ProtectedSite-birds
INFO: Open of `wfs:https://www.mercator.vlaanderen.be/raadpleegdienstenmercatorpubliek/wfs'
using driver `WFS' successful.
Metadata:
ABSTRACT=Publieke Download Service van Mercator
PROVIDER_NAME=...
2
You need to separate
the "page" name from the parameters with a ? instead of a &
ogrinfo -al -so "https://www.mercator.vlaanderen.be/raadpleegdienstenmercatorpubliek/wfs?version=2.0.0&request=GetFeature&typeName=anb_insp:PS.ProtectedSite-birds&srsName=EPSG:31370"
ERROR 6: Update from remote service not supported
Had to open data source read-...
1
The problem is not in encoding.
The problem is in the data because it seems that in some row of your table there is a value "20A" in a field that it defined to be of type integer. GDAL is telling that it can't save string '20A' as integer into shapefile so it saves just the number part "20".
GeoPackage is a SQLite database and for SQLite it is not a ...
1
You will need to refresh your path somehow, sometimes running rehash will do it, alternatively log off and log on again will work.
1
Ok so I figured it out while looking up metadata for @Ian Turton (Comments section). He was right, it's the elevation.
Number 38 in the dxf specification refers to the elevation.
Extract:
38 DXF: entity's elevation if nonzero
Source : https://images.autodesk.com/adsk/files/autocad_2012_pdf_dxf-reference_enu.pdf
1
Try the following.
ogr2ogr --debug ON -sql "select top 100 * from table" -f "GPKG" -a_srs "EPSG:4269" test123.gpkg MSSQL:database=dbname;server=servername;trusted_connection=yes;GeometryFormat=native -nln nameinpackage
NOTE:
table not dbo.table in the sql query -> i have had issues when using prefixes randomly
trusted_connection=yes can be replaced with ...
1
ogr2ogr MSSQL Driver wants to read\create geometry_columns metadata table in you mssql database.
You can create table geometry_columns and add record for your table to it.
OR
You can set config parameter MSSQLSPATIAL_USE_GEOMETRY_COLUMNS to NO
ogr2ogr --config MSSQLSPATIAL_USE_GEOMETRY_COLUMNS NO -f GPKG test.gpkg MSSQL:database=somedb;server=somesrv;...
1
I guessed the SRS to EPSG:25832 (UTM 32N) by looking at the DXF file with QGIS.
With ogr2ogr:
ogr2ogr -f GeoJSON umweltzone.geojson Umweltzone-Neu-Ulm.dxf -limit 1 -s_srs EPSG:25832 -t_srs EPSG:4326
-f GeoJSON output format
umweltzone.geojson output file name
Umweltzone-Neu-Ulm.dxf input file name
-limit 1 output only one ...
1
From @ThingumaBob comment:
alias your PK column AS fid: ogr2ogr wants that identifier for GML, and it seems the driver will add that field in any case.
Aliasing the collumn I wanted as fid worked and no new attribute field was created when exporting to gml.
Only top voted, non community-wiki answers of a minimum length are eligible
