Bodenschätzung

--Karsten Daedelow, 25. Mai 2009 (dae) Der Gutachterausschuß MST hatte Schwierigkeiten, bei Bewertungen von Teilflächen größerer Flurstücke, der Teilfläche auch den entsprechenden Schätzungsabschnit zuzuordnen. Sie benötigten also eine grafische Darstellung der Bodenschätzung in kvwmap. Da dies wohl noch niemand hat, hier eine Möglichkeit:

INSERT INTO `layer` (`Layer_ID`, `Name`, `Datentyp`, `Gruppe`, `pfad`, `Data`, `tileindex`, `tileitem`,  `labelangleitem`, `labelitem`, `labelmaxscale`, `labelminscale`, `labelrequires`, `connection`, `connectiontype`, `classitem`, `filteritem`, `tolerance`, `toleranceunits`, `epsg_code`, `template`, `queryable`, `transparency`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `ows_srs`, `wms_name`, `wms_server_version`, `wms_format`, `wms_connectiontimeout`, `wfs_geom`, `selectiontype`, `logconsume`) VALUES
(9000, 'Schätzungsabschnitt', 2, '9000', 'SELECT o.objnr AS oid,o.folie,o.objart,o.the_geom,t.label,round (area(o.the_geom)) AS Flaeche FROM alkobj_e_fla AS o, alkobj_t_pkt AS t WHERE o.objart BETWEEN 222 AND 223 and o.objnr=t.objnr\r\n', 'the_geom from (SELECT o.objnr AS oid,o.objart,o.folie,o.the_geom,t.label AS label FROM alkobj_e_fla AS o, alkobj_t_pkt AS t WHERE o.folie=042 AND o.objnr=t.objnr) as foo using unique oid using srid=2398\r\n', , , , 'label', NULL, NULL, , 'user=kvwmap password=xxxxxxxx dbname=kvwmapsp170', 6, 'objart', 'objart', 3, 'pixels', '2398', , '0', NULL, NULL, NULL, NULL, , 'EPSG:2398', 'Bod.schätzung', '1.1.0', 'image/png', 60, , , NULL),
(9002, 'Klassifizierung', 2, '9000', 'SELECT o.objnr AS oid,o.folie,o.objart,o.the_geom,t.label, round (area(o.the_geom)) AS Flaeche FROM alkobj_e_fla AS o, alkobj_t_pkt AS t WHERE o.objart=901 and o.objnr=t.objnr\r\n', 'the_geom from (SELECT o.objnr AS oid,o.objart,o.folie,o.the_geom,t.label AS label FROM alkobj_e_fla AS o, alkobj_t_pkt AS t WHERE o.folie=042 AND o.objnr=t.objnr ) as foo using unique oid using srid=2398\r\n', , , , 'label', NULL, NULL, , 'user=kvwmap password=xxxxxxxx dbname=kvwmapsp170', 6, 'objart', 'objart', 3, 'pixels', '2398', , '0', NULL, NULL, NULL, NULL, , 'EPSG:2398', 'Bod.schätzung', '1.1.0', 'image/png', 60, , , NULL),
(9003, 'Tagesabschnitte', 2, '9000', 'SELECT o.objnr AS oid,o.folie,o.objart,o.the_geom,t.label, round (area(o.the_geom)) AS Flaeche FROM alkobj_e_fla AS o, alkobj_t_pkt AS t WHERE o.objart=903 and o.objnr=t.objnr\r\n', 'the_geom from (SELECT o.objnr AS oid,o.objart,o.folie,o.the_geom,t.label AS label FROM alkobj_e_fla AS o, alkobj_t_pkt AS t WHERE o.folie=042 AND o.objnr=t.objnr ) as foo using unique oid using srid=2398\r\n', , , , 'label', NULL, NULL, , 'user=kvwmap password=xxxxxxxx dbname=kvwmapsp170', 6, 'objart', 'objart', 3, 'pixels', '2398', , '0', NULL, NULL, NULL, NULL, , 'EPSG:2398', 'Bod.schätzung', '1.1.0', 'image/png', 60, , , NULL),
(9004, 'Grabloch', 0, '9000', 'SELECT o.objnr AS oid,o.folie,o.objart,o.the_geom,t.label FROM alkobj_e_pkt AS o,alkobj_t_punkt AS t WHERE o.objart BETWEEN 264 AND 265 AND o.objnr=t.objnr\r\n', 'the_geom from (SELECT o.objnr AS oid,o.objart,o.folie,o.the_geom,t.label AS label FROM alkobj_e_pkt AS o,alkobj_t_pkt AS t WHERE o.objart BETWEEN 264 AND 265 AND o.objnr=t.objnr) as foo using unique oid using srid=2398\r\n', , , , 'label', NULL, NULL, , 'user=kvwmap password=xxxxxxxx dbname=kvwmapsp170', 6, 'objart', 'objart', 3, 'pixels', '2398', , '0', NULL, NULL, NULL, NULL, , 'EPSG:2398', 'Bod.schätzung', '1.1.0', 'image/png', 60, , , NULL);
(9005, 'Vergleichsstueck', 1, '9000', 'SELECT o.objnr AS oid,o.folie,o.objart,o.the_geom,t.label FROM alkobj_a_lin AS o, alkobj_t_pkt AS t WHERE o.objart=227 AND o.objnr=t.objnr\r\n\r\n', 'the_geom from (SELECT o.objnr AS oid,o.objart,o.folie,o.the_geom,t.label AS label FROM alkobj_a_lin AS o, alkobj_t_pkt AS t WHERE o.objart=227  AND o.objnr=t.objnr ) as foo using unique oid using srid=2398\r\n\r\n', , , , NULL, NULL, NULL, , 'user=kvwmap password=xxxxxxxx dbname=kvwmapsp170', 6, 'objart', 'objart', 3, 'pixels', '2398', , '0', NULL, NULL, NULL, NULL, , 'EPSG:2398', 'Bod.schätzung', '1.1.0', 'image/png', 60, , , NULL),
(9006, 'NrVglStueck', 0, '9000', 'SELECT objnr AS oid,folie,objart,the_geom,label FROM alkobj_t_pkt WHERE objart=227 \r\n\r\n', 'the_geom from (SELECT objnr AS oid,objart,folie,the_geom,label FROM alkobj_t_pkt WHERE objart=227) as foo using unique oid using srid=2398\r\n\r\n', , , , 'label', NULL, NULL, , 'user=kvwmap password=xxxxxxxx dbname=kvwmapsp170', 6, 'objart', 'objart', 3, 'pixels', '2398', , '0', NULL, NULL, NULL, NULL, , 'EPSG:2398', 'Bod.schätzung', '1.1.0', 'image/png', 60, , , NULL);

