проблема отображения слоя при подключении к базе данных

[Djinn18]

тут все слои через shp-файлы http://niczem.zapto.org/geo/ok.html
тут через базу http://niczem.zapto.org/geo/demo.html

есть слой ЗИС
когда данные берутся из shp- файла, map-файл выглядит так

Спойлер

MAP
NAME ZIS
IMAGECOLOR 255 255 255
SIZE 900 800
PROJECTION
"init=epsg:4326"
END
EXTENT 26.4 55.2 27.6 55.9
WEB
IMAGEPATH "/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
METADATA
"map" "C:/ms4w/apps/wms_zis.map"
"ows_schemas_location" "http://schemas.opengeospatial.net"
"ows_title" "ZIS_Braslavsky"
"ows_abstract" "Land Information System of Braslavsky district"
"ows_keywordlist" "ZIS, Braslavsky, Land"
"ows_onlineresource" "http://niczem.zapto.org/cgi-bin/mapserv ... ms_zis.map"
"wms_srs" "EPSG:4326 "
"wms_feature_info_mime_type" "text/plain"
"wms_feature_info_mime_type" "text/html"
"wms_server_version" "1.1.1"
"wms_formatlist" "image/png,image/gif,image/jpeg"
"wms_format" "image/gif"
END #metadata
END #web
LAYER
NAME Land_Braslav
TYPE POLYGON
TOLERANCE 8
TOLERANCEUNITS pixels
TEMPLATE "templates/query.html"
STATUS ON
DATA Land_Braslav
METADATA
"ows_title" "Land_Braslav"
"wms_include_items" "all"
END #metadata
CLASSITEM "LANDTYPE"
CLASS
NAME "Pahotnoprigodnie"
EXPRESSION '101'
COLOR 255 255 115
END
CLASS
NAME "Mnogoletnie"
EXPRESSION '102'
COLOR 255 127 127
END
CLASS
NAME "Lugovie"
EXPRESSION '103'
COLOR 211 255 190
END
CLASS
NAME "Lesa"
EXPRESSION '201'
COLOR 125 214 109
END
CLASS
NAME "Posadki"
EXPRESSION '202'
COLOR 115 255 223
END
CLASS
NAME "Porosl"
EXPRESSION '203'
COLOR 190 255 232
END
CLASS
NAME "Prochie lesopokritie"
EXPRESSION '204'
COLOR 128 100 55
END
CLASS
NAME "Prochie lesonepokritie"
EXPRESSION '205'
COLOR 151 167 247
END
CLASS
NAME "Bolota"
EXPRESSION '206'
COLOR 64 101 235
END
CLASS
NAME "Vodotoki"
EXPRESSION '301'
COLOR 63 100 235
END
CLASS
NAME "Vodoemi"
EXPRESSION '302'
COLOR 151 219 242
END
CLASS
NAME "Dorogi avtomobilnie"
EXPRESSION '328'
COLOR 168 112 0
END
CLASS
NAME "Dorogi avtomobilnie"
EXPRESSION '401'
COLOR 168 112 0
END
CLASS
NAME "Dorogi zheleznie"
EXPRESSION '402'
COLOR 0 0 0
END
CLASS
NAME "Elementi kommunikaciy"
EXPRESSION '403'
COLOR 109 227 150
END
CLASS
NAME "Ulici i dorozhki"
EXPRESSION '501'
COLOR 245 180 147
END
CLASS
NAME "Zelenie nasazhdeniya"
EXPRESSION '502'
COLOR 109 187 67
END
CLASS
NAME "Prochie stroyob'ekti"
EXPRESSION '503'
COLOR 106 187 235
END
CLASS
NAME "Zdaniya"
EXPRESSION '504'
COLOR 0 0 0
END
CLASS
NAME "Sooruzheniya"
EXPRESSION '505'
COLOR 110 130 245
END
CLASS
NAME "Narushennie zemli"
EXPRESSION '601'
COLOR 150 56 147
END
CLASS
NAME "Neispol'zuemie zemli"
EXPRESSION '602'
COLOR 94 145 142
END
CLASS
NAME "Ulucshaemie zemli"
EXPRESSION '701'
COLOR 237 225 85
END
CLASS
NAME "Razrabotki i stroitel'stvo"
EXPRESSION '702'
COLOR 106 86 130
END
CLASS
NAME "Svalki"
EXPRESSION '703'
COLOR 143 60 89
END
CLASS
NAME "Zahoroneniya"
EXPRESSION '704'
COLOR 0 0 0
END
CLASS
NAME "Prochie zemli"
EXPRESSION '705'
COLOR 255 190 232
END
END
END #map
[/quote]

а для подключения к базе данных, переделал вот так, но почему-то не работает

Спойлер

MAP
NAME ZIS
IMAGECOLOR 255 255 255
SIZE 900 800
PROJECTION
"init=epsg:4326"
END
EXTENT 26.4 55.2 27.6 55.9
WEB
IMAGEPATH "/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
METADATA
"map" "C:/ms4w/apps/wms_zis1.map"
"ows_schemas_location" "http://schemas.opengeospatial.net"
"ows_title" "ZIS_Braslavsky"
"ows_abstract" "Land Information System of Braslavsky district"
"ows_keywordlist" "ZIS, Braslavsky, Land"
"ows_onlineresource" "http://niczem.zapto.org/cgi-bin/mapserv ... s_zis1.map"
"wms_srs" "EPSG:4326 "
"wms_feature_info_mime_type" "text/plain"
"wms_feature_info_mime_type" "text/html"
"wms_server_version" "1.1.1"
"wms_formatlist" "image/png,image/gif,image/jpeg"
"wms_format" "image/gif"
END #metadata
END #web
LAYER
NAME land_braslav
CONNECTIONTYPE postgis
CONNECTION "user=xxxxxxxxx password=xxxxxxxx dbname=xxxxxxxx host=87.252.238.126"
DATA "the_geom from Land_Braslav using unique gid using srid=4326"
TYPE POLYGON
TOLERANCE 8
TOLERANCEUNITS pixels
TEMPLATE "templates/query.html"
STATUS ON
METADATA
"ows_title" "Land_Braslav"
"wms_include_items" "all"
END #metadata
CLASSITEM "LANDTYPE"
CLASS
NAME "Pahotnoprigodnie"
EXPRESSION '101'
COLOR 255 255 115
END
CLASS
NAME "Mnogoletnie"
EXPRESSION '102'
COLOR 255 127 127
END
CLASS
NAME "Lugovie"
EXPRESSION '103'
COLOR 211 255 190
END
CLASS
NAME "Lesa"
EXPRESSION '201'
COLOR 125 214 109
END
CLASS
NAME "Posadki"
EXPRESSION '202'
COLOR 115 255 223
END
CLASS
NAME "Porosl"
EXPRESSION '203'
COLOR 190 255 232
END
CLASS
NAME "Prochie lesopokritie"
EXPRESSION '204'
COLOR 128 100 55
END
CLASS
NAME "Prochie lesonepokritie"
EXPRESSION '205'
COLOR 151 167 247
END
CLASS
NAME "Bolota"
EXPRESSION '206'
COLOR 64 101 235
END
CLASS
NAME "Vodotoki"
EXPRESSION '301'
COLOR 63 100 235
END
CLASS
NAME "Vodoemi"
EXPRESSION '302'
COLOR 151 219 242
END
CLASS
NAME "Dorogi avtomobilnie"
EXPRESSION '328'
COLOR 168 112 0
END
CLASS
NAME "Dorogi avtomobilnie"
EXPRESSION '401'
COLOR 168 112 0
END
CLASS
NAME "Dorogi zheleznie"
EXPRESSION '402'
COLOR 0 0 0
END
CLASS
NAME "Elementi kommunikaciy"
EXPRESSION '403'
COLOR 109 227 150
END
CLASS
NAME "Ulici i dorozhki"
EXPRESSION '501'
COLOR 245 180 147
END
CLASS
NAME "Zelenie nasazhdeniya"
EXPRESSION '502'
COLOR 109 187 67
END
CLASS
NAME "Prochie stroyob'ekti"
EXPRESSION '503'
COLOR 106 187 235
END
CLASS
NAME "Zdaniya"
EXPRESSION '504'
COLOR 0 0 0
END
CLASS
NAME "Sooruzheniya"
EXPRESSION '505'
COLOR 110 130 245
END
CLASS
NAME "Narushennie zemli"
EXPRESSION '601'
COLOR 150 56 147
END
CLASS
NAME "Neispol'zuemie zemli"
EXPRESSION '602'
COLOR 94 145 142
END
CLASS
NAME "Ulucshaemie zemli"
EXPRESSION '701'
COLOR 237 225 85
END
CLASS
NAME "Razrabotki i stroitel'stvo"
EXPRESSION '702'
COLOR 106 86 130
END
CLASS
NAME "Svalki"
EXPRESSION '703'
COLOR 143 60 89
END
CLASS
NAME "Zahoroneniya"
EXPRESSION '704'
COLOR 0 0 0
END
CLASS
NAME "Prochie zemli"
EXPRESSION '705'
COLOR 255 190 232
END

END
END #map

[Denis Rykov]

Жалуется на отсутствие таблицы land_braslav.

[Djinn18]

на картинке список всех таблиц в базе
везде все с большой буквы Land_Braslav и все равно

[Denis Rykov]

В PostgreSQL не рекомендуется называть таблицы с использованием прописных букв, так как в этом случае при обращении к ним всегда нужно будет брать имя в кавычки. Переименуйте таблицу и, думаю, ваша проблема будет решена. http://gis-lab.info/qa/postgis-mapserver.html#01

[Djinn18]

я вообще заново загрузил данные в базу, и сразу дал ей название land_br

Спойлер

