--
--



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

CREATE SCHEMA "AD";


ALTER SCHEMA "AD" OWNER TO postgres;

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

CREATE SCHEMA "ENV";


ALTER SCHEMA "ENV" OWNER TO postgres;

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

CREATE SCHEMA "GW";


ALTER SCHEMA "GW" OWNER TO postgres;

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

CREATE SCHEMA "IND";


ALTER SCHEMA "IND" OWNER TO postgres;

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

CREATE SCHEMA "MO";


ALTER SCHEMA "MO" OWNER TO postgres;

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

CREATE SCHEMA "RISK";


ALTER SCHEMA "RISK" OWNER TO postgres;

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

CREATE SCHEMA "SW";


ALTER SCHEMA "SW" OWNER TO postgres;

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

CREATE SCHEMA "UP";


ALTER SCHEMA "UP" OWNER TO postgres;

--
-- Name: postgis; Type: EXTENSION; Schema: -; Owner: -
--

CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;


--
-- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions';




--
-- Name: T_Employee; Type: TABLE; Schema: AD; Owner: postgres
--

CREATE TABLE "AD"."T_Employee" (
    "ID" integer,
    "FName" character varying(20),
    "LName" character varying(20),
    "PhoneA" character varying(50),
    "AdresA" character varying(250),
    "NotesA" character varying(255),
    "ActualID" boolean
);


ALTER TABLE "AD"."T_Employee" OWNER TO postgres;

--
-- Name: T_LogSignIN; Type: TABLE; Schema: AD; Owner: postgres
--

CREATE TABLE "AD"."T_LogSignIN" (
    "ID" integer,
    "UserID" smallint,
    "Amis" timestamp with time zone,
    "IP_Hascen" character varying(50),
    "CompName" character varying(50)
);


ALTER TABLE "AD"."T_LogSignIN" OWNER TO postgres;

--
-- Name: T_Normativ; Type: TABLE; Schema: AD; Owner: postgres
--

CREATE TABLE "AD"."T_Normativ" (
    "ID" integer,
    "Hamar" character varying(20),
    "DateIn" timestamp with time zone,
    "ListPersonsID" integer,
    "TypeID" integer,
    "GorcuneutyanVolort" character varying(200),
    "AdressA" text,
    "StartDate" timestamp with time zone,
    "EndDate" timestamp with time zone,
    "NotesA" character varying(200),
    "MarzID" integer,
    "HamarA" character varying(20)
);


ALTER TABLE "AD"."T_Normativ" OWNER TO postgres;

--
-- Name: T_UserPermission; Type: TABLE; Schema: AD; Owner: postgres
--

CREATE TABLE "AD"."T_UserPermission" (
    "ID" integer,
    "UserID" smallint,
    "PageControlID" smallint,
    "TypeID" smallint,
    "NotesA" character varying(255),
    "ActualID" boolean,
    "ImagePath" character varying(100),
    "ShowHide" boolean,
    "Hert" smallint
);


ALTER TABLE "AD"."T_UserPermission" OWNER TO postgres;

--
-- Name: t_adorga; Type: TABLE; Schema: AD; Owner: postgres
--

CREATE TABLE "AD".t_adorga (
    adorcode character varying(16),
    "ORADCNCODEX" character varying(2),
    adorcodenat integer,
    "ADORSOURCE" character varying(5),
    "ORMUADCNCODEX" character varying(2),
    "ORADMUCODE" character varying(16),
    "ORTUTORADCNCODEX" character varying(2),
    "ORTUTADORCODE" character varying(16),
    "ADTOCODE" integer,
    "ADORCODEX" character varying(50),
    "ADORNAME" character varying(210),
    "ADORNAME2" character varying(210),
    "ADORACRONYM" character varying(50),
    "ADORADRESS1" character varying(38),
    "ADORADRESS2" character varying(38),
    "ADORADRESS3" character varying(38),
    "ADORADRESS4" character varying(38),
    "ADORADRESS5" character varying(38),
    "ADORADRESS6" character varying(38),
    "ADORCP" character varying(5),
    "ADORTEL" character varying(50),
    "ADORFAX" character varying(50),
    "ADOREMAIL" character varying(100),
    "ADORWEBSITE" text,
    "ADORUPWHO" character varying(50),
    "ADORUPDATE" timestamp with time zone,
    "ADORCOMM" text,
    "ADORLOGO" character varying(150)
);


ALTER TABLE "AD".t_adorga OWNER TO postgres;

--
-- Name: t_adreg; Type: TABLE; Schema: AD; Owner: postgres
--

CREATE TABLE "AD".t_adreg (
    geom public.geometry(MultiPolygon,32638),
    adrgcode character varying(100) NOT NULL,
    adrglevel numeric,
    rgadcncode character varying(100),
    rgadrgcode character varying(100),
    adrgname character varying(254),
    adrgname2 character varying(254),
    adrgcodex character varying(100)
);


ALTER TABLE "AD".t_adreg OWNER TO postgres;

--
-- Name: t_hyeaquifer; Type: TABLE; Schema: GW; Owner: postgres
--

CREATE TABLE "GW".t_hyeaquifer (
    geom public.geometry(MultiPolygon,32638),
    hyeaqcode character varying(50) NOT NULL,
    hyeaqcodex character varying(50),
    hyeaqname character varying(32),
    hyeaqname2 character varying(100),
    hyeaqclasscode character varying(10),
    hyeaqdesc character varying(100),
    hyeaqdesc2 character varying(100)
);


ALTER TABLE "GW".t_hyeaquifer OWNER TO postgres;

--
-- Name: t_hyeaquifer_id_seq; Type: SEQUENCE; Schema: GW; Owner: postgres
--

CREATE SEQUENCE "GW".t_hyeaquifer_id_seq
    START WITH 33
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE "GW".t_hyeaquifer_id_seq OWNER TO postgres;

--
-- Name: t_indata; Type: TABLE; Schema: IND; Owner: postgres
--

CREATE TABLE "IND".t_indata (
    "INDACODE" bigint NOT NULL,
    "INADCNCODEX" character varying(2) NOT NULL,
    "INADORCODE" character varying(14),
    "INININCODE" character varying(18) NOT NULL,
    "INDALEVEL" character varying(8),
    "INDAADREGCODE" character varying(20),
    "INDAHYBCODE" character varying(20),
    "INDAHYECODE" character varying(40),
    "INDAVALUE" double precision,
    "INDAYEAR" bigint,
    "INDAMONTH" bigint,
    "INDADAY" bigint,
    "INDADT" timestamp(6) without time zone,
    "INDAYEAREND" bigint,
    "INDAVALUEQLT" character varying(30),
    "INDALABEL" bigint
);


