How to append OS MasterMap Feature Class to the Feature class in PostgreSQL database 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?Merge Spatially Coincident Features in the Same Feature ClassHow to merge new values only?Combining multiple feature classes into single feature class using ArcGIS for Desktop?Loading existing datasets into empty geodatabase (with schema) in ModelBuilder with iterator and append?ogr2ogr append 1 row to a File GDB feature class's data tableNot able to apply update cursor on OS MasterMap feature classes created using OS Translator IIArcGIS gdb table field name problemMerge multiple geodatabases into oneArcMap Append (Data Management) Tool is not working correctlyAppending rows to empty FeatureClass with ArcPy

The logistics of corpse disposal

How should I respond to a player wanting to catch a sword between their hands?

How do I keep my slimes from escaping their pens?

What happens to sewage if there is no river near by?

Why there are no cargo aircraft with "flying wing" design?

Gastric acid as a weapon

ListPlot join points by nearest neighbor rather than order

Bonus calculation: Am I making a mountain out of a molehill?

What are the motives behind Cersei's orders given to Bronn?

Why don't the Weasley twins use magic outside of school if the Trace can only find the location of spells cast?

How to bypass password on Windows XP account?

How was the dust limit of 546 satoshis was chosen? Why not 550 satoshis?

Is there a service that would inform me whenever a new direct route is scheduled from a given airport?

Can a drone be seen on TCAS?

Is above average number of years spent on PhD considered a red flag in future academia or industry positions?

Can inflation occur in a positive-sum game currency system such as the Stack Exchange reputation system?

What are 'alternative tunings' of a guitar and why would you use them? Doesn't it make it more difficult to play?

Are my PIs rude or am I just being too sensitive?

Regex in IF condition in awk

Alternate inner products on Euclidean space?

Do I really need recursive chmod to restrict access to a folder?

Stars Make Stars

Is it true that "carbohydrates are of no use for the basal metabolic need"?

Letter Boxed validator



How to append OS MasterMap Feature Class to the Feature class in PostgreSQL database



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?Merge Spatially Coincident Features in the Same Feature ClassHow to merge new values only?Combining multiple feature classes into single feature class using ArcGIS for Desktop?Loading existing datasets into empty geodatabase (with schema) in ModelBuilder with iterator and append?ogr2ogr append 1 row to a File GDB feature class's data tableNot able to apply update cursor on OS MasterMap feature classes created using OS Translator IIArcGIS gdb table field name problemMerge multiple geodatabases into oneArcMap Append (Data Management) Tool is not working correctlyAppending rows to empty FeatureClass with ArcPy



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








1















I have my Enterprise Geodatabase as PostgreSQL. I want to keep OS MasterMap data on the Geodatabase and would like to update it whenever a new tile is downloaded. However, I am struggling to find a way to to append the existing OS MasterMap feature class with new data. I tried OS Translator II in QGIS as the OS Master Map files come with .gz extension but it overwrites the existing feature class in the geodatabase.



Please could you give me pointers as to how this can be done. Would I need a Python script or shall I first convert OS MasterMap data into shapefiles every time and then think about adding it to the existing OS MasterMap through ArcGIS.



I would preferably like the solution in QGIS as most of my team-mates have Arcgis Basic License except me who has ArcGIS Standard License.










