Re: [Qgis-user] Editing Joined Tables

[Nicolas Cadieux]

> Le 29 oct. 2020 à 01:41, Springfield Harrison  a écrit :
> 
> 
> Hello Nicolas,
> 
> Thanks for the comments, I'll go over them shortly.  Only a few dozen trees, 
> not 1 million!
> 
Well thats  easier!  Funny, your message got mixed up with another email list 
with a question about 1.3 million features... 
keep us posted!
Good luck
Nicolas
> -
> Cheers, Spring Harrison
> 
> 
> 
> On 10/28/20 07:52, Nicolas Cadieux wrote:
>> I have not followed this closely but see below.
>> 
>>> Le 28 oct. 2020 à 04:40, Springfield Harrison  a 
>>> écrit :
>>> 
>>> 
>>> Hello Charles & Sebastian,
>>> 
>>> Thanks very much for your suggestions.  I did try the Geopackage but it 
>>> seems much less convenient for my needs than shapefiles or CSV files.
>>> 
>> I thing you said you had over a million tree?  Shapefile will be very slow 
>> even if you create a spatial index. You would be better using a geopackage.  
>> What make geopackage less convenient?  Do you have a work flow that can only 
>> produce a csv and a shapefile?
>>>   I didn't try the xlsx option as I require a CSV table as the primary 
>>> table in the join (to import UTM coordinates). 
>>> 
>> With over a million object, you will go over the xlsx max limit.  
>>> Other spreadsheet formats do not trigger the X/Y georeferencing options 
>>> found in the delimited text file type.
>>> 
>> Csv table is a convenient way manually adding coordinates but if all you 
>> need is to have access to the x/y georefencing options, you can do that with 
>> any filed in any vector file by updating the geometry from a field using the 
>> field calculator. Using something like geom_from_wkt('POINT('||"x"||' 
>> '||"y"||')').  
>> 
>> https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields
>> 
>>> I need to frequently add UTM positions to the primary table plus make 
>>> manual edits to it so it needs to be a shapefile.  However, with care, I 
>>> can copy and paste new UTM records from a CSV file into the primary 
>>> shapefile.
>>> 
>> 
>>> Anyway, thanks again, your suggestions helped me along . . . . .
>>> 
>>> -
>>> Cheers, Springfield 
>>> 
>>> 
>>> 
>>> On 10/27/20 09:14, Sebastian Gutwein wrote:
 I have found that CSV layers are not editable but .xlsx layers are. I just 
 tried editing a joined field in 2 .xslx layers and it worked if I have 
 upsert on edit checked. QGIS 3.14.16
 
 On Tue, Oct 27, 2020 at 5:02 AM Charles Dixon-Paver  
 wrote:
> As far as I'm aware you cannot edit external flat file tables like csv as 
> they are imported into a QGIS project in a read only state. 
> 
> I would try exporting those tables to a database table (like a geopackage 
> table without geometry) and then performing the join to see if you get 
> the desired result.
> 
> On Tue, 27 Oct 2020 at 10:03, Springfield Harrison  
> wrote:
>> Hello All:
>> 
>> Using version 3.10.10, I have joined two MS Excel files: Positions.csv 
>> and catalogue.xls using a common field called Tag. This is a tree 
>> inventory project.
>> 
>> All is well except I cannot edit either table from within QGIS. I need 
>> to create some new positions manually and generally update the tables 
>> continuously.
>> 
>> In the Join dialogue, I have selected Enable Editing but it has no 
>> effect.
>> 
>> I feel that different file types or a different procedure may facilitate 
>> this process but am exhausted from trying so many blind alleys.
>> 
>> Is there a trick to being able to edit joined tables?
>> 
>> Thanks very much . . . .
>> 
>> -
>> Cheers, Springfield Harrison, British Columbia
>> 
>> 
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> ___
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Editing Joined Tables

[Springfield Harrison]

Hello Nicolas,

Thanks for the comments, I'll go over them shortly.  Only a few dozen 
trees, not 1 million!


-
Cheers, Spring Harrison




On 10/28/20 07:52, Nicolas Cadieux wrote:

I have not followed this closely but see below.

Le 28 oct. 2020 à 04:40, Springfield Harrison  
a écrit :




Hello Charles & Sebastian,

Thanks very much for your suggestions.  I did try the Geopackage but 
it seems much less convenient for my needs than shapefiles or CSV files.


I thing you said you had over a million tree?  Shapefile will be very 
slow even if you create a spatial index. You would be better using a 
geopackage.  What make geopackage less convenient?  Do you have a work 
flow that can only produce a csv and a shapefile?


  I didn't try the xlsx option as I require a CSV table as the 
primary table in the join (to import UTM coordinates).



With over a million object, you will go over the xlsx max limit.


Other spreadsheet formats do not trigger the X/Y georeferencing 
options found in the delimited text file type.


Csv table is a convenient way manually adding coordinates but if all 
you need is to have access to the x/y georefencing options, you can do 
that with any filed in any vector file by updating the geometry from a 
field using the field calculator. Using something like 
geom_from_wkt('POINT('||"x"||' '||"y"||')').


https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields

I need to frequently add UTM positions to the primary table plus make 
manual edits to it so it needs to be a shapefile.  However, with 
care, I can copy and paste new UTM records from a CSV file into the 
primary shapefile.





Anyway, thanks again, your suggestions helped me along . . . . .

-
Cheers, Springfield



On 10/27/20 09:14, Sebastian Gutwein wrote:
I have found that CSV layers are not editable but .xlsx layers are. 
I just tried editing a joined field in 2 .xslx layers and it worked 
if I have upsert on edit checked. QGIS 3.14.16


On Tue, Oct 27, 2020 at 5:02 AM Charles Dixon-Paver 
mailto:char...@kartoza.com>> wrote:


As far as I'm aware you cannot edit external flat file tables
like csv as they are imported into a QGIS project in a read only
state.

I would try exporting those tables to a database table (like a
geopackage table without geometry) and then performing the join
to see if you get the desired result.

On Tue, 27 Oct 2020 at 10:03, Springfield Harrison
mailto:stellar...@gmail.com>> wrote:

Hello All:

Using version 3.10.10, I have joined two MS Excel files:
Positions.csv
and catalogue.xls using a common field called Tag. This is a
tree
inventory project.

All is well except I cannot edit either table from within
QGIS. I need
to create some new positions manually and generally update
the tables
continuously.

In the Join dialogue, I have selected Enable Editing but it
has no effect.

I feel that different file types or a different procedure
may facilitate
this process but am exhausted from trying so many blind alleys.

Is there a trick to being able to edit joined tables?

Thanks very much . . . .

-
Cheers, Springfield Harrison, British Columbia


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Refresh layer at interval

[nagyrob...@yahoo.com]

Hi All!
I am trying to understand the behavior of Layer->Render-> Refresh layer at 
interval in QGIS   
   - I sat up a flask rest api which serves a geojson.
   - I added the geojson to QGIS via Add Layer-> 
   
   - a. Protocol HTTP/cloud/etc 
   - b. Type: HTTP 
   - c.URI: localhost/points.geojson The points are represented on the map 
correctly
   
   - I changed the layer->Properties->Rendering-> Refresh layer at interval (5 
sec)

I would have expected that there would be a call every 5 seconds towards the 
server and the map data would be updated accordingly. But the layer does not 
get refreshed. I don't see any changes neither when I remove a point from the 
json file on my local drive, nor if I change an attribute. If I press F5 then 
the canvas refreshes and it automatically loads the new data and I can see the 
changes. Is this the behavior that is wanted or am I misunderstanding the 
function of this tool? It seems like the data is cached somewhere?
from flask import Flask
from flask_restful import Api, Resource
import json

app = Flask(__name__)
api = Api(app)

class point(Resource):

def get(self):
with open('C:/points/venv/src/points.geojson') as json_file:
data = json.load(json_file)
return data

api.add_resource(point,"/points.geojson")

if __name__=="__main__":
app.run(debug=True)Robert Nagy

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [QGIS-it-user] Stile Linea Evidenziazione

[Ludovico]

Si, renderizza così. Devi cambiare unità di misura e scegliere ad esempio
unità di mappa.



-
Dott. For. Ludovico Frate, PhD

--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-Italian-User-f5250612.html
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

Re: [Qgis-user] impossible to save QGIS project

[Charles Dixon-Paver]

I'm not sure what the specific issue is you're facing, but if you're having
trouble and don't want to lose work, you could try to save the project
inside a geopackage as a temporary work around until this is resolved.

On Wed, 28 Oct 2020 at 13:32, Harald von der Osten 
wrote:

> Hi out there,
>
> Suddenly an error occurred when I try to save my project. It seems not
> possible to save it because of this message:
>
>
>
>
>
> So I created this strange sub-folder. But then the error message changes
> to:
>
>
>
>
>
> I have no idea for a work-around. If someone can give me a hint I would be
> very happy...
>
> Using QGIS 3.14.16-Pi on macOS 10.15
>
> Thanks a lot,
> Harry
>
>
> von meinem iPhone gesendet
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Editing Joined Tables

[Nicolas Cadieux]

I have not followed this closely but see below.

>> Le 28 oct. 2020 à 04:40, Springfield Harrison  a écrit 
>> :
> 
> Hello Charles & Sebastian,
> 
> Thanks very much for your suggestions.  I did try the Geopackage but it seems 
> much less convenient for my needs than shapefiles or CSV files.
> 
I thing you said you had over a million tree?  Shapefile will be very slow even 
if you create a spatial index. You would be better using a geopackage.  What 
make geopackage less convenient?  Do you have a work flow that can only produce 
a csv and a shapefile?
>   I didn't try the xlsx option as I require a CSV table as the primary table 
> in the join (to import UTM coordinates). 
> 
With over a million object, you will go over the xlsx max limit.  
> Other spreadsheet formats do not trigger the X/Y georeferencing options found 
> in the delimited text file type.
> 
Csv table is a convenient way manually adding coordinates but if all you need 
is to have access to the x/y georefencing options, you can do that with any 
filed in any vector file by updating the geometry from a field using the field 
calculator. Using something like geom_from_wkt('POINT('||"x"||' '||"y"||')').  

https://gis.stackexchange.com/questions/285634/qgis-update-feature-geometry-from-attribute-fields

> I need to frequently add UTM positions to the primary table plus make manual 
> edits to it so it needs to be a shapefile.  However, with care, I can copy 
> and paste new UTM records from a CSV file into the primary shapefile.
> 

> Anyway, thanks again, your suggestions helped me along . . . . .
> 
> -
> Cheers, Springfield 
> 
> 
> 
> On 10/27/20 09:14, Sebastian Gutwein wrote:
>> I have found that CSV layers are not editable but .xlsx layers are. I just 
>> tried editing a joined field in 2 .xslx layers and it worked if I have 
>> upsert on edit checked. QGIS 3.14.16
>> 
>> On Tue, Oct 27, 2020 at 5:02 AM Charles Dixon-Paver  
>> wrote:
>>> As far as I'm aware you cannot edit external flat file tables like csv as 
>>> they are imported into a QGIS project in a read only state. 
>>> 
>>> I would try exporting those tables to a database table (like a geopackage 
>>> table without geometry) and then performing the join to see if you get the 
>>> desired result.
>>> 
>>> On Tue, 27 Oct 2020 at 10:03, Springfield Harrison  
>>> wrote:
 Hello All:
 
 Using version 3.10.10, I have joined two MS Excel files: Positions.csv 
 and catalogue.xls using a common field called Tag. This is a tree 
 inventory project.
 
 All is well except I cannot edit either table from within QGIS. I need 
 to create some new positions manually and generally update the tables 
 continuously.
 
 In the Join dialogue, I have selected Enable Editing but it has no effect.
 
 I feel that different file types or a different procedure may facilitate 
 this process but am exhausted from trying so many blind alleys.
 
 Is there a trick to being able to edit joined tables?
 
 Thanks very much . . . .
 
 -
 Cheers, Springfield Harrison, British Columbia
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
 Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> ___
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[QGIS-it-user] Stile Linea Evidenziazione

[Jacopo Vannacci]

Salve a tutti e piacere innanzitutto!


Versione Qgis sia 3.10.11 che 3.16, su windows 10

Ho un layer lineare (temporaneo, o su gpkg poco cambia) con linea con 
tratteggio custom, negli spazi dell tratteggio mi serve una linea di 
evidenziazione (per inserire delle lettere).

es: --- A --- A ---

Il tutto funziona (viene renderizzato bene) solo se lo zoom della mappa è sopra 
al 101% vi risulta? sto sbagliando qualcosa?

Vi allego uno stile di base per layer lineare con foto d'esempio, se serve un 
progetto intero ve lo giro

grazie a tutti.

test_LineaEvidenziazione.qml
Description: Binary data
___
QGIS-it-user mailing list
QGIS-it-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/qgis-it-user

[Qgis-user] Error al iniciar QGIS 3.10 IndexError: list index out of range

[Alejandro Chamizo de Castro]

Hola,

cada vez que inicio QGIS se me salta una ventana con el siguiente error:


IndexError: list index out of range

Traceback (most recent call last):
  File 
"C:/PROGRA~1/QGIS3~1.10/apps/qgis-ltr/./python/plugins\processing\script\ScriptAlgorithmProvider.py",
line 110, in loadAlgorithms
folder = ScriptUtils.resetScriptFolder(folder)
  File 
"C:/PROGRA~1/QGIS3~1.10/apps/qgis-ltr/./python/plugins\processing\script\ScriptUtils.py",
line 114, in resetScriptFolder
commonSettingPath = os.path.join(paths[appIndex], paths[profileIndex])
IndexError: list index out of range


¿Sabéis a qué se debe?

Saludos y gracias

-- 
Alejandro Chamizo de Castro
+34 653681823
www.gisland.es

[image: Mailtrack]

Remitente
notificado con
Mailtrack

28/10/20
13:50:21
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] impossible to save QGIS project

[Harald von der Osten]

Hi out there,

Suddenly an error occurred when I try to save my project. It seems not possible 
to save it because of this message:





So I created this strange sub-folder. But then the error message changes to:





I have no idea for a work-around. If someone can give me a hint I would be very 
happy...

Using QGIS 3.14.16-Pi on macOS 10.15

Thanks a lot,
Harry


von meinem iPhone gesendet
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Editing Joined Tables

[Springfield Harrison]

Hello Charles & Sebastian,

Thanks very much for your suggestions.  I did try the Geopackage but it 
seems much less convenient for my needs than shapefiles or CSV files.  I 
didn't try the xlsx option as I require a CSV table as the primary table 
in the join (to import UTM coordinates). Other spreadsheet formats do 
not trigger the X/Y georeferencing options found in the delimited text 
file type.


I need to frequently add UTM positions to the primary table plus make 
manual edits to it so it needs to be a shapefile.  However, with care, I 
can copy and paste new UTM records from a CSV file into the primary 
shapefile.


Anyway, thanks again, your suggestions helped me along . . . . .

-
Cheers, Springfield



On 10/27/20 09:14, Sebastian Gutwein wrote:
I have found that CSV layers are not editable but .xlsx layers are. I 
just tried editing a joined field in 2 .xslx layers and it worked if I 
have upsert on edit checked. QGIS 3.14.16


On Tue, Oct 27, 2020 at 5:02 AM Charles Dixon-Paver 
mailto:char...@kartoza.com>> wrote:


As far as I'm aware you cannot edit external flat file tables like
csv as they are imported into a QGIS project in a read only state.

I would try exporting those tables to a database table (like a
geopackage table without geometry) and then performing the join to
see if you get the desired result.

On Tue, 27 Oct 2020 at 10:03, Springfield Harrison
mailto:stellar...@gmail.com>> wrote:

Hello All:

Using version 3.10.10, I have joined two MS Excel files:
Positions.csv
and catalogue.xls using a common field called Tag. This is a tree
inventory project.

All is well except I cannot edit either table from within
QGIS. I need
to create some new positions manually and generally update the
tables
continuously.

In the Join dialogue, I have selected Enable Editing but it
has no effect.

I feel that different file types or a different procedure may
facilitate
this process but am exhausted from trying so many blind alleys.

Is there a trick to being able to edit joined tables?

Thanks very much . . . .

-
Cheers, Springfield Harrison, British Columbia


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Question on Aequilibrae

[cankat]

Dear Pedro Camargo,

Thank you for the great videos and documents. I would like to learn if it is
possible to run TransCAD or AequilibraE to perform public transit assignment
stage of 4-step modeling with a completely new equation except from
Pathfinder or Stochastic User Equilibrium? If it is possible, how can we add
the formula to the softwares by hand? If it is not possible, is it the right
way to conduct a Stated Preference survey for a smaller scale (not whole
city but some stations) network?

Kind regards,
Cankat
cankattanrive...@gmail.com



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Trying new equations for public transit assignment

[cankat]

Hello,

Thank you for the great sharings here. I would like to learn if it is
possible to run TransCAD or AequilibraE to perform public transit assignment
stage of 4-step modeling with a completely new equation except from
Pathfinder or Stochastic User Equilibrium? If it is possible, how can we add
the formula to the softwares by hand? If it is not possible, is it the right
way to conduct a Stated Preference survey for a smaller scale (not whole
city but some stations) network?

Kind regards,
Cankat



--
Sent from: http://osgeo-org.1560.x6.nabble.com/QGIS-User-f4125267.html
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user