New software: PGAT aims to be a graphical interface for PostGIS

Hello list,

I would like to announce the availability of a new project that has the
goal to become a graphical interface to PostGIS.

PGAT is a graphical interface to PostGIS focused in mapping the spatial
operators defined in PostGIS. PGAT is implemented with Java and uses
GeoTools to render the geometries. PGAT is focused in using plain SQL
statements to carry on most functionalities. The license type is GNU
General Public License (GPL).

The currently functionalities (version 0.1 beta) are:

- Create/Delete spatial databases
- Import/Export shape files
- Manage tables and geometry Views
- Delete layers
- Add/Delete geometry columns
- Spatial Indexes (create, drop, vacuum)
- Copy layers (schema and data)
- Convert tables to views and viceversa
- Queries
- Work with schemas
- Spatial operations (buffer, dissolve)
- Log system to control errors and see SQL statements
- Dissolve improvement using spatial relations
- Spatial Indexes information

The project is still in its first phase of development. To continue with
this project I would like to know the opinions of the potential users

Open Source GIS Gathering San Diego (OSG-SD) - June 18th, 2007 at San Diego State University

Folks, save the datum.

We're tentatively planning a 2nd Annual Open Source
GIS Gathering to be held on Monday, June 18th -
probably starting early afternoon, ending late in the
evening. The same Monday of the Plenary Session(s) of
another famous GIS conference held in San Diego.

Don't be lost in space... San Diego State University's
Visualization Lab is easy to find via trolley from the
San Diego Convention Center area.

We filled the Lab in 2006, and arrangements are being
made to accommodate more. Suggested ideas for this
year include technical workshops and roundtable
discussions.

If you, or anyone you know, would be interested in
presenting on an open source GIS topic, or conducting
a technical workshop, please contact Dana Nibby here:
danaspatial <at> yahoo.com.

There's now a mailing list for OSG-SD 2007. If you
think you may be interested in attending, please
sign-up below:

http://lists.telascience.org/mailman/listinfo/osg-sd

Spread the word to the extent possible.

Re: [postgis-users] Open Source GIS Gathering San Diego (OSG-SD) - June18th, 2007 at San Diego State University

Thanks for the heads-up Dana,

We'll want to make sure to supply your meeting with a deck of invites to the Big 
Gathering (tm) :), FOSS4G 2007, as well as other goodies. I would like to be 
there myself, but will have a young baby to deal with at the time, so may have 
to settle for just sending software and tee-shirts.

Paul

Quoting dnrg <dananrg@...>:

> Folks, save the datum.
> 
> We're tentatively planning a 2nd Annual Open Source
> GIS Gathering to be held on Monday, June 18th -
> probably starting early afternoon, ending late in the
> evening. The same Monday of the Plenary Session(s) of
> another famous GIS conference held in San Diego.
> 
> Don't be lost in space... San Diego State University's
> Visualization Lab is easy to find via trolley from the
> San Diego Convention Center area.
> 
> We filled the Lab in 2006, and arrangements are being
> made to accommodate more. Suggested ideas for this
> year include technical workshops and roundtable
> discussions.
> 
> If you, or anyone you know, would be interested in
> presenting on an open source GIS topic, or conducting

OT: radio podcast of a programme presenting Open Source on New Zealand national radio today.

Apologies for the cross posting, but this might have broad appeal....

Today's topic on a weekly national radio radio programme (in New Zealand) on
"New Technology" was Open Source software.

The podcast is here if anyone is interested. Pretty simple overview....

http://podcast.radionz.co.nz/ntn/ntn-20070301-1145-New_Technology-064.mp3

Cheers,

  Brent Wood

Re: OT: radio podcast of a programme presenting Open Source on New Zealand national radio today.

Brent,

Under what licence is this clip under? I.e. can I post it to
http://digitalfreedom.uwc.ac.za as a podcast there too? Do you know how
I would get in touch with the original author(s)?

Thanks

--Paul

On Wed, 2007-02-28 at 20:41 -0800, Brent Wood wrote:
> 
> Apologies for the cross posting, but this might have broad appeal....
> 
> Today's topic on a weekly national radio radio programme (in New Zealand) on
> "New Technology" was Open Source software.
> 
> The podcast is here if anyone is interested. Pretty simple overview....
> 
> http://podcast.radionz.co.nz/ntn/ntn-20070301-1145-New_Technology-064.mp3
> 

