[postgis-users] DB and file organization best practices
Pavel Iacovlev
iacovlev.pavel at gmail.com
Wed Aug 26 12:41:33 PDT 2009
This really varies from project to project, and depends on many
things, but since I am bored at the moment here is what I use:
DB Structure:
I use 1 db per project with multiple schemas
Management solutions:
SVN, Issue tracker, Wiki
Backups:
cron & pg_dumpall
General Organization:
If you are a developer and do code use management solutions in your
team, and also docs (generate project documentation from them), unit
testing, coding style & standards across all projects
On Wed, Aug 26, 2009 at 10:20 PM, dassouki<dassouki at gmail.com> wrote:
> Hey all,
>
> I'm in the process of moving all my data to a new server. I was wondering:
>
> * How do you organize your GIS projects?
> o DB Structure:
> + Right now, what I do is I have a main GIS db
> containing GIS layers and another db containing data
> that I can join to the geometry. I find that this
> structure uses less storage space, but not as
> organized to one DB per project.
> o Folder Structure:
> + I usually follow this structure:
> /gis/projects/project_ID_D_M_Y .. with sub folders:
> documents, input data, used queries (Sql files),
> output data, emails, research, final output, and legal
> + Is there a management solution (software or technique)
> that you would recommend?
> o Backups
> + What do you recommend to backing up PostGIS data? How
> often do you do it?
> + I back up every project on a cd with all the data
> exported as shp sql files, any better suggestions?
> o General Organization
> + Any other tips, not necessarily PostGIS related, that
> make your GIS life easier?
> # I found that two 20 inch monitors really helped
> as well as a new stick of ram.
>
> I look forward to reading your responses,
> Dasouki
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
http://iap.md, The future is open
More information about the postgis-users
mailing list