Carlos -
AFAIK, the QGIS web client supports different CRS's in the same project,
because QGIS Web server (which is QGIS in its core) does. List members,
please correct me if I'm wrong.
Regarding the choice of CRS: Select the CRS, which mostly will be used
for the different end-user applications, and transform your data to this
CRS.
One caveat: If you use OGR2OGR (GDAL) to transform and load data to
MS-SQLServer, all your string based attributes will be converted to
"varchar"s. That means, that many accented characters (german, spanish,
french, danish .....) will be misrepresented in the database.
Regards
Bo Victor Thomsen
Aestas-GIS
Denmark
Den 25-04-2014 09:10, Carlos da Ponte skrev:
I'm setting up a spatial database in MS SQL Server. Data is in a variety of
CRS. The intent is to use the entire QGIS suite (desktop, server,
web-client) to view the data and run analysis. I've set up many databases
in the past but never one that merged data with numerous CRS.
my question is...what is the best practice for choosing a CRS, since QGIS
desktop can do on the fly transformation, but the web client cannot? Also
we want to be able to conduct spatial analysis within the database with
ease.
Our first thought was to transform all data on import from the original CRS
into WGS84? is this a good approach?
in addition we want to use an aerial photo service as a background. any
ideas would be welcome.
Thanks!
--
View this message in context:
http://osgeo-org.1560.x6.nabble.com/Creating-a-spatial-database-CRS-selection-tp5137067.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
