search

mattyschell / geodatabase-buildings-bbl-qa

Creative Commons Zero v1.0 Universal
0 stars 1 forks source link

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

Open mattyschell opened 3 months ago

mattyschell commented 3 months ago

The transformation we are using here...

https://github.com/mattyschell/geodatabase-buildings-bbl-qa/blob/6dd2dc6e810c9709579e8871a9766276520620a2/src/setup.sql#L25

... 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.

image

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

image

mattyschell commented 3 months ago

select SDO_CS.DETERMINE_DEFAULT_CHAIN(3857,2263) from dual

SDO_CS.DETERMINE_DEFAULT_CHAIN(3857,2263)
[3857,4326,4269,2263]
mattyschell commented 3 months ago

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 commented 3 months ago

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

image

same settings in the map properties

image

mattyschell commented 3 months ago

Does not appear to work importing from arcpy with

arcpy.FeatureClassToFeatureClass_conversion

and

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

Consider:

WGS1984(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 WGS1984(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 WGS1984(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