how to create points based on attribute of another layer?

[MaiTbaileh1]

I have an excel sheets of places ,this sheet has a column of longtitude and latitude,i import this sheet and convert it to feature class (points) using the langtitude and latitude ,some of the records in excel has no lang ,lat ,these records were imported but when i try to zoom to the point nothing appear,how can i update or set the geometery for those record?shall i add points and fill the fields manually??????

[MartinM__Baihaqi]

Adding Excel Lat Long Coordinates into ArcGIS

1. If you have latitude and longitude coordinates, you will have to

prepare these columns in decimal degrees. ...

2. In ArcGIS, right-click the “Layers” data frame in the table of

contents. ...

3. Now, add your excel data to ArcMap (file > add data). ...

4. Right click the table and select display XY data.

https://gisgeography.com/adding-excel-lat-long-coordinates-arcgis/

Pada tanggal Kam, 9 Agt 2018 pukul 16.06 Mai Tbaileh <geonet@esri.com>

menulis:

GeoNet <https://community.esri.com/?et=watches.email.thread>

how to create points based on attribute of another layer?

created by Mai Tbaileh

<https://community.esri.com/people/PalestineStudiesGisEditor?et=watches.email.thread>

in Geoprocessing - View the full discussion

<https://community.esri.com/message/790913-how-to-create-points-based-on-attribute-of-another-layer?et=watches.email.thread>

[MaiTbaileh1]

thank you for reply,but i did what you said exactly ,but my problems for data having no lat or long they were imported to the table but seems without a point just data i want to be able to set geogrpahical position for these records

i mean i have records imported (full data) but seems whithout geometery how to update the geometery?

[CarmelConnolly · Accepted solution]

Hi Mai, 

You can use this tool to create missing geometries for attributes if you know where their location should be: Replacing a feature's geometry with an entirely new shape—Help | ArcGIS Desktop 

Carmel

[MaiTbaileh1]

thank you very much this works with me.

if i want to automatically use the model builder to create these points at the middle of predefined polygon from another layer can i do this???

[CarmelConnolly]

Um potentially! I haven't tried it but if there's probably a way to do it using a Join if there's a common attribute.

Carmel

[MaiTbaileh1]

another question i used ur method to replace geometery but how to select the points having null geometeries ?

[CarmelConnolly]

You can use this tool to find out what features have a Null geometry: Check Geometry—Help | ArcGIS Desktop 

Or you could use Selecting features interactively—Help | ArcGIS for Desktop to select all the spatial features in your map and then in the Attribute Table use the Switching the selected set in a table—Help | ArcGIS Desktop which will switch the selection to all the features that have no geometry.

Carmel