sorting longitude
Sun, 11/09/2008 - 9:10pm
 17 years
|
Several POI files that I am interested in have the coordinates entered unsorted by value. Does anyone know how to sort .the entries in the file by the longitude value while retaining all the original values in the file. I would like to edit our those areas of the country that I will not be using in my travels.
With appreciation,
John
Do you have excel?
Open the poi, select the longitude column and then data>sort , select expand the selection and then sort....
It is terrible to speak well and be wrong. -Sophocles snɥɔnıɥdoɐ aka ʎɹɐƃ
Sorting
If you open the file in POI Edit just click the lat or lon at the top. It will sort top to bottom or vice versa.
Chuck
If you need poi edit
It is terrible to speak well and be wrong. -Sophocles snɥɔnıɥdoɐ aka ʎɹɐƃ
.
Open the poi, select the longitude column and then data>sort , select expand the selection and then sort....
Your statement could lead to database scrambling if not performed correctly.
Maybe better to do this.
Open the csv file in excel
Click on any column a cell
Click data menu tab
Click sort
Sort window appears, select column a, select ascending, select no headers
Click OK
All row info will follow column a cells
The way I suggested does the same thing....
Open the poi, select the longitude column and then data>sort , select expand the selection and then sort....
Your statement could lead to database scrambling if not performed correctly.
Maybe better to do this.
Open the csv file in excel
Click on any column a cell
Click data menu tab
Click sort
Sort window appears, select column a, select ascending, select no headers
Click OK
All row info will follow column a cells
It is terrible to speak well and be wrong. -Sophocles snɥɔnıɥdoɐ aka ʎɹɐƃ
jfw081658 wrote:I would
I would like to edit our those areas of the country that I will not be using in my travels.
I you want POIs for a specific state 'pulled' out of a POI file, http://www.PoiVerifier.com will create a separate file for each selected state.
RT
"Internet: As Yogi Berra would say, "Don't believe 90% of what you read, and verify the other half."