MEINMEL
asked on
Interpolate address along line to get x/y
SQL Server 2012, I have a table of street line geometry. I have the line geometry (SELECT @geometry = GEOM FROM STREETS WHERE FID1 = @objID) and I have an address that falls in the address range assigned to this record.
I need to get an approximate x/y (point) of where this address would fall along this line.
Example:
401 FERRY RD
address range is 395 - 415
Thank you!
I need to get an approximate x/y (point) of where this address would fall along this line.
Example:
401 FERRY RD
address range is 395 - 415
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.