Abhinay Malipeddi


SQLServerCentral Article

Determining Whether Home Addresses Fall Within a Tornado Polygon Using Spatial Functions

Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.

5 (2)

You rated this post out of 5. Change rating

2025-03-04 (first published: )

2,437 reads

Blogs

CHOOSE’ing a Beer: #SQLNewBlogger

By

We recently published an article on CHOOSE at SQL Server Central. I thought it...

Don’t Treat Your Data Catalog Like a Data Museum

By

Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...

The trade-offs associated with low-code solutions

By

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Read the latest Blogs

Forums

SQL availability group and file server role answering from the same name

By bill-humphrey

Hello, I'm tasked with setting up a 2 node server cluster that will host...

DbaTools With Powershell - Omit The Id Column on CSV Export?

By cajun_sql

I am learning DbaTools in Powershell, and my current project is exporting a CSV...

Visit the forum

Question of the Day

Replacing a Null

What is returned from this code in SQL Server 2022?

DECLARE @value INT = NULL;
SELECT ISNULL(@value, 100.5) AS Result;

See possible answers