Some more info: I think the new Floor Plan data we are getting are in much better format; after the JSON to database insertion, running the following command:
update SPLANNING_FLOORPLANS2 set shape = shape.MakeValid() where shape.STIsValid() = 0
does seem to fix the geometry--at least no more of the 'number of points...' error.
But the data I am getting is in SC State Plane '102733' Coordinate System. I assume the web service will always be the 1984 (3857) one? So any Published data simply never shows up in any web service. I must be doing something wrong?
Thanks.