NetQuarry Core Help
Namespaces
NetQuarry
EAPUtil Class
EAPUtil Methods
AddStyles Method
AnsiQuote Method
BitsSet Method
BlobToBytes Method
BlobToFile Method
CalcLatLongDistance Method
CalendarQuarter Method
CaptureStackFrames Method
CleanFilename Method
ClearFarmCacheAsync Method
ComposeDateTime Method
ConstructExternalLink Method
ConstructLink Method
ContainsKey Method
ControlHtml Method
CreateMissingPath Method
DataTableTypeToOleDbType Method
DateSQL Method
DefaultHtmlHeader Method
Deserialize Method
DevLogUnknownBits Method
DiagnoseMultipleControlError Method
EqualValue Method
EscapeEmbeddedFunctions Method
EscapeExpressionBrackets Method
EscapeSQLName Method
ExtractNestedMessage Method
FileExists Method
FileIsReadonly Method
FileMakeWriteable Method
FileVersion Method
FindChildControl Method
FixupHoverButton Method
FormatException Method
FormatExceptionForRequestLog Method
FromHex Method
FtpDeleteFile Method
FtpGetFileContents Method
FtpGetFileList Method
FtpUpload Method
GetByteBufferFromFile Method
GetByteBufferFromLogicalFile Method
GetDataRowValue Method
GetEventsHandled Method
GetImageFromFile Method
GetLogDB Method
GetNextBusinessDay Method
GetPageForm Method
GetTypeFromString Method
HasExactlyOneBitSet Method
HasRows Method
HelpString Method
HtmlEncode Method
ImageSize Method
InputStreamToBase64 Method
IsBitMask Method
IsClientScriptBlockRegistered Method
IsEditorBrowsable Method
IsFileValidateAcceptType Method
IsFolder Method
IsGuid Method
IsNonEmptyString Method
IsNullObjectOrEmptyString Method
IsNullOrBlank Method
IsNumeric Method
IsReservedDBWord Method
IsStartupScriptRegistered Method
IsTruthy Method
IsUIHidden Method
IsVersionConstrained Method
JString Method
LoadComponent Method
LogApiRequest Method
MD5 Method
MergeStrings Method
NewGuid Method
ObjCompare Method
PathExists Method
PathSplit Method
PhysicalPathToRelativePath Method
ReaderBlobToFile Method
ReadInputStream Method
ReadTextFile Method
RedirectUrl Method
RegisterClientHtmlBlock Method
RegisterClientScriptBlock Method
RegisterClientScriptFile Method
RegisterDocReadyScript Method
RegisterHiddenField Method
RegisterStartupScript Method
RemoveInvalidChars Method
ReplaceCaseInsensitive Method
ResizeImage Method
ResolvePath Method
RetrieveLinkerTimestamp Method
SafeSQLName Method
SavePostedFile Method
Serialize Method
SetInitialFocus Method
SetNewActionOnQS Method
SpanIncluding Method
SqlBlobToFile Method
SqlDbTypeToOleDbType Method
SqlExceptionInternals Method
SqlNativeTypeToOleDbType Method
SQLString Method
StripHTML Method
TextToHtml Method
ToDecimal Method
ToDouble Method
ToDoubleSafe Method
ToHex Method
ToInt Method
ToString Method
ToStringRaw Method
TypeIsBinary Method
TypeIsBoolean Method
TypeIsChar Method
TypeIsDate Method
TypeIsFloat Method
TypeIsInteger Method
TypeIsLong Method
TypeIsLongChar Method
TypeIsNumeric Method
TypeIsUnicode Method
TypeRequiresUnicodeEscape Method
ValidBits Method
WeekNumber Method
WindowOpenFeatures Method
WriteBlobToDatabase Method
WriteExceptionToRequestLog Method
WriteFileToDatabase Method
WriteInputStreamToDatabase Method
WriteToRequestLog Method
WriteToTimingLog Method
ZipDistanceCalc Method
ZipInfoLookup Method
Click or drag to resize

EAPUtilZipDistanceCalc Method

Calculate the distance between two zip codes.

Namespace:  NetQuarry
Assembly:  EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)
Syntax
Copy
public static double ZipDistanceCalc(
	IDatabase db,
	string zip1,
	string zip2,
	bool approximate
)

Parameters

db
Type: NetQuarryIDatabase
The database containing the zip code data.
zip1
Type: SystemString
The first ZIP code.
zip2
Type: SystemString
The second ZIP code.
approximate
Type: SystemBoolean
If true and either or both of the specified ZIP codes are not found, a "close" zip code will be used instead.

Return Value

Type: Double
The distance between the two ZIP codes in miles, -1.0 if unable to calculate.
Remarks
The distance is the theoretical straight-line distance between the points. It does not take altitide into account. The distance is calculated from the lattitude and longitude associated with the ZIP code in the xxx table in the database. These points were obtained from the 2000 U.S. Census as downloaded from http://www.census.gov/tiger/tms/gazetteer/zips.txt. Note that there are MANY caveats regarding this data including the fact that not all ZIP codes are included ("the file doesn't have ZIP Codes for completely commercial areas or for places with non-city-style addresses (most of the rural areas).") and "coverage is not good in the rural areas" .
See Also