[Qgis-user] qgis - virtual layers

[Jozef Riha]

hello list,

not sure if this is a known problem but during virtual layers feature
testing i discovered that this tool has issues when source used in query
contains characters such as space, forward slash, dash and possibly others
in column names. it would be nice if user would be presented with a
meaningful error message rather than a cryptic message about syntax error.

to reproduce:
- import test.geojson to qgis
- add virtual layer - run select * from test
- you'll get:

Query execution error on DROP TABLE IF EXISTS "test"; CREATE VIRTUAL TABLE
"test" USING QgsVLayer(test20160305235656402);: 1 - near "1": syntax error

br, j


test.geojson
Description: Binary data
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] fields are not updated with calculated field values in QGIS 2.14

[Alexandre Neto]

Hi Roy,

Are you sure your data is UTM 34 S? How did you convert the data to that
crs? What are the approximated coordinates values of your data
?

A sáb, 5/03/2016, 20:01, Roy Marsh  escreveu:

> Hi
> As a relative newcomer I have been working through the QGIS 2.14 training
> manual. Section 4.3.3 explains how to add calculated values using the Field
> Calculator.
> But when I do this ..(the examples are from 2.8 but the same procedure
> seems to apply to 2.14)..  the value stays as 0. It does this whatever
> parameters I try. It does this for both 'new field' and 'update field.' It
> does this even if layers are reprojected to UTM 34S (so as to show area in
> metres, not degrees).
> Is this a bug?
> Thanks
> Roy
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Alexandre Neto
-
@AlexNetoGeo
http://sigsemgrilhetas.wordpress.com
http://gisunchained.wordpress.com
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Export SHP to mySQL

[Vicent García]

Ok!

 

Thanks to everyone!

 

Vicent.

 

De: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] En nombre de Marco 
Lechner - FOSSGIS e.V.
Enviado el: dissabte, 5 de març de 2016 16:51
Para: qgis-user@lists.osgeo.org
Asunto: Re: [Qgis-user] Export SHP to mySQL

 

read this:

https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
Marco

Am 05.03.2016 um 14:55 schrieb Vicent García:

Hi,

 

I’ve tried to do that (shp2mysql), but I got this error: 

“ERROR 1: MySQL error message: The used table type doesn’t suport SPATIAL 
indexes. Description: ALTER TABLE ‘shapefile’ ADD SPATIAL 
INDEX(‘poligon_columna’)

ERROR 1: Terminating translation prmaturely after failed translation of layer 
ESP_adm4 (use -skipfailures to skip errors)”

 

Sorry, but it’s my first time that I use this command and I’m a bit lost.

 

Thanks,

 

Vicent.

 

De: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] En nombre de Marco 
Lechner - FOSSGIS e.V.
Enviado el: dissabte, 5 de març de 2016 11:16
Para: qgis-user@lists.osgeo.org  
Asunto: Re: [Qgis-user] Export SHP to mySQL

 

Hi Vincent,

its possible using ogr2ogr (and should be possible using QGIS -> Layer save as 
... as well.

# shp2mysql
ogr2ogr -f MySQL MySQL:,user=,password= 
.shp -nln  -overwrite -update -lco GEOMETRY_NAME=geom 
-lco ENGINE=MyISAM -lco CHARSET=UTF-8

# info about table
ogrinfo MySQL:,user=,password=  -so

# mysql2shp
ogr2ogr -f "ESRI Shapefile" .shp 
MySQL:,user=,password= -sql "SELECT * from "

Hope this helps

Marco

Am 05.03.2016 um 08:32 schrieb Vicent García:

Hi Community,

 

Does anyone know how to export shapefile files to mySQL? I read some things 
about the topic on the Internet but no clear solutions I’ve found.

 

Thanks,

 

Vicent.







___
Qgis-user mailing list
Qgis-user@lists.osgeo.org  
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

 

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] R in QGIS on OSX using Kyngchaos build

[Alex Mandel]

I've been meaning to play with this too. I assumed it used rpy2 but
maybe that is not the case.

Looking at
https://docs.qgis.org/testing/en/docs/training_manual/processing/r_intro.html
https://docs.qgis.org/2.8/en/docs/user_manual/processing/3rdParty.html

There's nothing about external dependencies other than having R and
configuring the path to the binary.

The pages do however list the author of that module, Matteo Ghetta

