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...
-
I have a python script and I use it through my toolbox but I use it many times in a day. Is it possible to assign a keyboard shortcut to my ...
-
I want to implement a feature in my app (gmap powered) to highlight the area on mouse over. Much like the functionality in wikimapia. Check ...
-
I have some multi-spectral data, where the individual bands are separate Raster files. How do I layer stack these rasters so that I get one ...
No comments:
Post a Comment