I am looking to run a query in OGR to write back all instances where there is only one record of an attribute. I was thinking that I would use the following:
ogrinfo -dialect sqlite -sql "SELECT COUNT(*) FROM roads AS roadcnt WHERE roadcnt = 1 GROUP BY road_name" roads.shp >report.txtThis query returns an error: near "road_name": syntax error
أكثر...
ogrinfo -dialect sqlite -sql "SELECT COUNT(*) FROM roads AS roadcnt WHERE roadcnt = 1 GROUP BY road_name" roads.shp >report.txtThis query returns an error: near "road_name": syntax error
أكثر...