I poked into the processing source code:
https://github.com/qgis/QGIS/blob/master/python/plugins/processing/algs/r/RUtils.py

And it looks like it sends R scripts out as R CMD via python's system
call methods, so like calling R on the command-line.

Maybe moving this over to the developer list will get a more formal
response, with better troubleshooting.

Thanks,
Alex

On 03/05/2016 10:09 AM, Pieter du Plooy wrote:
> William
> 
> Thank you so very much for your hard work!
> 
> Pieter
> 
> On Sat, Mar 5, 2016 at 7:55 PM, William Kyngesburye 
> wrote:
> 
>> I don't know what Processing needs to work with R.
>>
>> I just posted QGIS 2.14.
>>
>>> On Mar 5, 2016, at 11:06 AM, Pieter du Plooy 
>> wrote:
>>>
>>> Hi William
>>>
>>> I was in fact referring to Processing plugin.
>>>
>>> I installed rgdal, but that did not make a difference.
>>>
>>> Bye the way, if I can be presumptuous, when are you planning to release
>> 2.14?
>>>
>>> Pieter
>>>
>>> On Sat, Mar 5, 2016 at 6:42 PM, William Kyngesburye <
>> wokl...@kyngchaos.com> wrote:
>>> Sorry I didn't reply to your earlier email.
>>>
>>> I think it depends on how your scripts interact with R.  I have an R
>> plugin for the GDAL framework.  I also have an R plugin for the GEOS
>> framework, but that's for an old version of R.
>>>
>>> You can run R scripts from the Processing plugin, but I don't know how
>> that links R and QGIS data unless it's through GDAL.
>>>
>>> There is also rpy2 for using R from python, supposed to be a simple
>> instal with pip, but requires Xcode tools to compile.  I have a package for
>> an old R version, but I could update it.
>>>
 On Mar 5, 2016, at 6:28 AM, Pieter du Plooy 
>> wrote:

 Hi guys

 I would like to use R scripts in  QGIS 2.12 from Kyngchaos and am
>> unable to.

 I have installed the R package from r-project, and all  dependencies.

 When I run the R scripts that I have downloaded, I get the missing
>> dependency problem.

 How do I go about rectifying it?

 Regards

 Pieter
 ___
 Qgis-user mailing list
 Qgis-user@lists.osgeo.org
 List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
 Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>>
>>> -
>>> William Kyngesburye 
>>> http://www.kyngchaos.com/
>>>
>>> "Time is an illusion - lunchtime doubly so."
>>>
>>> - Ford Prefect
>>>
>>>
>>>
>>> ___
>>> Qgis-user mailing list
>>> Qgis-user@lists.osgeo.org
>>> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>> -
>> William Kyngesburye 
>> http://www.kyngchaos.com/
>>
>> "We can die but once, and that once we must die.  To be always fearing,
>> then, would not avert it, and would make life miserable."
>>
>> - Tarzan, on death

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] fields are not updated with calculated field values in QGIS 2.14

[Roy Marsh]

Hi
As a relative newcomer I have been working through the QGIS 2.14 training
manual. Section 4.3.3 explains how to add calculated values using the Field
Calculator.
But when I do this ..(the examples are from 2.8 but the same procedure
seems to apply to 2.14)..  the value stays as 0. It does this whatever
parameters I try. It does this for both 'new field' and 'update field.' It
does this even if layers are reprojected to UTM 34S (so as to show area in
metres, not degrees).
Is this a bug?
Thanks
Roy
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] R in QGIS on OSX using Kyngchaos build

[Pieter du Plooy]

William

Thank you so very much for your hard work!

Pieter

On Sat, Mar 5, 2016 at 7:55 PM, William Kyngesburye 
wrote:

> I don't know what Processing needs to work with R.
>
> I just posted QGIS 2.14.
>
> > On Mar 5, 2016, at 11:06 AM, Pieter du Plooy 
> wrote:
> >
> > Hi William
> >
> > I was in fact referring to Processing plugin.
> >
> > I installed rgdal, but that did not make a difference.
> >
> > Bye the way, if I can be presumptuous, when are you planning to release
> 2.14?
> >
> > Pieter
> >
> > On Sat, Mar 5, 2016 at 6:42 PM, William Kyngesburye <
> wokl...@kyngchaos.com> wrote:
> > Sorry I didn't reply to your earlier email.
> >
> > I think it depends on how your scripts interact with R.  I have an R
> plugin for the GDAL framework.  I also have an R plugin for the GEOS
> framework, but that's for an old version of R.
> >
> > You can run R scripts from the Processing plugin, but I don't know how
> that links R and QGIS data unless it's through GDAL.
> >
> > There is also rpy2 for using R from python, supposed to be a simple
> instal with pip, but requires Xcode tools to compile.  I have a package for
> an old R version, but I could update it.
> >
> > > On Mar 5, 2016, at 6:28 AM, Pieter du Plooy 
> wrote:
> > >
> > > Hi guys
> > >
> > > I would like to use R scripts in  QGIS 2.12 from Kyngchaos and am
> unable to.
> > >
> > > I have installed the R package from r-project, and all  dependencies.
> > >
> > > When I run the R scripts that I have downloaded, I get the missing
> dependency problem.
> > >
> > > How do I go about rectifying it?
> > >
> > > Regards
> > >
> > > Pieter
> > > ___
> > > Qgis-user mailing list
> > > Qgis-user@lists.osgeo.org
> > > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> > -
> > William Kyngesburye 
> > http://www.kyngchaos.com/
> >
> > "Time is an illusion - lunchtime doubly so."
> >
> > - Ford Prefect
> >
> >
> >
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> -
> William Kyngesburye 
> http://www.kyngchaos.com/
>
> "We can die but once, and that once we must die.  To be always fearing,
> then, would not avert it, and would make life miserable."
>
> - Tarzan, on death
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] R in QGIS on OSX using Kyngchaos build

[William Kyngesburye]

I don't know what Processing needs to work with R.

I just posted QGIS 2.14.

> On Mar 5, 2016, at 11:06 AM, Pieter du Plooy  wrote:
> 
> Hi William
> 
> I was in fact referring to Processing plugin.
> 
> I installed rgdal, but that did not make a difference.
> 
> Bye the way, if I can be presumptuous, when are you planning to release 2.14?
> 
> Pieter 
> 
> On Sat, Mar 5, 2016 at 6:42 PM, William Kyngesburye  
> wrote:
> Sorry I didn't reply to your earlier email.
> 
> I think it depends on how your scripts interact with R.  I have an R plugin 
> for the GDAL framework.  I also have an R plugin for the GEOS framework, but 
> that's for an old version of R.
> 
> You can run R scripts from the Processing plugin, but I don't know how that 
> links R and QGIS data unless it's through GDAL.
> 
> There is also rpy2 for using R from python, supposed to be a simple instal 
> with pip, but requires Xcode tools to compile.  I have a package for an old R 
> version, but I could update it.
> 
> > On Mar 5, 2016, at 6:28 AM, Pieter du Plooy  wrote:
> >
> > Hi guys
> >
> > I would like to use R scripts in  QGIS 2.12 from Kyngchaos and am unable to.
> >
> > I have installed the R package from r-project, and all  dependencies.
> >
> > When I run the R scripts that I have downloaded, I get the missing 
> > dependency problem.
> >
> > How do I go about rectifying it?
> >
> > Regards
> >
> > Pieter
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
> 
> -
> William Kyngesburye 
> http://www.kyngchaos.com/
> 
> "Time is an illusion - lunchtime doubly so."
> 
> - Ford Prefect
> 
> 
> 
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-
William Kyngesburye 
http://www.kyngchaos.com/

"We can die but once, and that once we must die.  To be always fearing, then, 
would not avert it, and would make life miserable."

- Tarzan, on death

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] R in QGIS on OSX using Kyngchaos build

[Pieter du Plooy]

Hi William

I was in fact referring to Processing plugin.

I installed rgdal, but that did not make a difference.

Bye the way, if I can be presumptuous, when are you planning to release
2.14?

Pieter

On Sat, Mar 5, 2016 at 6:42 PM, William Kyngesburye 
wrote:

> Sorry I didn't reply to your earlier email.
>
> I think it depends on how your scripts interact with R.  I have an R
> plugin for the GDAL framework.  I also have an R plugin for the GEOS
> framework, but that's for an old version of R.
>
> You can run R scripts from the Processing plugin, but I don't know how
> that links R and QGIS data unless it's through GDAL.
>
> There is also rpy2 for using R from python, supposed to be a simple instal
> with pip, but requires Xcode tools to compile.  I have a package for an old
> R version, but I could update it.
>
> > On Mar 5, 2016, at 6:28 AM, Pieter du Plooy 
> wrote:
> >
> > Hi guys
> >
> > I would like to use R scripts in  QGIS 2.12 from Kyngchaos and am unable
> to.
> >
> > I have installed the R package from r-project, and all  dependencies.
> >
> > When I run the R scripts that I have downloaded, I get the missing
> dependency problem.
> >
> > How do I go about rectifying it?
> >
> > Regards
> >
> > Pieter
> > ___
> > Qgis-user mailing list
> > Qgis-user@lists.osgeo.org
> > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> -
> William Kyngesburye 
> http://www.kyngchaos.com/
>
> "Time is an illusion - lunchtime doubly so."
>
> - Ford Prefect
>
>
>
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] R in QGIS on OSX using Kyngchaos build

[William Kyngesburye]

Sorry I didn't reply to your earlier email.

I think it depends on how your scripts interact with R.  I have an R plugin for 
the GDAL framework.  I also have an R plugin for the GEOS framework, but that's 
for an old version of R.

You can run R scripts from the Processing plugin, but I don't know how that 
links R and QGIS data unless it's through GDAL.

There is also rpy2 for using R from python, supposed to be a simple instal with 
pip, but requires Xcode tools to compile.  I have a package for an old R 
version, but I could update it.

> On Mar 5, 2016, at 6:28 AM, Pieter du Plooy  wrote:
> 
> Hi guys
> 
> I would like to use R scripts in  QGIS 2.12 from Kyngchaos and am unable to.
> 
> I have installed the R package from r-project, and all  dependencies.
> 
> When I run the R scripts that I have downloaded, I get the missing dependency 
> problem.
> 
> How do I go about rectifying it?
> 
> Regards
> 
> Pieter
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-
William Kyngesburye 
http://www.kyngchaos.com/

"Time is an illusion - lunchtime doubly so."

- Ford Prefect


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.14 LTR ?

[Christophe Damour]

Thank you for clarifying.

--
Christophe

Le 05/03/2016 à 15:29, Richard Duivenvoorde a écrit :

On 05-03-16 15:07, Christophe Damour wrote:

Hi,

I am wondering which QGIS version is current LTR.

Changelog says that 2.14 is LTR :
http://qgis.org/en/site/forusers/visualchangelog214/

But QGIS home page says current LTR is 2.8.7 :
https://www.qgis.org/en/site/

Do I miss something ?

2.14 will be the next LTR, but it will be 'named' LTR and be available
in the LTR repository when we release 2.16

See:
https://lists.osgeo.org/pipermail/qgis-community-team/2016-March/004554.html

So depending on your goals you could start with 2.14 knowing it is still
2.14.zero(!) maybe hitting a .0 bug, but then you know what to work with
when it will be the true LTR within a 3 of months.

But if you want current rock solid LTR: grab 2.8 for the upcoming months.

Regards,

Richard Duivenvoorde

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Export SHP to mySQL

[Marco Lechner - FOSSGIS e.V.]

read this:

https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html
Marco

Am 05.03.2016 um 14:55 schrieb Vicent García:
>
> Hi,
>
>  
>
> I’ve tried to do that (shp2mysql), but I got this error:
>
> “ERROR 1: MySQL error message: The used table type doesn’t suport
> SPATIAL indexes. Description: ALTER TABLE ‘shapefile’ ADD SPATIAL
> INDEX(‘poligon_columna’)
>
> ERROR 1: Terminating translation prmaturely after failed translation
> of layer ESP_adm4 (use -skipfailures to skip errors)”
>
>  
>
> Sorry, but it’s my first time that I use this command and I’m a bit lost.
>
>  
>
> Thanks,
>
>  
>
> Vicent.
>
>  
>
> *De:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *En nombre
> de *Marco Lechner - FOSSGIS e.V.
> *Enviado el:* dissabte, 5 de març de 2016 11:16
> *Para:* qgis-user@lists.osgeo.org
> *Asunto:* Re: [Qgis-user] Export SHP to mySQL
>
>  
>
> Hi Vincent,
>
> its possible using ogr2ogr (and should be possible using QGIS -> Layer
> save as ... as well.
>
> # shp2mysql
> ogr2ogr -f MySQL MySQL:,user=,password=
> .shp -nln  -overwrite -update -lco
> GEOMETRY_NAME=geom -lco ENGINE=MyISAM -lco CHARSET=UTF-8
>
> # info about table
> ogrinfo MySQL:,user=,password=  -so
>
> # mysql2shp
> ogr2ogr -f "ESRI Shapefile" .shp
> MySQL:,user=,password= -sql "SELECT * from
> "
>
> Hope this helps
>
> Marco
>
> Am 05.03.2016 um 08:32 schrieb Vicent García:
>
> Hi Community,
>
>  
>
> Does anyone know how to export shapefile files to mySQL? I read
> some things about the topic on the Internet but no clear solutions
> I’ve found.
>
>  
>
> Thanks,
>
>  
>
> Vicent.
>
>
>
>
> ___
>
> Qgis-user mailing list
>
> Qgis-user@lists.osgeo.org 
>
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>  
>



0x6A30F373.asc
Description: application/pgp-keys
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] QGIS 2.14 LTR ?

