'Storing Multipolygon in postgresql to than combine with another table Javascript
I have a huge file that consist of alot of multiploygons in a geojson file. I would like to save this in my database and than join it with another table. Is the best way to replace the [ and ] with () and store it that way with POLYGON, or is the are better way to solve this? I am using node/express as my server. This is an example of how the geojson polygon looks like:
[
[
[
[
5.298194750258646,
59.38375612268108
],
[
5.238152914790201,
59.4331770913096
],
[
5.246387750030943,
59.44504006435416
],
[
5.222177425937638,
59.501686571431904
],
[
5.243359043597426,
59.50341929734903
],
[
5.278484958388046,
59.48087209115295
],
[
5.302875561757018,
59.481165220603096
],
[
5.302876866809597,
59.48115641055075
],
[
5.314694597433288,
59.47542080310011
],
[
5.370557859276996,
59.4953383200662
],
[
5.3972584589994845,
59.48324530159345
],
[
5.374708831533977,
59.455300953268335
],
[
5.354964883102463,
59.45375477233842
],
[
5.352086576894662,
59.41387824954343
],
[
5.347118304423263,
59.4002262241702
],
[
5.298194750258646,
59.38375612268108
]
]
]
]
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
