Not able to query on ArcGIS Server REST query end point The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)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?
ELI5: Why do they say that Israel would have been the fourth country to land a spacecraft on the Moon and why do they call it low cost?
Python - Fishing Simulator
Pandas DataFrames: Create new rows with calculations across existing rows
How can I define good in a religion that claims no moral authority?
Predict a vector of values with constraints?
How are presidential pardons supposed to be used?
Why can't wing-mounted spoilers be used to steepen approaches?
How many people can fit inside Mordenkainen's Magnificent Mansion?
Would an alien lifeform be able to achieve space travel if lacking in vision?
Segmentation fault output is suppressed when piping stdin into a function. Why?
How does ice melt when immersed in water?
Can a 1st-level character have an ability score above 18?
How is simplicity better than precision and clarity in prose?
How to make `trap` know if the EXIT is after successful program finish or because of premature as an error or something
What LEGO pieces have "real-world" functionality?
He got a vote 80% that of Emmanuel Macron’s
Was credit for the black hole image misattributed?
"... to apply for a visa" or "... and applied for a visa"?
how can a perfect fourth interval be considered either consonant or dissonant?
The following signatures were invalid: EXPKEYSIG 1397BC53640DB551
Can smartphones with the same camera sensor have different image quality?
How long does the line of fire that you can create as an action using the Investiture of Flame spell last?
What do you call a plan that's an alternative plan in case your initial plan fails?
Why is Captain Marvel translated as male in Portugal?
Not able to query on ArcGIS Server REST query end point
The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)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,12542866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
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,12542866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
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,12542866
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,12542866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
edited Sep 10 '18 at 17:21
nmtoken
8,12542866
asked Sep 10 '18 at 17:14
Mona CoderMona Coder
126111
edited Sep 10 '18 at 17:21
nmtoken
8,12542866
edited Sep 10 '18 at 17:21
nmtoken
8,12542866
edited Sep 10 '18 at 17:21
nmtoken
8,12542866
8,12542866
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
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