Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT dbo.Segment.ROADJUR, dbo.Segment.L_F_ADD, dbo.Segment.L_T_ADD, dbo.Segment.R_F_ADD, dbo.Segment.R_T_ADD, dbo.Segment.Geometry, (SELECT LTRIM(RTRIM(UPPER(ISNULL(dbo.Street.Prefix_Full, '')))) + ' ' + (RTRIM(UPPER(ISNULL(dbo.Street.Street_Name, '')))) + ' ' + (RTRIM (UPPER(ISNULL(dbo.Street.Suffix_Cnty, '')))) + '' + (RTRIM (UPPER(ISNULL(dbo.Street.Suffix_Bell, '')))) + ' ' + (RTRIM (UPPER(ISNULL(dbo.Street.Suffix_Direction, ''))))) AS Name, (SELECT Ward_Name FROM dbo.Ward AS W WHERE (Ward_ID = dbo.Segment.Left_Mun_ID)) AS L_MUNAME, (SELECT Ward_Name FROM dbo.Ward AS W WHERE (Ward_ID = dbo.Segment.Right_Mun_ID)) AS R_MUNAME, CASE WHEN dbo.Segment.ROADJUR = 'KINGS' THEN 9 WHEN dbo.Segment.ROADJUR = 'CNTY' THEN 15 WHEN dbo.Segment.ROADJUR = 'TWP' THEN 16 WHEN dbo.Segment.ROADJUR = 'PRIV' THEN 17 END AS LEVEL FROM dbo.Segment INNER JOIN dbo.Ward ON dbo.Segment.Left_Mun_ID = dbo.Ward.Ward_ID AND dbo.Segment.Right_Mun_ID = dbo.Ward.Ward_ID, dbo.Street ON dbo.Segment.Street_ID = dbo.Street.Street_ID
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.