USP_DATALIST_ADDRESSCOORDINATESWITHINBOUNDS

Retrieves lat/long primary address coords within the given lat/long boundaries.

Parameters

Parameter	Parameter Type	Mode	Description
@SOUTHLATITUDE	decimal(13, 6)	IN	Southern bound
@NORTHLATITUDE	decimal(13, 6)	IN	Northern bound
@WESTLONGITUDE	decimal(13, 6)	IN	Western bound
@EASTLONGITUDE	decimal(13, 6)	IN	Eastern bound

Definition

Copy



CREATE procedure dbo.USP_DATALIST_ADDRESSCOORDINATESWITHINBOUNDS
(
    @SOUTHLATITUDE decimal(13,6),
    @NORTHLATITUDE decimal(13,6),
    @WESTLONGITUDE decimal(13,6),
    @EASTLONGITUDE decimal(13,6)
)
as
    set nocount on;

    select 
        ADDRESSCOORDINATES.LATITUDE, 
        ADDRESSCOORDINATES.LONGITUDE 
    from ADDRESSCOORDINATES
    inner join
        address on address.id = addresscoordinates.addressid
    where
        ADDRESS.ISPRIMARY = 1
        and
        (ADDRESSCOORDINATES.LATITUDE >= @SOUTHLATITUDE and ADDRESSCOORDINATES.LATITUDE <= @NORTHLATITUDE)
        and
        (ADDRESSCOORDINATES.LONGITUDE >= @WESTLONGITUDE and ADDRESSCOORDINATES.LONGITUDE <= @EASTLONGITUDE)
        and
        ADDRESSCOORDINATES.INVALIDGEOCODE = 0
        and
        ADDRESSCOORDINATES.MATCHEDMETHOD <> 'CountryRegion'