Some of you might already be aware of SQLite and the wrappers for lisp, SQLiteLsp, for those who are not, here’s the introįirst what is SQLite? I’ll quote from SQLite’s website Now, I’m not in the GIS and spatial data field, but if you are, now you know of a cool new tool. Now if all went as planned, you should have something like this. (setq ptlist (mapcar '(lambda (p) (cons 10 p)) lst)) (entmakex (list (cons 0 "POINT") (cons 10 pt))) "Y(PointN(ExteriorRing(Geometry), %d)) FROM Regions WHERE PK_UID = '%d' " "SELECT X(PointN(ExteriorRing(Geometry), %d)), " (setq res (DSQL_QUERY db "SELECT PK_UID, NumPoints(ExteriorRing(Geometry)) FROM Regions ")) (setq res (DSQL_QUERY db "SELECT X(Geometry), Y(Geometry) from Towns ")) (DSQL_loadext db "C:\\Dev\\Lisp\\Spatialite\\libspatialite-2.dll") Launch Bricscad and appload the SQLiteLsp module ( see SQLite and Lisp part 1) and this lisp. Toss this in your new c:\dev\lisp\spatialite\ folder as well. Now we just need one more item, the sample database get the test-2.3.sqlite sample from here. Get the libspatialite-win-x86-2.4.0.zip and dependencies-win-x86.zip packages, unzip them and throw all the DLL files in the same folder, say c:\dev\lisp\spatialite\ Still with me? ok The first thing you need to do is get the pre-compiled DLLs for windows here,, now as of this writing we are using the latest release candidate version. Now getting things setup is a bit advanced, so feel free to ask if you get stuck. We are going to import this spatial data into Bricscad. What is spatialite? A quote from the SpatiaLite site, the SpatiaLite extension enables SQLite to support spatial data too, in a way conformant to OpenGis specifications. The module is called spatialite and you can get it from here. Yes with SQLite, you can load external modules just like you would a BRX or Lisp routine. Before I get into the individual functions of SQLiteLsp, I want to show off a really cool module I found for SQLite. In my last post, I gave a brief introduction into SQLiteLsp. Highly compatible COM API (Windows only).īricsys is having a great promotion on this shiny new version until November 15, 2010,So be sure to check out the online store. Highly compatible ADS/SDS API (Windows only). Visual Basic for Applications (VBA) (Windows only).įast LISP engine with 450 VLAX functions support. Highly compatible with DWG 2010 file format.įull ACIS (3D solids) modeling (Windows only). I can’t wait to play with the new rendering engine as the screenshots look really amazing! It’s a solid release with a bunch of new goodies ! Here is the feature set (borrowed from the Bricscad website).
0 Comments
Leave a Reply. |