{"id":8458,"date":"2019-04-04T05:03:55","date_gmt":"2019-04-04T03:03:55","guid":{"rendered":"http:\/\/www.sigterritoires.fr\/?p=8458"},"modified":"2021-03-09T08:03:22","modified_gmt":"2021-03-09T07:03:22","slug":"arcgis-qgis-how-to-share-data","status":"publish","type":"post","link":"https:\/\/www.sigterritoires.fr\/index.php\/arcgis-qgis-how-to-share-data\/","title":{"rendered":"ArcGIS <-> QGis. How to share data?"},"content":{"rendered":"\n

More frequently we have a cohabitation of ArcGis\nwith QGis. We keep ArcGis for heavy operations while\nQGis is used for lighter work , even if QGis is quite capable of\nassuming much more than that . Free , easier to handle, QGis is more used for portable applications.\nBut there\u2019s always the\npossibility of sharing the data between these two\nsoftware\n. Towork properly with ArcGis we use geodatabases, but\nit\nis not possible to access such data from QGis.\nTherefore, we choose to export a shapefile<\/a> that it is easily accessible\nby both software . Except that this specific format,\navailable for more than 30 years does not pose many problems. In\nthis article, we will discuss, a quite unknown option, the use of\ndatabases SpatiaLite databases, to communicate between both\nsoftware\n.
\n
\nIf\nyou want , first of all, to know why it\u2019s worth\nusing SpatiaLite instead of a shapefile, go directly\nto the paragraph Why not a shapefile?\n.\nAnd\nafterwards, return here. <\/p>\n\n\n\n\n\n\n\n

With QGis, we have already discuss how to work\nwith SpatiaLite databases ( Tutorial\ndatabases<\/a> SpatiaLite under QGis 2.8\nWien<\/a> ). ArcGis uses may be surprised since the format SpatiaLite is well\nsupported\nby ArcGis since version 10.2. <\/p>\n\n\n\n

What is<\/strong>\nSpatiaLite?<\/strong>\n<\/p>\n\n\n\n

SpatiaLite is an Open Source Spatial Data\nManagement Project built above the SQLite\nplatform.
\nHere\nis an excerpt from the Wikipedia SQLite article: <\/p>\n\n\n\n

\u201c <\/p>\n\n\n\n

\n\u00a0\u00bb\nSQLite<\/em> is<\/em> a<\/em> relational database management system contained in a C\nprogramming library and SQL language.<\/em> SQLite<\/em>\nimplements<\/em> in<\/em> great<\/em>\npart of<\/em> the SQL-92 standard and<\/em> ACID<\/em> properties<\/em>\n.<\/em> <\/p>\n\n\n\n

Unlike<\/em> traditional<\/em>\ndatabase<\/em> servers<\/em>,<\/em> such as<\/em> MySQL<\/em> or<\/em> PostgreSQL,<\/em>\nits<\/em> main<\/em> feature<\/em> is<\/em> to not<\/em> reproduce<\/em>\nthe<\/em> usual<\/em> client-<\/em> server<\/em> schema<\/a><\/em> but<\/em>\nto be<\/em> directly<\/em> integrated<\/em> into\nprograms.<\/em> The entire database<\/em> (reports,\ntables, indexes and<\/em> data)<\/em> is<\/em> stored<\/em>\nin<\/em> an<\/em> independent<\/em> file<\/em> of the<\/em> platform<\/em> .<\/em>\n<\/p>\n\n\n\n