Re: [gdal-dev] GDAL question

2021-04-29 Thread Peter P
When I use in cmd: ogrinfo -so PG:"dbname='test' host='127.0.0.1' port='5432' user='user1' password='password1'" table1 Output is: Layer name: table1 Geometry: Unknown (any) Feature Count: 8 Extend: (...,...) - (,...) Layer SRS WKT: (unknown) FID Column = Id Geometry Column = TestGeometry Nam

Re: [gdal-dev] GDAL question

2021-04-23 Thread jratike80
Hi, You can't update with ogr2ogr. Use ogrinfo instead. I believe that you will find good examples from gis.stackexchange https://gis.stackexchange.com/search?q=ogrinfo+update -Jukka Rahkonen- Peter P wrote > It is works, Thanks > > Now I trying update row. > In SQL will be: /UPDATE "table1" S

Re: [gdal-dev] GDAL question

2021-04-23 Thread Peter P
It is works, Thanks Now I trying update row. In SQL will be: /UPDATE "table1" SET "TestGeometry"= WHERE "Name" = 'testname'/ How is this possible in ogr2ogr? I use -update, -append not work... jratike80 wrote > Hi, > > Please check your GeoJSON before fighting with Python. "Name" placed in

Re: [gdal-dev] GDAL question

2021-04-21 Thread jratike80
Hi, Please check your GeoJSON before fighting with Python. "Name" placed into here {"type": "FeatureCollection", "Name": "testName", will probably be just skipped. If you used lower case "name" {"type": "FeatureCollection", "name": "testName", then "testName would be used as a name of the layer

Re: [gdal-dev] GDAL question

2021-04-21 Thread Peter P
PostgreSQL "table1" columns: Name Data Type Id integer Name text TestGeometry geometry Example geojson - this will be one row in table: jsonVariable = {"type": "FeatureCollection", "Name": "testName", "features": [{"type": "Feature", "geometry": {"type": "Polygon", "coordinates": [[[26.54296875,64

Re: [gdal-dev] GDAL question

2021-04-21 Thread Peter P
PostgreSQL "table1" columns: Name Data Type Id integer Name text TestGeometry geometry Example geojson - this will be one row in table: jsonVariable = {"type": "FeatureCollection", "Name": "testName", "features": [{"type": "Feature", "geometry": {"type": "Polygon", "coordinates": [[[26.54296875,64

Re: [gdal-dev] GDAL question

2021-04-20 Thread jratike80
Hi, Ogr2ogr by default converts all the columns so you should not need to do anything. Test first ogr2ogr from the command line without mixing Python into the soup. If you still do not get your "name" attribute converted you may have something special in your data, like a few first features in the

[gdal-dev] GDAL question

2021-04-20 Thread Peter P
Hello I use GDAL(https://github.com/OSGeo/gdal) with python bindings. I am importing GeoJSON to PostgreSQL (PostGIS). I know how to import only geometry to the table. I dont know how to import geometry with others columns to one table. I need to import geometry to "wkt_geometry" column and his nam

Re: [gdal-dev] GDAL Question about the band/frequence information

2013-03-28 Thread Jonathan Greenberg
I was recently looking into for some code I'm writing in R using rgdal, and I wanted to see if we could generate some new effort on this. While the way each file format specifies RS information may be different, there are some standard pieces of info that could be read/stored in a meaningful way w

Re: [gdal-dev] GDAL Question about the band/frequence information

2013-02-06 Thread Frank Warmerdam
Shuqing, GDAL does not have a well defined name for metadata describing a bands wavelength. Some data products carry this in their metadata and it may be carried through via the GDAL generic metadata at either the band or dataset level. Running gdalinfo against a file will show such generic meta

[gdal-dev] GDAL Question about the band/frequence information

2013-02-06 Thread Shuqing Chen
Hello GDAL Developers, I have intergrated your GDAL library in my Multi Spectra analysis Project. It works very well and ease to use. A question is how can I find the band/frequence information for each band in image dataset? Thank you in advance. Best regards, Shuqing Chen __