mapserver with postgis problems

[sami jan]

Hi

I have loaded up spatial point data in postgre/postgis and can see it
OK in uDig and QuantumGIS

However, the map file exported by QuantumGIS fails to render the
points in mapServer - can anyone please help? I am running the map
through the url:
http://localhost/cgi-bin/mapserv.exe?map=D:\gis_data\postgis_dot_hospitals.map

I am using the MS 4.2.2 binaries on WinXP

I COULD render the shape file generated by running pgsql2shp on this data

This is what I get in the error.log file:

=========================================================
msPOSTGISLayerOpen called datastatement: geom FROM public.hospitals\r
 MSPOSTGISLayerOpen -- shared connection not available.\r
 msConnPoolRegister(hospitals,host=localhost dbname=postgis
password=postgres user=postgres port=5445,01A07240)\r
 msPOSTGISLayerFreeItemInfo called\r
msProjectRect(): all points failed to reproject, trying to fall back
to using world bounds ... hope this helps.\r
 msPOSTGISLayerWhichShapes called\r
msPOSTGISLayerRetrievePK(): Found schema public, table hospitals.\r
 msPOSTGISLayerRetrievePGVersion(): query = select substring(version()
from 12 for (position('on' in version()) - 13))\r
 msPOSTGISLayerRetrievePGVersion: Version String: B 8.1.8.25\r
 msPOSTGISLayerRetrievePGVersion(): Found version 0, 8, 1\r
 msPOSTGISLayerRetrievePK(): Major version below 7.\r
msPOSTGISLayerParseData: unique column = OID, srid='',
geom_column_name = geom, table_name=public.hospitals\r
 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT
asbinary(force_collection(force_2d(geom)),'NDR'),OID::text from
public.hospitals WHERE geom && setSRID('BOX3D(-180 -90,180
90)'::BOX3D, find_srid('','public.hospitals','geom') )\r
 msPOSTGISLayerFreeItemInfo called\r
 msPOSTGISLayerClose datastatement: geom FROM public.hospitals\r
msPOSTGISLayerClose -- closing query_result\r
 msConnPoolRelease(hospitals,host=localhost dbname=postgis
password=postgres user=postgres  port=5445,01A07240)\r
 msConnPoolClose(host=localhost dbname=postgis password=postgres
user=postgres port=5445,01A07240)\r
 msDrawMap(): Layer 0 (hospitals), 0.141s\r
msPOSTGISLayerClose datastatement: geom FROM public.hospitals\r
 msPOSTGISLayerClose -- layerinfo is  NULL\r
=========================================================

Here is a snippet of the map file:
=========================================================

 EXTENT -121957.553383 4786073.718698 809738.927418 5377266.718698
  PROJECTION
    'proj=longlat'
    'ellps=WGS84'
    'datum=WGS84'
    'no_defs'
  END

LAYER
    NAME 'hospitals'
    TYPE POINT
    CONNECTIONTYPE postgis
    CONNECTION 'host=localhost dbname=postgis password=postgres
user=postgres port=5445'
    DATA 'geom FROM public.hospitals'
    DEBUG on
    METADATA
      'wms_title' 'hospitals'
    END
    STATUS DEFAULT
    TRANSPARENCY 100
    PROJECTION
    'proj=utm'
    'zone=15'
    'ellps=GRS80'
    'datum=NAD83'
    'units=m'
    'no_defs'
    END
    CLASS
       NAME hospitals
       STYLE
         SYMBOL 'CIRCLE'
         SIZE 6
         OUTLINECOLOR 0 0 0
         COLOR 144 50 207
       END
    END
  END
=========================================================

Here are a few lines of the PostGIS SQL required to create a couple of
points (this is public data):
=========================================================

BEGIN;

CREATE TABLE "public"."hospitals" (gid serial PRIMARY KEY,
"status" varchar(1),
"score" int2,
"side" varchar(1),
"arc_street" varchar(60),
"arc_zone" varchar(20),
"hfid_fac" int4,
"fac_name" varchar(39),
"fac_add" varchar(37),
"fac_city" varchar(26),
"fac_state" varchar(9),
"fac_zip" int4,
"county_cod" int8,
"county_nam" varchar(23),
"fac_teleph" varchar(13),
"fac_fax" varchar(12),
"fac_admini" varchar(38),
"lic_type" varchar(43),
"hosp_beds_" int8,
"bass_beds_" int8,
"psy_hosp_b" int8,
"nh_beds_su" int8,
"bch_beds_s" int8,
"slfa_beds_" int8,
"slfb_beds_" int8,
"other_beds" int8,
"hcp_type_p" varchar(42),
"hws_prov" varchar(20),
"ops_prov" varchar(17),
"hosp18_bed" int8,
"cah_prov" varchar(37),
"jcaho_prov" varchar(25),
"swing_prov" varchar(26),
"psy18_beds" int8,
"snf_beds_s" int8,
"snfnf_beds" int8,
"nf1_beds_s" int8,
"nf2_beds_s" int8,
"icfmr_beds" int8,
"hha_prov" varchar(35),
"hspice_pro" varchar(23),
"cmhc_prov" varchar(44),
"corf_prov" varchar(53),
"esrd_prov" varchar(38),
"asc_prov" varchar(40),
"ppsp_prov" varchar(36),
"ppsr_prov" varchar(38),
"rehab_prov" varchar(63),
"rhc_prov" varchar(32),
"xray_prov" varchar(29)) with oids;

SELECT AddGeometryColumn('public','hospitals','geom','26915','POINT',2);

INSERT INTO "public"."hospitals"
("status",'SRID=26915;01010000004648CCF0F8341B41855BD9F616A85341');

INSERT INTO "public"."hospitals"
("status",'SRID=26915;0101000000464D7F54C7851E41AC85378763255341');

INSERT INTO "public"."hospitals"
("status",'SRID=26915;0101000000A698B73489BC1C41A03DF84E4C165341');

INSERT INTO "public"."hospitals"
("status",'SRID=26915;0101000000DA190C95CA481D4106B76B3FE50D5341');

END;

=========================================================