--
-- PostgreSQL database dump
--

-- Dumped from database version 10.16
-- Dumped by pg_dump version 16.1

-- Started on 2024-03-02 13:13:28 UTC

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 xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 16 (class 2615 OID 20646)
-- Name: latest; Type: SCHEMA; Schema: -;
--

CREATE SCHEMA latest;

SET default_tablespace = '';

--
-- TOC entry 282 (class 1259 OID 27252)
-- Name: kadastralegrens; Type: TABLE; Schema: latest;
--

CREATE TABLE latest.kadastralegrens (
    ogc_fid integer NOT NULL,
    gml_id character varying NOT NULL,
    namespace character varying,
    lokaalid character varying,
    begingeldigheid character varying,
    eindgeldigheid character varying,
    tijdstipregistratie character varying,
    eindregistratie character varying,
    historievolgnummer integer,
    historiestatuscode character varying,
    typegrens integer,
    perceellinkslokaalid character varying,
    perceelrechtslokaalid character varying,
    grenslijn public.geometry(LineString,28992)
);

--
-- TOC entry 281 (class 1259 OID 27250)
-- Name: kadastralegrens_ogc_fid_seq; Type: SEQUENCE; Schema: latest;
--

CREATE SEQUENCE latest.kadastralegrens_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 4758 (class 0 OID 0)
-- Dependencies: 281
-- Name: kadastralegrens_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: latest;
--

ALTER SEQUENCE latest.kadastralegrens_ogc_fid_seq OWNED BY latest.kadastralegrens.ogc_fid;


--
-- TOC entry 290 (class 1259 OID 491804)
-- Name: kwaliteit; Type: TABLE; Schema: latest;
--

CREATE TABLE latest.kwaliteit (
    ogc_fid integer NOT NULL,
    gml_id character varying NOT NULL,
    namespace character varying,
    lokaalid character varying,
    begingeldigheid character varying,
    eindgeldigheid character varying,
    tijdstipregistratie character varying,
    eindregistratie character varying,
    historievolgnummer integer,
    historiestatuscode character varying,
    classificatieelementaanduiding integer,
    classificatiekwaliteitsklasse integer,
    vankadastralegrensnamespace character varying,
    vankadastralegrensid character varying,
    wkb_geometry public.geometry
);


--
-- TOC entry 289 (class 1259 OID 491802)
-- Name: kwaliteit_ogc_fid_seq; Type: SEQUENCE; Schema: latest;
--

CREATE SEQUENCE latest.kwaliteit_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 4759 (class 0 OID 0)
-- Dependencies: 289
-- Name: kwaliteit_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: latest;
--

ALTER SEQUENCE latest.kwaliteit_ogc_fid_seq OWNED BY latest.kwaliteit.ogc_fid;


--
-- TOC entry 288 (class 1259 OID 491792)
-- Name: openbareruimtelabel; Type: TABLE; Schema: latest;
--

CREATE TABLE latest.openbareruimtelabel (
    ogc_fid integer NOT NULL,
    gml_id character varying NOT NULL,
    lv_publicatiedatum character varying,
    relatievehoogteligging integer,
    inonderzoek character varying,
    tijdstipregistratie character varying,
    eindregistratie character varying,
    namespace character varying,
    lokaalid character varying,
    bronhouder character varying,
    bgt_status character varying,
    plus_status character varying,
    identificatiebagopr character varying,
    tekst character varying,
    hoek double precision,
    openbareruimtetype character varying,
    geometrie_punt public.geometry(Point,28992)
);


--
-- TOC entry 287 (class 1259 OID 491790)
-- Name: openbareruimtelabel_ogc_fid_seq; Type: SEQUENCE; Schema: latest;
--

CREATE SEQUENCE latest.openbareruimtelabel_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 4760 (class 0 OID 0)
-- Dependencies: 287
-- Name: openbareruimtelabel_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: latest;
--

ALTER SEQUENCE latest.openbareruimtelabel_ogc_fid_seq OWNED BY latest.openbareruimtelabel.ogc_fid;


--
-- TOC entry 284 (class 1259 OID 491768)
-- Name: pand; Type: TABLE; Schema: latest;
--

CREATE TABLE latest.pand (
    ogc_fid integer NOT NULL,
    gml_id character varying NOT NULL,
    lv_publicatiedatum character varying,
    relatievehoogteligging integer,
    inonderzoek character varying,
    tijdstipregistratie character varying,
    eindregistratie character varying,
    namespace character varying,
    lokaalid character varying,
    bronhouder character varying,
    bgt_status character varying,
    plus_status character varying,
    identificatiebagpnd character varying,
    geometrie_vlak public.geometry(MultiSurface,28992)
);