All Email originating from UWC is covered by disclaimer
http://www.uwc.ac.za/portal/uwc2006/content/mail_disclaimer/index.htm 

_______________________________________________

Re: Boundary() without the internal holes?

Thanks Brad,

ExteriorRing() did the job.

For the benefit of list searchers in the future...

The problem at hand was to create a boundary around a bunch of land  
parcels that make up a neighborhood.
The space taken up by the streets is "empty" in that there is no  
polygon to represent it.

Step 1 was to add a neighborhood attribute and get it set to the  
correct value.

Step 2 was to add some small polygons to block off the street  
openings at the boundaries of the neighborhood. I gave them all a  
special tag that makes it easy to remove them when I'm finished.

Step 3 was to create the boundary using the ExteriorRing() function.

The query for an individual neighborhood looks like this:

INSERT INTO n_bounds (neighborhood,the_geom) SELECT  
p.neighborhood,MakePolygon(ExteriorRing(geometryN(geomunion 
(p.the_geom),1)))
FROM parcels AS p WHERE p.neighborhood=6;

Form a computational standpoint, I suspect this query is a disaster,  
but this is a one time shape generation, so waiting a bit longer for  
the result makes no difference.

Re: zcta census data, help with query

Ok, so I went back and looked over what I had done to import the data
and one stupid error I think I made was here:

shp2pgsql -s 2230 -d zt06_d00.shp public.ziptest > zip.sql

Census docs say that the SRID for the zcta data is actually 4269
(lon,lat). So I re-imported the generated sql with the correct srid
param and tested the data with the query:

select zcta, x(centroid(transform(the_geom, 4269))) as longitude,
y(centroid(transform(the_geom, 4269))) as latitude from ziptest where
zcta = 92116;

 zcta  |     longitude     |     latitude
-------+-------------------+------------------
 92116 | -117.121819788206 | 32.7655437135842

The point appears where I think it should however I still get false
when doing my within or contains queries:

SELECT zcta, contains (Transform(SetSRID(MakePoint(-117.119403,
32.771608),4269),4269), the_geom) from ziptest where zcta = 92116;
 zcta  | contains
-------+----------
 92116 | f
(1 row)

Thanks to anyone who can help me out,
Matt

Aggregate?

All,

I have a postGIS feature data set of the ranges of species, with many
separate records for each species name.  I would like to aggregate these
into a table with one multi-poly feauture for each species.  Should I use
Collect() for this task?  And could somebody give me quick example?

Thanks,
Steve

Stephen Crawford
Center for Environmental Informatics
GeoVISTA Center
The Pennsylvania State University
814.865.9905
src176 <at> psu.edu

Re: Aggregate?

Something like:

SELECT name, collect(the_geom)) AS the_geom,
    FROM constituencies
   GROUP BY constituencies.name;

Works for me. Use collect(geometryn(the_geom, 1)) id your data is 
specified as singular multigeometries.

Laurence

Stephen Crawford wrote:
> All,
> 
> I have a postGIS feature data set of the ranges of species, with many
> separate records for each species name.  I would like to aggregate these
> into a table with one multi-poly feauture for each species.  Should I use
> Collect() for this task?  And could somebody give me quick example?
> 
> Thanks,
> Steve
> 
> Stephen Crawford
> Center for Environmental Informatics
> GeoVISTA Center
> The Pennsylvania State University
> 814.865.9905
> src176 <at> psu.edu

RE: Re: Aggregate?

Thanks. 

I don't quite understand this part:
"Use collect(geometryn(the_geom, 1)) id your data is specified as singular
multigeometries."

Also, if I want to keep a few of the record for based on another another
value, should this work?:

SELECT name, party, collect(the_geom)) AS the_geom,
    FROM constituencies
   GROUP BY constituencies.name, constituencies.party;

Thanks,
Steve

-----Original Message-----
From: postgis-users-bounces <at> postgis.refractions.net
[mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Laurence
Rowe
Sent: Thursday, March 01, 2007 3:29 PM
To: postgis-users <at> postgis.refractions.net
Subject: [postgis-users] Re: Aggregate?

Something like:

SELECT name, collect(the_geom)) AS the_geom,
    FROM constituencies
   GROUP BY constituencies.name;