span8
span4
是否有人能够推荐在FME工作区中使用本地地理编码程序批量处理地理编码地址的最佳方法?
Ideally I want to read addresses stored in sql server table,use HTTPCaller to call the service and output returned coordinates plus address and uid to another
SQL Server表。
Is it possible to do it this way?
If you want to include an attribute value in the URL you shoud use @Value(attribute_name) instead of @attribute_name,maybe that's the cause.
Another thing to keep in mind is that you'll be hitting the service once per record,so you may need to slow things down by using a Decelerator (the GoogleGeocoder needs this for example,as it's metered,your own service may not be)
Thanks@david_ryes it is an internal geocoder (composite locator published with ArcGIS for Server) with REST based API.I will look at the GoogleGeocoder,thanks for the tip ;)
I'm trying to figure out the correct way to pass the addresses into the httpCaller from the table,it works fine when I use a query string with address data in request url field like this
http://mylocalserver.mydomain.com:6080/arcgis/rest/services/Locators/LocalComposite/GeocodeServer/Geocodeaddresses?addresses={"records":[{"attributes":{"OBJECTID":1,"address":"1231
Market Street","city":"San Francisco","ZIP":"94115"}},{"attributes":{"OBJECTID":2,"address":"2435 California Street","city":"San Francisco","ZIP":"94115"}}]}&outSR=&f=pjson
That gives me an x and y coordinate in the output attribute that I would have to extract somehow.
But I need to pass in thousands of addresses so tried this
and use httpCaller query string parameters to map my table fields to the service attributes
or do it like this
This does connect with the service but no output is returned,am I missing a step somewhere or just not configuring httpCaller correctly!!?
Hi
Sure,that should work just fine.I'm not sure what you mean about using a "local geocoder",but if you've got your own internal geocoder with a REST-based API,it should be fairly easy.If it's based on SOAP services it will be a bit more complicated,but still doable if you're not afraid of tackling some XML.
There are also a couple of custom transformers in FME that you could download and look at for inspiration,e.g.theGoogleGeocoder.
David
© 2019 亚搏在线Safe Software Inc |Legal