I need to do some transform on Postgis geometry, saying turn wgs84 into gcj02, I can use ST_DumpPoints to get all the points, but after modifying them, it seems not an easy and elegant way to join them back. I tried ST_Collect, it's not taking the path from ST_DumpPoints.

closed as unclear what you're asking by user30184, Ian Turton Jul 8 '18 at 19:27

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • 1
    Why don't you use ST_Transform for the original geometry? – Zoltan Jul 8 '18 at 18:07
  • st_transform supports some standard proj4 supported codes, like epsg:4326 to epsg:3857, but in China transforming from epsg4326 to gcj02, is not included. – Deo Leung Jul 9 '18 at 1:35
  • 1
    What about extending proj with gcj02? If you can solve the transformation, then you know all the necessary parameters for proj. – Zoltan Jul 9 '18 at 10:34

Browse other questions tagged or ask your own question.