Upcoming Book: PostGIS in Action

[Paragon Corporation-2]

Several months ago we asked  you about the value of a PostGIS book and if
you would buy such a thing.  We got a lot of favorable comments and
suggestions.  We think our success in getting a book contract was in large
part because of this.  We thank you very much for your heart-warming
support.

Needless to say we got a couple of contract offers a couple of months ago
and settled on Manning.  We liked the fact that they had pre-book sales and
also allowed readers to provide input into what they would like to see in
the book.  Now that our book has reached Pre-Book sale status and is now
listed on the Manning site, we can celebrate a little and announce its
existence.

The book detail summary is not in place yet, but you can download the first
chapter for free and order now if you want.  

http://www.manning.com/obe

Ordering early allows you to get the chapters as they are written and get
the final e-Book/Hardcopy.  We have an estimated Hard-Copy completion of
around January/February 2010 and the full ebook copy should be available
about 2 months before that.

The book will cover both basic concepts as well as advanced.

Things that will be covered (we have chapters 1,2,3 already written but
nothing is set in stone until it hits hard-copy),  so feel free to voice any
ideas you have on our author blog.

Below are the following chapters we have planned (or done)

1) What spatial databases do in general, which ones exist, and OGC
terminology
2) What geometry types PostGIS supports and how well it supports each with
some simple exercises of creating each type.  Here we cover 2d, 3d, 3dm
basic geometry types and curved geometries
3) Data modeling -- This chapter starts by going over some basic storage
models -- using schemas, do you use table inheritance, have untyped or
specific typed geometry column, separate tables, separate columns, use srids
or not and so forth as well as pros and cons of each.  It then concludes
with simple exercises demonstrating these different storage approaches.  
4) Working with geometries -- this covers key geometry properties and
concepts -- such as what a spatial reference system is and kinds out there,
other key geometry properties and functions that take one geometry.  It will
conclude with business case uses for these.
5) Deals mostly with relation operations and functions that take more than
one geometry as input (pretty much a companion to chapter 4)
6) This chapter covers combining what was learned in 4 and 5 to create more
sophisticated queries.  It will show things such as clipping geometries,
splitting geometries with lines, combining spatial aggregates with sql
aggregates, generating a farm of test data.
7) working with real data -- we go in depth into how to load data with
shp2pgsql and OGR2OGR.  Tricks for determining the spatial reference system
of a data source when there is or is no meta data.  Also exporting to
various different data sources.

8) Speeding up queries -- demonstrates how to write optimal SQL statements
as well as somewhat hackish statements to force the PostgreSQL planner to
follow a more optimal plan.  How to use explain and graphical explain to
determine where the bottlenecks in your queries are. Choosing the right
indexes (spatial and btree, compound vs. non-compound).  Key PostgreSQL
settings.

--Part 2:
9) This covers specific use cases -- how to fix different kinds of invalid
geometries, various proximity analysis/nearest neighbor exercises, using
buffers, linear referencing. I think we have about 25 exercises planned out.

10) PostGIS add-ons and ancillary tools -- planned here are Tiger Geocoder,
PgRouting, PLPython, PLR
11) Using PostGIS in web applications -- planned here UMN Mapserver,
GeoServer, SharpMap, OpenLayers, (maybe Web Feature Server)
12) Using PostGIS in desktop environment -- here we plan to do some quick
exercises using -- OpenJump, QuantumGIS, uDig, GvSig
13) WKT Raster -- new work going on here -- we'll cover difference between
raster and vector data, installing WKT Raster, loading raster data, raster
/vector overlays, analysis of color bands

The Appendixes
Appendix A:  Additional Resources
We'll have listings of useful blogs and sites for more tips and tricks,
places to get data etc.

Appendix B: Installation, Upgrade
We'll provide resources where you can get binaries for PostGIS
How to PostGIS enable a new db
How to upgrade from one version to another (both soft and hard and the lazy
hard)

Appendix C: SQL Primer
Basic SQL stuff that is pretty standard in most relational databases
Different join types (INNER, LEFT, RIGHT, EXCEPT, UNION [ALL]  with cute
diagrams of each), Aggregates, recursive queries and common table
expressions (new in PostgreSQL 8.4 but supported in other high-end dbs --
SQL server, IBM, Oracle), Windowing queries
Doing inserts, updates, cross table updates

Appendix D: PostgreSQL Specific Features
Things that are somewhat unique to PostgreSQL -- such as how to create
custom aggregates, arrays as data types, rules, triggers, sql and plpgsql
function primer.