ALTER TABLE "IND".t_indata OWNER TO postgres;

--
-- Name: t_inindic; Type: TABLE; Schema: IND; Owner: postgres
--

CREATE TABLE "IND".t_inindic (
    "ININCODE" character varying(30) NOT NULL,
    "INADORCODE" character varying(14),
    "ININCODEX" character varying(50),
    "ININACRONYM" character varying(50),
    "ININACRONYM2" character varying(50),
    "ININNAME" character varying(120),
    "ININNAME2" character varying(80),
    "ININUNIT" character varying(50),
    "ININUNIT2" character varying(50),
    "ININFORMU" character varying(150),
    "ININDEF" character varying(1000),
    "ININDEF2" character varying(1000),
    "ININCAT1" character varying(50),
    "ININCAT2" character varying(50),
    "ININCAT3" character varying(50),
    "ININCOMM" character varying(1000),
    "ININCOMM2" character varying(1000),
    "ININMIN" double precision,
    "ININMAX" double precision,
    "ININDETLIM" double precision,
    "ININORIGIN" character varying(50),
    "ININORIGIN2" character varying(50),
    "ININUSES" character varying(50),
    "INININTEREST" character varying(50),
    "ININUSED" character varying(100),
    "ININURL" character varying(150),
    "MO_ORVALINK" character varying(50)
);


ALTER TABLE "IND".t_inindic OWNER TO postgres;

--
-- Name: t_inindiclevel; Type: TABLE; Schema: IND; Owner: postgres
--

CREATE TABLE "IND".t_inindiclevel (
    "INLEVELCODE" character varying(8) NOT NULL,
    "INLEVELNAME" character varying(50),
    "INLEVELNAME2" character varying(50),
    "INLEVELCLASS" smallint
);


ALTER TABLE "IND".t_inindiclevel OWNER TO postgres;

--
-- Name: t_hyelake; Type: TABLE; Schema: SW; Owner: postgres
--

CREATE TABLE "SW".t_hyelake (
    geom public.geometry(MultiPolygon,32638),
    hyelcode character varying(40) NOT NULL,
    hyehyeltcode character varying(20),
    hyelcodex character varying(20),
    hyelname character varying(250),
    hyelname2 character varying(250),
    hyeldesc character varying(100),
    hyeldesc2 character varying(100)
);


ALTER TABLE "SW".t_hyelake OWNER TO postgres;

--
-- Name: t_hyentity; Type: TABLE; Schema: SW; Owner: postgres
--

CREATE TABLE "SW".t_hyentity (
    hyecode character varying(40) NOT NULL,
    hyetcode character varying(20),
    hyecodex character varying(20),
    hyename character varying(250),
    hyename2 character varying(250),
    hyedesc character varying(100),
    hyedesc2 character varying(100),
    hyehyetcode character varying(100)
);


ALTER TABLE "SW".t_hyentity OWNER TO postgres;


ALTER TABLE "SW".hyelake_swb3 OWNER TO postgres;

--
-- Name: t_hyeriver; Type: TABLE; Schema: SW; Owner: postgres
--

CREATE TABLE "SW".t_hyeriver (
    geom public.geometry(MultiLineString,32638),
    hyercode character varying(50) NOT NULL,
    hyehyertcode character varying(4),
    hyerdesc character varying(50),
    hyername character varying(300),
    hyercodex character varying(50),
    hyername2 character varying(300),
    hyerdesc2 character varying(50)
);


ALTER TABLE "SW".t_hyeriver OWNER TO postgres;

--
-- Name: hyeriver_swb2; Type: VIEW; Schema: SW; Owner: postgres
--

CREATE VIEW "SW".hyeriver_swb2 AS
 SELECT t_hyeriver.geom,
    t_hyeriver.hyercode,
    t_hyentity.hyecodex,
    t_hyentity.hyename,
    t_hyentity.hyename2,
    t_hyentity.hyedesc2
   FROM ("SW".t_hyentity
     JOIN "SW".t_hyeriver ON (((t_hyentity.hyecode)::text = (t_hyeriver.hyercode)::text)));


ALTER TABLE "SW".hyeriver_swb2 OWNER TO postgres;

--
-- Name: swb_data_new; Type: VIEW; Schema: SW; Owner: postgres
--

CREATE VIEW "SW".swb_data_new AS
 SELECT t_hyentity.hyecode AS hyetcode,
    t_hyeriver.geom,
    t_hyentity.hyetcode AS hyehyetcode,
    t_hyentity.hyecodex,
    t_hyentity.hyename,
    t_hyentity.hyename2,
    t_hyentity.hyedesc,
    t_hyentity.hyedesc2
   FROM "SW".t_hyelake,
    ("SW".t_hyentity
     JOIN "SW".t_hyeriver ON (((t_hyentity.hyecode)::text = (t_hyeriver.hyercode)::text)))
UNION ALL
 SELECT t_hyentity.hyecode AS hyetcode,
    t_hyelake.geom,
    t_hyentity.hyetcode AS hyehyetcode,
    t_hyentity.hyecodex,
    t_hyentity.hyename,
    t_hyentity.hyename2,
    t_hyentity.hyedesc,
    t_hyentity.hyedesc2
   FROM ("SW".t_hyentity
     JOIN "SW".t_hyelake ON (((t_hyentity.hyecode)::text = (t_hyelake.hyelcode)::text)));


ALTER TABLE "SW".swb_data_new OWNER TO postgres;

--
-- Name: swb_status_data_lake; Type: VIEW; Schema: SW; Owner: postgres
--

CREATE VIEW "SW".swb_status_data_lake AS
 SELECT t_hyentity.hyedesc2 AS basin_name,
    t_hyelake.hyelcode AS entity_code,
    t_hyentity.hyename2 AS entity_name,
    t_inindic."ININCAT1",
    t_indata."INININCODE",
    t_inindic."ININNAME2",
    t_indata."INDAVALUE",
    t_indata."INDAYEAR"
   FROM (("SW".t_hyentity
     JOIN "SW".t_hyelake ON (((t_hyentity.hyecode)::text = (t_hyelake.hyelcode)::text)))
     JOIN ("IND".t_indata
     JOIN "IND".t_inindic ON (((t_indata."INININCODE")::text = (t_inindic."ININCODE")::text))) ON (((t_hyentity.hyecode)::text = (t_indata."INDAHYECODE")::text)))
  WHERE (t_indata."INDAVALUE" IS NOT NULL);


ALTER TABLE "SW".swb_status_data_lake OWNER TO postgres;

--
-- Name: swb_status_data_lake_euwi; Type: VIEW; Schema: SW; Owner: postgres
--

