In order to do some quick analysis using SQL spatial, I'd like to generate spatial objects using the STGeomFromText / ST_GeomFromText function.
With point data, I can do this by geocoding an address and using desktop GIS to give me the X/Y, which I then turn into a point using a syntax like this:
declare @xyPoint geometry; set @xyPoint = geometry::STGeomFromText('Point(3175288.989 1711307.592)', 2232);
(This will create a temporary point geometry at the X,Y coordinates above in the 2232 (CO State Plane Central coordinate system)... I can then use the temporary point to drive distance calculations, etc.)
My question: is there a way to do something similar with a polygon: maybe draw a graphic in a desktop GIS map (ArcMap, QGIS, etc.), get the WKT from that graphic, which I can then use in a query to create a polygon object using the STGeomFromText function?
Basically, this is the opposite of the Quick Draw plugin for QGIS