Hi,<br><br>Here is the way you can find lat-long values from shp files. The method is ugly.<br>I used this method to select lat-long values from a shape file consisting of about 150 records. Using this method all lat-long values from a shapefile consisting of place names of country can be
selected and saved into files.<br>I already told method is dirty.<br><br>You can find using postgreSQL. first you should install postgis-postgresql package.<br>and follow instructions in postgis manual. <br>you want to import some files after installing postgis such as lwpostgis.sql etc...<br>
<br>I think you added necessary attributes in shape files such as name of place etc,..<br><br>create a database in postgresql with postgis enabled (say db1)<br>Now import .shp files into postgresql using cmd:<br><br>you should have a database db1 with postgis support.<br>
shp2pgsql /root/vect1.shp vect1 db1 > /root/vect1.sql <br>
<br>now you got vect1.sql file<br><br>import sql file into postgresql.<br>psql -d db1 -f /root/vect1.sql<br><br>Now logon to postgresql admin tool such as phppgadmin or you can do these thing from postgresql interactive terminal.<br>
<br>In the database db1 now you have another table name vect1.<br>vect1 has some other attributes such as gid,the_geom etc.. other than attributes you have entered. 'the_geom' is the geometry of shape file.<br>
<br>select X(the_geom) from vect1; query executes to display longitude all entries in shape files <br><br>and<br><br>select Y(the_geom) from vect1; query executes to display latitude all entries in shape files<br><br><br>
this data can also be inserted into table by inserting a new column for latitude and longitude.<br>
<br>If you want table back to shp files using the cmd:<br>pgsql2shp -f vect1 -p 5432 db1 vect1<br clear="all"><br>Or <br><br>You can also export column latitude and longtiude into mysql also as you wish<br><br><br>-- <br>
Regards,<br>Mohammed Rashad K.M<br><a href="http://keralainfo.web4all.in/" target="_blank">http://keralainfo.web4all.in/</a><br>
+919605476742<br>