[Qgis-user] (no subject)

[Minjamo Gelagile Garsamo]

if possibe remove me from your list.
___
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

Re: [Qgis-user] Edit attribute table rows

[Micha Silver]

  
  

  
Here's a way to accomplish what you want in a Spatialite table

I saved your sample 4 rows as a CSV:

row_id,strike,dip,rake,magnitude,quadrant,depth
0,Tensional and Compressional,
1,233,38,-96,6.77,Compressional,623
2,Tensional and Compressional,
3,68,36,83,5.7,Compressional,39

Then I imported the CSV to Spatialite_gui and ran this query:

UPDATE earthquakes SET depth=(SELECT e.depth FROM earthquakes AS
e WHERE e.rowid=(earthquakes.rowid+1)) 
WHERE depth IS NULL;

Then I got:
0    0    0    NULL    NULL    NULL    NULL    Tensional and
Compressional    623
1    1    1    233    38    -96    6.77    Compressional   
623
2    2    2    NULL    NULL    NULL    NULL    Tensional and
Compressional    39
3    3    3    68    36    83    5.70    Compressional    39

HTH,
Micha

  

-- Original Message --
  Subject: Re: [Qgis-user] Edit attribute table rows
  Date: Fri, 8 Apr 2016 17:17:09 +0100
  To: Andreas Neumann, Qgis-user
  From: Lester Anderson


On 04/08/2016 07:17 PM, Lester Anderson
  wrote:


  Hi Andreas,

Still having issues. I can see the logic of the CASE WHEN END, but I
am wondering if the problem is because "Depth" has both a NULL value
and a real value. I have tried all sorts of variants and cannot get
the NULL depth changed.

Attributes: strike dip rake magnitude quadrant depth
0 null null null null null "Tensional and compressional" null
1 233 38 -96 6.77 Compressional 623

So scanning for Depth=NULL is fine; this is actually all of the event
solutions, where the row with the values defines the nodal planes. I
have around 2928 events in the shapefile!

Can this be solved by scanning for the quadrant attribute, but then
how does one specify the value for "Depth". I think if one applies
"Depth" NOT NULL it returns 1

I could not find a guide in the documentation for the field calculator
that was similar.

Cheers
Lester

On 8 April 2016 at 15:00, Neumann, Andreas  wrote:

  
Hi Lester,

The field calculator is meant to change "a lot" of values. It will update
all selected records with the new value or calculation (_expression_).

With CASE WHEN END you can introduce switches for different rules.

So - please don't export to Excel. You can do it all with the field
calculator.

Andreas

On 2016-04-08 15:28, Lester Anderson wrote:

Hi Andreas,

I am trying change a lot of values, if it was a few that is no problem.

The other option is to export the attribute table as a database and
edit in Excel etc and then join the table in QGIS

Cheers
Lester

On 8 April 2016 at 14:23, Neumann, Andreas  wrote:

Hi Lester,

I thought you want to set the value to 623 where the value was NULL before?
- so just write 623 in the left field after you selected the values.

Alternatively, you can do without the previous selection and use the
following _expression_.

CASE WHEN depth IS NULL THEN 623 ELSE depth END

Hope this helps,

Andreas



On 2016-04-08 15:13, Lester Anderson wrote:

Hello Andreas,

Selecting the rows where depth = NULL is fine. The field calculator
does not update the depth with the depth where known values are
present.

Only update selected features is checked, update existing field
checked, with output field set to depth:
_expression_: tried just "depth" and also "depth"="depth".

Have I missed something here?

Thanks

On 8 April 2016 at 12:30, Neumann, Andreas  wrote:

Sure.

It is a two-step thing:

1. Select all records where Depth IS NULL. Use the "Select Features using an
_expression_" button (the Epsilon sign) for that and "depth IS NULL" as an
_expression_

2. Use the field calculator and only update the selected records (the top
checkbox in the field calculator).

You can find details about the field calculator in the QGIS manual.

Hope this helps,

Andreas

On 2016-04-08 13:18, 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

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 

Re: [Qgis-user] Edit attribute table rows

[David J. Bakeman]

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

Re: [Qgis-user] Drive time analysis

[Jakob Miksch]

you can also try the "OSM route" plugin: 
https://plugins.qgis.org/plugins/OSMroute/

It uses  openrouteservice.org/
There "drive time analysis" is called "accessiblity analysis"
___
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

