Otdfbt

Multi tool use

What is the effect of the Feeblemind spell on Ability Score Improvements?

Wiring a 4 channel relay - is this possible?

Polynomial division: Is this trick obvious?

How to continually let my readers know what time it is in my story, in an organic way?

When did game consoles begin including FPUs?

Capital gains on stocks sold to take initial investment off the table

tikz drawing rectangle discretized with triangle lattices and its centroids

What do you call the hair or body hair you trim off your body?

Why did the metro bus stop at each railway crossing, despite no warning indicating a train was coming?

2 parabolas through 4 points

How to rename multiple files in a directory at the same time

Single word that parallels "Recent" when discussing the near future

Will the volt, ampere, ohm or other electrical units change on May 20th, 2019?

Were any of the books mentioned in this scene from the movie Hackers real?

Why did Varys remove his rings?

Developers demotivated due to working on same project for more than 2 years

Is my test coverage up to snuff?

God-Pharaoh's Statue and Finale Of Promise

Who commanded or executed this action in Game of Thrones S8E5?

Formal Definition of Dot Product

Which creature is depicted in this Xanathar's Guide illustration of a war mage?

Is the seat-belt sign activation when a pilot goes to the lavatory standard procedure?

How will the lack of ground stations affect navigation?

Why did the UK remove the 'European Union' from its passport?

Constructing query to return values from all polygons that line passes through using SpatiaLite? [closed]

Seek assistance with: SQL Server 2008 Query that takes values from a column in another table (or from a flat file)How to combine Spatialite DatabasesHow to create a spatial view when allowing multiple selection in qgis’s edit widget “value relation”?problem merging polygons based on a column value - using SpatialiteExplicitly close a OGR result object from a call to ExecuteSQLFind start of riverDump a GeoJSON FeatureCollection from Spatialite query with PythonUsing nearest neighbor query in SpatiaLite?Update query adding values from multi column case statement in QGISQuerying geometry in perimeter or square with SpatiaLite?

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

I want an SQL query in Spatialite to return a list of values (Primary Key in this case, but could be any value) from all the polygons which are crossed by a line. Say, for example, a footpath passes through several fields and I want a table of the field numbers of all the fields the footpath passes through.

I've tried playing around with st_crosses, but that only returns a single result.

spatialite query spatial-query

share|improve this question

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

asked May 4 at 7:35

IsaacsonIsaacson

496313

closed as off-topic by Jochen Schwarze, PolyGeo♦ May 4 at 20:56

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "When seeking help to debug/write/improve code always provide the desired behavior, a specific problem/error and the shortest code (as formatted text, not pictures) needed to reproduce it in the question body. Providing a clear problem statement and a code attempt helps others to help you." – Jochen Schwarze, PolyGeo

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

0

I want an SQL query in Spatialite to return a list of values (Primary Key in this case, but could be any value) from all the polygons which are crossed by a line. Say, for example, a footpath passes through several fields and I want a table of the field numbers of all the fields the footpath passes through.

I've tried playing around with st_crosses, but that only returns a single result.

spatialite query spatial-query

share|improve this question

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

asked May 4 at 7:35

IsaacsonIsaacson

496313

closed as off-topic by Jochen Schwarze, PolyGeo♦ May 4 at 20:56

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "When seeking help to debug/write/improve code always provide the desired behavior, a specific problem/error and the shortest code (as formatted text, not pictures) needed to reproduce it in the question body. Providing a clear problem statement and a code attempt helps others to help you." – Jochen Schwarze, PolyGeo

If this question can be reworded to fit the rules in the help center, please edit the question.

add a comment | 

I want an SQL query in Spatialite to return a list of values (Primary Key in this case, but could be any value) from all the polygons which are crossed by a line. Say, for example, a footpath passes through several fields and I want a table of the field numbers of all the fields the footpath passes through.

I've tried playing around with st_crosses, but that only returns a single result.

spatialite query spatial-query

share|improve this question

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

asked May 4 at 7:35

IsaacsonIsaacson

496313

share|improve this question

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

asked May 4 at 7:35

IsaacsonIsaacson

496313

share|improve this question

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

asked May 4 at 7:35

IsaacsonIsaacson

496313

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

edited May 4 at 20:56

PolyGeo♦

54.3k1782251

asked May 4 at 7:35

IsaacsonIsaacson

496313

asked May 4 at 7:35

IsaacsonIsaacson

496313

1 Answer
1

active

oldest

votes

4

Try ST_INTERSECTS:

select polygons.*
from polygons, lines
where st_intersects(polygons.geometry, lines.geometry)

share|improve this answer

edited May 6 at 6:08

answered May 4 at 7:50

BERABERA

18.3k62145

add a comment | 

4

Try ST_INTERSECTS:

select polygons.*
from polygons, lines
where st_intersects(polygons.geometry, lines.geometry)

share|improve this answer

edited May 6 at 6:08

answered May 4 at 7:50

BERABERA

18.3k62145

add a comment | 

4

Try ST_INTERSECTS:

select polygons.*
from polygons, lines
where st_intersects(polygons.geometry, lines.geometry)

share|improve this answer

edited May 6 at 6:08

answered May 4 at 7:50

BERABERA

18.3k62145

add a comment | 

Try ST_INTERSECTS:

select polygons.*
from polygons, lines
where st_intersects(polygons.geometry, lines.geometry)

share|improve this answer

edited May 6 at 6:08

answered May 4 at 7:50

BERABERA

18.3k62145

select polygons.*
from polygons, lines
where st_intersects(polygons.geometry, lines.geometry)

share|improve this answer

edited May 6 at 6:08

answered May 4 at 7:50

BERABERA

18.3k62145

answered May 4 at 7:50

BERABERA

18.3k62145

answered May 4 at 7:50

BERABERA

18.3k62145