Hello all -<br><br>I'm working on a database with GIS data. In my table, I have columns for latitude, longitude, and coordinates, which is the Postgis geometry data type. What I would like to do is find the midpoint or 'average' for any group of points.
<br><br>I have the latitude and longitude, and then I use this syntax to create the coordinates column value:<br><br>UPDATE table SET coords = geometryfromtext('POINT( longitude latitude )', 4326)<br><br>( 4326 is the projection value that I understand is useful in the United States.
<br><br>So now that I have a bunch of lats, longs, and coordinates, I need to find the center point for any group of them. I can do a select query to get the specific records I'm looking for, and then I can have the list of lat&long points, or the coordinate geometry. How then do I take those rows and create an SQL st
<br><br><br>UPDATE table SET coords = geometryfromtext(' MULTIPOINT( $lat1 $long1, $lat2 $long2, $lat3 $long3)', 4326)<br><br>Can I use the 'coords' geometry object instead?<br><br><br clear="all"><br>--
<br>"Computers are useless. They can only give you answers"<br>-- Pablo Picasso