I am trying to use Google Earth Engine to extract a daily time series csv for 6 years of PRISM data across 5000+ census tracts within Texas. I need the final product to be a data frame with daily max temperature as rows, and individual census tracts as columns, with the temperature value for each census tract being the spatial average of the tract. The problem that I am running into is GEE's "Collection.geometry: Geometry has too many edges (2923493 > 2000000)."
Nothing I have been able to find has given a proper workaround for this in GEE. I can't simplify the geometry since the census tracts must stay standardized. My one thought is to convert the shapefile to a raster (using something like featureCollection.reduceToImage()), and extract daily census-tract level values through masking, but I'm not sure if that would actually work.
Is something like this possible in GEE or is the best route just to download the raw PRISM data and process it through python outside of GEE? Or something else?
I'm open to working in Javascript or the Python API, but prefer the latter if possible! Any ideas much appreciated!