|
|
Posted by richard on 11/13/57 11:56
"Paul Lautman" <paul.lautman@btinternet.com> wrote in message
news:4lape8F1297jU1@individual.net...
> richard wrote:
>> http://safer.fmcsa.dot.gov/CompanySnapshot.aspx
>>
>>
>> How could I go about automating a search of this site's database?
>> I'm not interested in all the details they present on the output
>> form, just the bare basics.
>> That is, trucking company name, city location, and zip code and a
>> couple of other fields
>> With over a million records, manual searching is out of the question.
>> Every trucking company is required to have, and display, a USDOT
>> number. Using that field as a starting point, one might be able to
>> extract the rest of the information.
>> Going by a name search, the site only returns 500 matches and does
>> not care where in the name the field appears.
>>
>> I'm open to suggestions.
>
> Create a fulltext index?
I have no clues as to what that is.
Navigation:
[Reply to this message]
|