tags:

views:

13

answers:

1
Q: 

What are some ways to extract a location from a sentence/query?

I want to recognize and extract a location that's built into a sentence. For example I might have a sentence:

"I love the pizza in Boston, Ma." but this same sentence could also be written as "Pizza in Boston, I love it." OR "I love the pizza in Boston."

So I have to be able to find it anywhere in the sentence and also if the state is not included. To makes things even more complicated people do things like ft. or s. for fort or south so I need a way to recognize these as well.

A: 

How about parse each word in the sentence and check against a "location" dictionary? After a hit, secondary tests could include the word before/after to complement the location with a corresponding city (word before) or state (word after).

This will get tricky for things like "The best Buffalo Wings in Kansas City"; When you find multiple locations in a single statement, you could use a seperate "dual-use" dictionary to eliminate words like "Buffalo". You could also search for prepositions like "in", "near", "at", etc. to identify the real location.

Jess  2010-10-13 21:23:08
We do that now but it's hard for 3,4,5 and 6 word cities(and slow).The prepositions is an interesting idea, I'll have to check how often those are included.
Ryan Detzel  2010-10-13 21:35:22

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?