AnsweredAssumed Answered

Spatial SQLite database - SQL

Question asked by aline.melo@lmdc.uff.br on Apr 28, 2020

I created a spatial SQLite database using ArcMap and I'm trying include a new point in my table (tbl_furos_coordenadas), by SQL, but I'm not having success with this... My table created below:

 

CREATE TABLE tbl_furos_coordenadas (
OBJECTID integer primary key autoincrement not null,
Shape POINT,
FURO_TX_NO text(254) check(
(typeof(FURO_TX_NO) = 'text' or typeof(FURO_TX_NO) = 'null') and not length(FURO_TX_NO) > 254),
FURO_VL_MC float64 check(
typeof(FURO_VL_MC) = 'real' or typeof(FURO_VL_MC) = 'null'),
FURO_VL_LA float64 check(
typeof(FURO_VL_LA) = 'real' or typeof(FURO_VL_LA) = 'null'),
FURO_VL_PR float64 check(
typeof(FURO_VL_PR) = 'real' or typeof(FURO_VL_PR) = 'null'),
X_SIRGAS float64 check(
typeof(X_SIRGAS) = 'real' or typeof(X_SIRGAS) = 'null'),
Y_SIRGAS float64 check(
typeof(Y_SIRGAS) = 'real' or typeof(Y_SIRGAS) = 'null'),
X_CGS float64 check(
typeof(X_CGS) = 'real' or typeof(X_CGS) = 'null'),
Y_CGS float64 check(
typeof(Y_CGS) = 'real' or typeof(Y_CGS) = 'null')
);


I'm trying to use this SQL for include a new point:

 

INSERT INTO tbl_furos_coordenadas (FURO_TX_NO,Shape)
VALUES('GET-9999',Shape('POINT(-42,614064 -24,986632)',4674));


But the error displayed is: SQL Error [1]: [SQLITE_ERROR] SQL error or missing database (no such function: Shape)

Outcomes