--
-- PostgreSQL database dump
--

-- Dumped from database version 10.7
-- Dumped by pg_dump version 11.2

-- Started on 2019-05-03 16:16:13

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

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 279 (class 1259 OID 588485)
-- Name: abschnitt; Type: TABLE; Schema: erhaltung; Owner: postgres
--

CREATE TABLE erhaltung.abschnitt (
    id integer NOT NULL,
    geometrie public.geometry(LineStringZM,3035),
    laenge double precision,
    laenge_manuell double precision,
    von_bkm double precision,
    bis_bkm double precision,
    von_netzknoten_nummer integer,
    nach_netzknoten_nummer integer,
    id_strasse integer,
    laenge_asb integer
);


ALTER TABLE erhaltung.abschnitt OWNER TO postgres;

--
-- TOC entry 3757 (class 0 OID 0)
-- Dependencies: 279
-- Name: COLUMN abschnitt.geometrie; Type: COMMENT; Schema: erhaltung; Owner: postgres
--

COMMENT ON COLUMN erhaltung.abschnitt.geometrie IS 'bestandsachse';


--
-- TOC entry 278 (class 1259 OID 588483)
-- Name: abschnitt_id_seq; Type: SEQUENCE; Schema: erhaltung; Owner: postgres
--

CREATE SEQUENCE erhaltung.abschnitt_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE erhaltung.abschnitt_id_seq OWNER TO postgres;

--
-- TOC entry 3758 (class 0 OID 0)
-- Dependencies: 278
-- Name: abschnitt_id_seq; Type: SEQUENCE OWNED BY; Schema: erhaltung; Owner: postgres
--

ALTER SEQUENCE erhaltung.abschnitt_id_seq OWNED BY erhaltung.abschnitt.id;


--
-- TOC entry 3614 (class 2604 OID 589017)
-- Name: abschnitt id; Type: DEFAULT; Schema: erhaltung; Owner: postgres
--

ALTER TABLE ONLY erhaltung.abschnitt ALTER COLUMN id SET DEFAULT nextval('erhaltung.abschnitt_id_seq'::regclass);


--
-- TOC entry 3751 (class 0 OID 588485)
-- Dependencies: 279
-- Data for Name: abschnitt; Type: TABLE DATA; Schema: erhaltung; Owner: postgres
--

