I cant help with a C abstraction, of course there will be such a thing, but a single query to get both lat and long of a point is:
SELECT ST_X(the_geom), ST_Y(the_geom) FROM mypoints -- or SELECT ST_ASTEXT(the_geom) FROM mypoints -- and parse the returned "POINT(long lat)" P. SixDegrees wrote:
I'm quite new to GIS in general and PostGIS/Postgres in particular. I have to write a C/C++ routine to dredge values out of an existing PostGIS-enabled database. For the most part, this seems straightforward, but I can't figure out how to access the members of types stored as points. I'm aware of the ST_X() and ST_Y() SQL functions, but it using these seems to require two queries. Is it possible to extract the point type into a C/C++ struct/class with one call to the DB and process the results, or do I have to make two calls for each point? I can't seem to find a PostGIS API; does such a thing exist? A short example would be much appreciated, if possible. Thank you.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
