<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
Many thanks, Stefan, this has solved the issue!
<div class=""><br class="">
</div>
<div class="">Neil
<div class="">
<div dir="auto" style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;">
</div>
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br class="">
</div>
<br class="Apple-interchange-newline">
</div>
<br class="Apple-interchange-newline">
</div>
<div><br class="">
<blockquote type="cite" class="">
<div class="">On Feb 1, 2018, at 8:56 AM, Stefan Giese (WhereGroup) <<a href="mailto:stefan.giese@wheregroup.com" class="">stefan.giese@wheregroup.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Hi
Neil,</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">not
only setting them to the same projection - you have to bring them into the same projection (save one of the two in tthe same projection). see attched image, where I save the california layer in the same projection (geographic, WGS84) like the csv and then
load it. When you intesects the points with this new california layer, you will have the correct attributes in your point layer, see attached csv...</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">best
stefan</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Am
2018-02-01 17:38, schrieb Berg, Neil:</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class="">
<blockquote type="cite" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">
Hi Stefan,<br class="">
Unfortunately, setting the layers to the same projection does not<br class="">
resolve the issue. Only one of the 12 subregions is still joined to<br class="">
each point.<br class="">
Neil<br class="">
<blockquote type="cite" class="">On Feb 1, 2018, at 8:09 AM, Stefan Giese<br class="">
<<a href="mailto:Stefan.Giese@wheregroup.com" class="">Stefan.Giese@wheregroup.com</a>> wrote:<br class="">
Hi Neil,<br class="">
the problem you encountered belongs to the different projection of<br class="">
your 2 layers. If you want to perform an intersect you should<br class="">
reproject your point layer to the same system like your zone-Layer.<br class="">
Just right-click on the point layer and select "save as". in the<br class="">
following dialog set the projection to the same as your california<br class="">
layer and load the data. then the intersection should work..<br class="">
Good luck<br class="">
stefan<br class="">
Mit freundlichen Grüßen<br class="">
Stefan Giese<br class="">
Projektleiter/Consultant<br class="">
</blockquote>
****************************************************************************<br class="">
<blockquote type="cite" class="">FOSS Academy Kompaktkurs Winterschule 2018<br class="">
Grundwissen zum Aufbau von Geodateninfrastrukturen mit<br class="">
Open-Source-Software<br class="">
</blockquote>
<a href="https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule" class="">https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule</a><br class="">
<blockquote type="cite" class=""></blockquote>
****************************************************************************<br class="">
<blockquote type="cite" class="">WhereGroup GmbH & Co. KG<br class="">
Schwimmbadstr. 2<br class="">
79100 Freiburg<br class="">
Germany<br class="">
Fon: +49 (0)761 / 519 102 - 61<br class="">
Fax: +49 (0)761 / 519 102 - 11<br class="">
stefan.giese@wheregroup.com<br class="">
<a href="http://www.wheregroup.com/" class="">www.wheregroup.com</a><span class="Apple-converted-space"> </span>[1]<br class="">
Amtsgericht Bonn, HRA 6788<br class="">
-------------------------------<br class="">
Komplementärin:<br class="">
WhereGroup Verwaltungs GmbH<br class="">
vertreten durch:<br class="">
Olaf Knopp, Peter Stamm<br class="">
-------------------------------<br class="">
Am 01.02.2018 um 16:23 schrieb Berg, Neil:<br class="">
Hi Stefan,<br class="">
Thanks for clarifying - I’ve uploaded the .shp, .shx, and .dbf<br class="">
files to the drive below. Hopefully this helps!<br class="">
Best,<br class="">
Neil<br class="">
On Jan 31, 2018, at 11:24 PM, Stefan Giese<br class="">
<<a href="mailto:Stefan.Giese@wheregroup.com" class="">Stefan.Giese@wheregroup.com</a>> wrote:<br class="">
Hi Neil,<br class="">
just a note to your link: if you provide shapefiles, you'll have to<br class="">
put at least 3 files: CC4a_RegionsSub.shp, CC4a_RegionsSub.dbf and<br class="">
CC4a_RegionsSub.shx. (shp contains the geometry, dbf the attributes<br class="">
and shx is the index between shp and dbf)..<br class="">
best regards<br class="">
stefan<br class="">
Mit freundlichen Grüßen<br class="">
Stefan Giese<br class="">
Projektleiter/Consultant<br class="">
</blockquote>
****************************************************************************<br class="">
<blockquote type="cite" class="">FOSS Academy Kompaktkurs Winterschule 2018<br class="">
Grundwissen zum Aufbau von Geodateninfrastrukturen mit<br class="">
Open-Source-Software<br class="">
</blockquote>
<a href="https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule" class="">https://www.foss-academy.com/schulungstermine/kompaktkurs-winterschule</a><br class="">
<blockquote type="cite" class=""></blockquote>
****************************************************************************<br class="">
<blockquote type="cite" class="">WhereGroup GmbH & Co. KG<br class="">
Schwimmbadstr. 2<br class="">
79100 Freiburg<br class="">
Germany<br class="">
Fon: +49 (0)761 / 519 102 - 61<br class="">
Fax: +49 (0)761 / 519 102 - 11<br class="">
<a href="mailto:stefan.giese@wheregroup.com" class="">stefan.giese@wheregroup.com</a><br class="">
<a href="http://www.wheregroup.com/" class="">www.wheregroup.com</a><span class="Apple-converted-space"> </span>[1]<br class="">
Amtsgericht Bonn, HRA 6788<br class="">
-------------------------------<br class="">
Komplementärin:<br class="">
WhereGroup Verwaltungs GmbH<br class="">
vertreten durch:<br class="">
Olaf Knopp, Peter Stamm<br class="">
-------------------------------<br class="">
Am 01.02.2018 um 05:42 schrieb Berg, Neil:<br class="">
Hi all,<br class="">
I’m working with (1) a CSV file containing columns of “lat”<br class="">
and “lon” which represent grid cell centroids from a gridded<br class="">
model product over California (“loca_lat_lon.csv”), and (2) a<br class="">
shape file that carves up California into 12 distinct subregions<br class="">
(“CC4a_RegionsSub.shp”).<br class="">
These files can be accessed here:<br class="">
</blockquote>
<a href="https://drive.google.com/drive/folders/1IUrpVSJYBRIoCS4vzGYK9sBEzdwZec-c?usp=sharing" class="">https://drive.google.com/drive/folders/1IUrpVSJYBRIoCS4vzGYK9sBEzdwZec-c?usp=sharing</a><br class="">
<blockquote type="cite" class="">I am trying to determine which grid cells reside in each of the 12<br class="">
subregions (or NA/NULL if outside all subregions) using Vector -><br class="">
Data Management Tools -> Join Attributes by Location. I have<br class="">
specified my Target vector layer as loca_lat_lon.csv, the Join<br class="">
vector layer as CC4a_RegionsSub.shp, the Geometric predicate as<br class="">
“intersects”, and am taking attributes of the first located<br class="">
feature, and only keeping matching records.<br class="">
The issue is that the returned joined layer assigns just 1 of the 12<br class="">
subregions, “Sierra Nevada Mountains”, to all grid cells, rather<br class="">
than different subregions (or None) to the cells.<br class="">
The shape file has a CRS of NAD83/California Albers and the<br class="">
coordinates in the CSV file are simply WGS 84. I’ve tried<br class="">
resetting the latter CRS to NAD83/California Albers, but the same<br class="">
issue persists.<br class="">
I’m using QGIS 2.18.14.<br class="">
Any help is greatly appreciated. Thanks in advance!<br class="">
Neil<br class="">
_______________________________________________<br class="">
Qgis-user mailing list<br class="">
<a href="mailto:Qgis-user@lists.osgeo.org" class="">Qgis-user@lists.osgeo.org</a><br class="">
List info:<span class="Apple-converted-space"> </span><a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" class="">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">
Unsubscribe:<span class="Apple-converted-space"> </span><a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" class="">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br class="">
</blockquote>
Links:<br class="">
------<br class="">
[1]<span class="Apple-converted-space"> </span><a href="http://www.wheregroup.com/" class="">http://www.wheregroup.com/</a></blockquote>
<span id="cid:741EE10A-DC65-4989-BAE7-9A0A09162504@psnet.ucla.edu"><2018-02-01 17_49_28-QGIS 2.18.4.png></span><span id="cid:62B06807-B8FD-46AC-9DB7-B55DD7B57360@psnet.ucla.edu"><loca_lat_lon_intersect_regions.zip></span></div>
</blockquote>
</div>
<br class="">
</div>
</body>
</html>