Posted by richard on 08/28/06 02:24

"Jerry Stuckle" <jstucklex@attglobal.net> wrote in message
news:_t6dnSfLTd_aAW3ZnZ2dnUVZ_uidnZ2d@comcast.com...
> 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.
>>
>>
>>
>>
>
> Get a copy of the database from FMCSA?

Have asked, no reply yet.

• Next in forum: Re: redirection based on not connecting to url (fsockopen)
• Prev in forum: Re: cron not working when calling php script with mysql on linux box
• Thread view: Re: Fishing for a way to search a humongous database

[Reply to this message]