Re: [WebDNA] Range calculation w/negative values
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107677
interpreted = N
texte = Should the base be ordered? If so, have you taken into account that, say, -7= 0 is greater than -100? Francisco Hirsch --=20 http://www.ayudamac.com.ar http://www.elasesordevinos.com.ar http://www.fiscaldemesa.com.ar On 08/11/2011, at 21:07, Gil Poulsen
wrote: >=20 > On Nov 8, 2011, at 6:46 PM, Francisco Hirsch wrote: >=20 >> Well, the use of negative signs is merely a convention, so it's ok to exc= hange negative for positive >=20 > Yeah, that's true. I just feel like it's cheating in the sense that if thi= s was a worldwide database, I wouldn't have the luxury of being able to conv= ert all the values to positives since there must be cases wherein two places= would have the same exact longitude were it expressed as an absolute value.= >=20 >>=20 >> Francisco Hirsch >> --=20 >> http://www.ayudamac.com.ar >> http://www.elasesordevinos.com.ar >> http://www.fiscaldemesa.com.ar >>=20 >>=20 >>=20 >> On 08/11/2011, at 10:11, Gil Poulsen wrote: >>=20 >>> Haven't posted to this list in ages, but every so often you run into som= ething... Doing a range calculation as part of a distance search based on ZI= P code (aka Great Circle calculation). For whatever reason, I can't get the s= earch to work on negative values, and the longitude of every city in the U.S= . is expressed as a negative value. Using WebCat 5.1e on an old Mac mini G4.= >>>=20 >>> This is the basic search, actually comes from something another individu= al on the list posted years ago: >>>=20 >>> [search db=3Dzipcodes.db&rnLATdatarq=3D[lowLat],[hiLat]&rnLONGdatarq=3D[= lowLong],[hiLong]&LATtype=3Dnum&LONGtype=3Dnum&asZIPsort=3D1] >>>=20 >>> The [lowLong]and [hiLong] values are negative as well. If I remove the e= ntire longitude section the search works fine. And if I change the values in= the db for longitude to positive, the search works, but that just seems wro= ng... >>>=20 >>> zipcodes.db >>> zip city state lat long >>> 00501 HOLTSVILLE NY 40.81 -73.04 >>>=20 >>>=20 >>> -- >>> Gil Poulsen, Mac Wirehead >>>=20 >>> ************************ >>> AltiM@c Consulting >>> P.O. Box 2125 >>> Neptune, NJ 07754 >>> Voice: 609-359-0103 >>> ************************ >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >=20 > -- > Gil Poulsen, Mac Wirehead >=20 > ************************ > AltiM@c Consulting > P.O. Box 2125 > Neptune, NJ 07754 > Voice: 609-359-0103 > ************************ >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
Should the base be ordered? If so, have you taken into account that, say, -7= 0 is greater than -100? Francisco Hirsch --=20 http://www.ayudamac.com.ar http://www.elasesordevinos.com.ar http://www.fiscaldemesa.com.ar On 08/11/2011, at 21:07, Gil Poulsen wrote: >=20 > On Nov 8, 2011, at 6:46 PM, Francisco Hirsch wrote: >=20 >> Well, the use of negative signs is merely a convention, so it's ok to exc= hange negative for positive >=20 > Yeah, that's true. I just feel like it's cheating in the sense that if thi= s was a worldwide database, I wouldn't have the luxury of being able to conv= ert all the values to positives since there must be cases wherein two places= would have the same exact longitude were it expressed as an absolute value.= >=20 >>=20 >> Francisco Hirsch >> --=20 >> http://www.ayudamac.com.ar >> http://www.elasesordevinos.com.ar >> http://www.fiscaldemesa.com.ar >>=20 >>=20 >>=20 >> On 08/11/2011, at 10:11, Gil Poulsen wrote: >>=20 >>> Haven't posted to this list in ages, but every so often you run into som= ething... Doing a range calculation as part of a distance search based on ZI= P code (aka Great Circle calculation). For whatever reason, I can't get the s= earch to work on negative values, and the longitude of every city in the U.S= . is expressed as a negative value. Using WebCat 5.1e on an old Mac mini G4.= >>>=20 >>> This is the basic search, actually comes from something another individu= al on the list posted years ago: >>>=20 >>> [search db=3Dzipcodes.db&rnLATdatarq=3D[lowLat],[hiLat]&rnLONGdatarq=3D[= lowLong],[hiLong]&LATtype=3Dnum&LONGtype=3Dnum&asZIPsort=3D1] >>>=20 >>> The [lowLong]and [hiLong] values are negative as well. If I remove the e= ntire longitude section the search works fine. And if I change the values in= the db for longitude to positive, the search works, but that just seems wro= ng... >>>=20 >>> zipcodes.db >>> zip city state lat long >>> 00501 HOLTSVILLE NY 40.81 -73.04 >>>=20 >>>=20 >>> -- >>> Gil Poulsen, Mac Wirehead >>>=20 >>> ************************ >>> AltiM@c Consulting >>> P.O. Box 2125 >>> Neptune, NJ 07754 >>> Voice: 609-359-0103 >>> ************************ >>>=20 >>>=20 >>> --------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >>=20 >=20 > -- > Gil Poulsen, Mac Wirehead >=20 > ************************ > AltiM@c Consulting > P.O. Box 2125 > Neptune, NJ 07754 > Voice: 609-359-0103 > ************************ >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us
Francisco Hirsch
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
NetSplat and WebCat2 (1997)
FYI: virus alert (1996)
Help formatting search results w/ table (1997)
Protecting a folder (2000)
blank fields (1999)
Emailer (WebCat2) (1997)
[SearchString] usage (1997)
Tcp Connect and the disappearing page (2000)
Nested tags count question (1997)
Multi-processor Mac info ... (1997)
docs for WebCatalog2 (1997)
Opinion: [input] should be called [output] ... (1997)
email messages (1997)
RE: Languages (1997)
Mozilla/4. and Browser Info.txt (1997)
Practice runs ? (1997)
I am sorry for always being such an ass (2004)
WebCat2b12plugin - [search] is broken ... not! (1997)
[SearchString] usage (1997)
[TaxableTotal] - not working with AOL and IE (1997)