Re: [Qgis-user] SQL to update table
You might try: update mc-roadsegs Set RFROMHN = Where RFROMHN IS NULL; NULL signify the absence of a value in a field; it not a specific value; therefore you can't use the = operator (as in RFROMHN = NULL) Regards Bo Victor Thomsen AestasGIS Denmark Den 14-03-2015 kl. 22:57 skrev Chuck Young: I am trying to eliminate the text NULL from a table. I have imported a set of Tiger road data and in some of the columns that I need to display the data itr has NULL in the field. If it is Null I would really like that NOT to show up in the labeling on the map. I have tried some standard SQL update queries but they didn't work. I tried the following from the QSpatialite form that appears from within QGIS. Example: update mc-roadsegs Set RFROMHN = Where RFROMHN = NULL; I also tried to construct a query from within the query builf=der at the top of the Attribute table in Edit mode. I really need to remove these unwanted valued. It has been a while since I used SQL on a routine basis so I am a bit rusty. Any help will be much appreciated! Thanks Chuck ___ 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-user Digest, Vol 109, Issue 27
Hi One of the method is to use Spatial Join to transfer attributes of point to polygon. This works if the point is spatially located withing the polygon to whom you want to attach the attributes to. The other method is to join attributes of point to polygon based on a attribute which is common to both and is present in both attribute tables. Hope this helps. Abhijit Original Message From: qgis-user-requ...@lists.osgeo.org Sent: Sunday 15 March 2015 00:31 To: qgis-user@lists.osgeo.org Reply To: qgis-user@lists.osgeo.org Subject: Qgis-user Digest, Vol 109, Issue 27 Send Qgis-user mailing list submissions to qgis-user@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/qgis-user or, via email, send a message with subject or body 'help' to qgis-user-requ...@lists.osgeo.org You can reach the person managing the list at qgis-user-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of Qgis-user digest... Today's Topics: 1. Re: Attribute copy from point to polygon (Joris Hintjens) 2. Re: Attribute copy from point to polygon (Lene Fischer) -- Message: 1 Date: Sat, 14 Mar 2015 13:44:19 +0100 From: Joris Hintjens joris...@gmail.com To: Raymond Nijssen r.nijs...@terglobo.nl Cc: QGIS User Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Attribute copy from point to polygon Message-ID: 3a4ef06e-c207-4410-895c-076da1fb7...@gmail.com Content-Type: text/plain; charset=windows-1252 Ahah! our beloved Ujaval again! bedankt, Raymond. Ik had die optie al geprobeerd natuurlijk, maar kwam tot een vreemd resultaat. (een point layer met alleen features daar waar de polygonLayer ene?null? value had in een bepaalde kolom. Toen ben ik op zoek gegaan naar een alternatief. Nu nog eens geprobeerd, en het werkt wel.Waarschinijk bij de eerste poging(en) verkeerde parameters ingevuld, dat kan ik nu niet meer nagaan. toch bedankt, het lukt me nu wel. Joris Op 12-mrt.-2015, om 12:33 heeft Raymond Nijssen r.nijs...@terglobo.nl het volgende geschreven: http://www.qgistutorials.com/nl/docs/performing_spatial_joins.html ps use google too ;) On 12-03-15 12:22, Joris Hintjens wrote: Hi, I have a pointlayer and polygon layer in .SHP. I need to copy an attribute from the points within each polygon to the polygon layer. Any suggestions on how to do this? thanks Joris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Terglobo Amp?restraat 110 5223 CT 's-Hertogenbosch 06-25314983 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Message: 2 Date: Sat, 14 Mar 2015 14:20:42 + From: Lene Fischer l...@ign.ku.dk To: Joris Hintjens joris...@gmail.com, Raymond Nijssen r.nijs...@terglobo.nl Cc: QGIS User Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Attribute copy from point to polygon Message-ID: 38497AD9CA059C42AA3451EFEFF0378ED7224C61@P2KITMBX04WC02.unicph.domain Content-Type: text/plain; charset=iso-8859-1 Try the point sampling tool ? Lene Fischer Associate Professor ? Department of Geosciences and Natural Resource Management University of Copenhagen ? MOB +45 40115084 l...@ign.ku.dk ? ? ? ? -Oprindelig meddelelse- Fra: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] P? vegne af Joris Hintjens Sendt: 14. marts 2015 13:44 Til: Raymond Nijssen Cc: QGIS User Emne: Re: [Qgis-user] Attribute copy from point to polygon Ahah! our beloved Ujaval again! bedankt, Raymond. Ik had die optie al geprobeerd natuurlijk, maar kwam tot een vreemd resultaat. (een point layer met alleen features daar waar de polygonLayer enenull value had in een bepaalde kolom. Toen ben ik op zoek gegaan naar een alternatief. Nu nog eens geprobeerd, en het werkt wel.Waarschinijk bij de eerste poging(en) verkeerde parameters ingevuld, dat kan ik nu niet meer nagaan. toch bedankt, het lukt me nu wel. Joris Op 12-mrt.-2015, om 12:33 heeft Raymond Nijssen r.nijs...@terglobo.nl het volgende geschreven: http://www.qgistutorials.com/nl/docs/performing_spatial_joins.html ps use google too ;) On 12-03-15 12:22, Joris Hintjens wrote: Hi, I have a pointlayer and polygon layer in .SHP. I need to copy an attribute from the points within each polygon to the polygon layer. Any suggestions on how to do this? thanks Joris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Terglobo Amp?restraat 110 5223 CT 's-Hertogenbosch 06-25314983 ___ Qgis-user mailing list
[Qgis-user] SQL to update table
I am trying to eliminate the text NULL from a table. I have imported a set of Tiger road data and in some of the columns that I need to display the data itr has NULL in the field. If it is Null I would really like that NOT to show up in the labeling on the map. I have tried some standard SQL update queries but they didn't work. I tried the following from the QSpatialite form that appears from within QGIS. Example: update mc-roadsegs Set RFROMHN = Where RFROMHN = NULL; I also tried to construct a query from within the query builf=der at the top of the Attribute table in Edit mode. I really need to remove these unwanted valued. It has been a while since I used SQL on a routine basis so I am a bit rusty. Any help will be much appreciated! Thanks Chuck ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Attribute copy from point to polygon (Joris Hintjens)
Hi One of the method is to use Spatial Join to transfer attributes of point to polygon. This works if the point is spatially located withing the polygon to whom you want to attach the attributes to. The other method is to join attributes of point to polygon based on a attribute which is common to both and is present in both attribute tables. Hope this helps. Abhijit Original Message From: abhijit.ekb...@gmail.com Sent: Sunday 15 March 2015 06:56 To: qgis-user@lists.osgeo.org; qgis-user@lists.osgeo.org Subject: Re: Qgis-user Digest, Vol 109, Issue 27 Hi One of the method is to use Spatial Join to transfer attributes of point to polygon. This works if the point is spatially located withing the polygon to whom you want to attach the attributes to. The other method is to join attributes of point to polygon based on a attribute which is common to both and is present in both attribute tables. Hope this helps. Abhijit Original Message From: qgis-user-requ...@lists.osgeo.org Sent: Sunday 15 March 2015 00:31 To: qgis-user@lists.osgeo.org Reply To: qgis-user@lists.osgeo.org Subject: Qgis-user Digest, Vol 109, Issue 27 Send Qgis-user mailing list submissions to qgis-user@lists.osgeo.org To subscribe or unsubscribe via the World Wide Web, visit http://lists.osgeo.org/mailman/listinfo/qgis-user or, via email, send a message with subject or body 'help' to qgis-user-requ...@lists.osgeo.org You can reach the person managing the list at qgis-user-ow...@lists.osgeo.org When replying, please edit your Subject line so it is more specific than Re: Contents of Qgis-user digest... Today's Topics: 1. Re: Attribute copy from point to polygon (Joris Hintjens) 2. Re: Attribute copy from point to polygon (Lene Fischer) -- Message: 1 Date: Sat, 14 Mar 2015 13:44:19 +0100 From: Joris Hintjens joris...@gmail.com To: Raymond Nijssen r.nijs...@terglobo.nl Cc: QGIS User Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Attribute copy from point to polygon Message-ID: 3a4ef06e-c207-4410-895c-076da1fb7...@gmail.com Content-Type: text/plain; charset=windows-1252 Ahah! our beloved Ujaval again! bedankt, Raymond. Ik had die optie al geprobeerd natuurlijk, maar kwam tot een vreemd resultaat. (een point layer met alleen features daar waar de polygonLayer ene?null? value had in een bepaalde kolom. Toen ben ik op zoek gegaan naar een alternatief. Nu nog eens geprobeerd, en het werkt wel.Waarschinijk bij de eerste poging(en) verkeerde parameters ingevuld, dat kan ik nu niet meer nagaan. toch bedankt, het lukt me nu wel. Joris Op 12-mrt.-2015, om 12:33 heeft Raymond Nijssen r.nijs...@terglobo.nl het volgende geschreven: http://www.qgistutorials.com/nl/docs/performing_spatial_joins.html ps use google too ;) On 12-03-15 12:22, Joris Hintjens wrote: Hi, I have a pointlayer and polygon layer in .SHP. I need to copy an attribute from the points within each polygon to the polygon layer. Any suggestions on how to do this? thanks Joris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Terglobo Amp?restraat 110 5223 CT 's-Hertogenbosch 06-25314983 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Message: 2 Date: Sat, 14 Mar 2015 14:20:42 + From: Lene Fischer l...@ign.ku.dk To: Joris Hintjens joris...@gmail.com, Raymond Nijssen r.nijs...@terglobo.nl Cc: QGIS User Qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Attribute copy from point to polygon Message-ID: 38497AD9CA059C42AA3451EFEFF0378ED7224C61@P2KITMBX04WC02.unicph.domain Content-Type: text/plain; charset=iso-8859-1 Try the point sampling tool ? Lene Fischer Associate Professor ? Department of Geosciences and Natural Resource Management University of Copenhagen ? MOB +45 40115084 l...@ign.ku.dk ? ? ? ? -Oprindelig meddelelse- Fra: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] P? vegne af Joris Hintjens Sendt: 14. marts 2015 13:44 Til: Raymond Nijssen Cc: QGIS User Emne: Re: [Qgis-user] Attribute copy from point to polygon Ahah! our beloved Ujaval again! bedankt, Raymond. Ik had die optie al geprobeerd natuurlijk, maar kwam tot een vreemd resultaat. (een point layer met alleen features daar waar de polygonLayer enenull value had in een bepaalde kolom. Toen ben ik op zoek gegaan naar een alternatief. Nu nog eens geprobeerd, en het werkt wel.Waarschinijk bij de eerste poging(en) verkeerde parameters ingevuld, dat kan ik nu niet meer nagaan. toch bedankt, het lukt me nu wel. Joris Op 12-mrt.-2015, om 12:33 heeft Raymond Nijssen r.nijs...@terglobo.nl het volgende geschreven: http://www.qgistutorials.com/nl/docs/performing_spatial_joins.html ps use
Re: [Qgis-user] SQL to update table
NULL means unknown, so you can't say if another value = NULL, it may or may not - the db can't tell. Instead of = there is usually an isnull or is null operator in your database to test for null, in your case, try:update mc-roadsegs Set RFROMHN = Where RFROMHN is null; (I use Postgis rather than Spatialite, which would use ' instead of to define strings, so:update mc-roadsegs Set RFROMHN = '' Where RFROMHN is null;) HTH, Brent Wood From: Chuck Young wylie1...@gmail.com To: Qgis-user@lists.osgeo.org Sent: Sunday, March 15, 2015 10:57 AM Subject: [Qgis-user] SQL to update table I am trying to eliminate the text NULL from a table. I have imported a set of Tiger road data and in some of the columns that I need to display the data itr has NULL in the field. If it is Null I would really like that NOT to show up in the labeling on the map. I have tried some standard SQL update queries but they didn't work. I tried the following from the QSpatialite form that appears from within QGIS. Example: update mc-roadsegs Set RFROMHN = Where RFROMHN = NULL; I also tried to construct a query from within the query builf=der at the top of the Attribute table in Edit mode. I really need to remove these unwanted valued. It has been a while since I used SQL on a routine basis so I am a bit rusty. Any help will be much appreciated! Thanks Chuck ___ 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] Attribute copy from point to polygon
Ahah! our beloved Ujaval again! bedankt, Raymond. Ik had die optie al geprobeerd natuurlijk, maar kwam tot een vreemd resultaat. (een point layer met alleen features daar waar de polygonLayer ene”null” value had in een bepaalde kolom. Toen ben ik op zoek gegaan naar een alternatief. Nu nog eens geprobeerd, en het werkt wel.Waarschinijk bij de eerste poging(en) verkeerde parameters ingevuld, dat kan ik nu niet meer nagaan. toch bedankt, het lukt me nu wel. Joris Op 12-mrt.-2015, om 12:33 heeft Raymond Nijssen r.nijs...@terglobo.nl het volgende geschreven: http://www.qgistutorials.com/nl/docs/performing_spatial_joins.html ps use google too ;) On 12-03-15 12:22, Joris Hintjens wrote: Hi, I have a pointlayer and polygon layer in .SHP. I need to copy an attribute from the points within each polygon to the polygon layer. Any suggestions on how to do this? thanks Joris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Terglobo Ampèrestraat 110 5223 CT 's-Hertogenbosch 06-25314983 ___ 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] Attribute copy from point to polygon
Try the point sampling tool Lene Fischer Associate Professor Department of Geosciences and Natural Resource Management University of Copenhagen MOB +45 40115084 l...@ign.ku.dk -Oprindelig meddelelse- Fra: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] På vegne af Joris Hintjens Sendt: 14. marts 2015 13:44 Til: Raymond Nijssen Cc: QGIS User Emne: Re: [Qgis-user] Attribute copy from point to polygon Ahah! our beloved Ujaval again! bedankt, Raymond. Ik had die optie al geprobeerd natuurlijk, maar kwam tot een vreemd resultaat. (een point layer met alleen features daar waar de polygonLayer enenull value had in een bepaalde kolom. Toen ben ik op zoek gegaan naar een alternatief. Nu nog eens geprobeerd, en het werkt wel.Waarschinijk bij de eerste poging(en) verkeerde parameters ingevuld, dat kan ik nu niet meer nagaan. toch bedankt, het lukt me nu wel. Joris Op 12-mrt.-2015, om 12:33 heeft Raymond Nijssen r.nijs...@terglobo.nl het volgende geschreven: http://www.qgistutorials.com/nl/docs/performing_spatial_joins.html ps use google too ;) On 12-03-15 12:22, Joris Hintjens wrote: Hi, I have a pointlayer and polygon layer in .SHP. I need to copy an attribute from the points within each polygon to the polygon layer. Any suggestions on how to do this? thanks Joris ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user -- Terglobo Ampèrestraat 110 5223 CT 's-Hertogenbosch 06-25314983 ___ 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
