[Qgis-user] Creating a spatial database: CRS selection

[Bo Victor Thomsen]

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
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user