PostGIS users

Daniel Kastl | 1 Aug 2008 02:29

Re: pgrouting

Hi,

If you have no idea what to start with I recommend you to take a look at
the tutorial: http://pgrouting.postlbs.org/wiki/WorkshopFOSS4G2007

Daniel

searchelite schrieb:
> Hi all..can anyone tell me about the pgrouting..
> I have roads table, vehicle point table and emergency point table..
> I want to calculate shortest route where vehicle point as the source and
> emergency point as a target..
>
> Thank you 
>

headers

danny | 1 Aug 2008 12:12

Merge all polygons from a dataset

Hello everybody,

I've converted a shapefile of Europe to PostGIS. I would like to merge all the countries together so that I only have one polygon left, the whole contour of Europe. I have tried ST_Union that gives me no result. I've tried several other functions to no avail. Does anybody know how I should proceed?

Many thanks,

Erik

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

headers

Sophie GRAS | 1 Aug 2008 12:20

Re: JSON

Hi everybody,
i want to use the asgeojson function.
Do you know where we can find the 1.3.4 version of postgis ?
once you have your data in the "geojson format", how do you "call" it in the json file ?
Thanks for your help

Sophie

----- Mail Original -----
De: "Paragon Corporation" <lr <at> pcorp.us>
À: "PostGIS Users Discussion" <postgis-users <at> postgis.refractions.net>
Envoyé: Jeudi 31 Juillet 2008 07:16:24 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: RE: [postgis-users] JSON

We should update the docs to have an Availability section for the Geometry
Outputs. Well at the very least for the ST_AsGeomJson.

It confused me too when I tried to use that function and realized it was in
an unreleased version.

-----Original Message-----
From: postgis-users-bounces <at> postgis.refractions.net
[mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, July 30, 2008 7:29 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] JSON

I think it's unreleased on the 1.3 branch. I have it here on my development
box. So 1.3.4 would have it.

# select st_asgeojson(geom) from fe_edges limit 1;
st_asgeojson
----------------------------------------------------------------------------
----------------------------------------------------

{"type":"MultiLineString","coordinates":[[[-89.734634999999997,31.4920720000
00000],[-89.734955999999997,31.492237999999997]]]}
(1 row)

On Wed, Jul 30, 2008 at 4:16 PM, Jim <jbucher <at> cnrit.tamu.edu> wrote:
> I just installed 1.3.3 and I don't see an ST_AsGeoJson or an AsGeoJson
> function.
>
> Paul Ramsey wrote:
>>
>> Jim,
>>
>> We've got that contribution already,
>>
>>
>> http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2
>> 975494
>>
>> Thanks though!
>>
>> Paul
>>
>
> _______________________________________________
> postgis-users mailing list
> 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

_______________________________________________
postgis-users mailing list
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

headers

Mark Cave-Ayland | 1 Aug 2008 12:41

Re: postgis on Debian 4.0

Adrian wrote:
> I'm trying to create a postgis database on a brand new install of Debian 
> 4.0r2 (which I understand is the stable, rock solid no problems 
> version), using the following steps:
> 
> aptitude install postgresql-8.1-postgis
> su - postgres
> createuser <username>
> createdb -E UTF8 -O <username> <dbname>
> createlang plpgsql <dbname>
> 
> Everything looks OK until I do
> 
> psql -d gis -f /usr/share/postgresql-8.1-postgis/lwpostgis.sql
> 
> and then I get lots of error messages that start with:
> 
> psql:/usr/share/postgresql-8.1-postgis/lwpostgis.sql:39: NOTICE:  type
> "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:/usr/share/postgresql-8.1-postgis/lwpostgis.sql:39: ERROR:  could
> not load library "/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1":
> /usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1: undefined symbol:
> vacuum_delay_point
> psql:/usr/share/postgresql-8.1-postgis/lwpostgis.sql:44: ERROR:  current
> transaction is aborted, commands ignored until end of transaction block
> 
> Any suggestions on how to fix it? I would have though many people have 
> been here before me, but I can't find them with Google. It looks to me 
> like the 8.1 version of the lwpostgis.sql script doesn't match the 
> shared library in the 8.1 release.

Eh? This looks like a broken package/installation - vacuum_delay_point 
was added in PostgreSQL 8.0 and so something else is wrong here. Are you 
sure you don't have multiple versions of PostGIS / lwpostgis.sql installed?

BTW PostgreSQL 8.1 and PostGIS 1.1 are both extremely old - you should 
really consider building the latest PostGIS 1.3.x release to avoid 
several nasty PostGIS bugs, and preferably a newer version of PostgreSQL 
at the same time.

ATB,

Mark.

--

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063

headers

Pedro Doria Meunier | 1 Aug 2008 12:37

Re: Merge all polygons from a dataset

Hi Erik,

(PostGIS 'listers' please forgive me)

I know this is a bit off-topic but have you tried OpenJump?
http://openjump.org/wiki/show/HomePage

You have easy-going multiple polygons merging...

As to what Erik asked, I'd also like to know as I've never tried that too ...

HTH,
Pedro Doria Meunier

On Fri, 2008-08-01 at 12:12 +0200, danny wrote:

Hello everybody,

I've converted a shapefile of Europe to PostGIS. I would like to merge all the countries together so that I only have one polygon left, the whole contour of Europe. I have tried ST_Union that gives me no result. I've tried several other functions to no avail. Does anybody know how I should proceed?

Many thanks,

Erik

_______________________________________________ postgis-users mailing list 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

headers

Courtin Olivier | 1 Aug 2008 12:41

Re: JSON


On Aug 1, 2008, at 12:20 PM, Sophie GRAS wrote:

Hi Sophie,

> i want to use the asgeojson function.
> Do you know where we can find the 1.3.4 version of postgis ?

This version is not yet released,
You could use the current SVN version from 1.3 branch:

svn checkout http://svn.refractions.net/postgis/branches/1.3 postgis-1.3

(require to have an svn client already installed, cf http://subversion.tigris.org/)

> once you have your data in the "geojson format", how do you "call"  
> it in the json file ?

Not sure to really understand the question, below a working use case:

SELECT ST_AsGeoJson(the_geom) FROM your_table LIMIT 1;

and copy/paste the result in OpenLayers:
cf <http://openlayers.org/dev/examples/vector-formats.html>

HTH,

--
Olivier

headers

Obe, Regina | 1 Aug 2008 12:56

RE: JSON

Sophie,

The 1.3.4 is well not actually released yet, but you can get it from the svn repository

By following the instructions here

http://postgis.refractions.net/download/ (on how to connect to the repository)

Then checkout the branches/1.3

I was hoping it would be a bit easier - to just download the postgis-svn.tar.gz (but looking at that - that looks like the 1.4 version which is kind of unstable at the moment I think).

HINT HINT to someone in dev group: Maybe we should also output the 1.3 branch as a tar.gz?

After you have compiled etc, it outputs just the geojson part, so you'll need to glue the strings (forming your attribute) together with your favorite web language e.g. PHP, python, .NET, Perl, whatever

and then you could use OpenLayers which has a driver for GeoJSON format as described

here: http://dev.openlayers.org/docs/files/OpenLayers/Format/GeoJSON-js.html

and example here (actually this one you can cut and paste an individual GeoJSON output geometry to see how it looks - take for example Paul's example below - get rid of the line breaks and paste in)

http://dev.openlayers.org/sandbox/tschaub/feature/examples/geojson.html

Hope that helps,

Regina

From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Sophie GRAS
Sent: Friday, August 01, 2008 6:20 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] JSON

Hi everybody,
i want to use the asgeojson function.
Do you know where we can find the 1.3.4 version of postgis ?
once you have your data in the "geojson format", how do you "call" it in the json file ?
Thanks for your help

Sophie

----- Mail Original -----
De: "Paragon Corporation" <lr <at> pcorp.us>
À: "PostGIS Users Discussion" <postgis-users <at> postgis.refractions.net>
Envoyé: Jeudi 31 Juillet 2008 07:16:24 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne
Objet: RE: [postgis-users] JSON

We should update the docs to have an Availability section for the Geometry
Outputs. Well at the very least for the ST_AsGeomJson.

It confused me too when I tried to use that function and realized it was in
an unreleased version.

-----Original Message-----
From: postgis-users-bounces <at> postgis.refractions.net
[mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Wednesday, July 30, 2008 7:29 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] JSON

I think it's unreleased on the 1.3 branch. I have it here on my development
box. So 1.3.4 would have it.

# select st_asgeojson(geom) from fe_edges limit 1;
st_asgeojson
----------------------------------------------------------------------------
----------------------------------------------------

{"type":"MultiLineString","coordinates":[[[-89.734634999999997,31.4920720000
00000],[-89.734955999999997,31.492237999999997]]]}
(1 row)

On Wed, Jul 30, 2008 at 4:16 PM, Jim <jbucher <at> cnrit.tamu.edu> wrote:
> I just installed 1.3.3 and I don't see an ST_AsGeoJson or an AsGeoJson
> function.
>
> Paul Ramsey wrote:
>>
>> Jim,
>>
>> We've got that contribution already,
>>
>>
>> http://postgis.refractions.net/documentation/manual-1.3/ch06.html#id2
>> 975494
>>
>> Thanks though!
>>
>> Paul
>>
>
> _______________________________________________
> postgis-users mailing list
> 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

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

Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper.

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

headers

Obe, Regina | 1 Aug 2008 13:15

RE: Merge all polygons from a dataset

Erik,

How were you using ST_Union and what exactly do you mean by no result. no result as it looks blank? If you are using something like PgAdmin III - it will look blank because it exceeds the buffer supported by PgAdmin III.

SELECT the_geom is null

FROM (somequery or table) as foo

LIMIT 1

will tell you if its actually returning no geometry

Hope that helps,

Regina

From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net] On Behalf Of danny
Sent: Friday, August 01, 2008 6:12 AM
To: postgis-users <at> postgis.refractions.net
Subject: [postgis-users] Merge all polygons from a dataset

