--
-- PostgreSQL database dump
--

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

-- Started on 2022-10-25 11:52:38 UTC

CREATE SCHEMA osmnl;
--
-- TOC entry 229 (class 1259 OID 50840)
-- Name: planet_osm_line; Type: TABLE; Schema: osmnl; Owner: osmnl
--

CREATE TABLE osmnl.planet_osm_line (
    osm_id bigint,
    abandoned text,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    attraction text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    castle_type text,
    "CEMT" text,
    "communication:radio" text,
    "communication:bos" text,
    "communication:television" text,
    construction text,
    covered text,
    crop text,
    culvert text,
    cutting text,
    denomination text,
    denotation text,
    direction text,
    disused text,
    embankment text,
    fee text,
    fenced text,
    foot text,
    "generator:source" text,
    harbour text,
    height text,
    highway text,
    hiking text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landcover text,
    landuse text,
    lanes text,
    layer text,
    leisure text,
    leaf_type text,
    lock text,
    man_made text,
    "memorial:type" text,
    military text,
    motorboat text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    orchard text,
    place text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    "region:type" text,
    religion text,
    resource text,
    route text,
    ruins text,
    sac_scale text,
    service text,
    shop text,
    site_type text,
    sport text,
    station text,
    surface text,
    "stream:type" text,
    toll text,
    tourism text,
    "tower:type" text,
    tracktype text,
    trail_visibility text,
    tunnel text,
    via_ferrata_scale text,
    voltage text,
    water text,
    waterway text,
    wetland text,
    width text,
    z_order integer,
    way_area real,
    way public.geometry(LineString,28992),
    gid integer NOT NULL
);


--
-- TOC entry 227 (class 1259 OID 50838)
-- Name: planet_osm_point; Type: TABLE; Schema: osmnl; Owner: osmnl
--

CREATE TABLE osmnl.planet_osm_point (
    osm_id bigint NOT NULL,
    abandoned text,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    attraction text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    capital text,
    castle_type text,
    "CEMT" text,
    "communication:radio" text,
    "communication:bos" text,
    "communication:television" text,
    construction text,
    covered text,
    crop text,
    culvert text,
    cutting text,
    denomination text,
    denotation text,
    direction text,
    disused text,
    ele text,
    embankment text,
    fee text,
    fenced text,
    foot text,
    "generator:source" text,
    harbour text,
    height text,
    highway text,
    hiking text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landcover text,
    landuse text,
    lanes text,
    layer text,
    leisure text,
    leaf_type text,
    lock text,
    man_made text,
    "memorial:type" text,
    military text,
    motorboat text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    orchard text,
    place text,
    poi text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    religion text,
    resource text,
    route text,
    ruins text,
    service text,
    shop text,
    site_type text,
    sport text,
    station text,
    subway text,
    "summit:cross" text,
    surface text,
    "stream:type" text,
    toll text,
    tourism text,
    "tower:type" text,
    train text,
    tunnel text,
    voltage text,
    water text,
    waterway text,
    wetland text,
    width text,
    z_order integer,
    way public.geometry(Point,28992)
);


--
-- TOC entry 228 (class 1259 OID 50839)
-- Name: planet_osm_polygon; Type: TABLE; Schema: osmnl; Owner: osmnl
--

CREATE TABLE osmnl.planet_osm_polygon (
    osm_id bigint,
    abandoned text,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    attraction text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    castle_type text,
    "CEMT" text,
    "communication:radio" text,
    "communication:bos" text,
    "communication:television" text,
    construction text,
    covered text,
    crop text,
    culvert text,
    cutting text,
    denomination text,
    denotation text,
    direction text,
    disused text,
    embankment text,
    fee text,
    fenced text,
    foot text,
    "generator:source" text,
    harbour text,
    height text,
    highway text,
    hiking text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landcover text,
    landuse text,
    lanes text,
    layer text,
    leisure text,
    leaf_type text,
    lock text,
    man_made text,
    "memorial:type" text,
    military text,
    motorboat text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    orchard text,
    place text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    "region:type" text,
    religion text,
    resource text,
    route text,
    ruins text,
    sac_scale text,
    service text,
    shop text,
    site_type text,
    sport text,
    station text,
    surface text,
    "stream:type" text,
    toll text,
    tourism text,
    "tower:type" text,
    tracktype text,
    trail_visibility text,
    tunnel text,
    via_ferrata_scale text,
    voltage text,
    water text,
    waterway text,
    wetland text,
    width text,
    z_order integer,
    way_area real,
    way public.geometry(MultiPolygon,28992),
    gid integer NOT NULL
);


--
-- TOC entry 226 (class 1259 OID 50837)
-- Name: planet_osm_roads; Type: TABLE; Schema: osmnl; Owner: osmnl
--

CREATE TABLE osmnl.planet_osm_roads (
    osm_id bigint,
    abandoned text,
    access text,
    "addr:housename" text,
    "addr:housenumber" text,
    "addr:interpolation" text,
    admin_level text,
    aerialway text,
    aeroway text,
    amenity text,
    area text,
    attraction text,
    barrier text,
    bicycle text,
    brand text,
    bridge text,
    boundary text,
    building text,
    castle_type text,
    "CEMT" text,
    "communication:radio" text,
    "communication:bos" text,
    "communication:television" text,
    construction text,
    covered text,
    crop text,
    culvert text,
    cutting text,
    denomination text,
    denotation text,
    direction text,
    disused text,
    embankment text,
    fee text,
    fenced text,
    foot text,
    "generator:source" text,
    harbour text,
    height text,
    highway text,
    hiking text,
    historic text,
    horse text,
    intermittent text,
    junction text,
    landcover text,
    landuse text,
    lanes text,
    layer text,
    leisure text,
    leaf_type text,
    lock text,
    man_made text,
    "memorial:type" text,
    military text,
    motorboat text,
    motorcar text,
    name text,
    "natural" text,
    office text,
    oneway text,
    operator text,
    orchard text,
    place text,
    population text,
    power text,
    power_source text,
    public_transport text,
    railway text,
    ref text,
    "region:type" text,
    religion text,
    resource text,
    route text,
    ruins text,
    sac_scale text,
    service text,
    shop text,
    site_type text,
    sport text,
    station text,
    surface text,
    "stream:type" text,
    toll text,
    tourism text,
    "tower:type" text,
    tracktype text,
    trail_visibility text,
    tunnel text,
    via_ferrata_scale text,
    voltage text,
    water text,
    waterway text,
    wetland text,
    width text,
    z_order integer,
    way_area real,
    way public.geometry(LineString,28992),
    gid integer NOT NULL
);


-- Completed on 2022-10-25 11:52:39 UTC

--
-- PostgreSQL database dump complete
--

