SRID for WS84 Web mercator aux sphere?

Question

Hi,

I've received some ESRI biz data in CSV format and I'm trying to create a SQL Server spatial layer with it before I query it down to more manageable datasets.  The CSV file contains lat long coordinates that are in WGS 84 Web Mercator Auxilary Sphere.  I want to import the data into sql and create a geometry field with the coordinates but can't seem to find any reference to the SRID I would use to convert the lat long to geometry.

I eventually want the data to land in SRID 4326 .  Do I even need to reproject it?  What SRID should I use to bring it into SQL Server geometry?

thanks in advance

Jamie

AdamZiegler1 · Answer

Hi Jamie - I think GSCUser85‌ was hitting this right earlier. Those are geographic coordinates. It would appear that your data is already in WGS 84, i.e. SRID 4326.

-Adam Z

JamiePortolese · Answer

The coordinates are (for example) -97 longitude, 26 latitude (they are from Texas).  I think this points to my misunderstanding of Lat Long coordinates in general.  I normally work in projected coordinate systems and only recently started doing a lot with lat long values.

JamiePortolese · Answer

Using that as the SRID to create a geometry field, when I add the table to arcmap, it places the points in meters and not decimal degrees like I would expect.  Perhaps I'm not understanding things.  If I'm given lat long values are the values specific to the web Mercator  auxiliary sphere projection or should they be imported as geographic?  I'm having a hell of a time trying to line things up with my other data that's already in Geographic wgs84 SRID 4326.