gannebamm/query.sql

Created January 28, 2018 17:50

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/gannebamm/5aa8cd856ce8a3d53848a39258a62df2.js"></script>
Save gannebamm/5aa8cd856ce8a3d53848a39258a62df2 to your computer and use it in GitHub Desktop.

Download ZIP

Query for getting the number of red lines which are crossed by each black line

Raw

	select SUM(red.n), black.*
	from red, black
	where st_crosses(red.geometry, black.geometry)
	group by black.ID

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment