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; =========================================================
