+ Reply to Thread
Results 1 to 7 of 7

Large database has x and y coordinates that are unknown to me

  1. #1
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Large database has x and y coordinates that are unknown to me

    I have looked and looked and looked for a conversion for these sample x & y numbers attached. They are locations in McKinney Tx.
    Has anyone seen these types before? If so, did you find a way to convert to lat and long?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Large database has x and y coordinates that are unknown to me

    Not familiar with this myself, but I put "geox geoy meaning" into my favorite internet search engine, which led me to "state plane coordinate" systems: https://en.wikipedia.org/wiki/State_...rdinate_System
    https://www.ngs.noaa.gov/TOOLS/spc.shtml
    http://www.earthpoint.us/StatePlane.aspx
    http://resources.arcgis.com/en/help/...0043000000.htm

    That's as far as I went with it. Is that a possibility?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Re: Large database has x and y coordinates that are unknown to me

    I tried the ones you showed but could not get any to work. However, I did find one coordinate that I pulled from an address and then used Google Earth to find the lat and long. Here is what I did find.

    Geox Geoy Lat Long
    253704650 713336950 33.22873 96.6400782

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: Large database has x and y coordinates that are unknown to me

    I'm not sure what to recommend, as I am not familiar with these different geographic coordinate systems. I don't know if anyone on this forum dabbles in this kind of stuff. If not, it may be preferable to talk to someone who is familiar with the different geographic coordinate system used in Texas.

  5. #5
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Re: Large database has x and y coordinates that are unknown to me

    Yes, I will do that. I have sent an email to the Civil Engineering Dept of the city and ask for their help.

    thanks again, blessings, ><>

  6. #6
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Large database has x and y coordinates that are unknown to me

    They look like some sort of UTM coordinates. If that's the case, you'll need to find out what UTM zone they are from.
    From https://www.expertgps.com/convert-coordinates.asp:
    Universal Transverse Mercator (UTM) coordinates are used worldwide. Unlike lat/lon, which is a spherical coordinate system based on angles, UTM, state plane, and national grid coordinates are rectangular grid systems where coordinates are expressed as Northings and Eastings from a fixed reference point. Rectangular grids make it much easier to calculate distances and to plot locations on a rectangular map. UTM coordinates look like this: 2346212N, 12343523E, 18T. The first value is the Northing. The second is the Easting. The third value (always a number between 1 and 60 followed by a single letter) is the UTM zone identifier. If your data is in UTM coordinates, it is very likely in NAD27 datum or WGS84 datum (see below). The vast majority of UTM data is expressed in meters. If you are using UTM data collected prior to 1983 by a US state entity, there's a chance that it uses US Survey Feet rather than meters as the base unit.
    If you can't find the zone, it might be possible to work backwards to get the reference point by taking known points and comparing their geox/geoy with Lat/Long - but it would not be quick or simple.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  7. #7
    Forum Contributor
    Join Date
    03-06-2015
    Location
    houston, tx
    MS-Off Ver
    MS 365
    Posts
    494

    Re: Large database has x and y coordinates that are unknown to me

    Found the answer. The numbers should look like this:
    2537046.50 7133369.50

    The last two numbers should have a leading "."
    This is the NAD 83, 4202 NORTH CENTRAL TEXAS AREA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 07-10-2017, 02:20 AM
  2. Replies: 1
    Last Post: 02-16-2012, 07:24 AM
  3. Large Database
    By jwaldmann in forum Excel General
    Replies: 4
    Last Post: 02-10-2012, 10:52 PM
  4. how to sum(group) a large database
    By Sparxx in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-24-2009, 12:53 PM
  5. Convert point coordinates -> pixel coordinates
    By Zorro in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2006, 10:30 PM
  6. VBA lookup into large database
    By erikhs in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-29-2006, 02:36 PM
  7. [SOLVED] Navigating a large database?
    By Arsenio Oloroso in forum Excel General
    Replies: 3
    Last Post: 11-11-2005, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1