Bodenschätzung: Unterschied zwischen den Versionen
Dae (Diskussion | Beiträge) |
Dae (Diskussion | Beiträge) |
||
| Zeile 1: | Zeile 1: | ||
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: | 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: | ||
| + | Landkreis MST, Karsten Daedelow | ||
| − | |||
| − | |||
| − | |||
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 | 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), | (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), | ||
| Zeile 12: | Zeile 10: | ||
(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); | (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 | INSERT INTO `classes` (`Class_ID`, `Name`, `Layer_ID`, `Expression`, `drawingorder`, `text`) VALUES | ||
(9000, 'Ackerland', 9000, '([objart] = 222)', 0, NULL), | (9000, 'Ackerland', 9000, '([objart] = 222)', 0, NULL), | ||
| Zeile 22: | Zeile 19: | ||
(9006, 'NrVglStueck', 9006, '', 101, NULL); | (9006, 'NrVglStueck', 9006, '', 101, NULL); | ||
| − | |||
INSERT INTO `u_styles2classes` (`class_id`, `style_id`, `drawingorder`) VALUES | INSERT INTO `u_styles2classes` (`class_id`, `style_id`, `drawingorder`) VALUES | ||
(9000, 9000, NULL), | (9000, 9000, NULL), | ||
| Zeile 32: | Zeile 28: | ||
(9006, 9006, 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 | 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), | (9001, 26, NULL, 3, '5 176 0', NULL, '0 0 0', 2, 4, 0, '', NULL, NULL, NULL, NULL, NULL), | ||
| Zeile 41: | Zeile 36: | ||
(9006, 26, NULL, 2, '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 | INSERT INTO `u_labels2classes` (`class_id`, `label_id`) VALUES | ||
(9000, 9000), | (9000, 9000), | ||
| Zeile 50: | Zeile 44: | ||
(9006, 9006); | (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 | 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), | (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), | ||
| Zeile 58: | Zeile 51: | ||
(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); | (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 | 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, 9000, '1', 140, 500, 15001, '', 70, '0', NULL, '', NULL, NULL, NULL, NULL, '0', '0'), | ||
Version vom 25. Mai 2009, 11:27 Uhr
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: Landkreis MST, Karsten Daedelow
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');
