nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to make unique points for multiple points in mdb

MaddyBrumberg

I have an access mdb that has multiple records that match to single parcels. I would like to create a point for each record that matches to the appropriate parcels. I made the parcels into points and then joined the database but this only got me one point per parcel. Any thought as to how to automate this?

Thanks!

Maddy

Find more posts tagged with

Accepted answers

JakeSkinner

Hi Maddy,

You could calculate the centroid of the parcels:

1. Open the attribute table

2. Add a field of type 'Double'

3. Right-click the field > Calculate Geometry > X Coordinate of Centroid

4. Repeat steps for Y Coordinate of Centroid

Next, join the parcels to the access table. Now, each record of the access table will have the XY coordinates. You can then create a point for each row by right-clicking on the table > Display XY Data.

All comments

JakeSkinner

After joining the parcels to the table, export the table to a new table. You can then add an offset to the coordinates by iterating through each record using python before displaying the XY Event Layer. Below is an example:

import arcpy
from arcpy import env
#set workspace to geodatabase
env.workspace = r"C:\temp\python\test.gdb"

#specify table
table = "Owners_Export"

dict = {}

#iterate through the table and add the Parcel PIN to a dictionary
with arcpy.da.SearchCursor(table, ["PIN", "CentroidX"]) as cursor:
    for row in cursor:
        dict[row[0]] = row[1]

del cursor

#for each PIN, add 0.2 to the X coordinate
for PIN in dict.values():
    x = 0.2
    with arcpy.da.UpdateCursor(table, ["CentroidX"]) as cursor:        
        for row in cursor:                 
            row[0] = row[0] + x
            x += 0.2
            cursor.updateRow(row)

del cursor

MaddyBrumberg

Okay, now I have all of the points but they are all on top of each other. Can you think of a way that I can offset them a bit? I want my field crews to be able to see how many points there are.

Cheers!

Maddy

MaddyBrumberg

Jake-

Thanks! Worked like a charm!

Cheers,

Maddy

JakeSkinner

Hi Maddy,

You could calculate the centroid of the parcels:

1. Open the attribute table

2. Add a field of type 'Double'

3. Right-click the field > Calculate Geometry > X Coordinate of Centroid

4. Repeat steps for Y Coordinate of Centroid

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.