--
--



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

CREATE SCHEMA uatdbhmis;


ALTER SCHEMA uatdbhmis OWNER TO postgres;



--
-- Name: ci_sessions; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.ci_sessions (
    data bytea,
    id character varying,
    ip_address character varying,
    "timestamp" integer
);


ALTER TABLE uatdbhmis.ci_sessions OWNER TO postgres;

--
-- Name: circles; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.circles (
    id integer NOT NULL,
    geom public.geometry(MultiPolygon,4326),
    objectid_1 bigint,
    objectid bigint,
    cir_name character varying(50),
    dist_name character varying(50),
    shape_le_1 double precision,
    shape_le_2 double precision,
    shape_leng double precision,
    shape_le_3 double precision,
    shape_area double precision
);


ALTER TABLE uatdbhmis.circles OWNER TO postgres;

--
-- Name: circles_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

CREATE SEQUENCE uatdbhmis.circles_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE uatdbhmis.circles_id_seq OWNER TO postgres;

--
-- Name: circles_id_seq; Type: SEQUENCE OWNED BY; Schema: uatdbhmis; Owner: postgres
--

ALTER SEQUENCE uatdbhmis.circles_id_seq OWNED BY uatdbhmis.circles.id;


--
-- Name: districts; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.districts (
    id integer NOT NULL,
    geom public.geometry(MultiPolygon,4326),
    shape_leng double precision,
    shape_area double precision,
    desc_ character varying(100),
    dist_name character varying(50),
    agro_clima character varying(50)
);


ALTER TABLE uatdbhmis.districts OWNER TO postgres;

--
-- Name: districts_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

CREATE SEQUENCE uatdbhmis.districts_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE uatdbhmis.districts_id_seq OWNER TO postgres;

--
-- Name: districts_id_seq; Type: SEQUENCE OWNED BY; Schema: uatdbhmis; Owner: postgres
--

ALTER SEQUENCE uatdbhmis.districts_id_seq OWNED BY uatdbhmis.districts.id;


--
-- Name: districts_name; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.districts_name (
    id integer NOT NULL,
    geom public.geometry(MultiPolygon,4326),
    shape_leng double precision,
    shape_area double precision,
    desc_ character varying(100),
    dist_name character varying(50),
    agro_clima character varying(50)
);


ALTER TABLE uatdbhmis.districts_name OWNER TO postgres;

--
-- Name: districts_name_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

CREATE SEQUENCE uatdbhmis.districts_name_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE uatdbhmis.districts_name_id_seq OWNER TO postgres;

--
-- Name: districts_name_id_seq; Type: SEQUENCE OWNED BY; Schema: uatdbhmis; Owner: postgres
--

ALTER SEQUENCE uatdbhmis.districts_name_id_seq OWNED BY uatdbhmis.districts_name.id;


--
-- Name: doctors; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.doctors (
    id integer NOT NULL,
    district integer NOT NULL,
    location character varying NOT NULL,
    doc_category integer NOT NULL,
    doc_name character varying NOT NULL,
    description text,
    status smallint NOT NULL,
    isdeleted smallint DEFAULT 0,
    created_at timestamp without time zone NOT NULL,
    updated_at timestamp without time zone
);


ALTER TABLE uatdbhmis.doctors OWNER TO postgres;

--
-- Name: doctors_categories; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.doctors_categories (
    id integer NOT NULL,
    name character varying NOT NULL
);


ALTER TABLE uatdbhmis.doctors_categories OWNER TO postgres;

--
-- Name: doctors_categories_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

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


--
-- Name: doctors_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

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


--
-- Name: health_family_welfare; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.health_family_welfare (
    id_0 integer NOT NULL,
    geom public.geometry(Point,4326),
    id integer,
    sl__no_ bigint,
    state character varying(254),
    district character varying(254),
    location character varying(254),
    latitude double precision,
    longitude double precision,
    category__ character varying(254),
    doctors_av character varying(254),
    no__of_bed character varying(254),
    building_t character varying(254),
    ambulance character varying(254),
    blood_bank character varying(254),
    emergency character varying(254),
    hiv_centre character varying(254),
    hiv_cent_1 character varying(254),
    laboratory character varying(254),
    labour_roo character varying(254),
    mortuary__ character varying(254),
    operation character varying(254),
    oxygen_fac character varying(254),
    oxygen_pla character varying(254),
    rntpc__tb_ character varying(254),
    immunizati character varying(254),
    x_ray__y_n character varying(254),
    nlep_servi character varying(254),
    covid_faci character varying(254),
    covid_fa_1 character varying(254),
    covid_fa_2 character varying(254),
    mental_hea character varying(254),
    geriatric character varying(254),
    dispensary character varying(254),
    dental_ser character varying(254),
    physiother character varying(254),
    ipd_ward__ character varying(254),
    ipd_ward_1 character varying(254),
    nvbdcp_ser character varying(254),
    ayush_sowa character varying(254),
    mode_of_op character varying(254),
    remarks character varying(254)
);


ALTER TABLE uatdbhmis.health_family_welfare OWNER TO postgres;

--
-- Name: health_family_welfare_id_0_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

CREATE SEQUENCE uatdbhmis.health_family_welfare_id_0_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE uatdbhmis.health_family_welfare_id_0_seq OWNER TO postgres;

--
-- Name: health_family_welfare_id_0_seq; Type: SEQUENCE OWNED BY; Schema: uatdbhmis; Owner: postgres
--

ALTER SEQUENCE uatdbhmis.health_family_welfare_id_0_seq OWNED BY uatdbhmis.health_family_welfare.id_0;


--
-- Name: roads; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.roads (
    id integer NOT NULL,
    geom public.geometry(MultiLineString,4326),
    categories character varying(50),
    type character varying(50),
    status character varying(50),
    code character varying(50),
    ownership character varying(50),
    shape_leng double precision,
    shape_le_1 double precision,
    shape_le_2 double precision
);


ALTER TABLE uatdbhmis.roads OWNER TO postgres;

--
-- Name: roads_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

CREATE SEQUENCE uatdbhmis.roads_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE uatdbhmis.roads_id_seq OWNER TO postgres;

--
-- Name: roads_id_seq; Type: SEQUENCE OWNED BY; Schema: uatdbhmis; Owner: postgres
--

ALTER SEQUENCE uatdbhmis.roads_id_seq OWNED BY uatdbhmis.roads.id;


--
-- Name: settlements; Type: TABLE; Schema: uatdbhmis; Owner: postgres
--

CREATE TABLE uatdbhmis.settlements (
    id integer NOT NULL,
    geom public.geometry(PointZ,4326),
    objectid bigint,
    oid_ bigint,
    name character varying(254),
    folderpath character varying(254),
    symbolid bigint,
    altmode bigint,
    base double precision,
    snippet character varying(254),
    popupinfo character varying(254),
    haslabel bigint,
    labelid bigint
);


ALTER TABLE uatdbhmis.settlements OWNER TO postgres;

--
-- Name: settlements_id_seq; Type: SEQUENCE; Schema: uatdbhmis; Owner: postgres
--

CREATE SEQUENCE uatdbhmis.settlements_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER SEQUENCE uatdbhmis.settlements_id_seq OWNER TO postgres;

--
-- Name: settlements_id_seq; Type: SEQUENCE OWNED BY; Schema: uatdbhmis; Owner: postgres
--

ALTER SEQUENCE uatdbhmis.settlements_id_seq OWNED BY uatdbhmis.settlements.id;


--
-- Name: circles id; Type: DEFAULT; Schema: uatdbhmis; Owner: postgres
--

ALTER TABLE ONLY uatdbhmis.circles ALTER COLUMN id SET DEFAULT nextval('uatdbhmis.circles_id_seq'::regclass);


--
-- Name: districts id; Type: DEFAULT; Schema: uatdbhmis; Owner: postgres
--

ALTER TABLE ONLY uatdbhmis.districts ALTER COLUMN id SET DEFAULT nextval('uatdbhmis.districts_id_seq'::regclass);


--
-- Name: districts_name id; Type: DEFAULT; Schema: uatdbhmis; Owner: postgres
--

ALTER TABLE ONLY uatdbhmis.districts_name ALTER COLUMN id SET DEFAULT nextval('uatdbhmis.districts_name_id_seq'::regclass);


--
-- Name: health_family_welfare id_0; Type: DEFAULT; Schema: uatdbhmis; Owner: postgres
--

ALTER TABLE ONLY uatdbhmis.health_family_welfare ALTER COLUMN id_0 SET DEFAULT nextval('uatdbhmis.health_family_welfare_id_0_seq'::regclass);


--
-- Name: roads id; Type: DEFAULT; Schema: uatdbhmis; Owner: postgres
--

