Re: [Qgis-user] Query Builder - I thought I understood what I was doing.

2024-06-12 Thread chris hermansen via QGIS-User
Jeremy, list;

On Wed, Jun 12, 2024 at 11:40 AM Jeremy Swarm via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> I have a set of vectors (it's a parcel map) from my county. This layer has
> a number of attributes defined. I would like to filter the features by an
> attribute called "DateSale". it is formatted MM/DD/. I believe it is
> astring. I would like to find features which end with any of
> 2021,2022,2023, ,or 2024. I have not been able to build a successful filter
> with the query builder.
>
> You don't say why you "believe" it is a string.  You can check the field
types...

Anyway, in case it's a date, you can use the year function in the query
builder e.g. year(DateSale)

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Fwd: Export data with tiff and csv files in QGIS 3.36.3

2024-06-11 Thread chris hermansen via QGIS-User
Richard, Sofia and list;

Sorry to top post here, but I wonder if this might be due to the various
input layers being in different coordinate systems?  I seem to recall a
problem like that from "back in the day".

On Tue, Jun 11, 2024 at 9:07 AM Richard McDonnell via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi Sofia,
>
> I unfortunately am unable to access the files you sent, as there are
> restrictions on our systems here in relation to accessing files.
>
> Apologies for that.
>
> Kind Regards,
>
>
>
> Richard
>
>
>
> ——
> Richard McDonnell MSc GIS, FME Certified Professional
> *Flood Risk Management - Data Management*
>
> ——
> Oifig na nOibreacha Poiblí
> Office of Public Works
>
> Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36
> Jonathan Swift Street, Trim, Co Meath, C15 NX36
> ——
> M +353 87 688 5964 T +353 46 942 2409
> https://gov.ie/opw
>
> ——
> To send me files larger than 30MB, please use the link below
> https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie
>
> Email Disclaimer:
> https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/
>
> *From:* ΣΟΦΙΑ ΤΣΙΤΟΥ 
> *Sent:* 11 June 2024 14:34
> *To:* Richard McDonnell 
> *Cc:* qgis-user@lists.osgeo.org
> *Subject:* Re: [Qgis-user] Fwd: Export data with tiff and csv files in
> QGIS 3.36.3
>
>
>
>  igme5000.tif
> 
>
> Dear Richard,
>
>
>
> Thank you very much for your quick response. I followed this procedure
> many times but unfortunately I gοt null values. Attached you can find the
> files that I used (two different tiff maps-I use one map each time- and one
> csv file with the coordinates). I can't find out if there's a problem with
> my files or something I'm not doing right in the process.
>
>
>
> Thank you.
>
>
>
> Warm regards,
>
> Sofia Tsitou
>
>
>
> Στις Τρί 11 Ιουν 2024 στις 3:42 μ.μ., ο/η Richard McDonnell <
> richard.mcdonn...@opw.ie> έγραψε:
>
> Hi Sofia,
>
> So I will start from the beginning, hopefully I understand your query
> properly…
>
>
>
> 1.   Add your Raster to the Canvas
>
> 2.   Using the *Data Source Manager* and *Delimited Text*, I add the
> CSV, making sure the Headers, Columns and rows are correct, while also
> setting/specifying the X, Y and Z fields (as required)
>
> 3.   This will result in a Point Dataset being added to the Canvas,
> with the CSV loaded as a temporary layer
>
> 4.   In the Processing Toolbox search bar, type “*sample*” and then
> select *Sample raster values*
>
> a.   *Input layer* set to the Point Dataset
>
> b.   *Raster Layer* set to the Raster you want to analyse
>
> c.   *Output column Prefix* is handy if you have multiple datasets
> you want to sample, as you can change this for each subsequent sample.
>
> d.   *Sampled* you can specify a Location for your output dataset, or
> you can leave it as a temporary layer until you have carried out all
> sampling.
>
>
>
> I hope that clarifies things,
>
>
>
> Kind Regards,
>
>
>
> Richard
>
>
>
>
>
>
> * ——*
> *Richard McDonnell MSc GIS, FME Certified Professional*
> *Flood Risk Management - Data Management*
>
> ——
> *Oifig na nOibreacha Poiblí*
> Office of Public Works
>
> *Sráid Jonathan Swift, Baile Átha Troim, Co na Mí, C15 NX36 *
> Jonathan Swift Street, Trim, Co Meath, C15 NX36
> ——
> M +353 87 688 5964 T +353 46 942 2409
> https://gov.ie/opw
>
> ——
> To send me files larger than 30MB, please use the link below
> https://filetransfer.opw.ie/filedrop/richard.mcdonn...@opw.ie
>
> Email Disclaimer:
> https://www.gov.ie/en/organisation-information/439daf-email-disclaimer/
>
> *From:* QGIS-User  *On Behalf Of *S?F??
> ?S via QGIS-User
> *Sent:* 11 June 2024 12:52
> *To:* qgis-user@lists.osgeo.org
> *Subject:* [Qgis-user] Fwd: Export data with tiff and csv files in QGIS
> 3.36.3
>
>
>
>
>
> Dear QGIS team,
>
>
>
> I have two maps in tiff format and coordinates in csv format and I try
> through zonal statistics and sample raster values to export the data but it
> gives me null values. Could you tell me the steps to extract the data
> because I might be making a mistake?
>
>
>
> Thank you in advance,
>
> Sofia Tsitou
>
> --
>
> Tsitou Sofia
>
>
>
> Αdjunct Lecturer
>
> Department of Economics
>
> University of Ioannina
>
> Greece
>
>
>
> Post Doctoral Fellow
>
> Department of Economics
>
> University of Macedonia, Thessaloniki
>
> Greece
>
>
>
> Research Fellow
>
> DAISSy Research Group
>
> Hellenic Open University
>
> Greece
>
>
>
> e-mail: sofitsi...@gmail.com
>
> Homepage: https://sites.google.com/view/sofiatsitou/home
> 
>
>
>
>
> --
>
> Tsitou Sofia
>
>
>
> Αdjunct Lecturer
>
> Department of Economics
>
> University of Ioannina
>
> Greece
>
>
>
> Post Doctoral Fellow
>
> Department of Economics
>
> University of Macedonia, Thessaloniki
>
> Greece
>
>
>
> Research Fellow
>
> DAISSy Research Group
>
> Hellenic Open University
>
> Greece
>
>

Re: [Qgis-user] Pakistan QGIS data

2024-06-03 Thread chris hermansen via QGIS-User
Nicole and list;

On Mon, Jun 3, 2024 at 8:01 AM Nicole Minor via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello!
>
> My boss will be doing some agricultural work in Pakistan and I would like
> to know if you could advise me on how I could get QGIS data for Pakistan.
> I appreciate any help you can give me.
>
> I see quite a lot of sources for spatial data in Pakistan when I enter the
phrase "pakistan spatial data" into my favourite search engine.

For example, this link shows 43 spatial datasets available for Pakistan,
some of which seem to relate to agricultural work:

https://datasetsearch.research.google.com/search?ref=TDJjdk1URnlabkE0Tm01ZmFBPT0sTDJjdk1URnphbkkxZVdkeU5BPT0sTDJjdk1URjBjekZtTUd0cU1BPT0%3D=pakistan%20spatial=L2cvMTF2ejg3aGYzZw%3D%3D

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Labeling: Allow HTML Formatting, text-size and map units

2024-05-16 Thread chris hermansen via QGIS-User
Thomas and list,

On Thu, May 16, 2024, 06:39 Thomas Schüttenberg  wrote:

> Hi Chris,
>
> yes I tried that. Any css-unit I could think of as well as em, % and
> code-words (large). But only pt resulted in a visible change on the canvas.
>
> Not sure if it is just not implemented or if it is a bug.
>

So ... works but  doesn't... That seems to be
surprising behaviour.

I can get that CSS style directives might not work the way one might hope
(that often happens to me in other circumstances...)

This is tempting me to experiment. Thanks for that!


> Thomas
>
> > chris hermansen  hat am 15.05.2024 21:00 CEST
> geschrieben:
> >
> >
> > Thomas and list,
> >
> >
> > On Wed, May 15, 2024 at 7:20 AM Thomas Schüttenberg via QGIS-User <
> qgis-user@lists.osgeo.org> wrote:
> > > Ha!
> > >  I found an other way around to do the trick, suitable for my use case
> at least:
> > >
> > >  1) increasing the (overall) text size setting on the text tab by 2/3
> > >  2) putting only the attributes/text strings of the second and
> following lines between ... tags, which renders them about 2/3
> smaler, i.e. same as before.
> > >
> > >  The (reverse) result is a multi line label with the first line
> emphazised by its larger size! ;-)
> > >
> > >  "Bezeichnung" || 'D ' || round("Deckelhohe",2) ||
> 'S ' || round( "Sohlhohe" ,2) || ''
> > >
> > In your first note you mentioned:
> >
> > > But only pt (points) seams to work as the unit in this place, which
> gives a fixed size throughout all scales and does not respect the behavior
> of the map units with maximum scale setting.
> >
> > I suppose you tried style="font-size: 75%;" and maybe style="font-size:
> 0.75em;", and they did not work?
> >
> > I wonder if, besides ..., you might have tried
> ...?
> > --
> >
> > Chris Hermansen · clhermansen "at" gmail "dot" com
> >
> > C'est ma façon de parler.
>
___
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] Labeling: Allow HTML Formatting, text-size and map units

2024-05-15 Thread chris hermansen via QGIS-User
Thomas and list,

On Wed, May 15, 2024 at 7:20 AM Thomas Schüttenberg via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Ha!
> I found an other way around to do the trick, suitable for my use case at
> least:
>
> 1) increasing the (overall) text size setting on the text tab by 2/3
> 2) putting only the attributes/text strings of the second and following
> lines between ... tags, which renders them about 2/3 smaler,
> i.e. same as before.
>
> The (reverse) result is a multi line label with the first line emphazised
> by its larger size! ;-)
>
> "Bezeichnung" || 'D ' || round("Deckelhohe",2) ||
> 'S ' || round( "Sohlhohe" ,2) || ''
>
> In your first note you mentioned:

But only pt (points) seams to work as the unit in this place, which gives a
> fixed size throughout all scales and does not respect the behavior of the
> map units with maximum scale setting.


I suppose you tried style="font-size: 75%;" and maybe style="font-size:
0.75em;", and they did not work?

I wonder if, besides ..., you might have tried
...?
-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Command for raster reprojetion from geodetic to cartesian coordinates

2024-05-10 Thread chris hermansen via QGIS-User
Alexandre and list,

On Fri, May 10, 2024 at 9:46 AM Alexandre dos Santos <
alexandre.san...@ifmt.edu.br> wrote:

> Hi Chris,
>
> Thanks for the tip, but dtsSRS parameter, support too  "+proj=laea +x_0=0
> +y_0=0 +lon_0=0 +lat_0=0" or just EPSG?
>
> Maybe this more in-depth tutorial from the QGIS training manual section
6.1 will help you solve your problem?

https://docs.qgis.org/3.34/en/docs/training_manual/vector_analysis/reproject_transform.html

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Command for raster reprojetion from geodetic to cartesian coordinates

2024-05-10 Thread chris hermansen via QGIS-User
Alexandre and list,

On Fri, May 10, 2024 at 5:50 AM Alexandre dos Santos via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Dear Member,
>
> I have a Global raster of elevation (''wc2.1_10m_elev.tif) and I'd like
> to reprojection from (+proj=longlat +datum=WGS84 +no_defs +ellps=WGS84
> +towgs84=0,0,0) to ("+proj=laea +x_0=0 +y_0=0 +lon_0=0 +lat_0=0"). Is
> there some command for this?
>
>
In the online manual in section  28.2.5.3 you will find the usage of the
"warp" command which is used to reproject raster layers.

https://docs.qgis.org/3.34/en/docs/user_manual/processing_algs/gdal/rasterprojections.html#warp-reproject


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Search through folders and combine SHP files

2024-05-09 Thread chris hermansen via QGIS-User
Tony and list,

On Thu, May 9, 2024, 16:06 Tony Shepherd (FarmMaps NZ) via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi
>
>
>
> I have loads, literally thousands, of SHP, GPKG, TAB files located in
> loads of different folders and sub-folders.
>
>
>
> Is there a plugin that will trawl through a set of folders, copy say just
> the polygons from each file into a new file, and populate a field with say
> the filename and folder the polygon(s) came from?
>
>
>
> Essentially combining a heap of files into one with some metadata about
> where the data came from?
>
>
>
> Why?  I have files from clients dating back about 20 years.  Clients sell
> properties.  Properties get subdivided.  New clients come and see us, and
> often we don’t realise we have GIS info on file for that property from many
> years ago, usually under a different name.  It would be handy to see a
> polygon on the screen and easily go back to some old GIS data.
>
>
>
> Maybe I am missing an easy tool to do this, but I can’t see anything
> obvious.
>

Have you considered creating a PostGIS database, where each file imported
is in a table named for the source? You could also create a companion
metadata table.

You would script something like this with shp2pgsql

https://postgis.net/docs/using_postgis_dbmanagement.html

To load the spatial data and likely the psql client with CREATE TABLE  and
INSERT statements in an SQL script.

If you're on Linux or OS/X you would use the find command to create the
shell script. Probably something similar in Power Shell if you're on
Windows.

>
___
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] INSTALL QGIS DESKTOP IN LUNUX UBUNTU THAT PERMIT CONNECT TO ORACLE DATABASES AND LOAD VECTOR LAYERS

2024-05-08 Thread chris hermansen via QGIS-User
Fredy and list,

On Wed, May 8, 2024 at 2:31 PM Fredy Varon via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> HI
> INSTALL QGIS DESKTOP IN LUNUX UBUNTU THAT PERMIT CONNECT  TO ORACLE
> DATABASES AND LOAD VECTOR LAYERS
>
> HOWTO
>
> PLEASE
>
> Fredy, have you reviewed the QGIS documentation on Oracle Spatial
connections found here:

https://docs.qgis.org/3.34/en/docs/user_manual/managing_data_source/opening_data.html#connecting-to-oracle-spatial

If you have, and it doesn't work for you, please provide more details
(error messages etc).

Es ideal comunicar en inglés pero hay hablantes de castellano en esta lista
y Google Translate nos ayuda también.

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] GeoJSON problem

2024-04-24 Thread chris hermansen via QGIS-User
Rafal and list,

On Wed, Apr 24, 2024 at 11:47 AM Rafal Jonca via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> I wanted ask you are here any GeoJSON specialists ?
>
>
> I was preparing some vector point features, with names, from some time,
> but now I am looking and they are empty (name attributes are null, only
> vector point locations still exist). It happened after saving to GeoJSON.
>
> I am not a GeoJSON expert. Are these attributes still there somewhere in
> it or I have to make them once again from scrap ?
>
> Almost two months of work to trash :/
>

You don't say what you did to "prepare" your vector point features except
that you lost some "names" after saving to GeoJSON.

Were you using QGIS?  How did you create your vector point features?

Looking at the sample GeoJSON file here

https://gist.github.com/wavded/1200773?short_path=99c1af9

might give you some insights.  In particular, you can see that attributes
are called "properties" and are rendered as a set of key-value pairs.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] web based spatial MIS/Dashboard

2024-04-22 Thread chris hermansen via QGIS-User
Janneke and list,

On Mon, Apr 22, 2024, 03:30 Janneke van Dijk via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Dear QGIS developers and users,
>
> [Snip]
>
> More and more, in addition to wanting 'a GIS system', there are requests
> for a web based management information system which shows both maps and
> a dashboard with selected KPIs, and where selecting a feature on the map
> will update the graphs and charts in the dashboard. So far, I have not
> been able to find out if this is possible using Open Source software,
> what it would require in terms of setting it up/configuring/additional
> development. I assume it is technically possible to develop it.
>

In my experience there are a few ways to go about this, but given that you
want something that gives a broader range of graphics support on the
browser end, a really great solution is D3.js

https://d3js.org/

This will give you a large range of ultra high quality data visualization
possibilities in the browser.

You would combine this with something like Bootstrap to build a beautiful
responsive web application. You could also consider something like React or
Vue or Angular.

Then there is the back end. You could also go with a JavaScript backend
like Node, or a Python backend like Django, or Rails which runs on Ruby, or
Spring which runs on Java. My own personal favourite is Grails which runs
on Groovy. All of these wrap a database engine, and given your interest in
geographical data PostGIS / PostgreSQL is the obvious candidate.

Depending on the backend framework you choose, the typical approach would
be to model your data in it, then use it to create basic controllers and
views, then start working on the dashboard views.

However you can build a static dashboard right away in HTML, Bootstrap and
D3 to be a design proof oQ,xf concept. This will also get you familiar with
what you need to learn at the client satisfaction end.

>
> Does anyone have experience with this? How did you set it up? Any
> examples I could have a look at?
>

You will see that the D3 documentation is very complete. Manning Books has
a good intro to D3 if you like books. Bootstrap is also well documented.

The backend frameworks I mentioned are also well-documented, as are PostGIS
( Manning has a great series on it) and PostgreSQL.

I have been building web applications in Grails since its early days, say
2010 ish. I can walk you through an example or two if you want to jump on a
video conference.


> Is there a demand for it (from my limited view - yes)?


There is a sizeable community around non free dashboarding stuff like
Tableau. But non free.

There are lots of web mapping service tools around. D3 in my (limited)
experience is a much broader and more configurable data visualization
approach.

Lots of people want dashboards (smile).


Are there
> thoughts about developing such functionality more 'out of the box'
> within the QGIS community? What would such development require? My
> impression is that there is more (very tentative) willingness from
> donors to consider contributing to Open Source software development as
> part of development projects, but it may mean that it would need to be
> written into tender proposals with indicative figures for the required
> funding.
>

Personally I don't find out-of-the-box data visualization tools all that
convincing at the point where I need to do something complicated. (Insert
bad analogy here about building a house with only a very good adjustable
wrench).

If you're going to end up building a complex web based data visualization
application you probably need to go beyond the simple stuff.

I hope this gives you some ideas.

Chris Hermansen
___
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] Move to discourse

2024-04-11 Thread chris hermansen via QGIS-User
Iain and list,

On Thu, Apr 11, 2024 at 2:35 PM IainS via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> I am not sure what is being proposed here – is this list, QGIS-User to
> close or move?
>

If you look back through this conversation, you will see that QGIS-User is
proposed (or going) to move to a non-mailing-list platform called
"Discourse".  Some of us users of this mailing list aren't positive about
this.

>
> Are we then to ban “lazy” users from asking “trivial questions” because
> QGIS is so well documented.
>
>
>
> Well, how helpful is that approach?
>
>
>
> The QGIS community includes new starter as well as the experts and
> inevitably basic questions will be asked (another would be about Dfx and
> Dwg files not projecting). They are asked as the users are in need of help
> and may not have the time to “do the research”. If you are starting out
> these are not trivial questions rather, they stem from deep frustration
> that things are not working as they are supposed to. So, when they turn to
> this list for help they are told sorry it’s too trivial? Is that really in
> the spirit of the open-source community?
>

Since the majority of the support channeled through this list is provided
by the readership on a voluntary basis, which I would argue is the spirit
of open source, I would venture that these voluntary contributors don't
appreciate being taken advantage of by users who are too busy to do a bit
of basic investigation on their own, or who pose poorly thought out
questions lacking in the detail necessary to provide help, etc etc.  I
don't have any experience of people being told their questions are "too
trivial", but sometimes gentle comments are included in the response that
indicate the answer is not all that far away.  Politeness is a two way
street.


>
>
> I propose that a QGIS-Elite user group be set up and those who want to can
> move there leaving us Users to ask our trivial and unresearched questions
> in this forum.
>
>
> I suggest that if you drive all the users with decent knowledge of the
subject off the list by an "ask before doing a bit of digging" approach,
there will be no one left to answer those questions.

Anyway, all of this is kind of off the topic of mailing list vs Discourse.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Announce - migrate our mailing lists to Discourse

2024-04-04 Thread chris hermansen via QGIS-User
Régis and everyone else,

My apologies; I try not to top post but my response is more an overall
reaction to your announcement rather than a point by point response.

I was a member (??) over at opensource.com's Discourse instance until
RedHat decided to shut down support for opensource.com, so I have some
experience with that Discourse configuration, also plenty of experience
with mailing lists.  Also familiarity with the Ubuntu Forums, Stack
Exchange etc.

In my experience, Discourse "out of the box" doesn't offer any net benefit
to its users.

It's quite possible that people interested in, and willing to invest time
and effort into customizing their usage profile would benefit more from
Discourse than from a mailing list.  I have no experience with that.

You may be correct when you say that we will attract more new users by
offering them Discourse than by maintaining a mailing list.  I guess the
question that begs to be asked is, will those new users thereby turn into
contributors, or will the biggest Discourse channel be "how do I install
QGIS on my new Mac"?

I suppose, perhaps wrongly, that most of us on this (and other) mailing
lists are here because the list provides a sense of community, an
opportunity to pay back by offering a bit of help, an opportunity to
stumble on something new and useful from time to time... what else?  I'm
pretty sure none of us participate in this list to learn how to participate
effectively in lists.  Moreover, we don't really have the tools to "only
pay attention to topics X, Y and Z".  So all of us get to see the beginner
questions, and the responses, and sometimes we find ourselves in the
situation of starting fresh with something that, because of this broad
familiarity, is not a total blank.

In contrast, in my experience, moving to Discourse, or any other similar
forum-type structure, allows or even encourages us to stick to certain
topics that we think may be of interest and avoid all others.

I would argue that we thereby cheapen and diminish our contribution back to
the forum, simply because we miss real opportunities to help while we avoid
reading certain topics; and by doing so, we reduce the sense of community
we get by belonging to the list.  I would further argue that we run the
risk of not learning many new things because by streaming topics into tens
or hundreds of specialist channels, we inevitably miss things that might
benefit us.

Finally, we have the "opportunity" to spend more of our limited time
learning about configuring our participation in this mechanism, rather than
just participating.  Your example of learning how to treat Discourse like a
mailing list by following the Mozilla tutorial addresses this situation
precisely - instead of helping a person with their configuration issues, or
learning more about how to structure the queries used in QGIS, we are
tweaking the Discourse knobs and levers to get the "optimum" experience.

I guess you can tell that I'm negative on this concept.  I don't feel that
the mailing list is a be-all and end-all.  But I am pretty sure, again
based on my experience, that the lovely community we have here on
qgis-user@lists.osgeo.org will not be the same collection of good things
once migrated to Discourse.  I do hope that I am wrong!

On Wed, Apr 3, 2024 at 7:04 AM Régis Haubourg via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> [Message sent to all QGIS's lists. Sorry for crossposting - **please reply
> only in PSC list**  ]
> [stuff deleted]
>
>
> Any thought from you is more than welcome, from ranting against modernity
> to thanking SAC for their hard work.
>
 And thank you, SAC, for your hard work!

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Problem with QGIS: Form uniform groups/clusters from a large point data set

2024-03-15 Thread chris hermansen via QGIS-User
Maren and list,

On Fri, Mar 15, 2024, 05:27 Dr.-Ing. Maren van der Meer via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello everyone,
>
> I'm facing a problem that I can't wrap my head around:
>
> I have a population dataset in the form of dots. Each point represents one
> inhabitant within an imaginary grid cell of 100x100 meters. For example, if
> there are 37 inhabitants living in one grid cell, there are 37 points on
> top of each other. (The data set is quite large and contains about 4
> million points)
>
> I would like to divide the point data set into groups of *equal* size.
> It is important that the groups are really the same size. (Clustering using
> k-means etc. does not work for me...)
>
> I am also faced with the problem that I would like to try out different
> variants of group formation. For example: Does it make a difference if I
> start the grouping in the north, south or west of the points? Does anyone
> know a (preferably automated) method of group formation?
>
> I hope I have been able to describe my problem sufficiently and would be
> very happy to receive help and tips.
>

There is a discussion on StackOverflow that sounds like what you want to
do. Looks like there are some good ideas there.

https://stackoverflow.com/questions/5452576/k-means-algorithm-variation-with-equal-cluster-size
___
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 and saving very large table

2024-03-12 Thread chris hermansen via QGIS-User
Michael and list,

On Tue, Mar 12, 2024 at 11:48 AM Michael.Dodd 
wrote:

> In this particular instance the data are not spatial data, at this stage
> at least. There is no link to location.
>
>
>
> The data does have a hierarchy according to several columns, by sorting I
> can put the data into a suitable order for editing in further information
> into an extra column. Without sorting the places where the extra info and
> which specific extra info are impossible to find and check as they are
> scattered all over.
>
>
>
> I tried putting the information in using the field calculator and even
> though the simple expression seemed correct and there was no error message
> it did not put the information in. So I was even thinking of putting the
> information in by hand once sorted although suspect there may be issues
> with this too.
>
>
>
> I was wondering about sorting the whole file then copying out/exporting
> chunks of a million rows at a time to go into a normal spreadsheet. If the
> copying out/export would not work directly then saving the sorted version
> of the data and chopping up using e.g. notepad++ and editing with
> spreadsheet. It is important to do the sorting before chopping up into the
> 5 separate files.
>
>
>
> It is only later that spatial information is attached, that is not
> relevant at this stage as the spatial data will not be attached to all rows.
>
>
Ok so you are sorting a text file, presumably something like a .CSV.
Perhaps you are working on Windows.

What are your options to sort the file before you put it in QGIS?  It seems
your spreadsheet won't accommodate the number of lines in your file; what
about the "sort" utility in say Windows PowerShell?

Here's an article that talks about sorting .CSV files that way.

https://stackoverflow.com/questions/23603397/sorting-csv-using-windows-sort
which in turn refers to this article

https://devblogs.microsoft.com/scripting/hey-scripting-guy-how-can-i-use-windows-powershell-to-sort-a-csv-file/

Alternatively, if you're using Linux or (I would imagine) OS/X, you can use
the Posix "sort" utility.
-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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 and saving very large table

2024-03-12 Thread chris hermansen via QGIS-User
Michael and list,

On Tue, Mar 12, 2024 at 5:31 AM Michael.Dodd via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Thanks, can you suggest how as the refactor fields help is not clear, to
> say the least, about saving after sorting.
>
> I sorted the data (5 million rows) by a couple of the columns, just by
> clicking on them, then wanted to save in the new order but this 'save in
> the new order' seems impossible.
>

Michael, I for one am puzzled as to what you sorted.  Was this a point,
polygon, line attribute table?  Or some .csv layer?  Or...?

And how did you sort it?  Opened it in the attribute table editor and
clicked on columns?  If so, as far as I know, sorting in this editor is
just for convenience in reviewing data.  The physical data order is
determined by the link to the spatial features.

Maybe you could also tell us what you're trying to achieve by sorting?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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 abot shapes

2024-03-08 Thread chris hermansen via QGIS-User
Sorry everyone, pressed "send" too early!

On Fri, Mar 8, 2024 at 9:55 AM chris hermansen 
wrote:

> Sylvain and list,
>
> On Fri, Mar 8, 2024 at 8:15 AM Sylvain Ard via QGIS-User <
> qgis-user@lists.osgeo.org> wrote:
>
>>
>> Good morning,
>> I have a PostgreSQL database of several million points with
>> latitude/longitude and I would like to do the following with qgis-server or
>> PostGis:
>> according to a number of shapes (hexagons, circles or squares) per mesh,
>> calculate the number of points per shape and color the shape darker as
>> there are points underneath. If there are no points the shape should not
>> appear. If we zoom in, the meshes must be recalculated and reduced of
>> course. On the other hand I would like a leaflet basemap.
>>
>
> I don't have a "follow this recipe" answer for you, but I wonder if you
> have looked at "heat maps" as a general concept and thought about how that
> might apply to your needs.
>
> For example, there is this interesting discussion on StackExchange about
> density of bomb craters:
>
> https://gis.stackexchange.com/questions/385338/point-density-map-in-qgis
>
> Also worth learning about is how QGIS handles point clouds and whether
that might apply to solving your problem

https://docs.qgis.org/3.34/en/docs/user_manual/working_with_point_clouds/point_clouds.html

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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 abot shapes

2024-03-08 Thread chris hermansen via QGIS-User
Sylvain and list,

On Fri, Mar 8, 2024 at 8:15 AM Sylvain Ard via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

>
> Good morning,
> I have a PostgreSQL database of several million points with
> latitude/longitude and I would like to do the following with qgis-server or
> PostGis:
> according to a number of shapes (hexagons, circles or squares) per mesh,
> calculate the number of points per shape and color the shape darker as
> there are points underneath. If there are no points the shape should not
> appear. If we zoom in, the meshes must be recalculated and reduced of
> course. On the other hand I would like a leaflet basemap.
>

I don't have a "follow this recipe" answer for you, but I wonder if you
have looked at "heat maps" as a general concept and thought about how that
might apply to your needs.

For example, there is this interesting discussion on StackExchange about
density of bomb craters:

https://gis.stackexchange.com/questions/385338/point-density-map-in-qgis


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] time series viewer for EGMS

2024-02-29 Thread chris hermansen via QGIS-User
Aldo and list,

On Thu, Feb 29, 2024 at 5:48 AM Aldo Piombino via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi all,
> I have a problem.
> I have downloaded some data from the European Ground Motion Service
> (EGMS). The data consist of persistent scatteres and the history of their
> distance from the satellite.
> The data are available with a CSV file accompanied by a xml file.
>
> The problem is taht I have not found a time series viewer plugin
>
> Is there someone who knows if this plugs exist?
>
>  If you are looking for a way to animate your maps, there is this:

https://plugins.qgis.org/plugins/animation_workbench/

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Encoding accents on the web

2024-02-27 Thread chris hermansen via QGIS-User
Robert and list,

On Tue, Feb 27, 2024 at 1:49 PM Robert Sweeny  wrote:

> Chris,
>
> Your suggestion makes sense. The opening line of the index.html code
> established UTF-8 as the code and which is now the same as the code for the
> Q-GIS layer. And yet, the problem persists. To make matters more
> complicated, the map has all the accents when opened from by computer, but
> looses them once uploaded.
>

This article by Bentley indicates that their software (and who knows, maybe
other software) expects shapefile characters to be encoded as ISO8859-1.
They recommend resaving the layer with a changed encoding.

You could try this.

https://communities.bentley.com/products/hydraulics___hydrology/w/hydraulics_and_hydrology__wiki/37273/characters-in-a-shapefile-do-not-appear-correctly-in-the-modelbuilder-preview

There's also this "encoding fixer plugin"

https://plugins.qgis.org/plugins/shapefile_encoding_fixer/

Here are some other people struggling with the same problem

https://www.reddit.com/r/QGIS/comments/y15m2a/problem_with_german_characters_in_an_attribute/

Maybe some of this will help.

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Encoding accents on the web

2024-02-27 Thread chris hermansen via QGIS-User
Robert and list

On Tue, Feb 27, 2024, 06:52 Robert Sweeny via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi people,
> I am attempting to produce Q-GIS web sites using the gqis2web add-on. I am
> opting for Leaflet because that seems to work best for my purposes. The
> problem is that french language accents do not appear properly. They are
> represented by odd combinations of capital letters and a symbol.
> Suggestions?
>


Sounds like one part of your environment is using say ISO8859 character
encoding and the other UTF-8

For example your data (in shape files) may be ISO8859 but QGIS may be using
UTF-8.

> Robert Sweeny
> Montreal
> ___
> 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] QGIS and Mango

2024-02-22 Thread chris hermansen via QGIS-User
Collin and list,

On Thu, Feb 22, 2024 at 12:06 PM Collin Coe 
wrote:

> Chris,
>
> Thank you so much for all the additional information, to be honest a lot
> of it is quite a bit over my head, but I will use it to hopefully point our
> folks at Mango down the right path.
>
> It is good to have a second set of eyes verify what we thought, that our
> Apache/QGIS server is in fact serving this WMS data, but that Mango is just
> formatting their requests incorrectly.
>

You are most welcome of course.

I am guessing - and maybe off in a misleading direction - that there is
some kind of configuration in the Mango stuff that looks like a template
that you would set up to send your queries to the map server.  For
instance, somewhere you should be specifying things like database
connection parameters or in your case the .qgz file.

Also I wonder if the layer names in the Mango application correspond to the
layer names in QGIS and if not, how you go about setting up that kind of
correspondence.  For example, you might have a "streets" layer called
"12345" on the Mango side and "transportation" on the QGIS side.

>
> Thanks!
>
>
>
>
>
>
>   [image: Facebook] [image:
> LinkedIn] 
>  [image: Twitter] 
>
> *Collin Coe*
>
> *IT Operations Manager*
>
> *Van Buren County Information Services*
>
> a:
>
> 219 E. Paw Paw St, Suite 202
>
> Paw Paw, MI 49079
>
> t:
>
> 269-657-8266 ext. 1248
>
> f:
>
> 269-657-8297
>
> w:
>
> https://www.vanburencountymi.gov  e: c...@vanburencountymi.gov
>
> Need to meet with me? Book a meeting or check my availability with this
> link: Microsoft Bookings
> 
>
> --
> *From:* chris hermansen 
> *Sent:* Thursday, February 22, 2024 2:42 PM
> *To:* Collin Coe 
> *Cc:* qgis-user@lists.osgeo.org 
> *Subject:* Re: [Qgis-user] QGIS and Mango
>
> This email was sent from outside your organization. Please use caution
> when clicking links or opening attachments.
> --
> Collin and list,
>
> On Thu, Feb 22, 2024 at 10:19 AM Collin Coe 
> wrote:
>
> Thank you for your response, see my answers below.
>
>
>- Note "the server understands the request but refuses to authorize
>it".
>- That was my thought, as if I shut the Apache service down, the
>   request times out instead.
>
>   - Looking at your URL, it appears your request doesn't go directly
>to the QGIS server, but rather goes to mangomap.com
>
> 
>  (it
>is "mangomap" and not "mangomaps", correct?).
>- The URL that we program into Mango is below, the one from the error
>   is what I assume is Mango reformatting the URL behind the scenes as it
>   presents in their UI to me. Note this URL is something that Mango 
> advised
>   us to use for the call on our server. We have tried it with the one
>   specified in the below question as well to the same results.
>   -
>  
> https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0
>
>
> If I try to access this URL with curl I get an error, I suppose because no
> parameters are specified:
>
>  $ curl '
> https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0
> '
> 
> Layer(s) not valid
> $
>
>
>-
>  - Is your qgis server / apache server / network policy set up to
>accept requests from outside your network?
>- It is. We have tested with ARCGIS and it is able to pull in the WMS
>   data fine with the below URL
>   -
>  
> https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0=EPSG:3857=VBCWMS1.qgz=APTEST
>
>
> If I try to access this URL with curl I get stuff:
>
> $ curl '
> https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0=EPSG:3857=VBCWMS1.qgz=APTEST
> '
> 
> http://www.opengis.net/wms
> 
> http://schemas.opengis.net/wms/1.3.0/capabilities_1_3_0.xsd
> 
> http://www.opengis.net/sld
> 
> http://schemas.opengis.net/sld/1.1.0/sld_capabilities.xsd
> 

Re: [Qgis-user] QGIS and Mango

2024-02-22 Thread chris hermansen via QGIS-User
Collin and list,

On Thu, Feb 22, 2024 at 10:19 AM Collin Coe 
wrote:

> Thank you for your response, see my answers below.
>
>
>- Note "the server understands the request but refuses to authorize
>it".
>- That was my thought, as if I shut the Apache service down, the
>   request times out instead.
>
>   - Looking at your URL, it appears your request doesn't go directly
>to the QGIS server, but rather goes to mangomap.com
>
> 
>  (it
>is "mangomap" and not "mangomaps", correct?).
>- The URL that we program into Mango is below, the one from the error
>   is what I assume is Mango reformatting the URL behind the scenes as it
>   presents in their UI to me. Note this URL is something that Mango 
> advised
>   us to use for the call on our server. We have tried it with the one
>   specified in the below question as well to the same results.
>   -
>  
> https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0
>
>
If I try to access this URL with curl I get an error, I suppose because no
parameters are specified:

 $ curl '
https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0
'

Layer(s) not valid
$

>
>-
>  - Is your qgis server / apache server / network policy set up to
>accept requests from outside your network?
>- It is. We have tested with ARCGIS and it is able to pull in the WMS
>   data fine with the below URL
>   -
>  
> https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0=EPSG:3857=VBCWMS1.qgz=APTEST
>
>
If I try to access this URL with curl I get stuff:

$ curl '
https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?service=WMS=GetCapabilities=1.3.0=EPSG:3857=VBCWMS1.qgz=APTEST
'

http://www.opengis.net/wms
http://schemas.opengis.net/wms/1.3.0/capabilities_1_3_0.xsd
http://www.opengis.net/sld
http://schemas.opengis.net/sld/1.1.0/sld_capabilities.xsd
http://www.qgis.org/wms
https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?MAP=VBCWMS1.qgzSERVICE=WMSREQUEST=GetSchemaExtension;
xmlns:sld="http://www.opengis.net/sld; xmlns:qgs="http://www.qgis.org/wms;
xmlns="http://www.opengis.net/wms; xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance;>
 
  WMS
  VBCWMS1
  
   infoMapAccessService
  
  http://www.w3.org/1999/xlink;
xlink:type="simple" xlink:href="
https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?MAP=VBCWMS1.qgz
"/>
  conditions unknown
  None
 
 
  
   
text/xml

 
  
   http://www.w3.org/1999/xlink;
xlink:type="simple" xlink:href="
https://wms.vanburencountymi.gov/cgi-bin/qgis_mapserv.fcgi.exe?MAP=VBCWMS1.qgz
;"/>
  
 

   
...
 

$

If I try the original you sent to me with curl, I get:

$ curl '
https://mangomap.com/clients/5dfb3952-42b1-11ee-83b6-027d7e0bb32b/coverage_stores/get_wms_layers?wms_source=https%253A%252F%252Fwms.vanburencountymi.gov%252Fcgi-bin%252Fqgis_mapserv.fcgi.exe%253Fservice%253DWMS%2526request%253DGetCapabilities%2526version%253D1.3.0&_=1708610138093
'
You are being https://mangomap.com/sign-in
">redirected.$

which lets me know mangomap.com is doing a redirect as we suspected.  If I
try with the curl "follow redirects" switch I am sent to mangomap.com's
login page:

 $ curl -L '
https://mangomap.com/clients/5dfb3952-42b1-11ee-83b6-027d7e0bb32b/coverage_stores/get_wms_layers?wms_source=https%253A%252F%252Fwms.vanburencountymi.gov%252Fcgi-bin%252Fqgis_mapserv.fcgi.exe%253Fservice%253DWMS%2526request%253DGetCapabilities%2526version%253D1.3.0&_=1708610138093
'



Sign in to Mango

...


$

So, so far so good, but not talking to your qgis server yet.

You might find it worthwhile continuing this way with curl, supplying your
login credentials, so you can get a bit more information on what's going on.


>-
>  - The text "(anonymous)" appears in the log following.  Could
>this mean that mangomap.com
>
> 
>  is
>trying to access your qgis server as user "anonymous"?
>- It is trying to access it anonymously, but I will note that ARCGIS
>   also accesses it this way and works fine
>
>   - When you configure MangoMap(s) to talk to your qgis server, have
>you entered the necessary credentials (user name and password)?
>- See above, it is availible anonymously. We will be locking it down
>   with creds eventually, but for testing it is
>
>
Got it.

>
>-
>   - Can you verify that your qgis server is ok to respond to the
>"getcapabilities" request with the parameters supplied?  Ie maybe try it
>with curl from inside 

Re: [Qgis-user] QGIS and Mango

2024-02-22 Thread chris hermansen via QGIS-User
Collin and list,

On Thu, Feb 22, 2024 at 7:43 AM Collin Coe via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hey All,
>
> Let me know if this is the appropriate place to send a question like this,
> or if there is a better support channel I might be able to reach out to.
>
> So I, internal IT, have been tasked with assisting our GIS department with
> standing up a WMS server to serve local mapping data to MangoMaps. This is
> all in an effort to distance ourselves from ESRI as they want big money to
> store the volume of GIS data we have on their hosted solution.
>
> I have stood up the QGIS server on a Windows 2019 server we are running
> here, gotten our GIS director connected to it using QGIS desktop, and he
> has even published a project that we can open just fine using the FQDN of
> our QGIS server externally. But here is the catch, while he can load the
> WMS data just fine in ARCGIS Pro on his home desktop, whenever we attempt
> to plug the string into MangoMaps as a WMS data source we get a 403 error
> and a 500 error on the Mango side and it fails to pull in the data.
>
> My question is this, does anyone here have the same setup we do, pumping
> WMS data from QGIS server over https to MangoMaps, and would you be able to
> give some advice on how you were able to get that working? We are working
> with Mango support, but this falls a bit out of their wheelhouse, as it
> seems like our Apache QGIS server is the one giving the 403 error. The bit
> that confuses me, is that it is working just fine in ARCGIS traversing the
> same network, from the same host. This leads me to believe that Mango needs
> something special/different done on their end to make it work.
>
> I will also be the first to note that I am not an Apache/GIS expert, and
> it very well could be an error we have made in our servers configuration.
> We have gone over the configuration with Mango, and they do not see any
> errors, but again, that is not their wheelhouse.
>

A 403 error usually indicates something along the lines that the web client
is trying to access something for which it doesn't have permission.  For
example Mozilla docs state:

403 Forbidden
> The HTTP 403 Forbidden response status code indicates that the server
> understands the request but refuses to authorize it.
> This status is similar to 401, but for the 403 Forbidden status code,
> re-authenticating makes no difference. The access is tied to the
> application logic, such as insufficient rights to a resource.


Note "the server understands the request but refuses to authorize it".

Looking at your URL, it appears your request doesn't go directly to the
QGIS server, but rather goes to mangomap.com (it is "mangomap" and not
"mangomaps", correct?).

Is your qgis server / apache server / network policy set up to accept
requests from outside your network?

The text "(anonymous)" appears in the log following.  Could this mean that
mangomap.com is trying to access your qgis server as user "anonymous"?

When you configure MangoMap(s) to talk to your qgis server, have you
entered the necessary credentials (user name and password)?

Can you verify that your qgis server is ok to respond to the
"getcapabilities" request with the parameters supplied?  Ie maybe try it
with curl from inside your network?


> At any rate, see the error that we get in Mango below, and let me know if
> you have any advice.
>
>
>
>
> application_one_page_app-e0c184742f67970dfcbc711490e8927caf4b7d25f000dd69df5a805edeca457b.js:63
> GET
> https://mangomap.com/clients/5dfb3952-42b1-11ee-83b6-027d7e0bb32b/coverage_stores/get_wms_layers?wms_source=https%253A%252F%252Fwms.vanburencountymi.gov%252Fcgi-bin%252Fqgis_mapserv.fcgi.exe%253Fservice%253DWMS%2526request%253DGetCapabilities%2526version%253D1.3.0&_=1708610138093
> 403 (Forbidden)
> send @
> application_one_page_app-e0c184742f67970dfcbc711490e8927caf4b7d25f000dd69df5a805edeca457b.js:63
> ajax @
> application_one_page_app-e0c184742f67970dfcbc711490e8927caf4b7d25f000dd69df5a805edeca457b.js:63
> request @
> application_one_page_app-e0c184742f67970dfcbc711490e8927caf4b7d25f000dd69df5a805edeca457b.js:640
> connectWms @
> application_data_portal-f8ccb478ddb794401762bdd65a58df88cca0a03a304324c540f5d9b97c5622bd.js:11
> (anonymous) @
> application_data_portal-f8ccb478ddb794401762bdd65a58df88cca0a03a304324c540f5d9b97c5622bd.js:13
> dispatch @
> application_one_page_app-e0c184742f67970dfcbc711490e8927caf4b7d25f000dd69df5a805edeca457b.js:62
> v.handle @
> application_one_page_app-e0c184742f67970dfcbc711490e8927caf4b7d25f000dd69df5a805edeca457b.js:61
>
>
>
>
>
>   [image: Facebook] [image:
> LinkedIn] 
>  [image: Twitter] 
>
> *Collin Coe*
>
> *IT Operations Manager*
>
> *Van Buren County Information Services*
>
> a:
>
> 219 E. Paw Paw St, Suite 202
>
> Paw Paw, MI 49079
>
> t:
>
> 269-657-8266 ext. 1248
>
> f:
>

Re: [Qgis-user] Primary key and spatial index

2024-02-15 Thread chris hermansen via QGIS-User
Rikesh and list,

On Thu, Feb 15, 2024, 18:40 Rikesh Lad via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello,
>
> Please see attached. Does anyone know how to add a primary key and spatial
> index to a large layer without the software crashing?
>
> [image: image.png]
>


Here is some reference info about adding a primary key to a PostgreSQL table

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-primary-key/#:~:text=To%20add%20a%20primary%20key%20to%20an%20existing%20table%2C%20you,to%20the%20primary%20key%20constraint
.

>
>
Here is some reference info that explains how to add a spatial index

https://postgis.net/workshops/postgis-intro/indexing.html

>
Both require the use of a PostgreSQL client for example "psql".

>
>
___
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] Distance measurement from Center - Buffer

2024-02-12 Thread chris hermansen via QGIS-User
A WGS84 UTM projection that encloses your area of interest could be good.

For that you need to look at your lat/lon and see what UTM zone that fits
into.

This could help

https://www.usgs.gov/faqs/what-does-term-utm-mean-utm-better-or-more-accurate-latitudelongitude#:~:text=The%20UTM%20system%20consists%20of,Grid%20Reference%20System%20(MGRS)
.

On Mon, Feb 12, 2024, 18:31 krishna Ayyala  wrote:

> Chris,
> Thanks for the reply. By rectangular coordinate system, can you mention
> which specific rectangular coordinate system?
>
> Regards.
>
> On Mon, Feb 12, 2024 at 5:52 PM chris hermansen 
> wrote:
>
>> Epsg 4326 is lat long. Make your buffers in a rectangular coordinate
>> system.
>>
>> On Mon, Feb 12, 2024, 16:29 krishna Ayyala via QGIS-User <
>> qgis-user@lists.osgeo.org> wrote:
>>
>>> Hello,
>>> I have a point shape file with the projection as shown below. I have
>>> created a buffer of 16km using this point shapefile. When I measure it
>>> vertically, it reads as 32km. But when I measure it horizontally, it reads
>>> as 26km only. I have reprojected the buffer to the projected coordinate
>>> system. Despite of this, I am getting the same values. What should I do
>>> such that I can read 32kms both horizontally and vertically?
>>> Regards.
>>>
>>> [image: image.png]
>>>
>>> [image: image.png]
>>> ___
>>> 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] Distance measurement from Center - Buffer

2024-02-12 Thread chris hermansen via QGIS-User
Epsg 4326 is lat long. Make your buffers in a rectangular coordinate system.

On Mon, Feb 12, 2024, 16:29 krishna Ayyala via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello,
> I have a point shape file with the projection as shown below. I have
> created a buffer of 16km using this point shapefile. When I measure it
> vertically, it reads as 32km. But when I measure it horizontally, it reads
> as 26km only. I have reprojected the buffer to the projected coordinate
> system. Despite of this, I am getting the same values. What should I do
> such that I can read 32kms both horizontally and vertically?
> Regards.
>
> [image: image.png]
>
> [image: image.png]
> ___
> 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] Installation of QGIS on Ubuntu 22.4 LTS (Jammy) seems to use old library versions from 20.04 LTS (Focal)

2024-01-27 Thread chris hermansen via QGIS-User
Maxime,

On Sat, Jan 27, 2024, 16:18 Schoemans Maxime 
wrote:

> Hi Chris,
>
> After some more tinkering around I managed to fix the issue.
> It seems the culprit was an old installation of gdal from sources.
> I am not certain how this was making crssync crash, but after
> recompiling and reinstalling gdal the qgis installation completed
> without errors.
>


Wow great news! I imagine it's because QGIS relies on Ubuntu to put GDAL in
place, and you already had one.


> Thank you for your help.
>

Kind of you to say so but I think you deserve all the congratulations.

>
___
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] Installation of QGIS on Ubuntu 22.4 LTS (Jammy) seems to use old library versions from 20.04 LTS (Focal)

2024-01-27 Thread chris hermansen via QGIS-User
Hello again Maxime,

Worth reading through this:

https://github.com/qgis/QGIS/issues/48685

You will see that someone in a similar problem solved it, albeit earlier
version of QGIS.  Maybe this will apply in your case as well...?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Installation of QGIS on Ubuntu 22.4 LTS (Jammy) seems to use old library versions from 20.04 LTS (Focal)

2024-01-27 Thread chris hermansen via QGIS-User
Maxime,

On Sat, Jan 27, 2024 at 9:56 AM Schoemans Maxime 
wrote:

>
> On 27/01/2024 17:23, chris hermansen wrote:
>
>
> It somehow seems like you have the focal packages installed, though your
> qgis.sources looks ok.
>
> What happens if you do an apt update and apt upgrade on the command line?
> Any errors?
>
>
> Both commands run without error.
> Here is the complete output of my installation process if it helps.
> It seems like I am indeed getting the jammy packages, so I am not sure
> what is going wrong.
>
> *maxime@maxime-pc:~ $* sudo apt update
>
> [stuff deleted]


> All packages are up-to-date.
> *maxime@maxime-pc:~ $* sudo apt upgrade
>

[stuff deleted]

>
>
0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.
>

Ok the below looks "interesting"... dependency problems?

I see the message below mentioning "crssync: error while loading shared
libraries...".  The story continues.


> *maxime@maxime-pc:~ $* sudo apt install qgis qgis-plugin-grass
> Reading package lists... Done
> Building dependency tree... Done
> Reading state information... Done
> The following additional packages will be installed:
>   grass-core grass-doc libjs-leaflet libqgis-3d3.34.3
> libqgis-analysis3.34.3 libqgis-app3.34.3 libqgis-core3.34.3
>   libqgis-customwidgets libqgis-gui3.34.3 libqgis-native3.34.3
> libqgis-server3.34.3 libqgisgrass7-3.34.3 libqgispython3.34.3
>   libqt5charts5 libqt5multimedia5 libqt5multimediawidgets5 libqt5pdf5
> python3-pyqt5.qtmultimedia python3-qgis
>   python3-qgis-common qgis-common qgis-plugin-grass-common
> qgis-provider-grass qgis-providers qgis-providers-common
>   qml-module-qtcharts qt5-image-formats-plugin-pdf
> Suggested packages:
>   grass-dev grass-gui e00compr avce00 gnuplot gpsbabel gpstrans
> python3-rpy2 grass grass-dev-doc otb-qgis saga
> The following NEW packages will be installed
>   grass-core grass-doc libjs-leaflet libqgis-3d3.34.3
> libqgis-analysis3.34.3 libqgis-app3.34.3 libqgis-core3.34.3
>   libqgis-customwidgets libqgis-gui3.34.3 libqgis-native3.34.3
> libqgis-server3.34.3 libqgisgrass7-3.34.3 libqgispython3.34.3
>   libqt5charts5 libqt5multimedia5 libqt5multimediawidgets5 libqt5pdf5
> python3-pyqt5.qtmultimedia python3-qgis
>   python3-qgis-common qgis qgis-common qgis-plugin-grass
> qgis-plugin-grass-common qgis-provider-grass qgis-providers
>   qgis-providers-common qml-module-qtcharts qt5-image-formats-plugin-pdf
> 0 to upgrade, 29 to newly install, 0 to remove and 0 not to upgrade.
> Need to get 0 B/178 MB of archives.
> After this operation, 510 MB of additional disk space will be used.
> Do you want to continue? [Y/n] Y
> Selecting previously unselected package qgis-providers-common.
>
> [stuff deleted]


> Setting up qgis-providers (1:3.34.3+36jammy) ...
> /usr/lib/qgis/crssync: error while loading shared libraries: libwebp.so.6:
> cannot open shared object file: No such file or dire
> ctory
> dpkg: error processing package qgis-providers (--configure):
>  installed qgis-providers package post-installation script subprocess
> returned error exit status 127
> dpkg: dependency problems prevent configuration of qgis:
>  qgis depends on qgis-providers (= 1:3.34.3+36jammy); however:
>   Package qgis-providers is not configured yet.
>

[stuff deleted]

So maybe worth trying

apt upgrade -f

to see if your dependencies get fixed.

After you try that, if things still aren't working, you might want to try:

apt install qgis grass qgis-plugin-grass

Please report back in any case!

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Installation of QGIS on Ubuntu 22.4 LTS (Jammy) seems to use old library versions from 20.04 LTS (Focal)

2024-01-27 Thread chris hermansen via QGIS-User
Maxime,

On Sat, Jan 27, 2024, 05:00 Schoemans Maxime 
wrote:

> Hi Chris,
>
> Thank you for your response.
>
> On 27/01/2024 00:55, chris hermansen wrote:
> > Please post your /etc/apt/sources.list.d/qgis.sources
>
> *maxime@maxime-pc:~ $* lsb_release -cs
> jammy
> *maxime@maxime-pc:~ $* sudo cat /etc/apt/sources.list.d/qgis.sources
> Types: deb deb-src
> URIs: https://qgis.org/ubuntu
> Suites: jammy
> Architectures: amd64
> Components: main
> Signed-By: /etc/apt/keyrings/qgis-archive-keyring.gpg
>
> > It seems to me you may be getting the wrong set of packages.
>
> I was also under this impression, but I am not certain where I went wrong.
>

It somehow seems like you have the focal packages installed, though your
qgis.sources looks ok.

What happens if you do an apt update and apt upgrade on the command line?
Any errors?

>
>
___
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] Installation of QGIS on Ubuntu 22.4 LTS (Jammy) seems to use old library versions from 20.04 LTS (Focal)

2024-01-26 Thread chris hermansen via QGIS-User
Maxime and list;

On Fri, Jan 26, 2024 at 3:18 PM Schoemans Maxime via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi,
>
>
> This is my first email on the qgis-user mailing list, I hope this is the
> correct place to send my questions.
>
> I have recently upgraded Ubuntu twice (first 18.04 -> 20.04, then 20.4
> -> 22.04).
> I am now trying to install QGIS 3.34.3 in Ubuntu 22.4 LTS (Jammy), but I
> seem to have many issues of the form:
>
> /usr/lib/qgis/crssync: error while loading shared libraries:
> libqhull_r.so.7: cannot open shared object file: No such file or directory
>

Please post your /etc/apt/sources.list.d/qgis.sources


>
> This specific error was related to libqhull 7, which is the version for
> 'Focal' (20.04), while 'Jammy' (22.04) uses libqull 8 (see
> https://pkgs.org/search/?q=libqhull).
> After manually downloading and installing libqhull 7 from pkgs.org, I am
> now hitting a similar error for another library:
>
> /usr/lib/qgis/crssync: error while loading shared libraries:
> libwebp.so.6: cannot open shared object file: No such file or directory
>
> Again, the libwebp library is using the 'Focal' version (libwebp 6),
> instead of the 'Jammy' version (libwebp 7).
> I suspect I will hit more similar errors if I keep manually installing
> the requested 'older' library versions.
>
> My question is thus: Am I doing something wrong, or is this normal and I
> should continue manually downloading previous library versions as needed?
>

It seems to me you may be getting the wrong set of packages.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Dúvida sobre mapa de calor

2024-01-19 Thread chris hermansen via QGIS-User
João and list,

On Fri, Jan 19, 2024 at 6:49 AM João Victor Martinelli via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Olá, bom dia!
>
> Eu tenho o mapa de calor de um município, e gostaria de calcular a média
> da temperatura de cada um dos bairros, a partir de um shapefile. Será que é
> possível?
>
> Obrigado!
>
> You can use geometric operations to produce the union (menu Vector >
Geoprocessing tools > Union) of the municipal heat map layer and the
neighborhood layer, which will give you polygons with attributes
identifying which municipality and which neighborhood each polygon sits
within.

At this point, you can set the neighborhood heat to be the same value as
the municipal heat in each one of those polygons.

Finally, you can calculate the weighted average heat by neighborhood by
multiplying each polygon area by its heat, summing across the neighborhoods
and dividing by the neighborhood total area.

Does that make sense to you?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS Qt6 Wayland ongoing status

2024-01-18 Thread chris hermansen via QGIS-User
Thanks very much for this detailed authoritative explanation, Nyall.  I
have a couple of specific comments below...

On Wed, Jan 17, 2024 at 10:29 PM Nyall Dawson 
wrote:

>
>
> On Thu, 18 Jan 2024 at 13:56, chris hermansen via QGIS-User <
> qgis-user@lists.osgeo.org> wrote:
> >
> > Adam and list,
> >
> > On Wed, Jan 17, 2024 at 5:34 PM Adam Nielsen 
> wrote:
> >>
> >> > I have been trying to find a mostly definitive and mostly up-to-date
> >> > conversation about the status of QGIS, Qt6 and Wayland and I'm not
> having
> >> > any luck.
> >>
> >> What's the underlying need for this information?
>
> ... gather round folks, for a truly sorry tale! Here's the definitive(*)
> situation regarding QGIS and wayland.
>
> - Qt 5 based applications do NOT work well under any wayland environment.
> There's fundamental broken functionality, and its functionality which QGIS
> requires. A good example is trying to drag a toolbar or dock panel --
> you'll instantly "break" the application with non functional empty windows.
> - This particular issue HAS been fixed in very recent Qt versions. Read
> all about it here:
> https://blog.david-redondo.de/kde/wayland/qt/2023/08/08/xdg-toplevel-drag.html
> . BUT... this fix ONLY works if the desktop environment supports the fix.
> So you'll also need a very recent KDE release for this to work. Gnome, in
> typical Gnome fashion, have shown no interest in helping out other toolkits
> and implementing this new Wayland protocol and so Qt applications (even
> those built with Qt 6.6+) will still be broken. There's little hope on the
> horizon that Gnome will change their ways, so you'll also need to move to
> KDE and put Gnome in the past. 路
>

 It's disappointing to read this as there's clearly a disconnect between
what e.g. QGIS developers are experiencing and what Fedora, Gentoo and
maybe others are saying about Qt5 and Wayland.  For example, this on the
Gentoo Wiki here https://wiki.gentoo.org/wiki/Wayland

For Qt an additional package called dev-qt/qtwayland
> <https://packages.gentoo.org/packages/dev-qt/qtwayland> is required. In
> the Qt Wiki it says: "QtWayland is a Qt 5 module that wraps the
> functionality of Wayland. QtWayland is separated into a client and server
> side. The client side is the wayland platform plugin, and provides a way to
> run Qt applications as Wayland clients. The server side is the QtCompositor
> API, and allows users to write their own Wayland compositors."


And this on Fedora here
https://fedoraproject.org/wiki/Changes/Qt_Wayland_By_Default_On_Gnome

Qt Wayland plugin has been available for a long time, but it hasn't been in
> condition where it could be enabled by default. With Qt 5.12 the state of
> the Wayland plugin is much better and it's becoming more and more reliable.
> It now supports all the needed protocols and has been enabled by default
> for non-Gnome Wayland sessions. With Qt Wayland on Gnome Wayland session we
> need to support CSD, it's actually the only way how decorations are going
> to work in Qt apps right now. Qt Wayland implements basic decorations,
> which really doesn't match Gnome Adwaita theme, therefore there are new CSD
> being implemented as part of QGnomePlatform.

To make Qt applications run natively on Wayland we need to modify Qt 5,
> specifically *qt5-qtbase* module, where we allow the Wayland plugin to be
> used also for Gnome sessions. The new decorations from QGnomePlatform will
> be used automatically once they are fully implemented and updated in
> Fedora.

(the above dated 2019!!!)

> - So let's say you're running KDE, on a distro with a very recent Qt
> version. You'll still need a QGIS build based on Qt 6. That's a heavy work
> in progress at the moment. We're all ACTIVELY working toward that, but it's
> still some time away. You CAN build master versions and get a mostly
> working QGIS Qt6 build, so long as you don't require any Python support,
> that is!
> - Ok, now lets assume you're on KDE, have recent Qt 6 library, have built
> QGIS master with Qt6 support and don't need python/plugins. Yay! Will
> everything work on Wayland? Well, not quite!.. There's still going to be
> broken functionality (such as the color picker not working outside of the
> QGIS application). There's also STILL fundamental missing bits in Wayland
> itself, such as proper restoring of Window locations. Every time QGIS opens
> a new dialog it'll just be thrown on some random screen at some random
> location. There's still no real progress toward that being fixed. Read
> about the sorry state of it here:
> https://gitlab.freedesktop.org/wayland/wayland-protocols/-/merge_requests/247
>

An exceptionally informative pull request.  I was

Re: [Qgis-user] QGIS Qt6 Wayland ongoing status

2024-01-17 Thread chris hermansen via QGIS-User
Extremely informative Andreas, thank you.

I should have thought about the developer list! Drat!

On Wed, Jan 17, 2024, 22:10 Andreas Neumann  wrote:

> Hi Chris, Adam and others,
>
> I am not the technical person to answer details, but I am on the QGIS PSC
> and can assure you that building QGIS on Qt6 is high up on our priority
> list (for at least a year or even longer). You can already build QGIS fine
> on Qt6 (for at least 2-3 versions now) but the core devs came across some
> blockers that had to be solved first, before we can bring this to the end
> users without major regressions:
>
>1. isues around qt3d and webengine compatibility (one could either use
>3D or the webengine, not both together)
>2. issues around the fact that Qt webengine cannot output HTML/web
>output to vectors when rendering to PDF
>3. PyQt6 bindings had to be done
>
> While the first issue is already solved, the 2nd issue is currently being
> solved by introducing another library (
> https://github.com/JakubMelka/PDF4QT) and the third item is roughly 2/3
> done and still actively being worked on.
>
> Then there is the issue that all QGIS plugins have to be migrated to PyQt6
> ...
>
> We will probably offer QGIS Qt6 builds as technology previews soon in
> parallel to the normal Qt5 builds.
>
> Now - about wayland: all of this has really nothing to do with Wayland but
> has to be done anyway, because Qt5 isn't developed any further and
> QGIS.ORG already invested in Qt6 improvements from which we cannot yet
> take advantage of until we ship with Qt6.
>
> Moving QGIS to Qt6 doesn't automatically mean that all QGIS wayland issues
> are solved - but probably quite a few of these issues.
>
> Hope this clarifies the situation? If you want more detailed, more
> technical responses, I recommend discussions on the QGIS developers mailing
> list. It would only bore regular QGIS users ...
>
> Greetings,
>
> Andreas
> QGIS.ORG treasurer and PSC member
>
>
>
> I don't know if you have recently run QGIS on a Wayland desktop, but there
> is a stern message strongly suggesting reverting to X.
>
> So as we seem to be marching away from X and ever forward to Wayland, I
> would like to start planning ahead a bit, and I would especially like to
> find some real information, as opposed to "I think this (but I really don't
> know)", or even worse, the people who can see a bright future for (let's
> say) Wayland-only desktops and aren't worried about the bumps on the road
> getting there.
>
> Fortunately it seems Ubuntu 24.04 will continue to support X
> https://discourse.ubuntu.com/t/ubuntu-desktop-24-04-lts-roadmap-highlights/41032
> so in my case at least I know I can drop back to X if / as necessary for
> the immediate future.
>
>
> > There is some stuff on GitHub but it seems to be at least a year or two
> > old, talking about Qt6.0 and I gather we are at Qt6.6 by now.  Plus
> endless
> > short conversations in places like Reddit that throw off more heat than
> > light.
>
> Updating to a new Qt version is likely going to be a lot of work, sot
> imagine nobody is that keen on starting until there's really no choice.
>
>
> As it happens, a search for qt6 in the QGIS repo on GitHub shows work
> being done on qt6, apparently for QGIS 4.  So maybe someone has started
> already?  I wonder how that's going?
>
>
> > Does anyone have any suggestions as to where to keep informed on this
> > topic?  Because it seems like Wayland is coming whether we want it or
> not...
>
> Wayland has been around for many years at this point, and is already the
> default on some Linux distributions, which have no problem running
> QGIS.  There is so much legacy code that they are always going to have
> compatibility modules to keep non-Wayland programs usable.  I wouldn't
> worry about any programs suddenly breaking due to Wayland.
>
>
> While I appreciate your attempts to reassure me, this isn't helping.
>
> I'm aware from firsthand experience that Wayland has been around for many
> years at this point.  I have even used it on and off.  In fact it's my
> daily driver on my laptop.
>
> My concern is learning how QGIS development might converge - or not - with
> a Wayland-only future, since it seems several important Linux distros are
> leaning away from supporting X to some degree or another.
>
> As to whether QGIS might break under Wayland, there are 31 issues in the
> QGIS repo as of this evening related to Wayland in some form or the other.
> Plus the warning I mentioned above.
>
> --
> Chris Hermansen · clhermansen "at" gmail "dot" com
>
> C'est ma façon de parler.
>
> ___
> 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: 

Re: [Qgis-user] QGIS Qt6 Wayland ongoing status

2024-01-17 Thread chris hermansen via QGIS-User
Adam and list,

On Wed, Jan 17, 2024 at 5:34 PM Adam Nielsen  wrote:

> > I have been trying to find a mostly definitive and mostly up-to-date
> > conversation about the status of QGIS, Qt6 and Wayland and I'm not having
> > any luck.
>
> What's the underlying need for this information?
>

I don't know if you have recently run QGIS on a Wayland desktop, but there
is a stern message strongly suggesting reverting to X.

So as we seem to be marching away from X and ever forward to Wayland, I
would like to start planning ahead a bit, and I would especially like to
find some real information, as opposed to "I think this (but I really don't
know)", or even worse, the people who can see a bright future for (let's
say) Wayland-only desktops and aren't worried about the bumps on the road
getting there.

Fortunately it seems Ubuntu 24.04 will continue to support X
https://discourse.ubuntu.com/t/ubuntu-desktop-24-04-lts-roadmap-highlights/41032
so in my case at least I know I can drop back to X if / as necessary for
the immediate future.

>
> > There is some stuff on GitHub but it seems to be at least a year or two
> > old, talking about Qt6.0 and I gather we are at Qt6.6 by now.  Plus
> endless
> > short conversations in places like Reddit that throw off more heat than
> > light.
>
> Updating to a new Qt version is likely going to be a lot of work, so I
> imagine nobody is that keen on starting until there's really no choice.
>

As it happens, a search for qt6 in the QGIS repo on GitHub shows work being
done on qt6, apparently for QGIS 4.  So maybe someone has started already?
I wonder how that's going?

>
> > Does anyone have any suggestions as to where to keep informed on this
> > topic?  Because it seems like Wayland is coming whether we want it or
> not...
>
> Wayland has been around for many years at this point, and is already the
> default on some Linux distributions, which have no problem running
> QGIS.  There is so much legacy code that they are always going to have
> compatibility modules to keep non-Wayland programs usable.  I wouldn't
> worry about any programs suddenly breaking due to Wayland.
>

While I appreciate your attempts to reassure me, this isn't helping.

I'm aware from firsthand experience that Wayland has been around for many
years at this point.  I have even used it on and off.  In fact it's my
daily driver on my laptop.

My concern is learning how QGIS development might converge - or not - with
a Wayland-only future, since it seems several important Linux distros are
leaning away from supporting X to some degree or another.

As to whether QGIS might break under Wayland, there are 31 issues in the
QGIS repo as of this evening related to Wayland in some form or the other.
Plus the warning I mentioned above.

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS Qt6 Wayland ongoing status

2024-01-16 Thread chris hermansen via QGIS-User
I have been trying to find a mostly definitive and mostly up-to-date
conversation about the status of QGIS, Qt6 and Wayland and I'm not having
any luck.

There is some stuff on GitHub but it seems to be at least a year or two
old, talking about Qt6.0 and I gather we are at Qt6.6 by now.  Plus endless
short conversations in places like Reddit that throw off more heat than
light.

Does anyone have any suggestions as to where to keep informed on this
topic?  Because it seems like Wayland is coming whether we want it or not...

Thanks in advance

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Problem with Python/Qgis

2023-12-12 Thread chris hermansen via QGIS-User
Gael and list,

On Tue, Dec 12, 2023 at 8:03 AM Gael Kermarrec via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Dear members,
>
> I am trying to install Qgis from Ubuntu 20.04 but everytime I make sudo
> apt install qgis qgis-plugin-grass I become the following:
>
>
> The following packages contain unsatisfied dependencies:
> qgis: Depends on python3-qgis (= 1:3.22.16+32focal) but
> 1:3.26.3+32focal-ubuntugis needs to be installed
> Depends on qgis-providers (= 1:3.22.16+32focal) but
> 1:3.26.3+32focal-ubuntugis needs to be installed
> Depends on qgis-common (= 1:3.22.16+32focal) but
> 1:3.26.3+32focal-ubuntugis needs to be installed
> qgis-plugin-grass: Depends on qgis-plugin-grass-common (=
> 1:3.22.16+32focal) but 1:3.26.3+32focal-ubuntugis needs to be installed
> Depends on grass782
> E: Unable to correct problems, defective packages are in "keep in the
> current state" mode.
>
> I have no idea what I should do to make it works. Maybe somebody had the
> same problem, I would be grateful to get some support as I would like to
> work with QGis.
>
> It looks as though you might be trying to work with the ubuntugis PPA.  If
that's so, maybe you should consider trying the suggested methodology on
the QGIS site here:

https://www.qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu

If you just want to correct the unsatisfied dependencies, it's probably
worth trying your command again with the "-f" option:

apt install -f qgis qgis-plugin-grass

In any event, I suggest you read this useful mini-tutorial on fixing
unsatisfied dependencies.

https://askubuntu.com/questions/140246/how-do-i-resolve-unmet-dependencies-after-adding-a-ppa
-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-21 Thread chris hermansen via QGIS-User
Fredy and list

On Thu, Sep 21, 2023, 19:48 Fredy Varon  wrote:

> Hi chris
>
>
>
> About your questions.
>
>
>
>1. which client are you trying to use? Oracle Database Programming
>interface in C?  JDBC? or... ?
>
> Im trying to use Qgis Desktop 3,22 and 3.28 to Access an Oracle Database
> via OCI (Oracle Call Interface) instaled via Oracle instant client 12c
>
>1. what configuration parameters do you use?
>
> Thats the problema when im install qgis desktop this dont show up the
> option to connect to Oracle
>
> On Windows i see this option on Navigator
>
> But install qgis desktop on Linux enviroment dont permit this option
>
>
>1. what is the error you receive?
>
> I need to install qgis desktop and see the Oracle option to stablish the
> connections to databases that i need to see
>

It looks to me that the QGIS install isn't "aware" of your OCI library.

Possibly a path issue?

Maybe this tutorial would help?

https://freegistutorial.com/how-to-connect-qgis-to-oracle-spatial-database/


Chris

>
___
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] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-21 Thread chris hermansen via QGIS-User
Fredy and list,

On Thu, Sep 21, 2023 at 11:50 AM Fredy Varon via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi.
>
> I need to configure qgis desktop on Linux enviroment and enable in the
> explorer the opción tio connect to Oracle databases
>
> Please any guise ti do this, un Windows works if before i install Oracle
> client, in Linux i configure the same but dont enable this type of
> connections in qgis
>
> Fredy, please provide more details on how you configure the Oracle client
in Linux and what happens:

   1. which client are you trying to use? Oracle Database Programming
   interface in C?  JDBC? or... ?
   2. what configuration parameters do you use?
   3. what is the error you receive?



-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Installing QGIS on Linux Mint 21.2.1

2023-09-20 Thread chris hermansen via QGIS-User
Bill and list;

On Wed, Sep 20, 2023 at 11:14 AM Bill Symington via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello -
>
> I recently set up my computer Windows 10 computer as a dual boot machine
> with Windows 10 and Linux MInt 21.2. I have had QGIS on the Windows side
> for some time and wanted install it on the Linux side also. I was
> successful at installing QGIS, but I've gotten a different version than I
> have under Windows.
>
> Under Windows 10 I have QGIS 3.28.8-Firenze. Under Linux I have QGIS
> 3.22.4-Biatowieza. I'd prefer to have the same version under both OS's. I
> have tried reinstalling QGIS on the Linux side (to bring it up to date with
> the Windows sode) following the instructions on the QGIS Web site. I get
> the following error message.
>
> bill 35 ->sudo apt update
> Hit:1 https://dl.google.com/linux/chrome/deb stable InRelease
> Ign:2 http://packages.linuxmint.com victoria InRelease
> Hit:3 http://packages.linuxmint.com victoria Release
> Hit:4 http://archive.ubuntu.com/ubuntu jammy InRelease
> Hit:6 http://archive.ubuntu.com/ubuntu jammy-updates InRelease
> Hit:8 http://archive.ubuntu.com/ubuntu jammy-backports InRelease
> Hit:9 http://security.ubuntu.com/ubuntu jammy-security InRelease
> Ign:7 https://debian.qgis.org/debian victoria InRelease
> Err:10 https://debian.qgis.org/debian victoria Release
>   404  Not Found [IP: 2606:4700:3035::ac43:8f17 443]
> Reading package lists... Done
> E: The repository 'https://qgis.org/debian victoria Release' does not
> have a Release file.
> N: Updating from such a repository can't be done securely, and is
> therefore disabled by default.
> N: See apt-secure(8) manpage for repository creation and user
> configuration details.
> bill 36 ->
> bill 36 ->
>
> I'm not sure how to proceed.
>
>
 You're using Linux Mint which doesn't have a distribution branded for it.
Mint "victoria" 21.2 says here
https://linuxmint.com/rel_victoria_cinnamon.php that

Linux Mint 21 is based on Ubuntu 22.04. Make sure to read the Ubuntu
> release notes
> .
>

So you need to download the correct version for Ubuntu 22.04 which is
codenamed "jammy".

In your /etc/apt/sources.list.d you should have a file called qgis.sources
and I believe it should look like this:

Types: deb deb-src
URIs: https://qgis.org/debian-ltr
Suites: jammy
Architectures: amd64
Components: main
Signed-By: /etc/apt/keyrings/qgis-archive-keyring.gpg

Yours probably currently looks like this:

Types: deb deb-src
URIs: https://qgis.org/debian
Suites: victoria
Architectures: amd64
Components: main
Signed-By: /etc/apt/keyrings/qgis-archive-keyring.gpg

This will not work - first of all it's going to get the latest release
(that's why you need "debian-ltr") and second it is looking for code name
"victoria" which doesn't exist there (that's why you need "jammy").

I hope this gets you further up the road!
-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Output to pdf file doesn't contain vector details

2023-09-18 Thread chris hermansen via QGIS-User
Michael and list,

I've been following along trying some stuff with data I have on hand and
offer you some comments below.

On Mon, Sep 18, 2023 at 9:25 AM Michael McNeil  wrote:

> The foregoing got sent before it was ready, sorry. I'll just continue from
> where I left off.
>
> As I said, I would prefer to use shapefiles to transfer the data – that
> *is* intended to be an interim format – however CorelDraw doesn't accept
> shapefiles (.shp) , though it does svg. But I've found that the reason why
> I can't produce svg (and pdf) files containing the detailed vector-graphics
> data that I wish to include in the map, for transfer into CorelDraw, is
> because Qgis believes (so I surmise) that I must want to ultimately *print
> out* the data – and because printers (or engravers, or whatever)
> inherently must have a maximum resolution they can render, Qgis has
> thoughtfully determined that that maximum should be no greater than 3000
> dpi (with a mere 300 dpi being the default).
>

> That, of course (the Export Resolution), is why my detailed contour lines
> are being rendered (upon Layout) into mere solid blobs of color –
> accompanied by an 80 MB pdf file! It seems crazy to me.
>

Not sure you're correct here - did you select "Always export as vectors" in
the SVG (or PDF) export window?  If so, then your vectors are not being
rasterized.  However, they ARE being reproduced at the thickness determined
by your settings and the print scale.


>
> Why? Because – regardless of the merits of being able to transfer
> full-resolution vector graphics using the svg and pdf formats – there's
> also the possibility (which the powers at be at Qgis don't seem to realize
> – I'm sure you all will correct me on this) of using (say) pdf format as a 
> *presentation
> medium* for Qgis' (and others') vector-graphics maps. By presentation I
> mean an interactive experience for viewing maps – in other words, the Qgis
> output should not just be for *printout*.
>

[examples deleted]

The SVG conversion you are using is part of the QGIS "print layout manager"
functionality, where the user is preparing a cartographic product for
reproduction at a certain scale and resolution.  So it's quite reasonable
that such functionality would behave the way QGIS doe; someone using QGIS
to make a cartographic product they intend to be used at a print size of
8.5 X 11 inches or 1 X 2 metres would expect to see lines of a chosen
thickness when the product is reproduced at that desired scale.

Accordingly, one thing that might help is if you choose a larger page size,
the default being A4 or US Letter.  You might also try experimenting with
layer Properties > Symbology > Stroke width.  This won't give you the
"infinite zoom" you hope for, but the lines will appear finer when zoomed
out to full screen and zoomed in to 100% zoom, assuming you selected a fine
stroke width.

I can understand your idea that SVG does after all mean "Scalable", but it
seems to me that the incorporation of the SVG export into the QGIS print
layout manager is not going to go in the direction you want.

You may be able to edit the line parameters in the SVG file once you import
it into Corel Draw.  I tried using LibreOffice Draw; I first ungrouped all
the elements in the SVG, selected some lines and then edited the line
styles.  This produced an SVG with nice thin zoomable lines.

>
> If that had been a map of (say) southern Great Britain (about 300 miles
> wide), a 6400% zoom would bring you up on any given *5 mile* stretch of
> the map. Nor does a limit of 64x zoom appear to be inherent in the pdf
> format – it's merely the viewer app designer's option, best I can tell.
>

Not sure what viewer app you're referring to here so I'll skip over this.

>
> Why wouldn't anybody (Qgis, for instance) *want* the capability of
> producing output maps that one can do that with – if desired by the map's
> creator! Why choose to enforce pixelation onto a vector format where it
> isn't inherent?
>

As I mentioned above, you're able to not rasterize, and if you do so, your
line thickness is a result of your output settings including line "weight"
and page size, ie intended print resolution, not pixelation.

Maybe you should look at a different QGIS export pathway, which you can
find by right-clicking on the layer you want to export, selecting  "Export
> Save Features As..." and working with whatever format that appears in
that list that works with Corel Draw (maybe AutoCAD DXF?).


> I suggest that that a specific Export Resolution dpi value in Qgis' Layout
> settings be made optional – with “Unlimited” as another option.
>

If SVG were one of the layer export options, I imagine it would be intended
to work this way.


>
> Best,
> Michael McNeil
>
>
>
> On Mon, Sep 18, 2023 at 8:43 AM Michael McNeil 
> wrote:
>
>> Chris, Garth, others,
>>
>> Now that we've resolved the issue of reentering Qgis and accessing my
>> previously saved project data (thanks again, Garth!), I can go on to
>> 

Re: [Qgis-user] Output to pdf file doesn't contain vector details

2023-09-13 Thread chris hermansen via QGIS-User
Michael and list.

On Wed, Sep 13, 2023 at 10:22 AM Michael Edward McNeil 
wrote:

> Chris, I could experiment with QGIS's cartography capabilities more if I
> could save my project, exit, and then resume working on it later. My other
> problem with QGIS interferes with that potential procedure.
>

Perhaps there is a degree of misunderstanding here.

When you work with say Microsoft Word to eventually produce a document that
you will export to PDF to send to others, you don't save your interim work
in PDF; you save it in Word's internal format, .docx.

Similarly with QGIS, you save an ongoing piece of work as a project. Look
at the Project menu item, where you will see the ability to Save or Save
As.  When you're ready to export your work to PDF or some other output
format, there is an "export work flow".

There is also an important QGIS component not immediately visible, which is
the Print Layout, also available in the Project menu item.

You might wish to follow through the online documentation here
https://docs.qgis.org/3.28/en/docs/training_manual/map_composer/map_composer.html
to see how that component is used to make a map, with surround, annotation,
etc ready for export to PDF as a finished product.

So the overall workflow is to assemble the various layers you wish to
depict on the main QGIS screen, applying symbology to each layer; then open
a print layout to wrap up what's on screen into a full map composition.


> Yes, aligning a single layer in another app with its true position is a
> problem. If I continue trying to do it this way, I'd probably also output
> meridians and possibly other clues (e.g., the British coastline) to allow
> aligning it properly.
>

Don't forget that you can add useful raster layers, like Open Street Map,
to your screen and map composition, to save yourself a lot of time with
respect to tracking down vector or raster data sets, symbolizing them, and
so forth.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Output to pdf file doesn't contain vector details

2023-09-13 Thread chris hermansen via QGIS-User
Michael and list,

On Wed, Sep 13, 2023 at 10:00 AM Michael Edward McNeil via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> I'm an almost total novice with regard to GIS in general and QGIS in
> particular. Nonetheless I've been attempting to put together a test map
> (using data I will make use of, in part) utilizing the contour lines for
> the island of Great Britain – obtaining data in that regard from the space
> shuttle's worldwide Shuttle Radar Topography Mission (SRTM).
>
> I obtained the data and loaded it into QGIS, no problem. After extracting
> the contours, the lines shown in QGIS are nice and sharp, and vectorize
> properly when zooming in and out. I'm using 100 meters between lines
> (rather than the default 10 m) which means that in some regions of the
> planet, they're not all that dense; nonetheless if you're looking at a
> larger scale view of, say, Wales or Scotland, the contour lines show up at
> that scale as generally pretty dense. The solution, of course, using vector
> graphics is to zoom in, then you can see the full detail.
>
> Anyway, things are fine while still within QGIS (except for the secondary
> issue noted below). However, I wanted to output the vectorized contour
> lines into a file I could input into (e.g.) CorelDRAW to add other layers
> and do the graphical finishing touches on the desired map. I tried svg
> format – got the message about svg handling in QGIS being buggy – and
> indeed the svg output didn't seem to work.
>

Is there any reason you can't do your cartography within QGIS?  Or at
least, make a "simplified" draft map, save as an image or PDF, and then do
whatever "graphical finishing" required in your desktop publishing
application?

I think this would be a more "normal" approach, rather than exporting a
layer by itself, if for no other reason than your geospatial information
will be properly aligned by QGIS in the final product.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] spatial analysis toolbox - testing for autocorrelation

2023-08-14 Thread chris hermansen via QGIS-User
Francesca and list,

On Mon, Aug 14, 2023, 02:58 Francesca Parente via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Thank you both! I checked that out and tried the suggested installing
> procedure.. but I can't get the command prompt where to type "pip install
> geopandas".
> I think I'm still missing a piece, I'm not so familiar with the python
> environment as you can assume.
>

Here is a useful explanation of using pip in python

https://packaging.python.org/en/latest/tutorials/installing-packages/



> These are the steps I followed:
>
> [image: image.png]
> --->
> [image: image.png]
> Then I clicked on "python3.dll", which downloaded the file I tried to open
> - but got me just another error message in QGis (saying that is an invalid
> data source).
> I searched online for other tips and tutorials, but (besides another
> procedure using fiona) I haven't found anything more specific on this one.
>
> Should I go into the "Scripts" folder and click on "pip.exe" or "pip3.exe"?
> Thanks again for your time and any other inputs you may have!
> Francesca
>

You will want to run python from a command line, not by clicking a dll.

Open your command prompt from the windows menu.


>
> Il giorno ven 11 ago 2023 alle ore 19:20 Thayer Young via QGIS-User <
> qgis-user@lists.osgeo.org> ha scritto:
>
>> Hi Francesca,
>>
>> If you don't know how to install Geopandas, I would like to add to what
>> Paolo said. Geopandas needs to be installed in the python that QGIS is
>> using.
>> You can check the location of the python installation by going to the
>> overall preferences for QGIS (command comma on a Mac, probably control
>> comma on other systems.)
>> From the System tab scroll to the bottom to find the "Current environment
>> variables" scroll down to find PYTHONHOME.
>> This documentation page shows you more with pictures:
>>
>> https://docs.qgis.org/3.28/en/docs/user_manual/introduction/qgis_configuration.html#system-settings
>>
>> Then in Finder or Explorer, etc. you want to find  location in the file
>> system. On a Mac you will need to right click on QGIS in your applications
>> folder and show package contents.  Then continue through the path and
>> double click to open the python3 file.
>> This will bring up a python prompt where you want to type:   pip install
>> geopandas   Then press enter/return. It will run for a while and hopefully
>> say that you successfully installed geopandas. You will probably need to
>> restart QGIS after that.
>>
>> -Thayer
>>
>>
>>
>> On Thursday, August 10, 2023 at 03:00:37 PM EDT,
>> qgis-user-requ...@lists.osgeo.org 
>> wrote:
>> --
>> Date: Thu, 10 Aug 2023 17:29:39 +0300
>> From: Paolo Cavallini 
>> To: Francesca Parente , Francesca
>> Parente via QGIS-User , QGIS User List
>> 
>> Subject: Re: [Qgis-user] spatial analysis toolbox - testing for
>> autocorrelation
>> Message-ID: 
>> Content-Type: text/plain; charset="utf-8"
>>
>> You have to install geopandas.
>> Cheers.
>>
>> Il 10 agosto 2023 17:10:28 EEST, Francesca Parente via QGIS-User <
>> qgis-user@lists.osgeo.org> ha scritto:
>> >Hello everyone!
>> >
>> >I was wondering how to perform spatial autocorrelation tests in QGis and
>> I
>> >downloaded the Spatial Analysis Toolbox
>> > plugin.
>> >I can't even open it thought and immediately got the following error
>> >message:
>>
>> >*Impossibile caricare il plugin 'spatialanalysistoolbox' a causa di un
>> >errore chiamando il metodo classFactory() ModuleNotFoundError: No module
>> >named 'geopandas' Traceback (most recent call last):  File
>> >"C:/OSGEO4~1/apps/qgis/./python\qgis\utils.py", line 335, in _startPlugin
>> >  plugins[packageName] = package.classFactory(iface)  File
>>
>> >"C:/Users/fparente/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\spatialanalysistoolbox\__init__.py",
>> >line 36, in classFactoryfrom .spatialanalysistoolbox import
>> >SpatialAnalysisToolboxPlugin  File
>> >"C:/OSGEO4~1/apps/qgis/./python\qgis\utils.py", line 799, in _import
>> mod
>> >= _builtin_import(name, globals, locals, fromlist, level)  File
>>
>> >"C:/Users/fparente/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\spatialanalysistoolbox\spatialanalysistoolbox.py",
>> >line 38, infrom .spatialanalysistoolbox_provider import
>> >SpatialAnalysisToolboxProvider  File
>> >"C:/OSGEO4~1/apps/qgis/./python\qgis\utils.py", line 799, in _import
>> mod
>> >= _builtin_import(name, globals, locals, fromlist, level)  File
>>
>> >"C:/Users/fparente/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\spatialanalysistoolbox\spatialanalysistoolbox_provider.py",
>> >line 35, infrom .algorithms.GWR_ import GWR_  File
>> >"C:/OSGEO4~1/apps/qgis/./python\qgis\utils.py", line 799, in _import
>> mod
>> >= _builtin_import(name, globals, locals, fromlist, level)  File
>>
>> 

Re: [Qgis-user] Dot Density Symbology

2023-07-26 Thread chris hermansen via QGIS-User
Hugh and list,

On Wed, Jul 26, 2023, 10:24 Hugh Kelley via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi all,
>
> I've been producing dot density maps for demographics work by using
> postgis to assign points randomly within a polygon with the number of
> points determined by, for example, the total number of a population
> sub-group residing in that polygon.
>
> I"m wondering if there might be a way to do this directly from the
> polygons in QGIS with symbology.
>
> I've looked through the resource sharing plugin without luck. I dont'
> think the geometry generator can handle such a task but maybe there's a
> way?
>
> Here's (apologies for the closed source link) an example of the type of
> map/symbology I'm trying to describe.
> https://www.arcgis.com/apps/mapviewer/index.html?webmap=30d2e10d4d694b3eb4dc4d2e58dbb5a5
>
> Thanks for any suggestions!
>

What about just shading the polygons using a gray scale?

Given that your polygons should generate a uniform density of dots within
the area they bound, I don't see value in generating the dots for symbology.

Chris

>
___
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] Authenticity of softwares

2023-06-29 Thread chris hermansen via QGIS-User
NP Singh and list,

On Thu, Jun 29, 2023 at 12:15 PM nr via QGIS-User 
wrote:

> Dear Users,
>
> I wanted to make a general query.
>
> How do we establish the authenticity of freely available online softwares
> or tools in general which can be downloaded from links are used from the
> page itself
>
> How do we know if they are  certified by professional bodies or they are
> peer reviewed just like journal papers.
>
> I understand that the softwares may have certain limitations or applicable
> with conditional inputs  and we need to know them before using.
>
> As to authenticity, you will see on many download sites the offer to
download verification keys, which when applied demonstrate authenticity to
some degree (provided that the organization's site hasn't been fully
hacked).

Read these QGIS instructions as an example of how this is done.
https://www.qgis.org/en/site/forusers/alldownloads.html#debian-ubuntu

You may well ask "how do I know my copy of Windows is genuine", which may
be an interesting thought experiment.

As to certified by professional bodies, you are unlikely to find
professional bodies willing or able to certify software.  Again, you will
find the same problem with commercial software.  Some particular software
is audited, typically software that claims some kind of privacy or
security.   Here is an example of this kind of thing:

https://www.securemessagingapps.com/

In any case, which professional body's recommendations might you trust with
your organization's security?  I can't name one, offhand.

As to peer review, open source facilitates peer review and security fixes,
closed source impedes or even precludes it.  Closed source, when provided
for peer review, is often under non-disclosure of some kind, which limits
what we know about it.

In summary, policies don't protect your organization's information nor
systems - you do.

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] SAGA Next Gen for MacOS

2023-06-26 Thread chris hermansen via QGIS-User
Etsuko and list,

On Mon, Jun 26, 2023 at 8:53 AM Etsuko Nonaka via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello Lorenzo,
>
> Thank you for your help! I tried both QGIS 3.30.x and 3.32, but I do not
> have Providers under Processing. QGIS 3.32 has SAGA Next Gen plugin already
> installed, but it is version 7.2, not 7.8 as you say, and it still says
> "Requires manuaö installation of SAGA 7.2 binaries."
>

Try  Settings > Options > Processing > Providers?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Consulta

2023-06-21 Thread chris hermansen via QGIS-User
Buenas tardes Juan Pablo,

On Wed, Jun 21, 2023 at 11:44 AM Juan Pablo Moreno Sebastian via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Buenas tardes.
>
> Soy Juan Pablo Moreno.
>
> Tengo que desarrollar un plugin para QGIS que calcule la prominencia
> orográfica de los cerros para después pasar a clasificar los puntos.
>
>
These two sources in English may relate to solutions to your problem

https://gis.stackexchange.com/questions/424121/extracting-mountain-peaks-from-a-dem-in-qgis
https://topotoolbox.wordpress.com/category/gridobj/



-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS controlling access in QGIS

2023-05-30 Thread chris hermansen via QGIS-User
Simon and list,

On Tue, May 30, 2023, 08:48 Simon via QGIS-User 
wrote:

> Hello,
>
> It's me again, I just had some questions regarding the ability to control
> access in QGIS. First of all, is it even possible? Can an organization
> (like departments of the Canadian government) control who has access to
> which database or file? Can the IT department of that organization manage
> the access?
>

Access to files is controlled through operating system settings. Access to
databases is controlled by database settings. Normally in organizations
system administrators manage these settings.

Whatever software application is run is limited in its access by those
settings. It would be unusual for an end user software application to
further manage access.

Settings typically include ability to read, ability to write, ability
create and ability delete. So for example a set of shape files could be
shared as read only to users, to a group of users, or via access control
lists.

>
To your point - access to resources is not controlled through QGIS; it is
controlled by the operating system, and by the database server if one is
used.

>
>
___
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] PSA: Don't update to Gnome 44!

2023-05-04 Thread chris hermansen via QGIS-User
Nyall and list,

On Thu, Apr 27, 2023 at 10:26 PM Nyall Dawson via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi lists,
>
> Just a quick PSA: If you're using QGIS (or any Qt based app), I recommend
> avoiding an upgrade to any gnome 44 based distribution for now.
>
> You'll get hit with this nasty bug:
> https://gitlab.gnome.org/GNOME/mutter/-/issues/2715 which breaks drag and
> drop functionality in all Qt applications. And in the process, basically
> makes QGIS unusable... 
>
> You've been warned!
>
>
Looking at the bug link, I see it's closed and there seems to be some
recent commits and merges.  Do you have any idea if it's fixed?


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Problems with installation QGIS Server 3.28.5 on Ubuntu 22.04.

2023-04-21 Thread chris hermansen via QGIS-User
Günter and list

On Fri, Apr 21, 2023, 18:48 G. Wagner, Wagner-IT via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello,
>
> I have problems installing QGIS Server 3.28.5 on Ubuntu 22.04. (Hetzner
> Cloud Server [1]):
> I proceed accordingly [2]. But with "sudo apt install qgis-server
> --no-install-

recommends --no-install-suggests " I receive:
>

Why do you use the --no-install flags?

Maybe try without?
___
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] How to have photos appear in HTML tips *and* the attribute editor?

2023-04-16 Thread chris hermansen via QGIS-User
Adam and list,

On Sun, Apr 16, 2023, 08:25 Adam Nielsen via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

[Stuff deleted]

>
>
> In the layer I have specified this as:
>
>   
>

[Stuff deleted]

>
>
> P.S. I have seen many things saying you must specify the URL as
> file:/// with three slashes to make it work under Windows, but under
> Linux you must have only two slashes.  It would be nice if any solution
> to this worked across all platforms.
>

I can't speak to solving your problem, but as to your PS:


https://en.m.wikipedia.org/wiki/File_URI_scheme

will help you understand file URLs. Specifically the format is

file://host/path

and when host is omitted the slash delimiter is not.

Note especially the comment

... two slashes, without a hostname) is never correct, but is often used
___
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] Qchainage plugin

2023-03-30 Thread chris hermansen via QGIS-User
Tim and list,

On Thu, Mar 30, 2023 at 12:09 PM Tim Fearn via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi everyone,
> I’m trying to use the qchainage plugin to create ½ mile markers along a
> vector line that represents a trail.  The line is a single feature with no
> multi-parts or dangles.  It is about 318 miles long so I would expect right
> around 636 points if there is one every half mile.  My project default is
> set to miles for length measurements as is the qgis main preference.  I set
> the unit measurement to miles and input .5 as the interval.  I continually
> get 771 points instead of the expected 636.  Also when I use the automatic
> labeling feature of the plugin it appears to be in degrees not an aggregate
> mileage.
>

What is the projection of your data?

>
>  Several weeks ago a fellow had queried the list on the same subject.
> He was working with the Appalachian Trail I believe and wanted to place
> points at given distances.  No one seemed to really understand so I’m
> hoping that if anyone remembers the original poster, and has come up with
> any thoughts or other ideas it would be much appreciated.  This is
> something that can be done for sure.  All of the National Scenic Trail maps
> in this country are demarcated with some form of mile or half mile makers
> which when labeled show the accumulated distance.
>
>  Hoping for some traction on this.  I’ve only just started learning
> python so I wouldn’t describe myself as a programer and am looking for a
> relatively simple solution.
>
> The more specific information you can share, the more likely it is someone
can help you.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS server : Serve Postgis data ?

2023-03-27 Thread chris hermansen via QGIS-User
Laurent and list,

On Mon, Mar 27, 2023, 09:09 celati Laurent via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Good afternoon,
> Following to my previous message, I'm sharing my error. I am unable to
> serve a project containing postgis tables. For a first test, I'm just
> trying to serve one of the tables contained in my project. Here is the URL
> that I defined and tested. I tried to define max and min coordinates (BBOX)
> in the spatial reference system in 2154 (Lambert 93).
>
> * 
> http://SERVEUR/cgi-bin/qgis_mapserv.fcgi?MAP=/home/qgis/projects/cigeo_forages.qgs=Cigeo_Zios_Po=WMS=1.3.0=GetMap=EPSG:2154=400=200=865347.7454,6820554.3899,886533.8979,6833234.8104
> *
>
> Please read below the error message : Internal Server Error
>
>
>
> *The server encountered an internal error or misconfiguration and was
> unable to complete your request.Please contact the server administrator at
> webmaster@localhost to inform them of the time this error occurred, and the
> actions you performed just before this error.More information about this
> error may be available in the server error log.*
> If someone has any idea? To be complete, since the beginning of my tests,
> I have never had a log file generated in /var/log/qgis...This folder has
> been always remained empty
> Thanks a lot.
>


Anything interesting in the PostgreSQL log file? Or syslog?


> Le lun. 27 mars 2023 à 11:48, celati Laurent  a
> écrit :
>
>> Good morning,
>> I have just (finally) validated the installation of Qgis server on our
>> Debian server.
>> I manage to serve/broadcast the .qgs project and the data made available
>> by the community (world.qgs project). These are shp files.
>> In parallel with the installation of Lizmap or QWC2, I would like to test
>> this time the fact to serve of qgis projects containing postgis tables from
>> our database. How to do this ? Especially for the definition of the URL?
>> How to define in the URL the sources of the postgis tables? The URL notably
>> has a LAYERS&...
>> How for example to publish all the postgis tables contained in a project,
>> without having to specify each of them in the URL?
>> Thank you so much.
>>
> ___
> 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] Placing random points

2023-03-24 Thread chris hermansen via QGIS-User
Andrea and list,

On Fri, Mar 24, 2023 at 5:00 PM Andrea Giudiceandrea via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> > Thomas Sebastien sebasapp at hotmail.com
> > Fri Mar 24 03:32:25 PDT 2023
>
> > what works best for what I’m trying to achieve is dissolving the
> polygons and placing random points in layer bounds
>
> Hi Sebastien,
> AFAIK, you don't need to dissolve the polygons before using them as
> input of the "Random points in layer bounds" algorithm: such algorithm
> correctly places the total chosen number n of random points even if the
> input N features/polygons are not dissolved.
>
> I believe I was the one who suggested the layer bounds approach.

Thomas Sebastian, you do not need to dissolve the polygons if you are only
interested in placing the random points within the layer bounds as Andrea
says.  If you have a non-rectangular dataset then your layer bounds could
result in points being placed outside the polygons in your dataset; you
should do the dissolve and place the points within the dissolved polygon.
If like me you live in a rectangular / map-sheet-ish world then by all
means work in the layer bounds.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Placing random points

2023-03-23 Thread chris hermansen via QGIS-User
Thomas and list,

On Thu, Mar 23, 2023 at 2:19 AM Thomas Sebastien via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Dear QGIS users,
>
> I’m trying to place a small number of points, n, randomly in a large
> number of polygons, N. But, the Vector>Research Tools> Random points in
> polygons tool only lets me place a minimum of 1 random point in each of the
> N polygons, i.e N points when I only need n. Do you know a way I can go
> about this?
>

Does

Vector >  Research Tools > Random points in extent

not accomplish what you want?  Using say the bounding box for all the
polygons?
-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Geopackage slow on NAS if not read-only

2023-03-18 Thread chris hermansen via QGIS-User
Árni and list,

On Wed, Mar 15, 2023 at 12:31 PM Árni Geirsson via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello all QGIS and geopackage users.
> I store my geopackages on a Synology RackStation NAS unit, like all other
> documents that are kept on a shared drive in the office. For larger
> datasets, the rendering is very slow, unless I open the properties dialog
> for the file in Windows and check the read only box. After that, the
> features are rendered blazingly fast. Nothing else is changed to see the
> dramatic difference in the rendering speed. Luckily, I don't need to edit
> many of the larger datasets, such as road networks and elevation contours
> and the geopackage can be kept read only. Shapefiles are not affected.
> What explains this and does anyone know how to solve the problem?
> Do other users experience this?
>
> You might find this thread of interest.  It talks about performance tuning
Samba read / write shares.  As to whether it applies directly to your
situation of course I cannot say.

https://serverfault.com/questions/734124/samba-share-write-performance

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] GPKG Multi-Layer to one flat

2023-03-03 Thread chris hermansen via QGIS-User
Dennis and list

On Fri, Mar 3, 2023 at 11:45 AM Dennis Burgess via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Ok, has to be a simple solution.
>
>
>
> I have a GPKG file that is around 50 meg.  This has multiple layers or at
> least I can see multiple layers.  I.e. I have one polygon on top of another
>
>
>
> What I want is to flatten these, to where ONLY the exact area that is show
> is displayed in the smallest file possible.
>
>
>
> Union is the way to do this but its SLOW SLOW..  any other options… ?
>
>
Are the overlapping polygon geometries "the same", ie boundaries are
coincident?  If that's the case, then the attributes from each polygon
refer to exactly the same and you could just pick one of the layers and
join the attributes on from the other layers.

If the geometries are distinct, union is one choice.  Another might be to
convert all the polygons to linestrings, merge the linestrings into one
layer, convert the merged linestrings back to polygons and then use spatial
join to transfer the attributes back to the new polygons.  Not sure if that
would be faster.  One potential problem with this general sort of problem
is the creation of many tiny polygons where the linework is not quite
coincident.  This can certainly mess with your concept of "the exact area".

Rasterizing the polygons, overlaying, then vectorizing might be another
choice.

I think it's probably hard to say "what's best" or "what's simplest"
without actually seeing an example of the overlap.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS (OGR) updating ESRI file geodatabases

2023-02-28 Thread chris hermansen via QGIS-User
Thanks Randy,

If I understand Even Roualt's earlier reply it's only the FGDB version 10
and newer that can be edited.  I was really hoping for the version 9 ones...

On Tue, Feb 28, 2023 at 8:58 AM Randal Hale via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hey Chris - So I've done two things in this area (I'm currently on fedora
> on one machine and ubuntu on a second).
>
> Flatpak will let you edit FGDBs and has updated gdal (i believe officially
> sanctioned through QGIS)
>
> Currently I'm working with this:
> https://github.com/conda-forge/qgis-feedstock and it's pretty smooth (you
> just have to install conda) and can edit FGDB.
>
> Good luck,
>
> Randy
>
>
> On 2/28/23 10:38, chris hermansen via QGIS-User wrote:
>
> Thanks Even, I appreciate the clarification though I'm sobbing quietly
> because I was hoping for ArcGIS 9 support.
>
> On Tue, Feb 28, 2023 at 4:24 AM Even Rouault 
> wrote:
>
>>
>> However today I stumbled upon this:
>>
>> https://gdal.org/drivers/vector/openfilegdb.html
>>
>> which clearly states:
>>
>> The OpenFileGDB driver provides read, write and update access to vector
>>> layers of File Geodatabases (.gdb directories) created by ArcGIS 9 and
>>> above.
>>>
>> That was misleading. I've just corrected it. Write support is only for
>> ArcGIS 10.x geodatabases
>>
>> -- http://www.spatialys.com
>> My software is free, but my time generally not.
>>
>>
>
> --
> Chris Hermansen · clhermansen "at" gmail "dot" com
>
> C'est ma façon de parler.
>
> ___
> QGIS-User mailing listqgis-u...@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
> -- https://www.northrivergeographic.com
> (423) 653-3611 rjh...@northrivergeographic.com
>
> ___
> 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
>


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS (OGR) updating ESRI file geodatabases

2023-02-28 Thread chris hermansen via QGIS-User
Thanks Even, I appreciate the clarification though I'm sobbing quietly
because I was hoping for ArcGIS 9 support.

On Tue, Feb 28, 2023 at 4:24 AM Even Rouault 
wrote:

>
> However today I stumbled upon this:
>
> https://gdal.org/drivers/vector/openfilegdb.html
>
> which clearly states:
>
> The OpenFileGDB driver provides read, write and update access to vector
>> layers of File Geodatabases (.gdb directories) created by ArcGIS 9 and
>> above.
>>
> That was misleading. I've just corrected it. Write support is only for
> ArcGIS 10.x geodatabases
>
> -- http://www.spatialys.com
> My software is free, but my time generally not.
>
>

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS (OGR) updating ESRI file geodatabases

2023-02-28 Thread chris hermansen via QGIS-User
Thanks, Jürgen, I should have known this.

On Mon, Feb 27, 2023 at 11:47 PM Jürgen E. Fischer via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi Chris,
>
> On Mon, 27. Feb 2023 at 12:33:31 -0800, chris hermansen via QGIS-User
> wrote:
> > So I fired up QGIS 3.28 running on Ubuntu 22.10 and opened an ArcGIS 9.3
> > created file geodatabase and, sure enough, could not edit it.
> >
> > I then checked the About QGIS page which indicates the GDAL/OGR version
> is
> > 3.5.1 and I see reading further on the GDAL page linked above that the
> > "Create" functionality is new in 3.6.
> >
> > Therefore, I'm wondering when we might see this surfaced in QGIS.  Can
> > anyone on this list give me an idea as to when this wonderful event might
> > occur?
>
> QGIS uses what your distribution offers.
>
> Ubuntu lunar has GDAL 3.6.2 - kinetic only 3.5.1.  (see
> https://packages.ubuntu.com/search?keywords=gdal=names=all=all
> )
> ubuntugis has GDAL 3.6.2 for jammy - but not for non-lts kinetic (see
> https://launchpad.net/~ubuntugis/+archive/ubuntu/ubuntugis-unstable/+packages?field.name_filter=gdal_filter=published_filter=
> )
>
>
> Jürgen
>
> --
> Jürgen E. Fischer   norBIT GmbH Tel. +49-4931-918175-31
> Dipl.-Inf. (FH) Rheinstraße 13  Fax. +49-4931-918175-50
> Software Engineer   D-26506 Norden
> https://www.norbit.de
> QGIS release manager (PSC)  Germany IRC: jef on Libera|OFTC
> ___
> 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
>


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS (OGR) updating ESRI file geodatabases

2023-02-27 Thread chris hermansen via QGIS-User
Work sometimes throws an ESRI file geodatabase my way, almost always one
created in ArcGIS 9.3, and until today I assumed that I can only write /
update these datasets when they are created in ArcGIS 10 and above.

However today I stumbled upon this:

https://gdal.org/drivers/vector/openfilegdb.html

which clearly states:

The OpenFileGDB driver provides read, write and update access to vector
> layers of File Geodatabases (.gdb directories) created by ArcGIS 9 and
> above.
>

So I fired up QGIS 3.28 running on Ubuntu 22.10 and opened an ArcGIS 9.3
created file geodatabase and, sure enough, could not edit it.

I then checked the About QGIS page which indicates the GDAL/OGR version is
3.5.1 and I see reading further on the GDAL page linked above that the
"Create" functionality is new in 3.6.

Therefore, I'm wondering when we might see this surfaced in QGIS.  Can
anyone on this list give me an idea as to when this wonderful event might
occur?

Thanks in advance!

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] ref pb

2023-02-09 Thread chris hermansen via QGIS-User
Mark and list;

On Thu, Feb 9, 2023 at 8:24 AM Marc Millas via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hello,
>
> I got an autocad dxf file describing objects in Djibouti.
> no pb to load it in qgis as a vector layer.
> but... the srid seems to be 0 and QGIS ask for a valid ref
> as the data looks x,y, I did try epsg 32638, which is standard in Djibouti.
> loads fine... but the objects are around 200km west of where they should
> be.
>
> any idea ?
>
> Perhaps your dxf data is not georeferenced.  It may be in rectangular
coordinates (x, y) representing metres from some origin point that makes
sense when thinking of it as a drawing (like the centre of the drawing or
the southwest corner or a nearby landmark).

Therefore when you assign a projection to it, its origin point will be at
the origin of the projection.  In your case using EPSG 32638, that is UTM
zone 38N whose centre coordinates are 50 4649776 (see
https://epsg.io/32638).

The origin point of your drawing will be in that coordinate system; (0,0)
will be 50 metres west of 45° east longitude and on the equator; in
other words, 40.511256° east longitude and 0° latitude.

The latitude and longitude of Djibouti City is 11.572076, 43.145645 (see
https://www.latlong.net/place/djibouti-city-djibouti-24884.html).  You can
see that your origin point (0,0) in UTM zone 38M is 2.634389° west and
11.572076° south of Djibouti City.

Working back to UTM coordinates, in UTM zone 38N Djibouti City is
297791.1138793365 east and 1279891.9276488272 north (see
https://epsg.io/transform#s_srs=4326_srs=32638=43.1456450=11.5720760)

If your DXF data coordinates - say the centre of the drawing file - aren't
somewhere around (297791,1279892) then you need to transform your data as
you import it (or afterward).

Please read these articles

https://opengislab.com/blog/tag/DWG+DXF+QGIS
https://gis.stackexchange.com/questions/22691/georeferencing-dxf-using-qgis
https://www.mkrgeo-blog.com/good-solution-to-georeferencing-the-autocad-dwg-drawing-in-qgis-3x/

which will provide you with some ideas and more background info.

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] use Binary (Blob) in writeAsVectorFormat

2023-02-03 Thread chris hermansen via QGIS-User
Hugh and list;

On Fri, Feb 3, 2023 at 11:41 AM Hugh Kelley via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> to follow up as I continue to work on this,
>
> I mistakenly understood the attribute type "binary" as a Boolean, but I
> think it's in fact an arbitrary value stored as binary. That is to say, not
> necessarily True/False or 0/1 but a series of 0/1's storing a value.
>
> If I can save it to the shapefile that would be great but I'm going to
> work on filtering those attributes out of what's saved as that's an
> acceptable solution too I think.
>
> On Fri, Feb 3, 2023 at 2:24 PM Hugh Kelley  wrote:
>
>> Hi,
>>
>> I'm attempting to use pyqgis to export a few things to shapefile.
>>
>> the code below is working well except that a few of the attributes are
>> incompatible with shapefiles (amazing) lack of a binary datatype.
>>
>> ```py
>> pathToFile = "C:/Users/hkelley/Downloads/test_exports/
>>
>> layers = QgsProject.instance().mapLayers()
>>
>> for layer_id, layer in layers.items():
>> print(layer.name())
>> QgsVectorFileWriter.writeAsVectorFormat( layer,  pathToFile+
>> layer.name() + ".shp", "utf-8", layer.crs(), driverName="ESRI Shapefile"
>> )
>> ```
>>
>> I see in the manual export options that I can check a box telling the
>> export process to use "Use Binary (BLOB)". Image linked below for clarity
>> [0]
>>
>> I haven't yet figured out how to pass that option to writeAsVectorFormat.
>>
>> any suggestions?
>>
>> Iv'e had a pretty thorough look through the docs for writeAsVctorFormat,
>> is the solution related to
>> QgsVectorFileWriter.BoolOption(QgsVectorFileWriter.BoolOption)?
>>
>>
Have you looked at this https://en.wikipedia.org/wiki/.dbf to understand
how attributes are stored in .dbf files?

In particular there you will see this comment:

*All field data is ASCII. Depending on the field's type, the application
imposes further restrictions: *

Does this help?
-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS for Windows with GSS/Kerberos/Active Directory

2023-02-03 Thread chris hermansen via QGIS-User
Tomas and list,

On Fri, Feb 3, 2023 at 9:25 AM Tomas Pospisek via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> On 03.02.23 18:02, chris hermansen wrote:
> > Tomas and list,
> >
> > On Fri, Feb 3, 2023 at 8:11 AM Tomas Pospisek via QGIS-User
> > mailto:qgis-user@lists.osgeo.org>> wrote:
> >
> > When I try to set up a connection to a Postgres/Postgis DB server
> with
> > Active Directory/Kerberos/GSS authentication the QGIS DB setup dialog
> > displays this message:
> >
> >   gssencmode value "require" invalid when GSSAPI support is not
> > compiled in
> >
> > When I check the Postgres source code [1] I see that apparently this
> > gets displayed when GSS support is not compiled in.
> >
> > So it seems QGIS as shipped by qgis.org  does not
> > ship with GSS support?
> > Is that correct?
> >
> > Does anybody use QGIS on Windows with GSS? How did you do it?
> >
> > I could go ahead and download the EDB Postgres ZIP [3] and exctract
> > libpq.dll from it and replace the libqq.dll shipped by the QGIS
> > installer with it, but I'm not sure if that would work at all, if
> that
> > would be robust and it'll certainly be a pain to maintain.
> >
> > Any pointers/suggestions/help?
> >
> >
> > Maybe this is the proverbial dumb question... but why not install your
> > EDB PostgreSQL on your windows machine and run it on a different port?
> > And then connect to it from your QGIS instance, on that different port
> > of course?
>
> Thanks for your answer Chris, but I can't see how you your reply relates
> to my question. I need QGIS to authenticate users with Active
> Directory/Kerberos. That QGIS/libpq fails to do so doesn't have anything
> to do with ports but with the fact that GSS support is not compiled into
> the libpq that is furnished with QGIS.
>
>
Sorry I was somehow thinking that by using a different PostgreSQL
installation "in its entirety" you could avoid using the libqq.dll (or is
it libpq.dll) that QGIS installs.  I guess I'm too used to (spoiled by?)
apt based installations on Linux where applications tend to use what's in
the distro's repositories for this kind of stuff.

My apologies for contributing nothing useful to the solution of your
problem.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS for Windows with GSS/Kerberos/Active Directory

2023-02-03 Thread chris hermansen via QGIS-User
Tomas and list,

On Fri, Feb 3, 2023 at 8:11 AM Tomas Pospisek via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> When I try to set up a connection to a Postgres/Postgis DB server with
> Active Directory/Kerberos/GSS authentication the QGIS DB setup dialog
> displays this message:
>
>  gssencmode value "require" invalid when GSSAPI support is not
> compiled in
>
> When I check the Postgres source code [1] I see that apparently this
> gets displayed when GSS support is not compiled in.
>
> So it seems QGIS as shipped by qgis.org does not ship with GSS support?
> Is that correct?
>
> Does anybody use QGIS on Windows with GSS? How did you do it?
>
> I could go ahead and download the EDB Postgres ZIP [3] and exctract
> libpq.dll from it and replace the libqq.dll shipped by the QGIS
> installer with it, but I'm not sure if that would work at all, if that
> would be robust and it'll certainly be a pain to maintain.
>
> Any pointers/suggestions/help?
>

Maybe this is the proverbial dumb question... but why not install your EDB
PostgreSQL on your windows machine and run it on a different port?  And
then connect to it from your QGIS instance, on that different port of
course?


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] What QGIS plugin development should I work on this year?

2023-01-27 Thread chris hermansen via QGIS-User
top posting sorry

Can we possibly have too much integration between QGIS and D3?  maybe
convert QGIS project to D3 JavaScript?  Oooh.

On Thu, Jan 26, 2023 at 7:37 AM C Hamilton via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi QGIS users,
>
> I am looking for ideas for what QGIS development I should be working on
> this year. My plugin development over the years has focused on capabilities
> that were missing at the time or algorithms that made QGIS user's lives
> easier. Here are the plugins I've developed so far.
>
> https://plugins.qgis.org/plugins/author/C%2520Hamilton/
>
> I am interested in algorithms that may be in commercial software but not
> in QGIS that people need. I am also interested in different ways to
> visualize and analyze data. Last year I released the Density Analysis
> plugin . It added
> additional density analysis algorithms including a fast H3 histogram of an
> area. I never got any feedback on the plugin so I don't know whether it is
> useful or not to users, but it has had 11,608 downloads since last June. I
> always appreciate feedback as it is what encourages me to continue
> development.
>
> I have been debating on updating the D3 Data Visualization plugin
>  to use plotly to create the
> graph and perhaps add additional graphs. That was one of my early plugins
> where I created my own D3 graph of the data. It could probably be done
> better.
>
> Are there any algorithms that you would like to have developed? It may be
> that QGIS is getting sufficiently advanced that there is not much that is
> really needed any more, but if you have any ideas I would appreciate them.
> Anything I work on needs to benefit a sizable number of users. It can't be
> too specific. It also needs to be constrained enough that I can complete in
> a reasonable amount of time.
>
> If you have any ideas for improving my existing plugins that could be an
> option as well.
>
> By the way is there a better forum than this qgis-user group to reach out
> to QGIS users or is this the best way?
>
> Thanks for your input!
>
> Calvin
> ___
> 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
>


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Looking for application/server etc

2023-01-12 Thread chris hermansen via QGIS-User
Dennis and list;

On Thu, Jan 12, 2023 at 8:45 AM Dennis Burgess via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> But looking to only display what is on the customer screen.  We should
> never get the 50 meg poly..
>
> 
> *Subject:* RE: Looking for application/server etc
>
> [stuff deleted]

>
>
> PostGIS with Geometry Index’s?!
>
> Set up Styles with Zoom Levels so as when zoomed in to 1:5000, that’s the
> only time you have full LOD
>


> [stuff deleted]
>
> 
>


> *From:* QGIS-User  *On Behalf Of *Dennis
> Burgess via QGIS-User
> *Sent:* 12 January 2023 15:43
> *To:* qgis-user@lists.osgeo.org
> *Subject:* [Qgis-user] Looking for application/server etc
>
>
>
> Looking for something that can take a HUGE, say a 50-75 meg mutli-polygon
> (multi-state etc.), that has detail level down to 1meter, then parse it and
> display it within 1meg on top of mapping systems in a web browser ?
> Options?  Not to mention, we have a few thousand of these so we need to be
> able to call the mapping for any one of them.   We also need it to simplify
> it i.e. maybe deliver a max a 1 meg to the customer..  if they zoom out we
> want to make it simpler to deliver something to the customer..  I’m sure
> there is a way of doing this..
>
>
>
> I’m sure there is an application, server, something that can do this
> automatically..
>
>
>
Dennis, do you mean your object of interest is a MULTIPOLYGON?  Because if
so, your bounding box, and therefore your spatial index, is going to bound
the entire polygon, and that's going to limit any kind of efficiency as you
zoom in.

You might consider splitting your MULTIPOLYGON into POLYGONs.  That way
each POLYGON will have its own bounding box and therefore your spatial
indexing scheme will have the chance to be more efficient.  But of course
you have to watch out for polygons like the Mississippi River.

This article might help
https://www.alibabacloud.com/blog/postgresql-how-to-optimize-spatial-index-based-query-performance-for-multipolygon-data_597324

I agree with Richard; PostGIS provides nice geometry indexing.  Probably
other database managers do as well.

I'm not certain that I follow what you are doing precisely, but one kind of
architecture would be to have your database within PostgreSQL / PostGIS,
being accessed by QGIS server and delivered to your clients that way.

The QGIS server guide is here
https://docs.qgis.org/3.22/en/docs/server_manual/index.html

The PostGIS manual is here https://postgis.net/documentation/

There are many, many resources available to learn PostGIS.  From personal
experience I know this is a good one
https://www.manning.com/books/postgis-in-action-third-edition

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Qgis 3.28 : Relational value form (spatial intersection)

2022-12-13 Thread chris hermansen via QGIS-User
Laurent and list,

On Tue, Dec 13, 2022 at 6:29 AM celati Laurent via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Good morning,
> With qgis 3.28 I have a point layer (boreholes) . And I have a polygonal
> layer (departments/districts). My goal would be to via Qgis (right click
> boreholes point layer -> attributes form) to automatically fill the
> "department" field of the boreholes layer. The filling would be done via
> spatial intersection. The field of the departments table that I would like
> to retrieve is called "nom_dep". I am attaching a screenshot of my settings.
>
> Not to dispute this approach, but why not use

Vector > Geoprocessing Tools > Intersection

or

Vector > Data Management Tools > Join Attributes by Location

to put the polygon department attribute on the points?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] ogr2ogr doesn't connect to MS SQL Server

2022-10-20 Thread chris hermansen via Qgis-user
Michael and list,

I don't use Microsoft SQL Server, so not speaking from experience here but
this doesn't help?

https://gdal.org/drivers/vector/mssqlspatial.html

On Thu, Oct 20, 2022 at 1:40 AM Reetz, Michael (NLPV) via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello all,
>
>
>
> it seems that nobody has an idea. I’ve found some tips (some of them
> really old) to install the latest ODBC-Driver from Microsoft or the SQL
> Server Native Client. First is installed, second is not supported in SQL
> Server 2019. Another tip was to rename or delete ogr_MSSPATIAL.dll but this
> dll isn’t installed on my system (obviously not part of the QGIS
> installation package).
>
>
>
> So, it looks as if ogr2ogr is not really helpful for me and I have to look
> for another tool.
>
>
>
> Best regard
>
> Michael
>
>
>
> *Von:* Qgis-user  *Im Auftrag von *Reetz,
> Michael (NLPV) via Qgis-user
> *Gesendet:* Mittwoch, 19. Oktober 2022 12:50
> *An:* qgis-user@lists.osgeo.org
> *Betreff:* [Qgis-user] ogr2ogr doesn't connect to MS SQL Server
>
>
>
> ACHTUNG!! Diese E-Mail erreicht Sie von einem Absender außerhalb der
> niedersächsischen Landesverwaltungs-Infrastruktur mit TLS-Verschlüsselung.
> Bitte klicken Sie auf keine Links oder öffnen Sie keine E-Mail-Anhänge,
> falls Sie den Absender nicht kennen und nicht wissen, ob der Inhalt sicher
> ist.
>
> Dear QGIS users,
>
>
>
> we are using MS SQL Server 2019 as basis for Geoserver and GIS software.
> There are a lot of tables that have attributes of the types geometry and/or
> geography. I can load these tables into QGIS (3.22.8) projects without any
> problems.
>
>
>
> Now I’m asked to add an geography attribute to one table that has already
> an geometry attribute and populate it with coordinates by transforming the
> geometry values. I’ve found code how to do this with ogr2ogr but when I run
> it I receive the error message “Unable to open datasource ‘MSSQL:server= server IP>;database=;trusted_connection=yes;' with the
> following drivers”. MSSQLSpatial is not listed but should be part of the
> ODBC driver. Any idea? Which driver QGIS is using?
>
>
>
> Best regards
>
>
>
> Michael
>
>
>
>
>
>
>
> *
>
> Michael Reetz
>
> Datenbanken und Anwendungsentwicklung
> Nationalpark-Verwaltung Niedersächsisches Wattenmeer
> Virchowstr. 1 | 26382 Wilhelmshaven
> Tel.: +49 (0) 4421 911 291
> e-mail: michael.re...@nlpvw.niedersachsen.de
> 
> Web: https://www.*nationalpark-wattenmeer.de
> *
>
>
> ___
> 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
>


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Opening ECW files in QGIS 3.22, Ubuntu 20

2022-09-26 Thread chris hermansen via Qgis-user
Rosa and list;

On Mon, Sep 26, 2022 at 9:17 AM Micha Silver via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> I think you made the right decision. Compiling gdal means recompiling most
> of the spatial applications on your computer. That's is a very deep rabbit
> hole that you want to avoid if possible.
>
>
> Unfortunately, for reasons that were explained some years ago on the list,
> ecw support is built into the Windows binaries, but not for Linux. So for
> Linux users there are only 2 options: either get the data in an open
> format, or fire up a windows VM and install the OSGeo4W version of QGIS and
> gdal just for converting the ecw files to something else.
>

Rosa, you may wish to try the supposedly free ECW → TIFF online converter
at anyconv.com

I have no personal experience with this tool nor relationship to the
providers etc etc.

>
>
> On 26/09/2022 14:31, Rosa Lago via Qgis-user wrote:
>
> Thank you all
>
> I am trying to obtain supported format (I have already installed gdal used
> by QGIS, and do not want to have problems later if we change the gdal's
> installation).
>
> Regards
>
> Rosa.
>
>
> [stuff deleted]


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Width and Height Attribute not in Meters

2022-09-16 Thread chris hermansen via Qgis-user
Jon and list,

On Fri, Sep 16, 2022 at 10:57 AM Jon via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello,
>
> After creating a Bounding box layer from my shape file, whether I
> iterate and get multiple Bounding Box layers or not use iterate and get
> one, is that in my 'Attribute Table' for the 'Bounding boxes' layer
> that is produced adds the Width and Height to the Attribute Table but
> the numbers inside are not what I expect:
>
> Width   Height
> 0.0412408   0.0457415
>
> I expect these to be in meters due to changing the Coordinate Reference
> System (CRS) to one that has meters at its Units under the properties.
> But when changing the CRS I still see the same data. I have checked the
> actual distance of the polygons and they are positive numbers, I should
> not see decimals.
>

You should expect these to be in the units of the source data.

If you want them to be in some other CRS then you should either reproject
the input layer before you calculate the bounding box(es), or reproject the
output layer you already have and maybe recalculate the width and height
attributes.

>
> I change the CRS by clicking the globe in the bottom right of the QGIS
> GUI and also by right-clicking the layer and selecting 'Layer CRS' and
> setting it there as well, still same issue.
>
> Changing the project CRS usually doesn't affect the results of
computations.  It's just the display / reprojection on the fly.

Changing the layer CRS doesn't cause the data to be reprojected.

Use the Vector > Data Management Tools > Reproject layer menu item instead.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Model for Temporal Measurement (vector) Datasets ?

2022-09-02 Thread chris hermansen via Qgis-user
Richard and list,

On Fri, Sep 2, 2022 at 4:07 AM Richard Duivenvoorde via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi All,
>
> Anybody is aware of a model in which data owns a location, but THAT
> location has a (growing) set of [timestamp, value] observation data to
> it
>
> We've done this but clumsily by duplicating the spatial data, one for each
point (ie a one-to-many join).

Also with start-datetime and end-datetime which is even uglier - the
overlap of datetime of occurrence vs datetime of display is really ugly,
especially when you're trying to visually display "point of ignition",
"bloom", "fading away" if you get my meaning.  A sort of heat map but
automated.

Anyway, as may be obvious from the above I'm also very interested.  Years
ago in the IJGIS there was an article about design of spatial databases
with time measures, but sad to say all my IJGIS issues have long since been
recycled.

Maybe someone is doing this in d3.js?  Seems like a logical framework for
this sort of thing...


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Tectonic plate boundaries

2022-08-19 Thread chris hermansen via Qgis-user
John and list,

On Fri, Aug 19, 2022 at 2:45 AM John Moyle via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Thank you one and all with helpful suggestions about finding a shape file
> of tectonic plate boundaries.
> Having tried several of them, QGIS accepts them and allows me to set
> colour type and thickness of line etc but even if they are the only layer
> selected I am unable to *see *them.
>

This might be a problem with your coordinate reference systems (CRS) for
the two layers and the project.  Maybe one layer or the other doesn't
correctly specify a CRS?

If you click on Help on the main menu, which pops up the documentation for
the version you are using in your browser, you can go to the section on
"Working with Projections" (it's § 10 in my QGIS version).  There you will
find a gentle explanaton of the topic and how to problem-solve when
something goes wrong.

If this doesn't help come back for more.


> I must be doing something wrong!
> Maybe it's "old dogs and new tricks" at 77 to learn QGIS. The problem is
> that this is probably the only time I will ever be using a GIS and all the
> courses available want to teach so much general GIS before the little bits
> that I need to learn!!  I have my base raster file of the North Atlantic
> and have learned enough to make individual layers of cable interruptions,
> sub-sea volcanoes and land-slides etc. but have come unstuck at an *imported
> *shape file!
>
> Take heart, sounds like you've done all the hard stuff!


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Event loop in QGIS3

2022-08-16 Thread chris hermansen via Qgis-user
Marian and list,

On Tue, Aug 16, 2022 at 12:02 PM Tudorache, Marian via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello community,
>
>
>
> A while ago I sent a question about a problem with QMessageBox and message
> bar does not get updated during a long process.
>
> In my example I create a script like this.
>
>
>
> from qgis.PyQt import QtWidgets
>
> message = "Wait to open the airspace project..."
>
> msg = QtWidgets.QMessageBox()
>
> msg.setText(message)
>
> msg.show()
>
> qgis.utils.iface.messageBar().pushMessage("Wait", message)
>
>
>
>
>
> for i in range(1000):
>
> print(i)
>
> qgis.utils.iface.messageBar().pushMessage("Done", "The process is done")
>
> msg.setText("The process is done")
>
> msg.show()
>
> qgis.utils.iface.messageBar().pushMessage("Done", "The process is done"))
>
>
>
>
>
> When I run the scrip in QGIS 2.18 the QMessageBox displays first the
> message "Wait to open the airspace project...". The same message is pushed
> to messageBar.
>
> Then during the loop it displays the variable i.
>
> At the end of the loop the QMessageBox displays the message "The process
> is done" which is also pushed to the messageBar.
>
>
>
> When I run the same scrip on QGIS 3 the QMessageBox is empty. The message
> "Wait to open the airspace project..." is not displayed by QMessageBox nor
> by messageBar.
>
> The print inside the loop displays the I and when the loop is done the
> QMessageBox displays the message "The process is done".
>
> The messageBar displays also the message "The process is done". And after
> a while it displays the initial message "Wait to open the airspace
> project..."
>
>
>
> I modified the scrip by adding QApplication.processEvents() inside the
> loop and now everything is fine.
>
> It seems QGIS3 no longer triggers this event loop and I have to do this
> explicitly by calling processEvents from QApplication.
>
>
>
> *Why QGIS 3 needs to call QApplication.processEvents() and QGIS 2 does not
> need?*
>
>
>

Marian, did you read this article?

https://doc.qt.io/qt-5/qcoreapplication.html#details

There you will see this:

The event loop is started with a call to exec
> (). Long-running
> operations can call processEvents
> () to keep
> the application responsive.
>

In your case, your "long-running operation" is your for loop.  And it is
not QGIS3 that has the responsibility to trigger processEvents() but your
own long-running operation, at least the way I'm reading this.

As to why QGIS 2 did not need this, I don't know.

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Tectonic plate boundaries

2022-08-13 Thread chris hermansen via Qgis-user
John and list,

On Sat, Aug 13, 2022, 09:38 John Moyle via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi
> New to QGIS. I want to plot Victorian submarine telegraph cable
> interruptions under the Atlantic.  I know, what an Anorak!!
> I have found a brilliant rasterfile of the seabed from GEBCO to use as a
> base layer. I have also collected all the data of cable failure, submarine
> earthquakes and volcanoes and am ready to make vector layers of all the
> data.
> But what I can't find is a shapefile of the tectonic plates boundaries,
> just the boundary lines with no shading or text.
>

I believe you have a basic misunderstanding of the nature of data within a
GIS.

Generally the way QGIS (and most GIS) works is they "take" only data such
as points lines and polygons and then the user develops styling on those to
create the desire cartographic effect.

It would be most unusual to find shading or text in a shapefile.

Test in a shapefile is an attribute of some geometric feature. So line 377
might have an attribute that is "Mid Atlantic Ridge".

QGIS provides the ability to print the text attributes as labels, which can
be styled in many useful ways for visualization purposes.


Everything I do find is rejected by QGIS as not being in a suitable format.
> Help please!
> John
>
> Dr John Moyle
> MB, BS, MSc, PhD, CEng, MInstMC, FRCA, FRHistS
> Chartered Engineer
> Physician & Anaesthetist (Retired)
> Historian (Telegraphy & Medical Technology)
>
> Home +44(0)1608 665968
> Cell +44(0)7836 244584
>
> Amberley
> Cotswold Close
> Tredington
> Shipston on Stour
> Warwickshire
> CV36 4NR, UK
>
> "A person has nothing to lose if he believes in God and in the end he
> turns out to be wrong but everything to lose if he wagers that God does not
> exist and it turns out in the end that He really does." - Blaise Pascal
> (C17th French Scientist & Mathematician)
> ___
> 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] QGIS and geopackages in sharepoint environement

2022-08-05 Thread chris hermansen via Qgis-user
Oops I spoke to soon, please see below...

On Fri, Aug 5, 2022 at 2:27 PM chris hermansen 
wrote:

> Sebastian and list,
>
> On Fri, Aug 5, 2022 at 2:19 PM Sebastian Gutwein  wrote:
>
>> Although it is not recommended we use google drive and as of the latest
>> release it works ok for most files including Geopackage. In past versions
>> any time a layer on a geopackage was opened this would cause the file to be
>> marked as changed and upload the whole file. In the current version (3.26)
>> this only happens when edit mode is turned on. However saving after edits
>> is much slower when it is in the Google drive. It appears that the .wal
>> file decides to load the entire file into itself when in the google drive
>> before writing the change to the file.  Of course this doesn't prevent
>> people from overwriting each other's changes if two people are concurrently
>> editing on different machines.
>> The file path doesn't seem to be a problem if the files are in the same
>> location relative to the project file on different machines.
>> I would be interested if at some point someone created a solution that
>> allowed for diffs on geopackages using Lutra's
>> https://github.com/MerginMaps/geodiff . I imagine if that worked there
>> would be an cloud unsynced local version and a cloud synced local version
>> that you could trigger a diff operation against.
>>
>
> The problem with Google Drive is actually a problem with Google Drive for
> Desktop, which is a "file streaming application" and not with the other
> approach which is synchronization, similar to Dropbox.  In the
> synchronization approach your changed files on your computer are backed up
> to the cloud Google Drive.
>
> Google Drive for Desktop is a plugin for Windows Navigator that makes
> files in Google Drive appear as though they are on your computer in the G:
> drive (or wherever else you might set it up).  If you double-click on one
> of those files, say foo.docx, then that file will open in Word.  But if you
> use QGIS to add a layer, the file names that appear in the  "Open OGR
> Vector Layer" window (for example) don't look like what you might expect.
>
> *Note I just tried this on Ubuntu 22.04 with QGIS 3.26.1 and WHOOPS it
> looks to be working here, so maybe it's not an issue in Windows any longer
> either.*
>
>>
> I was wrong there.

Things look good until I picked a .shp file to show; the file name that
came up was a great long thing with lots of x's and y's and what not and
QGIS would not open it.

Anyway this is Ubuntu not Windows so YMMV.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS and geopackages in sharepoint environement

2022-08-05 Thread chris hermansen via Qgis-user
Sebastian and list,

On Fri, Aug 5, 2022 at 2:19 PM Sebastian Gutwein  wrote:

> Although it is not recommended we use google drive and as of the latest
> release it works ok for most files including Geopackage. In past versions
> any time a layer on a geopackage was opened this would cause the file to be
> marked as changed and upload the whole file. In the current version (3.26)
> this only happens when edit mode is turned on. However saving after edits
> is much slower when it is in the Google drive. It appears that the .wal
> file decides to load the entire file into itself when in the google drive
> before writing the change to the file.  Of course this doesn't prevent
> people from overwriting each other's changes if two people are concurrently
> editing on different machines.
> The file path doesn't seem to be a problem if the files are in the same
> location relative to the project file on different machines.
> I would be interested if at some point someone created a solution that
> allowed for diffs on geopackages using Lutra's
> https://github.com/MerginMaps/geodiff . I imagine if that worked there
> would be an cloud unsynced local version and a cloud synced local version
> that you could trigger a diff operation against.
>

The problem with Google Drive is actually a problem with Google Drive for
Desktop, which is a "file streaming application" and not with the other
approach which is synchronization, similar to Dropbox.  In the
synchronization approach your changed files on your computer are backed up
to the cloud Google Drive.

Google Drive for Desktop is a plugin for Windows Navigator that makes files
in Google Drive appear as though they are on your computer in the G: drive
(or wherever else you might set it up).  If you double-click on one of
those files, say foo.docx, then that file will open in Word.  But if you
use QGIS to add a layer, the file names that appear in the  "Open OGR
Vector Layer" window (for example) don't look like what you might expect.

*Note I just tried this on Ubuntu 22.04 with QGIS 3.26.1 and WHOOPS it
looks to be working here, so maybe it's not an issue in Windows any longer
either.*

>

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] QGIS and geopackages in sharepoint environement

2022-08-05 Thread chris hermansen via Qgis-user
Guido and list,

On Fri, Aug 5, 2022 at 6:35 AM Guido Häfliger via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello
>
>
>
> We are discussing in our company to switch from local fileserver/NAS to
> Sharepoint (hosted in cloud). Will QGIS-projects and geopackages work on
> sharepoint environment or do we have to expect a lot of troubles? Have
> anybody experience with QGIS and geopackages on sharepoint? Will we
> encounter problems if geopackages are opened by several users?
>
>
I can't speak to the use of QGIS with Sharepoint, but we've tried using
both QGIS and ESRI products with Google Drive for Desktop and the name
remapping done by GDD in Windows Explorer is not picked up by the file
manager component used by them; so the file names do not appear as expected.

I've run across the same thing with QGIS and the Google Drive - Nautilus
connection in GNOME / Linux and not found a solution.

I suggest you try before you buy.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] excessive threads?

2022-07-30 Thread chris hermansen via Qgis-user
Mike and list,

Mike, would you please explain why the surface area would be related to the
number of threads?

1000 square miles or ~ 250.000 hectares in my units is big but not huge. We
have a 7 million hectare vegetation inventory we're updating now.

Do you have a bunch of small tiles? Are you thinking that 1 tile = 1 thread?

On Sat, Jul 30, 2022, 12:46 Mike Stanton  wrote:

> Chris, it really depends on how large your project is. Some of my projects
> cover 1000 sq miles.  Usually I don’t use QGIS directly for that, I break
> it down to smaller pieces.
>
>
>
> *From:* Qgis-user  * On Behalf Of *chris
> hermansen via Qgis-user
> *Sent:* Saturday, July 30, 2022 2:37 PM
> *To:* Greg Troxel 
> *Cc:* qgis-user 
> *Subject:* Re: [Qgis-user] excessive threads?
>
>
>
> Greg and list
>
>
>
> On Sat, Jul 30, 2022 at 10:38 AM Greg Troxel via Qgis-user <
> qgis-user@lists.osgeo.org> wrote:
>
>
> (I realize excessive is relative.  Back when I was young, we didn't have
> any threads at all)
>
> My desktop is NetBSD 9, I ran out of threads, and found that qgis 3.22.8
> was using 157 threads, much more than I expected.
>
>
>
> [stuff deleted]
>
>
> I really don't understand:
>
>   What is qgis using threads for?
>
>   Do others see large (100 or so, vs 10) thread counts?
>
>   Why are there 157 (really, why are there more than about 10-20)?
>
> Seems kind of surprising to me as well.  I get that some applications
> could benefit by parallel execution, and of course separating rendering
> from file or other I/O seems reasonable, but 157 is a lot of threads for
> just reading data and visualizing it.
>
>
>
> As far as I know, PostgreSQL doesn't even use threads.  See for example
> this discussion
> https://dba.stackexchange.com/questions/251935/number-of-worker-threads-available-in-postgresql
>
>
>
> About SQLite I have no idea.
>
>
>
> Does it seem like you have one thread per layer for reading plus one for
> rendering plus one for user  input?
>
>
>
> --
>
> Chris Hermansen · clhermansen "at" gmail "dot" com
>
> C'est ma façon de parler.
>
___
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] excessive threads?

2022-07-30 Thread chris hermansen via Qgis-user
Greg and list

On Sat, Jul 30, 2022 at 10:38 AM Greg Troxel via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

>
> (I realize excessive is relative.  Back when I was young, we didn't have
> any threads at all)
>
> My desktop is NetBSD 9, I ran out of threads, and found that qgis 3.22.8
> was using 157 threads, much more than I expected.
>

[stuff deleted]

>
> I really don't understand:
>
>   What is qgis using threads for?
>
>   Do others see large (100 or so, vs 10) thread counts?
>
>   Why are there 157 (really, why are there more than about 10-20)?
>
> Seems kind of surprising to me as well.  I get that some applications
could benefit by parallel execution, and of course separating rendering
from file or other I/O seems reasonable, but 157 is a lot of threads for
just reading data and visualizing it.

As far as I know, PostgreSQL doesn't even use threads.  See for example
this discussion
https://dba.stackexchange.com/questions/251935/number-of-worker-threads-available-in-postgresql

About SQLite I have no idea.

Does it seem like you have one thread per layer for reading plus one for
rendering plus one for user  input?


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Convert huge shapefile to small size

2022-07-28 Thread chris hermansen via Qgis-user
Scott and list,

With respect I think this conversation is moving off the point, which was
related to a 5gb shapefile

https://en.m.wikipedia.org/wiki/Shapefile

Which is beyond the design limits of the Shapefile standards and perhaps
therefore the source of the problem that the OP has.

Notably not a limitation of QGIS

On Thu, Jul 28, 2022, 10:45 Madry, Scott via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Dear colleagues,
>
> As we move more into the world of big data, IOE, data mining, and data
> analytics, dealing with larger and larger data sets will become required,
> and, eventually, the norm.
>
> GRASS GIS has made very good progress in this regard, optimizing the code
> to run on massively parallel computer architectures, with very good effect:
>
> https://grasswiki.osgeo.org/wiki/Supercomputing
>
> Perhaps it is time for QGIS to consider this in its future development
> plans? We will certainly be needing this in the future.
>
> And thanks to all the team who keep the QGIS train running, I am
> constantly amazed at the energy, effort, and availability of people to the
> broader community.
>
> Scott
>
> Scott Madry, Ph.D.
> Research Associate Professor of Archaeology
> The University of North Carolina at Chapel Hill
>
> Tel 1-919-448-4493
> Email:mad...@email.unc.edu 
> https://scottmadry.web.unc.edu
> Skype:   scott madry
>
>
>
> On Jul 28, 2022, at 10:14 AM, jhubbslist--- via Qgis-user <
> qgis-user@lists.osgeo.org> wrote:
>
> Past a point, trying to run a GIS app with very large data structures just
> doesn't work well. If you really need all the information you're carrying
> around for your analysis or whatever, you may need to reach for different
> tools or use the tools you have differently.
>
> I assume it's not so much the >5GiB of disk space that's the issue and
> that you've maxxed out the CPU, graphics, and disk I/O rate as much as is
> practical so mostly it's a matter of how long it takes maps etc. to paint
> onscreen. It may help you to move the heavy-lift onto PostgreSQL/PostGIS
> where you can make use of spatial indexing. Or, you can craft your
> operations the way you want them in QGIS but do the actual work with e.g.
> GDAL calls in Python. I spoke with someone a couple weeks ago whose
> particular GIS process worked better in GRASS than in QGIS, so that's
> something you might look into as well.
>
> On 7/28/22 7:52 AM, krishna Ayyala via Qgis-user wrote:
>
> dbf file itself is 5.1GB. Rest all other files are less than 500MB. It is
> the number of records which is huge. It has about 117,2100 points.
>
> On Thu, Jul 28, 2022 at 12:02 AM Bernd Vogelgesang via Qgis-user <
> qgis-user@lists.osgeo.org> wrote:
>
>> how big is the dbf file of that shape? Maybe you can also drop some
>> attributes.
>>
>> Am 28.07.22 um 03:46 schrieb krishna Ayyala via Qgis-user:
>> > Hello,
>> > I have a shapefile of 5GB in size. Is it possible to convert this
>> > shapefile to a smaller size file? It can be any format, not
>> > necessarily a shapefile. But, preferably a vector format. I tried to
>> > convert it into tiles, but that didn't work as it was losing the
>> > resolution. I am looking to convert this 5GB size file to about 500MB.
>> >
>> > Regards.
>> >
>> > ___
>> > 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 listqgis-u...@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] (no subject)

2022-07-16 Thread chris hermansen via Qgis-user
Takunda Chitambura and list,

On Sat, Jul 16, 2022, 07:16 takunda chitambure via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Im trying to combine my csv file with my shapefile but the resultant
> attribute table is showing the joint attributes with null values what could
> be the problem
> __
>

Probably when you imported your . CSV you did not define the types of the
columns, especially the join column, so that the column in the .SHP is say
integer and the matching column is string.

If that's the case, you can either reimport your .CSV taking care to define
the types of the columns or you can add a new column of the appropriate
type (e.g. integer) and use the field calculator to convert the join column
into it, then redo the join on the new column.

Chris

>
___
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] Issues with dependencies for Ubuntu 22.04

2022-07-07 Thread chris hermansen via Qgis-user
Vicente and list,

On Thu, Jul 7, 2022 at 7:37 AM vicentesmith via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello,
> I'm trying to install QGIS  in a fresh Ubuntu 22.04 system. Before
> building QGIS, I'm installing the dependencies from
> https://github.com/qgis/QGIS/blob/master/INSTALL.md#33-install-build-dependencies
> for jammy. At some point during the process, the system asked which
> services to restart so I left the default ones (packagekit, palkit,
> rsyslog, ssh, systemd-journal, systemd-manager, systemd-networkd,
> systemd-resolved). Everything seemed OK at the end but rebooting the system
> froze everything and I cannot even log in.
> NOTE: I also tried using apt to install QGIS directly. This time, there
> was no problem but it installed v3.22.4.
> Thanks.
>
> For what it's worth, I'm running QGIS 3.26.0 on Ubuntu 22.04 without
problems on two different machines.  On the one I'm working on now, I have
a file in /etc/apt/sources.list.d called
archive_uri-https_qgis_org_ubuntu-jammy.list with the line

deb [arch=amd64] https://qgis.org/ubuntu jammy main

in it.  I did not need to compile QGIS nor any other complicated thing.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Path along a line

2022-06-27 Thread chris hermansen via Qgis-user
Krishna and list

On Mon, Jun 27, 2022 at 9:58 AM krishna Ayyala via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello,
> I  have a roads shapefile.  I also have a points shape file with 5 points
> which are on top of these roads. I wish to extract the roads that are
> 1000ft along the path from each of these points. I am not looking for roads
> within 1000ft buffer. I am looking for roads along the path. Can anyone
> help me with this?
>

Have you looked at Processing > Service area (from point)?  Seems to me
this might do the job for you.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Dimensioning in QGIS

2022-06-24 Thread chris hermansen via Qgis-user
Nicolas, everyone,

Sorry to top post here but I'm not sure where to start below.

What about just using the various drawing tools on the print layout?
Arrows can be added, annotation, polylines, that sort of thing?  Of course
it's not in the original data / layers, but is that important?

On Fri, Jun 24, 2022 at 9:27 AM Nicolas Cadieux via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi,
>
> Qgis is not a CAD as you are discovering.  Others have given you good
> plugins and tools so I will not add to that.  You can still do “3D” as 3D
> objects like lines, points and polygon are supported.  You can use the 3D
> map windows to visualize the 3D objects and a DEM  raster or mesh layers.
> I too am an archaeologist.  In the past, I have used simple 3D WKT format
> in a text file to make 3D outlines of trenches and survey holes. Looks like
> some plugins can now do that for you now.  QGIS is not quite there as a
> full blown CAD but it’s as good as current Commercial GIS I have worked
> with.  Progress has been slow but steady.
>
> Nicolas Cadieux
> https://gitlab.com/njacadieux
>
> Le 24 juin 2022 à 08:03, Zoltán Siki via Qgis-user <
> qgis-user@lists.osgeo.org> a écrit :
>
> 
> you can solve it using Geometry Generator see:
> https://stuyts.xyz/2018/11/05/qgis-geometry-generator-examples-repository/
>
> Regards,
> Zoltan
>
>
> IainS via Qgis-user  ezt írta (időpont: 2022.
> jún. 23., Cs, 23:44):
>
>> Is there a tool for adding dimensions in QGIS. For those who are
>> wondering what I am talking about, it is common in CAD drafting to add
>> dimensions to what you have drawn and this is a whole part of a CAD program
>> where you can format dimensions …etc.
>>
>>
>>
>> I have been asked to add dimensions to an archaeological hole I am
>> digging on a QGIS map and I was wondering whether there is a similar
>> dimensioning tool in QGIS.
>>
>>
>>
>> Cheers
>>
>>
>>
>> *Dr Iain Stuart*
>>
>> *JCIS Consultants *
>>
>> P.O. Box 2397
>>
>> Burwood North
>>
>> NSW, 2134
>>
>>
>>
>> (02) 9701 0191
>> (0413) 380116 (m)
>>
>>
>> ___
>> 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
>>
>
>
> --
> Üdv.
> Siki Zoltán
> ___
> 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
>


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Symbology

2022-06-18 Thread chris hermansen via Qgis-user
If your layer is a CSV file, do you not first need to convert it to a
spatial form, for example a shapefile?

In case I misunderstand, if it came from a CSV file, then as Barend
suggests, maybe the type of the column is incorrect.  You can use a CSVT
file to define column types prior to conversion; alternatively you can add
a new column of type integer for example, and convert the string value to
integer.

On Fri, Jun 17, 2022 at 11:13 PM Allan Younger 
wrote:

> csv file
>
> -- Original Message --
> From "Kobben, Barend (UT-ITC)" 
> To "chris hermansen" ; "Allan Younger" <
> ahyoun...@iinet.net.au>
> Cc "QGIS User" 
> Date 18/06/2022 12:32:07 PM
> Subject Re: [Qgis-user] Symbology
>
> Usually this happens if you have numbers (quantitatvie data) that are
> stored in your file/db as Strings (text)
>
>
>
> *-- *
>
> *Barend Köbben*
>
>
>
>
>
> On 18/06/2022, 04:25, "Qgis-user on behalf of chris hermansen via
> Qgis-user"  Qgis-user@lists.osgeo.org> wrote:
>
>
>
> Allan and list,
>
>
>
> On Fri, Jun 17, 2022 at 7:00 PM Allan Younger via Qgis-user <
> qgis-user@lists.osgeo.org> wrote:
>
> Hi,
>
> I'm trying to show assay results as simple dot plots as graduated colour
> and size scaled points based on a selected element.
>
> Problem is that in the layer properties/symbology tab, I cannot select
> anything.
>
> Had the problem in Madeira 3.4 & assumed was just a glitch that had
> developed in that copy over time.
>
> Installed 3.22.7, same problem.
>
> Csv file has 162000 records & 30 column with co-ords for every point; with
> locations plotting a-ok.
>
>
> At the top of the Layer Properties > Symbology dialogue window, have you
> selected one of the options other than "No Symbols"?  For example,
> "Graduated"?
>
>
>
> Then in the field Value one of your layer's attributes?
>
>
>
> Then pressed the "Classify" button?
>
>
> --
>
> Chris Hermansen · clhermansen "at" gmail "dot" com
>
> C'est ma façon de parler.
>
>

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Symbology

2022-06-17 Thread chris hermansen via Qgis-user
Allan and list,

On Fri, Jun 17, 2022 at 7:00 PM Allan Younger via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi,
> I'm trying to show assay results as simple dot plots as graduated colour
> and size scaled points based on a selected element.
> Problem is that in the layer properties/symbology tab, I cannot select
> anything.
> Had the problem in Madeira 3.4 & assumed was just a glitch that had
> developed in that copy over time.
> Installed 3.22.7, same problem.
> Csv file has 162000 records & 30 column with co-ords for every point; with
> locations plotting a-ok.
>
> At the top of the Layer Properties > Symbology dialogue window, have you
selected one of the options other than "No Symbols"?  For example,
"Graduated"?

Then in the field Value one of your layer's attributes?

Then pressed the "Classify" button?

-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] most efficient way to digitize polygons

2022-06-16 Thread chris hermansen via Qgis-user
Byron and list,

On Thu, Jun 16, 2022 at 8:26 AM Firstname Lastname via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> i am a qgis newby and i am beginning a large project that involves
> digitizing several geology maps.  i am trying to determine the best way to
> manage the digitizing and avoid extra work.
> my question to the group is:  If i have several coloured polygons that are
> adjacent to each other, is there an efficient way to digitize one polygon
> and then use one edge of that polygon for the adjacent polygon so that i
> dont have to redigitize the same edge twice and so that i will have
> precisely overrlapping polys with no gaps?  should i digitize one polygon,
> export and rename it?  can i digitize one have of the next polygon and
> somehow merge it with the now re-imported polygon?
> is there a more efficient way to do this?
>
> You may wish to read one or more of the available tutorials on the topic
of digitizing in QGIS.

For example, this one:

https://www.qgistutorials.com/en/docs/3/digitizing_basics.html

where you would pay particular attention to steps 22 through 26 where
snapping new polygons to existing ones is demonstrated.


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Sync / Reconcile Data in Postgres

2022-06-07 Thread chris hermansen via Qgis-user
Andrew and list,

On Tue, Jun 7, 2022, 13:28 Andrew Hughes  wrote:

> Thanks Chris.
>
> Looks like that's for schema changes, and I need data changes. But thanks
> all the same.
>

Pretty sure the example shows some data changes as well...
___
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] Sync / Reconcile Data in Postgres

2022-06-07 Thread chris hermansen via Qgis-user
Andrew and list,

On Tue, Jun 7, 2022, 05:30 Andrew Hughes via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi All,
>
> I have several third-party living datasets (accessible via web services)
> that I need to replicate to an internal postgres instance (ETL processes).
>
> My question is, given my script/model has obtained a copy of the dataset.
> What would you recommend I use to synchronize the new/freshly downloaded
> data with the older data in the postgres database? In other words, how do I
> sync/reconcile the database.
>

Have you considered this tool

https://michaelsogos.github.io/pg-diff/

I have no experience with it but it seems like it could do the job.

Chris

>
>
___
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] website opens in various languages, not in browsers default language

2022-05-21 Thread chris hermansen via Qgis-user
Hernán and list,

On Sat, May 21, 2022, 12:16 Hernán De Angelis via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> In my desktop computer, opening "https://www.qgis.org;
>  the website renders in Russian and the address is
> shown as "https://www.qgis.org/ru/site/; .
> I am not in Russia and the browser (Firefox 100.0) and OS are set to
> English. Cleaned cache and history but the behavior is the same. In a
> smartphone, also using Firefox, the website opens in Danish. I am not in
> Denmark and the browser language is set to English too. What's going on?
>

I just tried from my Android 12 phone and it opened in English - what I
expected.
___
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] again: Create Geospatial PDF producing faulty output

2022-03-22 Thread chris hermansen via Qgis-user
Zoltan and list,

On Mon, Mar 21, 2022 at 1:17 PM Zoltan via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi Chris,
> I have not followed this thread in any detail, but as far as your labels
> comment below is concerned, depending on the output you choose, there will
> be slight changes in extents and scale, which could affect the labels
> becoming rendered or not.
> Maybe try playing with options that enforce displaying of all labels and
> then see if you labels still disappear?
>
> HTH,
> Zoltan
>
> On 2022-03-21 17:49, chris hermansen via Qgis-user wrote:
>
> Uwe and list,
>
> On Mon, Mar 21, 2022, 10:42 Uwe Fischer via Qgis-user <
> qgis-user@lists.osgeo.org> wrote:
>
>> Hello dear friends on the list,
>>
>>
>>
>> I’m sorry but I have to ask again about „Creating Geospatial PDF“ from
>> the 3.22 Print Composer:
>>
>> does nobody have problems like missing features in the PDF output? The
>> problem is very important for me, so any idea what the reason is would be
>> appreciated. Not a single answer until now.
>>
>>
>>
>> The problem description: some features (in my case line features) are
>> omitted when QGIS writes the geospatial PDF. Normal PDF output works fine,
>> as well as TIF image output. So the problem cannot be in the data.
>>
>>
>>
>> Please help!
>>
>
>
> No help I am afraid, but I do notice that labels appearing both on main
> screen and in print composer are sometimes dropped on export to image,
> whether from main screen or print composer.
>
> I have a simple demo in case anyone is interested. This is with latest
> version on Ubuntu.
>
>
>
Thanks for the response! I don't want to try to hijack  this conversation
so I'll start a new one.  But meanwhile I left my representative data on my
computer in Vancouver and now I'm not there...


-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] again: Create Geospatial PDF producing faulty output

2022-03-21 Thread chris hermansen via Qgis-user
Uwe and list,

On Mon, Mar 21, 2022, 10:42 Uwe Fischer via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello dear friends on the list,
>
>
>
> I’m sorry but I have to ask again about „Creating Geospatial PDF“ from the
> 3.22 Print Composer:
>
> does nobody have problems like missing features in the PDF output? The
> problem is very important for me, so any idea what the reason is would be
> appreciated. Not a single answer until now.
>
>
>
> The problem description: some features (in my case line features) are
> omitted when QGIS writes the geospatial PDF. Normal PDF output works fine,
> as well as TIF image output. So the problem cannot be in the data.
>
>
>
> Please help!
>


No help I am afraid, but I do notice that labels appearing both on main
screen and in print composer are sometimes dropped on export to image,
whether from main screen or print composer.

I have a simple demo in case anyone is interested. This is with latest
version on Ubuntu.

Chris

>
___
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] points to polygons conversion

2022-03-16 Thread chris hermansen via Qgis-user
Francesca and list,

On Wed, Mar 16, 2022, 03:06 Francesca Parente via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hello group,
>
> I'd have a question I hope it doesn't sound too nonsense to you: I'm
> working on a points shapefile, which I know has been created by centroids
> of polygons- but I don't have access to polygonal areas.
> I would need to select just those in some locations and recover their
> original area within polygonal borders.
>
> Is there a chance I can get it done by having this shapefile of centroids
> only?!
>

Polygon centroids aren't necessarily inside polygons, so selecting
centroids that fall within other areas doesn't mean the original polygons
would also lie within those areas.

Also if you are trying to determine the proportion of the original polygons
within the other areas (the intersections of the two sets) you must have
the original polygons.

I doubt that answers achieved with only the centroids would provide any
meaningful results.

Chris
___
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] Troubles with Join of two layers

2022-03-16 Thread chris hermansen via Qgis-user
Roland and list

On Wed, Mar 16, 2022, 01:20 Roland Spielhofer via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi,
> I am trying to join two layers using the DB Manager.
> One layer is a shape file, one is a pure attribute table without geometry.
> I have two fields that are identical in both layers, which should be used
> for the join.
>
> The SQL statement goes like this:
>
> SELECT *
> FROM 210914_Joined_Ebenheit as a,
> 20210914_sqlbatch_20220315_161846_erfassungsdaten as b
>  WHERE
> a.Filename = b.Filename AND
> b.frameNr = b.Frame;
>
> What I get is the following error message:
>
> Query execution error on CREATE TEMP VIEW _tview AS SELECT *  FROM
> 210914_Joined_Ebenheit as a,
> 20210914_sqlbatch_20220315_161846_erfassungsdaten as b  WHERE a.Filename =
> b.Filename AND b.frameNr = b.Frame: 1 - unrecognized token:
> "210914_Joined_Ebenheit"
>
> I don't get the meaning of "unrecognized token" - What I am doing wrong?
> I have "Load as new layer" ticked on - I want a new layer.
>
> Any help appreciated!
>
> Regards,
> Roland
>

Maybe try putting the 2019_Joined_Ebenheit in double quotes because it
begins with a non letter?

Chris
___
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] Archivo de texto a QGIS

2022-03-15 Thread chris hermansen via Qgis-user
Nicolás and list,

On Tue, Mar 15, 2022, 16:54 Nicolas Orellana via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> hola, una ayuda con la siguiente consulta:
> necesito lleva un archivo de texto con polilíneas de la siguiente
> estructura:
>

Nicolás, has revisado este how to, que explica el uso de CSV y linestrings?

https://gis.stackexchange.com/questions/287731/create-line-from-csv-coordinates#:~:text=Open%20QGIS%20and%20select%20the,and%20%22Lat%22%2C%20respectively

Te sirve? O necesitas más?

>
>
> ITEM;ID_Tramo_cable_óptico;Codigo_Tramo_cable_óptico;Cantidad_Fibras;Longitud_Estimada_Total;Columna1
> 1;259970;LANG ATP CAP 15 96 F.O. PKP;96;569,25;-72.3473131297419
> -37.4693619484954, -72.3472535235808 -37.469363950168, -72.3472616153805
> -37.4695764171866, -72.3472706302872 -37.4699298355154, -72.3472831573845
> -37.4702763430984, -72.3472901695875 -37.470366410894, -72.3471088478767
> -37.4703303839892
> 2;268863;LANG ATP CAP 15 32 F.O PKP;32;317,9;-72.3419967317581
> -37.4693365347936, -72.3418583028969 -37.4693147526957, -72.3418169714269
> -37.469275277813, -72.341675418789 -37.4692472316387, -72.3412370260197
> -37.4691627415692, -72.3407012104658 -37.4690533899232, -72.3406957666341
> -37.469049726257,
> 3;276549;LANG ATP-CAP14 256 F.O.;256;558,34;-72.3607871576207
> -37.4691957684416, -72.360780359542 -37.4692246441514, -72.3608072780816
> -37.4692281371511, -72.3616168271908 -37.4694057148484, -72.3616229393526
> -37.4694181824697, -72.3624055391924 -37.4695956598269, -72.3630246152763
> -37.469739721667
>
> a QGIS.
>
> de antemano muchas gracias.
>
> 
>
> Hello, help with the following query: I need a text file with lines of the
> following structure:
>
> ITEM;ID_Optical_cable_Span;Code_Optical_cable_Span;Amount_Fibers;Total_Estimated_Length;Column1
> 1;259970;LANG ATP CAP 15 96 F.O. PKP; 96; 569.25; -72.3473131297419
> -37.4693619484954, -72.3472535235808 -37.469363950168, -72.3472616153805
> -37.4695764171866, -72.3472706302872 -37.4699298355154, -72.3472831573845
> -37.4702763430984, -72.3472901695875 -37.470366410894, -72.3471088478767
> -37.4703303839892
> 2; 268,863; LANG ATP CAP 15 32 FO PKP; 32; 317.9; -72.3419967317581
> -37.4693365347936, -72.3418583028969 -37.4693147526957, -72.3418169714269
> -37.469275277813, -72.341675418789 -37.4692472316387, -72.3412370260197
> -37.4691627415692, -72.3407012104658 -37.4690533899232, -72.3406957666341
> -37.469049726257,
> 3; 276,549; LANG ATP-CAP14 FO 256; 256; 558.34; -72.3607871576207
> -37.4691957684416, -72.360780359542 -37.4692246441514, -72.3608072780816
> -37.4692281371511, -72.3616168271908 -37.4694057148484, -72.3616229393526
> -37.4694181824697, -72.3624055391924 -37.4695956598269, -72.3630246152763 -
> 37.469739721667
>
> to QGIS.
> Beforehand thank you very much.
>
>
>
>
> ___
> 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] (no subject)

2022-03-15 Thread chris hermansen via Qgis-user
Rayfson and list

On Tue, Mar 15, 2022, 13:32 rayfson souza via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> *OLÁ, SAUDAÇÕES, NÃO CONSIGO INSTALAR AS NOVAS VERSÕES DO QGIS 3.22 NO MEU
> NOVO COMPUTADOR, GOSTARIA MUITO DE ME AJUDAR POR FAVOR.*
>
>
>

Qual sistema operacional? È um Chromebook?


*my pc*
>
> *Processador: Snapdragon (TM) 7c Gen 2 @.55 GHz 2.55 GHz*
>
> *Ram: 4GB*
>
> *Sistema operacional 64 bits, processador baseado em ARM*
>
>
>
> MEU NAME RAYFSON SOUZA DE OLIVEIRA
>
> 5595991166136
>
___
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] Importing spreadsheet: Strange behaviour

2022-03-11 Thread chris hermansen via Qgis-user
Bernd and list,

On Fri, Mar 11, 2022, 12:08 Bernd Vogelgesang via Qgis-user <
qgis-user@lists.osgeo.org> wrote:

> Hi folks,
>
> for quite some time, I hold frequently changing data in a xlsx-file.
> Working in a spreadsheet application is so much more efficient sometimes.
>
> This spreadsheet easily imports by drag and drop, the import dialog pops
> up where to choose which tab to import, and finally the table is there
> with the first row as column heads.
>
> Now, I'm getting just nuts.
>
> I'm trying to do the same with other data, and whatever I try, it
> imports the table ignoring the header row, so its Field1, Field2...
>
> Findings so far:
>
> I had a long file name. With this, there was no import dialog, but the
> first tab was imported immediately, but without the header row.
>
> I saved the file with a short file name, and now the import dialog asks
> which tab to import. But still, the first data-row is ignored.
>
> Dragging my other already existing file into that project works just
> perfectly.
>
> What could be the reason for this behaviour?
>

Clutching at straws here...

Sometimes when making a pivot table in LibreOffice calc I notice that
column headings (first row) aren't interpreted as such.

This seems to occur on the following scenarios:

1) a column has an en empty cell in row 1 (or missing title)

2) a column exists outside the area of interest with no header (this
probably would not apply in your case, but maybe you have some calculations
to the right of your data which don't have a column header)

3) there are some "strange" characters in one or more header fields (I
can't recall precisely what constitutes "strange")


What you might want to do is save a copy of your spreadsheet, then delete
anything to the left or right of your columns, and check that your column
names are all "legal variable" names ie begin with a letter, only letters
and numbers

I hope this helps; good luck!

Chris

>
___
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


  1   2   >