On 04/08/2016 04:18 AM, Lester Anderson wrote: > Hello, > > I have an attribute table of earthquake data (focal mechanism beach > balls) and need to edit the depth attribute. Each ball is defined by > two rows in the table, eg first ball > > Row_ID Strike Dip Rake Magnitude Quadrant Depth > ---------------------------------------------------------- > 0 NULL NULL NULL NULL Tensional and Compressional NULL > 1 233 38 -96 6.77 Compressional 623 > 2 NULL NULL NULL NULL Tensional and Compressional NULL > 3 68 36 83 5.7 Compressional 39 > etc I'm probably completely misunderstanding your question but here goes...
So are you saying you want the Depth for row 0 set to 623 and the Depth for row 2 set to 39? Is there geometry connected to each row? If not rows 0 and 2 don't seem to have useful information? I'm definitely not any kind of database expert but isn't it a no no to have multiple rows represent one thing? Wouldn't they normally be in two tables and a join used to describe the whole object? I would be tempted to put rows 0,2, etc. into one table and 1,3, etc. into another and join but the only key would seem to be the rowid so I'm at a loss. > > where rows 0,1 and 2,3 represent separate beach balls, so basically it > is a row calculation > > What I need to do is replace the Depth NULL value with the depth 623 > etc for each entry. Is there an easy way of doing this? > > Thanks > > Lester > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user