i'm trying to create a shapefile from an excel spreadsheet. the spreadsheet contains some data such as "unknown record" for which no lat/long can be obtained while the rest of the data is related to states of a country.when i add spreadsheet to arcgis it displays "null" value under lat long field in front of unknown record and when i create the shapefile the null values are replaced by "0" which causes an inconsistent map extent. i don't want to create a csv as it distorts my rest of the data. i tried placing "0" for the unknown record in lat long fields but in that case lat long wont show in add xy dialog box.please suggest a workaround so that my problem of inconsistent map extent is resolved.
أكثر...
أكثر...