Quelltext der Seite GLE-Postgis-Wildnachweisung

 <nowiki>
CREATE TABLE jagdkataster.wilduebersetzung
(
  id integer NOT NULL DEFAULT nextval('jagdkataster.wilduebersetz_id_seq'::regclass),
  nummer character varying(7),
  wildart character varying(100),
  art character varying(25),
  CONSTRAINT primewildueberse PRIMARY KEY (id)
)
WITH (
  OIDS=TRUE
);
 
  

CREATE TABLE jagdkataster.wildnachweisung
(
  id_intern serial NOT NULL,
  id character varying(255),
  art character varying(15),
  conname character varying(80),
  gemeindenum integer,
  gemeindenam character varying(100),
  zeitstempel timestamp(6) without time zone, -- zeitstempel für die übersicht
  pachtjahr character varying(9),
  flaeche numeric,
  asp character varying(9),
  a1 integer NOT NULL DEFAULT 0,
  a2 integer NOT NULL DEFAULT 0,
  a3 integer NOT NULL DEFAULT 0,
  a5 integer NOT NULL DEFAULT 0,
  a6 integer NOT NULL DEFAULT 0,
  a7 integer NOT NULL DEFAULT 0,
  a8 integer NOT NULL DEFAULT 0,
  a9 integer NOT NULL DEFAULT 0,
  b1 integer NOT NULL DEFAULT 0,
  b2 integer NOT NULL DEFAULT 0,
  b3 integer NOT NULL DEFAULT 0,
  b5 integer NOT NULL DEFAULT 0,
  b6 integer NOT NULL DEFAULT 0,
  b7 integer NOT NULL DEFAULT 0,
  b8 integer NOT NULL DEFAULT 0,
  b9 integer NOT NULL DEFAULT 0,
  c1 integer NOT NULL DEFAULT 0,
  c2 integer NOT NULL DEFAULT 0,
  c3 integer NOT NULL DEFAULT 0,
  c5 integer NOT NULL DEFAULT 0,
  c6 integer NOT NULL DEFAULT 0,
  c7 integer NOT NULL DEFAULT 0,
  c8 integer NOT NULL DEFAULT 0,
  c9 integer NOT NULL DEFAULT 0,
  a12 integer NOT NULL DEFAULT 0,
  a13 integer NOT NULL DEFAULT 0,
  a14 integer NOT NULL DEFAULT 0,
  a16 integer NOT NULL DEFAULT 0,
  a17 integer NOT NULL DEFAULT 0,
  a18 integer NOT NULL DEFAULT 0,
  a19 integer NOT NULL DEFAULT 0,
  a20 integer NOT NULL DEFAULT 0,
  b12 integer NOT NULL DEFAULT 0,
  b13 integer NOT NULL DEFAULT 0,
  b14 integer NOT NULL DEFAULT 0,
  b16 integer NOT NULL DEFAULT 0,
  b17 integer NOT NULL DEFAULT 0,
  b18 integer NOT NULL DEFAULT 0,
  b19 integer NOT NULL DEFAULT 0,
  b20 integer NOT NULL DEFAULT 0,
  c12 integer NOT NULL DEFAULT 0,
  c13 integer NOT NULL DEFAULT 0,
  c14 integer NOT NULL DEFAULT 0,
  c16 integer NOT NULL DEFAULT 0,
  c17 integer NOT NULL DEFAULT 0,
  c18 integer NOT NULL DEFAULT 0,
  c19 integer NOT NULL DEFAULT 0,
  c20 integer NOT NULL DEFAULT 0,
  a23 integer NOT NULL DEFAULT 0,
  a24 integer NOT NULL DEFAULT 0,
  a25 integer NOT NULL DEFAULT 0,
  a27 integer NOT NULL DEFAULT 0,
  a28 integer NOT NULL DEFAULT 0,
  a29 integer NOT NULL DEFAULT 0,
  a30 integer NOT NULL DEFAULT 0,
  b23 integer NOT NULL DEFAULT 0,
  b24 integer NOT NULL DEFAULT 0,
  b25 integer NOT NULL DEFAULT 0,
  b27 integer NOT NULL DEFAULT 0,
  b28 integer NOT NULL DEFAULT 0,
  b29 integer NOT NULL DEFAULT 0,
  b30 integer NOT NULL DEFAULT 0,
  c23 integer NOT NULL DEFAULT 0,
  c24 integer NOT NULL DEFAULT 0,
  c25 integer NOT NULL DEFAULT 0,
  c27 integer NOT NULL DEFAULT 0,
  c28 integer NOT NULL DEFAULT 0,
  c29 integer NOT NULL DEFAULT 0,
  c30 integer NOT NULL DEFAULT 0,
  a33 integer NOT NULL DEFAULT 0,
  a34 integer NOT NULL DEFAULT 0,
  a35 integer NOT NULL DEFAULT 0,
  a37 integer NOT NULL DEFAULT 0,
  a38 integer NOT NULL DEFAULT 0,
  a39 integer NOT NULL DEFAULT 0,
  a40 integer NOT NULL DEFAULT 0,
  b33 integer NOT NULL DEFAULT 0,
  b34 integer NOT NULL DEFAULT 0,
  b35 integer NOT NULL DEFAULT 0,
  b37 integer NOT NULL DEFAULT 0,
  b38 integer NOT NULL DEFAULT 0,
  b39 integer NOT NULL DEFAULT 0,
  b40 integer NOT NULL DEFAULT 0,
  c33 integer NOT NULL DEFAULT 0,
  c34 integer NOT NULL DEFAULT 0,
  c35 integer NOT NULL DEFAULT 0,
  c37 integer NOT NULL DEFAULT 0,
  c38 integer NOT NULL DEFAULT 0,
  c39 integer NOT NULL DEFAULT 0,
  c40 integer NOT NULL DEFAULT 0,
  a43 integer NOT NULL DEFAULT 0,
  a44 integer NOT NULL DEFAULT 0,
  a45 integer NOT NULL DEFAULT 0,
  a47 integer NOT NULL DEFAULT 0,
  a48 integer NOT NULL DEFAULT 0,
  a49 integer NOT NULL DEFAULT 0,
  a50 integer NOT NULL DEFAULT 0,
  b43 integer NOT NULL DEFAULT 0,
  b44 integer NOT NULL DEFAULT 0,
  b45 integer NOT NULL DEFAULT 0,
  b47 integer NOT NULL DEFAULT 0,
  b48 integer NOT NULL DEFAULT 0,
  b49 integer NOT NULL DEFAULT 0,
  b50 integer NOT NULL DEFAULT 0,
  c43 integer NOT NULL DEFAULT 0,
  c44 integer NOT NULL DEFAULT 0,
  c45 integer NOT NULL DEFAULT 0,
  c47 integer NOT NULL DEFAULT 0,
  c48 integer NOT NULL DEFAULT 0,
  c49 integer NOT NULL DEFAULT 0,
  c50 integer NOT NULL DEFAULT 0,
  a53 integer NOT NULL DEFAULT 0,
  a54 integer NOT NULL DEFAULT 0,
  a55 integer NOT NULL DEFAULT 0,
  a56 integer NOT NULL DEFAULT 0,
  a57 integer NOT NULL DEFAULT 0,
  a58 integer NOT NULL DEFAULT 0,
  a59 integer NOT NULL DEFAULT 0,
  a60 integer NOT NULL DEFAULT 0,
  a61 integer NOT NULL DEFAULT 0,
  a62 integer NOT NULL DEFAULT 0,
  a63 integer NOT NULL DEFAULT 0,
  a85 integer NOT NULL DEFAULT 0,
  b53 integer NOT NULL DEFAULT 0,
  b54 integer NOT NULL DEFAULT 0,
  b55 integer NOT NULL DEFAULT 0,
  b56 integer NOT NULL DEFAULT 0,
  b57 integer NOT NULL DEFAULT 0,
  b58 integer NOT NULL DEFAULT 0,
  b59 integer NOT NULL DEFAULT 0,
  b60 integer NOT NULL DEFAULT 0,
  b61 integer NOT NULL DEFAULT 0,
  b62 integer NOT NULL DEFAULT 0,
  b63 integer NOT NULL DEFAULT 0,
  b85 integer NOT NULL DEFAULT 0,
  c53 integer NOT NULL DEFAULT 0,
  c54 integer NOT NULL DEFAULT 0,
  c55 integer NOT NULL DEFAULT 0,
  c56 integer NOT NULL DEFAULT 0,
  c57 integer NOT NULL DEFAULT 0,
  c58 integer NOT NULL DEFAULT 0,
  c59 integer NOT NULL DEFAULT 0,
  c60 integer NOT NULL DEFAULT 0,
  c61 integer NOT NULL DEFAULT 0,
  c62 integer NOT NULL DEFAULT 0,
  c63 integer NOT NULL DEFAULT 0,
  c85 integer NOT NULL DEFAULT 0,
  d53 integer NOT NULL DEFAULT 0,
  d54 integer NOT NULL DEFAULT 0,
  d55 integer NOT NULL DEFAULT 0,
  d56 integer NOT NULL DEFAULT 0,
  d57 integer NOT NULL DEFAULT 0,
  d58 integer NOT NULL DEFAULT 0,
  d59 integer NOT NULL DEFAULT 0,
  d60 integer NOT NULL DEFAULT 0,
  d61 integer NOT NULL DEFAULT 0,
  d62 integer NOT NULL DEFAULT 0,
  d63 integer NOT NULL DEFAULT 0,
  d85 integer NOT NULL DEFAULT 0,
  a64 integer NOT NULL DEFAULT 0,
  a65 integer NOT NULL DEFAULT 0,
  a66 integer NOT NULL DEFAULT 0,
  a67 integer NOT NULL DEFAULT 0,
  a68 integer NOT NULL DEFAULT 0,
  a69 integer NOT NULL DEFAULT 0,
  a70 integer NOT NULL DEFAULT 0,
  a71 integer NOT NULL DEFAULT 0,
  a86 integer NOT NULL DEFAULT 0,
  a72 integer NOT NULL DEFAULT 0,
  a73 integer NOT NULL DEFAULT 0,
  a74 integer NOT NULL DEFAULT 0,
  a75 integer NOT NULL DEFAULT 0,
  a76 integer NOT NULL DEFAULT 0,
  a77 integer NOT NULL DEFAULT 0,
  a78 integer NOT NULL DEFAULT 0,
  a79 integer NOT NULL DEFAULT 0,
  a80 integer NOT NULL DEFAULT 0,
  a81 integer NOT NULL DEFAULT 0,
  a82 integer NOT NULL DEFAULT 0,
  a87 integer NOT NULL DEFAULT 0,
  a88 integer NOT NULL DEFAULT 0,
  a89 integer NOT NULL DEFAULT 0,
  b64 integer NOT NULL DEFAULT 0,
  b65 integer NOT NULL DEFAULT 0,
  b66 integer NOT NULL DEFAULT 0,
  b67 integer NOT NULL DEFAULT 0,
  b68 integer NOT NULL DEFAULT 0,
  b69 integer NOT NULL DEFAULT 0,
  b70 integer NOT NULL DEFAULT 0,
  b71 integer NOT NULL DEFAULT 0,
  b86 integer NOT NULL DEFAULT 0,
  b72 integer NOT NULL DEFAULT 0,
  b73 integer NOT NULL DEFAULT 0,
  b74 integer NOT NULL DEFAULT 0,
  b75 integer NOT NULL DEFAULT 0,
  b76 integer NOT NULL DEFAULT 0,
  b77 integer NOT NULL DEFAULT 0,
  b78 integer NOT NULL DEFAULT 0,
  b79 integer NOT NULL DEFAULT 0,
  b80 integer NOT NULL DEFAULT 0,
  b81 integer NOT NULL DEFAULT 0,
  b82 integer NOT NULL DEFAULT 0,
  b87 integer NOT NULL DEFAULT 0,
  b88 integer NOT NULL DEFAULT 0,
  b89 integer NOT NULL DEFAULT 0,
  c64 integer NOT NULL DEFAULT 0,
  c65 integer NOT NULL DEFAULT 0,
  c66 integer NOT NULL DEFAULT 0,
  c67 integer NOT NULL DEFAULT 0,
  c68 integer NOT NULL DEFAULT 0,
  c69 integer NOT NULL DEFAULT 0,
  c70 integer NOT NULL DEFAULT 0,
  c71 integer NOT NULL DEFAULT 0,
  c86 integer NOT NULL DEFAULT 0,
  c72 integer NOT NULL DEFAULT 0,
  c73 integer NOT NULL DEFAULT 0,
  c74 integer NOT NULL DEFAULT 0,
  c75 integer NOT NULL DEFAULT 0,
  c76 integer NOT NULL DEFAULT 0,
  c77 integer NOT NULL DEFAULT 0,
  c78 integer NOT NULL DEFAULT 0,
  c79 integer NOT NULL DEFAULT 0,
  c80 integer NOT NULL DEFAULT 0,
  c81 integer NOT NULL DEFAULT 0,
  c82 integer NOT NULL DEFAULT 0,
  c87 integer NOT NULL DEFAULT 0,
  c88 integer NOT NULL DEFAULT 0,
  c89 integer NOT NULL DEFAULT 0,
  d64 integer NOT NULL DEFAULT 0,
  d65 integer NOT NULL DEFAULT 0,
  d66 integer NOT NULL DEFAULT 0,
  d67 integer NOT NULL DEFAULT 0,
  d68 integer NOT NULL DEFAULT 0,
  d69 integer NOT NULL DEFAULT 0,
  d70 integer NOT NULL DEFAULT 0,
  d71 integer NOT NULL DEFAULT 0,
  d86 integer NOT NULL DEFAULT 0,
  d72 integer NOT NULL DEFAULT 0,
  d73 integer NOT NULL DEFAULT 0,
  d74 integer NOT NULL DEFAULT 0,
  d75 integer NOT NULL DEFAULT 0,
  d76 integer NOT NULL DEFAULT 0,
  d77 integer NOT NULL DEFAULT 0,
  d78 integer NOT NULL DEFAULT 0,
  d79 integer NOT NULL DEFAULT 0,
  d80 integer NOT NULL DEFAULT 0,
  d81 integer NOT NULL DEFAULT 0,
  d82 integer NOT NULL DEFAULT 0,
  d87 integer NOT NULL DEFAULT 0,
  d88 integer NOT NULL DEFAULT 0,
  d89 integer NOT NULL DEFAULT 0,
  a83 integer NOT NULL DEFAULT 0,
  b83 integer NOT NULL DEFAULT 0,
  a84 integer NOT NULL DEFAULT 0,
  b84 integer NOT NULL DEFAULT 0,
  the_geom geometry,
  CONSTRAINT primewildnach PRIMARY KEY (id_intern),
  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
  CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 2398)
)
WITH (
  OIDS=TRUE
);

COMMENT ON COLUMN jagdkataster.wildnachweisung.zeitstempel IS 'zeitstempel für die übersicht';</nowiki>