--
-- TOC entry 286 (class 1259 OID 491780)
-- Name: pand_nummeraanduiding; Type: TABLE; Schema: latest;
--

CREATE TABLE latest.pand_nummeraanduiding (
    ogc_fid integer NOT NULL,
    gml_id character varying NOT NULL,
    namespace character varying,
    lokaalid character varying,
    objectbegintijd character varying,
    objecteindtijd character varying,
    tijdstipregistratie character varying,
    eindregistratie character varying,
    lv_publicatiedatum character varying,
    bronhouder character varying,
    inonderzoek character varying,
    relatievehoogteligging integer,
    bgt_status character varying,
    plus_status character varying,
    identificatiebagpnd character varying,
    nummeraanduidingtekst character varying,
    nummeraanduidinghoek double precision,
    identificatiebagvbolaagstehuisnummer character varying,
    identificatiebagvbohoogstehuisnummer character varying,
    geometrie_nummeraanduiding public.geometry(Point,28992)
);


--
-- TOC entry 285 (class 1259 OID 491778)
-- Name: pand_nummeraanduiding_ogc_fid_seq; Type: SEQUENCE; Schema: latest;
--

CREATE SEQUENCE latest.pand_nummeraanduiding_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 4761 (class 0 OID 0)
-- Dependencies: 285
-- Name: pand_nummeraanduiding_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: latest;
--

ALTER SEQUENCE latest.pand_nummeraanduiding_ogc_fid_seq OWNED BY latest.pand_nummeraanduiding.ogc_fid;


--
-- TOC entry 283 (class 1259 OID 491766)
-- Name: pand_ogc_fid_seq; Type: SEQUENCE; Schema: latest;
--

CREATE SEQUENCE latest.pand_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 4762 (class 0 OID 0)
-- Dependencies: 283
-- Name: pand_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: latest;
--

ALTER SEQUENCE latest.pand_ogc_fid_seq OWNED BY latest.pand.ogc_fid;


--
-- TOC entry 280 (class 1259 OID 20649)
-- Name: perceel; Type: TABLE; Schema: latest;
--

CREATE TABLE latest.perceel (
    ogc_fid integer NOT NULL,
    gml_id character varying NOT NULL,
    namespace character varying,
    lokaalid character varying,
    begingeldigheid character varying,
    eindgeldigheid character varying,
    tijdstipregistratie character varying,
    eindregistratie character varying,
    historievolgnummer integer,
    historiestatuscode character varying,
    akrgemeentecode character varying,
    akrgemeente character varying,
    kadgemeentecode character varying,
    kadgemeente character varying,
    sectie character varying,
    perceelnummer integer,
    oppervlakte double precision,
    perceelnummerrotatie double precision,
    deltax double precision,
    deltay double precision,
    begrenzing public.geometry(Polygon,28992),
    plaatscoordinaten public.geometry(Point,28992)
);


--
-- TOC entry 279 (class 1259 OID 20647)
-- Name: perceel_ogc_fid_seq; Type: SEQUENCE; Schema: latest;
--

CREATE SEQUENCE latest.perceel_ogc_fid_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


--
-- TOC entry 4763 (class 0 OID 0)
-- Dependencies: 279
-- Name: perceel_ogc_fid_seq; Type: SEQUENCE OWNED BY; Schema: latest;
--

ALTER SEQUENCE latest.perceel_ogc_fid_seq OWNED BY latest.perceel.ogc_fid;


--
-- TOC entry 4601 (class 2604 OID 27255)
-- Name: kadastralegrens ogc_fid; Type: DEFAULT; Schema: latest;
--

ALTER TABLE ONLY latest.kadastralegrens ALTER COLUMN ogc_fid SET DEFAULT nextval('latest.kadastralegrens_ogc_fid_seq'::regclass);


--
-- TOC entry 4605 (class 2604 OID 491807)
-- Name: kwaliteit ogc_fid; Type: DEFAULT; Schema: latest;
--

ALTER TABLE ONLY latest.kwaliteit ALTER COLUMN ogc_fid SET DEFAULT nextval('latest.kwaliteit_ogc_fid_seq'::regclass);


--
-- TOC entry 4604 (class 2604 OID 491795)
-- Name: openbareruimtelabel ogc_fid; Type: DEFAULT; Schema: latest;
--

ALTER TABLE ONLY latest.openbareruimtelabel ALTER COLUMN ogc_fid SET DEFAULT nextval('latest.openbareruimtelabel_ogc_fid_seq'::regclass);


--
-- TOC entry 4602 (class 2604 OID 491771)
-- Name: pand ogc_fid; Type: DEFAULT; Schema: latest;
--

