3

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

PROJCS["NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_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",984250.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-74.0],PARAMETER["Standard_Parallel_1",40.66666666666666],PARAMETER["Standard_Parallel_2",41.03333333333333],PARAMETER["Latitude_Of_Origin",40.16666666666666],UNIT["Foot_US",0.3048006096012192]]

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 '17 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 '17 at 18:04
  • prj2epsg.org/search says "Invalid WKT syntax" for both. – rhaskett Oct 31 '17 at 18:05
  • EPSG:2263 from epsg-registry.org. The WKT is from Esri. – mkennedy Nov 3 '17 at 16:32
3

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

NAD_1983_StatePlane_New_York_Long_Island_FIPS_3104_Feet

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)
values
( 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, privacy policy and cookie policy

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