![]() ![]() Right click the spreadsheet under table of content just shown below and click Display XY Data. Locate the excel file you just downloaded (with coordinates) and add the spreadsheet to the map (NOTE: usually the file have multiple spreadsheets in them, just click the first one). (I assume that it is the geometry type you are using, not the geography datatype. Click the Add Data Button located on the toolbar 6. If you want to obtain the WKB representation of a geometry, you need to use the STAsBinary() method. To answer the second(?) question, the SQL native geometry and geography datatypes are NOT WKB - they are a custom binary format that is similar to, but different from WKB. (I assume that it is the geometry type you are using, not the geography datatype.) Your best bet is to use a dedicated tool such as Safe FME (to do it. The bad news? Neither Virtual Earth nor SQL Server 2008 provide the ability to reproject spatial data. To get it back to latitude/longitude, you need to unproject it. This projection, unsurprisingly, is designed to display features in the state of Michigan with the minimal amount of distortion. If you have data expressed using X and Y coordinates obtained from the State of Michigan center for geographic information () then I'm guessing it's been projected using the Michigan State Plane Coordinate System. There are thousands of different sorts of projection, each designed to minimise distortion for a different purpose. Now, you cannot perfectly flatten a curved surface onto a flat plane without some form of distortion. This means that, once projected, you can refer to positions using Cartesian X, Y coordinates rather than Latitude and Longitude. Projection is the process of creating a flat map from a curved model of the Earth's surface. However, in general we want maps to be flat. Angular coordinates are very useful for describing positions on a sphere (or near-sphere), like on the Earth's surface. ![]() Latitude and Longitude are angular coordinates, measured from the centre of the Earth. What you are describing is the process of 'projection' (or, specifically, 'reprojection').
0 Comments
Leave a Reply. |