Re: [Qgis-user] joinning tables

[Szabo Szilard]

Dear Zoltan,
I had this kind of problem when I "hurt" the normal rules of field names
(i.e. using extra long field names bringing them directly from downloaded
TEIR tables); afterI correction them (shortening but I am not sure the
threshold), everything was fine. But You have correct and short field names
... my response is just a case study.

Best regards,
Szilard


2014-01-29 Siki Zoltan 

> Dear James,
>
> thanks for your answer.
> My data are available here:
> http://www.agt.bme.hu/gis/qgis/ods.zip
>
> You can find in the zip  a shapefile (megye_utf-8), and some spreadsheet
> files (ksh.ods, ksh.xlsx, ksh.csv) having the same data. All use utf-8 code
> page.
> Open megye_utf-8 and ksh.ods and make a join using "megye" and "Nev"
> columns. I get NULL data in all joined column.
> If ods or xlsx is not supported on your platform, you can use ksh.csv.
> If you join the two tables using "kod" (integer value) column, the result
> is OK.
> I tested it in 2.1, 1,7 and 1.8 on Linux and in 2.1 on Windows.
>
> Best Regards,
> Zoltan
>
> On Wed, 29 Jan 2014, James Wood wrote:
>
>  Zoltan,I don't know if someone has responded to you about this; I didn't
>> see any list posts. I am not seeing the same issue with textual joins in my
>> QGIS 2.0.1 install. If you want to provide me with your shapefile and your
>> join files, I'll be happy to test here.
>> Best Regards,James
>>
>>  Date: Sat, 25 Jan 2014 20:43:59 +0100
>>> From: s...@agt.bme.hu
>>> To: qgis-user@lists.osgeo.org
>>> CC: qgis-develo...@lists.osgeo.org
>>> Subject: [Qgis-user] joinning tables
>>>
>>>
>>> Dear List,
>>>
>>> I got into trouble joining tables in QGIS.
>>> When I try to join shape to a csv, ods or xlsx file using columns with
>>> textual data, it doesn't work. I get only NULL values in the joint
>>> columns.
>>> Using integer values the join works.
>>> Is it a feature or an error?
>>>
>>> Regards,
>>> Zoltan
>>> ___
>>> 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
>



-- 
Dr. Szilard SZABO
associate professor, head of department
Department of Physical Geography and Geoinformation Systems
University of Debrecen
http://www.mendeley.com/profiles/szilard-szabo/
Publications 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] joinning tables

[Siki Zoltan]

Dear James,

thanks for your answer.
My data are available here:
http://www.agt.bme.hu/gis/qgis/ods.zip

You can find in the zip  a shapefile (megye_utf-8), and some spreadsheet 
files (ksh.ods, ksh.xlsx, ksh.csv) having the same data. 
All use utf-8 code page.
Open megye_utf-8 and ksh.ods and make a join using "megye" and "Nev" 
columns. I get NULL data in all joined column.

If ods or xlsx is not supported on your platform, you can use ksh.csv.
If you join the two tables using "kod" (integer value) column, the result 
is OK.

I tested it in 2.1, 1,7 and 1.8 on Linux and in 2.1 on Windows.

Best Regards,
Zoltan

On Wed, 29 Jan 2014, James Wood wrote:


Zoltan,I don't know if someone has responded to you about this; I didn't see 
any list posts. I am not seeing the same issue with textual joins in my QGIS 
2.0.1 install. If you want to provide me with your shapefile and your join 
files, I'll be happy to test here.
Best Regards,James


Date: Sat, 25 Jan 2014 20:43:59 +0100
From: s...@agt.bme.hu
To: qgis-user@lists.osgeo.org
CC: qgis-develo...@lists.osgeo.org
Subject: [Qgis-user] joinning tables

Dear List,

I got into trouble joining tables in QGIS.
When I try to join shape to a csv, ods or xlsx file using columns with
textual data, it doesn't work. I get only NULL values in the joint
columns.
Using integer values the join works.
Is it a feature or an error?

Regards,
Zoltan
___
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] Organizing a US / North American User Group

[Alex Mandel]

On 01/22/2014 02:01 PM, Jeffrey Johnson wrote:
> I setup a quick google spreadsheet to collect emails in lieu of a
> mailing list for now.
> 
> https://docs.google.com/a/boundlessgeo.com/spreadsheet/ccc?key=0AishiXFd06bHdGl4ZE92Y09TbkU1TVBKTm8zMmNmZmc&usp=drive_web#gid=0
> 
> On Wed, Jan 22, 2014 at 12:50 PM, Jeffrey Johnson
>  wrote:
>> Hi Folks,
>>
>> It seems like a good time to get a US / North American User Group
>> going since there has been a serious uptick in interest in QGIS on
>> this side of the Atlantic. I've talked to quite a few people privately
>> about this, but figured now is the time to bring it to the wider user
>> community.
>>
>> So, my employer (Boundless Geo) would like to help organize an
>> inaugural User Group Meeting on April 11th, the day before the State
>> of the Map Conference in Washington DC. This seems like a good
>> opportunity to get everyone together when lots of spatially minded
>> people will be in town. The consensus is that we could arrange space
>> in the District during the day and have a happy hour nearby that
>> night.
>>
>> I'm not sure what the procedure is for organizing a User Group (or if
>> there even is one), but we can take on the tasks of setting up a
>> mailing list, website etc. If the PSC can let us know what hoops we
>> should jump through, or things we should think about, please let us
>> know. We will be reaching out to lots of people who are very excited
>> about QGIS but haven't really joined the community and try to get the
>> involved.
>>

There really isn't a procedure that I've seen. I think most people are
served by local user groups of FOSS or GIS origin. North America might
even be too big of a geographic area for what many traditionally call a
user group. I see a good role being to help ensure Birds of a
Feather/Local meets whenever good related conferences roll into town:
FOSS4G, FOSS4GNA, NACIS, State of the Map, URISA (e.g. WAURISA, CalGIS)
etc...

Note the comparison in the EU is the hackfests which is really a lot of
developers and power users getting together to work on QGIS.

>> Please contact me off-list if you are interested in helping with this
>> effort and as soon as we get a mailing list going I'll follow up with
>> a link here.
>>
>> Hoping to see some of you in DC in April!
>>
>> Jeff

My personal opinion is that beyond meetups coinciding with other confs,
and possibly organizing QGIS hackfests (can be user oriented) that most
other functions of such a group overlap either with QGIS' existing
infrastructure (e.g. do we really need our own mailing list since the
main QGIS ones are in English except to discuss regional events?) or
OSGeo chapters.

Guess I'm mostly hesitant about splitting the FOSS4G community
mindshare, I don't use QGIS in isolation and never would (unlike some
monolithic software packages), so to me leaving out Postgis, Spatialite,
GRASS, (Everything else in Processing) kinda misses the mark.

But I do get the notion that some things simplified can be more
attractive to a general audience (ie hook in the QGIS users out there
somehow).

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

Re: [Qgis-user] Print Composer - Rotation of Shapefiles with transparency

[Mike Flannigan]

I'd try this out for you, but I can't find the rotate capability
in "Project" - "New Print Composer".  Across from Rotation I have
Portrait and Landscape, but that is all.


Mike

Any chance you could answer this question below
that I posted 2 weeks ago?




Interestingly, I don't seem to have OSM plugin on
my version 2.0.1.  I don't see it under Installed
and I don't see it under Get more, though there is
an OSMEditorRemoteControl in the Get more tab.

How do I get it on ver 2.0.1 QGIS - Win64 version?

To start the Plugin Manager go to "Plugins" -
"Manage and Install Plugins".


Mike



On 1/28/2014 4:06 AM, qgis-user-requ...@lists.osgeo.org wrote:

Message: 8
Date: Tue, 28 Jan 2014 10:25:41 +0100
From: N St
To:qgis-user@lists.osgeo.org
Subject: [Qgis-user] Print Composer - Rotation of Shapefiles with
transparency
Message-ID:

Content-Type: text/plain; charset="iso-8859-1"

Hi List,

I try to rotate a map in the print composer and I have an awkward problem.
I wanted to check if I am alone in this case, or if it's a bug.

I work under Windows 7 64 Pro - QGIS is 2.0.1.