share|improve this question






























    1















    I have my Enterprise Geodatabase as PostgreSQL. I want to keep OS MasterMap data on the Geodatabase and would like to update it whenever a new tile is downloaded. However, I am struggling to find a way to to append the existing OS MasterMap feature class with new data. I tried OS Translator II in QGIS as the OS Master Map files come with .gz extension but it overwrites the existing feature class in the geodatabase.



    Please could you give me pointers as to how this can be done. Would I need a Python script or shall I first convert OS MasterMap data into shapefiles every time and then think about adding it to the existing OS MasterMap through ArcGIS.



    I would preferably like the solution in QGIS as most of my team-mates have Arcgis Basic License except me who has ArcGIS Standard License.










    share|improve this question


























      1












      1








      1








      I have my Enterprise Geodatabase as PostgreSQL. I want to keep OS MasterMap data on the Geodatabase and would like to update it whenever a new tile is downloaded. However, I am struggling to find a way to to append the existing OS MasterMap feature class with new data. I tried OS Translator II in QGIS as the OS Master Map files come with .gz extension but it overwrites the existing feature class in the geodatabase.



      Please could you give me pointers as to how this can be done. Would I need a Python script or shall I first convert OS MasterMap data into shapefiles every time and then think about adding it to the existing OS MasterMap through ArcGIS.



      I would preferably like the solution in QGIS as most of my team-mates have Arcgis Basic License except me who has ArcGIS Standard License.










      share|improve this question
















      I have my Enterprise Geodatabase as PostgreSQL. I want to keep OS MasterMap data on the Geodatabase and would like to update it whenever a new tile is downloaded. However, I am struggling to find a way to to append the existing OS MasterMap feature class with new data. I tried OS Translator II in QGIS as the OS Master Map files come with .gz extension but it overwrites the existing feature class in the geodatabase.



      Please could you give me pointers as to how this can be done. Would I need a Python script or shall I first convert OS MasterMap data into shapefiles every time and then think about adding it to the existing OS MasterMap through ArcGIS.



      I would preferably like the solution in QGIS as most of my team-mates have Arcgis Basic License except me who has ArcGIS Standard License.







      qgis postgresql merge append os-mastermap






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Apr 29 '16 at 23:59









      PolyGeo♦

      54k1782246




      54k1782246










      asked Apr 29 '16 at 13:17









      Astha DevraAstha Devra

      708




      708




















          1 Answer
          1






          active

          oldest

          votes


















          0














          If you're using ogr2ogr to load data, you can simply apply the append tag.



          -append


          Other than that it will depend on the solution you are using.



          The more common solutions for loading MasterMap data are:



          • Go Loader

          • FME





          share|improve this answer























          • I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

            – Astha Devra
            May 4 '16 at 9:27











          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%2f191710%2fhow-to-append-os-mastermap-feature-class-to-the-feature-class-in-postgresql-data%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









          0














          If you're using ogr2ogr to load data, you can simply apply the append tag.



          -append


          Other than that it will depend on the solution you are using.



          The more common solutions for loading MasterMap data are:



          • Go Loader

          • FME





          share|improve this answer























          • I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

            – Astha Devra
            May 4 '16 at 9:27















          0














          If you're using ogr2ogr to load data, you can simply apply the append tag.



          -append


          Other than that it will depend on the solution you are using.



          The more common solutions for loading MasterMap data are:



          • Go Loader

          • FME





          share|improve this answer























          • I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

            – Astha Devra
            May 4 '16 at 9:27













          0












          0








          0







          If you're using ogr2ogr to load data, you can simply apply the append tag.



          -append


          Other than that it will depend on the solution you are using.



          The more common solutions for loading MasterMap data are:



          • Go Loader

          • FME





          share|improve this answer













          If you're using ogr2ogr to load data, you can simply apply the append tag.



          -append


          Other than that it will depend on the solution you are using.



          The more common solutions for loading MasterMap data are:



          • Go Loader

          • FME






          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Apr 29 '16 at 13:41









          HeikkiVesantoHeikkiVesanto

          9,2702245




          9,2702245












          • I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

            – Astha Devra
            May 4 '16 at 9:27

















          • I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

            – Astha Devra
            May 4 '16 at 9:27
















          I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

          – Astha Devra
          May 4 '16 at 9:27





          I have looked into both of these options but they are quite expensive. Is this functionality not at all possible using Open Source ???

          – Astha Devra
          May 4 '16 at 9:27

















          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%2f191710%2fhow-to-append-os-mastermap-feature-class-to-the-feature-class-in-postgresql-data%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

          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

          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”