[FWTools] sql string functions for shapefiles in ogrinfo
Bryan Keith
bryan at geomega.com
Tue Jan 16 17:22:57 EST 2007
Mateusz Loskot wrote:
> Bryan Keith wrote:
>> Mateusz Loskot wrote:
>>> Bryan Keith wrote:
>>>> Hello,
>>>>
>>>> I can use this command and get the output I expect from a shapefile:
>>>>
>>>> ogrinfo "myfile.shp" -al -sql "select * from 'myfile' where ID =
>>>> 'SB-18'"
>>>>
>>>> However, what if I want all records where ID starts with 'SB'? If I
>>>> tried left, substr and others e.g.:
>>>>
>>>> where left(ID,2) = 'SB'
>>>>
>>>> I assume if you're using a db like PostGIS then the sql is parsed by the
>>>> db, and you can read the db documentation for the sql syntax. Which sql
>>>> syntax reference should I be using for shapefiles?
>>> SQL query compiler in OGR supports SQL standard operators: LIKE, ILIKE,
>>> IS, IN, etc.
>>>
>>> So, you can write your query as follows:
>>>
>>> "select * from myfile where ID LIKE 'SB%'"
>>>
>>> Cheers
>> Mateusz,
>>
>> That works for me. Thank you.
>
> Bryan,
>
> I'm glad.
>
> By the way, there is a document describing OGR SQL dialect in details:
>
> http://www.gdal.org/ogr/ogr_sql.html
Ah, the page that would have answered my question in the first place.
I've got it bookmarked now. Thanks, Mateusz
Bryan
>
> Cheers
More information about the FWTools
mailing list