topic Re: Getting an error when trying to do a query in esri-leaflet in Open Source Mapping Libraries Ques.

Getting an error when trying to do a query in esri-leaflet

joepublic — Mon, 28 Aug 2023 13:52:05 GMT

I am trying to created an app that when you click on a button at the top of the page will display only the countries that will satisfy the query attached to the button (see bottom of the file attached).

Here is the snippet of the code:

$('#NSM').click(function(){

var buttonType = document.getElementById('NSM');

countries.setWhere('type="'+ buttonType.value + '"');

});

I am using the "querying features #2" as my template.

The error I'm getting is

{"error":{"code":400,"message":"Unable to complete operation.","details":["Attribute column not found [Microsoft SQL Server Native Client 11.0: Invalid column name 'NSM'.] [MEP_global_data.DBO.test_bdry]"]}}

Any help would be appreciated

Thanks

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Fri, 12 Sep 2014 17:57:43 GMT

the error says you have no field named NSM. Is there a property named NSM in the data?

What does the HTML for the button look like?

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Fri, 12 Sep 2014 18:01:53 GMT

and the country value is in a field named type? What does the data table look like? what is the field holding the country?

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Fri, 12 Sep 2014 18:33:02 GMT

Here is the url

"http://dev.consciousglobalchange.org/arcgis/rest/services/MEP/noRelate_tester/FeatureServer/0

The column name is "type" the value is NSM

Let me know if you need any more information

Chris

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Fri, 12 Sep 2014 18:59:00 GMT

try setWhere(" type like 'nsm' ").

ArcGIS REST Services Directory

Home > services > MEP > noRelate_tester (FeatureServer) > MEP_global_data.DBO.test_bdry > query

Help | API Reference

Query: MEP_global_data.DBO.test_bdry (ID: 0)

# records: 6

type: NSM

Polygon:

[-1.05925448094E7, 6331610.610799998] , [-1.05925143079E7, 6337259.6477999985] , [-1.05923596851E7, 6339015.385300003] more...

[-1.74327857678E7, 1.1523017382700004E7] , [-1.74324155192E7, 1.15212753389E7] , [-1.74266945879E7, 1.1507461465899996E7] more...

[-1.70654633969E7, 7965857.698700003] , [-1.70644136541E7, 7967666.887500003] , [-1.70635779787E7, 7968250.298199996] more...

[-1.91074667251E7, 9277683.944799997] , [-1.91073749979E7, 9276497.047700003] , [-1.91068790695E7, 9273703.769900002] more...

[-1.4875929794599999E7, 7612574.983099997] , [-1.4875929794599999E7, 7613688.5315999985] , [-1.4873456720800001E7, 7628072.728600003] more...

[-1.51547280122E7, 8013438.626999997] , [-1.5154136794300001E7, 8014083.521700002] , [-1.51351838718E7, 8009271.293399997] more...

[-1.8491374124E7, 8490460.355300002] , [-1.84912484443E7, 8489146.592200004] , [-1.84870155207E7, 8473950.735399999] more...

[-1.5023646974E7, 8052052.3552] , [-1.5023307227E7, 8053469.133299999] , [-1.5022131804499999E7, 8053527.569499999] more...

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Fri, 12 Sep 2014 19:19:41 GMT

$('#NSM').click(function(){

var buttonType = document.getElementById('NSM');

countries.setWhere('type like"'+ buttonType.value + '"');

});

Didn't work... Got the same error: .... Invalid column name 'NSM'.

It thinks the column name is NSM instead of type

This is what I see in google's developers tool:

geometryType:esriGeometryEnvelope
geometry:{"xmin":-180.09,"ymin":11.50500000000001,"xmax":-0.08999999999999009,"ymax":85.95612673286779,"spatialReference":{"wkid":4326}}
outFields:*
outSR:4326
inSR:4326
where:type like"NSM"
f:json

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Fri, 12 Sep 2014 19:43:59 GMT

the field is type and the value is NSM. I got that error when I had NSM wrapped in double quotes

when I type like 'NSM' I get the results as expected.

you can use = too but has to be single quotes around NSM.

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Fri, 12 Sep 2014 19:58:52 GMT

got it.

Here is my code. No Jquery.

<!DOCTYPE html>

<html>

<head>

<style>

html, body, #map {

width : 100%;

height : 100%;

}

</style>

</head>

<body>

<button onclick="NSM()">NSM</button>

var you;

//var map = L.map('map');

var map = L.map('map').setView([35.10418,-106.62987], 13);

L.tileLayer('http://{s}.tile.osm.org/{z}/{x}/{y}.png',{opacity:.4}).addTo(map);

map.locate({watch:true, setView: false ,maxZoom: 16,enableHighAccuracy:true});

