I have a MultiPolygon representation of some shapes in POSTGIS, I am trying to convert them to Polygon data.
st_geometryn(r.geom, 1) but that didnt work because the way polygons are embedded I think. Just returns a partial.
ST_ConcaveHull(ST_Collect(r.geom), 0.99), no luck returns nothing
SELECT f.gid, ST_AsGeoJSON(ST_Union(f.geom)) as singlegeom FROM (SELECT gid, (ST_Dump(geom)).geom As geom FROM public.nyc_boroughs ) As f GROUP BY gid"
but getting back to Multi Polygon,
I feel like a little bit of direction could help me figure out.
Data is here http://www.sendspace.com/file/2savyw