<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#333333">
<br>
<div class="moz-cite-prefix">Le 02/11/2018 à 22:27, Markus Metz a
écrit :<br>
</div>
<blockquote type="cite"
cite="mid:CAG+h=FFkd6iBhtiL=dMUUmt6S8Eo69bEss5=v6h6oW-U-kxg7w@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr"><br>
<br>
On Fri, Nov 2, 2018 at 6:32 PM Frank David <<a
href="mailto:frank.david@geophom.fr" moz-do-not-send="true">frank.david@geophom.fr</a>>
wrote:<br>
><br>
> Le 02/11/2018 à 14:43, Markus Metz a écrit :<br>
><br>
><br>
><br>
> On Fri, Nov 2, 2018 at 11:58 AM Frank David <<a
href="mailto:frank.david@geophom.fr" moz-do-not-send="true">frank.david@geophom.fr</a>>
wrote:<br>
> ><br>
> > Le 31/10/2018 à 20:57, Markus Metz a écrit :<br>
> ><br>
> > Hi Frank,<br>
> ><br>
> > On Wed, Oct 31, 2018 at 1:39 PM Frank David <<a
href="mailto:frank.david@geophom.fr" moz-do-not-send="true">frank.david@geophom.fr</a>>
wrote:<br>
> > ><br>
> > > Hello Vero,<br>
> > ><br>
> > > Thanks for your reply. It took almost one hour to
extract my area (I guess because of topology). I do the same
with Qgis from a shape in less than 10 minutes (but with several
operations)... it's may be a bad idea to have a so heavy vector
map in Grass...<br>
> ><br>
> > this kind of operation could be much faster in latest
GRASS 7.4 than in any previous versions. Which GRASS version are
you using?<br>
> ><br>
> > Hello Markus,<br>
> ><br>
> > I'm using 7.4.1 on debian9<br>
> ><br>
> > But my grass db folder is on a small server (Synology
NAS), so may be the network makes slow down the operation ?<br>
><br>
> This is possible, but it should not slow it down that much:
10 min vs 1 hour<br>
><br>
> Can you provide a link to the vector from which you want to
extract a small area, and the command you used to extract a
small area? Maybe there is scope for optimization.<br>
><br>
> Markus,<br>
><br>
> The data is CorineLandCover for france. You can download
400mo here > <a href="https://we.tl/t-tvldlmkVw3"
moz-do-not-send="true">https://we.tl/t-tvldlmkVw3</a><br>
><br>
> First I have imported the shape in PERMANENT<br>
><br>
> and I do : v.extract --verbose input=CLC12_FR_RGF@PERMANENT
where=CODE_12 IN (111,112,131,311,312,313,324) output=clc12<br>
><br>
<div>> Hope it helps you...</div>
<div><br>
</div>
<div>import of the shapefile with v.in.ogr takes here 5 minutes</div>
<div>v.extract takes here 27 seconds instead of 1 hour<br>
</div>
<div><br>
</div>
<div>"here" means a laptop with Intel Core i7 4th generation and
standard SATA SSD, i.e. no fancy new high-speed system at all.<br>
</div>
<div><br>
</div>
<div>I am afraid this does not help you. What could take long is
writing attributes, depending on the database connection. I am
using the default sqlite database.</div>
<div><br>
</div>
<div>You could use top to check if v.extract is running at 100%.<br>
</div>
</div>
</blockquote>
<p>Hello Markus,</p>
<p>Thank you for your help.</p>
<p>I'm trying to do again the operation on local machine. I want
fisrt, create a vector with only selected data (on full France
area). But I've met a problem with v.extract.</p>
<p>v.extract --overwrite --verbose input=CLC12_FR_RGF@PERMANENT
type=area where=CODE_12 IN (111,112,121,311,312,313,324)
output=CLC12_FR_RGF_BOISBATI@PERMANENT<br>
Loading categories from table <CLC12_FR_RGF>...<br>
DBMI-DBF erreur de pilote :<br>
SQL parser error (syntax error, unexpected NAME processing<br>
'IN') in statement:<br>
SELECT cat FROM CLC12_FR_RGF WHERE CODE_12 IN<br>
(111,112,121,311,312,313,324)<br>
Unable to open cursor.<br>
DBMI-DBF erreur de pilote :<br>
SQL parser error (syntax error, unexpected NAME processing<br>
'IN') in statement:<br>
SELECT cat FROM CLC12_FR_RGF WHERE CODE_12 IN<br>
(111,112,121,311,312,313,324)<br>
Unable to open cursor.<br>
ERROR: Unable select records from table <CLC12_FR_RGF><br>
</p>
<p>It looks that grass does not recognized "IN" sql condition. If I
force layer=-1, it runs bur the output vector is the same as input
one.</p>
<p>Am I wrong somewhere ? I use Grass 7.4.2 on debian9.</p>
<p>Thank you for your help.</p>
<p>Frank<br>
</p>
<blockquote type="cite"
cite="mid:CAG+h=FFkd6iBhtiL=dMUUmt6S8Eo69bEss5=v6h6oW-U-kxg7w@mail.gmail.com">
<div dir="ltr">
<div><br>
</div>
<div>Markus M<br>
</div>
><br>
> Cheers,<br>
> Frank<br>
><br>
><br>
> Markus M<br>
> ><br>
> > Cheers,<br>
> > Frank<br>
> ><br>
> ><br>
> > Markus M<br>
> > ><br>
> > > Cheers,<br>
> > ><br>
> > > Frank<br>
> > ><br>
> > > Le 31/10/2018 à 11:26, Veronica Andreo a écrit :<br>
> > ><br>
> > > Check v.extract or v.clip<br>
> > ><br>
> > > Cheers,<br>
> > > Vero<br>
> > ><br>
> > > El mié., 31 oct. 2018 7:20, Frank David <<a
href="mailto:frank.david@geophom.fr" moz-do-not-send="true">frank.david@geophom.fr</a>>
escribió:<br>
> > >><br>
> > >> Hello,<br>
> > >><br>
> > >> What is the best and fast way to make a copy
of a part of vector map<br>
> > >> (national) to get a smaller territory ?
(partial copy).<br>
> > >> Thank you for your advice !<br>
> > >><br>
> > >> Frank<br>
> > >>
_______________________________________________<br>
> > >> grass-user mailing list<br>
> > >> <a href="mailto:grass-user@lists.osgeo.org"
moz-do-not-send="true">grass-user@lists.osgeo.org</a><br>
> > >> <a
href="https://lists.osgeo.org/mailman/listinfo/grass-user"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/grass-user</a><br>
> > ><br>
> > > _______________________________________________<br>
> > > grass-user mailing list<br>
> > > <a href="mailto:grass-user@lists.osgeo.org"
moz-do-not-send="true">grass-user@lists.osgeo.org</a><br>
> > > <a
href="https://lists.osgeo.org/mailman/listinfo/grass-user"
moz-do-not-send="true">https://lists.osgeo.org/mailman/listinfo/grass-user</a></div>
</blockquote>
</body>
</html>