{"push_id":927724452,"size":1,"distinct_size":1,"ref":"refs/heads/feature/better-stgeom-support","head":"b888d10a7b66c6b10c8c22ea42e0c6f395923d60","before":"3fe911707be6e06479d946e386ee552b94f32f78","commits":[{"sha":"b888d10a7b66c6b10c8c22ea42e0c6f395923d60","author":{"email":"bbfbe00f39eba682660cf45f42c4a650eb4e4fba@azavea.com","name":"Casey Thomas"},"message":"Fix parameterization of ST_Geometry column values.\n\nIn the context of running the G_REFRESH_PARCEL_ULRS_LAYER ULRS queue\nservice job, we were unable to insert parcels because the shape field\nwas not being correctly parameterized. The conditions in the changed\nif statement were not met because the shape values are not strings (they\nare NTS/GeoAPI geometry objects) and they couldn't be casted to a string.\nEven if they were converted to a string using ToString(), the string\nlengths were much shorter than 3999 characters (sometimes as small as 300\ncharacters). We know check if a certain property that is specific to geometry\nobjects is present.\n\nAlso, the way the shapes were parameteried was incorrect for ST_Geometry\ncolumns. We need to specify the type as Object, set the UDT type as\nST_Geometry, and pass the string representation of the object.\nThis is somewhat based off this example for SDO_Geometry columns:\nhttp://stackoverflow.com/questions/11969756.\n\nRefs https://github.com/azavea/oit-ulrs/issues/180","distinct":true,"url":"https://api.github.com/repos/azavea/net-dao-odp/commits/b888d10a7b66c6b10c8c22ea42e0c6f395923d60"}]}