Manually add a new point to PostGIS table

Question

I did accidently delete a table row - or well, in fact a whole subway station.

My attempt to solve the problem was this PostGIS function:

ST_GeomFromText('POINT(coordinates)')

But then PostgreSQL started to complain about some SRID connection with the spatial_ref_sys table. What did I do wrong? Is it possible to add this through QGIS instead?

http://gis.stackexchange.com/questions/24486/how-to-insert-a-point-into-postgis — nickves, Mar 30 '13 at 13:01

score 1 · Accepted Answer · answered Mar 30 '13 at 13:05

1

Try INSERT INTO and use SRID parameter for the geometry

INSERT INTO your_table
col-1-value,...,col-n-value, (SELECT ST_GeomFromText('POINT(coordinates)', SRID))

where SRID is an id of your spatial reference system (4326 for example).

Also it is possible to add needed points using QGIS. Check corresponding section of QGIS manual.

answered Mar 30 '13 at 13:05

SS_Rebelious

5,621
3
27
62

How do I know what SRID to use? – Ivar Mar 30 '13 at 14:35
2

@Ivar, look in geometry_columns table. – SS_Rebelious Mar 30 '13 at 14:41

score 1 · Answer 2 · answered Mar 30 '13 at 13:26

1

Try using

ST_SetSRID(ST_GeomFromText('POINT(coordinates)'),4326)

instead. Replace 4326 with the correct code as necessary.

answered Mar 30 '13 at 13:26

underdark

84,148
21
231
413

Manually add a new point to PostGIS table

2 Answers2

Linked