Search results
Jump to navigation
Jump to search
Page title matches
- DBMI-SQLite driver error: DBMI-SQLite driver error: ...703 bytes (118 words) - 10:20, 2 July 2016
- '''Q:''' How can I drop a column in sqlite-databases? Old '''A:''' It is not possible to drop columns within sqlite using the syntax ALTER TABLE DROP COLUMN [1]. However, there is a workaroun ...1 KB (209 words) - 21:35, 30 December 2011
- ...S module crashed and left the sqlite database locked. How can I unlock the sqlite database? $ ps aux | grep sqlite ...529 bytes (72 words) - 09:35, 23 April 2015
- == Separate SQLite database files for vector maps == ...arallelized vector map processing in a single mapset''' is hampered ("Busy SQLite" warnings). ...2 KB (333 words) - 15:52, 3 April 2017
- '''Problem:''' SQLite lacks by default log(), sqrt(), and other functions. Name of SQLite extension file for extra functions (SQLite backend only)'' ...2 KB (251 words) - 10:47, 12 March 2017
- '''Problem:''' SQLite lacks by default log(), sqrt(), and other functions. Name of SQLite extension file for extra functions (SQLite backend only)'' ...2 KB (309 words) - 21:08, 6 November 2018
Page text matches
- DBMI-SQLite driver error: DBMI-SQLite driver error: ...703 bytes (118 words) - 10:20, 2 July 2016
- ...S module crashed and left the sqlite database locked. How can I unlock the sqlite database? $ ps aux | grep sqlite ...529 bytes (72 words) - 09:35, 23 April 2015
- '''Q:''' In SQlite (or PostgreSQL or MySQL or ...) it seems that the vector attribute manageme SQLite syntax example: ...270 bytes (46 words) - 17:18, 28 November 2012
- '''Problem:''' SQLite lacks by default log(), sqrt(), and other functions. Name of SQLite extension file for extra functions (SQLite backend only)'' ...2 KB (309 words) - 21:08, 6 November 2018
- == Separate SQLite database files for vector maps == ...arallelized vector map processing in a single mapset''' is hampered ("Busy SQLite" warnings). ...2 KB (333 words) - 15:52, 3 April 2017
- '''Problem:''' SQLite lacks by default log(), sqrt(), and other functions. Name of SQLite extension file for extra functions (SQLite backend only)'' ...2 KB (251 words) - 10:47, 12 March 2017
- ...ionally it is recommended to switch the database backend from DBF files to SQLite. Both can be done in an automated way per MAPSET as described below.'' ...l GRASS 6 vector maps to GRASS 7 (including attribute transfer from DBF to SQLite) == ...2 KB (324 words) - 10:41, 4 December 2018
- '''Q:''' How can I drop a column in sqlite-databases? Old '''A:''' It is not possible to drop columns within sqlite using the syntax ALTER TABLE DROP COLUMN [1]. However, there is a workaroun ...1 KB (209 words) - 21:35, 30 December 2011
- ==== SQLite and SpatiaLite ==== * Tips for working with [[SQLite]]/[[SpatiaLite]] ...4 KB (554 words) - 10:25, 4 December 2018
- ...export a vector map layer to a Spatialite database with v.out.ogr, use the SQLite [[OGR]] driver and set the SPATIALITE data creation option to "yes". Raster v.out.ogr in=mymap output=mydbase.sqlite format=SQLite \ ...2 KB (370 words) - 16:55, 2 February 2017
- ...rogram or the [https://addons.mozilla.org/en-US/firefox/addon/5817 Firefox SQLite Manager plugin]. ...1 KB (199 words) - 21:35, 30 December 2011
- --with-sqlite --with-sqlite-libs=/Library/Frameworks/SQLite3.framework/unix/lib --with-sqlite-includes=/Library/Frameworks/SQLite3.framework/unix/include ...3 KB (288 words) - 20:27, 11 March 2012
- #* install SQLite (it does not need setup but works out of the box) #* use g.copy or db.copy to easily transform from DBF (or whatever to SQLite). ...3 KB (495 words) - 09:19, 26 February 2008
- ...this (example) - note that it won't work with the DBF driver but requires SQLite, PostgreSQL, MySQL, or... driver: # another solution (tested under SQLite) ...2 KB (272 words) - 10:28, 4 December 2018
- * SQLite - {{cmd|grass-sqlite}} ...2 KB (228 words) - 20:31, 2 September 2018
- * SQLite == SQLite == ...7 KB (1,100 words) - 05:32, 19 May 2014
- ...devart.com/odbc/ ODBC drivers] for Oracle, SQL Server, PostgreSQL, MySQL, SQLite. === SQLite files (OpenOffice.org 2.x) === ...11 KB (1,761 words) - 09:07, 14 September 2015
- ...bring laptops pre-loaded with GRASS GIS 6.4.0, R 2.11.x (or greater), and SQLite. *Database connection: PostgreSQL, SQLite,… ...4 KB (578 words) - 08:56, 11 February 2011
- # How can I drop columns in a sqlite-database? - [[Sqlite Drop Column]] # How to unlock SQLite database? - [[SQLite unlock database]] ...5 KB (763 words) - 12:17, 2 October 2016
- ...ySQL], [http://www.unixodbc.org unixODBC], [http://www.sqlite.org SQLite] (SQLite diperlukan untuk QGIS) ...4 KB (502 words) - 09:29, 17 January 2009
- --with-sqlite --with-sqlite-libs=/Library/Frameworks/SQLite3.framework/unix/lib \ --with-sqlite-includes=/Library/Frameworks/SQLite3.framework/unix/include \ ...9 KB (1,201 words) - 06:35, 14 May 2020
- Since GRASS GIS 7.x, SQLite is the default (local) DB driver used for GRASS vector attribute management ==== SQLite ==== ...10 KB (1,585 words) - 07:37, 10 October 2023
- ...ormat. It's recommended to store attribute data in {{cmd|grass-sqlite|desc=SQLite format}} rather then in old-fashioned {{cmd|grass-dbf|desc=DBF format}}. ...or maps from selected mapset to the current and stores their attributes in SQLite database ...6 KB (973 words) - 03:12, 23 January 2017
- * SQLite input (attributes only) {{cmd|g.mapset}} sqlite ...9 KB (1,357 words) - 09:15, 8 May 2018
- * '''gvl.sqlite''' file is SQLite relational database file with tables and view described above $ v.db.connect -o map=roads driver=sqlite database=gvl.sqlite table=road_network ...8 KB (1,171 words) - 00:36, 7 December 2011
- ...ss). The module is written in bash and needs a GRASS install compiled with sqlite support. <BR>'''Authors:''' Clara Tattoni and Damiano G. Preatoni ...2 KB (261 words) - 20:07, 15 December 2011
- * SQLite file (very fast compared to DBF in GRASS GIS 7 ({{cmd|grass-sqlite}}) ...rations which take hours using the DBF backend just take seconds using the SQLite backend. ...11 KB (1,603 words) - 14:00, 27 February 2021
- === Setting the database backend connection to SQLite === In GRASS 6, the DBF driver is the default database driver. However, the SQLite driver is way more powerful. To set ...12 KB (1,972 words) - 05:44, 6 July 2017
- # (Note: DBF driver unsupported, please use SQLite, MySQL or PostgreSQL) ...3 KB (441 words) - 08:07, 19 April 2015
- ### statement for SQLite driver: ...3 KB (554 words) - 23:18, 14 December 2013
- # (Nota: el controlador DBF no está soportado, use SQLite, MySQL o PostgreSQL) ...3 KB (467 words) - 21:39, 3 August 2016
- ...or maps from selected mapset to the current and stores their attributes in SQLite database ...4 KB (604 words) - 10:50, 4 December 2018
- ...ySQL], [http://www.unixodbc.org unixODBC], [http://www.sqlite.org SQLite] (SQLite dibutuhkan untuk QGIS) --with-sqlite \ ...18 KB (2,293 words) - 20:26, 11 March 2012
- ...onnecting GRASS to the most commonly used DBMS (PostgreSQL/PostGIS, MySQL, SQLite, ...) *** SQLite (SH) ...8 KB (1,140 words) - 15:00, 29 February 2016
- POI (points of interest) are often saved into a custom Sqlite DB by the Android App, GPS tracks are typically saved into a GPX file which ....mbtiles}} script can be used to prepare an offline TMS tileset or MBTiles SQLite database suitable for the fine [http://moovida.github.io/geopaparazzi/ Geop ...8 KB (1,350 words) - 23:34, 28 August 2014
- # change default database from DBF to SQLite as it is less lossy db.connect driver=sqlite \ ...10 KB (1,580 words) - 05:32, 15 December 2014
- * '''DRIVER''': The database backend. e.g. dbf, sqlite, pg, mysql ...4 KB (644 words) - 15:25, 31 January 2016
- ...onnect driver=sqlite database=/home/user-id/grassdb/clc2000/laea/PERMANENT/sqlite.db db.connect driver=sqlite database=/geo/grassdb/ellas/laea/PERMANENT/sqlite.db ...11 KB (1,617 words) - 03:47, 2 July 2019
- ...ySQL], [http://www.unixodbc.org unixODBC], [http://www.sqlite.org SQLite] (SQLite is needed for [[QGIS]]) --with-sqlite \ ...43 KB (5,778 words) - 18:55, 18 July 2013
- --with-sqlite \ --with-sqlite \ ...36 KB (4,698 words) - 18:17, 12 March 2024
- ...of database management systems (DBMS) supported as back-ends that include: SQLite, PostgreSQL + PostGIS, MySQL, ODBC (, DBF). The vector geometry types suppo ...6 KB (852 words) - 08:29, 30 July 2013
- --with-sqlite \ postgresql-dev proj-dev python3-dev py3-numpy-dev sqlite-dev tar tiff-dev unzip vim \ ...61 KB (7,603 words) - 09:01, 10 January 2024
- * <strike>sqlite driver: 'date' support (Markus), views support (Moritz), field size fix to * <strike>SQLite transactions to speed up execute</strike> (Antonio Galea) ...14 KB (2,042 words) - 11:00, 7 February 2013
- In case of SQlite a GRASS SQL database file is created for each mapset in a location. Views a ...6 KB (1,001 words) - 10:15, 1 February 2015
- ...e sqlite3 dll can't be found, then it is very likely that there is another SQLite library in %PATH% on that windows machine. Windows operating systems don't install natively a SQLite dll in any directory available in %PATH%. ...12 KB (1,990 words) - 20:24, 15 November 2019
- ...hapefile,MapInfo_File,TIGER,S57,DGN,Memory,BNA,CSV,GML,GPX,KML,GeoJSON,GMT,SQLite,ODBC,MSSQLSpatial, ...8 KB (893 words) - 21:41, 24 March 2014
- {{AddonSrc|vector|v.in.natura2000|version=7}} imports Natura 2000 (sqlite/spatialite) GIS data. ...7 KB (1,085 words) - 07:25, 25 June 2020
- change backend DB to SQLite: db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db' ...12 KB (2,097 words) - 15:06, 20 December 2012
- The editor automatically fetches keywords from SQLite GRASS GIS backend. Three well know dictionaries are added by default. The u ...atabase''' - path to SQLite database e.g. $GISDBASE/WGS84/PERMANENT/sqlite/sqlite.db ...23 KB (3,360 words) - 09:07, 24 April 2024
- ...hapefile,MapInfo_File,TIGER,S57,DGN,Memory,BNA,CSV,GML,GPX,KML,GeoJSON,GMT,SQLite,ODBC,MSSQLSpatial, ...8 KB (952 words) - 14:21, 4 August 2016