Not able to query on ArcGIS Server REST query end pointwhy is a gdb query WHERE clause invalid according to...
N.B. ligature in Latex
Should I join an office cleaning event for free?
What makes Graph invariants so useful/important?
Infinite past with a beginning?
How does one intimidate enemies without having the capacity for violence?
How to type dʒ symbol (IPA) on Mac?
Circuitry of TV splitters
Motorized valve interfering with button?
Could a US political party gain complete control over the government by removing checks & balances?
Can I make popcorn with any corn?
Can a German sentence have two subjects?
If Manufacturer spice model and Datasheet give different values which should I use?
The magic money tree problem
When blogging recipes, how can I support both readers who want the narrative/journey and ones who want the printer-friendly recipe?
Is it possible to do 50 km distance without any previous training?
A Journey Through Space and Time
What is the command to reset a PC without deleting any files
How to calculate implied correlation via observed market price (Margrabe option)
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
What do you call a Matrix-like slowdown and camera movement effect?
How do you conduct xenoanthropology after first contact?
Can I interfere when another PC is about to be attacked?
How is this relation reflexive?
How do we improve the relationship with a client software team that performs poorly and is becoming less collaborative?
Not able to query on ArcGIS Server REST query end point
why is a gdb query WHERE clause invalid according to the ArcGIS REST API?ArcGIS Server Manager keeps getting COM errorsInvalid return value: published arcgis server 10.0 toolboxArcGIS Server 10.1 - Inconsistent Querying ErrorsNo domain coded values on REST Arcgis 10.2ArcGIS Rest performing query on feature service layers using within and interceptsQuerying ARCGIS to find feature having specified pointPublishing MapService to ArcGIS Server problem (Slow and cannot publish data from SQLDatabase)ArcGIS Rest service is returning multiple identical records when getting KMZArcGIS REST map server query doesn't return geometry as JSON?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I have a map server published on ArcGIS Server and it has a Poles layer. It has following fields:
Now when I am trying to run any query against this layer by passing queries like
Owner IS NOT NULL
or
Owner = 'Utility'
I am getting this error while I am sure the Owner is not NULL and all has value of utility
Failed to execute query.
Can you please let me know what I am doing wrong?
arcgis-server arcgis-rest-api
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have a map server published on ArcGIS Server and it has a Poles layer. It has following fields:
Now when I am trying to run any query against this layer by passing queries like
Owner IS NOT NULL
or
Owner = 'Utility'
I am getting this error while I am sure the Owner is not NULL and all has value of utility
Failed to execute query.
Can you please let me know what I am doing wrong?
arcgis-server arcgis-rest-api
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
"return fields" always has to be set. Are you setting it? I always add * in there when doing a quick and dirty test
– Dowlers
Sep 10 '18 at 22:32
1
@Dowlers Return fields doesn't have to be set. If left empty, the geometry and the display field will be returned by default.
– Berend
Nov 1 '18 at 8:18
@Berend Your right, it works without * at 10.5.1. I could have sworn at 10.3.1 I always had to enter * but I don't have an installation to test on. Thanks for letting me know.
– Dowlers
Nov 1 '18 at 14:00
1
@Dowlers Actually that wouldn't have surprised me, but I just checked an old 10.2 installation and that works without*too. It's thewherethat's required, and of course, if you want to see some useful information, you need*anyway.
– Berend
Nov 1 '18 at 14:51
add a comment |
I have a map server published on ArcGIS Server and it has a Poles layer. It has following fields:
Now when I am trying to run any query against this layer by passing queries like
Owner IS NOT NULL
or
Owner = 'Utility'
I am getting this error while I am sure the Owner is not NULL and all has value of utility
Failed to execute query.
Can you please let me know what I am doing wrong?
arcgis-server arcgis-rest-api
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
I have a map server published on ArcGIS Server and it has a Poles layer. It has following fields:
Now when I am trying to run any query against this layer by passing queries like
Owner IS NOT NULL
or
Owner = 'Utility'
I am getting this error while I am sure the Owner is not NULL and all has value of utility
Failed to execute query.
Can you please let me know what I am doing wrong?
arcgis-server arcgis-rest-api
arcgis-server arcgis-rest-api
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
edited Sep 10 '18 at 17:21
nmtoken
8,08642866
8,08642866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
126111
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 7 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
"return fields" always has to be set. Are you setting it? I always add * in there when doing a quick and dirty test
– Dowlers
Sep 10 '18 at 22:32
1
@Dowlers Return fields doesn't have to be set. If left empty, the geometry and the display field will be returned by default.
– Berend
Nov 1 '18 at 8:18
@Berend Your right, it works without * at 10.5.1. I could have sworn at 10.3.1 I always had to enter * but I don't have an installation to test on. Thanks for letting me know.
– Dowlers
Nov 1 '18 at 14:00
1
@Dowlers Actually that wouldn't have surprised me, but I just checked an old 10.2 installation and that works without*too. It's thewherethat's required, and of course, if you want to see some useful information, you need*anyway.
– Berend
Nov 1 '18 at 14:51
add a comment |
1
"return fields" always has to be set. Are you setting it? I always add * in there when doing a quick and dirty test
– Dowlers
Sep 10 '18 at 22:32
1
@Dowlers Return fields doesn't have to be set. If left empty, the geometry and the display field will be returned by default.
– Berend
Nov 1 '18 at 8:18
@Berend Your right, it works without * at 10.5.1. I could have sworn at 10.3.1 I always had to enter * but I don't have an installation to test on. Thanks for letting me know.
– Dowlers
Nov 1 '18 at 14:00
1
@Dowlers Actually that wouldn't have surprised me, but I just checked an old 10.2 installation and that works without*too. It's thewherethat's required, and of course, if you want to see some useful information, you need*anyway.
– Berend
Nov 1 '18 at 14:51
1
1
"return fields" always has to be set. Are you setting it? I always add * in there when doing a quick and dirty test
– Dowlers
Sep 10 '18 at 22:32
"return fields" always has to be set. Are you setting it? I always add * in there when doing a quick and dirty test
– Dowlers
Sep 10 '18 at 22:32
1
1
@Dowlers Return fields doesn't have to be set. If left empty, the geometry and the display field will be returned by default.
– Berend
Nov 1 '18 at 8:18
@Dowlers Return fields doesn't have to be set. If left empty, the geometry and the display field will be returned by default.
– Berend
Nov 1 '18 at 8:18
@Berend Your right, it works without * at 10.5.1. I could have sworn at 10.3.1 I always had to enter * but I don't have an installation to test on. Thanks for letting me know.
– Dowlers
Nov 1 '18 at 14:00
@Berend Your right, it works without * at 10.5.1. I could have sworn at 10.3.1 I always had to enter * but I don't have an installation to test on. Thanks for letting me know.
– Dowlers
Nov 1 '18 at 14:00
1
1
@Dowlers Actually that wouldn't have surprised me, but I just checked an old 10.2 installation and that works without
* too. It's the where that's required, and of course, if you want to see some useful information, you need * anyway.– Berend
Nov 1 '18 at 14:51
@Dowlers Actually that wouldn't have surprised me, but I just checked an old 10.2 installation and that works without
* too. It's the where that's required, and of course, if you want to see some useful information, you need * anyway.– Berend
Nov 1 '18 at 14:51
add a comment |
1 Answer
1
active
oldest
votes
the best way to check an ArcGIS REST API endpoint is to simply add Where 1=1. In this way you should be able to get every possible result.
If you add the * on the out fields as it is mentioned in the commends you will also get all the attributes.
Finally, If you want to check for strings the
Owner = 'Utility'
should work. Check again as we discussed with all the output fields and you should be able to find the issue with this field.
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "79"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f295459%2fnot-able-to-query-on-arcgis-server-rest-query-end-point%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
the best way to check an ArcGIS REST API endpoint is to simply add Where 1=1. In this way you should be able to get every possible result.
If you add the * on the out fields as it is mentioned in the commends you will also get all the attributes.
Finally, If you want to check for strings the
Owner = 'Utility'
should work. Check again as we discussed with all the output fields and you should be able to find the issue with this field.
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
add a comment |
the best way to check an ArcGIS REST API endpoint is to simply add Where 1=1. In this way you should be able to get every possible result.
If you add the * on the out fields as it is mentioned in the commends you will also get all the attributes.
Finally, If you want to check for strings the
Owner = 'Utility'
should work. Check again as we discussed with all the output fields and you should be able to find the issue with this field.
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
add a comment |
the best way to check an ArcGIS REST API endpoint is to simply add Where 1=1. In this way you should be able to get every possible result.
If you add the * on the out fields as it is mentioned in the commends you will also get all the attributes.
Finally, If you want to check for strings the
Owner = 'Utility'
should work. Check again as we discussed with all the output fields and you should be able to find the issue with this field.
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
the best way to check an ArcGIS REST API endpoint is to simply add Where 1=1. In this way you should be able to get every possible result.
If you add the * on the out fields as it is mentioned in the commends you will also get all the attributes.
Finally, If you want to check for strings the
Owner = 'Utility'
should work. Check again as we discussed with all the output fields and you should be able to find the issue with this field.
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
answered Nov 1 '18 at 8:12
Stratos TsoStratos Tso
388113
388113
add a comment |
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f295459%2fnot-able-to-query-on-arcgis-server-rest-query-end-point%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
"return fields" always has to be set. Are you setting it? I always add * in there when doing a quick and dirty test
– Dowlers
Sep 10 '18 at 22:32
1
@Dowlers Return fields doesn't have to be set. If left empty, the geometry and the display field will be returned by default.
– Berend
Nov 1 '18 at 8:18
@Berend Your right, it works without * at 10.5.1. I could have sworn at 10.3.1 I always had to enter * but I don't have an installation to test on. Thanks for letting me know.
– Dowlers
Nov 1 '18 at 14:00
1
@Dowlers Actually that wouldn't have surprised me, but I just checked an old 10.2 installation and that works without
*too. It's thewherethat's required, and of course, if you want to see some useful information, you need*anyway.– Berend
Nov 1 '18 at 14:51