Re: [Qgis-user] Edit attribute table rows

[Lester Anderson]

Hi Andreas,

Still having issues. I can see the logic of the CASE WHEN END, but I
am wondering if the problem is because "Depth" has both a NULL value
and a real value. I have tried all sorts of variants and cannot get
the NULL depth changed.

Attributes: strike dip rake magnitude quadrant depth
0 null null null null null "Tensional and compressional" null
1 233 38 -96 6.77 Compressional 623

So scanning for Depth=NULL is fine; this is actually all of the event
solutions, where the row with the values defines the nodal planes. I
have around 2928 events in the shapefile!

Can this be solved by scanning for the quadrant attribute, but then
how does one specify the value for "Depth". I think if one applies
"Depth" NOT NULL it returns 1

I could not find a guide in the documentation for the field calculator
that was similar.

Cheers
Lester

On 8 April 2016 at 15:00, Neumann, Andreas  wrote:
> Hi Lester,
>
> The field calculator is meant to change "a lot" of values. It will update
> all selected records with the new value or calculation (expression).
>
> With CASE WHEN END you can introduce switches for different rules.
>
> So - please don't export to Excel. You can do it all with the field
> calculator.
>
> Andreas
>
> On 2016-04-08 15:28, Lester Anderson wrote:
>
> Hi Andreas,
>
> I am trying change a lot of values, if it was a few that is no problem.
>
> The other option is to export the attribute table as a database and
> edit in Excel etc and then join the table in QGIS
>
> Cheers
> Lester
>
> On 8 April 2016 at 14:23, Neumann, Andreas  wrote:
>
> Hi Lester,
>
> I thought you want to set the value to 623 where the value was NULL before?
> - so just write 623 in the left field after you selected the values.
>
> Alternatively, you can do without the previous selection and use the
> following expression.
>
> CASE WHEN depth IS NULL THEN 623 ELSE depth END
>
> Hope this helps,
>
> Andreas
>
>
>
> On 2016-04-08 15:13, Lester Anderson wrote:
>
> Hello Andreas,
>
> Selecting the rows where depth = NULL is fine. The field calculator
> does not update the depth with the depth where known values are
> present.
>
> Only update selected features is checked, update existing field
> checked, with output field set to depth:
> Expression: tried just "depth" and also "depth"="depth".
>
> Have I missed something here?
>
> Thanks
>
> On 8 April 2016 at 12:30, Neumann, Andreas  wrote:
>
> Sure.
>
> It is a two-step thing:
>
> 1. Select all records where Depth IS NULL. Use the "Select Features using an
> expression" button (the Epsilon sign) for that and "depth IS NULL" as an
> expression
>
> 2. Use the field calculator and only update the selected records (the top
> checkbox in the field calculator).
>
> You can find details about the field calculator in the QGIS manual.
>
> Hope this helps,
>
> Andreas
>
> On 2016-04-08 13:18, 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
>
> 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

Re: [Qgis-user] Edit attribute table rows

[Neumann, Andreas]

Hi Lester, 

The field calculator is meant to change "a lot" of values. It will
update all selected records with the new value or calculation
(expression). 

With CASE WHEN END you can introduce switches for different rules. 

So - please don't export to Excel. You can do it all with the field
calculator. 

Andreas 

On 2016-04-08 15:28, Lester Anderson wrote:

> Hi Andreas,
> 
> I am trying change a lot of values, if it was a few that is no problem.
> 
> The other option is to export the attribute table as a database and
> edit in Excel etc and then join the table in QGIS
> 
> Cheers
> Lester
> 
> On 8 April 2016 at 14:23, Neumann, Andreas  wrote: 
> 
>> Hi Lester,
>> 
>> I thought you want to set the value to 623 where the value was NULL before?
>> - so just write 623 in the left field after you selected the values.
>> 
>> Alternatively, you can do without the previous selection and use the
>> following expression.
>> 
>> CASE WHEN depth IS NULL THEN 623 ELSE depth END
>> 
>> Hope this helps,
>> 
>> Andreas
>> 
>> On 2016-04-08 15:13, Lester Anderson wrote:
>> 
>> Hello Andreas,
>> 
>> Selecting the rows where depth = NULL is fine. The field calculator
>> does not update the depth with the depth where known values are
>> present.
>> 
>> Only update selected features is checked, update existing field
>> checked, with output field set to depth:
>> Expression: tried just "depth" and also "depth"="depth".
>> 
>> Have I missed something here?
>> 
>> Thanks
>> 
>> On 8 April 2016 at 12:30, Neumann, Andreas  wrote:
>> 
>> Sure.
>> 
>> It is a two-step thing:
>> 
>> 1. Select all records where Depth IS NULL. Use the "Select Features using an
>> expression" button (the Epsilon sign) for that and "depth IS NULL" as an
>> expression
>> 
>> 2. Use the field calculator and only update the selected records (the top
>> checkbox in the field calculator).
>> 
>> You can find details about the field calculator in the QGIS manual.
>> 
>> Hope this helps,
>> 
>> Andreas
>> 
>> On 2016-04-08 13:18, 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
>> 
>> 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

