--
-- PostgreSQL database dump
--

-- Dumped from database version 10.5 (Ubuntu 10.5-0ubuntu0.18.04)
-- Dumped by pg_dump version 10.5 (Ubuntu 10.5-0ubuntu0.18.04)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: points; Type: TABLE; Schema: user_data; Owner: pguser
--

CREATE TABLE user_data.points (
    id integer NOT NULL,
    name text,
    description text,
    project text,
    createdby text,
    created timestamp without time zone,
    modifiedby text,
    modified timestamp without time zone,
    type integer,
    geom public.geometry,
    files text,
    elevation numeric(7,2),
    elevation_source text,
    metadata text
);

--
-- Name: points_id_seq; Type: SEQUENCE; Schema: user_data; Owner: pguser
--

CREATE SEQUENCE user_data.points_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

--
-- Name: points_id_seq; Type: SEQUENCE OWNED BY; Schema: user_data; Owner: pguser
--

ALTER SEQUENCE user_data.points_id_seq OWNED BY user_data.points.id;


--
-- Name: points id; Type: DEFAULT; Schema: user_data; Owner: pguser
--

ALTER TABLE ONLY user_data.points ALTER COLUMN id SET DEFAULT nextval('user_data.points_id_seq'::regclass);


--
-- Data for Name: points; Type: TABLE DATA; Schema: user_data; Owner: pguser
--

