I pulled the New York City census tract PostGIS from Todd Schneider's work, but I am struggling to find the correct SRID.


When I upload the above contents of the PRJ file to prj2epsg as suggested by this SE question, for instance, it fails to find a match.

  • mmm is it possible prj2epsg is not working or I'm doing something wrong? I looked up Zillow's nyc neighborhood SRID which I looked up yesterday (4269) and it doesn't appear to be working.
    – rhaskett
    Oct 31, 2017 at 18:01
  • Zilow's prj is much more simple: GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]
    – rhaskett
    Oct 31, 2017 at 18:04
  • prj2epsg.org/search says "Invalid WKT syntax" for both.
    – rhaskett
    Oct 31, 2017 at 18:05
  • EPSG:2263 from epsg-registry.org. The WKT is from Esri.
    – mkennedy
    Nov 3, 2017 at 16:32

1 Answer 1


It doesn't have an EPSG code. I looked it up on spatialreference.org with


Came up with http://spatialreference.org/ref/esri/102718/

It's ESRI:102718 which is in the proprietary ESRI namespace. The International Association of Oil & Gas Producers (OGP) Surveying & Positioning Committee maintains the proper EPSG codes.

This is the statement I would use to add it to PostGIS

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext)
( 9102718, 'esri', 102718, '+proj=lcc +lat_1=40.66666666666666 +lat_2=41.03333333333333 +lat_0=40.16666666666666 +lon_0=-74 +x_0=300000 +y_0=0 +ellps=GRS80 +datum=NAD83 +to_meter=0.3048006096012192 +no_defs ', 'PROJCS["NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet",GEOGCS["GCS_North_American_1983",DATUM["North_American_Datum_1983",SPHEROID["GRS_1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Lambert_Conformal_Conic_2SP"],PARAMETER["False_Easting",984249.9999999999],PARAMETER["False_Northing",0],PARAMETER["Central_Meridian",-74],PARAMETER["Standard_Parallel_1",40.66666666666666],PARAMETER["Standard_Parallel_2",41.03333333333333],PARAMETER["Latitude_Of_Origin",40.16666666666666],UNIT["Foot_US",0.30480060960121924],AUTHORITY["EPSG","102718"]]');

This will give it an effective PostGIS reference of 9102718. However, it shows here that the authority is ESRI and the authority has it as 102718.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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