Ik probeer een app te maken waarbij, wanneer je op een knop bovenaan de pagina klikt, alleen de landen worden weergegeven die voldoen aan de query gekoppeld aan de knop (zie onderaan het bijgevoegde bestand). Hier is het codefragment: $('#NSM').click(function(){ var buttonType = document.getElementById('NSM'); countries.setWhere('type="'+ buttonType.value + '"'); }); Ik gebruik de "querying features #2" als mijn sjabloon. De fout die ik krijg is {"error":{"code":400,"message":"Kan bewerking niet voltooien.","details":["Attribuutkolom niet gevonden [Microsoft SQL Server Native Client 11.0: Ongeldige kolomnaam 'NSM'.] [MEP_global_data.DBO.test_bdry]"]}} Alle hulp wordt gewaardeerd Dank je wel

Paul, Everything looks good!! Thanks for the help!! Chris

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");}

Make countries a global variable worked I do have multiple buttons and what to clear the countries from the previous button click... Any suggestions??

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Foutmelding bij het proberen een query uit te voeren in esri-leaflet

joepublic

Ik probeer een app te maken waarbij, wanneer je op een knop bovenaan de pagina klikt, alleen de landen worden weergegeven die voldoen aan de query gekoppeld aan de knop (zie onderaan het bijgevoegde bestand).<\/P>

<\/P>

Hier is het codefragment:<\/P>

<\/P>

$('#NSM').click(function(){<\/P>

var buttonType = document.getElementById('NSM');<\/P>

countries.setWhere('type="'+ buttonType.value + '"');<\/P>

});<\/P>

<\/P>

Ik gebruik de "querying features #2" als mijn sjabloon.<\/P>

<\/P>

De fout die ik krijg is<\/P>

{"error":{"code":400,"message":"Kan bewerking niet voltooien.","details":["Attribuutkolom niet gevonden [Microsoft SQL Server Native Client 11.0: Ongeldige kolomnaam 'NSM'.] [MEP_global_data.DBO.test_bdry]"]}}<\/P>

<\/P>

Alle hulp wordt gewaardeerd<\/P>

<\/P>

Dank je wel<\/P>

Vind meer berichten getagd met

Esri Leaflet

Accepted answers

All comments

joepublic

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

PaulCrickard1

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.

joepublic

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

PaulCrickard1

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>

joepublic

$('#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

PaulCrickard1

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)

Where:
Object IDs:
Time:
Input Geometry:
Geometry Type:	Envelope Point Polyline Polygon Multipoint
Input Spatial Reference:
Spatial Relationship:	Intersects Contains Crosses Envelope Intersects Index Intersects Overlaps Touches Within Relation
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:	HTML JSON AMF

# 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...

joepublic

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

PaulCrickard1

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

PaulCrickard1

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?

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.