CREATE VIEW "SW".swb_status_data_lake_euwi AS
 SELECT t_hyentity.hyedesc2 AS basin_name,
    t_hyelake.hyelcode AS entity_code,
    t_hyentity.hyename2 AS entity_name,
    t_inindic."ININCAT1",
    t_indata."INININCODE",
    t_inindic."ININNAME2",
    t_indata."INDAVALUE",
    t_indata."INDAYEAR"
   FROM (("SW".t_hyentity
     JOIN "SW".t_hyelake ON (((t_hyentity.hyecode)::text = (t_hyelake.hyelcode)::text)))
     JOIN ("IND".t_indata
     JOIN "IND".t_inindic ON (((t_indata."INININCODE")::text = (t_inindic."ININCODE")::text))) ON (((t_hyentity.hyecode)::text = (t_indata."INDAHYECODE")::text)))
  WHERE ((t_indata."INDAVALUE" IS NOT NULL) AND ((t_indata."INININCODE")::text = ANY (ARRAY[('IND_WFD_000003'::character varying)::text, ('IND_WFD_000007'::character varying)::text, ('IND_WFD_000011'::character varying)::text, ('IND_WFD_000012'::character varying)::text])));


ALTER TABLE "SW".swb_status_data_lake_euwi OWNER TO postgres;

--
-- Name: swb_status_data_river; Type: VIEW; Schema: SW; Owner: postgres
--

CREATE VIEW "SW".swb_status_data_river AS
 SELECT t_hyentity.hyedesc2 AS basin_name,
    t_hyeriver.hyercode AS entity_code,
    t_hyentity.hyename2 AS entity_name,
    t_inindic."ININCAT1",
    t_indata."INININCODE",
    t_inindic."ININNAME2",
    t_indata."INDAVALUE",
    t_indata."INDAYEAR"
   FROM (("SW".t_hyentity
     JOIN "SW".t_hyeriver ON (((t_hyentity.hyecode)::text = (t_hyeriver.hyercode)::text)))
     JOIN ("IND".t_indata
     JOIN "IND".t_inindic ON (((t_indata."INININCODE")::text = (t_inindic."ININCODE")::text))) ON (((t_hyentity.hyecode)::text = (t_indata."INDAHYECODE")::text)))
  WHERE (t_indata."INDAVALUE" IS NOT NULL);


ALTER TABLE "SW".swb_status_data_river OWNER TO postgres;

--
-- Name: swb_status_data_river_euwi; Type: VIEW; Schema: SW; Owner: postgres
--

CREATE VIEW "SW".swb_status_data_river_euwi AS
 SELECT t_hyentity.hyedesc2 AS basin_name,
    t_hyeriver.hyercode AS entity_code,
    t_hyentity.hyename2 AS entity_name,
    t_inindic."ININCAT1",
    t_indata."INININCODE",
    t_inindic."ININNAME2",
    t_indata."INDAVALUE",
    t_indata."INDAYEAR"
   FROM (("SW".t_hyentity
     JOIN "SW".t_hyeriver ON (((t_hyentity.hyecode)::text = (t_hyeriver.hyercode)::text)))
     JOIN ("IND".t_indata
     JOIN "IND".t_inindic ON (((t_indata."INININCODE")::text = (t_inindic."ININCODE")::text))) ON (((t_hyentity.hyecode)::text = (t_indata."INDAHYECODE")::text)))
  WHERE ((t_indata."INDAVALUE" IS NOT NULL) AND ((t_indata."INININCODE")::text = ANY (ARRAY[('IND_WFD_000003'::character varying)::text, ('IND_WFD_000007'::character varying)::text, ('IND_WFD_000011'::character varying)::text, ('IND_WFD_000012'::character varying)::text])));


ALTER TABLE "SW".swb_status_data_river_euwi OWNER TO postgres;

--
-- Name: t_hybasin; Type: TABLE; Schema: SW; Owner: postgres
--

CREATE TABLE "SW".t_hybasin (
    geom public.geometry(MultiPolygon,32638),
    hybcode character varying(50) NOT NULL,
    hybhybtcod numeric,
    hyblevel text,
    hybcodex character varying(100),
    hybname character varying(100),
    hybname2 character varying(100),
    hybsurf numeric,
    hybdesc character varying(100),
    hybdesc2 character varying(100)
);


ALTER TABLE "SW".t_hybasin OWNER TO postgres;

--
-- Name: t_hybtype; Type: TABLE; Schema: SW; Owner: postgres
--

CREATE TABLE "SW".t_hybtype (
    hybtcode numeric(100,0),
    hybtname character varying(100),
    hybtname2 character varying(100),
    hybtclass numeric(100,0)
);


ALTER TABLE "SW".t_hybtype OWNER TO postgres;

--
-- Name: T_EnclosedFiles; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_EnclosedFiles" (
    "ID" integer,
    "WaterUseApplicationID" integer,
    "Amsativ" timestamp with time zone,
    "NameA" text,
    "FileName" character varying(100),
    "MutqPul" smallint
);


ALTER TABLE "UP"."T_EnclosedFiles" OWNER TO postgres;

--
-- Name: T_GorcuneutyunTesak; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_GorcuneutyunTesak" (
    "ID" integer,
    "CodeA" character varying(50),
    "NameA" character varying(255)
);


ALTER TABLE "UP"."T_GorcuneutyunTesak" OWNER TO postgres;

--
-- Name: T_HPP; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_HPP" (
    "ID" integer,
    "NameA" character varying(200),
    "TypeID" smallint,
    "ListPersonsID" integer,
    "JtTari" integer,
    "MarzID" integer,
    "ActualID" boolean,
    "WaterUseApplicationID" integer,
    "HosqModel" character varying(150),
    "IPAddress" character varying(50),
    "InAddress" character varying(150)
);


ALTER TABLE "UP"."T_HPP" OWNER TO postgres;

--
-- Name: T_HPP_Licenses; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_HPP_Licenses" (
    "ID" integer,
    "HPPID" integer,
    "StartDate" timestamp with time zone,
    "EndDate" timestamp with time zone,
    "ElEndDate" timestamp with time zone,
    "Jraxbyur" character varying(200),
    "Hzorutyun" double precision,
    "TarekanArt" double precision,
    "TuyltvutyunDate" timestamp with time zone,
    "Hamar" character varying(20),
    "HashvChnshum" double precision,
    "HashvElq" double precision,
    "TypesID" smallint
);


ALTER TABLE "UP"."T_HPP_Licenses" OWNER TO postgres;

--
-- Name: T_HPP_Production; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_HPP_Production" (
    "ID" integer,
    "YearA" smallint,
    "HPPID" integer,
    "Am1" double precision,
    "Am2" double precision,
    "Am3" double precision,
    "Am4" double precision,
    "Am5" double precision,
    "Am6" double precision,
    "Am7" double precision,
    "Am8" double precision,
    "Am9" double precision,
    "Am10" double precision,
    "Am11" double precision,
    "Am12" double precision
);


