Timeline for MULTIPOLYGONM vs MULTIPOLYGON with shp2pgsql
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 1, 2017 at 16:44 | vote | accept | Ask613 | ||
| Dec 1, 2017 at 16:43 | answer | added | Ask613 | timeline score: 0 | |
| Apr 13, 2017 at 12:33 | history | edited | CommunityBot |
replaced http://gis.stackexchange.com/ with https://gis.stackexchange.com/
|
|
| Mar 24, 2017 at 19:36 | comment | added | Ask613 | @JohnBarça: I do not really know how to tell if the data is MultiPolygonM or not. But based on your suggestion I just edited file_name.sql and removed the M, and then running that SQL worked. Thank you. If you convert your comment into an answer, I will mark it accepted. | |
| Mar 24, 2017 at 19:25 | comment | added | user30184 | Use ogr2ogr for conversion and cast geometrytype into polygon with -nlt MULTIPOLYGON. | |
| Mar 24, 2017 at 19:04 | comment | added | John Powell | I don't think you can directly. Is your data actually MultiPolygonM or is it just declared that way. Because if the latter, you can always do a regex replace or similar on file_name.sql. | |
| Mar 24, 2017 at 18:20 | history | asked | Ask613 | CC BY-SA 3.0 |