Search results
Jump to navigation
Jump to search
Page title matches
- '''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
- DBMI-SQLite driver error: DBMI-SQLite driver error: ...703 bytes (118 words) - 10:20, 2 July 2016
- == 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
- sudo dnf install proj-devel proj-data gdal-devel sqlite-devel xml2 libxml2-devel udunits2-devel ...9 KB (1,403 words) - 19:58, 19 April 2023
- ...unctions. The database backend may be chosen from a file-based DBF tables, SQLite, MySQL, PostgreSQL, and ODBC data sources. GRASS GIS offers many spatial mo ...9 KB (1,320 words) - 15:07, 20 August 2019
- * fix timeseries plot which runs into an endless loop in t.rast.series - SQLite locking mess ...9 KB (1,384 words) - 08:49, 1 September 2022
- ...ion 3.0.x sqlite also supports temporal queries and datatypes [[http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions]] ...12 KB (1,769 words) - 15:08, 28 January 2016
- --with-readline --with-cxx --with-odbc --with-sqlite \ ...9 KB (1,536 words) - 21:21, 25 October 2013
- This is a product of sqlite. Therefore, if you need the last date included in your selection (map from ...e the [https://www.sqlite.org/lang_datefunc.html datetime functionality of SQLite] to perform this task, this should work for January: ...47 KB (7,425 words) - 17:55, 20 December 2022
- * add the OpenSSL support in both PostgreSQL and SQLite * ...12 KB (1,969 words) - 21:19, 19 August 2014
- * Make sqlite the default DB? <- needs more testing, done in GRASS 7. ...12 KB (1,994 words) - 02:52, 29 January 2014
- * SQLite default DB in grass7: switch default to per-map DB file like DBF, or keep a ...18 KB (2,655 words) - 23:54, 19 February 2016
- export TGISDB_DRIVER=sqlite export TGISDB_DATABASE=$MYGISDBASE/$MYLOC/PERMANENT/tgis/sqlite.db ...26 KB (3,839 words) - 07:30, 22 July 2022
- * <strike>establish SQLite as default DBMI driver for vector attribute storage (DBF is too limited).</ ...28 KB (4,409 words) - 21:04, 23 May 2019
- ...et, copy and build the topology, and copy the table attributes from dbf to sqlite and/or postgresql. ...40 KB (5,278 words) - 21:22, 27 May 2013
- In order to a avoid hardcoded paths to GRASS mapset files like the SQLite DB file, you can get the GISDBASE variable from the environment: path = os.path.join(gisdbase, location, mapset, 'sqlite.db') ...39 KB (5,610 words) - 20:40, 23 November 2022
- : The module is written in bash and needs a GRASS install compiled with sqlite support. ...EG format. You can create just the TMS tile tree or build the full MBTiles SQLite database. ...96 KB (15,249 words) - 16:09, 25 August 2018
- : The module is written in bash and needs a GRASS install compiled with sqlite support. ...75 KB (11,828 words) - 21:41, 16 June 2016