ALTER TABLE ONLY latest.pand ALTER COLUMN ogc_fid SET DEFAULT nextval('latest.pand_ogc_fid_seq'::regclass);


--
-- TOC entry 4603 (class 2604 OID 491783)
-- Name: pand_nummeraanduiding ogc_fid; Type: DEFAULT; Schema: latest;
--

ALTER TABLE ONLY latest.pand_nummeraanduiding ALTER COLUMN ogc_fid SET DEFAULT nextval('latest.pand_nummeraanduiding_ogc_fid_seq'::regclass);


--
-- TOC entry 4600 (class 2604 OID 20652)
-- Name: perceel ogc_fid; Type: DEFAULT; Schema: latest;
--

ALTER TABLE ONLY latest.perceel ALTER COLUMN ogc_fid SET DEFAULT nextval('latest.perceel_ogc_fid_seq'::regclass);


--
-- TOC entry 4611 (class 2606 OID 27260)
-- Name: kadastralegrens kadastralegrens_pkey; Type: CONSTRAINT; Schema: latest;
--

ALTER TABLE ONLY latest.kadastralegrens
    ADD CONSTRAINT kadastralegrens_pkey PRIMARY KEY (ogc_fid);


--
-- TOC entry 4623 (class 2606 OID 491812)
-- Name: kwaliteit kwaliteit_pkey; Type: CONSTRAINT; Schema: latest;
--

ALTER TABLE ONLY latest.kwaliteit
    ADD CONSTRAINT kwaliteit_pkey PRIMARY KEY (ogc_fid);


--
-- TOC entry 4621 (class 2606 OID 491800)
-- Name: openbareruimtelabel openbareruimtelabel_pkey; Type: CONSTRAINT; Schema: latest;
--

ALTER TABLE ONLY latest.openbareruimtelabel
    ADD CONSTRAINT openbareruimtelabel_pkey PRIMARY KEY (ogc_fid);


--
-- TOC entry 4618 (class 2606 OID 491788)
-- Name: pand_nummeraanduiding pand_nummeraanduiding_pkey; Type: CONSTRAINT; Schema: latest;
--

ALTER TABLE ONLY latest.pand_nummeraanduiding
    ADD CONSTRAINT pand_nummeraanduiding_pkey PRIMARY KEY (ogc_fid);


--
-- TOC entry 4615 (class 2606 OID 491776)
-- Name: pand pand_pkey; Type: CONSTRAINT; Schema: latest;
--

ALTER TABLE ONLY latest.pand
    ADD CONSTRAINT pand_pkey PRIMARY KEY (ogc_fid);


--
-- TOC entry 4608 (class 2606 OID 20657)
-- Name: perceel perceel_pkey; Type: CONSTRAINT; Schema: latest;
--

ALTER TABLE ONLY latest.perceel
    ADD CONSTRAINT perceel_pkey PRIMARY KEY (ogc_fid);


--
-- TOC entry 4612 (class 1259 OID 27261)
-- Name: kadastralegrens_wkb_geometry_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX kadastralegrens_wkb_geometry_geom_idx ON latest.kadastralegrens USING gist (grenslijn);


--
-- TOC entry 4624 (class 1259 OID 491813)
-- Name: kwaliteit_wkb_geometry_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX kwaliteit_wkb_geometry_geom_idx ON latest.kwaliteit USING gist (wkb_geometry);


--
-- TOC entry 4619 (class 1259 OID 491801)
-- Name: openbareruimtelabel_geometrie_punt_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX openbareruimtelabel_geometrie_punt_geom_idx ON latest.openbareruimtelabel USING gist (geometrie_punt);


--
-- TOC entry 4613 (class 1259 OID 491777)
-- Name: pand_geometrie_vlak_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX pand_geometrie_vlak_geom_idx ON latest.pand USING gist (geometrie_vlak);


--
-- TOC entry 4616 (class 1259 OID 491789)
-- Name: pand_nummeraanduiding_geometrie_nummeraanduiding_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX pand_nummeraanduiding_geometrie_nummeraanduiding_geom_idx ON latest.pand_nummeraanduiding USING gist (geometrie_nummeraanduiding);


--
-- TOC entry 4606 (class 1259 OID 20658)
-- Name: perceel_begrenzing_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX perceel_begrenzing_geom_idx ON latest.perceel USING gist (begrenzing);


--
-- TOC entry 4609 (class 1259 OID 20659)
-- Name: perceel_plaatscoordinaten_geom_idx; Type: INDEX; Schema: latest;
--

CREATE INDEX perceel_plaatscoordinaten_geom_idx ON latest.perceel USING gist (plaatscoordinaten);


-- Completed on 2024-03-02 13:13:28 UTC

--
-- PostgreSQL database dump complete
--