Hello everybody,

I've converted a shapefile of Europe to PostGIS. I would like to merge all the countries together so that I only have one polygon left, the whole contour of Europe. I have tried ST_Union that gives me no result. I've tried several other functions to no avail. Does anybody know how I should proceed?

Many thanks,

Erik

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.

Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper.

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

headers

fsalas | 1 Aug 2008 14:10

error with PgRouting 1.02 on Win32

Bruce

Thanks for his instruction, right now it works well

Best regards Francisco salas

___________________________________
Dpto de Sistemas Informáticos
Oficina Central Grupo Empresarial GEOCUBA
Este mensaje esta libre de virus.
Revisado por Kaspersky Antivirus
----------------------------------------------------------------------
Engine version: 4.0.1.14 Engine date: 2002/06/25 Definition count: 917484 Definition date: 2008/07/31 MDAV version: 2.2.9

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

headers

Randall, Eric | 1 Aug 2008 14:27

RE: Merge all polygons from a dataset

As others have mentioned somewhere, you could also use:

select st_buffer(st_collect(the_geom),0) from yourpolytable

Eric

-----Original Message-----
From: postgis-users-bounces <at> postgis.refractions.net [mailto:postgis-users-bounces <at> postgis.refractions.net]On Behalf Of danny
Sent: Friday, August 01, 2008 6:12 AM
To: postgis-users <at> postgis.refractions.net
Subject: [postgis-users] Merge all polygons from a dataset

Hello everybody,

I've converted a shapefile of Europe to PostGIS. I would like to merge all the countries together so that I only have one polygon left, the whole contour of Europe. I have tried ST_Union that gives me no result. I've tried several other functions to no avail. Does anybody know how I should proceed?

Many thanks,

Erik

_______________________________________________
postgis-users mailing list
postgis-users <at> postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

148	May 2013
141	April 2013
94	March 2013
201	February 2013
280	January 2013
220	December 2012
302	November 2012
348	October 2012
247	September 2012
149	August 2012
299	July 2012
289	June 2012
468	May 2012
541	April 2012
612	March 2012
561	February 2012
244	January 2012
352	December 2011
302	November 2011
371	October 2011
249	September 2011
240	August 2011
322	July 2011
352	June 2011
222	May 2011
196	April 2011
320	March 2011
232	February 2011
290	January 2011
241	December 2010
180	November 2010
219	October 2010
223	September 2010
251	August 2010
326	July 2010
151	June 2010
323	May 2010
193	April 2010
323	March 2010
176	February 2010
325	January 2010
196	December 2009
280	November 2009
299	October 2009
310	September 2009
266	August 2009
320	July 2009
179	June 2009
282	May 2009
201	April 2009
235	March 2009
243	February 2009
322	January 2009
265	December 2008
278	November 2008
384	October 2008
338	September 2008
329	August 2008
303	July 2008
481	June 2008
499	May 2008
444	April 2008
324	March 2008
240	February 2008
369	January 2008
196	December 2007
297	November 2007
361	October 2007
285	September 2007
342	August 2007
341	July 2007
358	June 2007
346	May 2007
382	April 2007
266	March 2007
306	February 2007
259	January 2007
278	December 2006
341	November 2006
303	October 2006
326	September 2006
237	August 2006
271	July 2006
256	June 2006
323	May 2006
270	April 2006
379	March 2006
351	February 2006
505	January 2006
318	December 2005
331	November 2005
337	October 2005
355	September 2005
296	August 2005
277	July 2005
323	June 2005
378	May 2005
322	April 2005
418	March 2005
305	February 2005
280	January 2005
185	December 2004
247	November 2004
300	October 2004
247	September 2004
246	August 2004
161	July 2004
192	June 2004
224	May 2004
257	April 2004
279	March 2004
297	February 2004
149	January 2004
174	December 2003
166	November 2003
192	October 2003
152	September 2003
243	August 2003
129	July 2003
141	June 2003
130	May 2003
116	April 2003
1	November 2002
1	August 2001

Mon	Tue	Wed	Thu	Fri	Sat	Sun

				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31