[postgis-users] Extract data with Lat Long

[MarkW]

To get lat/lons out, try (changing the srid as needed)

SELECT  AsText(ST_Transform(the_geom,4269))
FROM schema.tablename

is this a one-time or occasional deal? Could you use the MS query
feature of Excel to connect via ODBC and bring data into Excel?

Mark

On Thu, Oct 9, 2008 at 2:58 PM, Andre Schoonbee <andresch at iway.na> wrote:
> I have imported shapefiles (POI information) into my Postgis database. It
> works 100%. Now, I would like to export that same data as CSV, but at the
> same time get a LAT, LONG coordinate for each POI. Help would be
> appreciated!
>
> Secondly, How do I import CSV file with LAT LONG into Postgis and
> automatically populate the_geom field?
>
> Andre
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>