Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have serveral layers in PostGis that use a custom projection. I added the projection SRID and it's deffinition to the spatial_ref_sys table but, when I load the layer in QGis, I get the "Coordinate reference System Selector" dialog. Shouldn't QGis automagically read the proj definitions from the spatial_ref_sys table? The spatial_ref_sys table is in the public schema and the layers are on a different schema. The custom SRID that I added with code 90001 is:

'PROJCS["Brazil / Albers Equal Area Conic (WGS84)",GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]],PROJECTION["Albers_Conic_Equal_Area"],PARAMETER["longitude_of_center",-48.5],PARAMETER["standard_parallel_1",-20.5],PARAMETER["standard_parallel_2",-24.5],PARAMETER["latitude_of_center",-25.0],UNIT["Meter",1.0]]'

Thanks

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

QGIS doesn't access spatial_ref_sys. It fetches the EPSG code and tries to look it up in its own CRS database.

Therefore, you will have to add the custom CRS to QGIS too if you want to be able to use it. See How to define new custom projections in QGIS?.

share|improve this answer
    
Thanks, I'll create the custom CRS. Any chance of QGIS linking the SRID from postgis (listed in geoetry_columns table) to my custom CRS. Or do I need to choose the custom CRS each time I load the postgis layer –  Daniel Aug 22 '12 at 20:51
    
You could try with matching IDs but I haven't tested that yet. –  underdark Aug 22 '12 at 20:57
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.