var nsm = new L.esri.FeatureLayer("http://dev.consciousglobalchange.org/arcgis/rest/services/MEP/noRelate_tester/FeatureServer/0");

var popupTemplate = "<h3>{type}</h3>";

nsm.bindPopup(function(feature){

return L.Util.template(popupTemplate, feature.properties)

});

function NSM(){

nsm.setWhere("type like "+ "'NSM'");

nsm.addTo(map);

}

</script>

</body>

</html>

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Sun, 14 Sep 2014 17:39:57 GMT

Paul,

Using the single quotes worked!!

I made some changes similar to the code you posted above so that the tilemap is displayed initially.

When you click on the button the countries that satisfy the query are over-layed on the map

Now I am getting the following error: Uncaught TypeError: Cannot read property 'getBounds' of undefined

$('#NSM').click(function(){

var buttonType = document.getElementById('NSM')

countries.setWhere("type like "+"'"+buttonType.value+"'");

countries.addTo(map); <- placing this line here causes the error

});

Link to demo: Esri Leaflet Demo

Can you tell me what I'm doing wrong??

Thanks

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Mon, 15 Sep 2014 14:29:25 GMT

I got the same error. It was because I was not running the sample on a server, but from my desktop. You have to run the code from a webserver or it will not work. Could that be what is happening when you run it?

I ran it from my server and it worked perfect. Had the countries and when I clicked them they turned red and data was on the right side of screen.

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Mon, 15 Sep 2014 15:00:46 GMT

Hmmm...

I am running it on a esri webserver installed on an AWS virtual machine.

countries.addTo(map); <- placed outside the click function

$('#NSM').click(function(){

var buttonType = document.getElementById('NSM')

countries.setWhere("type like "+"'"+buttonType.value+"'");

});

The above "works" but it creates the a layer of ALL the countries BEFORE the setWhere works

see link: Add Map

But I want to create the layer only AFTER you click on the button with the countries that satisfies the query.

Chris

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Mon, 15 Sep 2014 15:14:44 GMT

Don't preload the layer. Load the basemap then add the layer using the where option - NOT the setWhere() method.

$('#NSM').click(function()

{

var buttonType = document.getElementById('NSM');

var countries = new L.esri.featureLayer(featureURL,

{

style: getStyle,

onEachFeature: onEachFeature,

where: "type like"+"'"+buttonType.value+"'"

}).addTo(map);

});

If you will have lots of buttons, then make a function loadLayer() and pass the buttontype value. then you only need to add the code for the layer once.

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Mon, 15 Sep 2014 15:16:08 GMT

Loading the full layer is really slow on my machine. Preloading it is not making setWhere() and faster than if you just load the layer with where option onclick. I think loading using where is faster by a lot.

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Mon, 15 Sep 2014 16:25:39 GMT

Paul,

Your suggestions worked great!!

The new issue I have is with my mouseout:resetHighlight

resetHighlight(e){

countries.resetStyle(e.target);

}

Is not recognizing the "countries" object since Iam now creating the instance inside of the click function.

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Mon, 15 Sep 2014 17:27:54 GMT

I think there is something wrong with the e.target - it is an object and you need to pass and ID to the resetStyle() method.

I added

var countries;

as the first line after the <script> tag. Delete the var in the onclick button function.

Then where you have resetStyle(), I put this instead:

countries.setStyle(getStyle());

Works. Code is as simple as ResetStyle() because I am just recalling your original style function.

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Mon, 15 Sep 2014 18:57:12 GMT

Make countries a global variable worked

I do have multiple buttons and what to clear the countries from the

previous button click...

Any suggestions??

Re: Getting an error when trying to do a query in esri-leaflet

PaulCrickard1 — Mon, 15 Sep 2014 19:10:45 GMT

Use map.removeLayer(). In each buttons function, before you add a layer, check to see if the other layers are on and turn them off if they are. then load your layer for the button.

if(map.hasLayer(countries)){

map.removeLayer(countries);

countriesABC = new L.esri.featureLayer(featureURL-ABC, { style: getStyle, onEachFeature: onEachFeature,where: "type like"+"'"+buttonType.value+"'"

}).addTo(map);

}

else {alert("aint got it");}

Re: Getting an error when trying to do a query in esri-leaflet

joepublic — Mon, 15 Sep 2014 19:44:00 GMT

Paul,

Everything looks good!!

Thanks for the help!!

Chris

Where:
Object IDs:
Time:
Input Geometry:
Geometry Type:
Input Spatial Reference:
Spatial Relationship:
Relation:
Out Fields:
Return Geometry:	True False
Max Allowable Offset:
Geometry Precision:
Output Spatial Reference:
Geodatabase Version Name:
Return IDs Only:	True False
Return Count Only:	True False
Order By Fields:
Group By Fields (ForStatistics):
Output Statistics:
ReturnZ:	True False
ReturnM:	True False
Format: