[postgis-devel] World Sinusoidal Projection in PostGIS

[G. Allegri]

Hi Josè,
MODIS uses a custom sinusoidal projection based on a sphere:
https://modis-land.gsfc.nasa.gov/GCTP.html I
It's defintions is http://spatialreference.org/ref/sr-org/modis-sinusoidal/

Inserting the definition inside PostGIS with a user code (>100000 by
convention) should be enough:

INSERT INTO spatial_ref_sys VALUES (
100001,
'MODIS sinusoidal',
100001,
'PROJCS["Sinusoidal",GEOGCS["GCS_Undefined",DATUM["D_Undefined",SPHEROID["User_Defined_Spheroid",6371007.181,0.0]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292519943295]],PROJECTION["Sinusoidal"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],UNIT["Meter",1.0]]',
'+proj=sinu +lon_0=0 +x_0=0 +y_0=0 +a=6371007.181 +b=6371007.181 +units=m
+no_defs'
)

giovanni


2018-01-10 11:09 GMT+01:00 José María <jmamuedo at gmail.com>:

> Hi,
>
> The question is I´m no sure if this reference system is the correct to
> define a Sinusoidal Projection from MODIS.
>
> Anyone may give me advise.
>
> Thanks,
>
> J.M.
>
> 2018-01-05 11:35 GMT+01:00 G. Allegri <giohappy at gmail.com>:
>
>> I don't have my pc right now to verify, but in that case you can insert
>> it by hand using the proj4 definition: http://epsg.io/54008.proj4
>>
>> Giovanni
>>
>> Il 5 gen 2018 11:14 AM, "José María" <jmamuedo at gmail.com> ha scritto:
>>
>>> Thanks G. Allegri.
>>>
>>> But the problem is I don´t get  any response with that query. So, that
>>> means my PostGIS has not this srid=54008.
>>>
>>> (Postgresql 9.6 PostGIS 2.0)
>>>
>>>
>>>
>>>
>>>
>>> 2018-01-05 11:06 GMT+01:00 G. Allegri <giohappy at gmail.com>:
>>>
>>>> World sinusoidal is EPSG:54008 so I guess it's proj string [1] is
>>>> already inside the spatial_ref_sys table, which is where CRS definitions
>>>> are defined in PostGIS.
>>>>
>>>> You can verify it doing:
>>>>
>>>> SELECT * FROM spatial_ref_sys WHERE srid = 54008
>>>>
>>>> Giovanni
>>>>
>>>>
>>>> [1] http://epsg.io/54008.proj4
>>>>
>>>> Il 5 gen 2018 10:46 AM, "José María" <jmamuedo at gmail.com> ha scritto:
>>>>
>>>>> Hi,
>>>>>
>>>>> I spent several days searching info about how to use Worl Sinusoidal
>>>>> porjection in PostGIS. But I didn´t find any responses.
>>>>>
>>>>> I only found a possible codification (54008)  in ESRI, but I don´t
>>>>> know how to manage this projection in PostGIS.
>>>>>
>>>>> Any people can I help me with this discussion?
>>>>>
>>>>>
>>>>> Thanks.
>>>>>
>>>>> _______________________________________________
>>>>> postgis-devel mailing list
>>>>> postgis-devel at lists.osgeo.org
>>>>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>>>>>
>>>>
>>>> _______________________________________________
>>>> postgis-devel mailing list
>>>> postgis-devel at lists.osgeo.org
>>>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>>>>
>>>
>>>
>>> _______________________________________________
>>> postgis-devel mailing list
>>> postgis-devel at lists.osgeo.org
>>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>>>
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>>
>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20180110/e762721b/attachment-0001.html>