[postgis-users] Trouble inserting coordinate values

[Mike Toews]

Hi Evan,

Try using ST_MakePoint [1] to build a geometry. Furthermore, you may
need to also use ST_SetSRID [2] to establish the SRID for the
geometry.

insert into Customers (Coordinates) value
ST_SetSRID(ST_MakePoint(-89.58124, 44.10570), 4326)

-Mike

[1] http://www.postgis.org/docs/ST_MakePoint.html
[2] http://www.postgis.org/docs/ST_SetSRID.html

On 13 June 2014 09:01, Evan Phillippi <ev_phil at rocketmail.com> wrote:
> Hello,
> My name is Evan.  I am new to postgis and sql and am attempting to build a
> databases to store and query data on soil moisture probes installed on farms
> accross the US.  I have successfully created a table with relevent columns
> including a geometry.  I used select AddGeometryColumn
> ('Customers','Coordinates',4326,'Point',2) create the coordinate column.  I
> am attempting to enter long and lat coordinates of off handwritten notes.
> The syntax I used is insert into Customers (Coordinates) value (-89.58124,
> 44.10570) for the first entry with the following error message insert into
> Customers (Coordinates)
> value (-89.58124, 44.10570)
> ERROR:  syntax error at or near "value"
> LINE 2: value (-89.58124, 44.10570)
> Would certainly appreciate help with this problem.
>
> Thanks,
> Evan Phillippi
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users