[postgis-users] Re: PostGIS/ArcWhatever Functionality Matrix, HowTo type, etc.

[Chris Puttick]

That would be an excellent resource. No ideas to contribute personally (not really my area), but there are others in the team who can contribute. The more we can learn about how to implement functionality in PostGIS, the easier it is to explore desktop GIS options.

Regards

Chris

Message: 19
Date: Mon, 21 Aug 2006 13:33:44 -0400
From: Eric Randall <eprand at earthlink.net>
Subject: Re: [postgis-users] PostGIS/ArcWhatever Functionality Matrix,
	HowTo	type, etc.
To: P Kishor <punkish at eidesis.org>,
	postgis-users at postgis.refractions.net
Message-ID: <44E9EE78.30109 at earthlink.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

P Kishor wrote:
> On 8/19/06, Eric Randall <eprand at earthlink.net> wrote:
>> Has anyone put together anything like this?  Remember the ArcGIS Desktop
>> functionality matrix, which I think originally was an excel type file
>> but now is a pdf.
>
> Well, shouldn't it really be a PostGIS/Postgres vs. ArcSDE/<rdbms of
> choice> functionality comparison?
>
Maybe, but after thinking about it, it should be more of a 
PostGIS/ArcGIS-ArcTools functional equivalence howto with examples.
While PostGIS functionality is in the database, the bulk of ArcGIS 
functionality resides with the client software rather than the database.
So I would want to compare how equivalent tasks are accomplished in each.
 
> Granted, there is much you can do with PostGIS that you can also do
> with ArcGIS, but ArcGIS (also a collective and confusing name for many
> products) ArcMap for example is geared for desktop. And I have to
> admit, albeit somewhat grudgingly, that some things in ArcGIS are
> pretty nicely done -- a very nice and detailed help system, a mostly
> intuitive interface, and a really amazing Modelbuilder, likes of which
> _I_ haven't seen in any other software.
>
Yes, that modelbuilder is pretty slick, especially as a scriptbuilder.  
My favorite PostGIS Modelbuilder
is SciTE  :-)
> That said,
>
>> I think it would be cool to have available a PostGIS/ArcInfo
>> Functionality Matrix type thing that not only outlines funtionality but
>> also tells how to do it.  I've used PostGIS to perform many of the
>> functions only available with ArcInfo licensing, and also do things that
>> are more difficult to do with ArcInfo.  Anyone else think this would be
>> useful?  I'll be happy to put it together but there are probably lots of
>> folks doing things that I'm not that could contribute.  What do you 
>> think?
>
> Yes, such a matrix would be really very nice. If you start work on it
> on a wiki site (maybe the PostGIS wiki, if there is one), then others
> can contribute to it as well.
>
> Many thanks,
>
Thanks for your ideas.  I'll see if I can get something going.
Other thoughts, please...anyone?
>
>



------------------------------

Message: 20
Date: Mon, 21 Aug 2006 15:43:21 -0300
From: "Bruno Patini Furtado" <bpfurtado at gmail.com>
Subject: [postgis-users] AddGeometryColumn problem
To: postgis-users at postgis.refractions.net
Message-ID:
	<fc04215e0608211143p7379ef95vf978b57fab9d0841 at mail.gmail.com>
Content-Type: text/plain; charset="utf-8"

Hi,
I've just installed PostgreSQL 8.1.4 without the GIS extensions and after
that installed the postgis-pg81-setup-1.1.3-1.exe from
http://postgis.refractions.net/download/windows/. ]

Everything went fine but when I try to run the SQL statements generated by
the shp2pgsql program, the error message "ERROR:  current transaction is
aborted, commands ignored until end of transaction block" is reported.

I've tried to run only the create table statement, but the same error
message was reported.
So I've changed:
CREATE TABLE "gis_test"."brazil_tiled2" (gid serial PRIMARY KEY,
"location" varchar(255));
To:
CREATE TABLE gis_test.brazil_tiled
(
  "location" varchar,
  gid serial NOT NULL,
  CONSTRAINT brazil_tiled_pk PRIMARY KEY (gid)
)
WITHOUT OIDS;
ALTER TABLE gis_test.brazil_tiled OWNER TO postgres;

But even so the same error message is reported when I only submit the
following SQL statement:

SELECT
AddGeometryColumn('gis_test','brazil_tiled2','the_geom','-1','MULTIPOLYGON',2);

I must be doing something very wrong.

Any Hints/suggestions would be most appreciated!

-- 
"Minds are like parachutes, they work best when open."

Bruno Patini Furtado
Software Developer
webpage: http://bpfurtado.net
software development blog: http://bpfurtado.livejournal.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.refractions.net/pipermail/postgis-users/attachments/20060821/e46c41d3/attachment-0001.html

------------------------------

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


End of postgis-users Digest, Vol 46, Issue 19
*********************************************









This message has been scanned for viruses by BlackSpider MailControl - www.blackspider.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: winmail.dat
Type: application/ms-tnef
Size: 5635 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20060822/e63429e5/attachment.bin>