[Manifold-l] Box and Image

Simon Greener (SpatialDB Advisor) spatialdbadvisor at netspace.net.au
Thu Nov 9 16:36:35 CST 2006


Atelier,

Additional note:

If your image and target drawing have two different projections you  
can/should
do this with your SQL (My test image is called "SpatialDBAdvisor":

insert into mydrawing ([Geom (I)])
select Project(
          AssignCoordSys(
            CGeom(CGeomWKB("POLYGON(("&min([Easting (I)])&" "&min([Northing  
(I)])&", "&min([Easting (I)])&" "&max([Northing (I)])&", "&max([Easting  
(I)])&" "&max([Northing (I)])&", "&max([Easting (I)])&" "&min([Northing  
(I)])&", "&min([Easting (I)])&" "&min([Northing (I)])&"))")),
            CoordSys("SpatialDBAdvisor" AS Component)),
            CoordSys("MyDrawing" As Component))
 from [SpatialDBAdvisor]

S
On Fri, 10 Nov 2006 00:42:58 +1100, Atelier CASSINI  
<contact at atelier-cassini.com> wrote:

> Hello,
> i would like to create a box drawing around an image. Do i need to know  
> the exact dimension of that image or can i drawit automaticaly ?
> Thank you (Manifold 6.5)
>
>
> _______________________________________________
> Manifold-l mailing list
> Manifold-l at lists.directionsmag.com
> http://www.directionsmag.com/mailman/listinfo/manifold-l



-- 
--------------------------------------------------
SpatialDB Advice and Solutions Architecture,
Oracle Spatial, ArcSDE, Manifold GIS, Radius Topology and Studio  
Specialist.
Allens Rivulet, Tasmania, Australia.
www.spatialdbadvisor.com
   Email: simon at spatialdbadvisor.com
   Voice: +61 362 396397
Mobile: +61 418 396391
Longitude: 147.20515
Latitude: -43.01530
NAC: W80CK 7SWP3


More information about the Manifold-l mailing list