Help with geocoding

5922
14
05-21-2015 09:05 AM
Labels (1)
ELTerrell
New Contributor III

Hi,

I just added a spreadsheet of 7 different points. I used GPS Visualizer: Free geocoders: Convert addresses to GPS coordinates to geocode my addresses (city halls).  4 of the 7 when placed on the map, were mapped correctly. The other three were waaaay north of the county I'm mapping.  I used Geographic Coordinate System:   Name: GCS_WGS_1984  to add my xy data.  Does anyone have any suggestions as to how/why this happened and how I can fix it?  Thanks so much.

Tags (1)
0 Kudos
14 Replies
StevenGraf1
Occasional Contributor III

Did you personally check those 3 that were incorrect?  I have a feeling the Address to XY tool you used didn't return the correct coordinates.

Steven

JoeBorgione
MVP Emeritus

I'm with Steve, but would add: Is it possible that the addresses that are mis-matched actually valid in the space they fall?  For example, are there more than one 1234 Main St addresses in your vicinity?

That should just about do it....
ELTerrell
New Contributor III

Not sure if those streets are locating on an appropriate place elsewhere, it's pretty far away from my county.  When you geocode using that website, it will show you a map of where the point lies.  Looking at it for all 3 addresses, there are in the correct location.  I've also used another geocoding website to double check.  I wasn't sure if it was GIS or the geocode that was messing up but that seems to make it seem like it's GIS, not the geocode site.

0 Kudos
ELTerrell
New Contributor III

actually, looking at the streets baselayer, the streets it located on isn't even close.  I'm in NC and it puts the 3 addresses in WV.  If it helps, the addresses are:    

239.783730-80.839782Huntersville101 Huntersville-Concord Rd, Huntersville,
  NC 28078
439.783730-80.849961Davidson216 S. Main St, Davidson, NC 28036
639.783730-80.718555Matthews232 Matthews Station St, Matthews, NC 28105
0 Kudos
StevenGraf1
Occasional Contributor III

Here's what I got when I put those in to the geocoder you listed:

latitude,longitude,name,desc,color,source,precision

39.78373,-100.445882,"101 Huntersville-Concord Rd, Huntersville,  NC 28078",US,,MapQuest Open,country

35.497836,-80.849496,"216 S Main St, Davidson, NC 28036","216 South Main Street, Davidson, Mecklenburg County, NC, US",,MapQuest Open,address

35.117336,-80.72053,"232 Matthews Station St, Matthews, NC 28105","Matthews Station Street, Matthews, Mecklenburg County, NC, US",,MapQuest Open,street

StevenGraf1
Occasional Contributor III

Looks like it can't find 232 on the last address so it's defaulting to the street name.  They most likely don't have a sufficient address range in their data that is valid for 232.

Steven

ELTerrell
New Contributor III

Ok, those coordinate have finally worked except for the Huntersville coordinates.  That one is in Kansas. 

StevenGraf1
Occasional Contributor III

Ya, it looks like it can't find any part of the address so it's throwing it in the middle of the US.

ELTerrell
New Contributor III

I played with the source (bing maps v. mapquest open) feature on that site.  Using different sources produces pretty different x coordinates.  Using one gives -100, another gives -80.  Even with the -80 (similar x coordinate to the other addresses), it still puts it up on WV.  Very odd.

0 Kudos