-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
hello daniela,
i have made a few changes to stock mezogis-0.1.5 to support current
psycopg2. now i have no problem with your data on my debian machine.
the working mezogis has been sent to you privately, and the patch has
been sent to frederic back
Hi Craig. I try the next query and it works great for me:
select ConvexHull(Collect(the_geom)) from tablename;
(Actually I had to make Multi(ConvexHull(Collect(the_geom))) cause the
ConvexHull returns a 'POLYGON' and my geometry column was defined as
'MULTIPOLYGON' through constraint, so maybe y
Michael,
I did try that however the resultant table does not contain a polygon.
I added a small rectangle to the layer using uDig (through geoserver) and
attempted the query again. A polygon was generated.
I checked the layer using isclosed(geom) and it returned false. How do I
determine where t
Hi Stephen
That's a good point. The way I've got things setup right now is that the
files are first uploaded to a temp location and are then parsed into
postgresql/postgis. I need to look into what you're suggesting and it's
obviously a more efficient way of achieving the same result. Thanks,
Che
--- Steve Lefevre <[EMAIL PROTECTED]> wrote:
> On 7/4/07, Brent Wood <[EMAIL PROTECTED]> wrote:
> >
> >
> > Hi Steve,
> >
> > Hope this helps...
> >
> > If I understand you correctly, this may be easier outside of PostGIS
> > geometries, try:
> >
> > select geometryfromtext(('POINT( avg(longitude
Hi Jessica,
I need to load a postgis enabled postgres database from on machine to
another, I got a long list of errors. Some of them are pointing to the
You may also want to look at the postgis_restore.pl script:
http://postgis.refractions.net/docs/ch02.html#upgrading
Regards,
Steffen
_
On 7/4/07, Brent Wood <[EMAIL PROTECTED]> wrote:
Hi Steve,
Hope this helps...
If I understand you correctly, this may be easier outside of PostGIS
geometries, try:
select geometryfromtext(('POINT( avg(longitude) avge(latitude) ',4326)
group by
Always assuming the avg() is a appropriate
--- Steve Lefevre <[EMAIL PROTECTED]> wrote:
> Hello all -
>
> I'm working on a database with GIS data. In my table, I have columns for
> latitude, longitude, and coordinates, which is the Postgis geometry data
> type. What I would like to do is find the midpoint or 'average' for any
> group of
On 7/4/07, Webb Sprague <[EMAIL PROTECTED]> wrote:
You might want to look into the "centroid" function. I am not sure if
that is the best, but it is useful in general.
Sorry ! I forgot to mention the centroid function in my post.
But my main question is, what is the syntax for the centriod
Hello all -
I'm working on a database with GIS data. In my table, I have columns for
latitude, longitude, and coordinates, which is the Postgis geometry data
type. What I would like to do is find the midpoint or 'average' for any
group of points.
I have the latitude and longitude, and then I us
Can you post the actual WKT for the result linestrings? I don't have a
PostGIS instance handy to run the SQL.
I'm betting that it is a precision issue. One way to handle this would
be to use a buffer around one of the geometries you want to compare, to
"fuzz" the comparison.
Jonathan Aguer
* Chetan Tiwari ([EMAIL PROTECTED]) wrote:
> I have a little perl script that reads CSV files uploaded via a browser and
> inserts the data into a table in postgres. I'll be happy to share that with
> you. It's setup to run with active perl and apache on windows, but it would
> be fairly easy to tw
Hi Pere
I have a little perl script that reads CSV files uploaded via a browser and
inserts the data into a table in postgres. I'll be happy to share that with
you. It's setup to run with active perl and apache on windows, but it would
be fairly easy to tweak it to your system setup.
- Chetan
On
Please only mail once to the list !
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
Do NOT use buffer() to do radius queries... you're building a whole
bunch of new geometry and then throwing it away. Use Distance(), or
even better, st_dwithin() on a newer install.
Select *
from california
where
st_dwithin(
transform(the_geom,2163),
transform(GeomFromText(
Hi,
I have US address which have been geocoded to get latitude and
longitude.
I am following the below steps
1. Add column
SELECT AddGeometryColumn( 'public', 'california', 'the_geom', 4326,
'POINT', 2 );
2. Populate geometry
UPDATE california
SET the_geom = PointF
Hi,
I have US address which have been geocoded to get latitude and
longitude.
I am following the below steps
1. Add column
SELECT AddGeometryColumn( 'public', 'california', 'the_geom', 4326,
'POINT', 2 );
2. Populate geometry
UPDATE california
SET the_geom = PointF
On Wed, Jul 04, 2007 at 12:53:27AM -0700, pere roca wrote:
> I just was wondering if there is some tool to insert automatically data
> from a .asc or .csv or text file (just X,Y and thematic data) to PostGIS
> (something similar to shp2pgsql.exe).
Are you familiar with COPY (or psql's \copy)?
h
Hi,
You can try out Pentaho Kettle software.
Santosh Gaikwad
Senior Software Developer
Saama Technologies (India) Pvt Ltd.
6th Floor West Wing, Marisoft III,
Marigold Premises, Kalayani Nagar,
Pune - 411014. India
Phone : +91 20 66071319 Extn: 397
Mobile: +91-9422005927
E-mail :[EMAIL PROTECTED]
Hi everybody,
I just was wondering if there is some tool to insert automatically data
from a .asc or .csv or text file (just X,Y and thematic data) to PostGIS
(something similar to shp2pgsql.exe).
What I want to do is that after a user inserts a file in our server,
automatically this file i
On Wed, Jul 04, 2007 at 11:31:37AM +1000, Craig Feuerherdt wrote:
> I have a table that has 275 individual multilinestrings. The geometries have
> come from a variety of tables and represent a bounding area.
> I wish to create a single polygon from them.
Have you tried something like this?
select
21 matches
Mail list logo