19#include "moc_qgscoordinatereferencesystemregistry.cpp"
48 QList<QgsCoordinateReferenceSystemRegistry::UserCrsDetails> res;
54 if ( result != SQLITE_OK )
60 const QString sql = QStringLiteral(
"select srs_id,description,parameters, wkt from tbl_srs" );
61 QgsDebugMsgLevel( QStringLiteral(
"Query to populate existing list:%1" ).arg( sql ), 4 );
63 if ( result == SQLITE_OK )
66 while ( preparedStatement.
step() == SQLITE_ROW )
74 if ( !details.
wkt.isEmpty() )
95 QString proj4String =
crs.d->mProj4;
96 if ( proj4String.isEmpty() )
110 if ( QgsCoordinateReferenceSystem::getRecordCount() == 0 )
112 mySql =
"insert into tbl_srs (srs_id,description,projection_acronym,ellipsoid_acronym,parameters,is_geo,wkt) values ("
116 +
',' + quotedEllipsoidString
124 mySql =
"insert into tbl_srs (description,projection_acronym,ellipsoid_acronym,parameters,is_geo,wkt) values ("
127 +
',' + quotedEllipsoidString
137 if ( myResult != SQLITE_OK )
139 QgsDebugError( QStringLiteral(
"Can't open or create database %1: %2" )
144 statement = database.
prepare( mySql, myResult );
146 qint64 returnId = -1;
147 if ( myResult == SQLITE_OK && statement.
step() == SQLITE_DONE )
151 returnId = sqlite3_last_insert_rowid( database.get() );
152 crs.d->mSrsId = returnId;
153 crs.d->mAuthId = QStringLiteral(
"USER:%1" ).arg( returnId );
154 crs.d->mDescription = name;
157 if ( returnId != -1 )
168 if ( returnId != -1 )
185 const QString sql =
"update tbl_srs set description="
198 if ( myResult != SQLITE_OK )
200 QgsDebugError( QStringLiteral(
"Can't open or create database %1: %2" )
207 QString errorMessage;
208 if ( database.
exec( sql, errorMessage ) != SQLITE_OK )
215 const int changed = sqlite3_changes( database.get() );
255 if ( result != SQLITE_OK )
257 QgsDebugError( QStringLiteral(
"Can't open database: %1 \n please notify QGIS developers of this error \n %2 (file name) " ).arg( database.
errorMessage(),
265 if ( result != SQLITE_OK || preparedStatement.
step() != SQLITE_DONE )
267 QgsDebugError( QStringLiteral(
"failed to remove custom CRS from database: %1 [%2]" ).arg( sql, database.
errorMessage() ) );
272 const int changed = sqlite3_changes( database.get() );
279 QgsMessageLog::logMessage( QObject::tr(
"Error removing user CRS [%1]: No matching ID found in database" ).arg(
id ), QObject::tr(
"CRS" ) );
298bool QgsCoordinateReferenceSystemRegistry::insertProjection(
const QString &projectionAcronym )
305 if ( result != SQLITE_OK )
307 QgsDebugError( QStringLiteral(
"Can't open database: %1 \n please notify QGIS developers of this error \n %2 (file name) " ).arg( database.
errorMessage(),
312 if ( result != SQLITE_OK )
320 const QString srsSql =
"select acronym,name,notes,parameters from tbl_projection where acronym=" +
QgsSqliteUtils::quotedString( projectionAcronym );
323 if ( srsResult == SQLITE_OK )
325 if ( srsPreparedStatement.
step() == SQLITE_ROW )
329 sql =
"insert into tbl_projection(acronym,name,notes,parameters) values ("
336 if ( result != SQLITE_OK || preparedStatement.
step() != SQLITE_DONE )
338 QgsDebugError( QStringLiteral(
"Could not insert projection into database: %1 [%2]" ).arg( sql, database.
errorMessage() ) );
354 static std::once_flag initialized;
355 static QMap< QString, QgsProjOperation > sProjOperations;
356 std::call_once( initialized, []
360 const PJ_OPERATIONS *operation = proj_list_operations();
361 while ( operation && operation->id )
365 value.mId = QString( operation->id );
367 const QString description( *operation->descr );
368 const QStringList descriptionParts = description.split( QStringLiteral(
"\n\t" ) );
369 value.mDescription = descriptionParts.value( 0 );
370 value.mDetails = descriptionParts.mid( 1 ).join(
'\n' );
372 sProjOperations.insert( value.
id(), value );
378 return sProjOperations;
383#if PROJ_VERSION_MAJOR>8 || (PROJ_VERSION_MAJOR==8 && PROJ_VERSION_MINOR>=1)
384 static QList< QgsCelestialBody > sCelestialBodies;
385 static std::once_flag initialized;
386 std::call_once( initialized, []
393 PROJ_CELESTIAL_BODY_INFO **list = proj_get_celestial_body_list_from_database( context,
nullptr, &resultCount );
394 sCelestialBodies.reserve( resultCount );
395 for (
int i = 0; i < resultCount; i++ )
397 const PROJ_CELESTIAL_BODY_INFO *info = list[ i ];
403 body.mAuthority = QString( info->auth_name );
404 body.mName = QString( info->name );
406 sCelestialBodies << body;
408 proj_celestial_body_list_destroy( list );
411 return sCelestialBodies;
413 throw QgsNotSupportedException( QObject::tr(
"Retrieving celestial bodies requires a QGIS build based on PROJ 8.1 or later" ) );
419 static QSet< QString > sKnownAuthorities;
420 static std::once_flag initialized;
421 std::call_once( initialized, []
426 PROJ_STRING_LIST
authorities = proj_get_authorities_from_database( pjContext );
428 for (
auto authIter =
authorities; authIter && *authIter; ++authIter )
430 const QString authority( *authIter );
431 sKnownAuthorities.insert( authority.toLower() );
437 return sKnownAuthorities;
443 if ( mCrsDbRecordsPopulated )
444 return mCrsDbRecords;
449 if ( QFileInfo::exists( srsDatabaseFileName ) )
453 int result = database.
open_v2( srsDatabaseFileName, SQLITE_OPEN_READONLY,
nullptr );
454 if ( result == SQLITE_OK )
456 const QString sql = QStringLiteral(
"SELECT description, srs_id, auth_name, auth_id, projection_acronym, deprecated, srs_type FROM tbl_srs" );
458 if ( result == SQLITE_OK )
460 while ( preparedStatement.
step() == SQLITE_ROW )
470 mCrsDbRecords.append( record );
476 mCrsDbRecordsPopulated =
true;
477 return mCrsDbRecords;
482 QList<QgsCoordinateReferenceSystem> res;
486 QStringList projectionsProj4 = settings.
value( QStringLiteral(
"UI/recentProjectionsProj4" ) ).toStringList();
487 QStringList projectionsWkt = settings.
value( QStringLiteral(
"UI/recentProjectionsWkt" ) ).toStringList();
488 QStringList projectionsAuthId = settings.
value( QStringLiteral(
"UI/recentProjectionsAuthId" ) ).toStringList();
489 int max = std::max( projectionsAuthId.size(), std::max( projectionsProj4.size(), projectionsWkt.size() ) );
491 for (
int i = 0; i < max; ++i )
493 const QString proj = projectionsProj4.value( i );
494 const QString wkt = projectionsWkt.value( i );
495 const QString authid = projectionsAuthId.value( i );
498 if ( !authid.isEmpty() )
514 settings.
remove( QStringLiteral(
"UI/recentProjectionsAuthId" ) );
515 settings.
remove( QStringLiteral(
"UI/recentProjectionsWkt" ) );
516 settings.
remove( QStringLiteral(
"UI/recentProjectionsProj4" ) );
527 QList<QgsCoordinateReferenceSystem> recent =
recentCrs();
528 recent.removeAll(
crs );
529 recent.insert( 0,
crs );
554 QList<QgsCoordinateReferenceSystem> recentSameType;
557 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( QStringLiteral(
"UI/recentProjectionsAuthId" ), authids );
583 settings.
setValue( QStringLiteral(
"UI/recentProjectionsWkt" ), wkt );
584 settings.
setValue( QStringLiteral(
"UI/recentProjectionsProj4" ), 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( QStringLiteral(
"UI/recentProjectionsAuthId" ), authids );
610 settings.
setValue( QStringLiteral(
"UI/recentProjectionsWkt" ), wkt );
611 settings.
setValue( QStringLiteral(
"UI/recentProjectionsProj4" ), 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)
@ 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()
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.
This class 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)
Adds a message to the log instance (and creates it if necessary).
Custom exception class which is raised when an operation is not supported.
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.
The QgsReadWriteLocker class is a convenience class that simplifies locking and unlocking QReadWriteL...
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.
This class is a composition of two QSettings instances:
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
const int USER_CRS_START_ID
Magick number that determines whether a projection crsid is a system (srs.db) or user (~/....
struct projCtx_t PJ_CONTEXT
#define QgsDebugMsgLevel(str, level)
#define QgsDebugError(str)
const QgsCoordinateReferenceSystem & crs
QString projectionAcronym