Posted by Paul Lautman on 12/17/69 11:56

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?

[Back to original message]