Creating multi-attribute primary key in table in ArcGIS DesktopProblem with adding new field to attribute table after performing join by attributesAssigning ID to features with similar attributesJoin Tables related by a composite primary key in qgisUsing non-unique names for attribute indexes of file/ArcSDE geodatabases?Embedding 2500 images into feature class using ArcGIS Desktop?Merging Rows in Table using ArcGIS Desktop?Data goes missing in Esri file geodatabase
Non-visual Computers - thoughts?
Why is the UK so keen to remove the "backstop" when their leadership seems to think that no border will be needed in Northern Ireland?
Compelling story with the world as a villain
Numbers Decrease while Letters Increase
What are some interesting features that are common cross-linguistically but don't exist in English?
Two questions about typesetting a Roman missal
How do I, an introvert, communicate to my friend and only colleague, an extrovert, that I want to spend my scheduled breaks without them?
Very slow boot time and poor perfomance
Nothing like a good ol' game of ModTen
Did a flight controller ever answer Flight with a no-go?
Prove your innocence
Is "The life is beautiful" incorrect or just very non-idiomatic?
Why did Khan ask Admiral James T. Kirk about Project Genesis?
Are the A380 engines interchangeable (given they are not all equipped with reverse)?
How do proponents of Sola Scriptura address the ministry of those Apostles who authored no parts of Scripture?
If someone uses the Command spell and says "drop", what happens?
Is gzip atomic?
Can I get temporary health insurance while moving to the US?
Can RMSE and MAE have the same value?
Why is there a difference between predicting on Validation set and Test set?
Architectural feasibility of a tiered circular stone keep
Is MOSFET active device?
moon structure ownership
How do the Etherealness and Banishment spells interact?
Creating multi-attribute primary key in table in ArcGIS Desktop
Problem with adding new field to attribute table after performing join by attributesAssigning ID to features with similar attributesJoin Tables related by a composite primary key in qgisUsing non-unique names for attribute indexes of file/ArcSDE geodatabases?Embedding 2500 images into feature class using ArcGIS Desktop?Merging Rows in Table using ArcGIS Desktop?Data goes missing in Esri file geodatabase
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
If I have this file geodatabase table with the format of:
ColA | ColB| ColC | ColD | ColE | ColF etc...
I want to declare a combination of columns will be the primary key (ColA | ColB| ColC). When I say primary key, I want to say that the combination of ColA | ColB| ColC defines a unique row within the table.
I was thinking of using Add Attribute Index tool in ArcGIS Desktop on these three columns, but I'm not sure if that is the right approach.
arcgis-desktop file-geodatabase table
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
add a comment |
If I have this file geodatabase table with the format of:
ColA | ColB| ColC | ColD | ColE | ColF etc...
I want to declare a combination of columns will be the primary key (ColA | ColB| ColC). When I say primary key, I want to say that the combination of ColA | ColB| ColC defines a unique row within the table.
I was thinking of using Add Attribute Index tool in ArcGIS Desktop on these three columns, but I'm not sure if that is the right approach.
arcgis-desktop file-geodatabase table
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
Concatenate them into new text field.
– FelixIP
Aug 12 at 20:34
1
Building a compound index isn't the same as a primary key, but I don't think file geodatabase even supports the concept of a primary key, at least in the way the real databases do.
– Vince
Aug 12 at 21:52
add a comment |
If I have this file geodatabase table with the format of:
ColA | ColB| ColC | ColD | ColE | ColF etc...
I want to declare a combination of columns will be the primary key (ColA | ColB| ColC). When I say primary key, I want to say that the combination of ColA | ColB| ColC defines a unique row within the table.
I was thinking of using Add Attribute Index tool in ArcGIS Desktop on these three columns, but I'm not sure if that is the right approach.
arcgis-desktop file-geodatabase table
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
If I have this file geodatabase table with the format of:
ColA | ColB| ColC | ColD | ColE | ColF etc...
I want to declare a combination of columns will be the primary key (ColA | ColB| ColC). When I say primary key, I want to say that the combination of ColA | ColB| ColC defines a unique row within the table.
I was thinking of using Add Attribute Index tool in ArcGIS Desktop on these three columns, but I'm not sure if that is the right approach.
arcgis-desktop file-geodatabase table
arcgis-desktop file-geodatabase table
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
edited Aug 12 at 21:54
Vince
15.3k4 gold badges30 silver badges50 bronze badges
15.3k4 gold badges30 silver badges50 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
asked Aug 12 at 19:50
ticklethateyoticklethateyo
62 bronze badges
62 bronze badges
Concatenate them into new text field.
– FelixIP
Aug 12 at 20:34
1
Building a compound index isn't the same as a primary key, but I don't think file geodatabase even supports the concept of a primary key, at least in the way the real databases do.
– Vince
Aug 12 at 21:52
add a comment |
Concatenate them into new text field.
– FelixIP
Aug 12 at 20:34
1
Building a compound index isn't the same as a primary key, but I don't think file geodatabase even supports the concept of a primary key, at least in the way the real databases do.
– Vince
Aug 12 at 21:52
Concatenate them into new text field.
– FelixIP
Aug 12 at 20:34
Concatenate them into new text field.
– FelixIP
Aug 12 at 20:34
1
1
Building a compound index isn't the same as a primary key, but I don't think file geodatabase even supports the concept of a primary key, at least in the way the real databases do.
– Vince
Aug 12 at 21:52
Building a compound index isn't the same as a primary key, but I don't think file geodatabase even supports the concept of a primary key, at least in the way the real databases do.
– Vince
Aug 12 at 21:52
add a comment |
1 Answer
1
active
oldest
votes
You can use your field calculator for this. Add a new text field to your table that will be your key field. Right-click on its field name in the attribute table and choose Field Calculator...
Use [ColA] & [ColB] & [ColC] for your field calculation.
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
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%2f331785%2fcreating-multi-attribute-primary-key-in-table-in-arcgis-desktop%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 use your field calculator for this. Add a new text field to your table that will be your key field. Right-click on its field name in the attribute table and choose Field Calculator...
Use [ColA] & [ColB] & [ColC] for your field calculation.
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
add a comment |
You can use your field calculator for this. Add a new text field to your table that will be your key field. Right-click on its field name in the attribute table and choose Field Calculator...
Use [ColA] & [ColB] & [ColC] for your field calculation.
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
add a comment |
You can use your field calculator for this. Add a new text field to your table that will be your key field. Right-click on its field name in the attribute table and choose Field Calculator...
Use [ColA] & [ColB] & [ColC] for your field calculation.
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
You can use your field calculator for this. Add a new text field to your table that will be your key field. Right-click on its field name in the attribute table and choose Field Calculator...
Use [ColA] & [ColB] & [ColC] for your field calculation.
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
edited Aug 12 at 20:37
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
answered Aug 12 at 20:25
Emil BrundageEmil Brundage
10.8k1 gold badge17 silver badges47 bronze badges
10.8k1 gold badge17 silver badges47 bronze badges
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
add a comment |
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
How can you be sure that the values in the new field are unique and prevent inserts and updates with already used values?
– user30184
Aug 13 at 6:28
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
I believe that may be coming, sort of, in a future release. But maybe I am misremembering from the UC. As of now, If you really need to do this, you can use query layers to get counts within multiple field sorts, or use concatenated keys and just summarize, to find duplicates after the fact. Most big applications would do this outside ArcGIS in other database managers.
– danak
Aug 15 at 23:29
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%2f331785%2fcreating-multi-attribute-primary-key-in-table-in-arcgis-desktop%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
Concatenate them into new text field.
– FelixIP
Aug 12 at 20:34
1
Building a compound index isn't the same as a primary key, but I don't think file geodatabase even supports the concept of a primary key, at least in the way the real databases do.
– Vince
Aug 12 at 21:52