Thanks for your support,
Leo and Regina






_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Chris Hermansen]

Wow!  Congratulations to you both; and how nice that we can all share in
the benefits of your hard work!

Paragon Corporation wrote:

> Several months ago we asked  you about the value of a PostGIS book and if
> you would buy such a thing.  We got a lot of favorable comments and
> suggestions.  We think our success in getting a book contract was in large
> part because of this.  We thank you very much for your heart-warming
> support.
>
> Needless to say we got a couple of contract offers a couple of months ago
> and settled on Manning.  We liked the fact that they had pre-book sales and
> also allowed readers to provide input into what they would like to see in
> the book.  Now that our book has reached Pre-Book sale status and is now
> listed on the Manning site, we can celebrate a little and announce its
> existence.
>
> The book detail summary is not in place yet, but you can download the first
> chapter for free and order now if you want.  
>
> http://www.manning.com/obe
>
> Ordering early allows you to get the chapters as they are written and get
> the final e-Book/Hardcopy.  We have an estimated Hard-Copy completion of
> around January/February 2010 and the full ebook copy should be available
> about 2 months before that.
>
> The book will cover both basic concepts as well as advanced.
>
> Things that will be covered (we have chapters 1,2,3 already written but
> nothing is set in stone until it hits hard-copy),  so feel free to voice any
> ideas you have on our author blog.
>
> Below are the following chapters we have planned (or done)
>
> 1) What spatial databases do in general, which ones exist, and OGC
> terminology
> 2) What geometry types PostGIS supports and how well it supports each with
> some simple exercises of creating each type.  Here we cover 2d, 3d, 3dm
> basic geometry types and curved geometries
> 3) Data modeling -- This chapter starts by going over some basic storage
> models -- using schemas, do you use table inheritance, have untyped or
> specific typed geometry column, separate tables, separate columns, use srids
> or not and so forth as well as pros and cons of each.  It then concludes
> with simple exercises demonstrating these different storage approaches.  
> 4) Working with geometries -- this covers key geometry properties and
> concepts -- such as what a spatial reference system is and kinds out there,
> other key geometry properties and functions that take one geometry.  It will
> conclude with business case uses for these.
> 5) Deals mostly with relation operations and functions that take more than
> one geometry as input (pretty much a companion to chapter 4)
> 6) This chapter covers combining what was learned in 4 and 5 to create more
> sophisticated queries.  It will show things such as clipping geometries,
> splitting geometries with lines, combining spatial aggregates with sql
> aggregates, generating a farm of test data.
> 7) working with real data -- we go in depth into how to load data with
> shp2pgsql and OGR2OGR.  Tricks for determining the spatial reference system
> of a data source when there is or is no meta data.  Also exporting to
> various different data sources.
>
> 8) Speeding up queries -- demonstrates how to write optimal SQL statements
> as well as somewhat hackish statements to force the PostgreSQL planner to
> follow a more optimal plan.  How to use explain and graphical explain to
> determine where the bottlenecks in your queries are. Choosing the right
> indexes (spatial and btree, compound vs. non-compound).  Key PostgreSQL
> settings.
>
> --Part 2:
> 9) This covers specific use cases -- how to fix different kinds of invalid
> geometries, various proximity analysis/nearest neighbor exercises, using
> buffers, linear referencing. I think we have about 25 exercises planned out.
>
> 10) PostGIS add-ons and ancillary tools -- planned here are Tiger Geocoder,
> PgRouting, PLPython, PLR
> 11) Using PostGIS in web applications -- planned here UMN Mapserver,
> GeoServer, SharpMap, OpenLayers, (maybe Web Feature Server)
> 12) Using PostGIS in desktop environment -- here we plan to do some quick
> exercises using -- OpenJump, QuantumGIS, uDig, GvSig
> 13) WKT Raster -- new work going on here -- we'll cover difference between
> raster and vector data, installing WKT Raster, loading raster data, raster
> /vector overlays, analysis of color bands
>
> The Appendixes
> Appendix A:  Additional Resources
> We'll have listings of useful blogs and sites for more tips and tricks,
> places to get data etc.
>
> Appendix B: Installation, Upgrade
> We'll provide resources where you can get binaries for PostGIS
> How to PostGIS enable a new db
> How to upgrade from one version to another (both soft and hard and the lazy
> hard)
>
> Appendix C: SQL Primer
> Basic SQL stuff that is pretty standard in most relational databases
> Different join types (INNER, LEFT, RIGHT, EXCEPT, UNION [ALL]  with cute
> diagrams of each), Aggregates, recursive queries and common table
> expressions (new in PostgreSQL 8.4 but supported in other high-end dbs --
> SQL server, IBM, Oracle), Windowing queries
> Doing inserts, updates, cross table updates
>
> Appendix D: PostgreSQL Specific Features
> Things that are somewhat unique to PostgreSQL -- such as how to create
> custom aggregates, arrays as data types, rules, triggers, sql and plpgsql
> function primer.
>
> Thanks for your support,
> Leo and Regina
>
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>  

