--
--


SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

-- *not* creating schema, since initdb creates it


ALTER SCHEMA public OWNER TO postgres;



--
-- Name: data_real; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.data_real (
    srl text,
    botanical_name text,
    local_name text,
    girth_in_cm text,
    height_in_mtr text,
    canopy_diameter text,
    condition text,
    remarks text,
    latitude text,
    longitude text,
    tree_age text,
    tree_no text
);


ALTER TABLE public.data_real OWNER TO postgres;

--
-- Name: products; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.products (
    id integer NOT NULL,
    name character varying(150) NOT NULL,
    sku character varying(100) NOT NULL,
    description text,
    created_at timestamp without time zone DEFAULT CURRENT_TIMESTAMP
);


ALTER TABLE public.products OWNER TO postgres;

--
-- Name: products_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.products ALTER COLUMN id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME public.products_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Data for Name: data_real; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.data_real (srl, botanical_name, local_name, girth_in_cm, height_in_mtr, canopy_diameter, condition, remarks, latitude, longitude, tree_age, tree_no) FROM stdin;
1	Sabal minor (Jacq.) Pers.	Sabal Palm	124	13	3	Healthy	NA	18.97735318	72.83837638	73	1429
2	Elaeis guineensis Jacq.	Oil Palm	70	4	6	Healthy	NA	18.97776153	72.83686559	78	855
3	Amherstia nobilis Wall.	Urvashi	56	6	3	Healthy	NA	18.97827496	72.83806966	50	1642
4	Cassia fistula Linn. var.white	Bahava (W)	60	6	4	Healthy	NA	18.9789137	72.83633044	55	1934
5	Amherstia nobilis Wall.	Urvashi	72	10	7	Healthy	NA	18.97967523	72.83851185	62	3330
6	Brownea grandiceps Jacq.	Brownea (G)	75	8	6	Healthy	NA	18.9799987	72.83840089	112	3306
7	Anogeissus pendula Edgew.	Kardhai	67	12	6	Healthy	NA	18.97727845	72.83663359	65	808
8	Cassia fistula Linn. var.white	Bahava (W)	158	10	7	Healthy	NA	18.97892829	72.83702266	55	1992
9	Corypha umbraculifera Linn.	Tolipot Palm	213	18	9	Healthy	NA	18.9781763	72.83622392	78	653
10	Madhuca longifolia (Koenig) MacBr	Moha (L)	172	13	9	Healthy	NA	18.98004227	72.83613885	62	2721
11	Guaiacum officinale Linn.	Indian Box Tree	52	6	5	Healthy	NA	18.97899252	72.83534351	52	2325
12	Cassia renigera Benth.	The Burmese Pink Cassia	232	12	9	Healthy	NA	18.97924971	72.83686915	82	2890
13	Strychnos nux-vomica Linn.	Kajra	84	14	9	Healthy	NA	18.98017147	72.83721626	52	2981
14	Attalea speciosa Mart.	Babassu Palm	147	14	7	Healthy	NA	18.97905667	72.83828247	88	1674
15	Guaiacum officinale Linn.	Indian Box Tree	58	6	5	Healthy	NA	18.97795277	72.83858814	52	1699
16	Hydnocarpus pentandrus (Buch.-Ham.) Oken.	Kadu-Kavath	238	13	10	Healthy	NA	18.98010293	72.83627745	65	2739
17	Guaiacum officinale Linn.	Indian Box Tree	63	7	5	Healthy	NA	18.97896784	72.83589476	65	2382
18	Guaiacum officinale Linn.	Indian Box Tree	66	8	5	Healthy	NA	18.97901803	72.8357264	65	2372
19	Guaiacum officinale Linn.	Indian Box Tree	67	8	5	Healthy	NA	18.97898832	72.83582769	65	2378
20	Pterocarpus indicus Willd.	Paduk	144	10	6	Healthy	NA	18.97945399	72.83589872	112	2685
21	Guaiacum officinale Linn.	Indian Box Tree	73	10	6	Healthy	NA	18.98000362	72.83839662	68	3305
22	Caesalpinia ferrea C.Mart.	Brazilian Ironwood Tree	132	11	8	Healthy	NA	18.97840094	72.83446197	88	113
23	Guaiacum officinale Linn.	Indian Box Tree	76	11	7	Healthy	NA	18.98017395	72.83863305	68	3361
24	Garcinia livingstonei T.Anderson	African Mangosteen	100	12	8	Healthy	NA	18.97950946	72.83542448	55	2354
25	Brownea coccinea Jacq.	Lal Zumber	63	8	6	Healthy	NA	18.97988173	72.83766467	112	3037
26	Garcinia livingstonei T.Anderson	African Mangosteen	105	7	5	Healthy	NA	18.97977627	72.83532583	78	2585
27	Guaiacum officinale Linn.	Indian Box Tree	84	8	5	Healthy	NA	18.97894914	72.83595787	70	2386
28	Cedrela toona Roxb.	Mahaneem	221	22	16	Healthy	NA	18.97987969	72.83765152	80	3035
29	Enterolobium cyclocarpum (Jacq.) Griseb.	Elephant Ear Tree	291	11	9	Healthy	NA	18.97897016	72.83716067	80	2914
30	Guaiacum officinale Linn.	Indian Box Tree	89	8	5	Healthy	NA	18.97893436	72.83512762	70	2315
31	Brownea coccinea Jacq.	Lal Zumber	73	6	8	Healthy	NA	18.9785795	72.83511837	110	245
32	Guaiacum officinale Linn.	Indian Box Tree	95	9	8	Healthy	NA	18.97838485	72.83499764	75	224
33	Enterolobium cyclocarpum (Jacq.) Griseb.	Elephant Ear Tree	320	15	18	Healthy	NA	18.97797527	72.8363788	85	718
34	Guaiacum officinale Linn.	Indian Box Tree	100	8	7	Healthy	NA	18.97889757	72.8361228	76	2404
35	Guaiacum officinale Linn.	Indian Box Tree	102	10	7	Healthy	NA	18.97882975	72.83618478	76	2202
36	Enterolobium cyclocarpum (Jacq.) Griseb.	Elephant Ear Tree	352	15	10	Healthy	NA	18.97700639	72.83805827	68	1372
37	Guaiacum officinale Linn.	Indian Box Tree	110	10	5	Healthy	NA	18.97778753	72.83673552	78	831
38	Enterolobium cyclocarpum (Jacq.) Griseb.	Elephant Ear Tree	373	16	12	Healthy	Mechanical Cut	18.97798312	72.83807332	68	1644
39	Guaiacum officinale Linn.	Indian Box Tree	118	10	8	Healthy	NA	18.97890128	72.83593613	80	2189
40	Guaiacum officinale Linn.	Indian Box Tree	120	10	8	Healthy	NA	18.97888468	72.83601066	80	2195
41	Strychnos nux-vomica Linn.	Kajra	180	18	10	Healthy	NA	18.97695809	72.83708478	72	1218
42	Guaiacum officinale Linn.	Indian Box Tree	127	8	6	Healthy	NA	18.97894851	72.83575123	72	2174
43	Guaiacum officinale Linn.	Indian Box Tree	127	10	9	Healthy	NA	18.97885826	72.83611662	72	2199
44	Castanospermum australe A.Cunn. & Fraser	Australian Chestnut Tree	203	22	16	Healthy	NA	18.97865796	72.8358831	68	2187
45	Brownea coccinea Jacq.	Lal Zumber	102	10	5	Healthy	Mechanical Cut	18.97825627	72.83770495	115	1807
46	Guaiacum officinale Linn.	Indian Box Tree	135	8	8	Healthy	NA	18.97894954	72.8357118	75	2171
47	Guaiacum officinale Linn.	Indian Box Tree	135	10	8	Healthy	NA	18.97891866	72.83586549	75	2186
48	Guaiacum officinale Linn.	Indian Box Tree	135	10	8	Healthy	NA	18.97886913	72.83608146	75	2198
49	Pterocarpus indicus Willd.	Paduk	302	15	13	Healthy	NA	18.97857473	72.83872643	115	1738
50	Guaiacum officinale Linn.	Indian Box Tree	145	10	8	Healthy	NA	18.9789376	72.83580568	80	2182
51	Diospyros discolor Willd.	Villayati Gaub	180	13	7	Healthy	NA	18.97980314	72.83659464	55	2806
52	Pterocarpus indicus Willd.	Paduk	329	20	18	Healthy	NA	18.97894453	72.83622149	128	2409
53	Brownea coccinea Jacq.	Lal Zumber	124	6	8	Healthy	NA	18.9787705	72.83615947	116	2201
54	Adansonia digitata Linn.	Gorakh Chinch	552	15	12	Healthy	NA	18.9792466	72.83566128	135	2365
55	Melaleuca leucadendra L.	Cajuput Tree	425	15	7	Healthy	NA	18.9784862	72.83611379	65	2046
56	Melaleuca leucadendra L.	Cajuput Tree	464	13	7	Healthy	NA	18.97876496	72.83631297	68	2054
57	Melaleuca leucadendra L.	Cajuput Tree	466	21	16	Healthy	NA	18.97868901	72.83568243	72	2165
\.


--
-- Data for Name: products; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.products (id, name, sku, description, created_at) FROM stdin;
1	Neem Tree	TR-001	Healthy roadside neem tree	2026-04-06 16:07:15.391666
2	Banyan Tree	TR-002	Old banyan near school campus	2026-04-06 16:07:15.391666
3	Peepal Tree	TR-003	Peepal tree at ward office	2026-04-06 16:07:15.391666
\.


--
-- Name: products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('public.products_id_seq', 3, true);


--
-- Name: products products_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_pkey PRIMARY KEY (id);


--
-- Name: products products_sku_key; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.products
    ADD CONSTRAINT products_sku_key UNIQUE (sku);


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE USAGE ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
--

