id summary reporter owner description type status priority milestone component version resolution keywords cc 2179 ST_MakeValid support for NaN values. strk strk "It's not easy to obtain a polygon with NaN ordinate values so here is one: {{{ 01060000000100000001030000000100000007000000010000000000F87F9CDFD01E32095341010000000000F87F193B6F0A30095341010000000000F87FA10FBF4C1D095341010000000000F87F38E258111C095341010000000000F87F5196BAFF17095341010000000000F87F4F0550911B095341010000000000F87F9CDFD01E32095341 }}} The above geometry was found in a shapefile, and can be imported successfully by both shp2pgsql and ogr2ogr. ST_MakeValid not only fails at turning it into a valid, but also throws an exception. Possible better things to do: 1. Pretend all NaN values are an arbitrary value (0.0) ? 2. Drop all Coordinates with any NaN ordinate value (including Z and M?) 3. Return null 4. Return the input untouched " defect new medium PostGIS Fund Me postgis 2.0.x