[postgis-users] QGIS - PostGIS - ArcGIS Interaction

Thu Jun 16 05:18:33 PDT 2011

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 <a.neumann at carto.net> 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 <david.fawcett at gmail.com> 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
>>> <james.david.smith at gmail.com> 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 <david.fawcett at gmail.com> 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
>>>>> <james.david.smith at gmail.com> 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
>>>>>> postgis-users at postgis.refractions.net
>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at postgis.refractions.net
>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>
>>>> _______________________________________________
>>>> postgis-users mailing list
>>>> postgis-users at postgis.refractions.net
>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
> --
> --
> Andreas Neumann
> Böschacherstrasse 10A
> 8624 Grüt (Gossau ZH)
> Switzerland
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>