--
Chris Hermansen         mailto:chris.hermansen@...
tel[phone] · fax[phone] · mob[phone]
Timberline Natural Resource Group · http://www.timberline.ca
401 · 958 West 8th Avenue  · Vancouver BC · Canada · V5Z 1E5

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Eduin Carrillo-2]

Congrats Regina & Leo. It's a big hiatus for our community's history.

Have you thought about translate it? We (the spanish-spoken users) are
missing a good and up to date reference of PostGIS. I would like
support such effort.

Eduin Yesid Carrillo Vega
Ingeniero Civil, Esp. Sistemas de Información Geográfica
Grupo IDE & GIG
Centro de Investigación y Desarrollo en Información Geográfica
Instituto Geográfico Agustín Codazzi - IGAC
Cr 30 48-51
Tel [phone]  ext 4305
Bogotá D.C., Colombia




On Fri, May 8, 2009 at 5:40 PM, Paragon Corporation <lr@...> wrote:
> Several months ago we asked  you about the value of a PostGIS book and if
> you would buy such a thing.  We got a lot of favorable comments and
> suggestions.  We think our success in getting a book contract was in large
> part because of this.  We thank you very much for your heart-warming
> support.
>
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Paragon Corporation-2]

Eduin,
Thanks.  We did give some thought to that and that would be really great.  I
think it all depends on the demand for such a translation and success of the
english version.  It would nice to think the book will be popular enough to
warrant several translations.

Leo

-----Original Message-----
From: postgis-users-bounces@...
[mailto:postgis-users-bounces@...] On Behalf Of Eduin
Carrillo
Sent: Friday, May 08, 2009 7:20 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Upcoming Book: PostGIS in Action

Congrats Regina & Leo. It's a big hiatus for our community's history.

Have you thought about translate it? We (the spanish-spoken users) are
missing a good and up to date reference of PostGIS. I would like support
such effort.

Eduin Yesid Carrillo Vega
Ingeniero Civil, Esp. Sistemas de Información Geográfica Grupo IDE & GIG
Centro de Investigación y Desarrollo en Información Geográfica Instituto
Geográfico Agustín Codazzi - IGAC Cr 30 48-51 Tel [phone]  ext 4305
Bogotá D.C., Colombia




On Fri, May 8, 2009 at 5:40 PM, Paragon Corporation <lr@...> wrote:
> Several months ago we asked  you about the value of a PostGIS book and
> if you would buy such a thing.  We got a lot of favorable comments and
> suggestions.  We think our success in getting a book contract was in
> large part because of this.  We thank you very much for your
> heart-warming support.
>
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[strk-2]

On Fri, May 08, 2009 at 06:40:40PM -0400, Paragon Corporation wrote:

> The book will cover both basic concepts as well as advanced.

Just a suggestion.

A section that I really appreciated in one of my first books about
free software (was it the Linux Administration Guide?) was the first
chapter (or was it the preface?) completely about what Free Software was.
The appendix also contained a full copy of the GPL version.
Very useful for reading under the sun, and makes you as a reader
happier to learn, as you know the knowledge you're loading your brain
with will not be wasted !

--strk;

 Free GIS & Flash consultant/developer      ()  ASCII Ribbon Campaign
 http://foo.keybit.net/~strk/services.html  /\  Keep it simple!
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[stetou]

Hello,
I searched for a data modeling/build/management tool for postresql and postgis.

I would like to have the opinion of users, which one really works? Could be open source or commercial.

Regards,
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Martin Fafard]

Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant@... a écrit :

Hello,
I searched for a data modeling/build/management tool for postresql and postgis.

I would like to have the opinion of users, which one really works? Could be open source or commercial.

Regards,
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
  

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date: 06/30/09 06:10:00

  

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[stetou]

Thanks Martin,
I'm already using pgAdminIII to manually manage databases.

What I meant is I need a tool to design a database structure (tables, fields, relations), so it can generate scripts to physically create the tables when the model is complete.
I need this tools to make reverse engineering, generate documentation about a database, etc....

