Location Geocode

Question

I mapping all the organizations in or sandbox.
Here is a snippet of the code:
def organizationBridge = Bridges.getOrganizationBridge();
def locationBridge = Bridges.getLocationBridge();
def orgResults = organizationBridge.find(new OrganizationCriteria());
def orgs = orgResults.getOrganizations();
def locations;
def locationRef;
def location;
try{
    orgs.each() {
        locations = it.getLocations();
        locSize = locations.size() ?: 0;
        if (locSize > 0){
            locationRef = locations.get(0);
            location = locationBridge.findById(locationRef.getSystemId());
            geocode = location.getGeocode() ?: "0,0";
            geocodeList = Arrays.asList(geocode.split("\s*,\s*"));
            row.put("Latitude", geocodeList.get(0));
            row.put("Longitude", geocodeList.get(1));
        }
        rows.push(row);
        row = new HashMap();
    }
}catch(Exception e)
{
    bSuccess = false;
}
 
Sometime getGeocode() returns a null.
How does the system know the geocode of the address?
Is there a way to refresh or update the geocodes?
Thanks
Jay

jw614h · Accepted Answer

I figured out how to accomplish this from the API doc

You need to pass in the Organization ID(orgId) and the new geocode(newgeocode as lat,long) :


import groovy.json.JsonBuilder;

import groovy.json.JsonSlurper;

import com.axeda.sdk.v2.dsl.Bridges;

import com.axeda.sdk.v2.bridge.LocationBridge;

import com.axeda.services.v2.LocationCriteria;


HashMap root = new HashMap();

List rows = new ArrayList();

HashMap row = new HashMap();


def organizationBridge = Bridges.getOrganizationBridge();

def org = organizationBridge.findById(parameters.orgId);

def locationBridge = Bridges.getLocationBridge();

locations = org.getLocations();

locSize = locations.size() ?: 0;

row.put("ClientId", org.getSystemId());

row.put("ClientName", org.getLabel());

if (locSize > 0){

    locationRef = locations.get(0);

    location = locationBridge.findById(locationRef.getSystemId());

    geocode = location.getGeocode() ?: "0,0";

    geocodeList = Arrays.asList(geocode.split("\\s*,\\s*"));

    if (geocodeList.get(0) == "0.0" ){

        row.put("update", true);

        location.setGeocode(parameters.newgeocode);

        locationBridge.update(location); 

    }

}

root.put("success", true);

root.put("Client", row);

JsonBuilder builder = new JsonBuilder(root);

return ["Content-Type": "application/javascript","Content":builder.toPrettyString()]

cdovholuk · Answer

First - if you import the Bridges object statically you can stop def'ing the bridges. I always start my v2 scripts like this:


import static com.axeda.sdk.v2.dsl.Bridges.*

Then you can simply call 'assetBridge' or 'modelBridge' or whatever bridge you're looking for. I would replace this:


def organizationBridge = Bridges.getOrganizationBridge();

def locationBridge = Bridges.getLocationBridge();

with just that import - it'll work just the same!

As for the .getGeocode() - that *ever* works? I looked at the object and I don't see a method called getGeocode on the v2 location object at all

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.