topic Re: SQL to update xy of A to xy of B in ArcGIS Enterprise Questions

SQL to update xy of A to xy of B

katy_wallis — Sat, 08 Nov 2014 06:27:07 GMT

My SQL is rusty and I cant remember how to do this. I have meters that are geocoded to the parcel centroid and I

need the SQL statement to move them to the correspoding XY of the GPSed points.

I know there is a statement that goes something like
Update coordinate x of MeterPoint to x of GPSpoints
where MeterID of MeterPoint = MeterID of GPS points

Can anyone out there help me out Please?

Thanks
Kathy

Re: SQL to update xy of A to xy of B

RobertScheitlin__GISP — Sat, 08 Nov 2014 14:04:35 GMT

Katy,

Sure something like this:

UPDATE MeterPoint

SET [coordinate x] = toX, [Coordinate y] = toY,

WHERE MeterID = MeterIDvalue;

MeterPoint = the table name

[coordinate x] = the column name

MeterID = the column name

Re: SQL to update xy of A to xy of B

katy_wallis — Sun, 09 Nov 2014 04:19:21 GMT

Robert - thank you so much for your quick reply. You save me a lot of time trying to figure this out.