Prebuild dll for windows

[mlcvista]

I don't succed to build the libspatialite-4.3.0a ...

It will be great if there is a possibility to download prebuild version of libspatialite like for the spatialite.exe...

Best regards...

[Jeff McKenna]

You can find spatialite.exe (version 4.4.0-RC0) and all of the
spatialite-tools and necessary dlls, as part of the popular MS4W suite:
http://ms4w.com/features.html

-jeff

--
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/

> --
> You received this message because you are subscribed to the Google
> Groups "SpatiaLite Users" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to spatialite-use...@googlegroups.com
> <mailto:spatialite-use...@googlegroups.com>.
> To post to this group, send email to spatiali...@googlegroups.com
> <mailto:spatiali...@googlegroups.com>.
> Visit this group at https://groups.google.com/group/spatialite-users.
> For more options, visit https://groups.google.com/d/optout.

[mj10777]

On Thursday, 9 February 2017 11:38:47 UTC+1, mlcvista wrote:

I don't succed to build the libspatialite-4.3.0a ...

It will be great if there is a possibility to download prebuild version of libspatialite like for the spatialite.exe...

As always, the latest pre-compiled version sfor Windows can be found here:

http://www.gaia-gis.it/gaia-sins/

Look for :

'MS Windows binaries'

A new version is in the working, see:

https://groups.google.com/forum/#!topic/spatialite-users/DdFiANp4Iyk

Look for:

'current state of the art and 2017 roadmap:'

Mark

 

Best regards...

[mlcvista]

Big thank you to Jeff and mj10777

I 'm will try to use libspatialite for reading WFS file and convert it into dxf...

It's possible to do this with the spatialite.exe ?

I've read it seem to be possible with the DLL libspatialite...

Best Regards,

Michel.

[mj10777]

On Thursday, 9 February 2017 15:55:36 UTC+1, mlcvista wrote:

Big thank you to Jeff and mj10777

I 'm will try to use libspatialite for reading WFS file and convert it into dxf...

 - dxf is autocad is it not?

It's possible to do this with the spatialite.exe ?

Here you should learn to use spatialite (in windows spatialite.exe) as you would sqlite3 (in Windows sqlite2.exe)

- this is mainly intended to create an sqlite3 Database

-- using (mainly) SQL-Commands

If you look at:

http://www.gaia-gis.it/gaia-sins/spatialite-sql-latest.html

you will see a list of spatialite SQL-Commands

- that you cannot use with sqlite3(.exe), but can use with spatialite(.exe)

So you would start by creating a TABLE to contain your WFS file

- adapt this sample to your needs

import.wfs_data.sql :

CREATE TABLE IF NOT EXISTS 'gcp_master'

(

 id_gcp INTEGER ,

 name TEXT DEFAULT '',

 notes TEXT DEFAULT '',

 text TEXT DEFAULT '',

 belongs_to_01 TEXT DEFAULT '',

 belongs_to_02 TEXT DEFAULT '',

 valid_since DATE DEFAULT '0001-01-01',

 valid_until DATE DEFAULT '3000-01-01',

 --> will be set by INSERT and UPDATE TRIGGERs 

 map_x DOUBLE DEFAULT 0,

 --> will be set by INSERT and UPDATE TRIGGERs 

 map_y DOUBLE DEFAULT 0,

 srid INTEGER DEFAULT 3068,

 -- 0=general point 

 -- 1=Known Point 

 -- 20=bridge 

 -- 100-199=street interface type 

 --> 100=general 

 --> 101 = street_start 

 --> 102 = street end 

 --> 109 = nearest point 

 --> 110 = street intersection (street continues) 

 --> 111 = street corner intersection (NW,NE,SE,SW) 

 -- maps: Top/Left Corner of Map, these maps share common points 

 --> 201 = scale 1:1000 (K1) 

 --> 203 = scale 1:4000 (Straube) 

 --> 204 = scale 1:4000 (K4) 

 --> 205 = scale 1:5000 (K5) 

 --> 210 = scale 1:10000 (K10) 

 --> 700 = Historical Points 

 -- 9999=no text/unknown 

 -- 9998=delete 

 gcp_type INTEGER DEFAULT 0,

 -- 0=tpc (Thin Plate Spline) 

 -- 1=1st order(affine) [precise] 

 -- 2nd order [less exact] 

 -- 3rd order [poor] 

 order_selected INTEGER DEFAULT 0,

 gcp_enable INTEGER DEFAULT 1,

 gcp_text TEXT DEFAULT '',

 PRIMARY KEY (id_gcp)

);

The you look up the WFS specfic command in the above link

- such as 'ImportWFS'

SELECT ImportWFS
(  -- filename_or_url Text , layer_name Text , table Text
 'file_name',
 'layer_name'
 'gcp_master'
);

Note: Explicitly setting the environment variable SPATIALITE_SECURITY=relaxed is absolutely required in order to effectively enable this function.

spatialite.exe import_wfs.db < import.wfs_data.sql

When completed correctly (i.e. after the 20th to 30th attempt)

- your data will contained in the spatialite Database

---

The you look up the DXF specific commands

- such as 'ExportDXF'

export.wfs_data.sql :

SELECT ExportDXF
( out_dir String , filename String , sql_queryString , layer_col_name String , geom_col_name String , label_col_name String , text_height_col_name String , text_rotation_col_name String , geom_filter Geometry  

 'dir_name',
 'file_name'
 'sql query',
 -- etc ...
);

Once all of the commands have been prepared, execute the SQL-Command

Note: Explicitly setting the environment variable SPATIALITE_SECURITY=relaxed is absolutely required in order to effectively enable this function.

spatialite.exe import_wfs.db < export.wfs_data.sql

Your DXF data should be found in the given directory.

Have fun ...

Mark

[mlcvista]

Whoa ! BIG THANK YOU MARK ! :)

Plenty of great information in your last post !

This will help me a lot !!!

Big thank you to you !

Best Regards,

Michel.

Le jeudi 9 février 2017 11:38:47 UTC+1, mlcvista a écrit :

[mlcvista]

Hello !

I can use the exe, but there isn't any dll ? In order to not use command line...

Best regards,

Michel.

Le jeudi 9 février 2017 11:38:47 UTC+1, mlcvista a écrit :

[Brad Hards]

Did you look at http://www.gaia-gis.it/gaia-sins/windows-bin-amd64/ and
http://www.gaia-gis.it/gaia-sins/windows-bin-x86/ for the applicable module
you need?

Brad