[postgis-users] Re: The Old Who is using PostGIS survey again?
Todd Fagin
tfagin at coordinatesolutions.com
Wed Dec 31 11:16:24 PST 2008
1) How you use PostGIS?
I work for a GIS consulting firm and we recently decided to explore the use
of PostGIS as a possible solution for one of our clients. I am also a GIS
professor at a local community college and am teaching a GIS class at the
local university next semester. I have been sufficiently impressed with
PostGIS thus far and have decided to introduce it to at least one of my
classes.
2) What you find useful about it over anything else?
>From a professional standpoint, we have used PostGIS with GeoServer and I
would like to integrate it into some existing MapServer applications that we
have. As a newbie, though, I cannot definitively say how useful it is
compared to, say, other products, but I can say I have been pleased thus
far. Additionally, as someone else noted, the user community is great. I
had a problem with a query yesterday and I received an immediate response
and some very helpful suggestions. Without going too much into a rant about
other software developers, I can say that such a user-supported community
sure beats the so-called tech support others have to offer.
3) Why you think there should be any book written focused on its use and of
course if such a thing were to exist, would you buy it?
As I said above, I teach GIS. Aside from how helpful a book would be from a
personal user perspective, it would be a great teaching tool, as well.
(Tell that to you publisher--a captured audience. Ha ha).
Todd Fagin
Coordinate Solutions, Inc.
2804 NW 18th St.
Oklahoma City, OK 73107
405.740.4324 (voice)
904.471.5548 (fax)
www.coordinatesolutions.com
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
postgis-users-request at postgis.refractions.net
Sent: Wednesday, December 31, 2008 2:01 PM
To: postgis-users at postgis.refractions.net
Subject: postgis-users Digest, Vol 74, Issue 28
Send postgis-users mailing list submissions to
postgis-users at postgis.refractions.net
To subscribe or unsubscribe via the World Wide Web, visit
http://postgis.refractions.net/mailman/listinfo/postgis-users
or, via email, send a message with subject or body 'help' to
postgis-users-request at postgis.refractions.net
You can reach the person managing the list at
postgis-users-owner at postgis.refractions.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of postgis-users digest..."
Today's Topics:
1. Re: The Old Who is using PostGIS survey again? (MarkW)
2. RE: The Old Who is using PostGIS survey again? (Randall, Eric)
3. Re: The Old Who is using PostGIS survey again? (pcreso at pcreso.com)
4. Re: The Old Who is using PostGIS survey again? (Chetan Tiwari)
5. Re: The Old Who is using PostGIS survey again? (Andreas Neumann)
6. Converting data from SDE 9.3 sql server database to
PostgreSQL database with PostGIS geometry. (Toni Hefer)
7. RE: Converting data from SDE 9.3 sql server database to
PostgreSQL database with PostGIS geometry. (Toni Hefer)
8. RE: The Old Who is using PostGIS survey again?
(Paragon Corporation)
9. Re: The Old Who is using PostGIS survey again? (Dan Blomberg)
10. Help with an area and hole filter query? (Bob and Deb)
11. Fw: RE: [postgis-users] The Old Who is using PostGIS survey
again? (pcreso at pcreso.com)
12. Re: The Old Who is using PostGIS survey again? (Stephen Davies)
13. Re: The Old Who is using PostGIS survey again? (Richard Greenwood)
14. Re: The Old Who is using PostGIS survey again? (Dane Springmeyer)
15. RE: Help with an area and hole filter query? (Paragon Corporation)
16. Re: Pgrouting directions (Stephen Woodbridge)
17. Re: Help with an area and hole filter query? (Bob and Deb)
18. The Old Who is using PostGIS survey again? (Mark)
19. Re: The Old Who is using PostGIS survey again? (Jay Cummins)
20. RE: The Old Who is using PostGIS survey again?
(Gregory Williamson)
21. Re: The Old Who is using PostGIS survey again? (Stefan Keller)
22. How to populate a column with results of isvalid
(Intengu Technologies)
23. RE: How to populate a column with results of isvalid (Obe, Regina)
24. Re: How to populate a column with results of isvalid
(Intengu Technologies)
25. What SQL admin tools are you using? (Stefan Keller)
----------------------------------------------------------------------
Message: 1
Date: Tue, 30 Dec 2008 14:17:21 -0500
From: MarkW <mark.wimer at gmail.com>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<5c880c980812301117v7c3d6955t3dc726bb905606d5 at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
1) Use for: shared data storage, adding basic spatial functionality to
websites, automating some spatial processes with scripting, and as a
mapserver back-end.
2) Find useful over others: well-established, great documentation & active
support community, easy entry
3) Why a book: there is good documentation online - very good. But the docs
cannot cover enough SQL examples, integration with other tools, or highlight
examples of a range of uses. I would buy the book if it had lots of good
examples/samples and/or if I could hand it to a colleague and say "read this
to get up to proficiency with PostGIS." I hope it can have both.
I think the Tyler book and the Kropla book really helped more people get
into Mapserver (and open source gis) - different people learn different
ways, and a book available through mainstream sources (Amazon, Borders)
could really help.
Mark
P.S. Okay, I'll buy the book no matter what really - having seen all the
helpful answers you've posted here. Let us know when the "pre-order forms
are available.
On Tue, Dec 30, 2008 at 7:21 AM, Paragon Corporation <lr at pcorp.us> wrote:
>
> 1) How you use PostGIS?
> 2) What you find useful about it over anything else?
> 3) Why you think there should be any book written focused on its use and
of
> course if such a thing were to exist, would you buy it?
>
>
> Thanks,
> Regina
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/12
2c35cd/attachment-0001.html
------------------------------
Message: 2
Date: Tue, 30 Dec 2008 14:46:29 -0500
From: "Randall, Eric" <ERandall at eriecountygov.org>
Subject: RE: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<CD32AE6ACD828644B29601ADC966FDCB01B4ABB6 at ex1.eriecountygov.local>
Content-Type: text/plain; charset="iso-8859-1"
1) How you use PostGIS?
a.) Monthly transfer of County ESRI SDE/MSSQL Geodatabase to County PostGIS
Database
b.) from which many manipulations, extractions, calculations, and updates
are performed with greater ease and automation than from the ArcGIS tools.
Some of our uses include:
c.) PA Act 319 Clean and Green calculations
d.) Pennsylvania Agricultural Conservation Easement Application Scoring
e.) Monthly Municipal GIS Extraction for the Municipalities
f.) Datastore for intranet web mapping.
g.) Virtually any ad hoc analysis and querying.
h.) Explaining GIS.
2.) What you find useful about it over anything else?
a.) Probably one of the most useful aspects of PostGIS for me personally has
been it's instructiveness (is that a word?). Between the database/SQL
nature of interfacing with spatial/non data, and the great community
surrounding it, I think it is the ideal GIS learning environment. I think
of it as a GIS Erector Set. I'm suprised that most Universities don't seem
to be using it for teaching (This alone I think would be a great reason for
a book).
b.) The variety of ways that solutions can be thought through and worked
through. Usually straightforward, and when not, there is always plenty of
help.
c.) Portable, numerous OSs and architectures.
d.) It JUST doesn't SUCK! (you may remove that)
3.) Why you think there should be any book written focused on its use and
of
course if such a thing were to exist, would you buy it?
See 1h. and 2a., and yes, I will buy one...I'll always know someone who can
use it.
-Eric
Eric Randall
GIS DB Admin/Analyst
County of Erie
140 W 6th St
Room 119
Erie, PA 16501
ph. 814-451-6063
fx. 814-451-7000
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net]On Behalf Of
Paragon Corporation
Sent: Tuesday, December 30, 2008 7:22 AM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] The Old Who is using PostGIS survey again?
Leo and I have a good portion of a PostGIS book written. Ideally we would
like to get a publisher to publish it, but seem to be running into the same
obstacles. No publisher seems to think people use PostGIS to warrant enough
demand for a book dedicated to it.
So to make a decent case for a book, can each of you in your own words
describe
1) How you use PostGIS?
2) What you find useful about it over anything else?
3) Why you think there should be any book written focused on its use and of
course if such a thing were to exist, would you buy it?
Of course I'll also need some official download stats etc. which hopefully
the Refractions group can help out with. I think Mark Cave-Ayland had
posted some stats a while back, but can't find them.
Thanks,
Regina
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------
Message: 3
Date: Tue, 30 Dec 2008 12:00:32 -0800 (PST)
From: pcreso at pcreso.com
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Cc: r at pcorp.us
Message-ID: <94087.45600.qm at web33201.mail.mud.yahoo.com>
Content-Type: text/plain; charset=us-ascii
>
> So to make a decent case for a book, can each of you in
> your own words
> describe
>
> 1) How you use PostGIS?
Several ways/reasons/purposes in a research organisation (NIWA New Zealand)
We use PostGIS for:
managing a national topo vector database as a back end for
a Mapserver site using WMS to provide background layers for
several national web mapping applications
A near real-time database at sea for data captured from numerous
instruments on a research vessel, with lat/long so all data
is spatially related
A summary database on shore of research vessel instrument
readings, with a web mapping (mapserver/python) interface.
A database supporting a data management & analysis system built
for a 16 month fisheries survey in the Arabian Sea on a chartered
commercial trawler. Used to collect & manage trip, station, catch,
biological, meteorological, hydrographic and oceanographic data
captured during the survey. (subject of a presentation at this
symposium: http://www.esl.co.jp/Sympo/4th/) Note, this database was
recently installed in Oman for their own use.
Databases for managing & spatially analysing (using PostGIS
grids) a variety of datasets of commercial fisheries catch &
effort information. Also usin R. (Subject of a presentation &
paper in the proceedings at the above symposium)
A generic Antarctic database supporting several fisheries,
oceanographic, hydrographic & ecological research programs studying
Antarctic & Southern Ocean processes & systems.
Currently also looking at PostGIS for:
replacing Oracle in an ArcSDE implementation managing a national
marine regional bathymetric database,
managing a national hydrological database for NZ, with catchments,
drainage, river, river flow data, etc
providing spatially enabled RDBMS capabilities to support regional &
national climate & haazard warning systems in the Pacific for
several nations.
> 2) What you find useful about it over anything else?
>From my perspective, there are a few critical aspects that make PostGIS
ideal for our situation, and that are not available from any other spatial
RDBMS:
Capability: it is a fully functional fast & powerful RDBMS able to manage,
query & analyse spatial data with NO other applications required for many
aspects of my work.
Interoperability: we can use it easily with Arc systems, natively as a
geodatabase, directly through WMS/WFS, and via shapefile export (ogr2ogr &
pgsql2shape). Also with QGIS, R, gvSIG, geoserver, FAO Geonetworks, Matlab
(via ODBC), etc...
Portability: (two aspects under one heading), we can use it anywhere, on
shore, in the field, at sea, under BSD, Linux, Unix, Windows as we desire,
with no licences to pay for, install, manage, expire inconveniently, etc.
Standards based. This is implicit in the above aspects, but I believe it is
worth including in it's own right. Any GIS suite, using any mix of
applications, if is built using common industry standards (ANSI, ISO, SQL,
OGC, ...) is compatible with PostGIS with relatively little work. eg: we
funded the migration of Atlas (www.atlasmd.com) from a completely different
RDBMS to PostGIS for spatial data & WMS support, the entire migration took
perhaps 3 weeks, and the vendor is now looking to migrate all
versions/installations to PostGIS due to the performance, reliability &
functional benefits it provides.
> 3) Why you think there should be any book written focused
> on its use and of course if such a thing were to exist, would you buy it?
Both personally, and through our library, we have purchased several
Postgres, Mapserver, GRASS, FOSS GIS books. I can guarantee a few copies
would be purchased of any PostGIS book, as our use of PostGIS is rapidly
expanding. (NIWA has about 600 staff, and many science staff would probably
buy personal copies as a reference/tutorial)
At the above mentioned symposium, with many countries represented, some 80%
of presenters from Asia, Europe, Africa, Australasia & N & S America, were
directly using FOSS tools, such as mapserver, R or PostGIS. The FAO is
supporting the development of Geonetworks, a standards based metadata
application for spatial data, which works well with PostGIS.
I recently ran an in-house workshop on Postgres & Postgis for NIWA staff.
I'd anticipated some 15 or so attendees. I finished with two workshops, of
about 20 people in each, with staff from some government departments also
attending. I thought I'd had a reasonable ear to the ground for Postgres &
PostGIS use in my organisation, but found we had others who'd been using it
for years on their own projects. Feedback was positive & interest & uptake
in PostGIS & related tools is growing rapidly. (I've been carefully watering
it for several years & it seems to be working :-)
I don't see the global market as enormous, as it is a niche, but I believe
it is enough to make such a book worthwhile, and I'd expect the market to
increase rapidly over the next few years as multinational initiatives,
especially in third world countries with limited budgtets for licences,
such as geonetworks, continue to drive the growth of affordable standards
based spatial data management systems world wide.
Good luck!!!!
Brent Wood
>
> Of course I'll also need some official download stats
> etc. which hopefully
> the Refractions group can help out with. I think Mark
> Cave-Ayland had
> posted some stats a while back, but can't find them.
>
> Thanks,
> Regina
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------
Message: 4
Date: Tue, 30 Dec 2008 14:05:58 -0600
From: "Chetan Tiwari" <chetan.tiwari at gmail.com>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<cee91c340812301205i4a8aae36tac6ca27009cd2181 at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
It would be nice to have an introductory book - it can be something I could
use in some of the classes I teach. Are you planning to have a section on
'Applications'? Looking at some of the diverse examples of how people use
PostGIS, maybe people on this list (and others) can contribute towards a
chapter or so.
To answer your questions:
1) How you use PostGIS?
We use it extensively in a web-based environmental health surveillance
system. We've embedded kernel density estimation methods and some
environmental models in a PostGIS-based system that allows users, who may
not be experts in GIS and spatial analysis (say public health officials), to
create and analyze spatial patterns of disease outcomes, measure exposures
to environmental contaminants, and visualize some of these data using
technologies like Google Earth.
> 2) What you find useful about it over anything else?
Ability to efficiently handle large datasets. Ability to create a
user-friendly interface where complex analysis tasks are embedded within
web-based, automated routines. Ties in well with other WebGIS
infrastructure.
> 3) Why you think there should be any book written focused on its use and
of
> course if such a thing were to exist, would you buy it?
>
I would buy it, and possibly use it for teaching GIS programming, WebGIS
classes at the undergraduate (possibly graduate) level.
Chetan
--
Chetan Tiwari, PhD
Assistant Professor
University of North Texas
Department of Geography
1155 Union Circle #305279
Denton, TX 76203-5017
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/2b
9c9d21/attachment-0001.html
------------------------------
Message: 5
Date: Tue, 30 Dec 2008 21:07:08 +0100
From: Andreas Neumann <a.neumann at carto.net>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <495A7F6C.2080501 at carto.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
1) In the City of Uster (Kanton Zurich, Switzerland) we use
PostgreSQL/Postgis as a central (geo)-data-warehouse. We import survey
data, data on energy supply (electricity, water, gaz) and waste-water
management and all additional geodata the city manages (urban planning,
nature, agriculture, traffic, street management, etc.)
We also use Postgis for data analysis and report generation. We use it
in conjunction with QuantumGIS, GRASS and Autodesk software. Sometimes
we do the analysis directly with SQL and export the data to SVG/HTML/PDF.
2) It is quite feature complete and offers more (geo)-functionality than
most commercial databases. PostgreSQL offers advanced database
technology (like Oracle) at a much lower price. It is also easy to
extend by ourselves and it is easy to find developers to extend it
feature-wise if it is too complex for us to implement it by ourself.
3) It is always good to have a book for learning new technology. For the
more advanced users it would be good to have some hints on improving
performance (eg tweaking postgresql.conf settings), indexes, query
optimization, etc. For all users it would be great to have spatial
queries to build upon. It would be great if the queries could be
visualized somehow with graphics or demo-data supplied to play with.
It would also be great to have chapters on more advanced topics like
linear referencing, routing with PostGIS and the intersectionPatternMatrix.
A text on interpreting the output of the "Explain" command would also be
great in order to allow query optimization.
Speaking for Switzerland I can say that there is a lot of interest in
PostgreSQL/Postgis because it is easier to maintain than oracle at lower
prices. The one missing bit for a break-trough and wide use in
Switzerland is proper curve-support for circular-arcs - not only for
data-storage but also for all the algorithms (data analysis) and related
tools (QGIS, GRASS, etc.). This is implemented in OracleSpatial and
still missing in PostgreSQL - the one major reason for many in
Switzerland to stay with OracleSpatial.
Andreas
Paragon Corporation wrote:
> Leo and I have a good portion of a PostGIS book written. Ideally we would
> like to get a publisher to publish it, but seem to be running into the
same
> obstacles. No publisher seems to think people use PostGIS to warrant
enough
> demand for a book dedicated to it.
>
> So to make a decent case for a book, can each of you in your own words
> describe
>
> 1) How you use PostGIS?
> 2) What you find useful about it over anything else?
> 3) Why you think there should be any book written focused on its use and
of
> course if such a thing were to exist, would you buy it?
>
> Of course I'll also need some official download stats etc. which hopefully
> the Refractions group can help out with. I think Mark Cave-Ayland had
> posted some stats a while back, but can't find them.
>
> Thanks,
> Regina
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
--
Andreas Neumann
Bvschacherstrasse 6
CH-8624 Gr|t (Gossau ZH)
Switzerland
Phone: ++41-44-2736668
Email: a.neumann at carto.net
Web: http://www.carto.net/neumann/
SVG Examples: http://www.carto.net/papers/svg/samples/
SVG.Open: http://www.svgopen.org/
------------------------------
Message: 6
Date: Tue, 30 Dec 2008 15:49:59 -0500
From: Toni Hefer <THefer at landadvisors.com>
Subject: [postgis-users] Converting data from SDE 9.3 sql server
database to PostgreSQL database with PostGIS geometry.
To: "postgis-users at postgis.refractions.net"
<postgis-users at postgis.refractions.net>
Message-ID:
<9AEDE8F6C1867249BCDE7CFDD83B3FA52DE35E3F03 at shelley3.webville.net>
Content-Type: text/plain; charset="iso-8859-1"
Skipped content of type multipart/alternative-------------- next part
--------------
A non-text attachment was scrubbed...
Name: 2.jpg
Type: image/jpeg
Size: 30843 bytes
Desc: 2.jpg
Url :
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/82
48521d/2-0001.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 1.jpg
Type: image/jpeg
Size: 39211 bytes
Desc: 1.jpg
Url :
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/82
48521d/1-0001.jpg
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 3.jpg
Type: image/jpeg
Size: 250123 bytes
Desc: 3.jpg
Url :
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/82
48521d/3-0001.jpg
------------------------------
Message: 7
Date: Tue, 30 Dec 2008 16:13:03 -0500
From: Toni Hefer <THefer at landadvisors.com>
Subject: [postgis-users] RE: Converting data from SDE 9.3 sql server
database to PostgreSQL database with PostGIS geometry.
To: Toni Hefer <THefer at landadvisors.com>,
"postgis-users at postgis.refractions.net"
<postgis-users at postgis.refractions.net>
Message-ID:
<9AEDE8F6C1867249BCDE7CFDD83B3FA52DE35E3F13 at shelley3.webville.net>
Content-Type: text/plain; charset="iso-8859-1"
I need to add to this information, that when I look at the attribute table,
there are the same amount of records in the feature class using pg_geometry
as the feature class using default geometry, you can zoom to a selected
feature etc and you can see that feature when you zoom in - you just can't
see the feature when zoomed to the extents of the feature class.
From: Toni Hefer
Sent: Tuesday, December 30, 2008 1:50 PM
To: 'postgis-users at postgis.refractions.net'
Subject: Converting data from SDE 9.3 sql server database to PostgreSQL
database with PostGIS geometry.
Hi - we have created a postgres database and are in the process of copying
the + 50 Gb of vector data in about 53 different feature classes into the
Postgres database. I am finding some very strange behavior when I use the
PG_Geometry keyword, some of which I have saved out in screenshots. I have
been using the following procedure to load the data:
7 Because I was getting errors, ArcCatalog was crashing and there
were many polygons missing, I have been copying the data into a file based
geodatabase, using the geometry fix tool in ArcCatalog and then loading the
data from the file based geodatabase.
7 If there was still data missing, I created a feature class and
loaded the data without using pg_geometry and the data seemed fine
7 I then tried loading the data from the default geometry feature
class into a new feature class using pg_geometry and there seemed to be the
same data missing as if I loaded directly from the fbgb
7 I am experiencing strange behavior if I bring the pg_geometry data
into ArcMap:
o Takes a long time to load
o If I get into an edit session, I can select a couple of polygons but if
I try to select a lot it gives me the following error: "Unable to create
logfile system tables. User perhaps lacks permissions or resources to create
tables[ERROR: schema "thefer" does not exist :: SQL state: 3F000]" which is
inconsistent with me being able to edit other data as usual
o While the same number of records are in the feature class as was in the
fgdb, only some of the features are visible (as you can see from first
attachment)
o When I try to use the select tool in ArcMap to select the entire
dataset, the following error occurs "There was an error executing the query.
Operation Failed[name of database.sde.name of dataset]
o When I select a portion of the data that cannot be seen when zoomed to
the extents of the dataset, those features can be seen as selected (these
features can be seen when you zoom in to them)
7 The third picture is the extent of the data as it should appear.
Is there any information you can give me that would cause this inconsistent
and unstable behavior?
I really will appreciate any help you can give me in this regard.
Toni
Toni Hefer
GIS Manager
Land Advisors Organization
4900 North Scottsdale Road, Suite 3000
Scottsdale, Arizona 85251
480.483.8100 | 800.888.0998
480.483.0000 Fax
www.landadvisors.com<http://www.landadvisors.com/>
| Please consider the environment before printing this e-mail.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/d7
e53925/attachment-0001.html
------------------------------
Message: 8
Date: Tue, 30 Dec 2008 16:54:19 -0500
From: "Paragon Corporation" <lr at pcorp.us>
Subject: RE: [postgis-users] The Old Who is using PostGIS survey
again?
To: "'PostGIS Users Discussion'"
<postgis-users at postgis.refractions.net>
Message-ID: <CFCA7EC3E5A441D4820376CFA4A2FAED at b>
Content-Type: text/plain; charset="us-ascii"
Thanks to all who have responded so far. Keep it coming. It is at the very
least very breathtaking to here of all the different ways people are using
PostGIS.
On the educational note, that is actually one of the reasons we want to
write a book. PostGIS seems like an ideal tool to introduce students to a
more or less unbiased view of spatial database analysis and its rather
disappointing that a lot of the education we see out there is froth with
ESRI centric training (not meaning to start an ESRI bashing war but we feel
education or at least grad/undergrad should be non-commercial oriented).
Well hopefully that is changing and it seems to be.
A section on Applications would be nice at least to provide people some sort
of breath of the possibilities I think.
Thanks,
Leo and Regina
_____
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Chetan
Tiwari
Sent: Tuesday, December 30, 2008 3:06 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] The Old Who is using PostGIS survey again?
It would be nice to have an introductory book - it can be something I could
use in some of the classes I teach. Are you planning to have a section on
'Applications'? Looking at some of the diverse examples of how people use
PostGIS, maybe people on this list (and others) can contribute towards a
chapter or so.
To answer your questions:
1) How you use PostGIS?
We use it extensively in a web-based environmental health surveillance
system. We've embedded kernel density estimation methods and some
environmental models in a PostGIS-based system that allows users, who may
not be experts in GIS and spatial analysis (say public health officials), to
create and analyze spatial patterns of disease outcomes, measure exposures
to environmental contaminants, and visualize some of these data using
technologies like Google Earth.
2) What you find useful about it over anything else?
Ability to efficiently handle large datasets. Ability to create a
user-friendly interface where complex analysis tasks are embedded within
web-based, automated routines. Ties in well with other WebGIS
infrastructure.
3) Why you think there should be any book written focused on its use and of
course if such a thing were to exist, would you buy it?
I would buy it, and possibly use it for teaching GIS programming, WebGIS
classes at the undergraduate (possibly graduate) level.
Chetan
--
Chetan Tiwari, PhD
Assistant Professor
University of North Texas
Department of Geography
1155 Union Circle #305279
Denton, TX 76203-5017
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/c2
de18c0/attachment-0001.html
------------------------------
Message: 9
Date: Tue, 30 Dec 2008 13:00:10 -0900
From: Dan Blomberg <services at gpsfiledepot.com>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <495A99EA.6080007 at gpsfiledepot.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
1) I use PostGIS to create topographic maps for
http://www.gpsfiledepot.com. I also suggest other people use it by
writing about it extensively in my tutorial on how to create Garmin
compatible topo maps. In addition; I've started using it for a program
I'm writing to help make topo maps.
2) I find the ability to run SQL queries on GIS data without the need to
load the data on screen the best benefit. Mainly this saves time having
to render the data for viewing in a GUI and thus significantly increases
the amount of data I can process and increases the speed.
3) Maybe; it would depend on what it included.
Paragon Corporation wrote:
> Leo and I have a good portion of a PostGIS book written. Ideally we would
> like to get a publisher to publish it, but seem to be running into the
same
> obstacles. No publisher seems to think people use PostGIS to warrant
enough
> demand for a book dedicated to it.
>
> So to make a decent case for a book, can each of you in your own words
> describe
>
> 1) How you use PostGIS?
> 2) What you find useful about it over anything else?
> 3) Why you think there should be any book written focused on its use and
of
> course if such a thing were to exist, would you buy it?
>
> Of course I'll also need some official download stats etc. which hopefully
> the Refractions group can help out with. I think Mark Cave-Ayland had
> posted some stats a while back, but can't find them.
>
> Thanks,
> Regina
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
------------------------------
Message: 10
Date: Tue, 30 Dec 2008 14:50:21 -0800
From: "Bob and Deb" <bobdebm at gmail.com>
Subject: [postgis-users] Help with an area and hole filter query?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<7a3148720812301450g59ac3a5rcb0160178926074c at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Hello PostGIS Users,
I have a polygon table that has many small areas and holes. Now, I would
like to remove small areas and holes that are 2800 m^2.
Any help or advice would be really appreciated.
Thanks in advance.
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/51
dd7a8a/attachment-0001.html
------------------------------
Message: 11
Date: Tue, 30 Dec 2008 15:01:30 -0800 (PST)
From: pcreso at pcreso.com
Subject: Fw: RE: [postgis-users] The Old Who is using PostGIS survey
again?
To: postgis-users at postgis.refractions.net
Message-ID: <23736.39502.qm at web33202.mail.mud.yahoo.com>
Content-Type: text/plain; charset=us-ascii
As a long time list leech I second that!!
Perusing the replies to such questions is always
interesting for me, both to find out what a wide range of
uses & users are out there, and to find colleagues who
are working in my field of interest who also use it.
I also think it is also useful for potential users to
search the list archives to locate others who have
successfully used POstGIS in their own areas of interest.
Thanks,
Brent Wood
--- On Wed, 12/31/08, Obe, Regina
<robe.dnd at cityofboston.gov> wrote:
> From: Obe, Regina <robe.dnd at cityofboston.gov>
> Subject: RE: [postgis-users] The Old Who is using PostGIS survey again?
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Wednesday, December 31, 2008, 4:11 AM
> I think the newsgroup is probably better even if it creates
> a bit of traffic. Its probably good traffic for future
> reference for others anyway.
> >
> Thanks,
> > Regina
------------------------------
Message: 12
Date: Wed, 31 Dec 2008 10:19:46 +1030
From: Stephen Davies <sdc at sdc.com.au>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <200812311019.46166.sdc at sdc.com.au>
Content-Type: text/plain; charset="iso-8859-1"
We use PostGIS to store, manipulate and display soil moisture & salinity
data
plus associated weather etc data for irrigators across southern Australia.
Mapserver is used to display maps and metrics (and Grace for associated
plots).
The database currently contains several million readings.
As a long-term PostgreSQL user and fan, it was a pretty obvious choice of
GIS
tool - particularly given it's open source nature. It is also attractive
because of it's integration with PostgreSQL which enables easy combinations
of GIS and relational data processing.
One area that I would like to see (better) documented is that of projections
and how to mix/transform data collected with different projections eg
lat/long and AMG.
HTH,
Stephen
The On Wednesday 31 December 2008 04:06:20 Paragon Corporation wrote:
> To answer the question some of you have asked.
>
> Our planned break down was as follows (though given input we may change
our
> concentration of effort in certain areas)
>
> 1) Basic Beginner stuff --
> A) a lot of time spent on how to load and dump data from-to various data
> sources using shp2pgsql, pgsql2shp, OGR2OGR
> B) Basic info of where to get data
> C) Open source tools you can use to view the data once loaded (OpenJump,
> uDig, Quantum,gvSig and pros and cons of each)
> We would throw GRASS in there too but don't have any experience with
> that. D) SQL Primer (INNER, LEFT, EXCEPT, CROSS JOINS, aggregates what
they
> are and how to use them properly) - gotchas with aggregates in PostGIS E)
> Using planner -- how to decide on indexes (and of course how to create a
> spatial index)
>
> 2) Mid Level stuff -- using table inheritance, writing plpgsql spatial
> stored procs, triggers for maintaining spatial relationships, constraints
> Security management
>
> 3) Recipe section on common use cases -- e.g. splitting geometries in
> various fashions, translation etc., statitical analysis examples,
proximity
> examples
>
> 4) High Level stuff -- a little coverage on PgRouting and possibly PL/R,
> Some spatial tricks using the upcoming 8.4 windowing functions
>
>
> Hope that helps,
> Leo
--
============================================================================
=
Stephen Davies Consulting P/L Voice: 08-8177
1595
Adelaide, South Australia. Fax : 08-8177
0133
Computing & Network solutions. Mobile:040 304
0583
VoIP:sip:1132210 at sip1.bbpglobal.com
------------------------------
Message: 13
Date: Tue, 30 Dec 2008 16:58:59 -0700
From: "Richard Greenwood" <richard.greenwood at gmail.com>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<ae9185aa0812301558q2ac40fd3wcb85764d6539a7b8 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
> 1) How you use PostGIS?
Primarily as a backend for MapServer. My applications serve public,
county government data for several Northern Rockies counties.
> 2) What you find useful about it over anything else?
Obviously a spatially enabled database is handy in that spatial and
attribute data are stored, and accessed, together. Postgres/PostGIS is
cost effective for small governmental bodies. And while cost
effective, it is not lacking in features or power.
> 3) Why you think there should be any book written focused on its use and
of
> course if such a thing were to exist, would you buy it?
Books are wonderful things, duh. Before Google that was all we had.
Yeah, I'll buy it.
--
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
------------------------------
Message: 14
Date: Tue, 30 Dec 2008 16:37:35 -0800
From: Dane Springmeyer <blake at hailmail.net>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <FEA74633-61C7-40A0-9AF8-A21C5F663C8E at hailmail.net>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
On Dec 30, 2008, at 4:21 AM, Paragon Corporation wrote:
> 1) How you use PostGIS?
As a platform for terrain and hydrological modeling, a database
backend for web sites developed using GeoDjango, and as a datasource
for rendering with Mapnik.
> 2) What you find useful about it over anything else?
PostGIS is an amazing tool for instructing/teaching the basics of GIS
and open source tools.
The community and documentation are top notch.
The mature functions for advanced data processing and visualization
make it a touchstone tool in the open source gis users toolbox.
> 3) Why you think there should be any book written focused on its use
> and of
> course if such a thing were to exist, would you buy it?
Yes! I think a book of the nature described by Regina would quickly
become the most recommended and useful book for beginners and experts
alike in the open source gis realm.
Dane
------------------------------
Message: 15
Date: Tue, 30 Dec 2008 20:15:02 -0500
From: "Paragon Corporation" <lr at pcorp.us>
Subject: RE: [postgis-users] Help with an area and hole filter query?
To: "'PostGIS Users Discussion'"
<postgis-users at postgis.refractions.net>
Message-ID: <D4DF45C8E69043B2BAEBB9CAEE81A7A5 at b>
Content-Type: text/plain; charset="us-ascii"
Bob,
Are you looking to fill in the holes or just exclude polygons with small
holes and that have small areas.
Anyrate you should take a look at
http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.
html (will give you number of holes)
ST_InterionRingN
http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.
html (will give you the holes)
Then use ST_BuildArea to convert holes to polygons so you can take the
ST_Area of it.
http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html
_____
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Bob and
Deb
Sent: Tuesday, December 30, 2008 5:50 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Help with an area and hole filter query?
Hello PostGIS Users,
I have a polygon table that has many small areas and holes. Now, I would
like to remove small areas and holes that are 2800 m^2.
Any help or advice would be really appreciated.
Thanks in advance.
Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/81
0df088/attachment-0001.html
------------------------------
Message: 16
Date: Wed, 31 Dec 2008 00:45:20 -0500
From: Stephen Woodbridge <woodbri at swoodbridge.com>
Subject: Re: [postgis-users] Pgrouting directions
To: PostGIS Users Discussion <postgis-users at postgis.refractions.net>
Message-ID: <495B06F0.5000004 at swoodbridge.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Ahmad Bdair wrote:
> Yes, that is something very similar to what I need to do, I already
> wrote a php code to check angels and slopes, but it was not accurate, it
> was more life "if else" code, I check the longlat for current segment
When you check the angles do not use the end points because they are
mis-leading.
B+---\
|
A+---/
If you have a segment from A to B like the above and you calculate the
heading or angles based on the vector AB then it will point north and is
should be pointing west at the end of the vector or east at the start of
the vector.
You also need to look at weather or not you need to flip segments
because you route might traverse them from start to end OR from end to
start.
When I compute angles I grid the angles into 8 pie pieces of 45 degrees
each.
continue straight
turn slight right/left
turn right/left
turn sharp right/left
make a u-turn
> with longlat for the previous one, I guess you didn't use the database
> for direction calculation(except for routing) am I right? Isn't steps 3
> and 4 depends on your angel calculations?
I have done this in C in a prototype router I wrote years ago. I have
implemented it in PHP and in perl in various incarnations in the past.
The demo page has it written in pgpsql, but it is based on my own
heavily modified versions of the pgRouting stored procedures.
Hope the above helps with your problems. I find it easiest to work out
the math problems of computing the angles and headings first and make
sure they are correct. Then move on to the other issues. If your math is
wrong computing the headings and angles it will cloud all the other results.
Best regards,
-Steve
> I have the roads with two different languages, a road map like anyother
> road map I guess.
>
> On Tue, Dec 30, 2008 at 3:17 AM, Stephen Woodbridge
> <woodbri at swoodbridge.com <mailto:woodbri at swoodbridge.com>> wrote:
>
> bdair2002 wrote:
>
> Hello,
> I am developing an application using Pgrouting with Postgis
> data, everything
> is fine, but now I am looking to do something like Google
> directions guide,
> where it tells you turn left or right, I am wondering if this
> feature is a
> built-in feature in Pgrouting or Postgis.
>
> Regards
>
>
> No this is not a feature that is part of either.
>
> I have implemented a directions explicator, but it is somewhat
> specific to the data that you have, as you need to know what
> column(s) contain the road names, if you have signage information
> then you need to know how to link to that. If you want to be able to
> explicate in multiple languages, then you probably need to consider
> supporting multiple languages each in a separate table the you can
> select from when you generate the languages.
>
> The algorithm is pretty straight forward as the you currently get a
> list of segments that make up the route. Then you need to:
>
> analyze each segment and
> 1) check to see if you want to join it with the previous segment
> because the road name matches
> 2) check the angle that it makes with the last segment to determine
> right, left, straightness of turn
> 3) compute the compass heading for the segment
> 4) determine if you have signage
> 5) based on these, determine if you are read to explicate and which
> predefined instruction you need to explicate an instruction
> 6) loop through all segments
>
> For a demo of this you can try:
> http://imaptools.com/leaddog/routing/dd.html
>
> Zoom into a city in one of the yellow areas, set a start and end
> point and click [calculate route] button. The driving directions
> should show below the button if it was successful, be patience the
> routing is running on a 333MHz box.
>
> -Steve
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> <mailto:postgis-users at postgis.refractions.net>
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
------------------------------
Message: 17
Date: Tue, 30 Dec 2008 23:08:00 -0800
From: "Bob and Deb" <bobdebm at gmail.com>
Subject: Re: [postgis-users] Help with an area and hole filter query?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<7a3148720812302308r2066202fof75a3b4714f24f31 at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
I am hoping to fill in the small holes and remove small areas. I'll read up
on these functions and see what I can come up with, but I might need help in
making an efficient query since there are over 100K polygons.
Thank you for your help.
Bob
On Tue, Dec 30, 2008 at 5:15 PM, Paragon Corporation <lr at pcorp.us> wrote:
> Bob,
>
> Are you looking to fill in the holes or just exclude polygons with small
> holes and that have small areas.
>
> Anyrate you should take a look at
>
>
>
http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.
html
> (will give you number of holes)
>
>
> ST_InterionRingN
>
>
>
http://postgis.refractions.net/documentation/manual-svn/ST_NumInteriorRings.
html
> (will give you the holes)
>
> Then use ST_BuildArea to convert holes to polygons so you can take the
> ST_Area of it.
>
> http://postgis.refractions.net/documentation/manual-svn/ST_BuildArea.html
>
>
>
> ------------------------------
> *From:* postgis-users-bounces at postgis.refractions.net [mailto:
> postgis-users-bounces at postgis.refractions.net] *On Behalf Of *Bob and Deb
> *Sent:* Tuesday, December 30, 2008 5:50 PM
> *To:* PostGIS Users Discussion
> *Subject:* [postgis-users] Help with an area and hole filter query?
>
> Hello PostGIS Users,
>
> I have a polygon table that has many small areas and holes. Now, I would
> like to remove small areas and holes that are 2800 m^2.
>
> Any help or advice would be really appreciated.
>
> Thanks in advance.
>
> Bob
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081230/9d
b5b26a/attachment-0001.html
------------------------------
Message: 18
Date: Wed, 31 Dec 2008 10:06:20 +0000
From: Mark <mark.balman at gmail.com>
Subject: [postgis-users] The Old Who is using PostGIS survey again?
To: postgis-users at postgis.refractions.net
Message-ID: <495B441C.3070902 at gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hi all
I have been wondering when a book on the joys of postgis would be written.
Here are my survey answers
1) How you use PostGIS?
Currently I am using postgis at home for personal projects dealing with
wildlife conservation issues as well as teaching myself new technologies. I
am impressed not only with the ability to store and analyse spatial and non
spatial data in the same database but also the ability to display query
results through mapserver and geoserver for web based tools as well as
through desktop applications such as uDIG, QGIS and GRASS. I am also trying
to implement postgis/mapserver at my workplace to assist with our global
conservation efforts.
2) What you find useful about it over anything else?
I like the idea of having my data in one place with the ability to analyse
and output results in various formats such as kml and shapefiles and all of
this for free (we do not have the money to explore proprietary databases
such as Oracle, SQL Server)
3) Why you think there should be any book written focused on its use and of
course if such a thing were to exist, would you buy it?
I think that there are enough users to warrant a book of this type, I am
constantly amazed at how quick the postgis users respond to any questions
posted. I would definitely buy this book as I have several FOSS GIS books
and this would make a valuable contribution to my little library. Not too
sure how you would cover such a potentially huge range of interests and
experiences, but I would like to see something that covers numerous examples
ranging from basic to complex
Best wishes for 2009 everyone!
Mark
------------------------------
Message: 19
Date: Wed, 31 Dec 2008 06:14:33 -0500
From: "Jay Cummins" <cumminsjp at gmail.com>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<dcf9a2d30812310314q6bf58b90i9ac62fb513816b41 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
1) How you use PostGIS?
I use it at home for self-teaching of spatial databases and for trying
GIS software such as uDIG and QGIS.
Using PostGIS relaxes me. If I have a bad day at work on the ESRI
stack, I'll either have a beer or play with PostGIS (sometimes both).
2) What you find useful about it over anything else?
It's cheaper than therapy and it doesn't impair my ability to drive
afterwards.
3) Why you think there should be any book written focused on its use and of
course if such a thing were to exist, would you buy it?
YES!
-Jay Cummins
On Tue, Dec 30, 2008 at 7:21 AM, Paragon Corporation <lr at pcorp.us> wrote:
> Leo and I have a good portion of a PostGIS book written. Ideally we would
> like to get a publisher to publish it, but seem to be running into the
same
> obstacles. No publisher seems to think people use PostGIS to warrant
enough
> demand for a book dedicated to it.
>
> So to make a decent case for a book, can each of you in your own words
> describe
>
> 1) How you use PostGIS?
> 2) What you find useful about it over anything else?
> 3) Why you think there should be any book written focused on its use and
of
> course if such a thing were to exist, would you buy it?
>
> Of course I'll also need some official download stats etc. which hopefully
> the Refractions group can help out with. I think Mark Cave-Ayland had
> posted some stats a while back, but can't find them.
>
> Thanks,
> Regina
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
------------------------------
Message: 20
Date: Wed, 31 Dec 2008 04:32:09 -0700
From: "Gregory Williamson" <Gregory.Williamson at digitalglobe.com>
Subject: RE: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion"
<postgis-users at postgis.refractions.net>, "PostGIS Users
Discussion"
<postgis-users at postgis.refractions.net>
Message-ID:
<8B319E5A30FF4A48BE7EEAAF609DB233021F38C7 at COMAIL01.digitalglobe.com>
Content-Type: text/plain; charset="iso-8859-1"
Jay Cummins wrote:
<...>
> > 2) What you find useful about it over anything else?
> It's cheaper than therapy and it doesn't impair my ability to drive
afterwards.
SBOBNL* !
This ought to be an (un)official slogan, or perhaps a pull quote ... made
this person's day.
I want to send an answer to the original questions, but we're more ...
formal ... now, so I have to get some form of formal sign-off for anything
public ... should only be a a day or two, but then, these are the holidays
and lots of folks are off.
Thanks [wiping beer off the screen],
Greg Williamson
Senior DBA
DigitalGlobe
Confidentiality Notice: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information and must be protected in accordance with those
provisions. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message.
(My corporate masters made me say this.)
* Sprayed Beer Out Both Nostrils Laughing
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.refractions.net/pipermail/postgis-users/attachments/20081231/0c
02947d/attachment-0001.html
------------------------------
Message: 21
Date: Wed, 31 Dec 2008 14:08:07 +0100
From: "Stefan Keller" <sfkeller at gmail.com>
Subject: Re: [postgis-users] The Old Who is using PostGIS survey
again?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<25bc040b0812310508r6be30829w9b2de0a753146b12 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
1) How you use PostGIS?
We use it in our university courses (bachelor degree) about databases
and we are giving courses about it (next one in January, see
http://gis.hsr.ch/wiki/Agenda).
2) What you find useful about it over anything else?
* It's more compatible to SQL than others in the same leagues (say
ORACLE and MySQL).
* It's made for production and professional environments
* Users (and students) can install it without license troubles
3) Why you think there should be any book written focused on its use and of
course if such a thing were to exist, would you buy it?
A book like this shows the relevance of a product in the market and an
academic institution we buy "any" relevant book we can get hold of :->
Yours,
Stefan
http://www.gis.hsr.ch/wiki/PostGIS
2008/12/31 Gregory Williamson <Gregory.Williamson at digitalglobe.com>:
> Jay Cummins wrote:
>
> <...>
>
>> > 2) What you find useful about it over anything else?
>> It's cheaper than therapy and it doesn't impair my ability to drive
>> afterwards.
>
> SBOBNL* !
>
> This ought to be an (un)official slogan, or perhaps a pull quote ... made
> this person's day.
>
> I want to send an answer to the original questions, but we're more ...
> formal ... now, so I have to get some form of formal sign-off for anything
> public ... should only be a a day or two, but then, these are the holidays
> and lots of folks are off.
>
> Thanks [wiping beer off the screen],
>
> Greg Williamson
> Senior DBA
> DigitalGlobe
>
> Confidentiality Notice: This e-mail message, including any attachments, is
> for the sole use of the intended recipient(s) and may contain confidential
> and privileged information and must be protected in accordance with those
> provisions. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
sender
> by reply e-mail and destroy all copies of the original message.
>
> (My corporate masters made me say this.)
>
> * Sprayed Beer Out Both Nostrils Laughing
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
------------------------------
Message: 22
Date: Wed, 31 Dec 2008 17:25:23 +0200
From: "Intengu Technologies" <sindile.bidla at gmail.com>
Subject: [postgis-users] How to populate a column with results of
isvalid
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<a1afa64b0812310725t736291a2jc27ccc293d538513 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
I have loaded a polygon shapefile into postgis and would like to tag
each row with the results of st_isvalid in a new field. I found this
query in the postgis manual "ALTER TABLE mytable ADD CONSTRAINT
geometry_valid_check CHECK (isvalid((the_geom));" when I run the query
it picks an invalid geometry and stops
--
Sent from my mobile device
Sindile Bidla
------------------------------
Message: 23
Date: Wed, 31 Dec 2008 10:54:47 -0500
From: "Obe, Regina" <robe.dnd at cityofboston.gov>
Subject: RE: [postgis-users] How to populate a column with results of
isvalid
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<53F9CF533E1AA14EA1F8C5C08ABC08D2053B49BA at ZDND.DND.boston.cob>
Content-Type: text/plain; charset="us-ascii"
You wouldn't use that for tagging. That is used if you want to prevent
people from adding invalid geometries into your table. If you have
already got invalid geometries it will just fail since you have already
violated the rule you are trying to establish.
To add a field
ALTER TABLE mytable ADD COLUMN the_geom_is_valid boolean ;
UPDATE mytable SET the_geom_is_valid = ST_IsValid(the_geom); //will
update existing
Unfortunately you can't put in a default value that references another
column which I think you may be looking for if you want to continually
add new data and have that field automatically fill. For that you'll
need a (preferably BEFORE TRIGGER).
Hope that helps,
Regina
-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Intengu Technologies
Sent: Wednesday, December 31, 2008 10:25 AM
To: PostGIS Users Discussion
Subject: [postgis-users] How to populate a column with results of
isvalid
I have loaded a polygon shapefile into postgis and would like to tag
each row with the results of st_isvalid in a new field. I found this
query in the postgis manual "ALTER TABLE mytable ADD CONSTRAINT
geometry_valid_check CHECK (isvalid((the_geom));" when I run the query
it picks an invalid geometry and stops
--
Sent from my mobile device
Sindile Bidla
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.
------------------------------
Message: 24
Date: Wed, 31 Dec 2008 19:17:19 +0200
From: "Intengu Technologies" <sindile.bidla at gmail.com>
Subject: [postgis-users] Re: How to populate a column with results of
isvalid
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<a1afa64b0812310917s10e43a8dse8ad8acf58eb01c5 at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Thanks Regina your solution was spot on.
On 12/31/08, Obe, Regina <robe.dnd at cityofboston.gov> wrote:
> You wouldn't use that for tagging. That is used if you want to prevent
> people from adding invalid geometries into your table. If you have
> already got invalid geometries it will just fail since you have already
> violated the rule you are trying to establish.
>
> To add a field
>
> ALTER TABLE mytable ADD COLUMN the_geom_is_valid boolean ;
> UPDATE mytable SET the_geom_is_valid = ST_IsValid(the_geom); //will
> update existing
>
> Unfortunately you can't put in a default value that references another
> column which I think you may be looking for if you want to continually
> add new data and have that field automatically fill. For that you'll
> need a (preferably BEFORE TRIGGER).
>
> Hope that helps,
> Regina
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
> Intengu Technologies
> Sent: Wednesday, December 31, 2008 10:25 AM
> To: PostGIS Users Discussion
> Subject: [postgis-users] How to populate a column with results of
> isvalid
>
> I have loaded a polygon shapefile into postgis and would like to tag
> each row with the results of st_isvalid in a new field. I found this
> query in the postgis manual "ALTER TABLE mytable ADD CONSTRAINT
> geometry_valid_check CHECK (isvalid((the_geom));" when I run the query
> it picks an invalid geometry and stops
>
> --
> Sent from my mobile device
>
> Sindile Bidla
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> -----------------------------------------
> The substance of this message, including any attachments, may be
> confidential, legally privileged and/or exempt from disclosure
> pursuant to Massachusetts law. It is intended
> solely for the addressee. If you received this in error, please
> contact the sender and delete the material from any computer.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
--
Sent from my mobile device
Sindile Bidla
------------------------------
Message: 25
Date: Wed, 31 Dec 2008 19:12:45 +0100
From: "Stefan Keller" <sfkeller at gmail.com>
Subject: [postgis-users] What SQL admin tools are you using?
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Message-ID:
<25bc040b0812311012u2bf7f2efo1510378ba5209a7c at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Regaring surveys... I have yet another question:
What PostGIS/PostgreSQL admin tools are you using?
I think up to now there have been three possibilities:
1. GIS built in (GUI)
2. psql (CLI)
3. pgAdminIII (GUI)
Recently I've found a nice alternative to 3. pgAdminIII, called:
4. "SQL Workbench/J" (www.sql-workbench.net).
Stefan
NOTE: Download SQL Workbench/J development build 102.8 (2008-12-31) or
later! In order to display geometry data as text (i.e. as WKT) in
SELECT statements, follow the following instructions (from:
http://www.sql-workbench.net/dev-history.txt > Build 102.8,
31.12.2008)
> Enh: (102.7) for specific datatypes, data retrieval in the DbExplorer can
now
> be done by applying expressions to the column when building the SQL
> to select the data.
So, for every DB there are configurations entries in a file called
"workbench.settings" (Windows users look at "C:\Documents and
Settings\<user>\.sqlworkbench\"). There, the following line has to be
inserted:
workbench.db.postgres.selectexpression.geometry=astext(transform(${column},4
326))
Now, for SELECT statements in the DbExplorer view of SQL Workbench/J
all column values of type geometry get through this function.
------------------------------
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
End of postgis-users Digest, Vol 74, Issue 28
*********************************************
More information about the postgis-users
mailing list