0
votes
0answers
74 views

Need advice on converting large geodatabase into shapefile or postgis

tl;dr: I have a fgdb w/ 800k tiny polygons representing high risk flood areas. I need to sum the area of these polygons within each administrative boundary (HUCs) and have a ratio per huc of high risk ...
1
vote
3answers
430 views

Is there a dissolve / ST_Union function that will close gaps between features?

I've been reading a number of related threads about ST_Union, ST_SnapToGrid and ST_Dump but I haven't been able to solve my problem. The problem is I am trying to merge Tiger/line census tracts that ...
2
votes
1answer
786 views

PostGIS Dissolve/Union close polygons

I have approximately 1 million polygons that have been split by lines. However, this has caused one half of a polygon to be separated by approximately 50cm from its other half. After doing a lot of ...
5
votes
1answer
485 views

PostGIS - Why are my ST_Union results (stored in a new table) outputting as points and not polygons?

I've decided to move to PostGIS to merge polygons rather than spend hours doing in in QGIS. However, I'm hitting an issue where the results of an ST_Union query are being stored, or at least outputted ...
2
votes
1answer
725 views

How to correctly merge layers with overlapping polygons in QGIS/GRASS?

I have 4 vector shapefile that I would like to join/merge, without worrying about attributes. Here are the shapefiles. I would like to do an union and a spatial dissolve, but everytime I do a dissolve ...