Query a feature layer (SQL)

A feature layer can contain a large number of features. To access a subset of the features, you can execute a SQL or spatial query, or both at the same time. You can also return the attributes, geometry, or both attributes and geometry for each record. SQL and spatial queries are useful when a feature layer is very large and you just want to access a subset of the data.

In this tutorial, you access and query a hosted feature layer with a SQL where clause and only return the first record.

Prerequisites

Steps

Create a new pen

1. If you are using the CDN libraries, use this pen to get started.

Get an API Key

To access location services, you need an API key or OAuth 2.0 access token. To learn how to create and scope your key, visit the Create an API key tutorial.

1. Go to your dashboard to get an API key. The API key must be scoped to access the services used in this tutorial.
2. In CodePen, update apiKey to use your key.

Make the request

Copy and paste the code below, following the steps to make a request to the feature service.

1. Reference the ArcGIS REST JS libraries either through CDN, ES Modules, or Node JS.

2. Set the apiKey with the API key from your dashboard.

3. Define the parameters needed for the request.

4. Call the feature service and handle the results.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
    <!-- require ArcGIS REST JS libraries from https://unpkg.com -->
    <script src="https://unpkg.com/@esri/arcgis-rest-request@4.0.0/dist/bundled/request.umd.js"></script>
    <script src="https://unpkg.com/@esri/arcgis-rest-feature-service@4.0.0/dist/bundled/feature-service.umd.js"></script>
    <script>
      /* when including ArcGIS REST JS all exports are available
    from the same arcgisRest global */

      const apiKey = "YOUR_API_KEY";

      const authentication = arcgisRest.ApiKeyManager.fromKey(apiKey);

      arcgisRest
        .queryFeatures({
          url: "https://services3.arcgis.com/GVgbJbqm8hXASVYi/arcgis/rest/services/LA_County_Parcels/FeatureServer/0",
          where: "UseType = 'Residential'",
          resultRecordCount: 1,
          authentication
        })
        .then((response) => {
          console.log(response.features);
          document.getElementById("result").textContent = JSON.stringify(response.features, null, 2);
        });

    </script>

Result

Below is the response from the service:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
[
  {
    "attributes": {
      "OBJECTID": 52,
      "AIN": "2004001003",
      "APN": "2004-001-003",
      "SitusHouseNo": "8321",
      "SitusFraction": " ",
      "SitusDirection": " ",
      "SitusUnit": " ",
      "SitusStreet": "FAUST AVE",
      "SitusAddress": "8321 FAUST AVE",
      "SitusCity": "LOS ANGELES CA",
      "SitusZIP": "91304-3327",
      "SitusFullAddress": "8321 FAUST AVE LOS ANGELES CA 91304",
      "TaxRateArea": "00016",
      "TaxRateCity": "LOS ANGELES",
      "AgencyClassNo": null,
      "AgencyName": null,
      "AgencyType": null,
      "UseCode": "0101",
      "UseCode_2": "01",
      "UseType": "Residential",
      "UseDescription": "Single",
      "DesignType1": "0131",
      "YearBuilt1": "1973",
      "EffectiveYear1": "1973",
      "Units1": 1,
      "Bedrooms1": 4,
      "Bathrooms1": 3,

What's next?

Learn how to use additional ArcGIS location services in these tutorials: