Re: [Qgis-user] Additional data

[James Keener]

It's called a choropleth map.

http://oobrien.com/2010/01/simple-choropleth-maps-in-quantum-gis/ is one 
tutorial I found.

Jim

On August 1, 2016 8:07:11 PM EDT, Chuck Young <wylie1...@gmail.com> wrote:
>Thanks Jim!  You are right a join!  I now need to know how to get the
>data
>to show the density by varying colors depending on the density.  I know
>it
>must be fairly simple bit I just don't have the key to it in my mind.
>Somethimes it can be rigth in front of me but I don't see it.  So an
>example mite be good if anyone has a place in the manual or tutorial to
>point me to.
>Thanks again!
>Chuck
>
>On Mon, Aug 1, 2016 at 4:53 PM, James Keener <j...@jimkeener.com> wrote:
>
>> Beyond just PostGIS, postgresql is a much better database on most
>fronts
>> than mysql.
>>
>> If you have two tables, one with geometries and one with densities,
>they
>> both need to have the same id somewhere. Once you have the join key,
>you
>> can perform a join , not a union, to get a result set containing both
>the
>> geometry and the density. You can use raw SQL in qgis, but I tend to
>create
>> a view in the database based on the query and the qgis will treat
>that as a
>> table, more or less.
>>
>> Jim
>>
>> On August 1, 2016 7:35:18 PM EDT, Chuck Young <wylie1...@gmail.com>
>wrote:
>>
>>> I have been using databases for years and have used QGIS since 1.8
>for
>>> general mapping.  I know it can use additional data attached to the
>>> geographic data via a union query to display lots of different
>things.  I
>>> have map areas where population density would be nice to display
>using
>>> different background fill colors bases on that density. I just need
>a bit
>>> of a boost getting the idea as to how to start and which way to go.
>>>
>>> I have been using the program with SpatiaLite database.  Do I need
>to go
>>> tto the PostGis db?  Most of my other data is currently in MySQL.
>>>
>>> Thanks for amy advice / guidance!!
>>>
>>> Chuck
>>>
>>> --
>>>
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>>
>> --
>> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>>

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS communication platforms

[James Keener]

You feel that to participate in the community of an open source tool I must 
sign up to a proprietary service who will track and advertise to me (of which 
none of the advertising revenue goes to qgis)? What happens in a few years when 
something else becomes the new hotness? What happens when Facebook becomes even 
more evil? Why do you want people tracking you all the time? Why are you OK 
forcing other people into luxury jails?

Jim

On July 18, 2016 9:34:10 AM EDT, "Mats Elfström"  
wrote:
>Hi!
>I am sad to say that I disagree strongly with the views expressed in
>some
>replies to my earlier post.
>
>I am a kid of 63 who has found that Facebook and Twitter are important
>and
>invaluable sources and platforms for both communication and
>information.
>And kids of a younger age are, and must be our target audience. I do
>not
>know about you abroad, but in Sweden there is an alarming lack of
>students
>and graduates in the geospatial sciences. It is now hard to find
>educated
>young people to fill the gaps when us old kids retire. I try to
>evangelize
>QGIS as good as I can and have opportunity to, and an FB page needs no
>explanation, while mailing lists are an unknown entity. Among younger
>kids,
>i mean.
>
>Second, I am a volunteer. I run a Facebook page for QGIS in swedish,
>and
>try to pick up news on QGIS development and QGIS use of a general
>interest.
>Time is a factor, of course, but using FB I need not spend any time to
>maintain userlists, login procedures, web servers etc. I can spend the
>time
>I can offer to maintain the content of the page, which is what should
>matter in the end.
>An I do not think that 2+ FB QGIS likers deserve to be so lightly
>disregarded.
>
>Cheers, Mats.E
>
>2016-07-18 14:20 GMT+02:00 Mats Elfström :
>
>> Hi!
>> I am sad to say that I disagree strongly with the views expressed in
>some
>> replies to my post.
>>
>> I am a kid of 63 who has found that Facebook and Twitter are
>invaluable
>> sources and platforms for both communication and information.
>> And kids of a younger age are, and must be our target audience. I do
>not
>> know about you abroad, but in Sweden there is an alarming lack of
>students
>> and graduates in the geospatial sciences. It is now hard to find
>educated
>> young people to fill the gaps when us old kids retire.
>>
>> Second, I am a volunteer. I run a Facebook page for QGIS in swedish,
>and
>> try to pick up news on QGIS development and QGIS use of a general
>interest.
>> Time is a factor, of course, but using FB I need not spend any time
>to
>> maintain userlists, login procedures, web servers etc. I can spend
>the time
>> I can offer to maintain the content of the page, which is what should
>> matter in the end.
>> An I do not think that 2 FB users deserve to be so easily
>disregarded.
>>
>> Cheers, Mats.E
>>
>> 2016-07-18 13:02 GMT+02:00 Nathan Woodrow :
>>
>>> I, along with some others, manage the Facebook and Twitter accounts.
>It's
>>> not normally a issue I have just been a bit slow with it lately.
>>>
>>> Both are updated now.
>>>
>>> On Mon, Jul 18, 2016 at 8:57 PM, Neumann, Andreas
>
>>> wrote:
>>>
 I am not sure if Facebook is our target audience. Isn't this more
>for
 the kids?

 However, if someone volunteers to work on that - feel free to do
>it.

 On Twitter there is probably more news on QGIS - but I agree with
>Strk
 that the mailing lists should be our primary channels - properly
>archive -
 no restrictions - free for everyone without having to pay with your
 personal data.

 Andreas

 On 2016-07-18 11:51, Mats Elfström wrote:


 This is what 20 774 QGIS likers on Facebook get as QGIS news.

 ​
 Surely they are entitled to a bit more attention?
 Why do you cling to old century mailing lists and bulletin board
 technology?
 How many subscribe to this list?

 Regards, Mats.E
 --


 *GisKraft*, GIS och webbkonsult
 Mats Elfström, Väpplingvägen 21, SE-227 38 LUND, Sweden
 tel: +46 70 595 39 35 / web: www.giskraft.com

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




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

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

Re: [Qgis-user] PostGIS Queries

[James Keener]

I would need double check if overlaps uses an index. 

If it does you can use explain to figure out which table is being fill y 
scanned and adjust the order in the statement accordingly. 

If it doesn't, then you can use something that does (e.g. &&) and ensure that 
the smaller table is the one being scanned.

Jim

On July 15, 2016 9:15:55 AM EDT, Richard McDonnell  
wrote:
>Need a little help, this may not be the forum, but I thought I would 
>throw it out there!
>I am looking to minimise the search area in this query
>
>SELECT objectid
>FROM
>level_1_20151206 AS A, water_polygon AS Z
>WHERE
>(SELECT ST_Overlaps (A.the_geom, Z.geom));
>
>What I want to do is use the extent of A's geometry to limit the search
>
>for overlaps with Z if that makes sense!?
>These are both large National coverage datasets.
>Any help suggestions welcomed!!
>
>Regards,
>
>Richard.
>
>
>
>OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
>OPW - Looking to the future - Caring for the past
>
>***
>Email Disclaimer: http://www.opw.ie/en/disclaimer/
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Backing up GIS Data

[James Keener]

Tapes are still common, actually. They're cheap per GB and are quite
large and reusable.

There is pg_dump available to dump the database itself for backup
purposes.  As for if the disk snapshot (I'm assuming it's a snapshot
and not just a copy of the disk while running!! CHECK THIS!) will
be a sufficient backup, I believe so, but you would defiantly be best
checking with the postgres mailing list.

Jim

On Thu, Jul 14, 2016 at 10:35 AM, Tyler Veinot  wrote:
> Hi All;
> I am thinking about getting IT to install PostgreSQL on our server and start
> moving our GIS Data over to the post database. My concern is backup; we
> currently backup the whole server onto, what are called "tapes" but I am
> sure they are not cassettes or the like, anyway twice a day the whole server
> is copied so we can go back to previous versions of a file or folder to;
> roll back, restore, or recover. With this in place do I need to setup a
> separate backup or replication service on the postgre database? Could I just
> "roll back" using a later server version?
> Well I guess this is more of a postgre question and not so much a QGIS
> one; but I am going to put this out there anyway and if no one can answer I
> will find another spot.
> Thanks
> Tyler
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Processing road data

[James Keener]

Isn't that the format the data is already in? What needs to be split?

On Wed, Jul 6, 2016 at 12:46 PM, Tyler Veinot 
wrote:

> Hi;
> I have an dbf file that identifies the condition of roads defined by
> intersecting streets i.e
>
> *Street* *From* *To* *Condition*
> Bods Rd Frank St Fred Cr Good
> What I would like to do is iterate through the dbf and split each street
> based on the intersection of From and To.
> Any ideas?
> Tyler
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Viewer

[James Keener]

How are users accessing the data?  If they're connecting to a
database, can you simply not give them update permission?  If it's
files, can you can keep read-only master copies on a public
store/shared drive?

Jim

On Thu, Jun 30, 2016 at 12:20 PM, Tyler Veinot  wrote:
> Hi again;
> Just wondering if there is a QGIS Viewer available, or any suggestions as to
> what I can use that is open source with some basic spatial search
> capabilities and can view filegeodatabases?
>
> I have been deploying QGIS to our staff to view our GIS Data and I am
> starting to get a little nervous where someone could easily do some awesome
> geoprocessing damage to our data if they got to messing about. So does QGIS
> have something like Esri's Arc Explorer?
>
> Thanks
> Tyler
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Drive time analysis

[James Keener]

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

Jim

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

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] unsubscribe

[James Keener]

It's on the bottom of every email you get from the list. It says unsubscribe 
and then the link to the mailing list management page.

On April 5, 2016 5:22:19 PM EDT, Sander van den Ende  
wrote:
>Please provide me with instructions to unscubscribe.  The links under
>the email texts don't lead me to unsubscribing.   Thanks and Kind
>Regards, Sander van den Ende
>
>
>
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] unsubscribe

[James Keener]

The link sure does

"To unsubscribe from Qgis-user, get a password reminder, or change your 
subscription options enter your subscription email address:"

On April 5, 2016 5:22:19 PM EDT, Sander van den Ende  
wrote:
>Please provide me with instructions to unscubscribe.  The links under
>the email texts don't lead me to unsubscribing.   Thanks and Kind
>Regards, Sander van den Ende
>
>
>
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Assistance with high-level use case of QGIS for commercial use

[James Keener]

Have you thought about using PostGIS and Python/Ruby/PHP/Perl/?  I'm
not 100% sure how you would respond to a file upload with the QGIS
python API.

Jim

On 02/26/2016 05:26 PM, Dave Tobias wrote:
> I'm new to QGIS and have been a very long time user of a commercial GIS
> solution.  Their fee to deploy a mapservice has opened my eyes to other
> options.  I use the term mapservice loosely because what I want to
> deploy won't even have a map GUI.  It is quite simple actually:
> I would like to deploy QGIS such that multiple non--GIS users can use
> their individual secure logins to upload a .txt file (in a prescribed
> format) which will contain a feature ID, latitude and longitude
> coordinate for each row.  Then in batch mode, the program would then
> overlay the points with a polygon layer I maintain on that server. The
> output would be a .txt file containing the input attributes plus 1
> attribute added to each row from the polygon layer. No map display
> needed, no other user interaction.  This is a simple geospatial
> operation for which they will pay a nominal fee.
> I was able to do this same operation manually with QGIS desktop and I
> see there is an API to perform the operation as a script.  So...are
> there any barriers to me doing this with QGIS/QGIS Server? Is there
> support for this use-case already? I searched but didn't come up with
> any concrete examples in the forums already - a few were interactive
> apps, but I need mine to run in batch mode.
> Thanks in advance - hopefully I'm sending to the correct forum!
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Technical questions regarding QGIS

[James Keener]

Perhaps I'm being dense but none of those questions apply to a user land 
application (except maybe scriptability) and none of those listed are gis 
applications.

Part of me wonders if this is an elaborate form of spam.

Jim

On January 14, 2016 11:40:43 PM EST, Eninna Luli  wrote:
>I am currently making a chart with information of various GIS
>software/applications
>
>
>
>I would like to know more information about QGIS as seen in the
>headings of
>this example chart:
>
>
>
>https://drive.google.com/file/d/0B15UI5xGYTOaM1lLNmZON1Z1MEE/view?usp=sharing
>
>
>
>Supported OSs,Windows Server 2008/Server Core Compatibility, Supported
>Applications, Pre-Backup Analysis, Schedulable, Scriptable, Reporting
>Options, Differential Backups, Virtual Machine Compatibility, Remote
>Administration, Volume Shadow Copy Service (VSS) Compatibility.
>
>
>
>(Of course price would be free)
>
>
>Where can I get this information?
>
>Thanks!
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Georeferencing old areal photography

[James Keener]

Hello!

I have many scans of old slides from areal photography from 30s/40s,
50s/60s, and 60s/70s. Being interested in rail lines, I (and I was going
to trick^Wask my dad and brother to help) trace out the rail lines found
in each areal photograph, with the goal being to align our traces with
current routes in order to georeference the old scans. While some of the
right-of-way has changed since those times, those cases should be small
enough that they can be handled by hand afterwards.

I realize that not all of these scans are in the exact same orientation,
scale, and skew and will need to use something like pHash (or anything
suggested!) to attempt to find overlap. Part of what I'm trying to
figure out right now is how to do the overlap with the GIS files since
phash would only work if I tile my maps of current lines.

Tiles that don't contain rail lines can be handled at a later date,
perhaps with a similar system attempting to align local roads or via
self-similarity with other tiles since they often overlap a little.

Any thoughts, suggestions, ideas, and advice would be greatly appreciated!

Thank you!
Jim
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] postgis/gresql views

[James Keener]

I guess I don't fully understand your problem. Is this a labeling issue or a 
postgres issue?

Also, labels can be the output of an expression. I don't know if that's what 
you mean as you're also talking about aggregate functions.