ALTER TABLE ONLY uatdbhmis.roads ALTER COLUMN id SET DEFAULT nextval('uatdbhmis.roads_id_seq'::regclass);


--
-- Name: settlements id; Type: DEFAULT; Schema: uatdbhmis; Owner: postgres
--

ALTER TABLE ONLY uatdbhmis.settlements ALTER COLUMN id SET DEFAULT nextval('uatdbhmis.settlements_id_seq'::regclass);


--
-- Data for Name: ci_sessions; Type: TABLE DATA; Schema: uatdbhmis; Owner: postgres
--

COPY uatdbhmis.ci_sessions (data, id, ip_address, "timestamp") FROM stdin;
\.


--
-- Data for Name: circles; Type: TABLE DATA; Schema: uatdbhmis; Owner: postgres
--

COPY uatdbhmis.circles (id, geom, objectid_1, objectid, cir_name, dist_name, shape_le_1, shape_le_2, shape_leng, shape_le_3, shape_area) FROM stdin;
1	[BLOB]	1	1	New_Seren	Lower Siang District	61095.5043983	61095.5043983	61095.5043983	61095.5043983	114940521.094
2	[BLOB]	2	2	Ruksin	East Siang District	48098.4072802	45322.6995919	45322.6995919	47849.02178	121529136.589
16	[BLOB]	16	16	Yangte	Kra Daadi District	65179.4425569	40695.705704	40695.705704	40695.705704	86341323.1595
17	[BLOB]	17	17	Singa	Upper Siang District	134425.380491	134425.380491	134425.380491	138352.356247	848578941.049
18	[BLOB]	18	18	Ziro	Lower Subansiri District	80977.402762	80977.402762	89326.6632539	89326.6632539	310851411.797
19	[BLOB]	19	19	Lumla	Tawang District	47648.8245345	47648.8245345	47648.8245345	47648.8245345	89896793.8491
3	[BLOB]	3	3	Nari	Lower Siang District	60129.8266523	64100.9998233	64100.9998233	59902.769805	144858551.967
34	[BLOB]	34	34	Payeng	Upper Subansiri District	124002.690647	124002.690647	124002.690647	124002.690647	612286008.766
4	[BLOB]	4	4	Oyan	East Siang District	55204.3937827	66479.0172895	66479.0172895	66479.0172895	156600988.074
5	[BLOB]	5	5	Koyu	Lower Siang District	77668.3097032	78820.8253213	78820.8253213	78820.8253213	271583430.347
6	[BLOB]	6	6	Bilat	East Siang District	90248.1961123	95312.8847256	95312.8847256	95312.8847256	297680257.224
51	[BLOB]	51	51	Mechuka	Shi-Yomi District	133513.354858	133513.354858	133513.354858	133513.354858	789523235.57
52	[BLOB]	52	52	Monigong	Shi-Yomi District	165541.444105	165541.444105	165541.444105	165541.444105	1334967789.34
53	[BLOB]	53	53	Kaying	Siang District	100298.088335	100298.088335	99730.3335018	99730.3335018	259561764.066
7	[BLOB]	7	7	Pasighat	East Siang District	84524.1370419	81533.4522372	81533.4522372	81533.4522372	257262131.974
8	[BLOB]	8	8	Pangin	Siang District	123142.757883	123142.757883	119433.990164	119433.990164	574535453.849
9	[BLOB]	9	9	Mebo	East Siang District	168649.535422	179580.888201	179580.888201	179580.888201	975297245.211
10	[BLOB]	10	10	Payum	Siang District	174530.975619	174530.975619	174530.975619	174530.975619	884549549.437
11	[BLOB]	11	11	Palin	Kra Daadi District	89152.9813372	89152.9813372	89152.9813372	89152.9813372	317754071.528
12	[BLOB]	12	12	Sangram	Kurung Kumey District	77353.4741871	62895.0886126	62895.0886126	62895.0886126	122411633.292
59	[BLOB]	59	59	Dudungkhar	Tawang District	53591.887206	53591.887206	53591.887206	53591.887206	123202134.255
60	[BLOB]	60	60	Zemithang	Tawang District	122990.790504	122990.790504	122990.790504	122990.790504	563943074.823
61	[BLOB]	61	61	Bongkhar	Tawang District	49350.7886872	49350.7886872	49350.7886872	49350.7886872	89878483.1766
62	[BLOB]	62	62	Tawang	Tawang District	91389.54206	84821.60992	84821.60992	84821.60992	197636273.578