When I rotate a map in the print composer, shapefiles are cut at a right
angle (according to the north) if the transparency is not set at 0. If the
transparency is set at zero, no problems. When I rotate the map from 180
degrees it works fine too, but anything else doesn't. Output is the same if
it exported in .jpg, .pdf, ...

Enclosed the output with the print composer and a rotation of 330 degrees
and a screenshot of the print composer (the map is cached). The
transparency of the green layer is set at 5%, 0% for the red. You can see
how the green layer is cut ...

Screenshot:http://imgur.com/ZtCdfwY
Print output:http://imgur.com/3iBFwXD

This problem doesn't appear for raster with/without transparency.

I already tried to modify every option I knew, but it doesn't work.

  Any hints?
Thanks a lot
Nebi


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

[Qgis-user] Reminder: AGIT 2014 CfP deadline 1.2.2014

[spatialjoe]

Hi all,


please submit your papers until Feb. 1, 2014 to be reviewed. 
http://www.agit.at/index.php/symposium/beitragseinreichung

Best

Johannes




--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Reminder-AGIT-2014-CfP-deadline-1-2-2014-tp5100504.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

Re: [Qgis-user] Mapinfo and qgis file's datum problem

[M. LATTES]

Hi,

Don't forget that in polar coordinates (so WGS84) the X scale and Y scale
are not the same and not constant in projected meter.

I will look into two directions :

1°) Check that the "core" units and projections of MapInfo are the same as
your project projection :

I'm not familiar with your MapInfo version, but I know that in previous
version (8.5 and above), the projection and units of the current map window
are distinct of the "core" (or default) mapinfo projection and unit.
By "core" I mean that when you use some tools, extensions, mapbasic,...
mapinfo may use the projection and units of the main settings, not the one
of the current map window.

2°) Check that your Qgis and MapInfo buffer are polygons, not Ellipse (or
arc) objects that store the radiuses and center and compute the shape.



Mathieu LATTES


-Message d'origine-
De : qgis-user-boun...@lists.osgeo.org
[mailto:qgis-user-boun...@lists.osgeo.org] De la part de nagellette
Envoyé : mardi 28 janvier 2014 14:01
À : qgis-user@lists.osgeo.org
Objet : Re: [Qgis-user] Mapinfo and qgis file's datum problem

Is there any one to help?



--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Mapinfo-and-qgis-file-s-datum-problem-tp
5091891p5100434.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


---
Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce 
que la protection avast! Antivirus est active.
http://www.avast.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Mapinfo and qgis file's datum problem

[nagellette]

Is there any one to help?



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/Mapinfo-and-qgis-file-s-datum-problem-tp5091891p5100434.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

Re: [Qgis-user] WFS caching behaviour

[Jonathan Moules]

>
> > I was using my web-server logs, however Fiddler is confirming that the
> WFS
> isn't making new requests when I zoom in/our except when I'm at distance
> zoom's (it should do it at all zooms).
>
> But if someone starts to fix this, please do not make it to send a new
> GetFeature request with every mouse roll step.
>

With caching off, it's supposed to do that. However, I did report
http://hub.qgis.org/issues/9439 yesterday  (QGIS sends a request for every
scroll, even intermediate scrolls when you do the wheel lots at once!) -
maybe that's what you're referring to.


> > So bug report it is.
> And more to come I bet.
>
> It keeps me out of trouble! :-)

Thanks again,
Jonathan

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Sum of values from atrribute table

[Filipe Dias]

You can install the plugin "Statist" or go to Processing->Basic statistics
for numeric fields


On Tue, Jan 28, 2014 at 9:25 AM, Simo Turunen wrote:

> I have attribute table with multiple columns. I want to calculate sum of
> one row. I know that it is possible to copy/paste table to excel, but the
> number of columns is huge. Is there a way to calculate with field
> calculator? And how it is done?
>
> ___
> 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] Print Composer - Rotation of Shapefiles with transparency

[N St]

Hi List,

I try to rotate a map in the print composer and I have an awkward problem.
I wanted to check if I am alone in this case, or if it's a bug.

I work under Windows 7 64 Pro - QGIS is 2.0.1.

