Investigate tax lot transformation from web mercator to new york state plane

[mattyschell]

The transformation we are using here...

geodatabase-buildings-bbl-qa/src/setup.sql

Line 25 in 6dd2dc6

,sdo_cs.transform(a.shape,2263) as shape

... aligns poorly with the on-the-fly transformation we see in ArcGIS Pro. The pink line on the left is a tax lot output by the code in this repository. The blue line on the right is tax lots in web mercator projected on the fly in ArcGIS Pro.

ArcGIS Pro is usually correct about these things. Review the transformation path here:

[mattyschell]

select SDO_CS.DETERMINE_DEFAULT_CHAIN(3857,2263) from dual

SDO_CS.DETERMINE_DEFAULT_CHAIN(3857,2263)
[3857,4326,4269,2263]

[mattyschell]

The Dept of Finance has a request from City Planning to also publish this service in spatial reference id 2263. It may be better to wait for that service than to go down the transformation chain rabbit hole.

[mattyschell]

Import from 3857 service works well in ArcGIS Pro like this:

same settings in the map properties

[mattyschell]

Does not appear to work importing from arcpy with

arcpy.FeatureClassToFeatureClass_conversion

and

arcpy.env.geographicTransformations = "WGS_1984_(ITRF00)_To_NAD_1983"

Consider:

• featureclasstogeodatabase is different from FeatureClassToFeatureClass_conversion?
• More magic transforms to try!

WGS_1984_(ITRF00)To_NAD_1983
NAD_1983_To_WGS_1984_5
NAD_1983_To_WGS_1984_4
NAD_1983_To_WGS_1984_1
NAD_1927_To_WGS_1984_79_CONUS + NAD_1927_To_NAD_1983_NADCON
NAD_1927_To_WGS_1984_4 + NAD_1927_To_NAD_1983_NADCON
NAD_1927_To_WGS_1984_5 + NAD_1927_To_NAD_1983_NADCON
NAD_1927_To_WGS_1984_3 + NAD_1927_To_NAD_1983_NADCON
NAD_1983_HARN_To_WGS_1984_2 + NAD_1983_To_HARN_New_York
NAD_1983_HARN_To_WGS_1984_3 + NAD_1983_To_HARN_New_York
WGS_1984(ITRF00)To_NAD_1983_HARN + NAD_1983_To_HARN_New_York
NAD_1983_To_WGS_1984_New_York_31
NAD_1983_HARN_To_WGS_1984 + NAD_1983_To_HARN_New_York
NAD_1983_HARN_To_WGS_1984_2 + NAD_1983_To_HARN_New_Jersey
NAD_1983_HARN_To_WGS_1984_3 + NAD_1983_To_HARN_New_Jersey
WGS_1984(ITRF00)_To_NAD_1983_HARN + NAD_1983_To_HARN_New_Jersey
NAD_1983_To_WGS_1984_New_Jersey_53
NAD_1983_HARN_To_WGS_1984 + NAD_1983_To_HARN_New_Jersey