Can you more clearly define your problem?

Jim

On December 9, 2015 1:08:47 AM EST, Matt Boyd  wrote:
>Hi QGISers.
>I'm trying to work out how to display some geological data on map.
>Basically
>Table x;
>location1 | zone1 | date1 | value1
>location1 | zone1 | date2 | value2
>continued with variations in location/zone etc..
>
>spatial table
>geometry Column | location1
>
>
>I create a view in postgresql using the location as the common column.
>However, when I try to display my data, zone2 is shown with value1 and
>I
>can't work out how to get 2 values and 2 zones to display at a time.
>
>All the data is there and shown correctly in the combined attributes
>table,
>however labels don't show correctly.
>
>Ideally I'd like to be able to create labels and views from within qgis
>using functions (eg, for all zones in location1, what is the sum of the
>values).
>
>I've only been at this a couple of hours this afternoon but thought I'd
>check here in case there's a simpler solution than the one I'm heading
>towards.
>
>Thanks
>Matt
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

To reopen a really old thread, I like the exclamation point/warning icon
with the tool tip in 2.12.  Figured I'd give some good feedback instead
of complaining ever now and then :)

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

[Qgis-user] Project file format

[James Keener]

If I wanted to embark on a fools errand of storing a project in a database, in 
a structured manner, is there a spec for the project file format, or is it what 
it is?
-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] qgis possible malware false positive

[James Keener]

Just to be sure: You did get your binary from
https://qgis.org/en/site/forusers/download.html ?

My first instinct would be to have IT tell you exactly which malware was
found.  If they believe QGIS _itself_ is maleware, then you need to do
different things than if they simply believe it's infected with maleware.

Jim

On 10/20/2015 12:39 PM, CYvilEng wrote:
> I work for a state government in the US. I have been using QGIS since
> version 2.0. I recently downloaded and installed 2.10. The folks in IT
> informed me that qgis was showing up as possible malware and they wiped
> my computer. Now I will begin the battle to get it back. I have seen in
> some searches that many versions ago QGIS was showing false positives
> for viruses. Is this still a thing that others come across? Does anybody
> have any information that can help me convince them this program is safe
> to install?
> 
> Thanks!
> CY
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Rule based styling issue

[James Keener]

Is it possible that when you leave the expression editor and recompute
the styling the colors accidentally get reversed (e.g. the one for 0 is
now 1)?  I've had this happen to me a few times.

Would it be possible to take a couple screen shots of the workflow so
that we can see exactly what you mean?

Jim

On 10/01/2015 11:50 AM, David Addy wrote:
> I have a query about the use of Rule based styles.
> I have a layer of parishes within a county area, which is  styled with a
> transparent fill. Below it I have a copy layer of the same data.
> In both layers the attribute table has a column headed WAPENTAKE, which
> holds string data of 25 characters wide. Some of the fields contain a
> wapentake name, and the remainder contain NULL.
> I want the copy layer to display a certain style when the wapentake contains
> a name, but nothing when the column wapentake contains NULL.
> 
> Now comes the problem. If I set the copy layer to a rule based style so that
> it will display a coloured shading where there is data in the field
> WAPENTAKE, I expect to use the filter of "WAPENTAKE" IS NOT NULL.
> This works correctly if I double click on the filter section in the Style
> window, and manually edit the filter to this expression.
> If instead I open the ellepsis button (...) in order to use the Expression
> builder to build the same expression, the result is the reverse of what I
> want.  IE those with NULL content now show the selected style, and those
> that have names in the column show no style.
> Can anybody shed light on this issue please? What I am I doing wrong?
> 
> (I am using QGIS 2.8.3 under Windows 7 Professional, 64 bit)
> 
> 
> 
> --
> View this message in context: 
> http://osgeo-org.1560.x6.nabble.com/Rule-based-styling-issue-tp5227403.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Rule based styling issue

[James Keener]

Interesting. I haven't noticed this behavior before. I'll see if I can
reproduce it on my end.

If you deselected the empty style in your pictures, does the problem
still occur? (I know, stupid question; I'd expect it not to matter)

Jim

PS: Note I'm not a dev, but I'm willing to help look into what's up, as
this is weird :)

On 10/01/2015 12:25 PM, David Addy wrote:
> Hi,
> First up comes how the styling should look.
>  
> Now two views using the Expression builder, showing the result:
>  
>  
> 
> Thanks for looking at this issue, and I hope these images  help. I note that
> the Expression builder returns '1' as the result, but this is assigned to
> the wrong polygons.
> 
> 
> 
> --
> View this message in context: 
> http://osgeo-org.1560.x6.nabble.com/Rule-based-styling-issue-tp5227403p5227414.html
> Sent from the Quantum GIS - User mailing list archive at Nabble.com.
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Maximum string length 254

[James Keener]

The 254 character limit is inherent to the shapefile format, not QGIS.
https://en.wikipedia.org/wiki/Shapefile#Limitations

Whoever is providing the shapefile must have it stored in another format.
Could you get the raw data? Could you get a SpatiaLite database instead of
shapefiles? Could you convert the geometry in the shapefile to WKT and do
whatever it is you need to do with the text (as opposed to the geometry)
with that?

Jim

On Thu, Sep 17, 2015 at 10:20 AM, Giulia Barbero 
wrote:

> Hello,
>
> I'm using Q-GIS 2.10.1 and I have a problem. I have a shapefile with datas
> from a company and in the list of attributes tehre is described the
> geometry (I mean, there are all the coordinates). The problem is that the
> maximum length of the string is set to 254 and because of this I loose
> information if teh line has a complicated geometry. Do you know if there a
> solution, maybe by creating the attribute in another way or by using
> different types of files ( for example using spatialite) ? I need the
> coordinates of each line...
>
> Thank you
>
>
> Giulia
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] I want to get out of this forum

[James Keener]

Every message you receive from this mailing list contains a link that allows 
you to manage your subscription. You can choose to receive an email for each 
message, one email with all messages for the day, or no emails and leave 
completely.

As with all mailing lists, this is self-serve.
Jim

On September 16, 2015 12:07:55 PM EDT, Giovanni Di Mineo 
 wrote:
>Hi Guys,
>I want to get out of this forum,because every time i get mail from this
>group.
>Is possible please?
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I wonder if we could make use of the stats the query planner uses.

http://www.postgresql.org/docs/9.1/static/monitoring-stats.html

http://www.postgresql.org/docs/9.1/static/planner-stats.html

I don't know how tightly this would couple us to any single version of
postgresql though.

Jim

On 09/04/2015 02:42 AM, Andrea Peri wrote:
> Ho,
> How do qgis to analyze the table to retrieve the unique?
> A loop on every record or a SQL to count distinct ?
> 
> A.
> 
> Il 04/set/2015 08:01, "Bernhard Ströbl"  > ha scritto:
> 
> 
> 
> Am 03.09.2015 um 23:41 schrieb Sandro Santilli:
> 
> On Wed, Sep 02, 2015 at 08:48:34AM +0200, Bernhard Ströbl wrote:
> 
> Am 01.09.2015 um 17:49 schrieb Matthias Kuhn:
> 
> 
> 
> 2. If there are tables without a PK open a second modal
> dialog with an
> explanation of the problem and offer to select a pk from
> a combobox.
> 
> 
> I hope you mean "relation" not table, a table should always
> have a
> PK.
> 
> 
> It's not mandatory for a table to have a PK.
> I guess by "tables without a PK" he means table for which no PRIMARY
> KEY constraint is explicitly defined (should an UNIQUE key be
> considered equally valid?).
> 
> 
> It is not mandatory, of course, that's why I wrote "should", but
> IMHO it is very bad database design to not define one.
> There might be several UNIQUE constraints on one table but there can
> be only one PK constraint. So in case of only a UINIQUE constraint
> the table would be handled as any other without PK constraint (or
> QGIS needs to analyse how many fields have a UNIQUE constraint).
> 
> Bernhard
> 
> 
> __ Information from ESET Mail Security, version of virus
> signature database 12200 (20150904) __
> 
> The message was checked by ESET Mail Security.
> http://www.eset.com
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

Sorry for the double email.  Also, I wonder how much we could extract
from EXPLAIN SELECT * FROM view; (alternatively EXPLAIN SELECT * FROM
view WHERE field1 = 1;) and if we could tease information out of that.

This all seems more complicated than it needs to be though.

Jim

On 09/04/2015 02:42 AM, Andrea Peri wrote:
> Ho,
> How do qgis to analyze the table to retrieve the unique?
> A loop on every record or a SQL to count distinct ?
> 
> A.
> 
> Il 04/set/2015 08:01, "Bernhard Ströbl"  > ha scritto:
> 
> 
> 
> Am 03.09.2015 um 23:41 schrieb Sandro Santilli:
> 
> On Wed, Sep 02, 2015 at 08:48:34AM +0200, Bernhard Ströbl wrote:
> 
> Am 01.09.2015 um 17:49 schrieb Matthias Kuhn:
> 
> 
> 
> 2. If there are tables without a PK open a second modal
> dialog with an
> explanation of the problem and offer to select a pk from
> a combobox.
> 
> 
> I hope you mean "relation" not table, a table should always
> have a
> PK.
> 
> 
> It's not mandatory for a table to have a PK.
> I guess by "tables without a PK" he means table for which no PRIMARY
> KEY constraint is explicitly defined (should an UNIQUE key be
> considered equally valid?).
> 
> 
> It is not mandatory, of course, that's why I wrote "should", but
> IMHO it is very bad database design to not define one.
> There might be several UNIQUE constraints on one table but there can
> be only one PK constraint. So in case of only a UINIQUE constraint
> the table would be handled as any other without PK constraint (or
> QGIS needs to analyse how many fields have a UNIQUE constraint).
> 
> Bernhard
> 
> 
> __ Information from ESET Mail Security, version of virus
> signature database 12200 (20150904) __
> 
> The message was checked by ESET Mail Security.
> http://www.eset.com
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

Explain also gives approx row counts and other info.

On September 4, 2015 9:49:52 AM EDT, Sandro Santilli <s...@keybit.net> wrote:
>On Fri, Sep 04, 2015 at 08:31:39AM -0400, James Keener wrote:
>> Sorry for the double email.  Also, I wonder how much we could extract
>> from EXPLAIN SELECT * FROM view; (alternatively EXPLAIN SELECT * FROM
>> view WHERE field1 = 1;) and if we could tease information out of
>that.
>
>Information can be extracted from the result set with a LIMIT 0
>select, and I believe this is what qgis already does.
>
>You can see which tables are being addressed and whether those
>tables have a primary key, but it ain't easy to determine if
>those primary keys will appear uniquely in the output.
>
>--strk;

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Adding a Mac to a group of PCs

[James Keener]

You don't need a VM, it could run a server, you just need postgres on a network 
that is accessible to everyone you want to use it.

Regardless, If this means the public internet I would highly recommend a 
nonstandard port and would highly suggest client certificates based 
authentication.

Also look into tools like fail2ban and how they can be configured to work for 
failed postgres logins as well.

Jim

On September 2, 2015 10:45:09 AM EDT, "Basques, Bob (CI-StPaul)" 
<bob.basq...@ci.stpaul.mn.us> wrote:
>All,
>
>Oops, I responded to the wrong thread (group actually)
>
>But really, if you wanted to run POSTGIS(Postgres) in the cloud, you
>would just set up a remote VM with OS of you choice), set up
>Postgres/PostGIS and use it from there.  You can filter the remote
>connections from within the Postgres config, etc.
>
>bobb
>
>On Sep 2, 2015, at 9:23 AM, Basques, Bob (CI-StPaul)
><bob.basq...@ci.stpaul.mn.us<mailto:bob.basq...@ci.stpaul.mn.us>>
>wrote:
>
>You could use WebDAV to handle the sharing.  All web based, and can
>look the same across all clients.
>
>bobb
>
>
>
>On Sep 1, 2015, at 8:59 PM, John Harrop
><jchar...@gmail.com<mailto:jchar...@gmail.com>> wrote:
>
>Any suggestions on how to "cloudify" PostGIS?  I would like to use it
>as well and shared across more than the local network.
>
>Cheers,
>
>John
>
>Sent from my iPhone
>
>On Sep 1, 2015, at 9:38 AM, didier peeters
><dpeet...@ulb.ac.be<mailto:dpeet...@ulb.ac.be>> wrote:
>
>Arni,
>
>Postgis is certainly an excellent option.
>Regarding the data sources, currently QGis cannot use relative paths to
>files or photos (at least) but to svg's in styling (and maybe other, I
>don’t have an exhaustive list). One option to bypass the files issue
>would be to use a web server and store URL instead of internal paths. 
>For instance you could have a web server, and whenever a file (or
>photo) is added generate with a Postgresql trigger the corresponding
>url in another attribute, making the file available to all the users,
>either through a form or through an action.
>
>Didier
>
>
>Le 1 sept. 2015 à 17:45, Árni Geirsson
><a...@alta.is<mailto:a...@alta.is>> a écrit :
>
>Thanks Jim
>Your answer encourages me to try the PostGIS option - it obviously has
>some other useful advantages. But your reply also made me realize that
>the problem is really that much of the data I have is on another
>network share - hence the problem with the paths. I should simply move
>the data so that everything is on the same share and and then, relative
>paths will solve the problem.
>Again, thank you for a very helpful answer.
>
>Arni
>
>
>Árni Geirsson
>Alta ehf // +354 582 5000 // +354 897 9549
>www.alta.is<http://www.alta.is/>  // Alta á
>Twitter<http://twitter.com/alta_ehf> // Alta á
>Facebook<http://www.facebook.com/pages/Alta/161795813838691?v=wall>
>
>On Tue, Sep 1, 2015 at 3:26 PM, James Keener
><j...@jimkeener.com<mailto:j...@jimkeener.com>> wrote:
>Re: postgresql in my experience it's neither cumbersome nor slow. Feel
>free to email me for help if you would like to explore that route.
>
>Are the paths in you qgs file relative or absolute? If their relative,
>is the issue that the path separator is different? If that is the
>issue, I would file a bug report. (If they are absolute, try saving
>them with relative paths.)
>
>Jim
>
>On September 1, 2015 11:12:10 AM EDT, "Árni Geirsson"
><a...@alta.is<mailto:a...@alta.is>> wrote:
>Hi
>I am adding a Mac to a local network of PCs. The Mac user uses QGIS (as
>well as the PCs) and accesses data on a shared drive. Now the problem
>comes up that data sources have different paths to the shared drive in
>each operating system, making cooperation difficult. On the other hand,
>since the .qgs file is easy to edit, some simple solution might map the
>paths automatically on open and back on save, to compensate for these
>differences. And maybe there is some other solution out there.
>I realize that having all shared data in PostGIS might be one way to
>solve this but I suspect that it might be both slower and a little more
>cumbersome.
>All thoughts and suggestions are highly appreciated.
>
>Árni Geirsson
>
>
>
>
>
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org<mailto:Qgis-user@lists.osgeo.org>
>http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>--
>Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
>___
>Qgis-user mailing list
>Qg

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I guess what I'm getting at is what is it used for outside of, and not within 
qgis. Are they used for queries? (Also, ctid can change on vacuum, as such they 
can't be relied upon outside the query (with any guarantees.) How would the 
situation be different if qgis used an incremental, internal integer? It's a 
guaranteed unique value (can't be said for oid or any column without an actual 
unique constraint), it just can't be persisted (can't be said for the ctid or a 
windowed function).

As I mentioned, qgis will accept non-unique fields as the primary key for a 
view (after being loaded, I don't expect that to be checked beforehand), so 
qgis isn't attempting to store the primary key in a constrained data store? 
This is what I'm most confused about. Why am i , as a user, being (poorly) to 
give qgis the name of the pk, when a non-unique field is just as acceptable?

Jim

On September 1, 2015 12:09:28 PM EDT, Matthias Kuhn <matth...@opengis.ch> wrote:
>On 09/01/2015 05:54 PM, James Keener wrote:
>> We also need to ask what qgis is doing with this and why we need to
>> bug the user about it at all.
>>
>> Why do we not big the user about tables without a primary key? If
>> tables can be loaded without a pk, why can't views.
>QGIS relies on feature ids for a lot of different things to
>unambiguously identify features.
>
>For tables there is a (also not optimal) ctid which can be used as
>feature id:
>http://www.postgresql.org/docs/8.2/static/ddl-system-columns.html
>
>For views there is none (see
>http://www.postgresql.org/docs/9.1/static/rules-views.html, section
>37.2.4)
>>
>> Why can I select non-unique columns as primary keys and after loading
>> the layer get no error?
>Because a lot of things in QGIS rely on feature ids and see above why
>the fallback which exists for tables does not work for views.
>Especially - but not only - editing. See my proposal #4.
>>
>> Are these also bugs? Should I make (or find?) tickets for them?
>>
>> Jim
>>
>> On September 1, 2015 11:49:23 AM EDT, Matthias Kuhn
>> <matth...@opengis.ch> wrote:
>>
>> Hi,
>>
>> I would like to second Andreas, what we need is an improvement in
>the UI
>> to make the user aware of the problem.
>>
>> My proposal (please review and improve)
>>
>> 1. Let the user choose whatever table/view he likes. Don't
>disable any
>> items.
>> 2. If there are tables without a PK open a second modal dialog
>with an
>> explanation of the problem and offer to select a pk from a
>combobox.
>>
>> -
>>
>> 3. Optional: Add a button "search suitable pk" which looks for a
>> suitable unique column.
>> 4. Optional: Add a selection "read-only" to the combobox and do
>some
>> row_number() or other black magic and warn the user with a big
>red
>> dialog that he's about to do something very dangerous, unreliable
>and
>> that his warranty is now very void.
>>
>> Best,
>> Matthias
>>
>> On 09/01/2015 05:36 PM, Andreas Neumann wrote:
>>
>> Hi, I would regard the loading of layers from a database
>> something "relatively advanced". Normally I prepare ready to
>> use QGIS project to my users who edit and query our GIS data
>> where they don't have to bother with loading layers. But you
>>     are correct that it can be different persons - the one who
>> creates the view and the ones who are loading them. You are
>> welcome to improve the situation/GUI, but please don't go
>back
>> to the old behavior where it is an assumption that the first
>> column in the list is always the primary key. Andreas On
>> 01.09.2015 14:51, James Keener wrote:
>>
>> Why are you assuming the user who created the view is the
>> one using QGIS? Jim On 09/01/2015 08:50 AM, Andreas
>> Neumann wrote:
>>
>> Hi, I agree with Jürgen - better let the user choose
>> the pkey column. If the user knows how to create a
>> Postgis View he also knows how to select a primary
>key
>> column. Andreas On 01.09.2015 14:37, Jürgen E.
>Fischer
>> wrote:
>>
>> Hi Sandro, On Tue, 01. Sep 2015 at 13:48:33
>+0200,
>> Sandro Santilli wrote:
>>
>> I agree with Luca this should have been
>better
>> not backported to 2.8.3. Only

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I don't disagree that it's a bad practice. However, is qgis a tool that you 
work with or around? Do we want to say "your data must have X as part of its 
schema or qgis can't use it" or will qgis make the best it can with poor data. 
Honestly, being loudly opinionated is a valid option if the developers feel it 
doesn't decrease the user experience drastically.

I'd also like to point out that the primary key need not be a single field. For 
instance (state_fips, county_fips) could be a valid key for county-based 
metrics. Going back to the previous question I posed, do we want to tell users 
to conform to a single-field primary key or will qgis accept valid schema 
designs. Again, it comes down to dev time vs the cost to the user experience.

Jim

On September 1, 2015 12:42:56 PM EDT, "Leknín Řepánek" 
<godzilalal...@gmail.com> wrote:
>Situation with a view without unique (and indexed) key is bad database
>model, or bad query. Using window function is unefficient, but i can't
>find another way to make unique column on query with duplicities in
>records. In query without duplicities is possible to use oid (but this
>needs tables with oids), or ctid (but ctid is slow).
>
>Sorting in row_number can be defined in (ORDER BY ...). But is
>unefficient (as you say). But works well for display smaller parts of
>data (thousands of features).
>
>Materialized view can be indexed. But this is about use case and it
>isnt
>a "pretty solution".  
>
>Je;
>
>On Tue, Sep 01, 2015 at 11:36:53AM -0400, James Keener wrote:
>> Please stop saying this. It's fine for certain situations, but it is
>not a
>> permanently unique identifier for a row. It may change when the
>underlying
>> table is altered. Sure, it's unique if you read the results and keep
>them in
>> memory and never talk about it again, but qgis does that on its own
>already.
>> 
>> Moreover querying on it is extremely inefficient. Querying against it
>forces a
>> sequence scan on the table. Depending on the table and version, it
>could also
>> try to materialize the view fully in memory before doing the scan.
>> 
>> Jim
>> 
>> On September 1, 2015 11:31:32 AM EDT, "Leknín Řepánek"
>> <godzilalal...@gmail.com> wrote:
>> 
>> Workaround about primary key in view, i had use sever times is
>using
>> window function "row_number() over()". It works in views and in
>query
>> from database manager.
>> 
>> Je;
>> 
>> On Tue, Sep 01, 2015 at 04:09:49PM +0200, Sandro Santilli wrote:
>>  On Tue, Sep 01, 2015 at 02:37:22PM +0200, Jürgen E. Fischer
>wrote:
>>  Hi Sandro,
>> 
>>  On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli
>wrote:
>>  I agree with Luca this should have been better not
>backported to 2.8.3.
>>  Only proper bugs should be backported, and this was
>a (debatable)
>>  GUI enhancement, as far as I can
>> tell.
>> 
>>  We intend to only backport fixes and not bugs. ;)
>> 
>>  You were always supposed to select the key column -
>preselecting the first
>>  column was the bug (also debatable).  And #11317 is a
>ticket that demonstrates
>>  there were unaware users.
>> 
>>  Reading #11317 I looks to me that the reported bug was about
>>  "Add PostGIS Layer" not giving the user full detail of why a
>>  layer could not be loaded: "is an invalid layer - not
>loaded".
>>  In this I agree with Aren here:
>http://hub.qgis.org/issues/11317#note-6
>> 
>>  That the first column often happens to be the primary
>key and and the combobox
>>  is not lexically sorted is somewhat pure luck - and
>unless you avoid having the
>>  key verified (using "use estimated metadata"),
>> keeping a wrongly select
>>  column will make the layer to insert invalid.
>> 
>>  I agree that the reported regression was based on the false
>expectation
>>  that QGIS would pick a primary key automatically, but in the
>>  (unlikely?) case a user was aware of that and properly coded
>the view
>>  to ensure primary key was first (or only) numeric the change
>was
>>  indeed a degradation of the experience.
>> 
>>  But I agree that the tooltip that you get on disabled
>lines (not only for the
>>  key selection,

Re: [Qgis-user] Call for release name suggestions 2015

[James Keener]

We could always use silly names.

Qgisor
Qgisisimo
Qgisinator
Qgisette
Qgisador
Qgis: a new hope
Qgis: the next generation
Qgis5
Qgis: or how I learned to stop worrying and love gis
Qgisamation
Qgisactica
Qgis: everywhere
Qgis 1138
Qgis 2001: a geospatial oddesy
Qgis who
Quails Gulls Iiwis and Sirysteses
Qgis fantastique
Qgis: what you will

(That's like 6 years of names!)

But in all seriousness, a bias in geographic locations based on where 
developers and users are isn't the worst bias. I also enjoy the old map imagery.

Jim


On September 1, 2015 5:02:47 PM EDT, "Jürgen E. Fischer"  wrote:
>Hi Mats,
>
>On Tue, 01. Sep 2015 at 17:06:23 +0200, Mats Elfström wrote:
>> Once, Qgis versions were named after planetary moons. We probably ran
>> out of those, at least those known to the public.
>
>Nope, there are probably plenty left.  But we stopped using them
>because there
>was a trademark claim on some of the moons we used by a company that
>already
>used it for their software product.
>
>> Place names can be biased, like: now it's time for a latin american
>name and
>> so on.
>
>We already had a latin american name: Copiapo.
>
>
>> May I suggest the periodic table of elements as base for the naming
>instead.
>> By cleverly using the groups one could even indicate major/minor
>version
>> changes.
>
>Not sure if that's safer than moons.
>
>
>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
>http://www.norbit.de
>QGIS release manager (PSC)  GermanyIRC: jef on
>FreeNode 
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

Why are you assuming the user who created the view is the one using QGIS?

Jim

On 09/01/2015 08:50 AM, Andreas Neumann wrote:
> Hi,
> 
> I agree with Jürgen - better let the user choose the pkey column. If the
> user knows how to create a Postgis View he also knows how to select a
> primary key column.
> 
> Andreas
> 
> On 01.09.2015 14:37, Jürgen E. Fischer wrote:
>> Hi Sandro,
>>
>> On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
>>> I agree with Luca this should have been better not backported to 2.8.3.
>>> Only proper bugs should be backported, and this was a (debatable)
>>> GUI enhancement, as far as I can tell.
>> We intend to only backport fixes and not bugs. ;)
>>
>> You were always supposed to select the key column - preselecting the first
>> column was the bug (also debatable).  And #11317 is a ticket that 
>> demonstrates
>> there were unaware users.
>>
>> That the first column often happens to be the primary key and and the 
>> combobox
>> is not lexically sorted is somewhat pure luck - and unless you avoid having 
>> the
>> key verified (using "use estimated metadata"), keeping a wrongly select
>> column will make the layer to insert invalid.
>>
>> But I agree that the tooltip that you get on disabled lines (not only for the
>> key selection, but also geometry type and srid) might not be visible enough
>> (but that IMHO would be just a GUI enhancement).
>>
>>
>> Jürgen
>>
>>
>>
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I don't want to reopen the ticket, as that's not my place, but I would
like to comment on it and your comment here:

> Why does QGIS need a primary key?
>
> To create (persistent) feature ids that are used for selection (and
deletion and changing of attribute or geometries - but that doesn't
apply to normal views).

While I understand from the applications POV how a single primary key
makes sense, from the databases POV querying off of ROW_NUMBER() will
force a sequence scan, which may be _extremely_ slow. While this isn't
exactly your issue, advocating a "solution" to your problem that creates
a bad user experience isn't a good idea.

At least selecting based on geometry would be able to invoke the
(likely-to-exist) index on the underlying table(s), where there is no
possible way to index row_number() and it will _always_ sequence scan.

Additionally, ROW_NUMBER() _isn't_ a pk.  If the view has no ordering
being forced (and even if there is!), then additions to the underlying
table could reörder the order of the output rows, changing ROW_NUMBER().
If you were querying against the ROW_NUMBER() column, the updated view
the _wrong_ row returned -- this is a very very bad thing!

At the very least, don't tell people to use ROW_NUMBER() as a primary
key.  This is just terrible advice!

Also, I'm running 2.10.1 and when I add a view on a table with no unique
values, and even if I select a non-unique field as my primary key, QGIS
will happily load the view, not complain about the cardinality of the
"primary key" being less than the carnality of the rows, and proceed to
draw the geometries correctly and let me select features and will show
me the correct attributes. As a user, I felt very frustrated by this
(especially because the default window size hid the dropdown to select
the pk and there was no indication at all at what was wrong!) and like I
had to jump through a hoop for the programmer's convenience, not for any
matter that actually mattered.

As a programmer, I know what you're trying to do, but since it doesn't
appear to matter anyway, what's the point.  Try this.

> [local]:5432 jim@geodata=# create table testing_mult (a int, t text);CREATE 
> TABLE
> Time: 6.248 ms
> [local]:5432 jim@geodata=# select 
> AddGeometryColumn('public','testing_mult','g',4326,'POINT', 2);
>  addgeometrycolumn  
> 
>  public.testing_mult.g SRID:4326 TYPE:POINT DIMS:2 
> (1 row)
> 
> Time: 5.349 ms
> [local]:5432 jim@geodata=# insert into testing_mult values (1, 'thingy', 
> st_geomfromtext('point(1 1)',4326 ));
> INSERT 0 1
> Time: 3.062 ms
> [local]:5432 jim@geodata=# insert into testing_mult values (1, 'this', 
> st_geomfromtext('point(1 0)',4326 ));
> INSERT 0 1
> Time: 2.865 ms
> [local]:5432 jim@geodata=# insert into testing_mult values (1, 'that', 
> st_geomfromtext('point(0 0)',4326 ));
> INSERT 0 1
> Time: 2.873 ms
> [local]:5432 jim@geodata=# create view testing_mult_view as select * from 
> testing_mult ;
> CREATE VIEW
> Time: 6.055 ms

Now, go to QGIS, select column 'a' as the "primary key".  You'll see 3
points, and you'll be able to get the correct attribute values for each

Moreover, you can load the test_multi without having to give it a pk, so
again, as a user, I'm extremely confused by inconsistent behavior,
doubly so if I didn't create the DB and don't understand what a view is.

If tables can be used without selecting a primary key, why must views?
and why must the UI be so tight-lipped?  "Select a primary key" as the
tool-tip means absolutely nothing to someone not used to databases. It
means less given that you can't see the "primary key" column in the
window with the window's default size. It means even less when someone
who understands what a primary key is seeing tables that are usable and
that don't have one.

What is the point of having the user select a "primary key" if QGIS is
accepting non-unique fields with no issue?  QGIS needs to either
complain about the lack of uniqueness, or drop forcing the user to
select one.

Jim

PS: I know this isn't the place, but the db manager gives absolutely,
positively terrible feedback about this.

On 09/01/2015 04:59 AM, Jürgen E. Fischer wrote:
> Hi James,
> 
> On Mon, 31. Aug 2015 at 15:05:05 -0400, James Keener wrote:
>> I don't mind the behavior as much as it's entirely unclear, especially
>> when the window is small and you have to scroll to see the drop down,
>> what is the problem.
> 
>> There should be an error message (or even an error/warning icon with the
>> tool tip saying there is on PK), along with possible remedies presented
>> to the user.
> 
> Well, it's not an error (same as having to select a geometry type or SRID,

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

We also need to ask what qgis is doing with this and why we need to bug the 
user about it at all. 

Why do we not big the user about tables without a primary key? If tables can be 
loaded without a pk, why can't views.

Why can I select non-unique columns as primary keys and after loading the layer 
get no error?

Are these also bugs? Should I make (or find?) tickets for them?

Jim

On September 1, 2015 11:49:23 AM EDT, Matthias Kuhn <matth...@opengis.ch> wrote:
>Hi,
>
>I would like to second Andreas, what we need is an improvement in the
>UI
>to make the user aware of the problem.
>
>My proposal (please review and improve)
>
>1. Let the user choose whatever table/view he likes. Don't disable any
>items.
>2. If there are tables without a PK open a second modal dialog with an
>explanation of the problem and offer to select a pk from a combobox.
>
>-
>
>3. Optional: Add a button "search suitable pk" which looks for a
>suitable unique column.
>4. Optional: Add a selection "read-only" to the combobox and do some
>row_number() or other black magic and warn the user with a big red
>dialog that he's about to do something very dangerous, unreliable and
>that his warranty is now very void.
>
>Best,
>Matthias
>
>On 09/01/2015 05:36 PM, Andreas Neumann wrote:
>> Hi,
>>
>> I would regard the loading of layers from a database something
>> "relatively advanced". Normally I prepare ready to use QGIS project
>to
>> my users who edit and query our GIS data where they don't have to
>> bother with loading layers.
>>
>> But you are correct that it can be different persons - the one who
>> creates the view and the ones who are loading them.
>>
>> You are welcome to improve the situation/GUI, but please don't go
>back
>> to the old behavior where it is an assumption that the first column
>in
>> the list is always the primary key.
>>
>> Andreas
>>
>> On 01.09.2015 14:51, James Keener wrote:
>>> Why are you assuming the user who created the view is the one using
>>> QGIS?
>>>
>>> Jim
>>>
>>> On 09/01/2015 08:50 AM, Andreas Neumann wrote:
>>>> Hi,
>>>>
>>>> I agree with Jürgen - better let the user choose the pkey column.
>If
>>>> the
>>>> user knows how to create a Postgis View he also knows how to select
>a
>>>> primary key column.
>>>>
>>>> Andreas
>>>>
>>>> On 01.09.2015 14:37, Jürgen E. Fischer wrote:
>>>>> Hi Sandro,
>>>>>
>>>>> On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
>>>>>> I agree with Luca this should have been better not backported to
>>>>>> 2.8.3.
>>>>>> Only proper bugs should be backported, and this was a (debatable)
>>>>>> GUI enhancement, as far as I can tell.
>>>>> We intend to only backport fixes and not bugs. ;)
>>>>>
>>>>> You were always supposed to select the key column - preselecting
>>>>> the first
>>>>> column was the bug (also debatable).  And #11317 is a ticket that
>>>>> demonstrates
>>>>> there were unaware users.
>>>>>
>>>>> That the first column often happens to be the primary key and and
>>>>> the combobox
>>>>> is not lexically sorted is somewhat pure luck - and unless you
>>>>> avoid having the
>>>>> key verified (using "use estimated metadata"), keeping a wrongly
>>>>> select
>>>>> column will make the layer to insert invalid.
>>>>>
>>>>> But I agree that the tooltip that you get on disabled lines (not
>>>>> only for the
>>>>> key selection, but also geometry type and srid) might not be
>>>>> visible enough
>>>>> (but that IMHO would be just a GUI enhancement).
>>>>>
>>>>>
>>>>> Jürgen
>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> Qgis-user mailing list
>>>>> Qgis-user@lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>>>
>>>> ___
>>>> Qgis-user mailing list
>>>> Qgis-user@lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I realized I'm coming off very antagonistic and don't mean to be. I understand 
the importance of a primary key, but don't want users to be told to do anti 
patterns and non beneficial things like row_number.

I also feel that the ui should be consistent and not have surprises. Tables and 
views needed to be treated similarly, and if their not, they shouldn't be 
intermingled in the ui.

My apologizes, and I will try to write from now on with a more amiable tone.

Jim

On September 1, 2015 11:49:23 AM EDT, Matthias Kuhn <matth...@opengis.ch> wrote:
>Hi,
>
>I would like to second Andreas, what we need is an improvement in the
>UI
>to make the user aware of the problem.
>
>My proposal (please review and improve)
>
>1. Let the user choose whatever table/view he likes. Don't disable any
>items.
>2. If there are tables without a PK open a second modal dialog with an
>explanation of the problem and offer to select a pk from a combobox.
>
>-
>
>3. Optional: Add a button "search suitable pk" which looks for a
>suitable unique column.
>4. Optional: Add a selection "read-only" to the combobox and do some
>row_number() or other black magic and warn the user with a big red
>dialog that he's about to do something very dangerous, unreliable and
>that his warranty is now very void.
>
>Best,
>Matthias
>
>On 09/01/2015 05:36 PM, Andreas Neumann wrote:
>> Hi,
>>
>> I would regard the loading of layers from a database something
>> "relatively advanced". Normally I prepare ready to use QGIS project
>to
>> my users who edit and query our GIS data where they don't have to
>> bother with loading layers.
>>
>> But you are correct that it can be different persons - the one who
>> creates the view and the ones who are loading them.
>>
>> You are welcome to improve the situation/GUI, but please don't go
>back
>> to the old behavior where it is an assumption that the first column
>in
>> the list is always the primary key.
>>
>> Andreas
>>
>> On 01.09.2015 14:51, James Keener wrote:
>>> Why are you assuming the user who created the view is the one using
>>> QGIS?
>>>
>>> Jim
>>>
>>> On 09/01/2015 08:50 AM, Andreas Neumann wrote:
>>>> Hi,
>>>>
>>>> I agree with Jürgen - better let the user choose the pkey column.
>If
>>>> the
>>>> user knows how to create a Postgis View he also knows how to select
>a
>>>> primary key column.
>>>>
>>>> Andreas
>>>>
>>>> On 01.09.2015 14:37, Jürgen E. Fischer wrote:
>>>>> Hi Sandro,
>>>>>
>>>>> On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
>>>>>> I agree with Luca this should have been better not backported to
>>>>>> 2.8.3.
>>>>>> Only proper bugs should be backported, and this was a (debatable)
>>>>>> GUI enhancement, as far as I can tell.
>>>>> We intend to only backport fixes and not bugs. ;)
>>>>>
>>>>> You were always supposed to select the key column - preselecting
>>>>> the first
>>>>> column was the bug (also debatable).  And #11317 is a ticket that
>>>>> demonstrates
>>>>> there were unaware users.
>>>>>
>>>>> That the first column often happens to be the primary key and and
>>>>> the combobox
>>>>> is not lexically sorted is somewhat pure luck - and unless you
>>>>> avoid having the
>>>>> key verified (using "use estimated metadata"), keeping a wrongly
>>>>> select
>>>>> column will make the layer to insert invalid.
>>>>>
>>>>> But I agree that the tooltip that you get on disabled lines (not
>>>>> only for the
>>>>> key selection, but also geometry type and srid) might not be
>>>>> visible enough
>>>>> (but that IMHO would be just a GUI enhancement).
>>>>>
>>>>>
>>>>> Jürgen
>>>>>
>>>>>
>>>>>
>>>>> ___
>>>>> Qgis-user mailing list
>>>>> Qgis-user@lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>>>
>>>> ___
>>>> Qgis-user mailing list
>>>> Qgis-user@lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>>
>>
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Adding a Mac to a group of PCs

[James Keener]

Re: postgresql in my experience it's neither cumbersome nor slow. Feel free to 
email me for help if you would like to explore that route.

Are the paths in you qgs file relative or absolute? If their relative, is the 
issue that the path separator is different? If that is the issue, I would file 
a bug report. (If they are absolute, try saving them with relative paths.)

Jim

On September 1, 2015 11:12:10 AM EDT, "Árni Geirsson"  wrote:
>Hi
>I am adding a Mac to a local network of PCs. The Mac user uses QGIS (as
>well as the PCs) and accesses data on a shared drive. Now the problem
>comes
>up that data sources have different paths to the shared drive in each
>operating system, making cooperation difficult. On the other hand,
>since
>the .qgs file is easy to edit, some simple solution might map the paths
>automatically on open and back on save, to compensate for these
>differences. And maybe there is some other solution out there.
>I realize that having all shared data in PostGIS might be one way to
>solve
>this but I suspect that it might be both slower and a little more
>cumbersome.
>All thoughts and suggestions are highly appreciated.
>
>Árni Geirsson
>
>
>
>
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I'm not saying the old behaviour is correct.

I'm saying the new behavior isn't friendly to non expert users. Loading from a 
database is no more difficult than loading a shapefile in most cases. I have 
clients and students do it quite often and "windowing function" means nothing 
and "primary key" is only a vague notion.

Please don't just accept a broken ui because its something _you think_ only 
"relatively advanced" users will use.

Moving towards a solution: how would people feel about a window appearing after 
selecting a view specifically asking which field to use (if one wasn't selected 
in the initial drop down). Alternatively, moving the in-row drop down to the 
beginning of the row so that small window sizes don't cut it off, and putting a 
yellow warning on it to draw attention. 

Jim

On September 1, 2015 11:36:09 AM EDT, Andreas Neumann <a.neum...@carto.net> 
wrote:
>Hi,
>
>I would regard the loading of layers from a database something 
>"relatively advanced". Normally I prepare ready to use QGIS project to 
>my users who edit and query our GIS data where they don't have to
>bother 
>with loading layers.
>
>But you are correct that it can be different persons - the one who 
>creates the view and the ones who are loading them.
>
>You are welcome to improve the situation/GUI, but please don't go back 
>to the old behavior where it is an assumption that the first column in 
>the list is always the primary key.
>
>Andreas
>
>On 01.09.2015 14:51, James Keener wrote:
>> Why are you assuming the user who created the view is the one using
>QGIS?
>>
>> Jim
>>
>> On 09/01/2015 08:50 AM, Andreas Neumann wrote:
>>> Hi,
>>>
>>> I agree with Jürgen - better let the user choose the pkey column. If
>the
>>> user knows how to create a Postgis View he also knows how to select
>a
>>> primary key column.
>>>
>>> Andreas
>>>
>>> On 01.09.2015 14:37, Jürgen E. Fischer wrote:
>>>> Hi Sandro,
>>>>
>>>> On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
>>>>> I agree with Luca this should have been better not backported to
>2.8.3.
>>>>> Only proper bugs should be backported, and this was a (debatable)
>>>>> GUI enhancement, as far as I can tell.
>>>> We intend to only backport fixes and not bugs. ;)
>>>>
>>>> You were always supposed to select the key column - preselecting
>the first
>>>> column was the bug (also debatable).  And #11317 is a ticket that
>demonstrates
>>>> there were unaware users.
>>>>
>>>> That the first column often happens to be the primary key and and
>the combobox
>>>> is not lexically sorted is somewhat pure luck - and unless you
>avoid having the
>>>> key verified (using "use estimated metadata"), keeping a wrongly
>select
>>>> column will make the layer to insert invalid.
>>>>
>>>> But I agree that the tooltip that you get on disabled lines (not
>only for the
>>>> key selection, but also geometry type and srid) might not be
>visible enough
>>>> (but that IMHO would be just a GUI enhancement).
>>>>
>>>>
>>>> Jürgen
>>>>
>>>>
>>>>
>>>> ___
>>>> Qgis-user mailing list
>>>> Qgis-user@lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>>
>>> ___
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

