4
votes
1answer
79 views

Homogeneous vs Heterogeneous schema in Postgis

Introduction I'm working on creating a spatial database in Postgis, to be viewed and edited trough QGIS to help managing some farmland areas. One of my goals is the have a centralized place where ...
1
vote
1answer
72 views

How do you get a schema report from SHP, PostGIS, or other file type?

All, We're loading City and County data into our database, but looking to remove several fields we don't use. Those fields we do use I'd like our users to simply highlight on a printout I give them ...
12
votes
3answers
643 views

Geometry column naming convention - 'geom' or 'the_geom'?

I'm starting my first PostGIS project, and in various books and tutorials I've seen the geometry column labelled either 'geom' or 'the_geom'. Is one more conventional than the other? Furthermore, is ...
4
votes
4answers
231 views

How to build PostGIS database schema for flexibility and normalization?

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 ...