I have a Geonode/Geoserver application with a lot of base layers added to it. I have also developed a Django App plugged into Geonode that lets a user upload shapefiles. These shapefiles are converted using shp2pgsql and stored in a
uploads PostGIS table, with each upload having a unique
Once a user uploads a shapefile, the app runs SQL queries to compare (check for overlapping areas) the uploaded shapefile with existing base layers and results are stored in a database table. So far, this has been done.
But now, I need to show the upload shapefile on top of existing base layers in a map viewer (Geonode). Wondering what would be the best approach.
Do I have to add the uploaded shapefiles to GeoServer? Or can I set the
uploads table as a PostGIS datastore in GeoServer and have it create layers from each row?