Filter a hosted table
GET https://services3.arcgis.com/GVgbJbqm8hXASVYi/arcgis/rest/services/Trailheads_data/FeatureServer/0/query?where=TRL_NAME LIKE '%Medea%'&outFields=*&f=json
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
where | string | ||
outFields | string | ||
f | string |
RESPONSES
status: OK
{"objectIdFieldName":"ObjectId2","uniqueIdField":{"name":"ObjectId2","isSystemMaintained":true},"globalIdFieldName":"","fields":[{"name":"OBJECTID","type":"esriFieldTypeString","alias":"OBJECTID","sqlType":"sqlTypeNVarchar","length":256,"domain":null,"defaultValue":null},{"name":"TRL_NAME","type":"esriFieldTypeString","alias":"TRL_NAME","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"PARK_NAME","type":"esriFieldTypeString","alias":"PARK_NAME","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"TRL_ID","type":"esriFieldTypeInteger","alias":"TRL_ID","sqlType":"sqlTypeInteger","domain":null,"defaultValue":null},{"name":"SEG_ID","type":"esriFieldTypeString","alias":"SEG_ID","sqlType":"sqlTypeNVarchar","length":256,"domain":null,"defaultValue":null},{"name":"FEATURE","type":"esriFieldTypeString","alias":"FEATURE","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"FEAT_CMNT","type":"esriFieldTypeString","alias":"FEAT_CMNT","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"ELEV_FT","type":"esriFieldTypeString","alias":"ELEV_FT","sqlType":"sqlTypeNVarchar","length":256,"domain":null,"defaultValue":null},{"name":"CITY_JUR","type":"esriFieldTypeString","alias":"CITY_JUR","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"ZIP_CODE","type":"esriFieldTypeString","alias":"ZIP_CODE","sqlType":"sqlTypeNVarchar","length":256,"domain":null,"defaultValue":null},{"name":"SUP_DIST","type":"esriFieldTypeString","alias":"SUP_DIST","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"X_STREET","type":"esriFieldTypeString","alias":"X_STREET","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"PARKING","type":"esriFieldTypeString","alias":"PARKING","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"PHOTO","type":"esriFieldTypeString","alias":"PHOTO","sqlType":"sqlTypeNVarchar","length":4000,"domain":null,"defaultValue":null},{"name":"ObjectId2","type":"esriFieldTypeOID","alias":"ObjectId2","sqlType":"sqlTypeInteger","domain":null,"defaultValue":null}],"features":[{"attributes":{"OBJECTID":"7769","TRL_NAME":"Medea Creek Trail","PARK_NAME":"National Parks Service","TRL_ID":20082,"SEG_ID":"200820000","FEATURE":"TAPO","FEAT_CMNT":"Auto Generated and Verified","ELEV_FT":"831","CITY_JUR":"Unincorporated Los Angeles County","ZIP_CODE":"91301","SUP_DIST":"3rd District","X_STREET":"28825 Lake Vista Dr","PARKING":"SA","PHOTO":null,"ObjectId2":1}},{"attributes":{"OBJECTID":"7768","TRL_NAME":"Medea Creek - Racetrack Connector","PARK_NAME":"National Parks Service","TRL_ID":20081,"SEG_ID":"200810000","FEATURE":"TAPO","FEAT_CMNT":"Auto Generated and Verified","ELEV_FT":"809","CITY_JUR":"Unincorporated Los Angeles County","ZIP_CODE":"91301","SUP_DIST":"3rd District","X_STREET":"29015 Mulholland Hwy","PARKING":"SA","PHOTO":null,"ObjectId2":108}}]}