I have a database and I am using geoms to build polygons around points.
I need to do st_distance, st_area, st_overlaps, st_union, and st_instersects. also using st_x and st_y and st_project, so pretty sure i have to use geometry data type for these operations.
My issue is that I need meters, not degrees to get st_distance between points, and and st_area of polygons.
Should i do a cast with the :: operator to convert to geography or should i project?
Also, how do I choose which srid to pick?
My input could be anywhere in the US (including AL, HI).