Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Keyword search in spatial database
0 views
Skip to first unread message
Kavita
Jan 6, 2010, 2:26:05 AM1/6/10
to
Hi all,
i am a master's student. I have to do a keyword search for spatial
database. I have the data set of a particular district in India. I
have a data model too.
Can some one help me through this task.
i am a master's student. I have to do a keyword search for spatial
database. I have the data set of a particular district in India. I
have a data model too.
Can some one help me through this task.
My question is - it is a single word (keyword) search. I have the
database schema too. How do i search this keyword through this schema
or the entire data. How do i convert this keyword into a sql query
that the database system would understand and query the database.
Eg keyword- river.
I would appreciate advice.
TIA.
Mladen Gogala
Jan 6, 2010, 10:04:53 PM1/6/10
to
You can do a text search on a single column with a text index. You should
do something like this:
WHERE text_srch_col @@ to_tsquery('keyword & ice')
You can not do a search the entire schema.
Laurenz Albe
Jan 7, 2010, 5:23:13 AM1/7/10
to
I don't understand.
What do you mean by "spatial database"? PostGIS?
What is a "keyword search"?
Maybe you could post a little example...
Yours,
Laurenz Albe
0 new messages