I am using Esri's GIS tools for Hadoop but I think the query is pretty standard stuff. The SQL/HQL below is from the Esri tutorial found here https://github.com/Esri/gis-tools-for-hadoop/wiki/Aggregating-CSV-Data-(Spatial-Binning)
So I have a datastore of millions of points but I only want to produce a map of a specific region (say Europe).
The query I currently run generates a Spatial bin of the entire world
FROM (SELECT ST_Bin(0.001, ST_Point(dropoff_longitude,dropoff_latitude)) bin_id, *FROM taxi_demo) binsINSERT OVERWRITE TABLE taxi_aggSELECT ST_BinEnvelope(0.001, bin_id) shape, COUNT(*) countGROUP BY bin_id;How would I limit this to a specific bounding box? Any Ideas?
Thank you v. much!
أكثر...
So I have a datastore of millions of points but I only want to produce a map of a specific region (say Europe).
The query I currently run generates a Spatial bin of the entire world
FROM (SELECT ST_Bin(0.001, ST_Point(dropoff_longitude,dropoff_latitude)) bin_id, *FROM taxi_demo) binsINSERT OVERWRITE TABLE taxi_aggSELECT ST_BinEnvelope(0.001, bin_id) shape, COUNT(*) countGROUP BY bin_id;How would I limit this to a specific bounding box? Any Ideas?
Thank you v. much!
أكثر...