From f386e22e3604b6268989a04a4749b5bc24b3a632 Mon Sep 17 00:00:00 2001 From: Even Rouault Date: Tue, 28 Sep 2021 14:47:07 +0200 Subject: AuthorityFactory::createGeodeticCRS(): use description column for remarks --- src/iso19111/factory.cpp | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src') diff --git a/src/iso19111/factory.cpp b/src/iso19111/factory.cpp index a898af6d..6c81b5ff 100644 --- a/src/iso19111/factory.cpp +++ b/src/iso19111/factory.cpp @@ -4809,8 +4809,7 @@ AuthorityFactory::createGeodeticCRS(const std::string &code, } std::string sql("SELECT name, type, coordinate_system_auth_name, " "coordinate_system_code, datum_auth_name, datum_code, " - "text_definition, " - "deprecated FROM " + "text_definition, deprecated, description FROM " "geodetic_crs WHERE auth_name = ? AND code = ?"); if (geographicOnly) { sql += " AND type in (" GEOG_2D_SINGLE_QUOTED "," GEOG_3D_SINGLE_QUOTED @@ -4831,9 +4830,10 @@ AuthorityFactory::createGeodeticCRS(const std::string &code, const auto &datum_code = row[5]; const auto &text_definition = row[6]; const bool deprecated = row[7] == "1"; + const auto &remarks = row[8]; auto props = d->createPropertiesSearchUsages("geodetic_crs", code, name, - deprecated); + deprecated, remarks); if (!text_definition.empty()) { DatabaseContext::Private::RecursionDetector detector(d->context()); -- cgit v1.2.3