<div dir="ltr">Thanks!<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, 18 Aug 2023 at 10:45, Even Rouault <<a href="mailto:even.rouault@spatialys.com">even.rouault@spatialys.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi Javier,<br>
<br>
><br>
> Having a look at proj.db, I have seen a column in the table <br>
> "grid_alternatives" called "open_license"<br>
> What is the purpose of this field? (apart from allowing a meaningless <br>
> "url")<br>
> I guess it is not effectively used in the code.<br>
><br>
It is reported as a metadata information in <br>
proj_grid_get_info_from_database(), so users can make an informed <br>
choice. It is used only for the following 2 grids which are publicly <br>
available but whose license terms are not considered open data:<br>
<br>
('naptrans2008.gtx','','naptrans2008.gtx','GTX','geoid_like',0,NULL,'<a href="https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/naptrans2008.gtx" rel="noreferrer" target="_blank">https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/naptrans2008.gtx</a>',1,0,NULL),<br>
('rdtrans2008.gsb','','rdtrans2008.gsb','NTv2','hgridshift',0,NULL,'<a href="https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/rdtrans2008.gsb" rel="noreferrer" target="_blank">https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/rdtrans2008.gsb</a>',1,0,NULL),<br>
('netherlands/rdtrans2008','','rdtrans2008.gsb','NTv2','hgridshift',0,NULL,'<a href="https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/rdtrans2008.gsb" rel="noreferrer" target="_blank">https://salsa.debian.org/debian-gis-team/proj-rdnap/raw/upstream/2008/rdtrans2008.gsb</a>',1,0,NULL),<br>
<br>
> The three entries with this field to "0" are a bit redundant, right?<br>
<br>
No I don't think so. There are 2 different grids. And the rdtrans2008 <br>
one has a different name if it is used by EPSG records or ESRI records, <br>
hence 2 records for it as original_grid_name is the key.<br>
<br>
<br>
> "original_grid_name" and "old_proj_grid_name" are the same. Are those <br>
> entries needed?<br>
<br>
There are tons of records where they are different like:<br>
<br>
INSERT INTO grid_alternatives(original_grid_name,<br>
                               proj_grid_name,<br>
                               old_proj_grid_name,<br>
                               proj_grid_format,<br>
                               proj_method,<br>
                               inverse_direction,<br>
                               package_name,<br>
                               url, direct_download, open_license, <br>
directory)<br>
                       VALUES ('conus.las',<br>
                               'us_noaa_conus.tif',<br>
                               'conus',<br>
                               'GTiff',<br>
                               'hgridshift',<br>
                               0,<br>
                               NULL,<br>
'<a href="https://cdn.proj.org/us_noaa_conus.tif" rel="noreferrer" target="_blank">https://cdn.proj.org/us_noaa_conus.tif</a>', 1, 1, NULL);<br>
<br>
<br>
old_proj_grid_name corresponds to known grid names by PROJ before PROJ 7 <br>
and the migration to GeoTIFF, so NTv2, CTable2 and GTX files<br>
<br>
original_grid_name corresponds to the """"official"""" name in the <br>
registry imported by PROJ, so most of the time the one used by EPSG (and <br>
a few ones from ESRI or IGNF)<br>
<br>
Even<br>
<br>
<br>
-- <br>
<a href="http://www.spatialys.com" rel="noreferrer" target="_blank">http://www.spatialys.com</a><br>
My software is free, but my time generally not.<br>
<br>
_______________________________________________<br>
PROJ mailing list<br>
<a href="mailto:PROJ@lists.osgeo.org" target="_blank">PROJ@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/proj" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/proj</a><br>
</blockquote></div>