About Pricing Community Teams Start Free Trial

Mr_Shaw

asked on 5/18/2011

sql spatial search

I need to make a spatial search.

I have the longitude and latitude of 1000 shops.

I need to find all the shops with 1 mile radius of the longitude and latitude.

I am not sure how to do this. Can anybody help?

Thanks.

Microsoft SQL Server 2005Microsoft SQL Server 2008Microsoft SQL Server

Last Comment

Mr_Shaw

8/22/2022 - Mon

ASKER CERTIFIED SOLUTION

Guy Hengel [angelIII / a3]

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

Mr_Shaw

5/18/2011

ASKER

>>no: you need to consider searching in a "circle" around the long/lat, which is a "simple" math expression

Do you know of any examples?

SOLUTION

Guy Hengel [angelIII / a3]

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

SOLUTION

Anthony Perkins

5/18/2011

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

⚡ FREE TRIAL OFFER

Try out a week of full access for free.

Find out why thousands trust the EE community with their toughest problems.

Mr_Shaw

5/25/2011

ASKER

thanks

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat

Plans and Pricing

Certified Expert Program

Credly Partnership

Udemy Partnership