search

mattyschell / geodatabase-buildings-bbl-qa

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

Review BBL 4125290228 #26

Closed mattyschell closed 4 months ago

mattyschell commented 4 months ago

This lot is being removed during import resulting in a hole in the tax lot fabric. Building doitt_id 1286313 is being flagged for QA though it is correct.

Review what exactly is up with this lot before adding the building id to ack.

image

mattyschell commented 4 months ago

what is this

image

mattyschell commented 4 months ago

sdo_util.rectify_geometry is turning this into a valid 2004 collection, starting with a line and then the polygon. In delettebadgeoms.sql we delete any record that is not a simple polygon or multipolygon.

Solution: extract the polygon and ditch the line.

MDSYS.SDO_GEOMETRY ( 2004, 3857, NULL, MDSYS.SDO_ELEM_INFO_ARRAY ( 1, 2, 1, 7, 1003, 1 ), MDSYS.SDO_ORDINATE_ARRAY ( -8212336.5301, 4965368.4501, -8212336.4861, 4965368.4747, -8212336.5301, 4965368.4501, -8212361.0704, 4965285.7611, -8212314.8979, 4965332.8756, -8212317.3193, 4965334.9244, -8212317.345, 4965334.9093, -8212319.2164607, 4965333.95049391, -8212321.18103506, 4965333.20074604, -8212323.21545235, 4965332.66893731, -8212325.29561456, 4965332.36136707, -8212327.3968818, 4965332.28167854, -8212329.49436419, 4965332.43081566, -8212331.5632167, 4965332.80701185, -8212333.5789334, 4965333.40581103, -8212335.51763778, 4965334.2201203, -8212337.35636555, 4965335.24029403, -8212339.07333666, 4965336.45424809, -8212340.6482133, 4965337.84760298, -8212342.06234077, 4965339.40385417, -8212343.29896849, 4965341.1045676, -8212344.34344839, 4965342.92959801, -8212345.18340842, 4965344.85732761, -8212345.80889911, 4965346.86492211, -8212346.21251142, 4965348.92860119, -8212346.38946449, 4965351.02392023, -8212346.33766228, 4965353.12605981, -8212346.05771839, 4965355.21011971, -8212345.5529488, 4965357.2514139, -8212344.82933261, 4965359.22576287, -8212343.89544117, 4965361.10978013, -8212342.76233659, 4965362.88114917, -8212341.44344068, 4965364.51888781, -8212339.954376, 4965366.00359676, -8212338.31278078, 4965367.31768937, -8212336.5381, 4965368.4456, -8212353.7212, 4965358.8335, -8212365.6363, 4965368.2213, -8212407.7456, 4965325.2523, -8212361.0704, 4965285.7611 ) )