Shifting intersections of polygon

How exactly does Hawking radiation decrease the mass of black holes?

What are the characteristics of a typeless programming language?

How to limit Drive Letters Windows assigns to new removable USB drives

Can someone publish a story that happened to you?

Contradiction proof for inequality of P and NP?

A ​Note ​on ​N!

Classification of surfaces

Does a large simulator bay have standard public address announcements?

How to not starve gigantic beasts

Why didn't the Space Shuttle bounce back into space as many times as possible so as to lose a lot of kinetic energy up there?

What's the polite way to say "I need to urinate"?

Critique of timeline aesthetic

bldc motor, esc and battery draw, nominal vs peak

Is Diceware more secure than a long passphrase?

Phrase for the opposite of "foolproof"

Can we say “you can pay when the order gets ready”?

Two field separators (colon and space) in awk

How to denote matrix elements succinctly?

What is causing the white spot to appear in some of my pictures

Why was the Spitfire's elliptical wing almost uncopied by other aircraft of World War 2?

Can SQL Server create collisions in system generated constraint names?

Map of water taps to fill bottles

How to have a sharp product image?

Re-entry to Germany after vacation using blue card



Shifting intersections of polygon







.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}







0















Hi I'm looking a Mapinfo SQL which I can look at two tables and easily determine, instead of having to the the long winded way in excel etc, if a particular smaller bounded polygon has now moved into a different larger bounded polygon because there has been recent redistribution of particular boundaries of the larger. I releasing it shouldn't be that hard, however the problem I have is that the smaller may fact be intersected by more than one of the larger and the cost's involved the vary significantly. I have been able to table before and after, and determine any differences, I guess looking for a query that looks at the two tables and says ok for smaller polygon WXYZ before you intersected larger polygon 1, but now you intersect larger polygon 1, 2 and 3. Btw I have over 5000 smaller polygons whereas I only have a total of 4 categorised larger polygons. Can anyone help? Or let me know if I didn't make sense. Cheers









share





























    0















    Hi I'm looking a Mapinfo SQL which I can look at two tables and easily determine, instead of having to the the long winded way in excel etc, if a particular smaller bounded polygon has now moved into a different larger bounded polygon because there has been recent redistribution of particular boundaries of the larger. I releasing it shouldn't be that hard, however the problem I have is that the smaller may fact be intersected by more than one of the larger and the cost's involved the vary significantly. I have been able to table before and after, and determine any differences, I guess looking for a query that looks at the two tables and says ok for smaller polygon WXYZ before you intersected larger polygon 1, but now you intersect larger polygon 1, 2 and 3. Btw I have over 5000 smaller polygons whereas I only have a total of 4 categorised larger polygons. Can anyone help? Or let me know if I didn't make sense. Cheers









    share

























      0












      0








      0








      Hi I'm looking a Mapinfo SQL which I can look at two tables and easily determine, instead of having to the the long winded way in excel etc, if a particular smaller bounded polygon has now moved into a different larger bounded polygon because there has been recent redistribution of particular boundaries of the larger. I releasing it shouldn't be that hard, however the problem I have is that the smaller may fact be intersected by more than one of the larger and the cost's involved the vary significantly. I have been able to table before and after, and determine any differences, I guess looking for a query that looks at the two tables and says ok for smaller polygon WXYZ before you intersected larger polygon 1, but now you intersect larger polygon 1, 2 and 3. Btw I have over 5000 smaller polygons whereas I only have a total of 4 categorised larger polygons. Can anyone help? Or let me know if I didn't make sense. Cheers









      share














      Hi I'm looking a Mapinfo SQL which I can look at two tables and easily determine, instead of having to the the long winded way in excel etc, if a particular smaller bounded polygon has now moved into a different larger bounded polygon because there has been recent redistribution of particular boundaries of the larger. I releasing it shouldn't be that hard, however the problem I have is that the smaller may fact be intersected by more than one of the larger and the cost's involved the vary significantly. I have been able to table before and after, and determine any differences, I guess looking for a query that looks at the two tables and says ok for smaller polygon WXYZ before you intersected larger polygon 1, but now you intersect larger polygon 1, 2 and 3. Btw I have over 5000 smaller polygons whereas I only have a total of 4 categorised larger polygons. Can anyone help? Or let me know if I didn't make sense. Cheers







      sql mapinfo query





      share












      share










      share



      share










      asked 1 min ago









      JaseJase

      1




      1






















          0






          active

          oldest

          votes












          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%2f321019%2fshifting-intersections-of-polygon%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          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%2f321019%2fshifting-intersections-of-polygon%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

          Щит и меч (фильм) Содержание Названия серий | Сюжет |...

          is 'sed' thread safeWhat should someone know about using Python scripts in the shell?Nexenta bash script uses...

          Meter-Bus Содержание Параметры шины | Стандартизация |...