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 <[EMAIL PROTECTED]> 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
