Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Hi Jukka, Rahkonen Jukka (MML) wrote > Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN > bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is > not mentioned in a bunch of documents about SQL language which I browsed > through, for example http://www.w3s

Re: [gdal-dev] GSoC 2016

Hi all, I am Avyav Kumar, a third year student at BITS Pilani, KK Birla Goa Campus, India. I am working to build a Triangulated Surface, Polyhedral Surface and Triangle API for OGRGeometry [http://www.gdal.org/classOGRGeometry.html] as part of my GSoC 2016 proposal. If anyone has suggestions they'

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Andrea Borruso wrote: >thank you very much. I had read that page, but stupidly I did not think >that "ALTER TABLE tablename ADD [COLUMN] columnname columntype" meant >strictly that I could only use it in this way. >My wrong intepretion was that I could use "alter table add" SQL command >and its v

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Hi Even, On 1 May 2016 at 22:28, Even Rouault wrote: > Because it is not implemented... OGR SQL has many implementation > limitations. > What is supported is documented here : http://gdal.org/ogr_sql.html > thank you very much. I had read that page, but stupidly I did not think that "ALTER TABL

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Le dimanche 01 mai 2016 19:11:36, aborruso a écrit : > Hi Jeff, > thank you from Italy! > > > jmckenna wrote > > > When I responded earlier I was testing and you cannot do this in one > > single ogrinfo command (so that answers your initial question). What > > would be great, if you could add y

Re: [gdal-dev] compile error on windows

If you want to protect your hair don't try to build HDF5.8.12 (and probably some other versions around this one) it will crash a couple times under VS14 and will error at the middle of build with a timezone variable not found (or similar) 5.10.0 builds fine but the HDF page has worry message say

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Hi Jeff, thank you from Italy! jmckenna wrote > > When I responded earlier I was testing and you cannot do this in one > single ogrinfo command (so that answers your initial question). What > would be great, if you could add your working example to the docs: here > is an existing wiki page f

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

On 2016-05-01 10:30 AM, aborruso wrote: jmckenna wrote I think you have to use 2 ogrinfo statements. I know it, it works with 2 statements. Do you know why I cannot use my kind of SQL command with all in one statement? And what do you think about to add some note in the documentation, about

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

I see. Thanks for the correction. On Sun, May 1, 2016 at 6:58 AM, aborruso wrote: > Hi Christine, > thank you. > > > Christine Waigl wrote > > > > As far as I'm aware -- please correct me if I'm wrong -- > > ogrinfo only lists information about a file and doesn't > > alter it. > > As I written i

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

aborruso wrote > As I written in my message I'm able to use ogrinfo to alterate my source > file, but if I want to add 3 fields I must write 3 ogrinfo statements; I > would like to know why a single statemente with a correct SQL command. ops, I'm sorry ... why I cannot use a single ogrinfo statem

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Hi Christine, thank you. Christine Waigl wrote > > As far as I'm aware -- please correct me if I'm wrong -- > ogrinfo only lists information about a file and doesn't > alter it. As I written in my message I'm able to use ogrinfo to alterate my source file, but if I want to add 3 fields I must w

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

On Sun, May 1, 2016 at 5:30 AM, aborruso wrote: > > > jmckenna wrote > > I think you have to use 2 ogrinfo statements. As far as I'm aware -- please correct me if I'm wrong -- ogrinfo only lists information about a file and doesn't alter it. "ogrinfo -sql" may well be executing the alter table s

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

Hi Jeff, thank you. jmckenna wrote > I think you have to use 2 ogrinfo statements. I know it, it works with 2 statements. Do you know why I cannot use my kind of SQL command with all in one statement? And what do you think about to add some note in the documentation, about the origin of the imp

Re: [gdal-dev] How to add more than one column to a shapefile using ogrinfo

On 2016-05-01 5:20 AM, aborruso wrote: Hi, I have no problem to add a column to a shapefile with: ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer" But if I use, the second column is not added to the file. ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer(3), fieldY i

[gdal-dev] How to add more than one column to a shapefile using ogrinfo

Hi, I have no problem to add a column to a shapefile with: ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer" But if I use, the second column is not added to the file. ogrinfo myfile.shp -sql "ALTER TABLE myfile ADD fieldX integer(3), fieldY integer(3)" The shell gives me only INFO: