New user here - thanks in advance for the help! I'm trying to use Coordinate Extractor to populate XY from address but not having any luck. Any suggestions?
Thanks in advance.
New user here - thanks in advance for the help! I'm trying to use Coordinate Extractor to populate XY from address but not having any luck. Any suggestions?
Thanks in advance.
Hi @keb9113
Let me know if I did understand your case.
What Source do you have?
Could you share us you data?
Thanks,
Danilo
I have a csv file with ~1k records of combined address (addr+csz) and broken out address:
Orig Address City State Zip 10 Richmond Dr West Chester, OH 45069 10 Richmond Dr West Chester OH 10041 Bolingbroke Dr Cincinnati, OH 45241 10041 Bolingbroke Dr Cincinnati OH 10045 Windisch Rd West Chester, OH 45069 10045 Windisch Rd West Chester OH 10045 Windisch Rd West Chester, OH 45069 10045 Windisch Rd West Chester OH 10045 WINDISCH RD,West Chester,OH,45069 10045 WINDISCH RD West Chester OH 10085 Mosteller Ln West Chester, OH 45069 10085 Mosteller Ln West Chester OH 10099 DAYCREST DR,West Chester,OH,45069 10099 DAYCREST DR West Chester OH 10100 Windisch Rd West Chester, OH 45069 10100 Windisch Rd West Chester OH 10111 Cliffwood Ct Cincinnati, OH 45241 10111 Cliffwood Ct Cincinnati OHAssuming you have point geometries, these are the correct settings for the CoordinateExtractor:
Assuming you have point geometries, these are the correct settings for the CoordinateExtractor:
Have a look at the GeoCoder transformer
I have a csv file with ~1k records of combined address (addr+csz) and broken out address:
Orig Address City State Zip 10 Richmond Dr West Chester, OH 45069 10 Richmond Dr West Chester OH 10041 Bolingbroke Dr Cincinnati, OH 45241 10041 Bolingbroke Dr Cincinnati OH 10045 Windisch Rd West Chester, OH 45069 10045 Windisch Rd West Chester OH 10045 Windisch Rd West Chester, OH 45069 10045 Windisch Rd West Chester OH 10045 WINDISCH RD,West Chester,OH,45069 10045 WINDISCH RD West Chester OH 10085 Mosteller Ln West Chester, OH 45069 10085 Mosteller Ln West Chester OH 10099 DAYCREST DR,West Chester,OH,45069 10099 DAYCREST DR West Chester OH 10100 Windisch Rd West Chester, OH 45069 10100 Windisch Rd West Chester OH 10111 Cliffwood Ct Cincinnati, OH 45241 10111 Cliffwood Ct Cincinnati OH
Hi @keb9113,
This article: https://knowledge.safe.com/articles/56486/converting-from-csv-data-2.html explains some different methods for converting CSV to spatial data.
Since your dataset is currently stored as an address feature it does not yet have any spatial geometry so you will not be able to use the Coordinate Extractor because this transformer requires existing spatial geometry and simply pulls the X and Y values out into attributes.
Instead as mentioned by @erik_jan and @danilo_fme you will need to use the Geocoder to convert each address into a point, which is method 3 in the linked article. You should be able to use your full address attribute with the mode set to 'Forward' and this will create a lat and long attribute for each address. There are a number of different Geocoding Services available which require different levels of authorization.
Hi @keb9113,
As @erik_jan mentioned, you'll want to use the Geocoder using the OpenStreetMap Geocoding Service in the Forward Mode - you can either set the Street Address parameter to the Orig attribute or build the address from multiple attribute values in the Text Editor.
Two things to note:
I've attached a sample workspace that geocodes 5 addresses (4 successfully, 1 fails), and an attribute remover to get rid of unwanted attributes that are created by the Geocoder
I hope this information helps.
- Chris
I truly appreciate the help! I thought I had done something (else) wrong so I started from scratch.
I've pulled in another file that has lat/long populated (via geocoder) and tried the Coordinate Extractor; however, it populates X/Y with nan. Sorry, just not sure what I'm missing.
I truly appreciate the help! I thought I had done something (else) wrong so I started from scratch.
I've pulled in another file that has lat/long populated (via geocoder) and tried the Coordinate Extractor; however, it populates X/Y with nan. Sorry, just not sure what I'm missing.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.