mike生成的dbf文件,
有的列表头是一样的,
arcgis可以打开,但使用org2ogr会出错。
如果用arcgis 修改过这个文件,arcgis会修改同名的表头,在表头后加后缀。
L:\ldxy__shape>ogr2ogr -sql "select ST_Centroid(geometry),* from YOU_20_XianZhuang" -dialect sqlite centroid_YOU_20_XianZhuang.shp YOU_20_XianZhuang.shp
ERROR 1: Cannot create virtual table for layer 'YOU_20_XianZhuang' :
CREATE VIRTUAL: invalid SQL statement :
CREATE TABLE "YOU_20_XianZhuang"("Maximum wa" FLOAT,
"Time at ma" FLOAT,
"Maximum cu" FLOAT,
"Time at ma" FLOAT,
"Duration a" FLOAT,
OGR_STYLE VARCHAR HIDDEN,
"GEOMETRY" BLOB_POLYGON_XY_4548,
OGR_NATIVE_DATA VARCHAR,
OGR_NATIVE_MEDIA_TYPE VARCHAR)
ERROR 1: In ExecuteSQL(): sqlite3_prepare_v2(select ST_Centroid(geometry),* from YOU_20_XianZhuang):
no such table: YOU_20_XianZhuang
没有评论:
发表评论