MAP
NAME ZIS
IMAGECOLOR 255 255 255
SIZE 900 800
PROJECTION
"init=epsg:4326"
END
EXTENT 26.4 55.2 27.6 55.9
WEB
IMAGEPATH "/tmp/ms_tmp/"
IMAGEURL "/ms_tmp/"
METADATA
"map" "C:/ms4w/apps/wms_zis1.map"
"ows_schemas_location" "http://schemas.opengeospatial.net"
"ows_title" "ZIS_Braslavsky"
"ows_abstract" "Land Information System of Braslavsky district"
"ows_keywordlist" "ZIS, Braslavsky, Land"
"ows_onlineresource" "http://niczem.zapto.org/cgi-bin/mapserv ... s_zis1.map"
"wms_srs" "EPSG:4326 "
"wms_feature_info_mime_type" "text/plain"
"wms_feature_info_mime_type" "text/html"
"wms_server_version" "1.1.1"
"wms_formatlist" "image/png,image/gif,image/jpeg"
"wms_format" "image/gif"
"wms_encoding" "UTF-8"
END #metadata
END #web
LAYER
NAME land_br
CONNECTIONTYPE postgis
CONNECTION "user=xxxx password=xxxxx dbname=xxxx host=87.252.238.126"
DATA "the_geom from land_br using unique gid using srid=4326"
TYPE POLYGON
TOLERANCE 8
TOLERANCEUNITS pixels
TEMPLATE "templates/query.html"
STATUS ON
METADATA
"ows_title" "land_br"
"wms_include_items" "all"
"wms_encoding" "UTF-8"
END #metadata
CLASSITEM "LANDTYPE"
CLASS
NAME "Pahotnoprigodnie"
EXPRESSION '101'
COLOR 255 255 115
END
CLASS
NAME "Mnogoletnie"
EXPRESSION '102'
COLOR 255 127 127
END
CLASS
NAME "Lugovie"
EXPRESSION '103'
COLOR 211 255 190
END
CLASS
NAME "Lesa"
EXPRESSION '201'
COLOR 125 214 109
END
CLASS
NAME "Posadki"
EXPRESSION '202'
COLOR 115 255 223
END
CLASS
NAME "Porosl"
EXPRESSION '203'
COLOR 190 255 232
END
CLASS
NAME "Prochie lesopokritie"
EXPRESSION '204'
COLOR 128 100 55
END
CLASS
NAME "Prochie lesonepokritie"
EXPRESSION '205'
COLOR 151 167 247
END
CLASS
NAME "Bolota"
EXPRESSION '206'
COLOR 64 101 235
END
CLASS
NAME "Vodotoki"
EXPRESSION '301'
COLOR 63 100 235
END
CLASS
NAME "Vodoemi"
EXPRESSION '302'
COLOR 151 219 242
END
CLASS
NAME "Dorogi avtomobilnie"
EXPRESSION '328'
COLOR 168 112 0
END
CLASS
NAME "Dorogi avtomobilnie"
EXPRESSION '401'
COLOR 168 112 0
END
CLASS
NAME "Dorogi zheleznie"
EXPRESSION '402'
COLOR 0 0 0
END
CLASS
NAME "Elementi kommunikaciy"
EXPRESSION '403'
COLOR 109 227 150
END
CLASS
NAME "Ulici i dorozhki"
EXPRESSION '501'
COLOR 245 180 147
END
CLASS
NAME "Zelenie nasazhdeniya"
EXPRESSION '502'
COLOR 109 187 67
END
CLASS
NAME "Prochie stroyob'ekti"
EXPRESSION '503'
COLOR 106 187 235
END
CLASS
NAME "Zdaniya"
EXPRESSION '504'
COLOR 0 0 0
END
CLASS
NAME "Sooruzheniya"
EXPRESSION '505'
COLOR 110 130 245
END
CLASS
NAME "Narushennie zemli"
EXPRESSION '601'
COLOR 150 56 147
END
CLASS
NAME "Neispol'zuemie zemli"
EXPRESSION '602'
COLOR 94 145 142
END
CLASS
NAME "Ulucshaemie zemli"
EXPRESSION '701'
COLOR 237 225 85
END
CLASS
NAME "Razrabotki i stroitel'stvo"
EXPRESSION '702'
COLOR 106 86 130
END
CLASS
NAME "Svalki"
EXPRESSION '703'
COLOR 143 60 89
END
CLASS
NAME "Zahoroneniya"
EXPRESSION '704'
COLOR 0 0 0
END
CLASS
NAME "Prochie zemli"
EXPRESSION '705'
COLOR 255 190 232
END

END
END #map

и в html файле в строчке заменил

zis_lands = new OpenLayers.Layer.WMS("ЗИС", "http://niczem.zapto.org/cgi-bin/mapserv ... s_zis1.map&",
{layers: "land_br",
transparent: "true", format: "image/png"}
);

и все равно не отображает ЗИС слой http://niczem.zapto.org/geo/demo.html

[Djinn18]

в ошибке упоминается "LANDTYPE"
с это строчкой что-то не так CLASSITEM "LANDTYPE"?

[Denis Rykov]

Нет поля "LANDTYPE" в базе, именно так, большими буквами.

[Djinn18]

огромное спасибо, теперь показывается слой
буду впредь внимателен с регистром