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;
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
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
add a comment |
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
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
add a comment |
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
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
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
qgis postgresql merge append os-mastermap
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
edited Apr 29 '16 at 23:59
PolyGeo♦
54k1782246
54k1782246
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
asked Apr 29 '16 at 13:17
Astha DevraAstha Devra
708
708
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
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
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
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
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%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
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
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
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
add a comment |
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
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
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
add a comment |
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
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
9,2702245
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
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
9,2702245
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
9,2702245
answered Apr 29 '16 at 13:41
HeikkiVesantoHeikkiVesanto
9,2702245
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
add a comment |
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
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%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
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
