Storing related tables and toolboxes within feature dataset? Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Is it possible to re-point operational layers ArcGIS Mobile projects v.3.0ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?Understanding ArcGIS Server connection typesIs it possible to force uppercase in a geodatabase string field?Renaming Feature Class within versioned Feature DatasetQuery Data from an Event Table in ArcGIS (Linear Referencing)File GeoDatabase Table is too large to export?Working on databased-stored-geodatabase with a ArcGIS for Desktop standard license?Working with a small spatial extent from a large dataset in ArcMapPortal And ArcSDE Geodatabase: Feature Datasets or Not
If a contract sometimes uses the wrong name, is it still valid?
Why did the Falcon Heavy center core fall off the ASDS OCISLY barge?
Is it fair for a professor to grade us on the possession of past papers?
Denied boarding although I have proper visa and documentation. To whom should I make a complaint?
What's the meaning of 間時肆拾貳 at a car parking sign
Why didn't this character "real die" when they blew their stack out in Altered Carbon?
porting install scripts : can rpm replace apt?
How to override model in magento2?
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
How widely used is the term Treppenwitz? Is it something that most Germans know?
Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?
Is the Standard Deduction better than Itemized when both are the same amount?
Apollo command module space walk?
Do I really need recursive chmod to restrict access to a folder?
How can I make names more distinctive without making them longer?
How to bypass password on Windows XP account?
Check which numbers satisfy the condition [A*B*C = A! + B! + C!]
Identifying polygons that intersect with another layer using QGIS?
Sci-Fi book where patients in a coma ward all live in a subconscious world linked together
What exactly is a "Meth" in Altered Carbon?
Generate an RGB colour grid
English words in a non-english sci-fi novel
Can a USB port passively 'listen only'?
3 doors, three guards, one stone
Storing related tables and toolboxes within feature dataset?
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Is it possible to re-point operational layers ArcGIS Mobile projects v.3.0ArcSDE/ST_Geometry: Can I store polygon and point geometries in same row?Understanding ArcGIS Server connection typesIs it possible to force uppercase in a geodatabase string field?Renaming Feature Class within versioned Feature DatasetQuery Data from an Event Table in ArcGIS (Linear Referencing)File GeoDatabase Table is too large to export?Working on databased-stored-geodatabase with a ArcGIS for Desktop standard license?Working with a small spatial extent from a large dataset in ArcMapPortal And ArcSDE Geodatabase: Feature Datasets or Not
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset within a single Enterprise geodatabase. To my knowledge this is possible if the data does not contain any related tables or associated toolboxes.
Is it possible to store related tables and toolboxes within a feature dataset?
My goal is to not create an Enterprise geodatabase for each individual project.
arcgis-server enterprise-geodatabase sql-server feature-dataset
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
asked Apr 9 at 13:31
DaykrayDaykray
916
add a comment |
I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset within a single Enterprise geodatabase. To my knowledge this is possible if the data does not contain any related tables or associated toolboxes.
Is it possible to store related tables and toolboxes within a feature dataset?
My goal is to not create an Enterprise geodatabase for each individual project.
arcgis-server enterprise-geodatabase sql-server feature-dataset
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
asked Apr 9 at 13:31
DaykrayDaykray
916
Geodatabase Diagrammer for 10X > arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7
– Mapperz♦
Apr 9 at 14:00
1
Best practice is to only place the feature classes which are absolutely required to be in feature datasets together. It's an antipattern to use feature datasets as a folder to glom related data together; doing this slows the actual FDS operations with additional checking and locking.
– Vince
Apr 9 at 14:48
add a comment |
I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset within a single Enterprise geodatabase. To my knowledge this is possible if the data does not contain any related tables or associated toolboxes.
Is it possible to store related tables and toolboxes within a feature dataset?
My goal is to not create an Enterprise geodatabase for each individual project.
arcgis-server enterprise-geodatabase sql-server feature-dataset
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
asked Apr 9 at 13:31
DaykrayDaykray
916
I am new to Enterprise geodatabases and am looking for some information regarding data structure and storage. Within my organization, we would like to store individual projects by feature dataset within a single Enterprise geodatabase. To my knowledge this is possible if the data does not contain any related tables or associated toolboxes.
Is it possible to store related tables and toolboxes within a feature dataset?
My goal is to not create an Enterprise geodatabase for each individual project.
arcgis-server enterprise-geodatabase sql-server feature-dataset
arcgis-server enterprise-geodatabase sql-server feature-dataset
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
asked Apr 9 at 13:31
DaykrayDaykray
916
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
asked Apr 9 at 13:31
DaykrayDaykray
916
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
edited Apr 9 at 22:17
PolyGeo♦
54k1782246
54k1782246
asked Apr 9 at 13:31
DaykrayDaykray
916
asked Apr 9 at 13:31
DaykrayDaykray
916
asked Apr 9 at 13:31
DaykrayDaykray
916
916
Geodatabase Diagrammer for 10X > arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7
– Mapperz♦
Apr 9 at 14:00
1
Best practice is to only place the feature classes which are absolutely required to be in feature datasets together. It's an antipattern to use feature datasets as a folder to glom related data together; doing this slows the actual FDS operations with additional checking and locking.
– Vince
Apr 9 at 14:48
add a comment |
Geodatabase Diagrammer for 10X > arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7
– Mapperz♦
Apr 9 at 14:00
1
Best practice is to only place the feature classes which are absolutely required to be in feature datasets together. It's an antipattern to use feature datasets as a folder to glom related data together; doing this slows the actual FDS operations with additional checking and locking.
– Vince
Apr 9 at 14:48
Geodatabase Diagrammer for 10X > arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7
– Mapperz♦
Apr 9 at 14:00
Geodatabase Diagrammer for 10X > arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7
– Mapperz♦
Apr 9 at 14:00
1
1
Best practice is to only place the feature classes which are absolutely required to be in feature datasets together. It's an antipattern to use feature datasets as a folder to glom related data together; doing this slows the actual FDS operations with additional checking and locking.
– Vince
Apr 9 at 14:48
Best practice is to only place the feature classes which are absolutely required to be in feature datasets together. It's an antipattern to use feature datasets as a folder to glom related data together; doing this slows the actual FDS operations with additional checking and locking.
– Vince
Apr 9 at 14:48
add a comment |
2 Answers
2
active
oldest
votes
No, a feature dataset is used to group related feature classes (see here). These feature classes can have related tables, but the tables will be stored outside the feature dataset.
One approach that I see with many organization is to have distinct database users / schemas / whatever to keep projects separated. This way, you don't need to have separate geodatabases, and it also gives you an easy way to implement security (e.g. when not all users are allowed to see all projects)
answered Apr 9 at 13:45
BerendBerend
2,625618
add a comment |
As others have said, don't use feature datasets for organizing data. They are not folders and will cause problems down the road if you teat them as such.
My suggestion would be to use schemas instead. Create a schema and database role for each project and then assign roles and permissions to users as appropriate.
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
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%2f318243%2fstoring-related-tables-and-toolboxes-within-feature-dataset%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
No, a feature dataset is used to group related feature classes (see here). These feature classes can have related tables, but the tables will be stored outside the feature dataset.
One approach that I see with many organization is to have distinct database users / schemas / whatever to keep projects separated. This way, you don't need to have separate geodatabases, and it also gives you an easy way to implement security (e.g. when not all users are allowed to see all projects)
answered Apr 9 at 13:45
BerendBerend
2,625618
add a comment |
No, a feature dataset is used to group related feature classes (see here). These feature classes can have related tables, but the tables will be stored outside the feature dataset.
One approach that I see with many organization is to have distinct database users / schemas / whatever to keep projects separated. This way, you don't need to have separate geodatabases, and it also gives you an easy way to implement security (e.g. when not all users are allowed to see all projects)
answered Apr 9 at 13:45
BerendBerend
2,625618
add a comment |
No, a feature dataset is used to group related feature classes (see here). These feature classes can have related tables, but the tables will be stored outside the feature dataset.
One approach that I see with many organization is to have distinct database users / schemas / whatever to keep projects separated. This way, you don't need to have separate geodatabases, and it also gives you an easy way to implement security (e.g. when not all users are allowed to see all projects)
answered Apr 9 at 13:45
BerendBerend
2,625618
No, a feature dataset is used to group related feature classes (see here). These feature classes can have related tables, but the tables will be stored outside the feature dataset.
One approach that I see with many organization is to have distinct database users / schemas / whatever to keep projects separated. This way, you don't need to have separate geodatabases, and it also gives you an easy way to implement security (e.g. when not all users are allowed to see all projects)
answered Apr 9 at 13:45
BerendBerend
2,625618
answered Apr 9 at 13:45
BerendBerend
2,625618
answered Apr 9 at 13:45
BerendBerend
2,625618
answered Apr 9 at 13:45
BerendBerend
2,625618
2,625618
add a comment |
add a comment |
As others have said, don't use feature datasets for organizing data. They are not folders and will cause problems down the road if you teat them as such.
My suggestion would be to use schemas instead. Create a schema and database role for each project and then assign roles and permissions to users as appropriate.
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
add a comment |
As others have said, don't use feature datasets for organizing data. They are not folders and will cause problems down the road if you teat them as such.
My suggestion would be to use schemas instead. Create a schema and database role for each project and then assign roles and permissions to users as appropriate.
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
add a comment |
As others have said, don't use feature datasets for organizing data. They are not folders and will cause problems down the road if you teat them as such.
My suggestion would be to use schemas instead. Create a schema and database role for each project and then assign roles and permissions to users as appropriate.
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
As others have said, don't use feature datasets for organizing data. They are not folders and will cause problems down the road if you teat them as such.
My suggestion would be to use schemas instead. Create a schema and database role for each project and then assign roles and permissions to users as appropriate.
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
answered Apr 9 at 22:36
DowlersDowlers
1,7691424
1,7691424
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%2f318243%2fstoring-related-tables-and-toolboxes-within-feature-dataset%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
Geodatabase Diagrammer for 10X > arcgis.com/home/item.html?id=a378b48be11b45b5bb25254643304cb7
– Mapperz♦
Apr 9 at 14:00
1
Best practice is to only place the feature classes which are absolutely required to be in feature datasets together. It's an antipattern to use feature datasets as a folder to glom related data together; doing this slows the actual FDS operations with additional checking and locking.
– Vince
Apr 9 at 14:48