40#include "moc_qgscoordinatereferencesystemregistry.cpp"
42using namespace Qt::StringLiterals;
52 QList<QgsCoordinateReferenceSystemRegistry::UserCrsDetails> res;
58 if ( result != SQLITE_OK )
64 const QString sql = u
"select srs_id,description,parameters, wkt from tbl_srs"_s;
67 if ( result == SQLITE_OK )
70 while ( preparedStatement.
step() == SQLITE_ROW )
78 if ( !details.
wkt.isEmpty() )
99 QString proj4String = crs.d->mProj4;
100 if ( proj4String.isEmpty() )
102 proj4String = crs.
toProj();
114 if ( QgsCoordinateReferenceSystem::getRecordCount() == 0 )
116 mySql =
"insert into tbl_srs (srs_id,description,projection_acronym,ellipsoid_acronym,parameters,is_geo,wkt) values ("
123 + quotedEllipsoidString
132 mySql =
"insert into tbl_srs (description,projection_acronym,ellipsoid_acronym,parameters,is_geo,wkt) values ("
137 + quotedEllipsoidString
148 if ( myResult != SQLITE_OK )
153 statement = database.
prepare( mySql, myResult );
155 qint64 returnId = -1;
156 if ( myResult == SQLITE_OK && statement.
step() == SQLITE_DONE )
160 returnId = sqlite3_last_insert_rowid( database.get() );
161 crs.d->mSrsId = returnId;
162 crs.d->mAuthId = u
"USER:%1"_s.arg( returnId );
163 crs.d->mDescription = name;
166 if ( returnId != -1 )
177 if ( returnId != -1 )
194 const QString sql =
"update tbl_srs set description="
196 +
",projection_acronym="
198 +
",ellipsoid_acronym="
211 if ( myResult != SQLITE_OK )
218 QString errorMessage;
219 if ( database.
exec( sql, errorMessage ) != SQLITE_OK )
226 const int changed = sqlite3_changes( database.get() );
266 if ( result != SQLITE_OK )
275 if ( result != SQLITE_OK || preparedStatement.
step() != SQLITE_DONE )
282 const int changed = sqlite3_changes( database.get() );
289 QgsMessageLog::logMessage( QObject::tr(
"Error removing user CRS [%1]: No matching ID found in database" ).arg(
id ), QObject::tr(
"CRS" ) );
308bool QgsCoordinateReferenceSystemRegistry::insertProjection(
const QString &projectionAcronym )
315 if ( result != SQLITE_OK )
321 if ( result != SQLITE_OK )
328 const QString srsSql =
"select acronym,name,notes,parameters from tbl_projection where acronym=" +
QgsSqliteUtils::quotedString( projectionAcronym );
330 sqlite3_statement_unique_ptr srsPreparedStatement = srsDatabase.
prepare( srsSql, srsResult );
331 if ( srsResult == SQLITE_OK )
333 if ( srsPreparedStatement.
step() == SQLITE_ROW )
337 sql =
"insert into tbl_projection(acronym,name,notes,parameters) values ("
346 sqlite3_statement_unique_ptr preparedStatement = database.
prepare( sql, result );
347 if ( result != SQLITE_OK || preparedStatement.
step() != SQLITE_DONE )
365 static std::once_flag initialized;
366 static QMap< QString, QgsProjOperation > sProjOperations;
367 std::call_once( initialized, [] {
370 const PJ_OPERATIONS *operation = proj_list_operations();
371 while ( operation && operation->id )
375 value.mId = QString( operation->id );
377 const QString description( *operation->descr );
378 const QStringList descriptionParts = description.split( u
"\n\t"_s );
379 value.mDescription = descriptionParts.value( 0 );
380 value.mDetails = descriptionParts.mid( 1 ).join(
'\n' );
382 sProjOperations.insert( value.
id(), value );
388 return sProjOperations;
393 static QList< QgsCelestialBody > sCelestialBodies;
394 static std::once_flag initialized;
395 std::call_once( initialized, [] {
401 PROJ_CELESTIAL_BODY_INFO **list = proj_get_celestial_body_list_from_database( context,
nullptr, &resultCount );
402 sCelestialBodies.reserve( resultCount );
403 for (
int i = 0; i < resultCount; i++ )
405 const PROJ_CELESTIAL_BODY_INFO *info = list[i];
411 body.mAuthority = QString( info->auth_name );
412 body.mName = QString( info->name );
414 sCelestialBodies << body;
416 proj_celestial_body_list_destroy( list );
419 return sCelestialBodies;
424 static QSet< QString > sKnownAuthorities;
425 static std::once_flag initialized;
426 std::call_once( initialized, [] {
430 PROJ_STRING_LIST
authorities = proj_get_authorities_from_database( pjContext );
432 for (
auto authIter =
authorities; authIter && *authIter; ++authIter )
434 const QString authority( *authIter );
435 sKnownAuthorities.insert( authority.toLower() );
441 return sKnownAuthorities;
447 if ( mCrsDbRecordsPopulated )
448 return mCrsDbRecords;
453 if ( QFileInfo::exists( srsDatabaseFileName ) )
457 int result = database.
open_v2( srsDatabaseFileName, SQLITE_OPEN_READONLY,
nullptr );
458 if ( result == SQLITE_OK )
460 const QString sql = u
"SELECT description, srs_id, auth_name, auth_id, projection_acronym, deprecated, srs_type FROM tbl_srs"_s;
462 if ( result == SQLITE_OK )
464 while ( preparedStatement.
step() == SQLITE_ROW )
474 mCrsDbRecords.append( record );
480 mCrsDbRecordsPopulated =
true;
481 return mCrsDbRecords;
486 QList<QgsCoordinateReferenceSystem> res;
490 QStringList projectionsProj4 = settings.
value( u
"UI/recentProjectionsProj4"_s ).toStringList();
491 QStringList projectionsWkt = settings.
value( u
"UI/recentProjectionsWkt"_s ).toStringList();
492 QStringList projectionsAuthId = settings.
value( u
"UI/recentProjectionsAuthId"_s ).toStringList();
493 int max = std::max( projectionsAuthId.size(), std::max( projectionsProj4.size(), projectionsWkt.size() ) );
495 for (
int i = 0; i < max; ++i )
497 const QString proj = projectionsProj4.value( i );
498 const QString wkt = projectionsWkt.value( i );
499 const QString authid = projectionsAuthId.value( i );
502 if ( !authid.isEmpty() )
504 if ( !crs.
isValid() && !wkt.isEmpty() )
506 if ( !crs.
isValid() && !proj.isEmpty() )
518 settings.
remove( u
"UI/recentProjectionsAuthId"_s );
519 settings.
remove( u
"UI/recentProjectionsWkt"_s );
520 settings.
remove( u
"UI/recentProjectionsProj4"_s );
531 QList<QgsCoordinateReferenceSystem> recent =
recentCrs();
532 recent.removeAll( crs );
533 recent.insert( 0, crs );
536 switch ( crs.
type() )
557 QList<QgsCoordinateReferenceSystem> recentSameType;
558 std::copy_if( recent.begin(), recent.end(), std::back_inserter( recentSameType ), [crs, &hasVertical](
const QgsCoordinateReferenceSystem &it ) { return hasVertical( it ) == hasVertical( crs ); } );
561 const QList<QgsCoordinateReferenceSystem> toTrim = recentSameType.mid( 30 );
564 recent.removeOne( crsTrimmed );
569 authids.reserve( recent.size() );
571 proj.reserve( recent.size() );
573 wkt.reserve( recent.size() );
576 authids <<
c.authid();
582 settings.
setValue( u
"UI/recentProjectionsAuthId"_s, authids );
583 settings.
setValue( u
"UI/recentProjectionsWkt"_s, wkt );
584 settings.
setValue( u
"UI/recentProjectionsProj4"_s, proj );
594 QList<QgsCoordinateReferenceSystem> recent =
recentCrs();
595 recent.removeAll( crs );
597 authids.reserve( recent.size() );
599 proj.reserve( recent.size() );
601 wkt.reserve( recent.size() );
604 authids <<
c.authid();
609 settings.
setValue( u
"UI/recentProjectionsAuthId"_s, authids );
610 settings.
setValue( u
"UI/recentProjectionsWkt"_s, wkt );
611 settings.
setValue( u
"UI/recentProjectionsProj4"_s, proj );
@ Compound
Compound (horizontal + vertical) CRS.
@ Projected
Projected CRS.
@ DerivedProjected
Derived projected CRS.
@ Engineering
Engineering CRS.
@ Geographic3d
3D geopraphic CRS
@ Geographic2d
2D geographic CRS
@ Geocentric
Geocentric CRS.
CrsDefinitionFormat
CRS definition formats.
@ Wkt
WKT format (always recommended over proj string format).
static const int USER_CRS_START_ID
Minimum ID number for a user-defined projection.
@ Preferred
Preferred format, matching the most recent WKT ISO standard. Currently an alias to WKT2_2019,...
static QString qgisUserDatabaseFilePath()
Returns the path to the user qgis.db file.
static QString srsDatabaseFilePath()
Returns the path to the srs.db file.
Contains information about a celestial body.
Contains details of a custom (user defined) CRS.
QgsCoordinateReferenceSystem crs
QgsCoordinateReferenceSystem object representing the user-defined CRS.
QString proj
PROJ string definition of CRS.
QString wkt
WKT definition of CRS.
QString name
CRS name (or description).
QList< QgsCrsDbRecord > crsDbRecords() const
Returns the list of records from the QGIS srs db.
void userCrsAdded(const QString &id)
Emitted whenever a new user CRS definition is added.
void recentCrsRemoved(const QgsCoordinateReferenceSystem &crs)
Emitted when a recently used CRS has been removed from the recent CRS list.
void userCrsChanged(const QString &id)
Emitted whenever an existing user CRS definition is changed.
void recentCrsCleared()
Emitted when the list of recently used CRS has been cleared.
void recentCrsPushed(const QgsCoordinateReferenceSystem &crs)
Emitted when a recently used CRS has been pushed to the top of the recent CRS list.
QList< QgsCelestialBody > celestialBodies() const
Returns a list of all known celestial bodies.
void userCrsRemoved(long id)
Emitted when the user CRS with matching id is removed from the database.
void crsDefinitionsChanged()
Emitted whenever an operation has caused any of the known CRS definitions (including user-defined CRS...
bool updateUserCrs(long id, const QgsCoordinateReferenceSystem &crs, const QString &name, Qgis::CrsDefinitionFormat nativeFormat=Qgis::CrsDefinitionFormat::Wkt)
Updates the definition of the existing user CRS with matching id.
QgsCoordinateReferenceSystemRegistry(QObject *parent=nullptr)
Constructor for QgsCoordinateReferenceSystemRegistry, with the specified parent object.
void removeRecent(const QgsCoordinateReferenceSystem &crs)
Removes a CRS from the list of recently used CRS.
~QgsCoordinateReferenceSystemRegistry() override
long addUserCrs(const QgsCoordinateReferenceSystem &crs, const QString &name, Qgis::CrsDefinitionFormat nativeFormat=Qgis::CrsDefinitionFormat::Wkt)
Adds a new crs definition as a custom ("USER") CRS.
QSet< QString > authorities() const
Returns a list of all known authorities.
bool removeUserCrs(long id)
Removes the existing user CRS with matching id.
void clearRecent()
Cleans the list of recently used CRS.
QList< QgsCoordinateReferenceSystemRegistry::UserCrsDetails > userCrsList() const
Returns a list containing the details of all registered custom (user-defined) CRSes.
QList< QgsCoordinateReferenceSystem > recentCrs()
Returns a list of recently used CRS.
void pushRecent(const QgsCoordinateReferenceSystem &crs)
Pushes a recently used CRS to the top of the recent CRS list.
QMap< QString, QgsProjOperation > projOperations() const
Returns a map of all valid PROJ operations.
Represents a coordinate reference system (CRS).
bool isValid() const
Returns whether this CRS is correctly initialized and usable.
bool createFromWkt(const QString &wkt)
Sets this CRS using a WKT definition.
QString toProj() const
Returns a Proj string representation of this CRS.
QString ellipsoidAcronym() const
Returns the ellipsoid acronym for the ellipsoid used by the CRS.
QString projectionAcronym() const
Returns the projection acronym for the projection used by the CRS.
bool createFromProj(const QString &projString, bool identify=true)
Sets this CRS by passing it a PROJ style formatted string.
static void invalidateCache(bool disableCache=false)
Clears the internal cache used to initialize QgsCoordinateReferenceSystem objects.
QString toWkt(Qgis::CrsWktVariant variant=Qgis::CrsWktVariant::Wkt1Gdal, bool multiline=false, int indentationWidth=4) const
Returns a WKT representation of this CRS.
long srsid() const
Returns the internal CRS ID, if available.
Qgis::CrsType type() const
Returns the type of the CRS.
static void logMessage(const QString &message, const QString &tag=QString(), Qgis::MessageLevel level=Qgis::MessageLevel::Warning, bool notifyUser=true, const char *file=__builtin_FILE(), const char *function=__builtin_FUNCTION(), int line=__builtin_LINE(), Qgis::StringFormat format=Qgis::StringFormat::PlainText)
Adds a message to the log instance (and creates it if necessary).
static PJ_CONTEXT * get()
Returns a thread local instance of a proj context, safe for use in the current thread.
Contains information about a PROJ operation.
QString id() const
ID of operation.
A convenience class that simplifies locking and unlocking QReadWriteLocks.
void changeMode(Mode mode)
Change the mode of the lock to mode.
Scoped object for logging of the runtime for a single operation or group of operations.
Stores settings for use within QGIS.
QVariant value(const QString &key, const QVariant &defaultValue=QVariant(), Section section=NoSection) const
Returns the value for setting key.
void remove(const QString &key, QgsSettings::Section section=QgsSettings::NoSection)
Removes the setting key and any sub-settings of key in a section.
void setValue(const QString &key, const QVariant &value, QgsSettings::Section section=QgsSettings::NoSection)
Sets the value of setting key to value.
static QString quotedString(const QString &value)
Returns a quoted string value, surround by ' characters and with special characters correctly escaped...
Unique pointer for sqlite3 databases, which automatically closes the database when the pointer goes o...
sqlite3_statement_unique_ptr prepare(const QString &sql, int &resultCode) const
Prepares a sql statement, returning the result.
int open(const QString &path)
Opens the database at the specified file path.
QString errorMessage() const
Returns the most recent error message encountered by the database.
int open_v2(const QString &path, int flags, const char *zVfs)
Opens the database at the specified file path.
int exec(const QString &sql, QString &errorMessage) const
Executes the sql command in the database.
Unique pointer for sqlite3 prepared statements, which automatically finalizes the statement when the ...
QString columnAsText(int column) const
Returns the column value from the current statement row as a string.
int step()
Steps to the next record in the statement, returning the sqlite3 result code.
As part of the API refactoring and improvements which landed in the Processing API was substantially reworked from the x version This was done in order to allow much of the underlying Processing framework to be ported into c
T qgsEnumKeyToValue(const QString &key, const T &defaultValue, bool tryValueAsKey=true, bool *returnOk=nullptr)
Returns the value corresponding to the given key of an enum.
#define BUILTIN_UNREACHABLE
#define QgsDebugMsgLevel(str, level)
#define QgsDebugError(str)
QString projectionAcronym