AnsweredAssumed Answered

arc-jsapi How can I st_geometry using a lookup field?

Question asked by guriguri1576 on Jun 13, 2016
Latest reply on Jun 14, 2016 by guriguri1576

I am using the st_geometry field and try to view the PNU code value.



I tried two ways.



1. oracle DB query.



    select a.pnu from LP_PA_CBND_4600000000 a  

    where sde.st_contains(a.shape,

    sde.st_point(177566.6728471977,160430.12935426735, 4))=1



When an event occurs, click the map object

i got the  evt.mapPoint(x,y).

4 is my srid.

this way is took a long time. and query was down...



2. i used the arcgis api`s IdentifyParameters



my code is follows.






      PoiClick : function(map, evt) {

        G_evt =evt;

        console.log("ClickPoint ==== "+evt.mapPoint);

        var targetLayerId = 'LP_PA_CBND';

        var url = map.Layers.getLayerInfo(targetLayerId).SVC_URL;

        var map = map.getMap();

        //파라미터 설정.

        var idParams = new krcgis.core.tasks.IdentifyParameters();

        G_idparams =idParams;

        idParams.geometry = evt.mapPoint;

        idParams.mapExtent = map.extent;

        idParams.returnGeometry = true;

        idParams.tolerance = 3;

        idParams.layerOption = krcgis.core.tasks.IdentifyParameters.LAYER_OPTION_ALL;

        idParams.width = map.width;

        idParams.height = map.height;


           krcgis.Function.GetPoiInfo(url, idParams);

           return evt.mapPoint;



        //POI 정보를 가져온다.

        GetPoiInfo : function(url, idParams) {

         idTask = new krcgis.core.tasks.IdentyfyTask(url);




        .addCallback(function (response) {

               G_response = response;

        if (response) {

        return response;




        .addErrback(function (error) {

        console.log('GetPoiInfo result error=', error);





It could be obtained in this way code pnu.



However, this way is different from the value that gets pnu code depending on the zoom level.



I want to get a single pnu code in a single x, y values.



how to get pnu code? 



Database table  :