ALTER TABLE "UP"."T_HPP_Production" OWNER TO postgres;

--
-- Name: T_IravakanTesak; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_IravakanTesak" (
    "ID" integer,
    "Name" character varying(50),
    statcode character varying(60)
);


ALTER TABLE "UP"."T_IravakanTesak" OWNER TO postgres;

--
-- Name: T_Kap; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_Kap" (
    "ID" integer,
    "ParentID" integer,
    "ChildID" integer,
    "TypesID" smallint
);


ALTER TABLE "UP"."T_Kap" OWNER TO postgres;

--
-- Name: T_ListMonth; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_ListMonth" (
    "ID" smallint,
    "Name" character varying(50),
    "NameEn" character varying(50),
    "NameX" character varying(50)
);


ALTER TABLE "UP"."T_ListMonth" OWNER TO postgres;

--
-- Name: T_ListNames; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_ListNames" (
    "ID" integer,
    "ParentID" integer,
    "Name" character varying(250),
    "NameH" character varying(50),
    "TypeOb" smallint,
    "Hert" smallint,
    "Active" smallint
);


ALTER TABLE "UP"."T_ListNames" OWNER TO postgres;

--
-- Name: T_ListPersons; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_ListPersons" (
    "ID" integer,
    "TypeOrganization" smallint,
    "FulName" text,
    "FulName_Manr" text,
    "MarzID" smallint,
    "SettlementID" smallint,
    "AdressA" text,
    "MarzGID" smallint,
    "SettlementGID" smallint,
    "AdressG" text,
    "Phone1" character varying(20),
    "Phone2" character varying(20),
    "Phone" character varying(200),
    "InNum" character varying(50),
    "NotesA" text,
    "ActualID" boolean,
    "IravakanTesakID" integer,
    "RegistrCod" character varying(30),
    "HarkayinCod" character varying(30),
    "GorcuneutyunTesakID" integer,
    "GorcuneutyunTesakLr" text,
    "NuynakanacumCod" character varying(30),
    "TnorenAnun" character varying(50)
);


ALTER TABLE "UP"."T_ListPersons" OWNER TO postgres;

--
-- Name: T_PageControl; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PageControl" (
    "ID" integer,
    "ParentID" smallint,
    "Name" character varying(200),
    "ValueA" character varying(200),
    "Hert" smallint,
    "TypeID" smallint,
    "NotesA" character varying(255),
    "ActualID" boolean,
    "ImagePath" character varying(100),
    "ShowHide" boolean
);


ALTER TABLE "UP"."T_PageControl" OWNER TO postgres;

--
-- Name: T_PastaciAylSparox; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciAylSparox" (
    "ID" integer,
    "WaterUsePermitID" integer,
    "PastaciJrogtID" integer,
    "YearA" integer,
    "ListPersonsID" integer,
    "VorakID" integer,
    "TariMX" double precision,
    "TypeID" smallint
);


ALTER TABLE "UP"."T_PastaciAylSparox" OWNER TO postgres;

--
-- Name: T_PastaciJrogt; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciJrogt" (
    "ID" integer,
    "WaterUseApplicationID" integer,
    "WaterUsePermitID" integer,
    "BMOID" smallint,
    "MarzID" smallint,
    "SettlementID" integer,
    "AdressA" text,
    "NpatakID" smallint,
    "VerStorID" smallint,
    "TypeVerStor" smallint,
    "JrResurs" text,
    "JrResursLracum" text,
    "TariMX" double precision,
    "RegimAmis" double precision,
    "RegimOr" double precision,
    "RegimGam" double precision,
    "TariMXP" double precision,
    "RegimAmisP" double precision,
    "RegimOrP" double precision,
    "RegimGamP" double precision,
    "Korust" double precision,
    "Axtotvac" double precision,
    "Chaporosh" double precision,
    "Mexanikakan" double precision,
    "Fizika" double precision,
    "Kensab" double precision,
    "TypeED" smallint,
    "YearA" smallint
);


ALTER TABLE "UP"."T_PastaciJrogt" OWNER TO postgres;

--
-- Name: T_PastaciJrogt_MatterQuantity; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciJrogt_MatterQuantity" (
    "ID" integer,
    "WaterUsePermitID" integer,
    "PastaciJrogtID" integer,
    "WaterUsePermit_MatterQuantityID" integer,
    "material_ID" smallint,
    "quantity_TSA" double precision,
    "quantity_GMX" double precision,
    "quantity_GMXP" double precision,
    "YearA" integer
);


ALTER TABLE "UP"."T_PastaciJrogt_MatterQuantity" OWNER TO postgres;

--
-- Name: T_PastaciKazmakerputyun; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciKazmakerputyun" (
    "KazmakerputunID" integer,
    "NameKazmakerputun" character varying(255),
    "KadastrID" character varying(255),
    "CodeA" character varying(60)
);


ALTER TABLE "UP"."T_PastaciKazmakerputyun" OWNER TO postgres;

--
-- Name: T_PastaciLracucich; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciLracucich" (
    "ID" integer,
    "ParentID" integer,
    "YearA" integer,
    "PastaciLracucichCucID" integer,
    "TariMX" double precision,
    "ChapmanMiavorID" integer
);


ALTER TABLE "UP"."T_PastaciLracucich" OWNER TO postgres;

--
-- Name: T_PastaciLracucichCuc; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciLracucichCuc" (
    "ID" integer,
    "Name" character varying(250),
    "Kod" integer,
    "ChapmanMiavorID" integer
);


ALTER TABLE "UP"."T_PastaciLracucichCuc" OWNER TO postgres;

--
-- Name: T_PastaciTuning; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_PastaciTuning" (
    "ID" integer,
    "YearA" integer,
    "DateS" timestamp with time zone,
    "DateE" timestamp with time zone
);


ALTER TABLE "UP"."T_PastaciTuning" OWNER TO postgres;

