<div dir="ltr"><div>I found a CRS in proj.db that seems to be deprecated, but I do not understand why exactly (or what does deprecated mean)</div><div><br></div><div><span style="color:rgb(32,33,36);font-family:"Roboto Mono",monospace;font-size:11px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:pre-wrap;word-spacing:0px;background-color:rgb(250,250,250);text-decoration-style:initial;text-decoration-color:initial;display:inline;float:none">NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet</span></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">(I guess it happens to other CRSs as well. Let's focus in this one) <br></div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">in proj.db (table projected_crs) appears as ESRI:102747, deprecated</div><div class="gmail_signature" data-smartmail="gmail_signature">I ended up in this repo, where I think we get the ESRI CRSs<br></div><div class="gmail_signature" data-smartmail="gmail_signature"><a href="https://github.com/Esri/projection-engine-db-doc/blob/master/json/pe_list_projcs.json">https://github.com/Esri/projection-engine-db-doc/blob/master/json/pe_list_projcs.json</a> (json is easier to read than csv)<br></div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">That CRS appears twice in the file, with exactly the same name. The only differences I can find are:</div><div class="gmail_signature" data-smartmail="gmail_signature"> - wkid</div><div class="gmail_signature" data-smartmail="gmail_signature"> - authority / version</div><div class="gmail_signature" data-smartmail="gmail_signature"> - deprecated<br></div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature"><pre style="color:rgb(0,0,0);font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;white-space:pre-wrap">  { "wkid": 2284,
    "latestWkid": 2284,
    "macro": "PE_PCS_NAD_1983_VA_S_FT",
    "name": "NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",
    "wkt": "PROJCS[\"NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",11482916.66666666],PARAMETER[\"False_Northing\",3280833.333333333],PARAMETER[\"Central_Meridian\",-78.5],PARAMETER[\"Standard_Parallel_1\",36.76666666666667],PARAMETER[\"Standard_Parallel_2\",37.96666666666667],PARAMETER[\"Latitude_Of_Origin\",36.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]",
    "description": "NAD 1983 SPCS Virginia South (Feet)",
    "authority": "EPSG",
    "version": "5.3(9.0.0)",
    "deprecated": "no",
    "areaname": "USA - Virginia - SPCS - S",
    "extent":
    { "slat": 36.54,
      "nlat": 38.28,
      "llon": -83.68,
      "rlon": -75.31
    }
  },</pre></div><div class="gmail_signature" data-smartmail="gmail_signature"><pre style="color:rgb(0,0,0);font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial;white-space:pre-wrap">  { "wkid": 102747,
    "latestWkid": 2284,
    "macro": "PE_PCS_NAD_1983_VA_S_FT",
    "name": "NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet",
    "wkt": "PROJCS[\"NAD_1983_StatePlane_Virginia_South_FIPS_4502_Feet\",GEOGCS[\"GCS_North_American_1983\",DATUM[\"D_North_American_1983\",SPHEROID[\"GRS_1980\",6378137.0,298.257222101]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Lambert_Conformal_Conic\"],PARAMETER[\"False_Easting\",11482916.66666666],PARAMETER[\"False_Northing\",3280833.333333333],PARAMETER[\"Central_Meridian\",-78.5],PARAMETER[\"Standard_Parallel_1\",36.76666666666667],PARAMETER[\"Standard_Parallel_2\",37.96666666666667],PARAMETER[\"Latitude_Of_Origin\",36.33333333333334],UNIT[\"Foot_US\",0.3048006096012192]]",
    "description": "NAD 1983 SPCS Virginia South (Feet)",
    "authority": "Esri",
    "version": "8.0.1",
    "deprecated": "yes",
    "areaname": "USA - Virginia - SPCS - S",
    "extent":
    { "slat": 36.54,
      "nlat": 38.28,
      "llon": -83.68,
      "rlon": -75.31
    }
  },</pre></div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">I do not know what does it mean. Has ESRI deprecated its own CRS, but includes the EPSG one (btw, which one?)... with exactly the same info and name?</div><div class="gmail_signature" data-smartmail="gmail_signature">The consequence is that it appears (only once) as deprecated in proj.db. Is that intended?</div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">Making this query</div><div class="gmail_signature" data-smartmail="gmail_signature">SELECT auth_name, code, name, deprecated FROM projected_crs WHERE name LIKE "%Virginia%South%"<br></div><div class="gmail_signature" data-smartmail="gmail_signature">I realized that the deprecated ones are duplicated in a similar way in ESRI file. The non deprecated ones (from CORS96) are not "duplicated" in the ESRI file. Is there any reason behind that?</div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">A more general question: What does mean that a CRS is deprecated?</div><div class="gmail_signature" data-smartmail="gmail_signature"><br></div><div class="gmail_signature" data-smartmail="gmail_signature">Thanks<br></div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature">.___ ._ ..._ .. . ._.  .___ .. __ . _. . __..  ... .... ._ .__<br>Entre dos pensamientos racionales <br>hay infinitos pensamientos irracionales.<br><br></div></div></div></div>