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;








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.










share|improve this question
























  • 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

















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.










share|improve this question
























  • 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













0












0








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.










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Apr 9 at 22:17









PolyGeo♦

54k1782246




54k1782246










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

















  • 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










2 Answers
2






active

oldest

votes


















2














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)






share|improve this answer






























    0














    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.






    share|improve this answer























      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
      );



      );













      draft saved

      draft discarded


















      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









      2














      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)






      share|improve this answer



























        2














        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)






        share|improve this answer

























          2












          2








          2







          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)






          share|improve this answer













          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)







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Apr 9 at 13:45









          BerendBerend

          2,625618




          2,625618























              0














              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.






              share|improve this answer



























                0














                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.






                share|improve this answer

























                  0












                  0








                  0







                  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.






                  share|improve this answer













                  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.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered Apr 9 at 22:36









                  DowlersDowlers

                  1,7691424




                  1,7691424



























                      draft saved

                      draft discarded
















































                      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.




                      draft saved


                      draft discarded














                      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





















































                      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







                      Popular posts from this blog

                      Magento 1.9 observer on only new product added ( no updated product )Admin Create New Order ObserverObserver checkout_cart_product_add_after get product quantity in cartHow can I differentiate between product creation and saving existing products?How to get the original price Product SaveBeforeMagento Observer for Admin Sales order Address updateHow do i get quantity in a product_save_after event observer magento2?Using observer event to get updated customer infoSave product observer - detect availabilityEvent not triggered when new product added in admin : Magento 2magento 1.9 observer on quantity product change

                      Adding contour labels to SpatialLinesDataFrame or sf object? The Next CEO of Stack OverflowTearing of SpatialLinesDataFrame and problem with gClip functionAutomatically adjusting map labelsExtracting data.frame from simple features object in RR convert sf object back to SpatialPolygonsDataFrameSimplify polygons of sf objectlines of a SpatialLinesDataFrame corresponding to pointsCropping sf object in R?Pattern matching with grepl on SpatialPolygonsDataFrame object in RHow to create and empty SpatialLinesDataFrame in RWarning message in raster::rotate(): “this does not look like an appropriate object for this function”

                      Does an object always see its latest internal state irrespective of thread? The 2019 Stack Overflow Developer Survey Results Are InDoes a finally block always get executed in Java?Java: serial thread confinement questionJava difference between fixed threadpool and scheduled threadpoolJackrabbit and concurrent modificationHow to stop a Runnable scheduled for repeated execution after a certain number of executionsMultiple threads accessing inner classHow can a loop be completed by two thread? say loop from count=1 to count=4 by ist thread and count =5 to 8 by 2nd thread?If I keep a reference to a Runnable, when does the Thread it ran on get released?How to stop a schedule ScheduledExecutorServiceHow to implement a singleThreadedScheduledExcecutor in wildfly