Please stop saying this. It's fine for certain situations, but it is not a 
permanently unique identifier for a row.  It may change when the underlying 
table is altered. Sure, it's unique if you read the results and keep them in 
memory and never talk about it again, but qgis does that on its own already.

Moreover querying on it is extremely inefficient. Querying against it forces a 
sequence scan on the table. Depending on the table and version, it could also 
try to materialize the view fully in memory before doing the scan.

Jim

On September 1, 2015 11:31:32 AM EDT, "Leknín Řepánek" 
 wrote:
>Workaround about primary key in view, i had use sever times is using
>window function "row_number() over()". It works in views and in query
>from database manager.
>
>Je;
>
>On Tue, Sep 01, 2015 at 04:09:49PM +0200, Sandro Santilli wrote:
>> On Tue, Sep 01, 2015 at 02:37:22PM +0200, Jürgen E. Fischer wrote:
>> > Hi Sandro,
>> > 
>> > On Tue, 01. Sep 2015 at 13:48:33 +0200, Sandro Santilli wrote:
>> > > I agree with Luca this should have been better not backported to
>2.8.3.
>> > > Only proper bugs should be backported, and this was a (debatable)
>> > > GUI enhancement, as far as I can tell.
>> > 
>> > We intend to only backport fixes and not bugs. ;)
>> > 
>> > You were always supposed to select the key column - preselecting
>the first
>> > column was the bug (also debatable).  And #11317 is a ticket that
>demonstrates
>> > there were unaware users.
>> 
>> Reading #11317 I looks to me that the reported bug was about
>> "Add PostGIS Layer" not giving the user full detail of why a
>> layer could not be loaded: "is an invalid layer - not loaded".
>> In this I agree with Aren here:
>http://hub.qgis.org/issues/11317#note-6
>> 
>> > That the first column often happens to be the primary key and and
>the combobox
>> > is not lexically sorted is somewhat pure luck - and unless you
>avoid having the
>> > key verified (using "use estimated metadata"), keeping a wrongly
>select
>> > column will make the layer to insert invalid.
>> 
>> I agree that the reported regression was based on the false
>expectation
>> that QGIS would pick a primary key automatically, but in the
>> (unlikely?) case a user was aware of that and properly coded the view
>> to ensure primary key was first (or only) numeric the change was
>> indeed a degradation of the experience.
>> 
>> > But I agree that the tooltip that you get on disabled lines (not
>only for the
>> > key selection, but also geometry type and srid) might not be
>visible enough
>> > (but that IMHO would be just a GUI enhancement).
>> 
>> There should maybe be another rule about LTS backports being:
>> debatable fixes/enhancement need to be debated more on list ?
>> 
>> --strk;
>> ___
>> Qgis-user mailing list
>> Qgis-user@lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>___
>Qgis-user mailing list
>Qgis-user@lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.10.1 adding PostGIS Views

[James Keener]

I don't mind the behavior as much as it's entirely unclear, especially
when the window is small and you have to scroll to see the drop down,
what is the problem.

There should be an error message (or even an error/warning icon with the
tool tip saying there is on PK), along with possible remedies presented
to the user.

Jim

On 08/31/2015 03:00 PM, Luca Lanteri wrote:
> Hi,
> 
> I noticed that this new behavior has been backported to 2.8.3.
> I think this behavior should be considered a regression because now it's
> very uncomfortable to load views, specially when I have to load many
> views. I also noticed that lot of users are confused, because they
> thinks that views doesn't work. I think the old behavior was better
> because it allowed both to choose a custom gid and to load view faster.
> Currently we decide to remain with 2.8.2.
> 
> What about reconsidering to return to the old behavior ? 
> 
> Thanks
> Luca
> 
> 2015-08-06 20:58 GMT+02:00 Jürgen E. >:
> 
> Hi Randal,
> 
> On Thu, 06. Aug 2015 at 13:53:08 -0400, Randal Hale wrote:
> > In 2.8.x I can add the view and the Primary key is automatically 
> displayed.
> 
> No, you're supposed to select the primary key.  In 2.8.x you also
> have to
> choose from all columns, but first one is preselected.  If that
> happens to be
> the primary key, you're fine, but that's not always the case and hence
> newer versions force you to actually select it.
> 
> 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   
>  http://www.norbit.de
> QGIS release manager (PSC)  GermanyIRC: jef on
> FreeNode
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org 
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Getting There, From Here (How to get this Shapefile into a tablet!)

[James Keener]

Depending on how much space you're willing to give it, you could pre
compute tiles and have a single-folder webpage (via the qgis2web plugin)
you could load on your device and view it on its web browser.

There is the Android Osmand application for viewing OSM data (via
network of offline downloads!) I'm not sure how you would go about
converting your information into a format it could handle, but it could
be an interesting project.

There is, somewhere, an Android version of QGIS, you may want to seek
out it's status and see if it'll work on your device.

Jim

On 08/29/2015 10:46 AM, Adam Sherman wrote:
 This is maybe slightly off-topic, but I'm hoping this is the right place
 to figure this out: I've been tearing my hair out trying to get from
 there to here, so I'm posting in the hope that someone has done this
 before me.
 
 The Province of Quebec, Canada, now publishes road data in multiple formats:
 
 MapInfo (TAB)
 ESRI (SHP)
 ESRI (PGDB)
 ESRI (FGDB)
 Géomédia (MDB)
 
 I opened the SHP in QGIS and it is incredibly detailed! It contains
 forestry roads not found in any other data that I have looked at. So, I
 want this in my truck. But I have been completely unable to get it to
 work, short of carrying my laptop with me.
 
 Anyone have any ideas?
 
 I have:
 
 A MacBook
 I can run Windows on it
 An Android tablet
 A iPad (iOS)
 
 Note: The SHP file is 1.6 GB.
 
 The goal is pretty much any way to get the data onto a tablet with a GPS
 app. I don't mind buying some software, either.
 
 Thanks for any and all comments or suggestions,
 
 A.
 
 -- 
 Adam Sherman
 Directeur des opérations, Sauvetage bénévole Outaouais
 Director of Operations, Ottawa Volunteer SAR
 CTO, Versature Corp.
 +1 613 797 6819
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to reference a map with qGIS

[James Keener]

When you export from composer, it's just a tiff, not a geotiff (someone else 
correct me if I'm wrong!)

A quick-and-dirty solution may be to fake the tiff that was exported from the 
composer and georefernce it against your project, and save that as a geotiff.

Jim

On August 22, 2015 9:22:29 PM EDT, Laurence Béchet 
bechet.laure...@gmail.com wrote:

Hi,

I'm investigating the use of electronic devices to record data when 
people are doing field work. Apps like PDF Maps require referenced maps

in pdf or tiff format. While it's quite easy to design a referenced map

from a GIS project with ArcGIS, it's seems to be quite a challenge with

qGIS.

I have a qGIS project with different shapefiles. If I use /project/save

as image/ and create a .tiff file, then use 
/raster/conversion/translate/ the tiff file into a geotiff, the result 
is georeferenced. But the map itself is not very exciting.

If I use the composer to create the .tiff file and then use 
/raster/conversion/translate/ the tiff file into a geotiff (as in the 
previous case), the final map is not georeferenced.

At this stage I'm kind of lost, as the composer allows setting like 
GDAL, CRS etc.. and everything seems to be set properly.

I'm on Windows7 pro, with qGIS Wien 2.8.3 (I've got a rendering pbe
with 
version 2.10 which forced me to downgrade to 2.8).

Would someone have any ideas? What's the best practice to create geo 
referenced tif or pdf?

Regards
Laurence Bechet






___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGis server project files stored in DB?

[James Keener]

 So you assume to have grants to write in the table where is stored the
published informazioni. This is not always true. The dba amministratore of
a published environment not like to have some cowboy to write into its DBMS.

It depends on the access you need. If you're in an environment with an
actual dba, they can give you the rights you need and no more.  The more
widespread case is when you're acting as your own DBA and in which case you
can have the rights you need.  The user QGIS Server uses doesn't need to be
the same user that has update access.  There are many solutions.

It also depends on the application, and a billion other things that make it
difficult to say you can't do that.  It _can_ be done, it's just a matter
of making it happen.


 Instead in low profile environment where there is 1 user only and it is
webadmin , qgis user and perhaps also publisher. Not always it ha also  the
capability to admin a DBMS like postgres.

I'm not sure what you're getting at. No one is saying that the db-based
projects should be the only, or even the default, method.

 I feat that this option increasing complexity will reduce the
installation of qgis-server.

Again, no one is talking about removing the current method.  I'm not sure
what your problem is with people discussing a more complex, but
also extremely flexible, needed, and wanted method of storing projects.  If
you don't want it, don't use it.  No one is taking away file-based projects.

Jim

On Wed, Aug 12, 2015 at 10:03 AM, Andrea Peri aperi2...@gmail.com wrote:

 So you assume to have grants to write in the table where is stored the
 published informazioni.
 This is not always true. The dba amministratore of a published environment
 not like to have some cowboy to write into its DBMS.

 Instead in low profile environment where there is 1 user only and it is
 webadmin , qgis user and perhaps also publisher. Not always it ha also  the
 capability to admin a DBMS like postgres.

 I feat that this option increasing complexity will reduce the installation
 of qgis-server.

 A.
 Il 12/ago/2015 03:29 PM, James Keener j...@jimkeener.com ha scritto:

 I was also looking for this a bit back and never found a solution. I
 ended up using other software, unfortunately.

 As for being less flexible, it is exactly as flexible as a qgs file would
 be, it's just that they could be manipulated and created more easily.  I
 would love to see the parts of the file broke out in the database and not
 just using a single text blob, though.

 Also, setting up identical-enough is fairly trivial, especially if most
 of the layers are already coming from a database, or known cache of
 shapefiles.

 Jim

 On Wed, Aug 12, 2015 at 9:13 AM, Andrea Peri aperi2...@gmail.com wrote:

 I don't guess is more flexible.
 Infact usually the teting environment is never exactly exals to the
 publish environmnet.

 A file allw to open and correct the paths from develop and publish
 environment.
 Also the svg symbols could be not exactly with the same path from
 develop and publish environment.

 So having a same project in a db is more complex becasue need to have
 two environment exactly the same.
 And this is not possible.
 .

 I guess the db storing for project could be more flexible only if the
 paths to the layers and relative paths of svg was not stored in the
 project file but instead in other files.

 My 2ct.

 A.


 2015-08-12 15:06 GMT+02:00 lars lingner gislars+l...@gmail.com:
  Hello,
 
  I'm looking for a solution for storing QGis project files (qgs) in a
  PostgreSQL database. Storing the files in a table isn't actually the
  problem, but getting it out and feeding it to QGis server.
 
  Did anyone had this need already? Would this be a good idea?
 
  In my use case the project files are generated, based on a default
  project file. Having the file in the DB would give more flexibility.
 
  Since saving the style in DB is already supported by QGis, I'm just
  curious of opinions of other users or developers.
 
  Thanks in advance for any feedback
 
  Lars
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user



 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGis server project files stored in DB?

[James Keener]

I was also looking for this a bit back and never found a solution. I ended
up using other software, unfortunately.

As for being less flexible, it is exactly as flexible as a qgs file would
be, it's just that they could be manipulated and created more easily.  I
would love to see the parts of the file broke out in the database and not
just using a single text blob, though.

Also, setting up identical-enough is fairly trivial, especially if most of
the layers are already coming from a database, or known cache of shapefiles.

Jim

On Wed, Aug 12, 2015 at 9:13 AM, Andrea Peri aperi2...@gmail.com wrote:

 I don't guess is more flexible.
 Infact usually the teting environment is never exactly exals to the
 publish environmnet.

 A file allw to open and correct the paths from develop and publish
 environment.
 Also the svg symbols could be not exactly with the same path from
 develop and publish environment.

 So having a same project in a db is more complex becasue need to have
 two environment exactly the same.
 And this is not possible.
 .

 I guess the db storing for project could be more flexible only if the
 paths to the layers and relative paths of svg was not stored in the
 project file but instead in other files.

 My 2ct.

 A.


 2015-08-12 15:06 GMT+02:00 lars lingner gislars+l...@gmail.com:
  Hello,
 
  I'm looking for a solution for storing QGis project files (qgs) in a
  PostgreSQL database. Storing the files in a table isn't actually the
  problem, but getting it out and feeding it to QGis server.
 
  Did anyone had this need already? Would this be a good idea?
 
  In my use case the project files are generated, based on a default
  project file. Having the file in the DB would give more flexibility.
 
  Since saving the style in DB is already supported by QGis, I'm just
  curious of opinions of other users or developers.
 
  Thanks in advance for any feedback
 
  Lars
  ___
  Qgis-user mailing list
  Qgis-user@lists.osgeo.org
  http://lists.osgeo.org/mailman/listinfo/qgis-user



 --
 -
 Andrea Peri
 . . . . . . . . .
 qwerty àèìòù
 -
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Slow to open huge rasters

[James Keener]

Spinning disks can be significantly slower than an SSD :( However, I've
opened 10GB, 3-band rasters off spinning platter disks in seconds, so :-\
Some calculations on band cutoffs and things can take a while if I ask it
to calculate those.

On Thu, Jul 30, 2015 at 9:50 AM, Nicolas Cadieux 
nicolas.cadi...@archeotec.ca wrote:

 Hi,

 I have been opening rasters that are much bigger than that lately with no
 trouble at all. It does take some time but not hours. I have bigger file
 (80-300GB) but with one band only. I do use a SSD to help out but works
 with a usb3 drive also.

 The obvious is to check for to see if there is a problem with the hardware
 (memory, CPU, drive) and to make sure you are not opening the file from a
 file server (a virtual drive) but from a local hard drive (not a USB key)
 or a failing HD.

 Try zooming on the zone using a small polygons as a reference, before
 opening the raster.  Try disabling the screen render before opening the
 raster (right lower corner or Option\Rendering\Rendering behavior.

 An other potential problem is the way the tiff was created.  If, for
 example the file was created with gdal-Grid (interpolation), then by
 default, the file was created with an origin from the bottom-left and not
 upper-left.

 Try resaving the file in QGIS.  Try using the QGIS usual method of saving
 rasters and also try using gdal-warp with no parameters
 (raster/projections/warp) (that with change the file origin) then reopen
 the file.

 Nicolas Cadieux M.Sc.
 Les Entreprises Archéotec inc.
 8548, rue Saint-Denis Montréal H2P 2H2
 Téléphone: 514.381.5112  Fax: 514.381.4995
 www.archeotec.ca
 On Jul 30, 2015 7:49 AM, Radim Blazek-2 [via OSGeo.org]  [hidden email]
 http:///user/SendEmail.jtp?type=nodenode=5217781i=0 wrote:

 On Thu, Jul 30, 2015 at 11:36 AM, Andrea Peri a
 href=/user/SendEmail.jtp?type#61;nodeamp;node#61;5217747amp;i#61;0[hidden
 email] wrote:
  Hi Radim,
  thx for hint.
 
  I try to set the contrast enhancement to NO STRETCH
  and
  Limits to minimum / maximum ,
  Apparently seem to have no result. The qgis is locked in opening of
  raster, but of course I should wait for some hours to see if some
  improvements is occursed.

 You can try to uncheck Options  Canvas  Legend  Layer Legend 
 Create raster icons
 but I don't think that it could help if zoom/pan is fast, so it seems
 that there are overviews (pyramids). In fact, even with cumulative cut
 it should not be slow if there are overviews because default cut
 calculation is using estimated histogram (25 pixels).

 The file is on local hard disk?

 Do you see what is happening from debug output?

 If you save a project with the raster, the next load of the project is
 fast?

 Radim


  A.
 
 
  2015-07-30 9:52 GMT+02:00 Radim Blazek a
 href=/user/SendEmail.jtp?type#61;nodeamp;node#61;5217747amp;i#61;1[hidden
 email]:
  On Thu, Jul 30, 2015 at 9:19 AM, Andrea Peri a
 href=/user/SendEmail.jtp?type#61;nodeamp;node#61;5217747amp;i#61;2[hidden
 email] wrote:
  Hi,
 
  I have a GeoTiff raster of 24Gbyte, floating point (Float64) with 11
  bands and fomat geotiff.
 
  When try to open it with qgis 2.8.1 I see it take a really uge time to
  open it (about 10 hours).
  Initially I guess that was a time due to the huge dimension, but after
  the qgis show it.
  I notice that it is reallyquickly to zoom and pan.
  I don't understand why this difference between the open time and
 zoom/pan time.
 
  My first suspect was that qgis want to calculate the statistics in
 first open.
  But after a check with gdalinfo I see the statistics are available
  also in original tiff.
 
  QGIS defaults are stretch to 2/98% cut, try to set in
  Options  Rendering  Rasters
  Contrast enhancement: No stretch  or  Limits: Minimum / maximum
 
  Radim
 
 
  So I dont know really why it take so more time to open it.
 
  I hope to find some setting to reduce the pen time for this kind of
 images.
 
  Thx,
 
  A.
 
  --
  -
  Andrea Peri
  . . . . . . . . .
  qwerty àèìòù
  -
  ___
  Qgis-user mailing list
  a
 href=/user/SendEmail.jtp?type#61;nodeamp;node#61;5217747amp;i#61;3[hidden
 email]
  http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
 
  --
  -
  Andrea Peri
  . . . . . . . . .
  qwerty àèìòù
  -
 ___
 Qgis-user mailing list
 a
 href=/user/SendEmail.jtp?type#61;nodeamp;node#61;5217747amp;i#61;4[hidden
 email]
 http://lists.osgeo.org/mailman/listinfo/qgis-user

 --
  If you reply to this email, your message will be added to the discussion
 below:

 http://osgeo-org.1560.x6.nabble.com/Slow-to-open-huge-rasters-tp5217691p5217747.html
  To start a new topic under Quantum GIS - User, email
 ml-node+s1560n4125267...@n6.nabble.com
 To unsubscribe from Quantum GIS - User, a href=
 

Re: [Qgis-user] Question on default file formats

[James Keener]

More tools support it. Spatialite wasn't supported in esri until very recently 
and other tools may not support anything but shape files. It's become a lingual 
franca, and like English: it's terrible, but works well enough.

Jim

On July 28, 2015 11:38:24 AM AST, Árni Geirsson a...@alta.is wrote:
Hello
I find it interesting that the ancient shapefile format is (or at least
appears to be) the default file format for QGIS when SpatiaLite seems
to be
a much more capable format. I have been using mostly shapefiles and
when
using for example the tools under the vector menu, intermediate results
are
saved as shapefiles, leading to a big pile of files after a short
session
of vector processing. Now, I have discovered that by using the
processing
tools the intermediates can be temporary files (still shapefiles, just
hidden away in a temporary folder). After saving a temporary file as a
SpatiaLite file, I can enter field names longer than 10 characters but
I
can not add a text field that accommodates more than 255 characters.
So my question is: Why is the shapefile format the default?

I have also noticed that with 2.10 I can save in Geopackage format.
Does
that mean that support for this format has improved?

Any insights are highly appreciated.

Arni Geirsson




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] TIGER projection question

[James Keener]

This has been bothering me for days and I think I realize why: It's
valid on the outside of the rectangle and the marker in the middle isn't
to denote which part is valid, it's just the center of the map (I'd
never actually tried to move those maps until just now, and it moves
when you move the map).

Is that the correct interpretation?

Sorry for the double email.

Jim

On 07/26/2015 11:03 AM, James Keener wrote:
 http://gis.stackexchange.com/questions/27702/what-is-the-srid-of-census-gov-shapfiles
 claims that the projection is EPSG 4269, however the map at
 http://spatialreference.org/ref/epsg/4269/ shows the projection as
 not valid for North America.
 
 Am I not reading the map at SpatialReference.org right? Is the map there
 wrong? Is this not the correct projection for the TIGER files?
 
 Thanks,
 Jim
 
 
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Maps over multiple projected coordinate systems

[James Keener]

If I want to use a PCS to do distance calculations over a large area.
For instance, lets say I want to calculate a 650km buffer around
Pittsburgh, Pa.  The buffer would go outside the state plane for
Pittsburgh and outside the UTM zone. I decided to punt and just put
everything in UTM Zone 17N and do the calculation that way, but I'm not
sure if that is the correct thing to do.

http://jimkeener.com/posts/projections if anyone wants to see what I'm
talking about or would be kind enough to give me feedback on the post
(especially to point out if I'm wrong anywhere in it).

In QGIS can't figure out how to create a buffer not in the native units
of the projection the layer is part of. (i.e. a m-based buffer with GCS).

Any help is appreciated.

Jim



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] TIGER projection question

[James Keener]

http://gis.stackexchange.com/questions/27702/what-is-the-srid-of-census-gov-shapfiles
claims that the projection is EPSG 4269, however the map at
http://spatialreference.org/ref/epsg/4269/ shows the projection as
not valid for North America.

Am I not reading the map at SpatialReference.org right? Is the map there
wrong? Is this not the correct projection for the TIGER files?

Thanks,
Jim





signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Ubuntu: qgis_mapserv.fcgi doesn't load

[James Keener]

That is a message from the mapserver.  Do you have any qgs file in the
directory with it?

Jim

On Thu, Jul 16, 2015 at 10:42 AM, Kavita Chitnis kvchit...@gmail.com
wrote:

 I am trying to install QGIS on Ubuntu 15.04 by following the steps
 mentioned in the link
 http://anitagraser.com/2012/03/30/qgis-server-on-ubuntu-step-by-step/

 After the confutation, I see the following-

 http://localhost/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMSVERSION=1.3.0REQUEST=GetCapabilities

 Returns an HTML with 'This XML file does not appear to have any style
 information associated with it. The document tree is shown below.'

 http://localhost/cgi-bin/vienna/qgis_mapserv.fcgi

 The above link returns-
 This XML file does not appear to have any style information associated
 with it. The document tree is shown below.
 ServiceExceptionReport xmlns=http://www.opengis.net/ogc; version=1.3.0
 
 ServiceException code=Service configuration errorService unknown or
 unsupported/ServiceException
 /ServiceExceptionReport


 Can someone please help me with the configuration?

 Thanks,
 Kavita


 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS Ubuntu: qgis_mapserv.fcgi doesn't load

[James Keener]

I'll have to check when I get home.  I ran into this issue before as well.


http://localhost/cgi-bin/vienna/qgis_mapserv.fcgi if you go there, you will
get the error about the unsupported service (since you're not telling it a
service).

What does
http://localhost/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMSVERSION=1.3.0REQUEST=GetCapabilities
 or
http://localhost/cgi-bin/vienna/qgis_mapserv.fcgi?SERVICE=WMSVERSION=1.3.0REQUEST=GetCapabilities
return?

Jim

On Thu, Jul 16, 2015 at 10:54 AM, Kavita Chitnis kvchit...@gmail.com
wrote:

 Hi Jim,

 Thank you for responding. I have created a project called Vienna under my
 cgi-bin.

 kchitnis:~$ ls -l /usr/lib/cgi-bin/vienna/
 total 156
 -rwxrwxrwx 1 root root 158926 Jul 15 16:16 OSP_Laterals.qgs
 lrwxrwxrwx 1 root root 20 Jul 15 16:15 qgis_mapserv.fcgi -
 ../qgis_mapserv.fcgi
 lrwxrwxrwx 1 root root 19 Jul 15 16:15 wms_metadata.xml -
 ../wms_metadata.xml

 kchitnis:~$ ls -l /usr/lib/cgi-bin/
 total 1132
 -rw-r--r-- 1 root root 666 Apr 11 13:53 admin.sld
 -rwxr-xr-x 1 root root 1142352 Jun 28 03:32 qgis_mapserv.fcgi
 -rw-r--r-- 1 root root 588 Apr 11 13:53 schemaExtension.xsd
 drwxrwxrwx 2 root root4096 Jul 15 16:16 vienna
 -rw-r--r-- 1 root root1488 Apr 11 13:53 wms_metadata.xml


 On Thu, Jul 16, 2015 at 10:44 AM, James Keener j...@jimkeener.com wrote:

 That is a message from the mapserver.  Do you have any qgs file in the
 directory with it?

 Jim

 On Thu, Jul 16, 2015 at 10:42 AM, Kavita Chitnis kvchit...@gmail.com
 wrote:

 I am trying to install QGIS on Ubuntu 15.04 by following the steps
 mentioned in the link
 http://anitagraser.com/2012/03/30/qgis-server-on-ubuntu-step-by-step/

 After the confutation, I see the following-

 http://localhost/cgi-bin/qgis_mapserv.fcgi?SERVICE=WMSVERSION=1.3.0REQUEST=GetCapabilities

 Returns an HTML with 'This XML file does not appear to have any style
 information associated with it. The document tree is shown below.'

 http://localhost/cgi-bin/vienna/qgis_mapserv.fcgi

 The above link returns-
 This XML file does not appear to have any style information associated
 with it. The document tree is shown below.
 ServiceExceptionReport xmlns=http://www.opengis.net/ogc; version=
 1.3.0
 ServiceException code=Service configuration errorService unknown or
 unsupported/ServiceException
 /ServiceExceptionReport


 Can someone please help me with the configuration?

 Thanks,
 Kavita


 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Live DVD advice

[James Keener]

Could you use QGIS Server?  It'd take a qgs file and the data it needs
(which can be any input type QGIS uses, including shapefiles and
spatialite dbs along with PostGIS).

Jim

On 06/27/2015 07:46 PM, Brent Wood wrote:
 Hi,
 
 I'm looking to build a LiveDVD/USB key with QGIS, OSM base layer and web
 services for New Zealand.
 
 Our road  topo data is very up to date in OSM, and we have numerous
 government (central, regional  local) agencies and others providing
 data via OGC services, so I'm hoping the system will have embedded OSM,
 and pre-loaded OGC servers to connect to, as well as some QGIS plugins
 specific to New Zealand.
 
 The disk/key is intended for schools  demonstrations showing FOSS, FOSS
 GIS, Open Data and Open Standards, focused on NZ data.
 
 Some years ago I built a laptop system demo'ed at several local schools
 which worked OK, with mapserver serving OSM via WMS direct from Postgis.
 NZ is small enough that the data could be rendered dynamically from the
 vector data in a reasonably interactive system.
 
 I can't reasonably use Postgis on a read only filesystem, and all the
 later guides assume that tiles will be used. Does anyone have any advice
 as to how I might best do this?
 
 Thanks,
 
 Brent Wood
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Live DVD advice

[James Keener]

Ah, if you're already using mapserver, I'd see about just exporting the
PostGIS db as a shapefile.  Are you worried it'll be too large/too slow?

Also, the OSM styles are available as CartoCSS, which is supported by
other tilers too.

Jim

