x27;);" $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:
>
id(makepoint(175.5,-43.5),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/
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
http:
ith 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
{
register LONGDOUBLE_TYPE x;
x = asinl(1.0L);
m_pi_2 = x;
m_pi_4 = x / 2.0L;
m_pi = x * 2.0L;
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
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)), cos(0.2/6378.14
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 requir
7 matches
Mail list logo