Adding Not Operator in Definition Query of ArcGIS Pro?
I am using ArcGIS Pro 2.2
I want to apply a definition query saying
NOT (name contains 'road%')
apparently there is no option to add Not Operator in query neither there seem to be any option saying not contains
.
Is there a way to add Not Operator in definition query using ArcGIS Pro?
arcgis-pro definition-query operator
add a comment |
I am using ArcGIS Pro 2.2
I want to apply a definition query saying
NOT (name contains 'road%')
apparently there is no option to add Not Operator in query neither there seem to be any option saying not contains
.
Is there a way to add Not Operator in definition query using ArcGIS Pro?
arcgis-pro definition-query operator
add a comment |
I am using ArcGIS Pro 2.2
I want to apply a definition query saying
NOT (name contains 'road%')
apparently there is no option to add Not Operator in query neither there seem to be any option saying not contains
.
Is there a way to add Not Operator in definition query using ArcGIS Pro?
arcgis-pro definition-query operator
I am using ArcGIS Pro 2.2
I want to apply a definition query saying
NOT (name contains 'road%')
apparently there is no option to add Not Operator in query neither there seem to be any option saying not contains
.
Is there a way to add Not Operator in definition query using ArcGIS Pro?
arcgis-pro definition-query operator
arcgis-pro definition-query operator
edited Nov 12 '18 at 6:36
PolyGeo♦
53.2k1779238
53.2k1779238
asked Nov 12 '18 at 6:15
user4906240
366110
366110
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can do this, but not in Edit Clause Mode, so you need to switch to Edit SQL Mode first using the toggle at top left.
As a test using ArcGIS Pro 2.2.4 I used the expression NAME NOT LIKE '%ust%'
to filter all countries except Australia and Austria from the Natural Earth countries successfully.
The warning (seen in the picture) that "The expression can't be edited in Clause mode" comes up if I try to toggle back to Edit Clause Mode using the blue icon at top left. Nevertheless, the expression can be used (just not edited in Clause mode).
If you take out the word NOT to make it NAME LIKE '%ust%'
then you can toggle back to Edit Clause Mode where you will see that the clause displays as NAME contains the text ust
.
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%2f302235%2fadding-not-operator-in-definition-query-of-arcgis-pro%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
You can do this, but not in Edit Clause Mode, so you need to switch to Edit SQL Mode first using the toggle at top left.
As a test using ArcGIS Pro 2.2.4 I used the expression NAME NOT LIKE '%ust%'
to filter all countries except Australia and Austria from the Natural Earth countries successfully.
The warning (seen in the picture) that "The expression can't be edited in Clause mode" comes up if I try to toggle back to Edit Clause Mode using the blue icon at top left. Nevertheless, the expression can be used (just not edited in Clause mode).
If you take out the word NOT to make it NAME LIKE '%ust%'
then you can toggle back to Edit Clause Mode where you will see that the clause displays as NAME contains the text ust
.
add a comment |
You can do this, but not in Edit Clause Mode, so you need to switch to Edit SQL Mode first using the toggle at top left.
As a test using ArcGIS Pro 2.2.4 I used the expression NAME NOT LIKE '%ust%'
to filter all countries except Australia and Austria from the Natural Earth countries successfully.
The warning (seen in the picture) that "The expression can't be edited in Clause mode" comes up if I try to toggle back to Edit Clause Mode using the blue icon at top left. Nevertheless, the expression can be used (just not edited in Clause mode).
If you take out the word NOT to make it NAME LIKE '%ust%'
then you can toggle back to Edit Clause Mode where you will see that the clause displays as NAME contains the text ust
.
add a comment |
You can do this, but not in Edit Clause Mode, so you need to switch to Edit SQL Mode first using the toggle at top left.
As a test using ArcGIS Pro 2.2.4 I used the expression NAME NOT LIKE '%ust%'
to filter all countries except Australia and Austria from the Natural Earth countries successfully.
The warning (seen in the picture) that "The expression can't be edited in Clause mode" comes up if I try to toggle back to Edit Clause Mode using the blue icon at top left. Nevertheless, the expression can be used (just not edited in Clause mode).
If you take out the word NOT to make it NAME LIKE '%ust%'
then you can toggle back to Edit Clause Mode where you will see that the clause displays as NAME contains the text ust
.
You can do this, but not in Edit Clause Mode, so you need to switch to Edit SQL Mode first using the toggle at top left.
As a test using ArcGIS Pro 2.2.4 I used the expression NAME NOT LIKE '%ust%'
to filter all countries except Australia and Austria from the Natural Earth countries successfully.
The warning (seen in the picture) that "The expression can't be edited in Clause mode" comes up if I try to toggle back to Edit Clause Mode using the blue icon at top left. Nevertheless, the expression can be used (just not edited in Clause mode).
If you take out the word NOT to make it NAME LIKE '%ust%'
then you can toggle back to Edit Clause Mode where you will see that the clause displays as NAME contains the text ust
.
edited Nov 12 '18 at 6:41
answered Nov 12 '18 at 6:34
PolyGeo♦
53.2k1779238
53.2k1779238
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f302235%2fadding-not-operator-in-definition-query-of-arcgis-pro%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