--
-- Name: T_WRMA_Hayt; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_WRMA_Hayt" (
    "HID" integer,
    "DimumHamar" character varying(50),
    "InDate" timestamp with time zone,
    "TypesHayt" smallint,
    "ListPersonsID" integer,
    "NotesA" text,
    "DimumHayt" character varying(50),
    "Past1" smallint,
    "Past2" smallint,
    "Past3" smallint,
    "Past4" smallint,
    "Past5" smallint,
    "Past6" smallint,
    "Past7" smallint,
    "Past8" smallint,
    "Past9" smallint,
    "Past10" smallint,
    "Past11" smallint,
    "Past12" smallint,
    "Past13" smallint,
    "Past14" smallint,
    "Past15" smallint,
    "Past16" smallint,
    "Past17" smallint,
    "PetTurgHamar" character varying(50),
    "PetTurgGumar" double precision,
    "TypesStatus" boolean,
    "VorDate1" timestamp with time zone,
    "VorDate2" timestamp with time zone,
    "VorDate3" timestamp with time zone,
    "VorDate4" timestamp with time zone,
    "VorDate5" timestamp with time zone,
    "VorDate6" timestamp with time zone,
    "VorChk1" smallint,
    "VorChk2" boolean,
    "VorChk4" boolean,
    "VorChk5_1" smallint,
    "VorChk5_2" character varying(50),
    "VorChk6_1" smallint,
    "VorChk6_2" character varying(50),
    "MutqPul" smallint,
    "CreateUser" integer,
    "CreateDate" timestamp with time zone
);


ALTER TABLE "UP"."T_WRMA_Hayt" OWNER TO postgres;

--
-- Name: T_WRMA_Hayt_Child; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_WRMA_Hayt_Child" (
    "ID" integer,
    "ParentID" integer,
    "WaterUseApplicationID" integer,
    "ExtendDate" timestamp with time zone,
    "NotesA" text
);


ALTER TABLE "UP"."T_WRMA_Hayt_Child" OWNER TO postgres;

--
-- Name: T_WaterUseApplication; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_WaterUseApplication" (
    "HID" integer,
    "ListPersonsID" integer,
    "JTHamar" character varying(50),
    "StartDate" timestamp with time zone,
    "EndDate" timestamp with time zone,
    "ExtendDate" timestamp with time zone,
    "NotesA" text,
    "TypesStatus" boolean,
    "VorChk5_1" smallint,
    "VorChk5_2" character varying(50),
    "VorChk6_1" smallint,
    "VorChk6_2" character varying(50),
    "MutqPul" smallint,
    "PermitCode" character varying(50),
    "VorogumHektar" double precision,
    "OldID" integer,
    "PersonsName" text,
    "HaytKap" character varying(50),
    "PersonsNameLracum" character varying(250),
    "Hayt" boolean
);


ALTER TABLE "UP"."T_WaterUseApplication" OWNER TO postgres;

--
-- Name: T_WaterUsePermit; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_WaterUsePermit" (
    "ID" integer,
    "ParentID" integer,
    "BMOID" smallint,
    "MarzID" smallint,
    "SettlementID" integer,
    "AdressA" text,
    "NpatakID" smallint,
    "VerStorID" smallint,
    "TypeVerStor" smallint,
    "JrResurs" text,
    "JrResursCode" character varying(50),
    "JrResursLracum" text,
    "aX" double precision,
    "rX" double precision,
    "vX" double precision,
    "aY" double precision,
    "rY" double precision,
    "vY" double precision,
    "Barcrutyun" double precision,
    "TariMX" double precision,
    "OrMX" double precision,
    "LitrV" double precision,
    "MaxMont" double precision,
    "TypeED" smallint,
    "MutqPul" smallint,
    "GroundwaterStaticID" integer,
    "CodeRiversID" integer,
    "CodeCatchmentsID" integer,
    "OldID" integer,
    "OldParentIP" integer,
    "Servitud" boolean,
    "RegimAmis" double precision,
    "RegimOr" double precision,
    "RegimGam" double precision,
    "UpdateGIS" bytea
);


ALTER TABLE "UP"."T_WaterUsePermit" OWNER TO postgres;

--
-- Name: T_WaterUsePermit_Child; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_WaterUsePermit_Child" (
    "ID" integer,
    "WaterUsePermitID" integer,
    "AmsativM" timestamp with time zone,
    "TariMXM" double precision,
    "OrMXM" double precision,
    "LitrVM" double precision,
    "NotesM" text,
    "ListMonthID" smallint
);


ALTER TABLE "UP"."T_WaterUsePermit_Child" OWNER TO postgres;

--
-- Name: T_WaterUsePermit_MatterQuantity; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP"."T_WaterUsePermit_MatterQuantity" (
    "ID" integer,
    "WaterUsePermitID" integer,
    "material_ID" smallint,
    "quantity_TSA" double precision,
    "quantity_GMX" double precision,
    "NotesN" text,
    "OldID" integer,
    "OldParentID" integer
);


ALTER TABLE "UP"."T_WaterUsePermit_MatterQuantity" OWNER TO postgres;

--
-- Name: t_upis; Type: TABLE; Schema: UP; Owner: postgres
--

CREATE TABLE "UP".t_upis (
    "UPISCODE" character varying(20),
    "ISHYECODE" character varying(20),
    "ISADLOCODE" character varying(20),
    "UPISCODEX" character varying(20),
    "UPISCODEX2" character varying(20),
    "UPISCODEX3" character varying(20),
    "UPISTYPE" integer,
    "UPISNAME" character varying(50),
    "UPISNAME2" character varying(50),
    "ISADR1CODE" character varying(20),
    "ISADR2CODE" character varying(20),
    "ISADR3CODE" character varying(20),
    "ISADR4CODE" character varying(20),
    "ISADR5CODE" character varying(20),
    "UPISPLACE" character varying(50),
    "UPISLOCTYPE" character varying(2),
    "UPISX" double precision,
    "UPISXTXT" character varying(13),
    "UPISY" double precision,
    "UPISYTXT" character varying(13),
    "UPISZ" double precision,
    "UPISYEAR" integer,
    "UPISDEND" timestamp with time zone,
    "UPISDESC" text,
    "UPISCOMMENT" character varying(250),
    "UPISOWNTYPE" integer,
    "UPISOBJ" integer,
    "UPISMAINUSE" integer,
    "UPISMANPROF" integer,
    "UPISOWNER" integer,
    "UPISPROGRAM" integer,
    "UPISFINANCE" integer,
    "UPISUPDATE" timestamp with time zone,
    "UPISUPWHO" character varying(80)
);


ALTER TABLE "UP".t_upis OWNER TO postgres;

--
-- Data for Name: T_Employee; Type: TABLE DATA; Schema: AD; Owner: postgres
--

COPY "AD"."T_Employee" ("ID", "FName", "LName", "PhoneA", "AdresA", "NotesA", "ActualID") FROM stdin;
3	Սևակ	Մաթիլյան			Հայտերի բաժին	f
11	Արփինե 	Դավթյան 			Ջրային ռեսուրսների կադաստրի վարման և մոնիտորինգի բաժնի առաջատար մասնագետ 	f
\.


--
-- Data for Name: T_LogSignIN; Type: TABLE DATA; Schema: AD; Owner: postgres
--

