by
4,460 13
0
4
2,378
0
Top 1% !
Popular
Famous
Specified
Popularity: 7368th place
This snippet is Public
No tags for this snippet yet.
Languaget-sql

SQL Bounds

Copy Embed Code
<iframe id="embedFrame" style="width:600px; height:300px;"
src="https://www.snip2code.com/Embed/682238/SQL-Bounds?startLine=0"></iframe>
Click on the embed code to copy it into your clipboard Width Height
Leave empty to retrieve all the content Start End
SELECT geometry::EnvelopeAggregate(geometry::STGeomFromWKB(geom.STAsBinary(), 4326).MakeValid()).STPointN(1).STX AS MinX, geometry::EnvelopeAggregate(geometry::STGeomFromWKB(geom.STAsBinary(), 4326).MakeValid()).STPointN(1).STY AS MinY, geometry::EnvelopeAggregate(geometry::STGeomFromWKB(geom.STAsBinary(), 4326).MakeValid()).STPointN(3).STX AS MaxX, geometry::EnvelopeAggregate(geometry::STGeomFromWKB(geom.STAsBinary(), 4326).MakeValid()).STPointN(3).STY AS MaxX FROM FrontierFiber WHERE id = 1;
If you want to be updated about similar snippets, Sign in and follow our Channels

blog comments powered by Disqus