Can SQL 2008 Geospatial data give me Country,State,city info?

I don't know SQL Geospatial new feature.

I'm wondering if I can use to make something lik开发者_StackOverflow中文版e:

• Map a point in a world map
• Know the country the point is located
• The points location state, and the city.
• Measure how much deliveries I have per state.
• Can all of this be done to a geometry form like a rectangle?

I mean can I make and app that allows you to insert delivery locations on a map and then make some BI analysis on this info?

Are the types Geometry and Geography suited for this? Thanks in advance.

You could store the point in SQL Server, and the geographic extensions can do things like handle polygons and testing the points for being in the polygons.

Without a database of state,city,etc polygon definitions, you will need a Geocoding service. Eg. One of the Bing Maps web services, or a desktop solution such as MapPoint.