<div>I've never had any luck using the simple PostGIS DATA string: </div>
<div> </div>
<div>DATA "the_geom from mytable"</div>
<div> </div>
<div>To make any PostGIS layer work, I've always had to use strings similar to the following:</div>
<div> </div>
<div>DATA "the_geom from (SELECT * from mytable) as foo using unique gid using SRID=2163"<br> </div>
<div>Give that a shot!</div>
<div> </div>
<div>Cheers,<br>Ken Lord</div>
<div>Vancouver BC</div>
<div><br> </div>
<div><span class="gmail_quote">On 6/3/05, <b class="gmail_sendername">Robert Campbell</b> <<a href="mailto:rrc124@gmail.com">rrc124@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I updated my line record's SRID to a valid one in the spatial_ref_sys<br>table (I set it to 2163) and changed the STATUS to DEFAULT. I still
<br>get nothing. Is there anything else I can try? :-/<br><br>Thanks everyone..<br><br><br>On 6/3/05, Mark Cave-Ayland <<a href="mailto:m.cave-ayland@webbased.co.uk">m.cave-ayland@webbased.co.uk</a>> wrote:<br>>
<br>> > -----Original Message-----<br>> > From: UMN MapServer Users List<br>> > [mailto:<a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</a>] On Behalf Of Robert Campbell<br>> > Sent: 03 June 2005 05:55
<br>> > To: <a href="mailto:MAPSERVER-USERS@LISTS.UMN.EDU">MAPSERVER-USERS@LISTS.UMN.EDU</a><br>> > Subject: [UMN_MAPSERVER-USERS] MapServer & PostGIS won't work..<br>> ><br>> ><br>> > I just installed Postgres
8.0 and PostGIS 1.0.1 Win32<br>> > binaries. Both work; I have a nice demo table set up with<br>> > geometry columns, queries work okay through pgAdmin III, etc.<br>><br>> (cut)<br>><br>> > Thanks everyone! Oh, and I was able to log in with psql using
<br>> > the two above CONNECTION string details (postgres & localhost).<br>><br>><br>> Hi Robert,<br>><br>> Try setting STATUS to DEFAULT for the PostGIS layer (DEFAULT and ON have<br>> different meanings than you may expect...)
<br>><br>><br>> Kind regards,<br>><br>> Mark.<br>><br>> ------------------------<br>> WebBased Ltd<br>> South West Technology Centre<br>> Tamar Science Park<br>> Plymouth<br>> PL6 8BT<br>
><br>> T: +44 (0)1752 797131<br>> F: +44 (0)1752 791023<br>> W: <a href="http://www.webbased.co.uk">http://www.webbased.co.uk</a><br>><br>><br>><br><br></blockquote></div>