mapserver with postgis problems
sami jan
sami.jan at GMAIL.COM
Sun Mar 4 06:35:13 PST 2007
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;
=========================================================
More information about the MapServer-users
mailing list