[Richard Duivenvoorde]

On 05-03-16 15:07, Christophe Damour wrote:
> Hi,
> 
> I am wondering which QGIS version is current LTR.
> 
> Changelog says that 2.14 is LTR :
> http://qgis.org/en/site/forusers/visualchangelog214/
> 
> But QGIS home page says current LTR is 2.8.7 :
> https://www.qgis.org/en/site/
> 
> Do I miss something ?

2.14 will be the next LTR, but it will be 'named' LTR and be available
in the LTR repository when we release 2.16

See:
https://lists.osgeo.org/pipermail/qgis-community-team/2016-March/004554.html

So depending on your goals you could start with 2.14 knowing it is still
2.14.zero(!) maybe hitting a .0 bug, but then you know what to work with
when it will be the true LTR within a 3 of months.

But if you want current rock solid LTR: grab 2.8 for the upcoming months.

Regards,

Richard Duivenvoorde

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Export SHP to mySQL

[Matthias Kuhn]

Hi Vincent,

While it should be possible to use MySQL, PostgreSQL with postgis is
much more common and there is much more help available for it in the
QGIS world. So if you are not required to use MySQL for other reasons, I
would recommend to evaluate other database systems first.

If you need to use MySQL, that's what google brought up concerning this
topic:

http://stackoverflow.com/questions/18379808/the-used-table-type-doesnt-support-spatial-indexes

Deducing from this, it sounds like you are not using the ISAM engine.

Kind regards,
Matthias


On 03/05/2016 02:55 PM, Vicent García wrote:
>
> Hi,
>
>  
>
> I’ve tried to do that (shp2mysql), but I got this error:
>
> “ERROR 1: MySQL error message: The used table type doesn’t suport
> SPATIAL indexes. Description: ALTER TABLE ‘shapefile’ ADD SPATIAL
> INDEX(‘poligon_columna’)
>
> ERROR 1: Terminating translation prmaturely after failed translation
> of layer ESP_adm4 (use -skipfailures to skip errors)”
>
>  
>
> Sorry, but it’s my first time that I use this command and I’m a bit lost.
>
>  
>
> Thanks,
>
>  
>
> Vicent.
>
>  
>
> *De:*Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] *En nombre
> de *Marco Lechner - FOSSGIS e.V.
> *Enviado el:* dissabte, 5 de març de 2016 11:16
> *Para:* qgis-user@lists.osgeo.org
> *Asunto:* Re: [Qgis-user] Export SHP to mySQL
>
>  
>
> Hi Vincent,
>
> its possible using ogr2ogr (and should be possible using QGIS -> Layer
> save as ... as well.
>
> # shp2mysql
> ogr2ogr -f MySQL MySQL:,user=,password=
> .shp -nln  -overwrite -update -lco
> GEOMETRY_NAME=geom -lco ENGINE=MyISAM -lco CHARSET=UTF-8
>
> # info about table
> ogrinfo MySQL:,user=,password=  -so
>
> # mysql2shp
> ogr2ogr -f "ESRI Shapefile" .shp
> MySQL:,user=,password= -sql "SELECT * from
> "
>
> Hope this helps
>
> Marco
>
> Am 05.03.2016 um 08:32 schrieb Vicent García:
>
> Hi Community,
>
>  
>
> Does anyone know how to export shapefile files to mySQL? I read
> some things about the topic on the Internet but no clear solutions
> I’ve found.
>
>  
>
> Thanks,
>
>  
>
> Vicent.
>
>
>
>
> ___
>
> Qgis-user mailing list
>
> Qgis-user@lists.osgeo.org 
>
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>  
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Matthias Kuhn
OPENGIS.ch - https://www.opengis.ch
Spatial • (Q)GIS • PostGIS • Open Source

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] QGIS 2.14 LTR ?