As far as I know pgAdmin doesn't do that.
steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

Martin Fafard <martin.fafard@...>@postgis.refractions.net
Envoyé par : postgis-users-bounces@...

30/06/2009 11:09 AM

Veuillez répondre à
martin.fafard@...; Veuillez répondre à
PostGIS Users Discussion <postgis-users@...>

A	PostGIS Users Discussion <postgis-users@...>
cc
Objet	Re: [postgis-users] Data modeling tool

Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant@... a écrit :

Hello,
I searched for a data modeling/build/management tool for postresql and postgis.

I would like to have the opinion of users, which one really works? Could be open source or commercial.

Regards,
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

---

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
 

---

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date: 06/30/09 06:10:00

 _______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users




_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[János Löbb]

There is a free version of DBVisualizer.

János

On Jun 30, 2009, at 11:19 AM, Steve.Toutant@... wrote:

Thanks Martin,
I'm already using pgAdminIII to manually manage databases.

What I meant is I need a tool to design a database structure (tables, fields, relations), so it can generate scripts to physically create the tables when the model is complete.
I need this tools to make reverse engineering, generate documentation about a database, etc....

As far as I know pgAdmin doesn't do that.
steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

Martin Fafard <martin.fafard@...>@postgis.refractions.net
Envoyé par : postgis-users-bounces@...

30/06/2009 11:09 AM

Veuillez répondre à
martin.fafard@...; Veuillez répondre à
PostGIS Users Discussion <postgis-users@...>

A	PostGIS Users Discussion <postgis-users@...>
cc
Objet	Re: [postgis-users] Data modeling tool

Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant@... a écrit :

Hello,
I searched for a data modeling/build/management tool for postresql and postgis.

I would like to have the opinion of users, which one really works? Could be open source or commercial.

Regards,
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

---

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users
 

---

No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date: 06/30/09 06:10:00

 _______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Alexander Von Luenen]

Steve,

there is a nice tool out there developed by MicroOLAP
(http://www.microolap.com/), the Database Designer for PostgreSQL,
which lets you draw ERM diagrams and then generates the database from
that diagram. There's a free trial version on their webpage. This tool
is also capable of reverse-engineering databases.

There is also a tool called PostGeoOLAP, but I haven't tried it yet.
http://postgeoolap.projects.postgresql.org/ingles/release.html 

Cheers,
Alex



Dr Alexander von Luenen
Senior Research Associate
Great Britain Historical GIS
Dept. of Geography
University of Portsmouth
Buckingham Building, Lion Terrace
Portsmouth, PO1 3HE, UK
tel: [phone]
fax: [phone]


>>> <Steve.Toutant@...> 30/06/2009 16:19 >>>
Thanks Martin,
I'm already using pgAdminIII to manually manage databases.

What I meant is I need a tool to design a database structure (tables,
fields, relations), so it can generate scripts to physically create the

tables when the model is complete.
I need this tools to make reverse engineering, generate documentation
about a database, etc....

As far as I know pgAdmin doesn't do that.
steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca 
 




Martin Fafard <martin.fafard@...>@postgis.refractions.net

Envoyé par : postgis-users-bounces@...
30/06/2009 11:09 AM
Veuillez répondre à
martin.fafard@...; Veuillez répondre à
PostGIS Users Discussion <postgis-users@...>


A
PostGIS Users Discussion <postgis-users@...>
cc

Objet
Re: [postgis-users] Data modeling tool








Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant@... a écrit :

Hello,
I searched for a data modeling/build/management tool for postresql and

postgis.

I would like to have the opinion of users, which one really works?
Could
be open source or commercial.

Regards,
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca 
 


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users 
 



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date:
06/30/09
06:10:00

  _______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users 



_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[davis4459]

Steve,

There is an excellent tool for ERD, SQL script and an Excel spreadsheet report.
Jude Professional
http://jude.change-vision.com/jude-web/product/professional.html

The graphics are much better than DB Designer.  
There's a $40 educational timed license (1 year).
Many other tools as well - sequence diagrams, class diagrams, mind maps, etc.

Davis van Bakergem


-----Original Message-----
From: postgis-users-bounces@... on behalf of Alexander Von Luenen
Sent: Tue 6/30/2009 10:40 AM
To: martin.fafard@...; postgis-users-bounces@...
Cc: PostGIS Users Discussion
Subject: Re: [postgis-users] Data modeling tool
 
Steve,

there is a nice tool out there developed by MicroOLAP
(http://www.microolap.com/), the Database Designer for PostgreSQL,
which lets you draw ERM diagrams and then generates the database from
that diagram. There's a free trial version on their webpage. This tool
is also capable of reverse-engineering databases.

There is also a tool called PostGeoOLAP, but I haven't tried it yet.
http://postgeoolap.projects.postgresql.org/ingles/release.html 

Cheers,
Alex



Dr Alexander von Luenen
Senior Research Associate
Great Britain Historical GIS
Dept. of Geography
University of Portsmouth
Buckingham Building, Lion Terrace
Portsmouth, PO1 3HE, UK
tel: [phone]
fax: [phone]


>>> <Steve.Toutant@...> 30/06/2009 16:19 >>>
Thanks Martin,
I'm already using pgAdminIII to manually manage databases.

What I meant is I need a tool to design a database structure (tables,
fields, relations), so it can generate scripts to physically create the

tables when the model is complete.
I need this tools to make reverse engineering, generate documentation
about a database, etc....

As far as I know pgAdmin doesn't do that.
steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca 
 




Martin Fafard <martin.fafard@...>@postgis.refractions.net

Envoyé par : postgis-users-bounces@...
30/06/2009 11:09 AM
Veuillez répondre à
martin.fafard@...; Veuillez répondre à
PostGIS Users Discussion <postgis-users@...>


A
PostGIS Users Discussion <postgis-users@...>
cc

Objet
Re: [postgis-users] Data modeling tool








Hi Steve

pgAdminIII (pgadmin.org)

Martin F

Steve.Toutant@... a écrit :

Hello,
I searched for a data modeling/build/management tool for postresql and

postgis.

I would like to have the opinion of users, which one really works?
Could
be open source or commercial.

Regards,
Steve

Steve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3
Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca 
 


_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users 
 



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.375 / Virus Database: 270.13.0/2210 - Release Date:
06/30/09
06:10:00

  _______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users 



_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users



_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Frode Wiseth Jørgensen]

I'm using "Dezign for databases" delivered by http://www.datanamic.com/

It has'nt by default a GEOMETRY datatype but it can easily be added.

Frode

2009/6/30 <Steve.Toutant@...>

Hello,
I searched for a data modeling/build/management tool for postresql and postgis.

I would like to have the opinion of users, which one really works? Could be open source or commercial.

Regards,
Steve

bySteve Toutant, M. Sc.
Analyste en géomatique
Secteur environnement
Direction des risques biologiques, environnementaux et occupationnels
Institut national de santé publique du Québec
945, avenue Wolfe
Québec, Qc G1V 5B3

Tél.: [phone] #5281
Fax.: [phone]
steve.toutant@...
http://www.inspq.qc.ca

 

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

--
Frode Wiseth Jørgensen
[phone]

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Rob Tester]

I use Open System Architect. http://www.codebydesign.com/

It is available on several platforms and free to use.

-----Original Message-----
From: Frode Wiseth Jørgensen <frodewj@...>
Sent: Tuesday, June 30, 2009 10:25 AM
To: PostGIS Users Discussion <postgis-users@...>
Subject: Re: [postgis-users] Data modeling tool

I'm using "Dezign for databases" delivered by http://www.datanamic.com/

It has'nt by default a GEOMETRY datatype but it can easily be added.

Frode



2009/6/30 <Steve.Toutant@...>

>
> Hello,
> I searched for a data modeling/build/management tool for postresql and
> postgis.
>
> I would like to have the opinion of users, which one really works? Could be
> open source or commercial.
>


[The entire original message is not included]
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Eduin Carrillo-2]

I use EMS PgManager. A free version is available.

http://sqlmanager.net/products/postgresql/manager

Eduin Yesid Carrillo Vega
Ingeniero Civil, Esp. Sistemas de Información Geográfica
Grupo IDE & GIG
Centro de Investigación y Desarrollo en Información Geográfica
Instituto Geográfico Agustín Codazzi - IGAC
Cr 30 48-51
Tel [phone]  ext 4305
Bogotá D.C., Colombia



2009/6/30  <Steve.Toutant@...>:

>
> Hello,
> I searched for a data modeling/build/management tool for postresql and
> postgis.
>
> I would like to have the opinion of users, which one really works? Could be
> open source or commercial.
>
> Regards,
> Steve
>

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Nicolas Ribot]

I'm using Druid (http://druid.sourceforge.net/) allowing to generate
ER views, HTML, PDF docs, to reverse existing database
can also generate scripts for several targets (oracle, mysql, pg, etc)

Nicolas Ribot
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users