..
>
>
> From: Clemens Ladisch
> To: sqlite-users@mailinglists.sqlite.org
> Sent: Thursday, January 3, 2019 10:52 PM
> Subject: Re: [sqlite] sqlite trig/geometry error
>
>
>
> Brent Wood wrote:
>
>> Is there an easy way to
,4326));" | \
sqlite3 -cmd "SELECT load_extension('mod_spatialite');" $DB
Thanks...
From: Clemens Ladisch
To: sqlite-users@mailinglists.sqlite.org
Sent: Thursday, January 3, 2019 10:52 PM
Subject: Re: [sqlite] sqlite trig/geometry error
Brent Wood wrote:
Brent Wood wrote:
> Is there an easy way to tell where the sqlite math functions are coming from?
Are you using the sqlite3 command-line shell, or something else?
Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
th Medcalf
To: SQLite mailing list
Sent: Thursday, January 3, 2019 9:57 AM
Subject: Re: [sqlite] sqlite trig/geometry error
SQLite 3.27.0 2018-12-31 21:43:55
b57c545a384ab5d62becf3164945b32b1e108b2fb4c8dbd939a1706c2079alt2
zlib version 1.2.11
gcc-8.1.0
sqlite> select degrees( radians(175)
m_1_pi = 0.5L / x;
m_2_pi = 1.0L / x;
m_2_sqrtpi = 2.0L / sqrtl(x * 2.0L);
m_deg2rad = x / 90.0L;
m_rad2deg = 90.0L / x;
}
m_e = expl(1.0L);
m_log10e = log10l(expl(1.0L));
m_sqrt2 = sqrtl(2.0L);
m_ln2 = logl(2.0L);
m_ln10 = logl(10.0L);
sqlite> select degrees( radians(175) + atan2( sin(radians(90)) *
sin(0.2/6378.14)*cos(radians(-42)), cos(0.2/6378.14) -
sin(radians(-42))*sin(radians(-42;
264.997582396241
postgres=# select degrees( radians(175) + atan2( sin(radians(90)) *
sin(0.2/6378.14)*cos(radians(-42)),
Hi,
I'm trying to create an SQL in Sqlite3 which returns the X &
Y coords for a point, given origin coordinates in degrees, with distance
and bearing to the new location.
My install of Spatialite (Mint Linux) does not support the Project()
function, and it seems easier to write the SQL
7 matches
Mail list logo