Nathan,
I was involved in the same sort of decision about 9 months ago.
Often these decisions are made by one's IT department as spatial data mangement
is about fundamental integration with the business's enterprise data management.
So, if you business's data management is SQL Server on Winte
The machine has a system PostgreSQL 8.1 something but no PostGIS extensions.
The box also has Pg 8.4.0 with PostGIS 1.4.0 (GEOS 3.1.1) that I
compiled about six months ago. I thought the instance was turned off
for several reasons, but I see what you mean of a mixup in Pg
instances, I'll check tha
On Thu, Nov 26, 2009 at 7:29 AM, Nathan Widmyer wrote:
> 1. I get differences in error message formats.
> The tests expect an error message, "ERROR: parse error - invalid
> geometry" but the tests return "ERROR: parse error - invalid geometry
> at character 18"
> I think the PGIS developers add
ST_Collect worked for me.
I have a column of multipolygons. I can take the ST_Centroid of each
multipolygon and it produces a multipoint.
Don't have the SQL at hand, but it's something close to:
UPDATE table SET geom_multip=(SELECT
ST_Collect(ST_Centroid(geom_multipoly)) FROM table2 WHERE
ST_IsVa
It's Solaris 10 8/07, the box is only about a year old.
I do get two types of test failures though...
1. I get differences in error message formats.
The tests expect an error message, "ERROR: parse error - invalid
geometry" but the tests return "ERROR: parse error - invalid geometry
at characte
Hello,
I was involved in the same sort of decision about 9 months ago.
Generally what we found was that Oracle Spatial supported a basic set
of functions so they can check that features box in sales brochures
saying "yes, we do geospatial stuff", but you have to do it Oracle's
way.
OTOH, PostGIS
This is fixed in PostGIS 1.4.1 I believe -- due out shortly.
-Original Message-
From: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Ben
Madin
Sent: Thursday, November 26, 2009 5:08 AM
To: PostGIS Users Discussion
Subject:
Good points Paul and Simon,
>> uDIG, QGIS allow direct connectivity to PostGIS, hope they allow
>> direct file editing too.
>
> Yes, they do. As does gvSIG, and I think MapWindow.
For the record MapWindow does not work. Tried it and have been trying to
get them to fix their PostGIS driver, but
Hi,
you could also see this compare table at bostongis.com (the site is offline
but we have google cache :P)
http://www.google.com.br/url?sa=t&source=web&ct=res&cd=2&ved=0CA0QFjAB&url=http%3A%2F%2Fwww.bostongis.com%2FPrinterFriendly.aspx%3Fcontent_name%3Dsqlserver2008_postgis_mysql_compare&ei=w3Y
Arrgh! it was so likely to happen that Murphy would be proud,
On 26/11/2009, at 12:14 , Ben Madin wrote:
> create schema postgis;
>
> set search_path postgis, other schemas;
>
> \i postgis.sql -- or you could set the search_path in the postgis_sql file -
> there used to be some problems here
Use ST_Multi(point) to get what you want.
You can build your query using ST_DWithin(geomA, geomB, dist).
Gr Ralf
Von: postgis-users-boun...@postgis.refractions.net
[mailto:postgis-users-boun...@postgis.refractions.net] Im Auftrag von Mehmet
Sirin
Gesendet: Donnerstag, 26. November 2009 01:
11 matches
Mail list logo