Hi James,
Thanks for the explanation. ArcGIS is still more powerful than QGIS,
but for many tasks QGIS is already good enough and it is rapidly
improving. For basic data editing and map publishing, the current QGIS
version is already quite good. Analysis tools are also improving
constantly. Of course 3D is still a weakness of QGIS ... The discussion
is a bit offtopic for the Postgis mailinglist anyway ...
If you decide at one point to give QGIS a try, feel free to ask for
support at the QGIS users mailinglist. QGIS and Postgis is a very good
team usually.
Andreas
On Thu, 16 Jun 2011 13:18:33 +0100, James David Smith wrote:
Hi Andreas,
I'm sure that QGIS could do exactly what ArcGIS can do, it's just
that
I do not have time at the moment to learn how. I am familiar with
ArcGIS at the moment, so while I appreciate that is a poor excuse,
I'm
going to keep using ArcGIS for the time being. Maybe later this year
I
will learn more QGIS.
Best wishes
James
On 16 June 2011 12:34, Andreas Neumann <[email protected]> wrote:
Hi James,
Glad you found a good solution for your problem.
Of course we'd like to know what keeps you from using QGIS instead
of
ArcGIS? Where would QGIS have to improve that you would consider
using it?
Thanks,
Andreas
On Thu, 16 Jun 2011 12:23:13 +0100, James David Smith wrote:
Dear all,
Thank you so much for your help.
shp2pgsql - I didn't realise it automaticaly renamed columns.
Awesome.
I'll use that.
ArcGIS 10 - I'm on 9 unfortunately. No access to 10 at the moment.
RT SQL - I glanced at that the other day and they seem to have
stopped supporting ArcGIS 9, and also you had to pay for anything
more
than 100 rows of data I think? I may have read that incorrectly,
but
the shp2pgsql solution seems good so I'll just go with that anyway.
Cheers all, this list is awesome!
James :-)
On 15 June 2011 21:44, David Fawcett <[email protected]>
wrote:
James,
There a couple of SQL plugins for QGIS. They allow you to
visualize
spatial features via 'ad hoc' queries (not whole tables).
I am pretty sure that I used the RT_SQL plugin. Here is a link to
some info:
http://underdark.wordpress.com/2010/10/16/visualizing-postgis-queries-in-qgis-using-rt-sql-layer-plugin/
No need to buy a $10,000 proprietary desktop GIS...
David.
On Wed, Jun 15, 2011 at 1:33 PM, James David Smith
<[email protected]> wrote:
Dear Cristian & David,
Thanks alot for your responses.
Cristian - I don't have money to buy additional software
unfortunately. With regard to 'view' I actually don't know what
this
is. I'm a bit of a beginner. I wonder if I made a 'view' whether
I
could then query that view with QGIS. Something for me to look
into...
David - That looks like a good idea... but when adding data to
QGIS
you can only select the whole table (I think) and then you
manually
enter the 'WHERE' clause in a dialog box. I guess I could run the
query you suggest in PostgreSQL and save it into another table...
and
then link QGIS to the new table. Though it all starts to get a
bit
convoluted if I have to do that every time I want to look at some
data
in QGIS...
Cheers
James
On 15 June 2011 19:16, David Fawcett <[email protected]>
wrote:
This is what is really cool about using a database to store your
data...
Change your query to:
SELECT mycol1,
mycol2,
date_time_of_arrival as dt_arrive,
date_time_of_departure as dt_depart,
the_geom
FROM incidents
WHERE urgency = 'Immediate'
AND date_time_of_arrival - date_time_unit_assigned > '00:12:00'
Note: you will need to specify the names of the columns that you
are
interested in.
On Wed, Jun 15, 2011 at 12:58 PM, James David Smith
<[email protected]> wrote:
Dear all,
I appreciate that this is more of a QGIS query, but I think
that the
route of the problem might be in PostGIS, so... I have opened
QGIS and
ran the query on my PostGIS table as below:
SELECT * FROM incidents
WHERE urgency = 'Immediate'
AND date_time_of_arrival - date_time_unit_assigned > '00:12:00'
This gives me 33 points in QGIS. Great. I would now however
like to
save this as a ShapeFile for use in ArcGIS with which I am more
familiar, but when I try to SAVE AS from QGIS I am given the
following
error....
Export to vector file failed.
Error: trimming attribute name 'date_time_of_arrival' to ten
significant characters produces duplicate column name.
I am guessing that the problem here is that ESRI shapefiles can
only
deal with column names that are ten characters long...? And
that as I
also have a column called 'date_time_of_departure', when QGIS
trims
this column it ends up with two columns called the same thing?
Is
there a way around this? I realise I could rename the column in
QGIS,
but I actually have around 45 columns in the table and this
problem
will occur with about 15 pairs of them I think. I guess there
is no
simple answer... but thought I'd ask.
Cheers
James
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