Re: [Qgis-user] Edit attribute table rows

[Lester Anderson]

Hi Andreas,

I am trying change a lot of values, if it was a few that is no problem.

The other option is to export the attribute table as a database and
edit in Excel etc and then join the table in QGIS

Cheers
Lester

On 8 April 2016 at 14:23, Neumann, Andreas  wrote:
> Hi Lester,
>
> I thought you want to set the value to 623 where the value was NULL before?
> - so just write 623 in the left field after you selected the values.
>
> Alternatively, you can do without the previous selection and use the
> following expression.
>
> CASE WHEN depth IS NULL THEN 623 ELSE depth END
>
> Hope this helps,
>
> Andreas
>
>
>
> On 2016-04-08 15:13, Lester Anderson wrote:
>
> Hello Andreas,
>
> Selecting the rows where depth = NULL is fine. The field calculator
> does not update the depth with the depth where known values are
> present.
>
> Only update selected features is checked, update existing field
> checked, with output field set to depth:
> Expression: tried just "depth" and also "depth"="depth".
>
> Have I missed something here?
>
> Thanks
>
> On 8 April 2016 at 12:30, Neumann, Andreas  wrote:
>
> Sure.
>
> It is a two-step thing:
>
> 1. Select all records where Depth IS NULL. Use the "Select Features using an
> expression" button (the Epsilon sign) for that and "depth IS NULL" as an
> expression
>
> 2. Use the field calculator and only update the selected records (the top
> checkbox in the field calculator).
>
> You can find details about the field calculator in the QGIS manual.
>
> Hope this helps,
>
> Andreas
>
> On 2016-04-08 13:18, 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
>
> 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

Re: [Qgis-user] Edit attribute table rows

[Neumann, Andreas]

Hi Lester, 

I thought you want to set the value to 623 where the value was NULL
before? - so just write 623 in the left field after you selected the
values. 

Alternatively, you can do without the previous selection and use the
following expression. 

CASE WHEN depth IS NULL THEN 623 ELSE depth END 

Hope this helps, 

Andreas 

On 2016-04-08 15:13, Lester Anderson wrote:

> Hello Andreas,
> 
> Selecting the rows where depth = NULL is fine. The field calculator
> does not update the depth with the depth where known values are
> present.
> 
> Only update selected features is checked, update existing field
> checked, with output field set to depth:
> Expression: tried just "depth" and also "depth"="depth".
> 
> Have I missed something here?
> 
> Thanks
> 
> On 8 April 2016 at 12:30, Neumann, Andreas  wrote: 
> 
>> Sure.
>> 
>> It is a two-step thing:
>> 
>> 1. Select all records where Depth IS NULL. Use the "Select Features using an
>> expression" button (the Epsilon sign) for that and "depth IS NULL" as an
>> expression
>> 
>> 2. Use the field calculator and only update the selected records (the top
>> checkbox in the field calculator).
>> 
>> You can find details about the field calculator in the QGIS manual.
>> 
>> Hope this helps,
>> 
>> Andreas
>> 
>> On 2016-04-08 13:18, 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
>> 
>> 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

Re: [Qgis-user] Edit attribute table rows

[Lester Anderson]

Hello Andreas,

Selecting the rows where depth = NULL is fine. The field calculator
does not update the depth with the depth where known values are
present.

Only update selected features is checked, update existing field
checked, with output field set to depth:
Expression: tried just "depth" and also "depth"="depth".

Have I missed something here?

Thanks