[Christophe Damour]

Hi,

I am wondering which QGIS version is current LTR.

Changelog says that 2.14 is LTR :
http://qgis.org/en/site/forusers/visualchangelog214/

But QGIS home page says current LTR is 2.8.7 :
https://www.qgis.org/en/site/

Do I miss something ?

--
Christophe




___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Export SHP to mySQL

[Vicent García]

Hi,

 

I’ve tried to do that (shp2mysql), but I got this error: 

“ERROR 1: MySQL error message: The used table type doesn’t suport SPATIAL 
indexes. Description: ALTER TABLE ‘shapefile’ ADD SPATIAL 
INDEX(‘poligon_columna’)

ERROR 1: Terminating translation prmaturely after failed translation of layer 
ESP_adm4 (use -skipfailures to skip errors)”

 

Sorry, but it’s my first time that I use this command and I’m a bit lost.

 

Thanks,

 

Vicent.

 

De: Qgis-user [mailto:qgis-user-boun...@lists.osgeo.org] En nombre de Marco 
Lechner - FOSSGIS e.V.
Enviado el: dissabte, 5 de març de 2016 11:16
Para: qgis-user@lists.osgeo.org
Asunto: Re: [Qgis-user] Export SHP to mySQL

 

Hi Vincent,

its possible using ogr2ogr (and should be possible using QGIS -> Layer save as 
... as well.

# shp2mysql
ogr2ogr -f MySQL MySQL:,user=,password= 
.shp -nln  -overwrite -update -lco GEOMETRY_NAME=geom 
-lco ENGINE=MyISAM -lco CHARSET=UTF-8

# info about table
ogrinfo MySQL:,user=,password=  -so

# mysql2shp
ogr2ogr -f "ESRI Shapefile" .shp 
MySQL:,user=,password= -sql "SELECT * from "

Hope this helps

Marco

Am 05.03.2016 um 08:32 schrieb Vicent García:

Hi Community,

 

Does anyone know how to export shapefile files to mySQL? I read some things 
about the topic on the Internet but no clear solutions I’ve found.

 

Thanks,

 

Vicent.






___
Qgis-user mailing list
Qgis-user@lists.osgeo.org  
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

 

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] R in QGIS on OSX using Kyngchaos build

[Pieter du Plooy]

Hi guys

I would like to use R scripts in  QGIS 2.12 from Kyngchaos and am unable to.

I have installed the R package from r-project, and all  dependencies.

When I run the R scripts that I have downloaded, I get the missing
dependency problem.

How do I go about rectifying it?

Regards

Pieter
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] Export SHP to mySQL

[Marco Lechner - FOSSGIS e.V.]

Hi Vincent,

its possible using ogr2ogr (and should be possible using QGIS -> Layer
save as ... as well.

# shp2mysql
ogr2ogr -f MySQL MySQL:,user=,password=
.shp -nln  -overwrite -update -lco
GEOMETRY_NAME=geom -lco ENGINE=MyISAM -lco CHARSET=UTF-8

# info about table
ogrinfo MySQL:,user=,password=  -so

# mysql2shp
ogr2ogr -f "ESRI Shapefile" .shp
MySQL:,user=,password= -sql "SELECT * from
"

Hope this helps

Marco

Am 05.03.2016 um 08:32 schrieb Vicent García:
>
> Hi Community,
>
>  
>
> Does anyone know how to export shapefile files to mySQL? I read some
> things about the topic on the Internet but no clear solutions I’ve found.
>
>  
>
> Thanks,
>
>  
>
> Vicent.
>
>
>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user




0x6A30F373.asc
Description: application/pgp-keys
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] Standard symbols

[Carmine Massarelli]

Dear,
do you know if there is a European standard for the use of symbols for 
the biocenotic maps of seabeds?

Thanks

Carmine


___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user