On Wed, 9 Nov 2022, Leber, Thorsten wrote:
Hi All,
I am trying to use org2org with the following command:
ogr2ogr -f "ESRI Shapefile" C:\RenderTest\raster_clipper_and.shp PG:"host=10.49.20.42 port=5432 user=tilemill password=test
dbname=nextgen" -sql "SELECT "name", "left", top, "right", botto
ent is safe.
Hi,
Does the SQL part work with a tool like pgAdmin? Notice that the
inner double quotes must be escaped as \” in the ogr2ogr command or
otherwise they will truncate the -sql parameter. And it seems that
you did not select the geometry field. Generally I would suggest to
start with a simple SQL and add complexity onc
he SQL part work with a tool like pgAdmin? Notice that the inner
double quotes must be escaped as \” in the ogr2ogr command or
otherwise they will truncate the -sql parameter. And it seems that you
did not select the geometry field. Generally I would suggest to start
with a simple SQL and add com
you have gotten a good result. Suggestion includes testing with easy table
names first before forwarding to names like
countries.geometries_boundary_buffer_10km('and').
-Jukka Rahkonen-
Lähettäjä: gdal-dev
mailto:gdal-dev-boun...@lists.osgeo.org>>
Puolesta Leber, Thorsten
Lähe
9. marraskuuta 2022 13.02
Vastaanottaja: gdal-dev@lists.osgeo.org
Aihe: [gdal-dev] org2org
Hi All,
I am trying to use org2org with the following command:
ogr2ogr -f "ESRI Shapefile" C:\RenderTest\raster_clipper_and.shp
PG:"host=10.49.20.42 port=5432 user=tilemill password=test
Hi All,
I am trying to use org2org with the following command:
ogr2ogr -f "ESRI Shapefile" C:\RenderTest\raster_clipper_and.shp
PG:"host=10.49.20.42 port=5432 user=tilemill password=test dbname=nextgen" -sql
"SELECT "name", "left", top, "right", bottom FROM grids.grid_1_25grad WHERE
ST_Intersec
I want have some points and I want to find out if they are in a polygon.
I have two shape files one defining a polygon and the other two points here are
the csv files for both and the vrt files:
My_Polygon.csv:ID,WKT1,"POLYGON ((1 1, 4 1, 4 3, 1 3, 1 1))"
My_points.csv:ID X Y1 2 22 0 1
My_Polygon
