<feed xmlns='http://www.w3.org/2005/Atom'>
<title>PROJ/data/sql, branch 8.1.1</title>
<subtitle>Forked from https://github.com/OSGeo/PROJ</subtitle>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/'/>
<entry>
<title>Merge pull request #2772 from rouault/epsg_10_028</title>
<updated>2021-07-08T13:30:27+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-07-08T13:22:16+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=0b32eaf1b1c335144ee2ac62e8c2576e8d6f81a5'/>
<id>0b32eaf1b1c335144ee2ac62e8c2576e8d6f81a5</id>
<content type='text'>
Database: update to EPSG v10.028</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
Database: update to EPSG v10.028</pre>
</div>
</content>
</entry>
<entry>
<title>Database: update to EPSG v10.027</title>
<updated>2021-06-19T19:15:39+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-06-19T19:15:39+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=9a2f2ed95074df7e22d89521a93ccccc4abfd789'/>
<id>9a2f2ed95074df7e22d89521a93ccccc4abfd789</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Database: update to EPSG v10.026</title>
<updated>2021-06-10T10:25:35+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-06-10T10:25:35+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=230012325a04876da43e67dbcff76acbaff67c3e'/>
<id>230012325a04876da43e67dbcff76acbaff67c3e</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Database: update to EPSG v10.024</title>
<updated>2021-05-27T09:49:06+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-27T09:49:06+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=548a6ab0509ea03bf4fffc377c17fcd0ba977c7d'/>
<id>548a6ab0509ea03bf4fffc377c17fcd0ba977c7d</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>Database: decrease DB size by using WITHOUT ROWID tables</title>
<updated>2021-05-24T12:40:37+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-24T12:40:37+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=ee04c2725f0f8b163ae242935a2ca21dbcc17620'/>
<id>ee04c2725f0f8b163ae242935a2ca21dbcc17620</id>
<content type='text'>
None of our tables are indexed by a INTEGER PRIMARY KEY, but most of
them are by a (auth_name, code) primary key. Consequently they can
benefit from being created as WITHOUT ROWID tables
(https://sqlite.org/withoutrowid.html), which avoids an index to be
created on the rowid we don't use. WITHOUT ROWID is a feature added in
SQLite 3.8.2, so as our baseline is 3.11, we can use it.

This decreases the DB size from 7,749,632 to 7,229,440 bytes, without
any measurable consequence on performance.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
None of our tables are indexed by a INTEGER PRIMARY KEY, but most of
them are by a (auth_name, code) primary key. Consequently they can
benefit from being created as WITHOUT ROWID tables
(https://sqlite.org/withoutrowid.html), which avoids an index to be
created on the rowid we don't use. WITHOUT ROWID is a feature added in
SQLite 3.8.2, so as our baseline is 3.11, we can use it.

This decreases the DB size from 7,749,632 to 7,229,440 bytes, without
any measurable consequence on performance.
</pre>
</div>
</content>
</entry>
<entry>
<title>Database: add a ANALYZE step during proj.db creation</title>
<updated>2021-05-22T22:48:25+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-22T22:42:10+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=1720b0586cfe0b4e0b32fd8b3ca5b9ef1799d2bc'/>
<id>1720b0586cfe0b4e0b32fd8b3ca5b9ef1799d2bc</id>
<content type='text'>
This will create the sqlite_stat* table (generally sqlite_stat1). This
speeds up a bit the test suite. Runtime of ``make test_cpp_api-check``
goes from the range [14.0 s, 14.6 s] to [13.0s, 13.5s] on my machine.
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
This will create the sqlite_stat* table (generally sqlite_stat1). This
speeds up a bit the test suite. Runtime of ``make test_cpp_api-check``
goes from the range [14.0 s, 14.6 s] to [13.0s, 13.5s] on my machine.
</pre>
</div>
</content>
</entry>
<entry>
<title>projsync: make it filter out files not intended for the current version</title>
<updated>2021-05-17T14:00:12+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-17T14:00:12+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=aee1709d6c02f466b88ea0aa44928e6820f45045'/>
<id>aee1709d6c02f466b88ea0aa44928e6820f45045</id>
<content type='text'>
* Add a PROJ_DATA.VERSION in proj.db to indicate the target PROJ-data
  package version
* Make projsync use that information and the version_added and
  version_removed properties added in https://github.com/OSGeo/PROJ-data/pull/67
  to filter out files that are not relevant
* Add --no-version-filtering and --verbose switches
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
* Add a PROJ_DATA.VERSION in proj.db to indicate the target PROJ-data
  package version
* Make projsync use that information and the version_added and
  version_removed properties added in https://github.com/OSGeo/PROJ-data/pull/67
  to filter out files that are not relevant
* Add --no-version-filtering and --verbose switches
</pre>
</div>
</content>
</entry>
<entry>
<title>Merge pull request #2723 from rouault/grid_alternatives_AGQG_20201120</title>
<updated>2021-05-17T10:26:59+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-17T10:26:59+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=5fe51fad2c0e5d8ff880b3c7f5c652be8a680381'/>
<id>5fe51fad2c0e5d8ff880b3c7f5c652be8a680381</id>
<content type='text'>
grid_alternatives.sql: reference AGQG_20201120.gsb </content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
grid_alternatives.sql: reference AGQG_20201120.gsb </pre>
</div>
</content>
</entry>
<entry>
<title>Database: map ESRI spain/peninsula and spain/baleares grids</title>
<updated>2021-05-16T19:21:56+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-16T19:21:56+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=7d2f76694051d7827cb0a21b369c027d00743a20'/>
<id>7d2f76694051d7827cb0a21b369c027d00743a20</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
<entry>
<title>grid_alternatives.sql: reference AGQG_20201120.gsb (cf OSGeo/PROJ-data#63)</title>
<updated>2021-05-16T19:10:20+00:00</updated>
<author>
<name>Even Rouault</name>
<email>even.rouault@spatialys.com</email>
</author>
<published>2021-05-16T12:15:53+00:00</published>
<link rel='alternate' type='text/html' href='https://git.otimperi.dev/PROJ/commit/?id=6cca5d6df50c2b607adad3704a4ef3d1aeac43dc'/>
<id>6cca5d6df50c2b607adad3704a4ef3d1aeac43dc</id>
<content type='text'>
</content>
<content type='xhtml'>
<div xmlns='http://www.w3.org/1999/xhtml'>
<pre>
</pre>
</div>
</content>
</entry>
</feed>