On 8 April 2016 at 12:30, Neumann, Andreas  wrote:
> Sure.
>
> It is a two-step thing:
>
> 1. Select all records where Depth IS NULL. Use the "Select Features using an
> expression" button (the Epsilon sign) for that and "depth IS NULL" as an
> expression
>
> 2. Use the field calculator and only update the selected records (the top
> checkbox in the field calculator).
>
> You can find details about the field calculator in the QGIS manual.
>
> Hope this helps,
>
> Andreas
>
> On 2016-04-08 13:18, 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
>
> 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

Re: [Qgis-user] Drive time analysis

[James Keener]

There s a pgrouting plugin for qgis to let you query a PostGIS database with 
pgrouting installed. Otherwise I normally just write the SQL myself.

Jim

On April 8, 2016 4:47:15 AM EDT, johnrobot  wrote:
>Hi
>I am looking into drive time analysis using QGIS. A typical question
>would
>be "What percentage of the population can reach location X within 45
>minutes?". Are there any examples of that using QGIS? Or would
>pgRouting be
>a better choise?
>
>Regards,
>
>Magnus
>
>
>
>--
>View this message in context:
>http://osgeo-org.1560.x6.nabble.com/Drive-time-analysis-tp5260284.html
>Sent from the Quantum GIS - User mailing list archive at Nabble.com.
>___
>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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
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

Re: [Qgis-user] Edit attribute table rows

[Neumann, Andreas]

Sure. 

It is a two-step thing: 

1. Select all records where Depth IS NULL. Use the "Select Features
using an expression" button (the Epsilon sign) for that and "depth IS
NULL" as an expression 

2. Use the field calculator and only update the selected records (the
top checkbox in the field calculator). 

You can find details about the field calculator in the QGIS manual. 

Hope this helps, 

Andreas 

On 2016-04-08 13:18, 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
> 
> 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

[Qgis-user] Edit attribute table rows

[Lester Anderson]

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

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] Drive time analysis

[johnrobot]

Hi
I am looking into drive time analysis using QGIS. A typical question would
be "What percentage of the population can reach location X within 45
minutes?". Are there any examples of that using QGIS? Or would pgRouting be
a better choise?

Regards,

Magnus



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Drive-time-analysis-tp5260284.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
___
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

Re: [QGIS-it-user] Problema repository [RISOLTO]

[Sergio Gollino]

Hai provato a configurare il proxy in qgis? Settings->options->network->use
proxy for web access (i parametri del proxy devi chiederli a chi gestisce
la tua rete aziendale comunque sono gli stessi impostati per windows).

Ciao!

Il giorno 8 aprile 2016 09:53, Maurizio Marchi 
ha scritto:

> Buondì a tutti,
> stamani ho avuto la conferma che si tratta di un problema relativo alla
> mia connessione. Infatti il portatile che a casa si collega tranquillamente
> ha invece lo stesso problema se collegato alla rete aziendale..certe
> volte è bene lavorare da casa via :))
>
> Saluti a tutti e buon lavoro
>
> --
> Maurizio Marchi
> Calenzano (FI) - Italy
> ID Skype: maurizioxyz
> Ubuntu 14.04 LTS
> linux user 552742
>
>
>
> ___
> QGIS-it-user mailing list
> QGIS-it-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-it-user
>
>


-- 
Sergio Gollino

Questo messaggio, comprensivo di eventuali allegati, è ad uso esclusivo del
destinatario e potrebbe contenere  informazioni riservate; se è stato
recapitato per errore ci scusiamo per l'accaduto e Vi invitiamo
cortesemente a darcene notizia provvedendo alla sua distruzione.
Vi ricordiamo che la diffusione, l'utilizzo e/o la conservazione dei dati
ricevuti per errore costituiscono violazione alle disposizioni del D.Lgs.
n. 196/2003 "Codice in materia di protezione dei dati personali".
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [QGIS-it-user] Problema repository [RISOLTO]

[Maurizio Marchi]

Buondì a tutti,
stamani ho avuto la conferma che si tratta di un problema relativo alla mia
connessione. Infatti il portatile che a casa si collega tranquillamente ha
invece lo stesso problema se collegato alla rete aziendale..certe volte
è bene lavorare da casa via :))

Saluti a tutti e buon lavoro

-- 
Maurizio Marchi
Calenzano (FI) - Italy
ID Skype: maurizioxyz
Ubuntu 14.04 LTS
linux user 552742
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-it-user