Export from QGIS to existing SpatiaLite .sqlite database
Paulo Eduardo Cardoso
jefe rodolfo pereira da silva
Um abraço,
Can we export vector data from Qgis into an existing *.sqlite database?
--
You received this message because you are subscribed to the Google Groups "SpatiaLite Users" group.
To post to this group, send email to spatiali...@googlegroups.com.
To unsubscribe from this group, send email to spatialite-use...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/spatialite-users?hl=en.
--
Jefe Rodolfo Silva
Analista de SIG
CONSIS-Consultoria e Sistemas Ltda.
65 3301-3276
65 8154-6830
Paulo Eduardo Cardoso
Any suggestion? I'm not being able so far.
Paulo
On 18 Jan, 15:53, jefe rodolfo pereira da silva
> 2011/1/18 Paulo Eduardo Cardoso <pauloeducard...@gmail.com>
> > Can we export vector data from Qgis into an existing *.sqlite database?
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "SpatiaLite Users" group.
> > To post to this group, send email to spatiali...@googlegroups.com.
> > To unsubscribe from this group, send email to
> > .
Noli Sicad
Save the vector layer in QGIS. Open a console / terminal, open the
spatialite database and .loadshp command to load it in existing
spatialite database.
I just try it. It works.
Regards, Noli
> spatialite-use...@googlegroups.com.
Paulo Eduardo Cardoso
You mean the Python console?
Have you a sample code for this? This is completely new for me.
By now I'm doing this using SpatiaLite GUI | Load Shapefile utility
but I would like to do it from inside QGIS.
Regards,
Paulo
> Hi Paulo.
>
> Save the vector layer in QGIS. Open a console / terminal, open the
> spatialite database and .loadshp command to load it in existing
> spatialite database.
>
> I just try it. It works.
>
> Regards, Noli
>
>
>
>
>
>
>
>
> > Hi,
>
> > Any suggestion? I'm not being able so far.
>
> > Paulo
>
> > On 18 Jan, 15:53, jefe rodolfo pereira da silva
> > <jeferodo...@gmail.com> wrote:
> >> Pode sim Paulo.
>
> >> Um abraço,
>
> >> 2011/1/18 Paulo Eduardo Cardoso <pauloeducard...@gmail.com>
>
> >> > Can we export vector data from Qgis into an existing *.sqlite database?
>
> >> > --
> >> > You received this message because you are subscribed to the Google
> >> > Groups
> >> > "SpatiaLite Users" group.
> >> > To post to this group, send email to spatiali...@googlegroups.com.
> >> > To unsubscribe from this group, send email to
Noli Sicad
No. It is console terminal. Not a python console.
Sample code:
C:\spatialite-tools-win-x86-2.4.0\bin>spatialite VicMap20.sqlite
spatialite> .nullvalue NULL
spatialite> .headers on
spatialite> .mode column
spatialite> .tables
spatialite> .loadshp PROPERTY_MP property_mp CP1252 4326;
~~~~~~~~~
Use python console to load shapefile.
> but I would like to do it from inside QGIS.
Not possible as the moment. You can create a QGIS python plugin with
above information.
Noli
Alex Mandel
spatialite in QGIS. It would probably be best to check in with him and
the QGIS developers since this is a QGIS feature request, there's
nothing from the spatialite side that prevents it from happening.
It might also be solved when GDAL/OGR 1.8 comes out with the next
release of QGIS as I believe that too supports read/write from spatialite.
Thanks,
Alex
On 01/19/2011 01:34 PM, Paulo Eduardo Cardoso wrote:
> Hi Noli,
> You mean the Python console?
> Have you a sample code for this? This is completely new for me.
> By now I'm doing this using SpatiaLite GUI | Load Shapefile utility
> but I would like to do it from inside QGIS.
> Regards,
> Paulo
> On Jan 19, 9:16 am, Noli Sicad <nsi...@gmail.com> wrote:
>> Hi Paulo.
>>
>> Save the vector layer in QGIS. Open a console / terminal, open the
>> spatialite database and .loadshp command to load it in existing
>> spatialite database.
>>
>> I just try it. It works.
>>
>> Regards, Noli
>>
>> On 1/19/11, Paulo Eduardo Cardoso <pauloeducard...@gmail.com> wrote:
>>
>>
>>
>>
>>
>>
>>
>>> Hi,
>>
>>> Any suggestion? I'm not being able so far.
>>
>>> Paulo
>>
>>> On 18 Jan, 15:53, jefe rodolfo pereira da silva
>>> <jeferodo...@gmail.com> wrote:
>>>> Pode sim Paulo.
>>
>>>> Um abra�o,