COPY user_data.points (id, name, description, project, createdby, created, modifiedby, modified, type, geom, files, elevation, elevation_source, metadata) FROM stdin;
177	Xxx		edit_demo	uros	2019-01-06 19:08:05		\N	\N	0104000020110F00000100000001010000001AFBADCD27903741F0F7AB82B29F5641		\N		{"accuracy":0,"alt":null,"source":"manual","id":1}
5	sdf	\N	edit_demo	demo	2017-11-25 20:05:45	\N	\N	0	0104000020110F00000100000001010000004F956F36E1EF64C151195AAAA3BB4D41	\N	\N	\N	\N
6	\N	\N	edit_demo	demo	2017-11-25 20:05:50	\N	\N	0	0104000020110F0000010000000101000000D7F7E1807DAE64C15AAEC88865704D41	\N	\N	\N	\N
7	dsfs	dsfsdf	edit_demo	demo	2017-11-25 20:06:08	\N	\N	5	0104000020110F0000010000000101000000314278B544F264C1326601F43FE04E41	\N	\N	\N	\N
178	Test		edit_demo	uros	2019-01-06 19:17:20		\N	\N	0104000020110F00000100000001010000008D25EC3638EA39415E79C28989335641		\N		{"accuracy":0,"alt":null,"source":"manual","id":1}
179	Xxx		edit_demo	uros	2019-01-09 10:27:35		\N	\N	0104000020110F0000010000000101000000E993243A60EC394168153617A8325641		280.90	Geolocation API	{"accuracy":12.456000328063965,"lat":46.2409146,"lon":15.2615882,"alt":283,"time":1547026050341,"source":"Geolocation API","correction":0,"correction_source":"","antenna":2,"antenna_type":"ARR200","id":1}
180			edit_demo	uros	2019-01-09 18:54:45		\N	\N	0104000020110F000001000000010100000043207DADE1EA394122303E7BBD325641		\N		{"accuracy":8.753000259399414,"lat":46.2414462,"lon":15.2581517,"time":1547056483000,"source":"Geolocation API","id":1}
123	Ygg	\N	edit_demo	iwo	2018-05-02 14:49:16	\N	\N	0	0104000020110F0000010000000101000000182302295AC343417C6DF6D9EA166541	\N	50.27	Geolocation API	{"accuracy":11.109999656677246,"lat":69.9639206,"lon":23.2698542,"alt":78.115,"correction":25.849,"correction_source":"egm2008_2_5","antenna":2,"time":0}
12	test	test	edit_demo	demo	2018-02-01 13:56:39	demo	2018-02-01 13:57:15	0	0104000020110F0000010000000101000000471E88546A641C412336B38DFE505941	\N	\N	\N	\N
124	Ygg	\N	edit_demo	iwo	2018-05-02 14:49:16	\N	\N	0	0104000020110F0000010000000101000000182302295AC343417C6DF6D9EA166541	\N	50.27	Geolocation API	{"accuracy":11.109999656677246,"lat":69.9639206,"lon":23.2698542,"alt":78.115,"correction":25.849,"correction_source":"egm2008_2_5","antenna":2,"time":0}
14	testpoint2	testpoint2	edit_demo	demo	2018-02-01 13:58:24	\N	\N	888	0104000020110F00000100000001010000004A5DB63E7AB31841822B0FD1CA825941	\N	\N	\N	\N
13	testpoint	testpoint	edit_demo	demo	2018-02-01 13:58:09	demo	2018-02-01 13:58:42	777	0104000020110F0000010000000101000000C1CDFB3696C61841538FD9E312825941	\N	\N	\N	\N
15	testpoint	testpoint	edit_demo	demo	2018-02-01 14:36:33	\N	\N	777	0104000020110F00000100000001010000003FE603EE5DEB14415F1E7C1E44765941	\N	\N	\N	\N
16	llll	azen123	edit_demo	demo	2018-02-01 14:36:55	\N	\N	123	0104000020110F00000100000001010000004120C013BF0415417DE62CFD07775941	\N	\N	\N	\N
181	\N	aaaaaaaaaaaaaa	\N	\N	\N	\N	\N	150	0104000020110F0000010000000101000000E01E5F56EDC229414FDDADE43E645741	\N	\N	\N	\N
54	\N	\N	\N	\N	\N	\N	\N	0	0104000020110F00000100000001010000001F6344A708C53641A8DD3D451B4D5A41	\N	\N	\N	\N
75	Iw	G	edit_demo	iwo	2018-04-05 09:46:52	\N	\N	0	0104000020110F0000010000000101000000EC1113F065C343415867C1CDF2166541	["1522914393377-1195569469.jpg"]	\N	\N	\N
77	Iwo2	Pieknie	edit_demo	iwo	2018-04-05 10:59:09	\N	\N	0	0104000020110F00000100000001010000003F8FDD515CC343418B0E325DEA166541	["1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg"]	\N	\N	\N
78	Iwo2	Pieknie	edit_demo	iwo	2018-04-05 10:59:09	\N	\N	0	0104000020110F00000100000001010000003F8FDD515CC343418B0E325DEA166541	["1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg"]	\N	\N	\N
79	Iwo2	Pieknie	edit_demo	iwo	2018-04-05 10:59:09	\N	\N	0	0104000020110F00000100000001010000003F8FDD515CC343418B0E325DEA166541	["1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg"]	\N	\N	\N
80	Iwo2	Pieknie	edit_demo	iwo	2018-04-05 10:59:09	\N	\N	0	0104000020110F00000100000001010000003F8FDD515CC343418B0E325DEA166541	["1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg"]	\N	\N	\N
81	Iwo2	Pieknie	edit_demo	iwo	2018-04-05 10:59:09	\N	\N	0	0104000020110F00000100000001010000003F8FDD515CC343418B0E325DEA166541	["1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg"]	\N	\N	\N
82	Iwo2	Pieknie	edit_demo	iwo	2018-04-05 10:59:09	\N	\N	0	0104000020110F00000100000001010000003F8FDD515CC343418B0E325DEA166541	["1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg","1522918712881252852471.jpg"]	\N	\N	\N
83	Hghg	Ygygyg	edit_demo	iwo	2018-04-05 11:24:54	\N	\N	65	0104000020110F00000100000001010000002DFF3F3D93C34341AF565F03F5166541	\N	\N	\N	\N
84	Ygf	\N	edit_demo	iwo	2018-04-05 11:31:44	\N	\N	0	0104000020110F0000010000000101000000058210798DC3434124393B35EC166541	\N	\N	\N	\N
85	test	\N	edit_demo	iwo	2018-04-07 00:05:58	\N	\N	0	0104000020110F00000100000001010000008769400609C74341258975B4C51A6541	\N	\N	\N	\N
86	test	\N	edit_demo	iwo	2018-04-07 00:05:58	\N	\N	0	0104000020110F00000100000001010000008769400609C74341258975B4C51A6541	\N	\N	\N	\N
76	test	poprava	edit_demo	uros	2018-04-05 09:52:35	\N	\N	0	0104000020110F000001000000010100000090FC1C0C7ACC3341B851AE9649AB5941	\N	\N	\N	\N
121	Iw	\N	edit_demo	iwo	2018-05-02 14:48:57	\N	\N	0	0104000020110F0000010000000101000000FA9728265AC34341641B1FDEEA166541	\N	50.28	Geolocation API	{"accuracy":11.100000381469727,"lat":69.963921,"lon":23.269854,"alt":78.128,"correction":25.849,"correction_source":"egm2008_2_5","antenna":2,"time":0}
122	Iw	\N	edit_demo	iwo	2018-05-02 14:48:57	\N	\N	0	0104000020110F0000010000000101000000FA9728265AC34341641B1FDEEA166541	\N	50.28	Geolocation API	{"accuracy":11.100000381469727,"lat":69.963921,"lon":23.269854,"alt":78.128,"correction":25.849,"correction_source":"egm2008_2_5","antenna":2,"time":0}
125	Ggg	\N	edit_demo	iwo	2018-05-02 14:50:08	\N	\N	0	0104000020110F00000100000001010000002AD862055AC34341641B1FDEEA166541	\N	50.26	Geolocation API	{"accuracy":11.112000465393066,"lat":69.963921,"lon":23.2698517,"alt":78.112,"correction":25.849,"correction_source":"egm2008_2_5","antenna":2,"time":0}
126	Ggg	\N	edit_demo	iwo	2018-05-02 14:50:08	\N	\N	0	0104000020110F00000100000001010000002AD862055AC34341641B1FDEEA166541	\N	50.26	Geolocation API	{"accuracy":11.112000465393066,"lat":69.963921,"lon":23.2698517,"alt":78.112,"correction":25.849,"correction_source":"egm2008_2_5","antenna":2,"time":0}
\.


--
-- Name: points_id_seq; Type: SEQUENCE SET; Schema: user_data; Owner: pguser
--

SELECT pg_catalog.setval('user_data.points_id_seq', 181, true);


--
-- Name: points points_pkey; Type: CONSTRAINT; Schema: user_data; Owner: pguser
--

ALTER TABLE ONLY user_data.points
    ADD CONSTRAINT points_pkey PRIMARY KEY (id);


--
-- Name: user_data_points_geom_idx; Type: INDEX; Schema: user_data; Owner: pguser
--

CREATE INDEX user_data_points_geom_idx ON user_data.points USING gist (geom);


--
-- PostgreSQL database dump complete
--

