Tan Hao Feng <htan <at> hsr.ch> writes: > Dear Sir/Madam, > I'm a student in HSR, Rapperswil and I am trying to clip a SQLite file > I converted .osm.pbf file of liechtenstein to a .sqlite file, and then tried to clip it with the following codes, (is it > -clipsrc or -clipdstogr2ogr -f "SQLite" > liechtenstein.sqlite > liechtenstein-latest.osm.pbg -skipfailures -dsco SPATIALITE=yes -clipsrc 47.1386361 9.5231616 47.1404971 > 9.5266377 Also, I tried to clip the map of Singapore but was unsuccessful, the following is the code > ogr2ogr -f "SQLite" singapore.sqlite malaysia-singapore-brunei-latest.osm.pbg -skipfailures -dsco -clipsrc singapore.geojson > Do I have to convert to .shp file? > Do you have any suggestions? > Thank you! > Hao Feng.
Hi, I suggest to check the names of your input files. Are you sure they are .pbg and not .pbf? Clipsrc takes coordinates in the source projection, clipdst in target projection. Both mean the same if you do not use different -s_srs and -t_srs parameters. Did you not find the information from manual page http://gdal.org/ogr2ogr.html? Read also the manual page of SQLite/Spatialite format. I bet that you will want to create Spatialite database and not a "regular" FDO database. Here is a fast running query that worked for me: ogr2ogr -f SQLite -dsco spatialite=yes clip.sqlite finland-latest.pbf -gt 20000 -progress --config OGR_SQLITE_SYNCHRONOUS OFF --config OSM_COMPRESS_NODES YES -clipsrc 27 65 28 66 -Jukka Rahkonen- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
