Analysis Api - Spatial Join

[mkeller3]

Description

Allow user to perform spatial join analysis

Example:

WITH join_points AS(
	SELECT points.gid, polygons.name, polygons.state_name, polygons.population
	FROM starbucks AS points
	JOIN counties AS polygons
	ON ST_INTERSECTS(polygons.geom, points.geom)
)
SELECT points.gid, join_points.*
FROM starbucks AS points
LEFT JOIN join_points
ON points.gid = join_points.gid
ORDER BY state_name

Tasks

• Create spatial_join method in analysis_queries
• Create endpoint in router for analysis
• Create Docs