COPY erhaltung.abschnitt (id, geometrie, laenge, laenge_manuell, von_bkm, bis_bkm, von_netzknoten_nummer, nach_netzknoten_nummer, id_strasse, laenge_asb) FROM stdin;
26	01020000E0DB0B0000410000006097242E31FE504132C4F046897D4741000000000000000000000000000000006297242E31FE5041C0C3F046897D4741000000000000000000000000000000005C73832C31FE5041C3B7E678867D47410000000000000000000000000000000064D45EF934FE50415E895158E47B474100000000000000000000000000000000D076B2A735FE5041794D9AA7987B4741000000000000000000000000000000002DC2CC4138FE5041F0DEAC136B7A4741000000000000000000000000000000008F131E5B38FE50417E1F66D9637A4741000000000000000000000000000000002728276538FE50411FC3C4095D7A474100000000000000000000000000000000E459BC8B39FE5041193756C1A179474100000000000000000000000000000000DFD59D7F39FE504154A216649D7947410000000000000000000000000000000005E8928337FE5041936DACC66D79474100000000000000000000000000000000388C849135FE50418E07F741567947410000000000000000000000000000000099ED768D31FE50415BB4C26832794741000000000000000000000000000000005F0DF56329FE5041EB7CF7D5FF78474100000000000000000000000000000000FA5D394522FE5041CC314CAFDE78474100000000000000000000000000000000B86223341CFE5041CC2CF495C67847410000000000000000000000000000000020E600070EFE50410948968E98784741000000000000000000000000000000002844A588FDFD5041FC03C4436E784741000000000000000000000000000000000B38C58AF2FD5041F0B6EC82567847410000000000000000000000000000000044ABE9ACC2FD504152C7595CF977474100000000000000000000000000000000461D65EF82FD5041D177BB727D77474100000000000000000000000000000000FF57A3B580FD5041C53DF0EA7877474100000000000000000000000000000000F25707157EFD5041041471A37377474100000000000000000000000000000000FE67A4D676FD5041506CFBF264774741000000000000000000000000000000005261DB4969FD5041651E7F4345774741000000000000000000000000000000007ECF64DB59FD5041D75723101977474100000000000000000000000000000000A0A54FBC4CFD5041DDE9838AE97647410000000000000000000000000000000055386B3D47FD5041DFFE9FDCD076474100000000000000000000000000000000FF956C7A41FD5041D5161873B27647410000000000000000000000000000000087905F1841FD5041A403C623B0764741000000000000000000000000000000007CB42FB140FD5041A17807D2AD76474100000000000000000000000000000000352818BD3AFD50416FA3B4FB8376474100000000000000000000000000000000A6B35EF437FD50418F3546B1687647410000000000000000000000000000000008CB6C5A37FD504176AB43CC6276474100000000000000000000000000000000D7495C9634FD50415CEFF48734764741000000000000000000000000000000004637D69C2CFD50412BFF929C54754741000000000000000000000000000000009FBBFA692CFD50416A683D7651754741000000000000000000000000000000006D3F082F2CFD5041BB8813194B754741000000000000000000000000000000002D0D39BF25FD50419507E85C9974474100000000000000000000000000000000B4722CA923FD50411853846A717447410000000000000000000000000000000004E3CC8E23FD5041C3A7D8706F744741000000000000000000000000000000000BD905D421FD5041565F775D5B74474100000000000000000000000000000000F799700A1EFD50418663036C3874474100000000000000000000000000000000F552FFB017FD5041536CD94C10744741000000000000000000000000000000005A1AE2DF0EFD504118D1EA72E4734741000000000000000000000000000000008AE0182D08FD50412B13D1DDC9734741000000000000000000000000000000009AD7444301FD50419F2938A1B2734741000000000000000000000000000000009732828EF8FC504161E5B54297734741000000000000000000000000000000002AA4C765EAFC5041F9EF41A07073474100000000000000000000000000000000D83BBFA3E9FC50418FC933B26E734741000000000000000000000000000000007F9E73E0E8FC50418A92BDC66C7347410000000000000000000000000000000063A2FCEBAAFC5041244738DACD7247410000000000000000000000000000000083871C4857FC5041A1090936F7714741000000000000000000000000000000008BCEDF7456FC50411C3CF4F3F4714741000000000000000000000000000000007273B10A56FC5041BDCA72DEF3714741000000000000000000000000000000003D99CF9655FC50416C08D7B9F27147410000000000000000000000000000000013D1EFB854FC5041E28DE19BF0714741000000000000000000000000000000000F570CD624FC5041B9DB30077571474100000000000000000000000000000000AC130B8711FC5041EABE4DEF3F714741000000000000000000000000000000009DEA47910FFC50411C08E3C839714741000000000000000000000000000000004DD53FC802FC5041D9FA330E1271474100000000000000000000000000000000391C87E6F1FB504108890DD0D5704741000000000000000000000000000000001F541C55F1FB50418CAC6C7FD3704741000000000000000000000000000000008FB3FEBDF0FB50417647E837D1704741000000000000000000000000000000002DE1FDBDF0FB5041F5E4E437D170474100000000000000000000000000000000	7254.770555538269	\N	196.00700000000001	203.244	5137058	5237080	3	7237
27	01020000E0DB0B00002F0000005B9EE908C7F850416F535A078F2E4741000000000000000000000000000000003ACAF307CBF850411015A6036C2E474100000000000000000000000000000000AE8EBE74CEF850416A39FC8D492E47410000000000000000000000000000000048357016CFF850410DF07652402E474100000000000000000000000000000000DCCA60A2CFF85041AA352F54382E474100000000000000000000000000000000B8E37D59D3F85041A0BA1C11FB2D4741000000000000000000000000000000007B0A88D0D3F85041E4CC6C9DD82D4741000000000000000000000000000000005C8ED76DD3F85041EA3B4A5CA62D47410000000000000000000000000000000080692905D0F8504124CE6C58772D474100000000000000000000000000000000BC42E4B3CAF850419ADFE7CC472D474100000000000000000000000000000000F3D517B5C3F85041DFED0F291E2D4741000000000000000000000000000000001944B669C3F850412E943A681C2D47410000000000000000000000000000000099DFBE98BBF85041BA2112A7F82C47410000000000000000000000000000000031BE5771A7F85041AE7A5BF6A42C47410000000000000000000000000000000041549EBD9AF8504106E0E1C2652C474100000000000000000000000000000000AC7ABC6599F85041554416085D2C474100000000000000000000000000000000CAC4A5A398F85041DE34601A582C4741000000000000000000000000000000002A9C1DDB94F85041429825DB3E2C47410000000000000000000000000000000014ECB45893F850414479F375342C4741000000000000000000000000000000002C529F3F92F8504158044EE62C2C474100000000000000000000000000000000197657ED86F850413186680DE42B474100000000000000000000000000000000436C2AED81F850411AFD225DCC2B474100000000000000000000000000000000C8A1650276F850410CD80FE39C2B474100000000000000000000000000000000BDB9F95B5FF85041A78F1023532B4741000000000000000000000000000000000D6D17EB58F850414CA5F9E73F2B4741000000000000000000000000000000005A83E97850F85041323591AD262B47410000000000000000000000000000000033F5EB384FF850410B1FDAF0222B47410000000000000000000000000000000078A1D08F4DF85041D0394CFD1D2B474100000000000000000000000000000000AF68BB7B40F8504122B046ECF62A47410000000000000000000000000000000034BA4BBC33F850418BA93235CC2A474100000000000000000000000000000000FA0FA8B928F8504126E478F39F2A4741000000000000000000000000000000005CBED30A27F8504122C6AF2F992A474100000000000000000000000000000000CEDD580713F85041D5DAA2EE362A474100000000000000000000000000000000CA5918E103F850418264C487DD29474100000000000000000000000000000000960EC2CBF9F7504113053C5CA929474100000000000000000000000000000000D78AA0EEF0F750412CE1AF5B8029474100000000000000000000000000000000169B0276E7F75041F81A359F5C2947410000000000000000000000000000000031F69E96E5F75041874CB79D5629474100000000000000000000000000000000E010E8D9E3F7504178E53B0D5129474100000000000000000000000000000000775A070BD6F7504149D50C2A2829474100000000000000000000000000000000B914DDC1C7F750417B5C8A9E0529474100000000000000000000000000000000A73B419AB9F750413577E90DEA28474100000000000000000000000000000000C069D1E2A9F7504135CBC872CB2847410000000000000000000000000000000035A3E594A1F7504185DFD234BC284741000000000000000000000000000000000811B73092F750412C8D8FF49F2847410000000000000000000000000000000041F4494380F750410F0D040D7F284741000000000000000000000000000000006734C61F7EF75041127E81207B28474100000000000000000000000000000000	3494.3263453116751	\N	239.82400000000001	243.32400000000001	5536041	5536001	3	3500
29	01020000E0DB0B00008B0000004B8C1CCBE9F75041AA8E568C47454741000000000000000000000000000000008C5C458CF4F750410445DAB12D45474100000000000000000000000000000000C96BAC6D05F850411ABDEBBF0B45474100000000000000000000000000000000513817BF3FF850416EE93F319A44474100000000000000000000000000000000C4306D3A43F8504115656B2B93444741000000000000000000000000000000006C608E3F49F85041F500E5068744474100000000000000000000000000000000EDA4273E52F85041337D5C06724447410000000000000000000000000000000063988B5165F85041E9950B8C41444741000000000000000000000000000000005E79FE3267F85041C97BC7263C44474100000000000000000000000000000000020AD78967F85041D7C6B42D3B4447410000000000000000000000000000000004DF8D427CF8504168969B60FA43474100000000000000000000000000000000715410428EF85041B1B9F733B4434741000000000000000000000000000000007290455997F85041C9B282718A43474100000000000000000000000000000000F6CB39239DF8504145A97DA16B43474100000000000000000000000000000000B7FA4383A7F850418BD929432743474100000000000000000000000000000000A639BEAFAEF85041FDEB12CBE642474100000000000000000000000000000000D5270B18B1F85041905DF27FCB4247410000000000000000000000000000000056B2F54EB4F85041D28A48019042474100000000000000000000000000000000708B8C11B5F85041BAC148E2674247410000000000000000000000000000000058DFDE21B5F850410A9662E35B4247410000000000000000000000000000000033C21C41B4F85041126C5260264247410000000000000000000000000000000073DBA89FB2F850410610948CFA4147410000000000000000000000000000000095AD23A4A9F850417A4089669341474100000000000000000000000000000000F55928EDA4F850411AC3FC4D7041474100000000000000000000000000000000C8FB7EA399F85041DE05BCC12A41474100000000000000000000000000000000E185F40C93F8504169BA4A0A0941474100000000000000000000000000000000AF316CCD8DF85041BE60B324F24047410000000000000000000000000000000030C151A972F85041132181EC8A404741000000000000000000000000000000001618F28F63F850418BC86F4F5040474100000000000000000000000000000000A81741A761F850419F1BDC3E4840474100000000000000000000000000000000EB9D8A3D60F850412871E6734140474100000000000000000000000000000000E69DB09E5AF85041C70536372740474100000000000000000000000000000000CC895ABD52F85041FF08D2B7F73F4741000000000000000000000000000000008633776C4CF85041DB53504BB43F474100000000000000000000000000000000B351C6E14AF850419F05D03A9D3F4741000000000000000000000000000000007BBF6AC648F8504191C0A1D0293F47410000000000000000000000000000000098A56A8547F8504157F6E448AB3E4741000000000000000000000000000000007994254A47F85041D48BBB96943E4741000000000000000000000000000000000BEB6A2647F850411607DF2A903E474100000000000000000000000000000000BD24111247F8504140522A818C3E474100000000000000000000000000000000D513F7FC46F850419FD4D6C6883E4741000000000000000000000000000000001DC2680144F850411A2CEF68B13D474100000000000000000000000000000000431733DD42F85041D0BE1825983D47410000000000000000000000000000000083A7AB5741F85041FB58DC9A7F3D474100000000000000000000000000000000FD4F0E563DF850418CF6E06C513D47410000000000000000000000000000000036A4744539F8504184548909353D4741000000000000000000000000000000006B8EE29B30F85041443DCDB5033D4741000000000000000000000000000000002538BEF92BF85041361CEE26ED3C4741000000000000000000000000000000006DB1795820F850414E5D7768BF3C47410000000000000000000000000000000037406F8403F8504160CEC00F4D3C47410000000000000000000000000000000004126DF9FEF750412DAA11CD383C47410000000000000000000000000000000034862E52F1F750412EF602C9EF3B47410000000000000000000000000000000060674449EEF750416DE54861D93B4741000000000000000000000000000000007E82C05AEAF750419927085DB33B474100000000000000000000000000000000A798C3F4E7F7504108D9F759893B47410000000000000000000000000000000001E14676E7F75041A889162A773B474100000000000000000000000000000000C1F7A997E7F750419BDEAA1D453B474100000000000000000000000000000000D4D64187EAF7504117A17803123B474100000000000000000000000000000000D6068427EBF750418FB59C6E0B3B474100000000000000000000000000000000EC7B0AD7EBF75041980F8DAC033B4741000000000000000000000000000000002456BDF8EEF75041BC6310E7E73A474100000000000000000000000000000000E6377FD0EFF750415CCAED6DE03A47410000000000000000000000000000000017B3820EF6F75041D01A79FDB73A4741000000000000000000000000000000004EDAE105FCF75041C5CF1422993A474100000000000000000000000000000000C96D1EDF03F85041986B22FF773A4741000000000000000000000000000000000846DC0C0AF85041A3301438633A47410000000000000000000000000000000051101FEF11F85041C14705DA483A47410000000000000000000000000000000062BE509118F850414C5B58ED353A474100000000000000000000000000000000FF4281A428F85041E56ACFFF0E3A474100000000000000000000000000000000D740AEF32DF85041FA89B6A2043A474100000000000000000000000000000000E61CA8B93DF8504106E33DD8E5394741000000000000000000000000000000002C0B7D694AF850413115EF87D13947410000000000000000000000000000000007788BAB6DF85041A03FDB329D39474100000000000000000000000000000000415E05F789F8504100B1095C77394741000000000000000000000000000000000A0F30F08BF85041A928527C743947410000000000000000000000000000000008C8E35494F85041DD040C4368394741000000000000000000000000000000004106E7689DF85041CF5AA7445839474100000000000000000000000000000000F9928925A7F85041AB7207D5453947410000000000000000000000000000000077EE677EAFF8504137C952B13239474100000000000000000000000000000000C11F2F63B7F85041EE52FE481E39474100000000000000000000000000000000752AEED7BEF85041478936FD0739474100000000000000000000000000000000E98FAC71C6F850415AC56262EC38474100000000000000000000000000000000C3C7331BCCF850416A0DF7A3D638474100000000000000000000000000000000F3C51E21D1F8504132D6212BBC3847410000000000000000000000000000000041517FB8D5F850410B57CF2E9F384741000000000000000000000000000000006C266954DAF85041BAB3052375384741000000000000000000000000000000009C679EC9DCF85041F7DAD66A4938474100000000000000000000000000000000D4342CBEDCF8504181584DD01E3847410000000000000000000000000000000093049289DBF850416FC033EE0438474100000000000000000000000000000000759C84F2D7F8504108322005DE3747410000000000000000000000000000000030813B11D7F85041F41AC769D5374741000000000000000000000000000000002543B237D3F8504194DA0576B8374741000000000000000000000000000000009FA74610D3F85041AD6AB74DB7374741000000000000000000000000000000005F23FA3BD2F850419B8EE70CB13747410000000000000000000000000000000008BCD82AB7F8504175F44C6AF7364741000000000000000000000000000000006AA03CDAA5F8504114D5D2A9803647410000000000000000000000000000000007C80D63A1F85041AB6CC0CB5A364741000000000000000000000000000000002842BFC89CF85041092CF2A61C36474100000000000000000000000000000000AC45D2329CF85041E2FFD41C03364741000000000000000000000000000000007933A5F59DF8504198FC3318CE3547410000000000000000000000000000000017E539189EF85041AA962B07CA3547410000000000000000000000000000000089F8B3689FF850416CE63979B635474100000000000000000000000000000000912DCB9CA4F850418284FA948B35474100000000000000000000000000000000E56CEA78A6F8504192508F567D35474100000000000000000000000000000000066B5650BBF85041A5404DD7ED344741000000000000000000000000000000008D20BC33C2F85041920447F3B03447410000000000000000000000000000000018DB50F5C4F8504190FB22B09134474100000000000000000000000000000000DE5BB1C4C8F850410B5DC07252344741000000000000000000000000000000009554F915CAF85041957162672A344741000000000000000000000000000000005176F27BCAF850415BDD693FEF334741000000000000000000000000000000001866E18BCAF8504155538B00E633474100000000000000000000000000000000817C6B4FC9F850416FA37CCBB733474100000000000000000000000000000000FF6FEA2FC6F850416220C7D37E33474100000000000000000000000000000000C64F2405C3F85041CD51C8F9543347410000000000000000000000000000000080D351BABFF850418BA6D0733433474100000000000000000000000000000000E6374A76B8F85041CF69F9B7F732474100000000000000000000000000000000F49FBC3D99F850418700D0CF03324741000000000000000000000000000000007F1407FA97F85041AC98FCEEF931474100000000000000000000000000000000CE070FAF87F850416E0C6C6478314741000000000000000000000000000000007E763A8B82F8504186F2F2813F31474100000000000000000000000000000000698701EE7FF8504104BD913C083147410000000000000000000000000000000041D8E77A7FF85041ED02A95FDB30474100000000000000000000000000000000DB24690980F8504191A34F54AB304741000000000000000000000000000000007025E32482F850412120AAE376304741000000000000000000000000000000005E9D5A8A85F8504143730FE94A30474100000000000000000000000000000000A1DA23F08AF8504106F30FD318304741000000000000000000000000000000005E3B3B718BF85041BEDE4F251430474100000000000000000000000000000000631353F696F85041F374B11FBF2F474100000000000000000000000000000000FFFD802998F850418918523FB72F474100000000000000000000000000000000361E117E99F850411E80B6AEAE2F474100000000000000000000000000000000B041268DAAF85041CB622A04482F4741000000000000000000000000000000009643F6BEACF850410D7FC8CE3A2F47410000000000000000000000000000000047A35B5EAFF85041361425062B2F4741000000000000000000000000000000008A6785A2B0F850415F575E3C232F47410000000000000000000000000000000064C500EAB1F85041D67C065E1B2F4741000000000000000000000000000000007D7E44CEBDF85041A5E3ECB5D02E474100000000000000000000000000000000D4B0787BC3F85041B47B369FA92E4741000000000000000000000000000000005276E808C7F850413C7564078F2E4741000000000000000000000000000000005B9EE908C7F850416F535A078F2E474100000000000000000000000000000000	12540.190485441435	\N	227.26499999999999	239.82400000000001	5436006	5536041	3	12559
25	01020000E0DB0B00005F000000C2B12200F5F850418C2F02E0CF5C4741000000000000000000000000000000004AB89F9BE7F850411A3360A3A45C47410000000000000000000000000000000088664126D6F85041292606AE735C474100000000000000000000000000000000FE8BE70ED1F85041D0111A67655C474100000000000000000000000000000000A74D217CBCF85041B68CAEE62D5C474100000000000000000000000000000000E103B53996F8504166ECFFAFC65B4741000000000000000000000000000000007DE65C2394F8504167B37C33C15B474100000000000000000000000000000000CE2253146BF850416F2FD0DE535B474100000000000000000000000000000000A9FD06BB5CF85041F1653832285B4741000000000000000000000000000000000F1B37234AF85041968ECF33E75A474100000000000000000000000000000000FFD324053FF85041C1499E0DBA5A47410000000000000000000000000000000067EA5D8030F850413A36900C755A474100000000000000000000000000000000FA1A665828F85041944897A3455A474100000000000000000000000000000000E73CD1BD20F8504196688D74105A474100000000000000000000000000000000E8F1472E17F8504170122C9FB959474100000000000000000000000000000000E929AF75EDF75041F4B3DF28255847410000000000000000000000000000000055F6B020EDF750410801DEB02158474100000000000000000000000000000000F28530A8ECF7504158AA35C61C58474100000000000000000000000000000000B2AB1687ECF750416C5B956C1B5847410000000000000000000000000000000091D13802ECF75041687D8C89165847410000000000000000000000000000000069FA6951CBF75041205E441FDC564741000000000000000000000000000000004FD5EA8ABAF750412BFDCD913A56474100000000000000000000000000000000D176A568AFF7504122187351CF5547410000000000000000000000000000000013E23312A9F75041A98094569155474100000000000000000000000000000000AAB433A7A4F75041838C0E30615547410000000000000000000000000000000050141852A0F75041EE0EB71C1C554741000000000000000000000000000000004B5B58A99EF75041514165F3E9544741000000000000000000000000000000005435F4079CF7504176DA24814D544741000000000000000000000000000000007D36E9289AF75041E1E627A8E25347410000000000000000000000000000000023395B109AF7504115F0291EDE534741000000000000000000000000000000003E9FB6FF99F7504112CE4501D9534741000000000000000000000000000000003570B5DF94F750417F228064AB5247410000000000000000000000000000000049552DF091F750419E953D055952474100000000000000000000000000000000C496844E8EF750412D33D1171C52474100000000000000000000000000000000B1FB23308DF7504172449C000E5247410000000000000000000000000000000026E3E8E284F75041B0B1F99AB3514741000000000000000000000000000000001F80971A7CF7504137E88FCF6A51474100000000000000000000000000000000A886178A71F7504122AF879E2251474100000000000000000000000000000000754D769C55F750415A6B5AEC7350474100000000000000000000000000000000011BF9AE4DF750415EB5BCC04250474100000000000000000000000000000000731F224246F750419A15033314504741000000000000000000000000000000008140573B39F75041B51EDC8EC34F474100000000000000000000000000000000F3080F1E35F75041F47CB39AA94F474100000000000000000000000000000000D4772D4231F75041A0BCA5E2914F474100000000000000000000000000000000B23047BB30F750417BD36DA58E4F4741000000000000000000000000000000006B50D32A30F750417CCC3A198B4F474100000000000000000000000000000000C27260B208F75041E8A710C8954E474100000000000000000000000000000000EE09B1ECFFF6504122E8CDE45E4E47410000000000000000000000000000000016487130F5F650417D3498271C4E474100000000000000000000000000000000DC513F6DF4F65041842E237E174E474100000000000000000000000000000000B6D7028FF3F650417701004A124E47410000000000000000000000000000000072098280F2F65041320ADAC50B4E474100000000000000000000000000000000787F5F27C3F6504148CBFD22E44C474100000000000000000000000000000000A2F117A8BCF65041B66679DEBA4C474100000000000000000000000000000000547313D895F6504163014AA5C94B474100000000000000000000000000000000419C5BF180F6504127BCE3A3464B474100000000000000000000000000000000277E723D7CF6504137F1D3B0224B4741000000000000000000000000000000000095553078F65041D475E246F24A474100000000000000000000000000000000F03BB08176F65041FAB79251C84A47410000000000000000000000000000000091078D4C76F650418C2A79CCAD4A474100000000000000000000000000000000E2A8FF8777F65041D753DBA78A4A4741000000000000000000000000000000009C6333DD79F650410BBEB2366A4A474100000000000000000000000000000000EC7814AE7EF65041434DA7C63F4A474100000000000000000000000000000000225D4C1A83F65041AB8D840C234A474100000000000000000000000000000000DA04AF1A90F6504144DFF2A8DF494741000000000000000000000000000000004AE6AB7095F6504170C4B71FCA49474100000000000000000000000000000000E4BFCB9A99F65041D39FD855BB494741000000000000000000000000000000008069B88F9CF650412CF58DD5B049474100000000000000000000000000000000DBBFB4AB9FF650417E3BF2B7A649474100000000000000000000000000000000C6A200A6ACF6504196AC4A657E49474100000000000000000000000000000000985F36BDB2F65041587488336E494741000000000000000000000000000000000FD054E1C0F65041EEE2D3D44B494741000000000000000000000000000000003997CC78D2F650414EFA2CA3274947410000000000000000000000000000000073DF1D10D6F6504134D6C43F20494741000000000000000000000000000000005D5A6377E4F650418A10EA1D03494741000000000000000000000000000000009C20E8BF04F750411938D531C2484741000000000000000000000000000000006BDC816F63F75041CC70C85900484741000000000000000000000000000000009D2E67D072F750410EEC3EC1DA47474100000000000000000000000000000000DBBE0ABA74F75041C82D5DEBD547474100000000000000000000000000000000C4C1200D78F75041A9F34104CB4747410000000000000000000000000000000079A4D77A7BF75041D879B6C7BF47474100000000000000000000000000000000077603A984F75041B02C87239F474741000000000000000000000000000000008D73D91B8BF75041106993C88147474100000000000000000000000000000000767B2C0D90F7504149966F48674747410000000000000000000000000000000036DA58AC93F750419D8423A34F4747410000000000000000000000000000000020E58CF4B9F75041384B3F850D464741000000000000000000000000000000006533C742C0F75041E41A22A6DF4547410000000000000000000000000000000089774280C2F750411AAB4E74D34547410000000000000000000000000000000068224E7BC6F750418608C723BE45474100000000000000000000000000000000526F8924CFF75041F8521DAD9945474100000000000000000000000000000000BCC0E7D1D7F7504190F2083E7A454741000000000000000000000000000000001BCDC13BDCF7504101A93ECB6D454741000000000000000000000000000000008057E879E8F750418E6657434B45474100000000000000000000000000000000D13E19CBE9F750412D7F5E8C47454741000000000000000000000000000000004B8C1CCBE9F75041AA8E568C4745474100000000000000000000000000000000	12978.337324749717	\N	214.31	227.26499999999999	5336018	5436006	3	12955
28	01020000E0DB0B0000520000002DE1FDBDF0FB5041F5E4E437D17047410000000000000000000000000000000093C7CC31F0FB5041002780F6CE704741000000000000000000000000000000000A2BE717EFFB5041B0E42AB1CA704741000000000000000000000000000000008EC92724D4FB50412BDF0EA45770474100000000000000000000000000000000482059E0A1FB5041E0A405237B6F474100000000000000000000000000000000078481808CFB5041FF794ABA1D6F474100000000000000000000000000000000EED7EC606BFB50413DE186B08C6E4741000000000000000000000000000000005A54A1105DFB50416DD7AEAD4E6E474100000000000000000000000000000000D7B2DC7D4CFB5041A0ED8049066E474100000000000000000000000000000000A3C393554AFB5041238F85FEFC6D4741000000000000000000000000000000006F56B13449FB504180E15302F86D47410000000000000000000000000000000007D441FE46FB50414FCB7A4DEE6D4741000000000000000000000000000000004ED7BF243CFB504105474AD9BC6D474100000000000000000000000000000000885946A13AFB50417D99D059B56D47410000000000000000000000000000000077F4DF0930FB5041C72E4DE1806D47410000000000000000000000000000000057BAF8872AFB5041954E2BBF606D4741000000000000000000000000000000001132C4E922FB504102A8AAB0266D474100000000000000000000000000000000BBC6600521FB5041C84F407F146D47410000000000000000000000000000000056A739AA1CFB5041BCDD7F70DA6C474100000000000000000000000000000000CA0BA70B1BFB50410CBAE24BAE6C474100000000000000000000000000000000798B92911AFB50414ED5C3FA7A6C474100000000000000000000000000000000012D85271BFB504132E2D8015C6C4741000000000000000000000000000000001EB402EC1DFB50419AD900581F6C47410000000000000000000000000000000013097E1921FB504167567B5DF86B474100000000000000000000000000000000AEC782CD23FB50417F0F6D64E06B4741000000000000000000000000000000001A13000224FB504193CA0793DE6B47410000000000000000000000000000000088EFBF3626FB50413EE9F250CD6B47410000000000000000000000000000000093D7F1002AFB5041E1A7EAA1AF6B4741000000000000000000000000000000004C0045522EFB5041D7B378CB946B474100000000000000000000000000000000A4C6356544FB5041E68229991F6B474100000000000000000000000000000000B3CFE98B6BFB50419B4009EF556A474100000000000000000000000000000000DEC5384F7AFB5041CEEFBE5A036A4741000000000000000000000000000000005B30BFE67BFB504130AAB8E1F869474100000000000000000000000000000000C5CBD2A47EFB5041EB25B8D4E669474100000000000000000000000000000000A339C2EE85FB5041E5F883A29F69474100000000000000000000000000000000D70021E487FB5041DF12DCBC8169474100000000000000000000000000000000CCE2F61A8AFB5041C6507CCC5569474100000000000000000000000000000000CE8E13948AFB504137680B1C3A694741000000000000000000000000000000004DA565478AFB5041267863340869474100000000000000000000000000000000C19D062688FB504192647FDDD468474100000000000000000000000000000000AA0AFA6785FB5041EB5679D8AD684741000000000000000000000000000000002A08CFBB80FB5041C6862A218068474100000000000000000000000000000000DE60E8D47CFB504150808B8A60684741000000000000000000000000000000003896BCFC74FB504104592D912B68474100000000000000000000000000000000A550FCA070FB50411694D9AA1568474100000000000000000000000000000000B93B3C476FFB5041EA60BF0E0F6847410000000000000000000000000000000088D077386BFB50418508D333FB674741000000000000000000000000000000008020B9825EFB5041531D53F6C8674741000000000000000000000000000000004259ECF355FB504114B02104AB67474100000000000000000000000000000000AB514A773EFB504146EE39935F67474100000000000000000000000000000000AF75811629FB5041573D33361967474100000000000000000000000000000000AD5BEA07F1FA504157AB6A24676647410000000000000000000000000000000042C04FB7F0FA50419E480315666647410000000000000000000000000000000027579B55EFFA5041894DD9526166474100000000000000000000000000000000F5ACDEDCE9FA5041733A347A4E6647410000000000000000000000000000000090820B08DFFA504159B1149024664741000000000000000000000000000000009D8C7F1BD6FA5041E5FB909AFC654741000000000000000000000000000000004958C8C6A1FA5041B95C231404654741000000000000000000000000000000007F2BC3CBA0FA5041E3E31773FF644741000000000000000000000000000000007942CD5E8CFA50418ABAD0BD9E64474100000000000000000000000000000000607E0D9766FA504158F693BEEB63474100000000000000000000000000000000CA2D8FE963FA504136BF3C1DDF634741000000000000000000000000000000007A1E977B3DFA5041FF83A5C92863474100000000000000000000000000000000F00943612BFA5041A65965F6D26247410000000000000000000000000000000068FF768425FA50410224FB55B66247410000000000000000000000000000000057668A310EFA5041DD9BA79048624741000000000000000000000000000000000C4030B0C6F95041A6B383950D614741000000000000000000000000000000002C82108FB3F9504130F3DE91B960474100000000000000000000000000000000B74A1F21B2F95041C7067D59B360474100000000000000000000000000000000B0A6B856B0F950413887466DAB60474100000000000000000000000000000000919EE985A2F950414CD4BB4C6E604741000000000000000000000000000000006D53F17290F95041AAF8531913604741000000000000000000000000000000003B07D0E76BF950418E0465383B5F4741000000000000000000000000000000009EA6924648F950419A3E1F4C665E474100000000000000000000000000000000431F91932BF95041BBC26962B95D47410000000000000000000000000000000020FEC90021F95041F02B09487F5D474100000000000000000000000000000000BE9BB4F21BF95041BE90B480635D4741000000000000000000000000000000001804CAA012F9504171488178375D474100000000000000000000000000000000BF34C3420DF95041789B5CB0215D4741000000000000000000000000000000006F8367220CF95041B6341E1E1D5D4741000000000000000000000000000000009823A6D7FEF85041989A99CDEE5C474100000000000000000000000000000000C2B12200F5F850418C2F02E0CF5C474100000000000000000000000000000000	11054.967199364313	\N	203.244	214.31	5237080	5336018	3	11066
\.


--
-- TOC entry 3759 (class 0 OID 0)
-- Dependencies: 278
-- Name: abschnitt_id_seq; Type: SEQUENCE SET; Schema: erhaltung; Owner: postgres
--

SELECT pg_catalog.setval('erhaltung.abschnitt_id_seq', 29, true);


--
-- TOC entry 3617 (class 2606 OID 589001)
-- Name: abschnitt abschnitt_pk; Type: CONSTRAINT; Schema: erhaltung; Owner: postgres
--

ALTER TABLE ONLY erhaltung.abschnitt
    ADD CONSTRAINT abschnitt_pk PRIMARY KEY (id);


--
-- TOC entry 3615 (class 1259 OID 588702)
-- Name: abschnitt_geom_idx; Type: INDEX; Schema: erhaltung; Owner: postgres
--

CREATE INDEX abschnitt_geom_idx ON erhaltung.abschnitt USING gist (geometrie);


--
-- TOC entry 3621 (class 2620 OID 588893)
-- Name: abschnitt trigger_laenge; Type: TRIGGER; Schema: erhaltung; Owner: postgres
--

CREATE TRIGGER trigger_laenge BEFORE INSERT OR UPDATE OF geometrie, laenge, laenge_manuell ON erhaltung.abschnitt FOR EACH ROW EXECUTE PROCEDURE erhaltung.shape_length();


