40#include "moc_qgscoordinatereferencesystemregistry.cpp"
42using namespace Qt::StringLiterals;
54 QList<QgsCoordinateReferenceSystemRegistry::UserCrsDetails> res;
60 if ( result != SQLITE_OK )
66 const QString sql = u
"select srs_id,description,parameters, wkt from tbl_srs"_s;
69 if ( result == SQLITE_OK )
72 while ( preparedStatement.
step() == SQLITE_ROW )
80 if ( !details.
wkt.isEmpty() )
101 QString proj4String = crs.d->mProj4;
102 if ( proj4String.isEmpty() )
104 proj4String = crs.
toProj();
116 if ( QgsCoordinateReferenceSystem::getRecordCount() == 0 )
118 mySql =
"insert into tbl_srs (srs_id,description,projection_acronym,ellipsoid_acronym,parameters,is_geo,wkt) values ("
122 +
',' + quotedEllipsoidString
130 mySql =
"insert into tbl_srs (description,projection_acronym,ellipsoid_acronym,parameters,is_geo,wkt) values ("
133 +
',' + quotedEllipsoidString
143 if ( myResult != SQLITE_OK )
150 statement = database.
prepare( mySql, myResult );
152 qint64 returnId = -1;
153 if ( myResult == SQLITE_OK && statement.
step() == SQLITE_DONE )
157 returnId = sqlite3_last_insert_rowid( database.get() );
158 crs.d->mSrsId = returnId;
159 crs.d->mAuthId = u
"USER:%1"_s.arg( returnId );
160 crs.d->mDescription = name;
163 if ( returnId != -1 )
174 if ( returnId != -1 )
191 const QString sql =
"update tbl_srs set description="
204 if ( myResult != SQLITE_OK )
213 QString errorMessage;
214 if ( database.
exec( sql, errorMessage ) != SQLITE_OK )
221 const int changed = sqlite3_changes( database.get() );
261 if ( result != SQLITE_OK )
263 QgsDebugError( u
"Can't open database: %1 \n please notify QGIS developers of this error \n %2 (file name) "_s.arg( database.
errorMessage(),
271 if ( result != SQLITE_OK || preparedStatement.
step() != SQLITE_DONE )
278 const int changed = sqlite3_changes( database.get() );
285 QgsMessageLog::logMessage( QObject::tr(
"Error removing user CRS [%1]: No matching ID found in database" ).arg(
id ), QObject::tr(
"CRS" ) );
304bool QgsCoordinateReferenceSystemRegistry::insertProjection(
const QString &projectionAcronym )
311 if ( result != SQLITE_OK )
313 QgsDebugError( u
"Can't open database: %1 \n please notify QGIS developers of this error \n %2 (file name) "_s.arg( database.
errorMessage(),
318 if ( result != SQLITE_OK )
326 const QString srsSql =
"select acronym,name,notes,parameters from tbl_projection where acronym=" +
QgsSqliteUtils::quotedString( projectionAcronym );
328 sqlite3_statement_unique_ptr srsPreparedStatement = srsDatabase.
prepare( srsSql, srsResult );
329 if ( srsResult == SQLITE_OK )
331 if ( srsPreparedStatement.
step() == SQLITE_ROW )
335 sql =
"insert into tbl_projection(acronym,name,notes,parameters) values ("
341 sqlite3_statement_unique_ptr preparedStatement = database.
prepare( sql, result );
342 if ( result != SQLITE_OK || preparedStatement.
step() != SQLITE_DONE )
360 static std::once_flag initialized;
361 static QMap< QString, QgsProjOperation > sProjOperations;
362 std::call_once( initialized, []
366 const PJ_OPERATIONS *operation = proj_list_operations();
367 while ( operation && operation->id )
371 value.mId = QString( operation->id );
373 const QString description( *operation->descr );
374 const QStringList descriptionParts = description.split( u
"\n\t"_s );
375 value.mDescription = descriptionParts.value( 0 );
376 value.mDetails = descriptionParts.mid( 1 ).join(
'\n' );
378 sProjOperations.insert( value.
id(), value );
384 return sProjOperations;
389 static QList< QgsCelestialBody > sCelestialBodies;
390 static std::once_flag initialized;
391 std::call_once( initialized, []
398 PROJ_CELESTIAL_BODY_INFO **list = proj_get_celestial_body_list_from_database( context,
nullptr, &resultCount );
399 sCelestialBodies.reserve( resultCount );
400 for (
int i = 0; i < resultCount; i++ )
402 const PROJ_CELESTIAL_BODY_INFO *info = list[ i ];
408 body.mAuthority = QString( info->auth_name );
409 body.mName = QString( info->name );
411 sCelestialBodies << body;
413 proj_celestial_body_list_destroy( list );
416 return sCelestialBodies;
421 static QSet< QString > sKnownAuthorities;
422 static std::once_flag initialized;
423 std::call_once( initialized, []
428 PROJ_STRING_LIST
authorities = proj_get_authorities_from_database( pjContext );
430 for (
auto authIter =
authorities; authIter && *authIter; ++authIter )
432 const QString authority( *authIter );
433 sKnownAuthorities.insert( authority.toLower() );
439 return sKnownAuthorities;
445 if ( mCrsDbRecordsPopulated )
446 return mCrsDbRecords;
451 if ( QFileInfo::exists( srsDatabaseFileName ) )
455 int result = database.
open_v2( srsDatabaseFileName, SQLITE_OPEN_READONLY,
nullptr );
456 if ( result == SQLITE_OK )
458 const QString sql = u
"SELECT description, srs_id, auth_name, auth_id, projection_acronym, deprecated, srs_type FROM tbl_srs"_s;
460 if ( result == SQLITE_OK )
462 while ( preparedStatement.
step() == SQLITE_ROW )
472 mCrsDbRecords.append( record );
478 mCrsDbRecordsPopulated =
true;
479 return mCrsDbRecords;
484 QList<QgsCoordinateReferenceSystem> res;
488 QStringList projectionsProj4 = settings.
value( u
"UI/recentProjectionsProj4"_s ).toStringList();
489 QStringList projectionsWkt = settings.
value( u
"UI/recentProjectionsWkt"_s ).toStringList();
490 QStringList projectionsAuthId = settings.
value( u
"UI/recentProjectionsAuthId"_s ).toStringList();
491 int max = std::max( projectionsAuthId.size(), std::max( projectionsProj4.size(), projectionsWkt.size() ) );
493 for (
int i = 0; i < max; ++i )
495 const QString proj = projectionsProj4.value( i );
496 const QString wkt = projectionsWkt.value( i );
497 const QString authid = projectionsAuthId.value( i );
500 if ( !authid.isEmpty() )
502 if ( !crs.
isValid() && !wkt.isEmpty() )
504 if ( !crs.
isValid() && !proj.isEmpty() )
516 settings.
remove( u
"UI/recentProjectionsAuthId"_s );
517 settings.
remove( u
"UI/recentProjectionsWkt"_s );
518 settings.
remove( u
"UI/recentProjectionsProj4"_s );
529 QList<QgsCoordinateReferenceSystem> recent =
recentCrs();
530 recent.removeAll( crs );
531 recent.insert( 0, crs );
535 switch ( crs.
type() )
556 QList<QgsCoordinateReferenceSystem> recentSameType;
557 std::copy_if( recent.begin(), recent.end(), std::back_inserter( recentSameType ), [crs, &hasVertical](
const QgsCoordinateReferenceSystem & it )
559 return hasVertical( it ) == hasVertical( crs );
563 const QList<QgsCoordinateReferenceSystem> toTrim = recentSameType.mid( 30 );
566 recent.removeOne( crsTrimmed );
571 authids.reserve( recent.size() );
573 proj.reserve( recent.size() );
575 wkt.reserve( recent.size() );
578 authids <<
c.authid();
584 settings.
setValue( u
"UI/recentProjectionsAuthId"_s, authids );
585 settings.
setValue( u
"UI/recentProjectionsWkt"_s, wkt );
586 settings.
setValue( u
"UI/recentProjectionsProj4"_s, proj );
596 QList<QgsCoordinateReferenceSystem> recent =
recentCrs();
597 recent.removeAll( crs );
599 authids.reserve( recent.size() );
601 proj.reserve( recent.size() );
603 wkt.reserve( recent.size() );
606 authids <<
c.authid();
611 settings.
setValue( u
"UI/recentProjectionsAuthId"_s, authids );
612 settings.
setValue( u
"UI/recentProjectionsWkt"_s, wkt );
613 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())
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