On 06/27/2015 08:13 PM, Brent Wood wrote:
 Thanks James,
 
 I have looked at
 http://docs.qgis.org/2.8/en/docs/user_manual/working_with_ogc/ogc_server_support.html?highlight=server
  
 which seems like it would work - but I'd still need to avoid Postgis as
 the data source (read only filesystem) and sort out the rendering styles
 for use with QGIS - it may be possible to export the OSM Postgis tables
 as shapefiles  use those as the data source, but I don't know how to go
 about adapting the rendering styles, which is a large part of the value
 of OSM - data plus style.
 
 Cheers,
 
   Brent
 
 *From:* James Keener j...@jimkeener.com
 *To:* Brent Wood pcr...@pcreso.com; Qgis-user List
 qgis-user@lists.osgeo.org; Mapserver-users
 mapserver-us...@lists.osgeo.org; OSGeo Discussions
 disc...@lists.osgeo.org; Nzopengis nzopen...@googlegroups.com;
 Live-demo live-d...@lists.osgeo.org
 *Sent:* Sunday, June 28, 2015 11:52 AM
 *Subject:* Re: [Qgis-user] Live DVD advice
 
 Could you use QGIS Server?  It'd take a qgs file and the data it needs
 (which can be any input type QGIS uses, including shapefiles and
 spatialite dbs along with PostGIS).
 
 Jim
 
 
 
 On 06/27/2015 07:46 PM, Brent Wood wrote:
 Hi,

 I'm looking to build a LiveDVD/USB key with QGIS, OSM base layer and web
 services for New Zealand.

 Our road  topo data is very up to date in OSM, and we have numerous
 government (central, regional  local) agencies and others providing
 data via OGC services, so I'm hoping the system will have embedded OSM,
 and pre-loaded OGC servers to connect to, as well as some QGIS plugins
 specific to New Zealand.

 The disk/key is intended for schools  demonstrations showing FOSS, FOSS
 GIS, Open Data and Open Standards, focused on NZ data.

 Some years ago I built a laptop system demo'ed at several local schools
 which worked OK, with mapserver serving OSM via WMS direct from Postgis.
 NZ is small enough that the data could be rendered dynamically from the
 vector data in a reasonably interactive system.

 I can't reasonably use Postgis on a read only filesystem, and all the
 later guides assume that tiles will be used. Does anyone have any advice
 as to how I might best do this?

 Thanks,

 Brent Wood
 


 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 

 
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] mrsid qgis 2.8 and ubuntu 14.04

[James Keener]

I've not used it as a gdal plugin and in the past have simply converted
my data into a more standard format:

http://jimkeener.com/posts/orthoimagery

Have you followed the steps you've linked to? Did either the
gdal-build-mrsid or gdal-mrsid-build work?

Jim

On 06/26/2015 01:43 PM, Chris House wrote:
 Hi all,
 
 I'm trying to find some updated instructions for adding MrSid support
 for QGIS 2.8 on Ubuntu 14.04.  I started following the instructions from
 here:
 
 https://trac.osgeo.org/ubuntugis/wiki/TutorialMrSid
 
 However, I'm hung up on the instructions where you do the build.  I
 downloaded the following mrsid sdk from Lizardtech and extracted it.
 
 MrSID_DSDK-9.1.0.4045-linux.x86-64.gcc44.tar.gz
 
 The readme specifically says no real installation is necessary
 
 Can someone point me to some updated instructions on how to get mrsid
 support in QGIS 2.8?
 
 Thanks!
 
 Chris
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] labelling by attribute

[James Keener]

Andreas,

Thank you very much for your feedback!

Jim



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] labelling by attribute

[James Keener]

 0.00xx percent of what ESRI has available in its budget.
 And have an amazing piece of software to show for it!
 
 Thanks we try our best. 

But seriously, I've shown people who've only used Arc QGIS and they love
it!  They find the interface easier to understand and use, and some of
them also really latch onto the idea of it being F/OSS (beer AND
speech)!  I only hope that at some point I have enough that I can give
back.  QGIS is amazing and may be in the process of changing the flow of
my life (more on that in a few months if this works ::fingers crossed::).

 For the import we will probably use a library called
 Teigha - the same library also used by ESRI, Bricscad, Intergraph and
 many others. We will have to join the OpenDesignAlliance to get access
 to this library and pay a yearly membership fee - we still have to
 investigate which level of membership we need as an open source project.
 It is clear that the DWG import is harder than the DXF export, but the
 Teigha library will help a lot.

Not to argue, since I'm not the one doing the work (and it's a feature
that could help me out a bit!), but how does this mesh with GPLv2 and
the goal of being a F/OSS platform?

 In all seriousness, what would be the process of doing this?  Has this
 been done for any other QGIS features?  Who would be paid? OSG, specific
 developers?  Who would we talk to about something like this?
 
 yes - absolutely - it has been done before. Maybe 2/3 of the recent new
 features were introduced because of paid development, and there has been
 some co-financed and/or crowd-funded development efforts.

What's the process for going about this?  Let's say I want to start a
crowd funding campaign or fund a specific project.  Would I contact the
PSC and hash out the feasibility and funding requirements?

Jim



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] labelling by attribute

[James Keener]

 0.00xx percent of what ESRI has available in its budget.

And have an amazing piece of software to show for it!

 However, I agree with you, that rule-based or categorized labels would
 be very useful to have in QGIS. In fact we know this for a long time
 already - since version 2.0 people have asked for it. But - it is quite
 a lot of work to implement. If you need this, consider sponsoring it or
 start a crowd-funding initiative.

There was talk in another email thread about doing something similar for
AutoCAD support.

In all seriousness, what would be the process of doing this?  Has this
been done for any other QGIS features?  Who would be paid? OSG, specific
developers?  Who would we talk to about something like this?

Jim



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Local Government for QGIS

[James Keener]

 They feel as thought they are adhering to a standard - of course a
 standard put forth by a software company.

A proprietary software company with whom they have no reason to believe
their data from now will be accessible in 10 years, let along 50.

  Yes it's free but it's very professional.

A million times, yes. This is a message that's hard to get across.

 Well - we seem to have started something - question is where do we go
 next with this?

Does the OSGeo group have a local governments sub-group? (I didn't see
one, I wonder if there would be interest in creating one. If not, I
still think we should create one, and I would be willing to fund the
domain, site and forum hosting, mailing lists, c  at first.) It seems
to be a tech-focused organization and I wonder if they would they would
be interested in forming a group dedicated to ... ?

What should we be dedicated to? (Also, I'm using F/OSS as a catch all, I
realize we might want to trim it to OSG or something else).

Main Goal: To increase the usage of F/OSS software by government.

I say that with the subtext of legitimizing the use of F/OSS by
governments, i.e. show them others who are using it, show them standards
they can point to and justify themselves by, and show them that being
beholden to software corps isn't the only way to get support.

I would suggest the following actions to supporting that goal:

* Compiling standards that Governments can (be) point to (endorsing the
  (OGC standards)[http://www.opengeospatial.org/standards]?)
* Compiling software that Governments can (be) pointed to (QGIS,
  PostGIS, GDAL, c)
* Compiling case-studies done with F/OSS
* Compiling white papers around using F/OSS
* Improve the documentation and tutorials of recommended software
* Work towards creating standards as needs arise
* Provide a starting point for Governments to network with
  * Other governments using F/OSS
  * Vendors of F/OSS-based services (I'd be OK if this was left out,
though it could be useful depending on our exact goals)

Thoughts?
Jim Keener

On 06/12/2015 09:11 AM, Randal Hale wrote:
 In the states it's all ESRI all day.
 
 A few small governments might try to run in a FOSS4G direction but it's
 rare. In the Southeast they go what is the next town over doing? we
 will do the same thing. The models that ESRI provide are tempting for
 many because suddenly everyone is doing the exact same thing. So with no
 thought - Gov't A can share with Gov't B. They feel as thought they are
 adhering to a standard - of course a standard put forth by a software
 company.
 
 My business is swinging in a more foss4g direction although I still use
 ESRI software as many of my customers do - but it's getting rare. So
 rare I opted to not renew my ESRI licensing this year. Many of my
 clients are versions back so I can sit on 10.2 for a while. I still get
 well that free stuff can't be that good but I'm slowly winning over
 clients as They are getting very good data with qgis/postgis and the
 word is spreading. Yes it's free but it's very professional.
 
 Well - we seem to have started something - question is where do we go
 next with this?
 
 Randy
 
 
 
 On 06/12/2015 04:34 AM, Andreas Neumann wrote:
 Hi Steve,

 Thank you for raising this important discussion.

 In some European countries the situation is a bit different and Open
 Source solutions are gaining an increasing market share. I live and
 work in Switzerland - and while the majority of the markets still uses
 ESRI products - there is an increasing number of provinces who also
 increasingly use Postgis, QGIS, OpenLayers, etc - sometimes
 exclusively and sometimes side by side with proprietary software.

 I also think that the next couple of years we will see an increasing
 number of governmental organisations introducing OpenSource GIS side
 by side with commercial GIS and will gradually shift more and more
 applications to FOSSGIS.

 Some examples in Switzerland:

 * The national mapping portal runs exclusively on OS software
 (Postgis, OpenLayers, and some more) - it runs very well, fast and is
 very popular - production of the data is still done exclusively in ESRI
 * 2 provinces in Switzerland run exclusively in FOSSGIS, about 7 and 8
 additional provinces introduced FOSSGIS side by side with commercial
 products
 * several cities and water/gaz providers are currently migrating to
 FOSSGIS to document utility networks
 * The austrian province Vorarlberg introduced several hundred
 installations of QGIS as the main GIS in their administration
 * several Scandinavian countries/provinces/cities are already using
 FOSSGIS on both Desktop GIS and web mapping

 The list would be much longer - but things are moving slowly and
 steadily to more FOSSGIS usage in Europe - at least I can tell

 There are two other interesting points:

 * in my opinion - it is not so much about money - but about different
 values: the ability to more easily influence the direction of the
 software, support of 

Re: [Qgis-user] map with specific information for particular POIs

[James Keener]

You could create a new point layer and add attributes for phone number,
person in charge, c.  Then you can add points and the associated
metadata to the map.

Did you intend for this to be internal or public facing in the end?

Jim

On 06/01/2015 02:35 AM, Kevin Suhr wrote:
 Hi Folks
 
 My company is planning to start working with QGIS. Therefore, we have one 
 crucial question to be answered. As we organize sports events such as 
 Marathons and others, we would like to display all the checkpoints, e.g. for 
 emergencies, safety, spatially. Internally, we need maps with information 
 such as person in duty, phone number, or necessary material etc for each of 
 those POI. 
 
 Is this particular form of maps possible to create with QGIS and how would 
 this be managed?
 
 I have some experience in ArcGIS as I have been studying geography for a few 
 years. But this particular software would be way too expensive for my company.
 
 Thank you very much for your advice and best wishes,
 Kevin
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] How to assign geographical objects to records and find records that have no geographical object

[James Keener]

If you can't get record order to be the same, you can assign each an id and 
join on it.

I haven't yet attempted to copy-paste attributes between tables. You may have 
to add the expected columns to the destination shapefile though.

I'm not at a computer at the moment, but I wonder if there is a plugin to help 
with this. (Or how hard it'd be to write one?)

Jim

On May 27, 2015 8:40:12 AM EDT, Randal Hale rjh...@northrivergeographic.com 
wrote:
One way to go about doing it is to make a shapefile and place a point. 
Make sure that point has an attribute that relates to your table.

  * You table has a record field so your shapefile has a record field.
  * record 1 corresponds to point 1

If you add data to QGIS and Right click on it (in the layers window)
you 
can open the properties. From there you can Join (7 menu items down on 
the left) data together.

I hope that helps some.

Randy


On 05/27/2015 07:51 AM, Jens Verwaerde wrote:
 I've imported a table with records and would like to add geographical

 points to the records.

 In Mapinfo, one can have the table data open and the map and click on

 a record (in the table) and afterwards on a location in the map, so 
 that a geographical object (a point) is attached to the record.
 Afterwards, it is quite easy to look for records that haven't yet
have 
 any geographical objects attached to them.


 1 -- how can I interactively assign geographical objects to a record 
 table in qgis
 2 -- how can I look for records in the table that do not yet have 
 related geographical objects?




 .
 /./
 /Jens Verwaerde/
 ​Biologist
 Natuurpunt
 www.natuurpunt.be http://www.natuurpunt.be​



 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
-
Randal Hale
North River Geographic Systems, Inc
http://www.northrivergeographic.com
423.653.3611 rjh...@northrivergeographic.com
twitter:rjhale http://about.me/rjhale
http://www.northrivergeographic.com/introduction-to-quantum-gis
Southeast OSGEO: http://wiki.osgeo.org/wiki/Southeast_US





___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] failed - OpenStreetMap import

[James Keener]

Can you provide more information on what you did and what plugins you
were using, if any?

Jim

On 05/26/2015 12:27 AM, K Imran M wrote:
 Hi,
 
 When I try to create the SpatialLite DB file, I receive this error 
 'failed to import OSM data: database file cannot be overwritten'
 What I have done wrong and how can I correct this?
 
 Thanks
 
 Kamarul 
 
 -- 
 Dr. Kamarul Imran Musa,
 M.D. M.Community.Med.
 Associate Professor (Epidemiology and Biostatistics)  
 Public Health Physician
 Dept of Community Medicine
 School of Medical Sciences
 16150 Universiti Sains Malaysia, Kbg Kerian
 Kelantan
 Thomson Reuters researchID: http://www.researcherid.com/rid/G-4864-2010
 Google-scholar: 
 http://scholar.google.co.uk/citations?user=aZyayMgJhl=enauthuser=1
 blog: http://designdataanalysis.wordpress.com
 http://designdataanalysis.wordpress.com/   
 email : drkama...@usm.my
 mailto:drkama...@kb.usm.my , k.m...@lancaster.ac.uk
 mailto:k.m...@lancaster.ac.uk
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Security aigainst spyware certificate

[James Keener]

Is SQGIS a specific build?

Additionally, what kinds of certification would your boss be looking
for? (I've never seen one _I_ found trustworthy, as they all look a
little scammy, but that's just me.) Are Chrome and Firefox certified
(or are you guys using Internet Explorer ::shudder::)?

Depending on exactly what your boss is looking for, you could point to
the support by the OSGeo Foundation a 503(x)4 in the US and to other
governments who use QGIS (some from Denmark:
http://www.qgisforum.org/qgis-tutorial/who-uses-qgis)

Aside: Would you be able to use any plugins in this situation? Would you
be able to update (for either feature or security reasons?)

Best of luck!

Jim

On 05/21/2015 05:38 AM, BLANC Damien (ECHO Dakar) wrote:
 Dear All,
 
 Would you know if SQGIS has been granted an external certificate against
 spyware? My boss would like to have something of the kind to allow me to
 install it on my office computer. He is afraid the SQGIS installation
 may breach the security of the network of the office.
 
  
 
 Thank you!
 
  
 
  
 
 *Damien BLANC*
 
 */Coordinateur Réponse Rapide et Expert Eau Hygiène et Assainissement/*
 
 */Bureau Régional de l’Afrique de l’Ouest/*
 
 /Direction Générale de l’Aide Humanitaire et de la Protection Civile (ECHO)/
 
 /Commission Européenne/
 
 /Route des Almadies/
 
 /Dakar/
 
 /Sénegal/
 
 Tel : +221 338 698 008
 
 Mob : +221 776 394 168
 
  
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Calling OSM as a Base Layer in Geoserver

[James Keener]

Open layers has many good tutorials (on my phone so I can't kink right now). 
While it is JavaScript, it isn't a lot and you shouldn't need to modify the 
tutorial too much of you just want to overlay layers.

Jim

On May 16, 2015 8:10:01 AM EDT, abhijit.ekb...@gmail.com wrote:
‎Hi

I know this is not very specific to QGIS, but I thought of asking it
here as I am sure someone out there would be able to help. 

I have published a lot of layers created in QGIS through GeoServer. I
now need to have a OSM Base Layer under some of my vector layers. How
can one do that? I am not good with javascript, but familiar with html
and css‎.


Cheers

Abhijit





___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Lizmap Web Client

[James Keener]

I've had luck using the QGIS server[1] on the back and
QGIS-Web-Client[2], MapBender[3], and generic OpenLayers[4] on the front
end.

QGIS server uses the qgs project files and the same rendering engine as
QGIS, so things will look as awesome as they do in QGIS.


I'm not sure if it's proper for this list, but if you decide to look for
someone to set the server and web client up on contract, feel free to
contact me directly.

Jim Keener
j...@jimkeener.com

[1] http://hub.qgis.org/projects/quantum-gis/wiki/qgis_server_tutorial
[2] https://github.com/qgis/QGIS-Web-Client
[3] http://mapbender3.org/
[4] http://dev.openlayers.org/examples/wms.html

On 05/13/2015 01:47 PM, John Rose wrote:
 Hello,
 
 I am working within a Franco-senegalese team to develop a GIS covering
 the Niokolo-Koba National Park in Senegal. We have updated the OSM data
 for the Park and entered it into QGIS as the beginning of our GIS. QGIS
 works great for generating printable maps of the area.
 
 Now we would like to find a way to make our maps available interactively
 on the web (initially pure OSM data, but we will be adding additional
 data, for example of wildlife location). At first we thought of LizMap
 Web Client, but it seems that this is not really a web user client but
 rather a web server client which we could not readily install on our
 commercial host.
 
 At the moment we do not have a computer specialist on our team. Sorry
 for our ignorance but could someone advise whether it would be possible
 with QGIS to generate files which could be readily used to provide
 interactive map access on a basic web server (perhaps using a plugin at
 the navigator end)? We would really rather use the map presentation
 parameters we have already developed for QGIS, than to start over with
 another approach like Mapnik.
 
 Thanks and best regards,
 
 John
 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] base maps

[James Keener]

Would you be able to import the OpenStreetMaps data and manipulate it as
you wish if you chose not to use the default OSM layer as your basemap?

Jim
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Spatial Query with buffer?

[James Keener]

What's your data source? If it's PostGIS a query could do that in a mostly 
straightforward way.

Jim

On May 6, 2015 10:32:38 AM EDT, Joris Hintjens joris...@gmail.com wrote:
Hello,
I want to do a spatial query.
Which Polygones intersect with a series of points,... That is easy with
the
spatial query plugin.
BUT: Which polygones intersect with a buffer of X around my points...
How
can I do that without creating a new layer where I buffer my points?
My points are not static, they change often, so creating a buffer layer
would require also an update of the buffer layer. Too complicated (and
source of errors!) to my taste...

All suggestions welcome.

Joris




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Spatial Query with buffer?

[James Keener]

Ah! Good point! I forgot that spatialite can handle complex queries.

For reference, Jorish, spatialite is a sqlite database with geospatial support. 
Sqlite is a (really super cool) library that supports single file databases 
that can be queried via SQL.

Jim

On May 6, 2015 11:50:43 AM EDT, David Fawcett david.fawc...@gmail.com wrote:
If you don't have an easy way to set up PostGIS, you could use QGIS to
save
your data in a SpatiaLite database, and then write a spatial query
against
that.

On Wed, May 6, 2015 at 10:42 AM, DelazJ del...@gmail.com wrote:

 Hi,
 May be you can use the graphical modeler of Processing to design your
 process. Processing offers both spatial selection and buffer tools.

 2015-05-06 17:08 GMT+02:00 Joris Hintjens joris...@gmail.com:

 All my data is in shape.
 Have a look at postgis is on my urgent to do list. Never worked with
 postgis until now



 2015-05-06 16:37 GMT+02:00 James Keener j...@jimkeener.com:

 What's your data source? If it's PostGIS a query could do that in a
 mostly straightforward way.

 Jim

 On May 6, 2015 10:32:38 AM EDT, Joris Hintjens joris...@gmail.com
 wrote:

 Hello,
 I want to do a spatial query.
 Which Polygones intersect with a series of points,... That is easy
with
 the spatial query plugin.
 BUT: Which polygones intersect with a buffer of X around my
points...
 How can I do that without creating a new layer where I buffer my
points?
 My points are not static, they change often, so creating a buffer
layer
 would require also an update of the buffer layer. Too complicated
(and
 source of errors!) to my taste...

 All suggestions welcome.

 Joris

 --

 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user


 --
 Sent from my Android device with K-9 Mail. Please excuse my
brevity.



 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user



 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user





___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Spatial Query with buffer?

[James Keener]

Sorry about the extra H in your name.  I saw your email and didn't look
at your signature.

Jim

On 05/06/2015 11:50 AM, David Fawcett wrote:
 If you don't have an easy way to set up PostGIS, you could use QGIS to
 save your data in a SpatiaLite database, and then write a spatial query
 against that.
 
 On Wed, May 6, 2015 at 10:42 AM, DelazJ del...@gmail.com
 mailto:del...@gmail.com wrote:
 
 Hi,
 May be you can use the graphical modeler of Processing to design
 your process. Processing offers both spatial selection and buffer tools.
 
 2015-05-06 17:08 GMT+02:00 Joris Hintjens joris...@gmail.com
 mailto:joris...@gmail.com:
 
 All my data is in shape.
 Have a look at postgis is on my urgent to do list. Never worked
 with postgis until now
 
 
 
 2015-05-06 16:37 GMT+02:00 James Keener j...@jimkeener.com
 mailto:j...@jimkeener.com:
 
 What's your data source? If it's PostGIS a query could do
 that in a mostly straightforward way.
 
 Jim
 
 On May 6, 2015 10:32:38 AM EDT, Joris Hintjens
 joris...@gmail.com mailto:joris...@gmail.com wrote:
 
 Hello,
 I want to do a spatial query.
 Which Polygones intersect with a series of points,...
 That is easy with the spatial query plugin.
 BUT: Which polygones intersect with a buffer of X around
 my points... How can I do that without creating a new
 layer where I buffer my points?
 My points are not static, they change often, so creating
 a buffer layer would require also an update of the
 buffer layer. Too complicated (and source of errors!) to
 my taste...
 
 All suggestions welcome.
 
 Joris
 
 
 
 
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
 -- 
 Sent from my Android device with K-9 Mail. Please excuse my
 brevity.
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org mailto:Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Problem with loading layers from a project

[James Keener]

I'm trying to load a project via python (original project and the single
shp file (the extension should be .zip), along with the project after
saving, are attached).  When I load the project, there are no layers,
and if I write the project out, it doesn't contain the original layer
either.

Python transcript:
 jim@lilith {+81% } Fri 2015-05-01 01:16:00 0  
   
 
 /home/jim/Desktop/test
 % export PYTHONPATH=/usr/share/qgis/python
 jim@lilith {+82% } Fri 2015-05-01 01:16:02 0  
   
 
 /home/jim/Desktop/test
 % python  
 Python 2.7.6 (default, Mar 22 2014, 22:59:56) 
 [GCC 4.8.2] on linux2
 Type help, copyright, credits or license for more information.
 from qgis.core import QgsProject
 from PyQt4.QtCore import QFileInfo
 project = QgsProject.instance()
 project.read(QFileInfo('test.qgs'))
 True
 map(lambda i: i.name(), project.layerTreeRoot().children())
 []
 project.write()
 True

Before and After sizes:
 jim@lilith {+81% } Fri 2015-05-01 01:15:14 0  
   
 
 /home/jim/Desktop/test
 % ls -l test.qgs
 -rw-rw-r-- 1 jim jim 14222 May  1 01:15 test.qgs
 jim@lilith {+82% } Fri 2015-05-01 01:16:20 0  
   
 
 /home/jim/Desktop/test
 % ls -l test.qgs
 -rw-rw-r-- 1 jim jim 1654 May  1 01:17 test.qgs

I'm sure (or at least hope!) that I'm just doing something little (and
non-obvious?) wrong.

As an aside: this is a condensed test.  If you add a group into the
project, the group will show up in the layer list and will be written
back out, but no other layers will be found.

Thank you,
Jim

PS:

contents of PYTHONPATH, in case I'm not using the right location

 jim@lilith {+90% } Fri 2015-05-01 01:28:05 0  
   
 
 /home/jim/Desktop/test
 % ls -l $PYTHONPATH 
 total 20
 drwxr-xr-x 2 root root 4096 Feb 26 10:46 console/
 drwxr-xr-x 6 root root 4096 Feb 26 10:46 owslib/
 drwxr-xr-x 7 root root 4096 Aug 20  2014 plugins/
 drwxr-xr-x 2 root root 4096 Feb 26 10:46 pyplugin_installer/
 drwxr-xr-x 2 root root 4096 Feb 26 10:46 qsci_apis/


I had seen somewhere about doing QgsApplication.initQgis(), so I gave
that a shot:

 % python
 Python 2.7.6 (default, Mar 22 2014, 22:59:56) 
 [GCC 4.8.2] on linux2
 Type help, copyright, credits or license for more information.
 from qgis.core import QgsApplication
 from qgis.core import QgsProject
 from PyQt4.QtCore import QFileInfo
 QgsApplication.setPrefixPath('/usr/share/qgis', True)
 QgsApplication.initQgis()
 project = QgsProject.instance()
 project.read(QFileInfo('test.qgs'))
 True
 map(lambda i: i.name(), project.layerTreeRoot().children())
 []

to no avail :(


test.qgs
Description: application/qgis-project


Hospitals.really-a-zip
Description: Zip archive


  
  

  
  
  
  

  +proj=longlat +datum=WGS84 +no_defs
  EPSG:4326
  3452


  false


  0
  255
  255
  255
  255
  255
  255


  2
  current_layer
  off
  0


  2
  true


  false

  



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS FreeBSD port and qgis-server

[James Keener]

GREP HARDER!

:) I was specifically referring to the FreeBSD port's Makefile. Ports
are a collection of source-based packages. Essentially, on your system
you get the base tools and Makefile and pkg-plist for every program.
Those files tell the base tools how to get a copy of the source, how to
set options in it, which other ports are needed to compile this one, c.

Rainer, the port maintainer, replied and said he was fixing the issue.

Jim

On 04/19/2015 05:07 AM, Jürgen E. Fischer wrote:
 Hi James,
 
 On Sun, 19. Apr 2015 at 01:02:23 -0400, James Keener wrote:
 I am interested in being able to use the qgis mapserver on FreeBSD 10.1.
 I enabled the mapserver option via `make config-recursive` and built the
 port via `make install`.  I cannot seem to find the fcgi executable in
 the build output or in the pkg-plist file. I see
 WITH_MAPSERVER:BOOL=TRUE being passed into CMakeCache.txt
 
 What plist file?  The only reference to WITH_MAPSERVER I find in master
 is 
 
 $ git grep WITH_MAPSERVER
 ChangeLog:* rename cmake option WITH_MAPSERVER to WITH_SERVER
 
 
 Jürgen
 
 
 
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 http://lists.osgeo.org/mailman/listinfo/qgis-user
 



signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS FreeBSD port and qgis-server

[James Keener]

Hello,

I am interested in being able to use the qgis mapserver on FreeBSD 10.1.
I enabled the mapserver option via `make config-recursive` and built the
port via `make install`.  I cannot seem to find the fcgi executable in
the build output or in the pkg-plist file. I see
WITH_MAPSERVER:BOOL=TRUE being passed into CMakeCache.txt

However, I did notice there is a WITH_SERVER:BOOL=FALSE so I changed
that to TRUE ands rebuilt and could find fcgi executable.

The Makefile refers to a QGIS_MAPSERVER variable in the plist file,
which I also couldn't find.  I added in a line to install the
qgis_mapserv.fcgi binary.

Are there any other files that I need for the fcgi server?

Also, I've copied the package maintainer on this email if, for some
reason, he's not already on this list.

Below are diffs of the changes that I made that may help along the
process of updating the port.

Thank you,
Jim Keener

% diff Makefile.new Makefile.orig
38c38
 OPTIONS_DEFINE=   GRASS POSTGIS PYTHON SERVER
---
 OPTIONS_DEFINE=   GRASS POSTGIS PYTHON MAPSERVER
81,82c81,82
 .if ${PORT_OPTIONS:MSERVER}
 CMAKE_ARGS+=  -DWITH_SERVER:BOOL=TRUE
---
 .if ${PORT_OPTIONS:MMAPSERVER}
 CMAKE_ARGS+=  -DWITH_MAPSERVER:BOOL=TRUE
86c86
 CMAKE_ARGS+=  -DWITH_SERVER:BOOL=FALSE
---
 CMAKE_ARGS+=  -DWITH_MAPSERVER:BOOL=FALSE

% diff pkg-plist.new pkg-plist.orig
4d3
 %%QGIS_MAPSERVER%%bin/qgis_mapserv.fcgi




signature.asc
Description: OpenPGP digital signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user