can pls someone give me a example for MSSQL?
I was looking all over the Internet for examples and couldn’t find any. I finally muddled through it and built a tutorial on my company’s website for visualizing geospatial data in PostgreSQL, though much of it will be applicable to other databases. Hopefully that helps. I wish I had it a few months ago!
Hi,
Here is a working example using PostgreSQL:
SELECT
to_date(cast(timestamp as TEXT),‘YYYY-MM-DD’) as time_sec,
value,
latitude,
longitude,
name
FROM locations_new
WHERE id = 1
ORDER BY timestamp ASC
Here is the table:
– Table: public.locations_new
– DROP TABLE public.locations_new;
CREATE TABLE public.locations_new
(
id integer NOT NULL DEFAULT nextval(‘locations_new_id_seq’::regclass),
latitude double precision,
longitude double precision,
name character varying,
value integer,
“timestamp” timestamp without time zone,
CONSTRAINT locations_new_pkey PRIMARY KEY (id)
)
WITH (
OIDS=FALSE
);
ALTER TABLE public.locations_new
OWNER TO postgres;
I hope it helps.
Yes, but needs some editings. See my comment in the feed.