Intercept undefined geometries as 4326

CartoDB / observatory-extension

BSD 3-Clause "New" or "Revised" License

6 stars 4 forks source link

Intercept undefined geometries as 4326 #193

Open andrewbt opened 8 years ago

andrewbt commented 8 years ago

I try

SELECT *
FROM OBS_GetBoundariesByGeometry( ST_MakeEnvelope(-76.04736328125,38.764256548069305,-73.10302734375,41.6169823542308),
       'us.census.tiger.state')

doesn't work because I forgot SRID, displays error getting OBS_GetBoundariesByGeometry

says @talos : we should probably intercept undefined geometries and set them to 4326

talos commented 7 years ago

We're seeing this cause problems in the wild.

The refactor to use obs_getdata and obs_getmeta will make this easy to fix, we need to intercept at one location and should solve this whole class of errors.