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
Dylan,
On Dec 17, 2008, at 2:19 PM, Dylan Beaudette wrote:
On Wed, Dec 17, 2008 at 11:37 AM, Richard Greenwood
richard.greenw...@gmail.com wrote:
On Wed, Dec 17, 2008 at 10:54 AM, Frank Warmerdam warmer...@pobox.com
wrote:
However, I am troubled that the Ubuntu proj distribution does not
Stephen,
Try:
select astext(st_linemerge(ST_Collect(b.the_geom)))
from (
select ST_GeomFromText('LINESTRING(35.5269251710001
33.891749555,35.527091166 33.8917984710001)') as the_geom
union
select ST_GeomFromText('LINESTRING(35.527091166
33.8917984710001,35.527435201
back and try to get the latest.
Dane
Thanks,
Regina
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of Dane Springmeyer
Sent: Monday, October 06, 2008 1:46 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cascaded Union Aggregate function
Regina,
On Oct 5, 2008
On Oct 6, 2008, at 4:02 AM, Obe, Regina wrote:
Dane,
I just ran the full union set in OpenJump and it took 55 seconds.
Yes, 42 seconds for the full union. wow.
Running your below for me with the OpenJump that contains the
Cascade Union functionality takes 30 seconds.
Yes, 32 seconds
Hi John,
Regarding snapping points to lines, postgis does not have a built-in
function to do that, but this nice post gives you a good guide on how
to accomplish it: http://blog.cleverelephant.ca/2008/04/snapping-points-in-postgis.html
Regarding how to do a 'Dissolve' in postgis, I assume
it again.
It could be the detoasting affect of st_geom_accum that Mark had
described
was the difference between the two.
Thanks,
Regina
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Dane
Springmeyer
Sent: Sunday, October 05, 2008 1:47 AM
To: PostGIS
] On Behalf Of
Dane
Springmeyer
Sent: Sunday, October 05, 2008 1:47 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cascaded Union Aggregate function
Hi Regina,
Thank you so much for the wiki posting. I've been using your code
from your
august 12th email with great success
] [mailto:[EMAIL PROTECTED]
] On Behalf Of Dane Springmeyer
Sent: Sunday, October 05, 2008 12:59 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cascaded Union Aggregate function
Regina,
Great, my query now works with your amended upgis function posting.
So, here are my timing outputs
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of Dane Springmeyer
Sent: Sunday, October 05, 2008 12:59 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cascaded Union Aggregate function
Regina,
Great, my query now works with your amended upgis function posting.
So, here
Hi Regina,
Thank you so much for the wiki posting. I've been using your code from
your august 12th email with great success, if not joy. What an amazing
speed improvement, especially for such a critical function. This was
your exact email of code I have working:
Hi Dylan,
Comments/questions inline...
On Sep 5, 2008, at 12:11 PM, Dylan Lorimer wrote:
Thanks everyone for the awesome suggestions! Given that I need this
to be command line driven, Mapnik looks to be the best option.
Well, do you need it to be command line in the sense that you need to
Hi David,
I grabbed a copy previously and here it is:
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
--
-- $Id: cleanGeometry.sql 2008-04-24 10:30Z Dr. Horst Duester $
--
-- cleanGeometry - remove self- and ring-selfintersections from
-- input
Dylan,
+1 on Webb's suggestion, as Mapnik is a great tool for rendering PNG's
from postgis data.
Like Regina said, if you are looking for a Graphical tool, OpenJump,
QGIS, and uDig are great solutions.
But if you are looking for a commandline or scriptable solution and
you are into
Regina,
I think the 'Dissolve' tool in the ArcGIS ArcToolbox
ArcFolderstructure mights be a more Arcceptible equivalent to ST_UNION
with a GROUP BY on some field to aggregate upon.
Cheers,
Dane
On Aug 18, 2008, at 5:15 AM, Obe, Regina wrote:
Mike,
I could very well be an idiot or at
x(the_geom), y(the_geom)
If I use asewkb(the_geom)
\001\001\000\000 -a\000\000\240}3a\031\027A;\347\243\012AxbA
And with asewkt(the_geom)
SRID=24877;POINT(723852.689845968 9683464.33250772)
2008/8/15 Dane Springmeyer [EMAIL PROTECTED]
Hi David,
I'm not sure about that error
Hi David,
Try this:
SELECT
'lat: ' || ST_Y(a.geometry) as Latitude,
'long: ' || ST_X(a.geometry) as Longitude
FROM (
SELECT ST_Transform(geometry,4326) AS geometry
FROM YOUR_TABLE
);
Dane
On Aug 11, 2008, at 2:24 PM, David Calle wrote:
Hi List,
I need to convert geometry
No, this feature is under discussion but not yet implemented within
PostGIS.
Dane
On Jul 17, 2008, at 3:25 AM, eehab hamzeh wrote:
Hello,
Is POSTGIS, ASKML command support extrude, tesselate, altitudemode
now.
thank you
ihab hijazi
Invite your mail contacts to join your friends
,.95,1.0]:
print '%s%s completed' % (oid/query_records*100, '%')
else:
print 'error
-'
print 'Complete'
connection.commit()
On Jul 10, 2008, at 11:38 AM, Dane Springmeyer wrote:
Regina and Brent
Regina and Brent:
Wow. Thanks so much for the pointers.
I've now got a single query that is working excellently so far.
Without indexes it runs on the entire dataset in about 5 minutes when
splitting lines to ~ 150 m, which is just fine.
I was able to use the ST_Reverse function to make
Stanley,
A few weeks ago I placed an issue on the bug tracker that addresses
your 'Issue 2' and I'd love to have feedback since I would be willing
to tackle getting docbook (postgis.xml) meta into db comments however
it makes most sense to do so.
I've written a python script that parses
Kevin and Regina,
Thanks for the feedback. It sounds like there is a lot of room for
improvement and expansion of the core docbook xml before we worry
about exactly how to parse it.
While I am not at all familiar with Docbook logic I have looked
closely at the postgis.xml and will begin
).
This may as well include styling.
I'm not suggesting this is not a good idea, but IMHO, it's
not essential.
GL
-- Original Message --
From: Dane Springmeyer [EMAIL PROTECTED]
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Date: Tue, 19 Feb 2008 09:45:14 -0800
Subject: [postgis
).
This may as well include styling.
I'm not suggesting this is not a good idea, but IMHO, it's
not essential.
GL
-- Original Message --
From: Dane Springmeyer [EMAIL PROTECTED]
To: PostGIS Users Discussion postgis-users@postgis.refractions.net
Date: Tue, 19 Feb 2008 09:45:14 -0800
Subject
Doug, I would also recommend uDig as a good route.
Styling, using SLD in uDig great (LayersChange StyleTheme), however
currently I'm only aware that Equal Interval and Quantile themes are
exposed in the application. A natural breaks algorithm would need to
be added, and how to go about
Gustavo,
I'm not exactly clear on how you want to use ST_Dump, but I'll give a
shot a some example SQL that might help...
I want to convert linestrings from multilinestrings, with
linemerge, to obtain united linestrings in overlapping points
with this sentence:
In your subject you say
Gustavo,
It sounds like the dump command may work for you.
However it seems to me that you still may be trying to tackle a
slightly different issue:
how to convert your multilinestrings into single linestrings (each on
a row) and merge them in such a way to be collected along with all
John,
If you have a lot of attribute data that all depends upon the same
spatial columns it should not be a problem to establish all the
relationships that would be needed to link many tables to one spatial
geometry within one database.
I'm not familiar with dblink: can you explain what
Neil,
I don't know of anything standard, but lambert and albers are what
come to mind.
There are the esri-crafted albers projections for asia that do not
have epsg listings but might be useful references.
See the esri Albers options here:
John,
From your description it seems that the hotspot points represent
individual fires rather than locations around the periphery of
hotspots. Just in case the latter is true it seems like a potential
route would be to dissolve/union all points that relate to a single
fire, then
Hi Marc,
Exactly. You are perceptive- immediately after I got things working I
realized that the way the Php FOR LOOP worked it would make it
impossible to write out KML for records returned by a dynamically
changing query.
As such I worked with the example here (http://code.google.com/
31 matches
Mail list logo
