Hi, If the object has been edited enough, it may not even be nearby the original object anymore. If all attributes has also been updated, it is hard to see how you would be able to detect that is really the same record anymore. So a unique ID or the approach below is needed:
If you have 10 users, that update various parts of a database, then have a field called userid and give it a value from 1-10, depending on who modifies that part of the network. When you get the updates back from user 7, delete all records where userid=7 and then append the records from user 7, where userid=7. This even allows you to give the users a larger part of the database, than just the part they are going to update. I have just been involved in such a project with cadastral data in Lithuania and that is pretty much how it was solved. It is a sort of a check-in/out scenario. Records marked with userid<>0, means the user is currently updating these records and nobody else is supposed to edit them. If you also have new records, you may have to restrict the area, where new records are allowed by defining a polygon and checking them before they are appended to the database. I hope this gives some inspiration on solving your task. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "S�ren Lindqvist" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, September 14, 2003 8:20 PM Subject: SV: MI-L Uppdate value from tableB to tableA continues Hello Uffe, Thanks I will try your suggestion You wrote: >If any of the objects has been updated too, this method will fail. So by this you mean if a user add another node to a polyline than just the data value on the subset it will not work with "entirely within? How should the problem then be solved? I would like to know if anyone has an idea how to deal with updating master data from subsets coming from other users not using a server? If you have a "master" and sending out subset from the "master" to for example 10 users that will update data and even put in new polylines in the subset and regularly sending them back for updating the "master" (No server). How should this be done to make life easy for everyone? Thanks Regards S�ren -----Ursprungligt meddelande----- Fr�n: Uffe Kousgaard [mailto:[EMAIL PROTECTED] Skickat: den 13 september 2003 16:42 Till: [EMAIL PROTECTED] �mne: Re: MI-L Uppdate value from tableB to tableA continues Hi, I think your basic problem is using intersect with polyline objects. 2 different polylines that snap at endnodes may also intersect. So here is my suggestion (untested): 1) Start by adding an ID field to both MasterTable and SubsetTable. Use value of rowid for instance. 2) Save a copy of the mastertable and open the copy. 3) Now create a very small buffer around all objects in the copy. Just update the table itself, so the polylines gets replaced by the buffers. 4) run an SQL: select copy.id,subset.id from copy,subset where subset.object enirely within copy.object You should now have a list of ID's that match together and can use that for transferring data. Check that there are not 2 subset ID's for any master ID. If you have that, you need a smaller buffer. If any of the objects has been updated too, this method will fail. Next time you hand out a subset of the street network, make sure there is an ID field, so the updates are easy to integrate back into the master. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "S�ren Lindqvist" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, September 13, 2003 1:36 PM Subject: SV: MI-L Uppdate value from tableB to tableA continues This is giving me headache, I changed SQL to: Select TableA.ColumnA, TableA.ColumnB, TableB.ColumnA, TableB.ColumnB from TableA, TableB where TableA.obj Intersects TableB.obj into New_Table The New_Table has now 4 columns (all columns Char (2)) I want the two last columns (that is from TableB) to update the two first columns (that is from TableA) If I use the following selection Update Columns: Update New_Table Set TAA = TBA, TAB = TBB ###TAA is TableA Column A etc.### The result is giving me the values, but not in right order as they are from TableB, for example if I have value 11,11 in a row in TableB it gives me 13,13 in TableA!!!!! Instead of doing an update it messes up all my data in the selection for TableA. What I'm doing wrong? I have a "master" road network and got a part of it in another layer with updates that I need to transfer over to the "master". I thought by doing intersect you can then take the data from the update layer down to the "master" layer. Is this not the right way to do it? Any help is appreciated as I can't go any further just now. Thanks Regards S�ren -----Ursprungligt meddelande----- Fr�n: S�ren Lindqvist [mailto:[EMAIL PROTECTED] Skickat: den 13 september 2003 00:11 Till: [EMAIL PROTECTED] �mne: MI-L Uppdate value from tableB to tableA Dear list, I have two tables where one is updated (tableB). I need to update the data from tableB to tableA I have made two selections by SQL like this: Select * From TableA, TableB where TableA.obj Intersects TableB.obj into tmptA Select * From TableB, TableA where TableB.obj Intersects TableA.obj into tmptB Now I need to update columns "B" and "C" in tmptA with values from columns "B" and "C" in tmptB. How is it written? Update tmptA column B and C with values from tmptB columns B and C Regards S�ren --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8373 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8374 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8375 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8378 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 8388
