| [GMCnet] Black List Update [message #110304] |
Thu, 30 December 2010 21:44  |
bdub
Messages: 1578
Registered: February 2004
Location: Central Texas
Karma: 5
|
Senior Member |
|
|
Hi Netters
Jim Melberg has just delivered the updated list and map files. I've updated
the web site with his files.
http://www.bdub.net/Black_List/
Thanks to Jim for all his work in updating these files.
bdub
_______________________________________________
GMCnet mailing list
List Information and Subscription Options:
http://temp.gmcnet.org/cgi-bin/mailman/listinfo/gmclist
bdub
'76 Palm Beach/Central Texas
www.bdub.net
www.gmcmhphotos.com
www.gmcmotorhomemarketplace.com
www.gmcmhregistry.com
www.facebook.com/groups/classicgmcmotorhomes
www.facebook.com/groups/gmcmm
|
|
|
|
| Re: [GMCnet] Black List Update [message #285446 is a reply to message #110304] |
Thu, 20 August 2015 10:26  |
Olly Schmidt
Messages: 1265
Registered: February 2014
Location: Germany and Scottsville, ...
Karma: 8
|
Senior Member |
|
|
Billy,
> Just got through updating the Black List. We gained a dozen or so members
> since July.
thanks for the update.
Would it be hard to add the longitude and latitude to the list as well?
That way, people who need to massage the file for different imports
don't need to re-add that information each time or manually add new
people to their own database.
--
Best regards
Peer Oliver Schmidt
PGP Key ID: 0x83E1C2EA
'76a Eleganza II, VA
_______________________________________________
GMCnet mailing list
Unsubscribe or Change List Options:
http://list.gmcnet.org/mailman/listinfo/gmclist_list.gmcnet.org
Best regards
Olly Schmidt
PGP Key ID: 0x18a9 3a1f 4196 bf22
'76a Eleganza II, VA
'73 Sequoia, SH, Germany
|
|
|
|
|
|
| Re: [GMCnet] Black List Update [message #285458 is a reply to message #110304] |
Thu, 20 August 2015 12:53 |
habbyguy
Messages: 896
Registered: May 2012
Location: Mesa, AZ
Karma: 3
|
Senior Member |
|
|
I did a utility for my business, to help find existing customers close to the location of someone asking for help. Seems like it might be a good fit.
It's an Excel-based spreadsheet that uses a standard zip code to lat/long "database" (though just in an Excel spreadsheet format). For the Excel geeks among you, I just set an arbitrary maximum "offset" in each the lat and long positions (of 0.3 degrees in my case, which works out to about 25 miles). If the position of a zip code ends up being less than 25 miles off in both latitude and longitude, the associated formula returns a "TRUE", otherwise a "FALSE". It would be pretty trivial to add some smarts to the Excel-based blacklist to allow the user to enter their zip code (or the zip code of their location), and set a value in a cell associated with each blacklist member so they can tell at a glance who is close to their location. It seems that the A (left-most) column isn't being used for anything in the Excel Blacklist.
Yes, it's limited, since some zip codes are pretty broad, the lat/long resolution is limited to two digits right of the decimal point, and I didn't get fancy trying to work out absolute distances, but only limiting each the North/South and East/West distances to a given value (which will change at least a little from north to south as the longitudinal lines get closer together as you go north). Still, it might be a nice option for those who have reasonably up to date Excel installed on their machines (I'm only using Office 2003, so it's probably not much of an issue). All the data (30,000 or so lines of zip codes) and formulas does bump up the size of the Excel file to about 5 megabytes - nothing in today's standards, but still big enough that it might not work in every case (such as on a phone?). Still, it would be a really easy way to help someone quickly work out who on the list is within X number of miles from them (whether at home or on the road).
Mark Hickey
Mesa, AZ
1978 Royale Center Kitchen
|
|
|
|
|
|
| Re: [GMCnet] Black List Update [message #285483 is a reply to message #285461] |
Thu, 20 August 2015 18:49 |
bdub
Messages: 1578
Registered: February 2004
Location: Central Texas
Karma: 5
|
Senior Member |
|
|
They are no longer available.
-----Original Message-----
From: Gmclist On Behalf Of Armand Minnie
Sent: Thursday, August 20, 2015 2:30 PM
Where are the map files?
_______________________________________________
GMCnet mailing list
Unsubscribe or Change List Options:
http://list.gmcnet.org/mailman/listinfo/gmclist_list.gmcnet.org
bdub
'76 Palm Beach/Central Texas
www.bdub.net
www.gmcmhphotos.com
www.gmcmotorhomemarketplace.com
www.gmcmhregistry.com
www.facebook.com/groups/classicgmcmotorhomes
www.facebook.com/groups/gmcmm
|
|
|
|
GMCforum
Search
Help
Register
Login
Home
