I'm creating a database that will be used by researchers in population genetics with different goals and sampling strategies. The database needs to accommodate locations as points, lines, or polygons and I'm puzzling over whether those should be kept in a single "locations" table, or in separate tables for "point_locations", "line_locations", and "polygon_locations". The single-table design is appealing because it would make it simple to enforce the required one-to-one relationship between samples and their locations with a foreign key constraint. I can imagine that there may be reasons to split locations out into separate tables for points, lines, and polygons, however. If I can keep all locations' spatial data in a single column, then which geography datatype should I use (I know geometry would be more flexible, but that's a topic for another post)? I'm thinking geography(polygon,4326).
Subscribe to:
Post Comments (Atom)
arcpy - Changing output name when exporting data driven pages to JPG?
Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...
-
Does anyone know if it is possible to add hyperlinks to image fields etc. in the pop-up windows of Qgis2web? I've had a look in the laye...
-
I am now working with VIIRS/NPP Active Fires by using python gdal. But I cannot read the data inside the files. Filename = "NPP_AVAF_L2...
-
Here is what I'd like to achieve in QGIS. Is there a processing tool to remove the overlapping part of polygons? It is also very importa...
No comments:
Post a Comment