Pil Kwon
  • Member for 8 years, 8 months
  • Last seen this week
How to convert all tables from FGDB into CSV using OGR2OGR?
Accepted answer
5 votes

ogr2ogr -overwrite -progress -f csv "D:\NGII_Emap\" "D:\NGII_Emap\input_table.gdb" it does create the NGII_Emap folder. so if you have NGII_Emap folder already, you'd better change the name

View answer
Extracting POI from Openstreetmap (*.osm)
Accepted answer
5 votes

easy. 1. download *.osm.pbf 2. install osmosis 3. in the command window type osmosis --rbf INPUT.osm.pbf --nk keyList="amenity" --wx OUTPUT.osm

View answer
Get Bounding Box of Each Polygon (Each Rows in a table) using PostGIS
2 votes

select *, st_asText(ST_Envelope(wkb_geometry)) as bound from world_tile4; ST_Extent -> St_Envelope this was the key.

View answer
Merging shapefiles and saving them to file geodatabase using ogr2ogr?
Accepted answer
2 votes

base on on @user30184 the code should be changed to for %f in (*disp_line.shp) do (if not exist test.gdb (ogr2ogr -progress --config shape_encoding "UTF-8" -f "filegdb" test.gdb %f -nln test_line -...

View answer
Is there an option in OGR2OGR to repair geometry when importing data to PostGIS?
2 votes

so basically your whole code will be like this ogr2ogr -overwrite -progress -f "PostgreSQL" PG:"host=localhost port=5432 dbname=yourdb user=yourid password=pw" inputGDBpath -lco GEOMETRY_NAME=...

View answer
Extract data from osm.pbf with GDAL
1 votes

Well,, I ended up using imposm3 and it gave me what I wanted to have. It works great with linux without installing but with MacOSx you have to do some trick to install.

View answer
Increase spatial query performance (st_difference)
1 votes

I am sure I am going to have bad reputation after posting this.. but I probably have to for those who helped me. Again, I am very thankful to all those who gave me solutions. the soultion from @...

View answer
OGR2OGR Differencing Vector Layer
Accepted answer
0 votes

I edited the script a little bit as below and it worked just fine. ogr2ogr -overwrite out.shp input.shp -dialect SQLite -sql "select st_difference(a.geometry, b.geometry) as geometry from input as a, ...

View answer
Import Shapefile to GDB. OGR2OGR FGDB Driver bug(?) on CentOS 7
Accepted answer
0 votes

Yes, it is because of setting the projection. The original Shapefile comes without .prj and that is the reason why. I added the epsg and now seems fine. Sorry for the trouble. this is the code I ...

View answer