Skip to main content
snakey866's user avatar
snakey866's user avatar
snakey866's user avatar
snakey866
  • Member for 3 years, 5 months
  • Last seen more than 1 year ago
awarded
revised
Loading…
comment
QField SSL authentication and live project updates
the question is has anyone found a fix for getting QField to to read and write directly to the database whilst SSL is being forced or how i can get QField to submit credentials to the database for the login
Loading…
Loading…
comment
Creating unique ID for features that are within polygons with unique IDs
I am once again using this expression to do the same thing however it is no longer increasing the count by 1 each time for the ID of the items any ideas why this may be? My current expression is as follows: '' || array_first ( overlay_within( 'distribution_area', "name")) || '-MST12-' || to_string (array_find (array_agg (array_first (overlay_within ('distribution_area', $id))||''||-$id,array_first (overlay_within ('disdtribution_area', $id))),array_first (overlay_within ('distribution_area', $id))||''||-$id)+1)
awarded
comment
Generating list of IDs from intersecting lines
isnt the linked question only in relation to polygons? im working with lines here and im useless with writing expressions. its been a very long day
comment
Generating list of IDs from intersecting lines
ive managed to get a merge of line 1 and lines 2.1 2.2 and 2.3 but they are all seperate items and i have a lot of them to do this for so was hoping it could be automated in someway
Loading…
awarded
answered
Loading…
comment
Generate ID based on intersecting points
I will also need a similar thing in the future to create a list of points that a line intersects with i assume this is also achieveable with a similar overlay_intersects command
comment
Generate ID based on intersecting points
apologies for the lateness in my reply. I got kicked out the office and then the weekend happened. so I have tried putting the expression you gave me into the field calculator but it only returns NULL. Picture 1 is the layer with the endpoint ID i need to set with the name field of pictures 2 and 3 depending on which layer A intersects (it will be either a chamber or a pole) there is roughly 180 items in layer A if this matters at all Pic 1: imgur.com/vOf8Ai3 Pic 2: imgur.com/nhHNE4r Pic 3 : imgur.com/gwTqJkV
comment
Generate ID based on intersecting points
i did attempt to use overlay intersects as ive used overlay within for a similar issue with generating ids based on the poly they were in but had no luck due to me not really understanding what im doing. so if im right : aggregate(layer:='point B',aggregate:='array_agg',expression:="name",filter:=interse‌​cts($geometry,geomet‌​ry))[0] will that make the name now my endpoint id ?
asked
Loading…
comment
Creating unique ID for features that are within polygons with unique IDs
That's absolutely fantastic thank you so much. The only thing I need to do now is work out how to have this in an actual field as opposed to just in the labels but thanks so much I wasn't even aware that the overlay within part was an option
awarded
awarded
comment
Creating unique ID for features that are within polygons with unique IDs
points. sorry my use of terminology might be a little off due to me being pretty new at all this. I cant really share screenshots or anything due to the somewhat sensitive nature of the project