INSERT INTO `classes` (`Class_ID`, `Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES 
(9000, 'Ackerland', 9000, '([objart] = 222)', 0, NULL),
(9001, 'Grünland', 9000, '([objart] = 223)', 0, NULL),
(9002, 'Klassifizierung', 9002, '([objart] = 901)', 0, NULL),
(9003, 'Tagesabschnitte', 9003, '([objart] = 903)', 0, NULL),
(9004, 'Grabloch', 9004, , 145, NULL),
(9005, 'Vergleichsstueck', 9005, , 101, NULL),
(9006, 'NrVglStueck', 9006, , 101, NULL);

INSERT INTO `u_styles2classes` (`class_id`, `style_id`, `drawingorder`) VALUES 
(9000, 9000, NULL),
(9001, 9001, NULL),
(9002, 9002, NULL),
(9003, 9003, NULL),
(9004, 9004, NULL),
(9005, 9005, NULL),
(9006, 9006, NULL);

INSERT INTO `styles` (`Style_ID`, `symbol`, `symbolname`, `size`, `color`, `backgroundcolor`, `outlinecolor`, `minsize`, `maxsize`, `angle`, `angleitem`, `antialias`, `width`, `minwidth`, `maxwidth`, `sizeitem`) VALUES 
(9001, 26, NULL, 3, '5 176 0', NULL, '0 0 0', 2, 4, 0, , NULL, NULL, NULL, NULL, NULL),
(9002, NULL, NULL, 2, '255 190 232', NULL, '0 0 0', 1, 4, 0, , NULL, NULL, NULL, NULL, NULL),
(9003, 26, NULL, 6, '-1 -1 -1', NULL, '0 245 255', 3, 9, 0, , NULL, NULL, NULL, NULL, NULL),
(9004, 24, NULL, 6, '255 064 064', NULL, '0 0 0', 3, 9, 0, , NULL, NULL, NULL, NULL, NULL),
(9005, NULL, 'Strichlinie', 1, '255 064 064', NULL, '0 0 0', 1, 3, 0, , NULL, NULL, NULL, NULL, NULL),
(9006, 26, NULL, 2, '255 064 064', NULL, '0 0 0', 1, 3, 0, , NULL, NULL, NULL, NULL, NULL);

INSERT INTO `u_labels2classes` (`class_id`, `label_id`) VALUES 
(9000, 9000),
(9001, 9000),
(9002, 9002),
(9003, 9003),
(9004, 9004),
(9006, 9006);

INSERT INTO `labels` (`Label_ID`, `font`, `type`, `color`, `outlinecolor`, `shadowcolor`, `shadowsizex`, `shadowsizey`, `backgroundcolor`, `backgroundshadowcolor`, `backgroundshadowsizex`, `backgroundshadowsizey`, `size`, `minsize`, `maxsize`, `position`, `offsetx`, `offsety`, `angle`, `autoangle`, `buffer`, `antialias`, `minfeaturesize`, `maxfeaturesize`, `partials`, `wrap`, `the_force`) VALUES 
(9000, 'arial', 0, '139 69 19', '255 255 255', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 8, 12, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, 0, 1),
(9002, 'arial', 0, '100 100 255', '255 255 255', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 8, 12, 8, 10, 15, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9003, 'arial', 0, '0 245 255', '255 255 255', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 20, 18, 25, 8, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9004, 'arial', 0, '255 064 064', '255 255 255', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8, 6, 10, 8, 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9006, 'arial', 0, '255 064 064', '255 255 255', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 8, 12, 8, 10, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `used_layer` (`Stelle_ID`, `Layer_ID`, `queryable`, `drawingorder`, `minscale`, `maxscale`, `offsite`, `transparency`, `postlabelcache`, `Filter`, `template`, `header`, `footer`, `symbolscale`, `requires`, `logconsume`, `privileg`) VALUES 
(605, 9000, '1', 140, 500, 15001, , 70, '0', NULL, , NULL, NULL, NULL, NULL, '0', '0'),
(605, 9002, '1', 141, 500, 15001, , 60, '0', NULL, , NULL, NULL, NULL, NULL, '0', '0'),
(605, 9003, '0', 142, 0, 0, , NULL, '0', NULL, , NULL, NULL, NULL, NULL, '0', '0'),
(605, 9004, '0', 143, 500, 15001, , NULL, '0', NULL, , NULL, NULL, NULL, NULL, '0', '0'),
(605, 9005, '0', 144, 500, 15001, , NULL, '0', NULL, , NULL, NULL, NULL, NULL, '0', '0'),
(605, 9006, '0', 145, 500, 15001, , NULL, '0', NULL, , NULL, NULL, NULL, '[Vergleichsstueck] != 0', '0', '0');