--
-- TOC entry 3620 (class 2606 OID 588736)
-- Name: abschnitt nach_netzknoten_fk; Type: FK CONSTRAINT; Schema: erhaltung; Owner: postgres
--

ALTER TABLE ONLY erhaltung.abschnitt
    ADD CONSTRAINT nach_netzknoten_fk FOREIGN KEY (nach_netzknoten_nummer) REFERENCES erhaltung.netzknoten(nummer) MATCH FULL ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 3618 (class 2606 OID 588956)
-- Name: abschnitt strasse_fk; Type: FK CONSTRAINT; Schema: erhaltung; Owner: postgres
--

ALTER TABLE ONLY erhaltung.abschnitt
    ADD CONSTRAINT strasse_fk FOREIGN KEY (id_strasse) REFERENCES erhaltung.strasse(id) MATCH FULL ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- TOC entry 3619 (class 2606 OID 588731)
-- Name: abschnitt von_netzknoten_fk; Type: FK CONSTRAINT; Schema: erhaltung; Owner: postgres
--

ALTER TABLE ONLY erhaltung.abschnitt
    ADD CONSTRAINT von_netzknoten_fk FOREIGN KEY (von_netzknoten_nummer) REFERENCES erhaltung.netzknoten(nummer) MATCH FULL ON UPDATE CASCADE ON DELETE RESTRICT;


-- Completed on 2019-05-03 16:16:14

--
-- PostgreSQL database dump complete
--