COPY "AD"."T_LogSignIN" ("ID", "UserID", "Amis", "IP_Hascen", "CompName") FROM stdin;
\.


--
-- Data for Name: T_Normativ; Type: TABLE DATA; Schema: AD; Owner: postgres
--

COPY "AD"."T_Normativ" ("ID", "Hamar", "DateIn", "ListPersonsID", "TypeID", "GorcuneutyanVolort", "AdressA", "StartDate", "EndDate", "NotesA", "MarzID", "HamarA") FROM stdin;
5	110/3595-19	2019-05-03 00:00:00+02	3271	\N	Հյուրանոց	գ․ Անտառուտ 1-ին փողոց 8-րդ փակուղի 51 շենք	\N	\N		11	\N
\.


--
-- Data for Name: T_UserPermission; Type: TABLE DATA; Schema: AD; Owner: postgres
--

COPY "AD"."T_UserPermission" ("ID", "UserID", "PageControlID", "TypeID", "NotesA", "ActualID", "ImagePath", "ShowHide", "Hert") FROM stdin;
3	1	3	1	\N	f	images/Desktop/PlanGumar.png	f	3
\.


--
-- Data for Name: t_adorga; Type: TABLE DATA; Schema: AD; Owner: postgres
--

COPY "AD".t_adorga (adorcode, "ORADCNCODEX", adorcodenat, "ADORSOURCE", "ORMUADCNCODEX", "ORADMUCODE", "ORTUTORADCNCODEX", "ORTUTADORCODE", "ADTOCODE", "ADORCODEX", "ADORNAME", "ADORNAME2", "ADORACRONYM", "ADORADRESS1", "ADORADRESS2", "ADORADRESS3", "ADORADRESS4", "ADORADRESS5", "ADORADRESS6", "ADORCP", "ADORTEL", "ADORFAX", "ADOREMAIL", "ADORWEBSITE", "ADORUPWHO", "ADORUPDATE", "ADORCOMM", "ADORLOGO") FROM stdin;
AMORG00000100	AM	651	\N	AM	AMMUN001424	\N	\N	\N	\N	Hydrogeological Monitoring Centre	ГНКО ”Центр гидрогеологического мониторинга”	HMC	Hydrogeological Monitoring Centre	EREVAN	\N	\N	\N	ARMENIE	\N	+374 10 57 62 80	\N	hidroerkraban@mnp.am	http://www.hidroerkraban.am	ZONINO	2016-06-07 00:00:00+02	\N	\N
AMORG00000614	AM	614	DG001	AM	AMMUN000946	\N	\N	24	\N	Northern Basin Management Organisation	Органы управления Северного бассейна	Northern BMO	Northern Basin Management Organisation	EREVAN	\N	\N	\N	ARMENIE	\N	+374 32 22 28 05	\N	levon.mikaelyan@mnp.am	http://www.wrma.am/5_1_1.php	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000617	AM	617	DG001	AM	AMMUN000946	\N	\N	2	\N	Country Water Partnership Armenia	НПО "Национальное Водное Партнерство"	CWP	Country Water Partnership Armenia	Cholakyan Str. Ap. 38	0037 EREVAN	\N	\N	ARMENIE	\N	+374 10 20 96 03	\N	cwp.armenia@gmail.com	http://www.cwp.am/	ZONINO	2018-10-23 00:00:00+02	\N	\N
AMORG00000620	AM	620	DG001	AM	AMMUN000946	\N	\N	16	\N	Hrazdan Basin Management Organisation	Органы управления Разданского бассейна	Hrazdan BMO	Hrazdan Basin Management Organisation	EREVAN	\N	\N	\N	ARMENIE	\N	+374 91 01 80 79	\N	artur.avagyan@mnp.am	http://www.wrma.am/5_1_2.php	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000623	AM	623	DG001	AM	AMMUN000946	AM	AMORG00000623	48	\N	UNIVERSITY AFTER MOVSES KHORENACI	\N	\N	UNIVERSITY AFTER MOVSES KHORENACI	105 Teryan Street	375010 YEREVAN	\N	\N	ARMENIE	\N	\N	\N	\N	\N	MILLIMONO	2006-10-03 00:00:00+02	\N	\N
AMORG00000624	AM	624	DG001	AM	AMMUN000946	\N	\N	1	\N	UNIVERSITY OF PEDAGOLOGY	\N	\N	UNIVERSITY OF PEDAGOLOGY	KH. ABOVYAN	17 Tigran Mets Street	375010 YEREVAN	\N	ARMENIE	\N	\N	\N	\N	\N	MILLIMONO	2006-10-03 00:00:00+02	\N	\N
AMORG00000626	AM	626	DG001	AM	AMMUN000946	\N	\N	14	\N	Ministry of Nature Protection	Министерство охраны природы	MNP	Ministry of Nature Protection	Republic Square - 3rd Government Bldg	0010 YEREVAN	\N	\N	ARMENIE	\N	+374 10 51 61 03	+374 10 58 54 69	iac@mnp.am	http://www.mnp.am	ZONINO	2017-07-03 00:00:00+02	\N	\N
AMORG00000628	AM	628	DG001	AM	AMMUN000946	\N	\N	48	\N	University YEREVAN STATE	\N	YSU	University YEREVAN STATE	Faculty Geography-Geology	1 Alek Manoukian Str - YEREVAN 0025	YEREVAN 0025	\N	ARMENIE	\N	\N	\N	\N	\N	MILLIMONO	2010-08-04 00:00:00+02	\N	\N
AMORG00000629	AM	629	DCI01	AM	AMMUN000946	\N	\N	20	\N	State Health Inspectorate of Ministry of Healthcare	Государственная здравоохранительная инспекция Министерства здравоохранения	SHI	State Health Inspectorate of MOH	Nork-Marash, G. Ovsepiana, Str. 10	37047 YEREVAN	\N	\N	ARMENIE	\N	+374 10 65 03 05	+374 10 589 505	\N	\N	ZONINO	2016-06-07 00:00:00+02	\N	\N
AMORG00000630	AM	630	DCI01	AM	AMMUN000946	\N	\N	64	\N	Scientific Center of Zoology and HydroEcology of the National Academy of Sciences	\N	SCZHE	Scientific Center of Zoology and Hydro	HydroEcology of National Academy Scien	7 - Paruyr Sevak	0014 YEREVAN	\N	ARMENIE	\N	+374 10 20 75 92	\N	\N	http://www.schze.sci.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000631	AM	631	DCIDG	AM	AMMUN000946	\N	\N	69	\N	Armenian Water and Sewerage Company CJSC	ЗАО "Армводоканал"	AWSC	Armenian Water & Sewerage Company	8 A Vardanants Blind Alley	0010 YEREVAN	\N	\N	ARMENIE	\N	+374 60 65 01 71	\N	info@armwater.am	http://www.armwater.am	ZONINO	2016-06-09 00:00:00+02	\N	\N
AMORG00000632	AM	632	DCIDG	AM	AMMUN000946	\N	\N	68	\N	North South Road Corridor Investment Program	\N	\N	NorthSouth Rd Corridor Investment Prog	State Non Commercial Organisation	58 Puskhin Street  -  YEREVAN 0002	\N	\N	ARMENIE	\N	\N	\N	\N	http://www.northsouth.am	ZONINO	2015-11-17 00:00:00+01	\N	\N
AMORG00000633	AM	633	DCIDG	AM	AMMUN000946	\N	\N	14	\N	Ministry of Energy, Infrastructure & Natural Resources	Министерство энергетики и природных ресурсов	MENR	Ministry Energy, Infrastruct. & Nat. R	Natural Resources-Government Bldg 3	YEREVAN 0010	\N	\N	ARMENIE	\N	+374 11 52 19 64	\N	minenergy@minenergy.am	http://www.minenergy.am	ZONINO	2018-03-22 00:00:00+01	\N	\N
AMORG00000640	AM	640	\N	AM	AMMUN001424	\N	\N	57	\N	USAID c/o MEA	\N	USAID	USAID c/o MEA -	CITADEL Business Center	105/1 Teryan Str  - YEREVAN 0009	\N	\N	ARMENIE	\N	\N	\N	\N	\N	ZONINO	2018-10-23 00:00:00+02	Carte de visite PH\r\n Suite 204	\N
AMORG00000641	AM	641	\N	AM	AMMUN001424	\N	\N	77	\N	Water Resources Management Agency	Агентство по управлению водными ресурсами	WRMA	Water Resources Management Agency	Republic Square, Govnt Bldg 3	0010 YEREVAN	\N	\N	ARMENIE	\N	+374 11 81 85 48	\N	vahan.davtyan@mnp.am	http://www.wrma.am	ZONINO	2018-10-23 00:00:00+02	(Ministry of Nature Protection)	\N
AMORG00000642	AM	642	\N	AM	AMMUN001424	\N	\N	\N	\N	State Committee on Water Economy	Государственный Комитет водного хозяйства	SCWE	State Committee on Water Economy	13a Vardanants Street	0010 YEREVAN	\N	\N	ARMENIE	\N	+374 10 54 09 09	+374 10 54 06 13	scws@scws.am	http://www.scws.am	ZONINO	2017-08-11 00:00:00+02	dépend du MINISTRY OF ENERGY INFRASTRUCTURES AND NATURAL RESOURCES	\N
AMORG00000643	AM	643	\N	AM	AMMUN001424	\N	\N	\N	\N	Standing Committee on Economic Affairs	\N	\N	Standing Committee on Economic Affairs	Republic Square, Government Bldg 3	0010 YEREVAN	\N	\N	ARMENIE	\N	\N	\N	\N	\N	ZONINO	2016-06-02 00:00:00+02	\N	\N
AMORG00000647	AM	647	\N	AM	AMMUN001424	\N	\N	\N	\N	Sevan Basin Management Organisation	Органы управления бассейна оз.Севан	Sevan BMO	Sevan Basin Management Organisation	EREVAN	\N	\N	\N	ARMENIE	\N	+374 91 58 33 41	\N	samvel.mkrtchyan@mnp.am	http://www.wrma.am/5_1_3.php	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000648	AM	648	\N	AM	AMMUN001424	\N	\N	\N	\N	Araratyan Basin Management Organisation	Органы управления Араратского бассейна	Araratyan BMO	Araratyan Basin Management Organisatio	EREVAN	\N	\N	\N	ARMENIE	\N	+374 10 22 38 12	\N	petros.shahnazaryan@mnp.am	http://www.wrma.am/5_1_4.php	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000649	AM	649	\N	AM	AMMUN001424	\N	\N	\N	\N	Akhuryan Basin Management Organisation	Органы управления Ахурянского бассейна	Akhuryan BMO	Akhuryan Basin Management Organisation	EREVAN	\N	\N	\N	ARMENIE	\N	+374 31 24 17 45	\N	\N	http://www.wrma.am/5_1_5.php	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000650	AM	650	\N	AM	AMMUN001424	\N	\N	\N	\N	Southern Basin Management Organisation	Органы управления Южного бассейна	Southern BMO	Southern Basin Management Organisation	EREVAN	\N	\N	\N	ARMENIE	\N	+374 28 56 70 71	\N	aram.grigoryan@mnp.am	http://www.wrma.am/5_1_6.php	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000652	AM	652	\N	AM	AMMUN001424	\N	\N	\N	\N	State Environmental Inspectorate	Государственная природоохранная инспекция	SEI	State Environmental Inspectorate	EREVAN	\N	\N	\N	ARMENIE	\N	+374 11 81 85 23	\N	hakob.galstyan@mnp.am	\N	ZONINO	2016-06-07 00:00:00+02	\N	\N
AMORG00000653	AM	653	\N	AM	AMMUN001424	\N	\N	\N	\N	Environmental Monitoring and Information Center - SNCO	ГНКО ”Центр мониторинга воздействия на окружающую среду”	EMIC	Environmental Monitoring & Info Center	Ministry of Nature Protection - SNCO	# 2 Block 46 Charents str.	YEREVAN	\N	ARMENIE	\N	+374 10 27 20 07	\N	info@armmonitoring.am	http://www.armmonitoring.am	ZONINO	2017-01-19 00:00:00+01	\N	\N
AMORG00000654	AM	654	\N	AM	AMMUN001424	\N	\N	\N	\N	Ministry of Agriculture	Министерство сельского хозяйства	MA	Ministry of Agriculture	Republic Square	Government House 3	EREVAN	\N	ARMENIE	\N	+374 55 54 19 68	+374 11 52 46 10	agro@minagro.am	http://www.minagro.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000655	AM	655	\N	AM	AMMUN001424	\N	\N	12	\N	Ministry of Emergency Situations	Министерство по чрезвычайным ситуациям	MES	Ministry of Emergency Situations	109/8 Mikoyan Str, Block of Davitashen	0054 YEREVAN	\N	\N	ARMENIE	\N	+374 10 31 78 43	\N	mes@mes.am	http://www.mes.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000656	AM	656	\N	AM	AMMUN001424	\N	\N	\N	\N	Service of Hydrometeorology and Active Influence on Atmospheric Phenomena	Служба гидрометеорологии и активного воздействия на атмосферные явления	ArmStatHydromet	Hydrometeorological and Monitoring	Service of the MES - SHAIAP	Leoi St. 54 Building	YEREVAN	\N	ARMENIE	\N	+374 10 53 29 52	+374 10 532 952	lvardanyan@meteo.am	http://www.mes.am/hy/meteo-management/	ZONINO	2018-03-22 00:00:00+01	\N	\N
AMORG00000657	AM	657	\N	AM	AMMUN001424	\N	\N	\N	\N	Ministry of Finance	Министерство финансов	MF	Ministry of Finance	Melik Adamyan Str. 1	0010 YEREVAN	\N	\N	ARMENIE	\N	+374 11 80 01 56	+374 11 800 132	secretariat@minfin.am	http://www.minfin.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000658	AM	658	\N	AM	AMMUN001424	\N	\N	\N	\N	Ministry of Healthcare	Министерство здравоохранения	MOH	Ministry of Healthcare	Government Building 3	Republic Square	0010 YEREVAN	\N	ARMENIE	\N	+374 10 54 40 28	+374 10 544 027	info@moh.am	http://www.moh.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000659	AM	659	\N	AM	AMMUN001424	\N	\N	\N	\N	National Center for Disease Control and Prevention	Национальный центр по контролю и профилактике заболеваний	NCDCP	National Center for Disease Control	and Prevention	Davtashen, 2A Building	0010 YEREVAN	\N	ARMENIE	\N	+374 10 34 04 44	\N	\N	\N	ZONINO	2017-11-16 00:00:00+01	State non commercial organisation (of state Health Inspectorate)	\N
AMORG00000660	AM	660	\N	AM	AMMUN001424	\N	\N	12	\N	Ministry of Territorial Administration and Development	Министерство территориального управления и развития	MTA	Ministry of Territorial Administration	and Development	Government House, 3 republic Square	0010 EREVAN	\N	ARMENIE	\N	+374 10 51 13 52	\N	mta@mta.gov.am	http://www.mta.gov.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000661	AM	661	\N	AM	AMMUN001424	\N	\N	\N	\N	State Agency Water Sector Project Implementation Unit of the State Committee of Water System	Государственное учреждение ''Бюро по реализации программ водного хозяйства''	PIU	PIU - Water Sector Project Implementat	Unit Sstate Committee of Water Systems	Abovyan 75/ 44	0033 YEREVAN	\N	ARMENIE	\N	+374 10 27 79 43	+374 10 26 60 58	info@wsdp.am	http://www.piu.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000662	AM	662	\N	AM	AMMUN001424	\N	\N	\N	\N	State Agency "Program Implementation Unit of Rehabilitation of Tunnel"	Государственное учереждение ''Бюро по реализации программ востановлению тоннеля ''Арпа-Севан'' РА	ARPA-SEVAN RA	State Agency "Program Implementation	Unit of Rehabilitation of Tunnel"	YEREVAN	\N	\N	ARMENIE	\N	+374 10 65 11 16	\N	vorotan-arpa-sevan@rambler.ru	\N	ZONINO	2016-06-09 00:00:00+02	\N	\N
AMORG00000663	AM	663	\N	AM	AMMUN001424	\N	\N	\N	\N	Shirak Water and Sewerage CJSC	ЗАО “Ширак-водоканал”	SWS	SHIRAK Water and Sewerage	Dudco 1	GYUMRI 377 523	\N	\N	ARMENIE	\N	+374 31 23 12 78	+374 312 312 78	shirwater@rambler.ru	\N	ZONINO	2016-06-09 00:00:00+02	\N	\N
AMORG00000664	AM	664	\N	AM	AMMUN000946	\N	\N	\N	\N	Lori Water and Sewerage CJSC	ЗАО «Лори водоканал»	LWS	Lori Water and Sewerage Company	Stepanyan 2 A	VANADZOR 377 204	\N	\N	ARMENIE	\N	+374 32 24 82 00	+374 322 482 00	lwsc@mail.ru	\N	ZONINO	2016-06-09 00:00:00+02	\N	\N
AMORG00000665	AM	665	\N	AM	AMMUN001424	\N	\N	\N	\N	Nor Akunq CJSC	ЗАО «Нор Акунк»	NA	Nor Akunq CJSC	0901 Armavir	ABOVYAN 59	\N	\N	ARMENIE	\N	+374 23 72 15 55	+374 02 37 2 89 89	norakunq2002@gmail.com	http://www.norakunq.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000666	AM	666	\N	AM	AMMUN001424	\N	\N	\N	\N	Public Services Regulatory Commisison	Комиссия по регулированию общественных услуг	PSRC	Public Services Regulatory Commission	22 Saryan street	YEREVAN	\N	\N	ARMENIE	\N	+374 10 52 25 22	+374 10 525 563	psrcinfo@psrc.am	http://www.psrc.am	ZONINO	2017-11-16 00:00:00+01	\N	\N
AMORG00000667	AM	667	\N	AM	AMMUN001424	\N	\N	\N	\N	Yerevan Water Users Association	Общество водопользователей "Ереван"	Yerevan WUA	Yerevan Water Users Association	0068 YEREVAN	\N	\N	\N	ARMENIE	\N	+374 10 77 31 04	\N	\N	\N	ZONINO	2016-06-09 00:00:00+02	\N	\N
\.


--
-- Data for Name: t_adreg; Type: TABLE DATA; Schema: AD; Owner: postgres
--

COPY "AD".t_adreg (geom, adrgcode, adrglevel, rgadcncode, rgadrgcode, adrgname, adrgname2, adrgcodex) FROM stdin;
[BLOB]	AM_AD_R2_6	2	AM	Ashtarak	\N	Talin	6
[BLOB]	AM_AD_R1_11	1	AM	\N	\N	Tavush	11
[BLOB]	AM_AD_R1_4	1	AM	\N	\N	Armavir	4
[BLOB]	AM_AD_R1_6	1	AM	\N	\N	Lori	6
[BLOB]	AM_AD_R1_8	1	AM	\N	\N	Shirak	8
[BLOB]	AM_AD_R2_1	2	AM	Yerevan	\N	Yerevan	1
[BLOB]	AM_AD_R1_10	1	AM	\N	\N	Vayots-dzor	10
[BLOB]	AM_AD_R1_3	1	AM	\N	\N	Ararat	3
[BLOB]	AM_AD_R1_5	1	AM	\N	\N	Gegharkunik	5
[BLOB]	AM_AD_R1_9	1	AM	\N	\N	Syunik	9
[BLOB]	AM_AD_R2_3	2	AM	Ashtarak	\N	Aparan	3
[BLOB]	AM_AD_R2_8	2	AM	Ararat	\N	Ararat	8
[BLOB]	AM_AD_R2_9	2	AM	Armavir	\N	Armavir	9
[BLOB]	AM_AD_R2_11	2	AM	Tumanian	\N	Tumanian	11
