I have a postgis table that I've uploaded a shapefile to, this shapefile contains 200+ polygon rows with several integer columns.
What I'd like to do is similar to the QGIS 'random points in polygon' function except with numbers that are much larger. My initial approach with QGIS crashed upon trying to add ~500,000 random points to each polygon - I need the number of random points to come from the related integer column.
After some research, an indexed postgis database is the way to go. But I'm unsure how to generate random points in a polygon for each polygon in my table, and to have the number of points that get randomly generated, come from a corresponding column.
New to Postgres, and postgis, but familiar with mysql, QGIS, ArcGIS, and geographic concepts.
Help is much appreciated.
أكثر...
What I'd like to do is similar to the QGIS 'random points in polygon' function except with numbers that are much larger. My initial approach with QGIS crashed upon trying to add ~500,000 random points to each polygon - I need the number of random points to come from the related integer column.
After some research, an indexed postgis database is the way to go. But I'm unsure how to generate random points in a polygon for each polygon in my table, and to have the number of points that get randomly generated, come from a corresponding column.
New to Postgres, and postgis, but familiar with mysql, QGIS, ArcGIS, and geographic concepts.
Help is much appreciated.
أكثر...