Timeline for Insert points to PostGIS using a function
Current License: CC BY-SA 3.0
17 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 10, 2016 at 10:46 | vote | accept | Mozafar Veysipanah | ||
| Aug 4, 2016 at 13:21 | history | edited | Kirk Kuykendall | CC BY-SA 3.0 |
added 53 characters in body
|
| Aug 4, 2016 at 12:19 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
deleted 30 characters in body
|
| Aug 3, 2016 at 14:34 | history | edited | artwork21 |
edited tags
|
|
| Aug 3, 2016 at 14:12 | answer | added | Paul Ramsey | timeline score: 5 | |
| S Aug 3, 2016 at 12:59 | history | suggested | Shahzad Bacha | CC BY-SA 3.0 |
improved formatting, corrected grammer
|
| Aug 3, 2016 at 12:49 | review | Suggested edits | |||
| S Aug 3, 2016 at 12:59 | |||||
| Aug 3, 2016 at 12:42 | comment | added | kttii | is gid an autonumber column? If so, then just leave that column out and let the database assign the id: cur.execute ("INSERT INTO gronkarta.test5 (height, geom) VALUES (str(height), ST_GeomFromText('POINT(X Y)', 3008))") | |
| Aug 3, 2016 at 11:47 | history | rollback | Mozafar Veysipanah |
Rollback to Revision 1
|
|
| Aug 3, 2016 at 11:13 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
deleted 36 characters in body
|
| Aug 3, 2016 at 8:25 | comment | added | Mozafar Veysipanah | Thanks for your response. I changed the code like this: cur.execute ("INSERT INTO gronkarta.test5 (gid, height, geom) VALUES (gid, str(height), ST_GeomFromText('POINT(X Y)', 3008))") Error: There is a column named "gid" in table "test5", but it cannot be referenced from this part of the query. | |
| Aug 3, 2016 at 8:10 | comment | added | John Powell | Use something like stackoverflow.com/questions/902408/…. There is no need to build up a string like that. | |
| Aug 3, 2016 at 6:51 | comment | added | Mozafar Veysipanah | I used Python for this code. | |
| S Aug 3, 2016 at 6:37 | history | suggested | nielsgerrits | CC BY-SA 3.0 |
sics / codeblock
|
| Aug 3, 2016 at 6:36 | review | First posts | |||
| Aug 3, 2016 at 6:47 | |||||
| Aug 3, 2016 at 6:36 | review | Suggested edits | |||
| S Aug 3, 2016 at 6:37 | |||||
| Aug 3, 2016 at 6:35 | history | asked | Mozafar Veysipanah | CC BY-SA 3.0 |