When I rotate a map in the print composer, shapefiles are cut at a right
angle (according to the north) if the transparency is not set at 0. If the
transparency is set at zero, no problems. When I rotate the map from 180
degrees it works fine too, but anything else doesn't. Output is the same if
it exported in .jpg, .pdf, ...

Enclosed the output with the print composer and a rotation of 330 degrees
and a screenshot of the print composer (the map is cached). The
transparency of the green layer is set at 5%, 0% for the red. You can see
how the green layer is cut ...

Screenshot: http://imgur.com/ZtCdfwY
Print output: http://imgur.com/3iBFwXD

This problem doesn't appear for raster with/without transparency.

I already tried to modify every option I knew, but it doesn't work.

 Any hints?
Thanks a lot
Nebi
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Sum of values from atrribute table

[Simo Turunen]

I have attribute table with multiple columns. I want to calculate sum of
one row. I know that it is possible to copy/paste table to excel, but the
number of columns is huge. Is there a way to calculate with field
calculator? And how it is done?
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] WFS caching behaviour

[Jukka Rahkonen]

Jonathan Moules  writes:


> Hi Jukka,  You do seem to like Fiddler!

No, the name of the software is not important but I like to know what really
happens and with OGC services it means that one must see the messages which
client and server are sending.

> I was using my web-server logs, however Fiddler is confirming that the WFS
isn't making new requests when I zoom in/our except when I'm at distance
zoom's (it should do it at all zooms).

But if someone starts to fix this, please do not make it to send a new
GetFeature request with every mouse roll step.

> So bug report it is.
And more to come I bet.

-Jukka-

> Cheers,
> Jonathan


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

Re: [Qgis-user] WFS caching behaviour

[Jonathan Moules]

Hi Jukka,
  You do seem to like Fiddler!
I was using my web-server logs, however Fiddler is confirming that the WFS
isn't making new requests when I zoom in/our except when I'm at distance
zoom's (it should do it at all zooms).

So bug report it is.
Cheers,
Jonathan


On 27 January 2014 18:05, Jukka Rahkonen  wrote:

> Jonathan Moules  writes:
>
> >
> >
> > Hi List,Before I report this one as a bug, I figured I should check.
> >
> > What's the desired behaviour of the WFS client in QGIS in respect to
> caching results versus making new requests.
> >
> >
> > Example:
> > WFS server only returns 500 results for any given request. There are
> 51639
> features in the layer.
> >
> > - If I load the layer using the "Cached" checkbox as ticked, then QGIS
> only loads 500 features. Fine.
> >
> >
> > - If I then add the layer again, but with "cached" unticked, then QGIS
> only loads 500 features - but they're 500 different features. Fine.
> >
> > Except in both cases when I zoom in/out, the features don't change; QGIS
> doesn't make new requests. I thought it was supposed to, at least with the
> uncached version? Both appear to behaving the exact same way to me.
> >
> > Am I doing something wrong?
>
> Hi,
>
> Made a trial with v. 2.0.1 and checked with Fiddler2 proxy what happens (I
> recommend).
> - With caching a plain GetFeature is sent and you will get the 500 first
> records.
> - Without caching QGIS adds a BBOX filter and applies the extents of the
> current map view. You will get the first 500 records within the box.
> - After zooming/panning a new request with BBOX filter gets fired.
>
> I can't say why QGIS does not send new features for you. But you a the one
> who should absolutely install Fiddler or some other logging proxy and you
> can do loads of wonderful bug reports in the future.
>
> -Jukka Rahkonen-
>
>
> >
> > Thanks,Jonathan
> >
> >
> > This transmission is intended for the named addressee(s) only and may
> contain sensitive or protectively marked material up to RESTRICTED and
> should be handled accordingly. Unless you are the named addressee (or
> authorised to receive it for the addressee) you may not copy or use it, or
> disclose it to anyone else. If you have received this transmission in error
> please notify the sender immediately. All email traffic sent to or from us,
> including without limitation all GCSX traffic, may be subject to recording
> and/or monitoring in accordance with relevant legislation.
> >
> >
> > ___
> > Qgis-user mailing list
> > Qgis-user@...
> > 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
>

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user